Job Overview
We are seeking a highly experienced Senior Database Administrator (DBA) with at least 10+ years of extensive experience as an SQL Server Administrator.
The ideal candidate will have deep expertise in MS-SQL DBA advanced database administration and high-availability solutions.
This role is critical for ensuring our mission-critical databases' optimal performance, reliability, and security.
Responsibilities
* Create new Microsoft SQL Server instances, configure and maintain database servers and processes, and download and install SQL Server service packs and updates.
* Expert MS-SQL DB administrator, configured and maintained SQL Security controls, proactively monitored SQL Server maintenance tasks, troubleshoot failed processes.
* Manage database backup and recovery and disaster recovery planning.
* Configure and manage high-availability solutions such as AlwaysOn availability groups and failover clustering; well-versed with replication methodology, HA configuration, and failover in MS-SQL Database.
* Develop and enforce comprehensive security policies for database access, encryption, and auditing; perform security patches and upgrades.
* Provide expert-level troubleshooting and support for complex database issues, including performance bottlenecks, corruption issues, and critical failures.
* Analyze current and future database capacity requirements and plan for scalability to accommodate growth and evolving business needs.
* Create and maintain detailed documentation of database architectures, configurations, and processes. Provide regular reports on database performance and status.
* Work closely with application developers, infrastructure teams, and other IT stakeholders to support and enhance database-driven applications and services.
* Strong end-to-end automation skills, excellent knowledge of Python scripting, Terraform, etc.
Qualifications
* Bachelor's degree in Computer Science, Information Technology, or a related field.
* Availability to work in the office twice a week.
* Advanced degrees or relevant certifications are highly desirable.
Experience & Technical Skills:
* Minimum of 10+ years of strong experience as a SQL Server Administrator.
* 5+ years of proven track record in backup, recovery, and applying security patches.
* 4+ years of proficiency in managing and configuring high availability and DR configurations.
* Must have 5+ years of proficiency in Python scripting and end-to-end automation.
* 2+ years of strong familiarity with Azure Arc and other monitoring and management tools like Service Now.
* 5+ years of strong familiarity with experience with cloud services (AWS, Microsoft Azure) with working knowledge on Terraform.
* Good to have Oracle DBA knowledge and troubleshooting skills.
Soft Skills:
* Exceptional analytical and problem-solving abilities.
* Good communication and interpersonal skills, with the ability to work collaboratively with diverse teams.
* Detail-oriented and committed to delivering high-quality results under pressure.