Job Purpose
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.
