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.

Senior Sql Database Administrator

Senior Database Administrator (MS SQL & AWS RDS) (Remote)