As a Senior Database Administrator, you will be part of the Global Data Services team with accountability for designing, testing, implementing and maintaining the organization s databases across multiple platforms, technologies (e.g., relational, non-relational and warehousing) and computing environments (e.g., host based, distributed systems, client server). The role requires the ability to apply comprehensive functional and technical knowledge in a team setting for problem resolution, design and engineering decisions and system architecture planning.
Responsibilities
- Conduct database administrative work to support for production systems
- Responsible for Installing, configuring, patching, maintaining SQL Server (2014,2016, 2019)
- Plan and action migration and upgradation of SQL server
- Responsible for planning, configuring, and maintaining HA (high availability) and DR (disaster recovery) solutions: Backup/Restore, AG (availability groups), Mirroring, Replication, Log-shipping
- Test HA and DR strategy to ensure that business Recovery Point Objective (RPO) and Recovery Time Objectives (RTO); ensure that the backups are verified and tested.
- Maintain baselines for performance benchmarks & examine SQL Server wait statistics.
- Tuning the server and database settings for optimum performance (identifying missing Indexes, unnecessary indexes, resource intensive queries, providing query tuning recommendations; handling index fragmentation, statistics updates)
- Monitoring SQL Server, SQL Server logs, SQL Server Agent logs, Windows logs and troubleshooting to ensure optimum performance
- Provide support for Development, QA teams and systems
- Design, architect, plan database solutions to meet the business need
- Design and implement disaster recovery solutions for critical systems
- Installing, configuring, and troubleshooting SQL Server Reporting Services (SSRS).
Knowledge and Experience
- Bachelor s Degree in Computer Science, Information Technology or related field
- 8+ years of experience in the design, maintenance and administration of relational databases
- Strong understanding of relational database principles, guidelines, and best practices
- Hands-on with configuring Backup/Restore), AG (availability groups), Mirroring, Replication, Log-shipping.
- Hands-on experience in Upgrading/Migrating the SQL Servers Instances/Databases
- Experience of backup/restore, and other HA/DR strategies to meet RPO/RTO
- Experience working with Windows server, including Active Directory
- Experience in managing logins and users using server/database roles and troubleshooting issues around it
- Experienced in daily database maintenance tasks
- Experience of patching, standalone and clustered instances, and pre and post patching activities
- Capacity planning and estimation experience
- Good understanding of server and storage hardware; and virtualization
- Experience in basic troubleshooting, incident resolution, performance tuning
- Hands-on with Performance tuning
- Reviewing the SQL scripts developed by development team
- Performing Health Checks using Automated scripts and tools
- Worked on security management (Adding & Disabling the SQL Server Logins)
- Well versed with Incident Management and Change Management (ITIL)
- Proactively monitor SQL Server workload and identify areas of improvement.
- Microsoft certification would be an added advantage
- Able to produce documentation to a high standard
- Knowledge of project/task management tools such as Jira is desirable.