Senior Sql Database Administrator

Senior SQL DBA (10+ Years Experience): Please apply only if your Notice period is below 30 days

Job Qualifications:

• 10+ Years of experience with Computer Science or equivalent degree Preferred
• Strong knowledge of database management, data warehouse management and decision support tools
• Extensive experience in the development, implementation and maintenance of data warehouses and data marts is desired
• Ability to use database access tools for application delivery
• Demonstrated ability to work independently and with others
• On-call and 24x7 Support

Job Responsibilities:

• Assesses future information requirements in order to develop long-range, comprehensive database plans
• Develops policies and procedures designed to ensure the integrity of the database environment
• Develops and maintains routines to facilitate database use
• Keeps informed on latest developments in the database management field
• Plans and coordinates migration to new data management system software levels
• Assures that appropriate database management software is available and effectively used
• Understands benchmarking processes and techniques
• Determines, implements, and enhances standards on database security
• Promotes and recommends appropriate database software for new application systems
• Educates applications programmers about database concepts and efficient access techniques, and assists them in analysis and problem resolutions pertaining to database
• Performs database performance monitoring and implements efficiency improvements
• Designs or supervises the designing of the procedures necessary to save and recover databases from hardware and software failures
• Supervises the design and maintenance of database structures
• Performs related work as assigned

Technical Knowledge:

• Install, configure, upgrade, and maintain Microsoft SQL Server (2012/2016/2019/2022).
• Manage and support hybrid database environments across on-premises data centers and cloud platforms (Azure / AWS).
• Manage production, staging, and development environments.
• Perform regular database maintenance activities including index rebuilds, statistics updates, and integrity checks.
• Monitor database systems to ensure high performance, availability, and security.
• Manage database objects such as tables, indexes, views, stored procedures, and triggers.
• Design, implement, and manage:
• AlwaysOn Availability Groups (AG)
• SQL Server Failover Cluster Instances (FCI)
• Log Shipping and Replication
• Perform failover, failback, and DR drills to validate business continuity.
• Ensure minimal downtime and data loss through optimized HA/DR strategies.
• Troubleshoot issues related to cluster, quorum, and availability replicas.
• Analyze and optimize slow-running queries, stored procedures, and execution plans.
• Implement indexing strategies and optimize locking, blocking, and deadlocks.
• Tune server-level settings (memory, CPU, tempdb configuration).
• Diagnose and resolve database performance issues, outages, and failures.
• Perform root cause analysis (RCA) for incidents.
• Address issues such as: Blocking / deadlocks, High CPU, memory pressure, Disk I/O bottlenecks
• Design and implement robust backup and recovery strategies.
• Perform point-in-time recovery and restore operations.
• Ensure backup validation and compliance with RPO/RTO requirements.
• Manage database security: Logins, roles, permissions, Encryption (TDE - Transparent Data Encryption)
• Implement auditing and compliance requirements.
• Apply security patches and updates regularly.
• Work closely with developers to:
• Optimize SQL queries and database schema design
• Review code for performance and scalability
• Support deployments and release activities
• Provide guidance on Best practices for SQL coding, Indexing and performance optimization
• Assist in performance testing and capacity planning.
• Develop scripts using PowerShell, Python, or SQL for automation and monitoring.
• Automate routine DBA tasks such as backups, health checks, and alerting.
• Experience with tools like OEM (Oracle Enterprise Manager) or similar monitoring tools.
• Work within SLA timelines in a 24x7 support environment.