We are seeking a highly skilled Senior SQL Database Administrator to join our team and take charge of building, maintaining, and securing our database systems. In this role, you'll be instrumental in ensuring the smooth operation of our databases, resolving issues swiftly, and playing a key role in our ongoing transition to cloud-native services.
**Key Responsibilities:**
**Database Administration:**
- Install, configure, upgrade, and maintain SQL Servers, databases, and related components.
- Implement and manage database security, including user permissions, roles, and access controls.
- Perform regular database backups and restores to maintain data integrity and ensure availability.
- Monitor database performance, optimize queries, and tune servers for peak efficiency.
- Implement high availability and disaster recovery solutions, such as clustering, mirroring, and log shipping.
- Automate routine tasks, including backups and index maintenance, using scripts and SQL Server Agent jobs.
- Collaborate with data and application teams to develop roadmaps for migrating on-premise SQL Server solutions to cloud-native services.
- Develop and enforce database server version control policies.
**Database Development:**
- Work closely with application developers to design and implement new databases or modify existing ones.
- Apply data modeling techniques and database normalization to ensure optimal performance.
- Review and implement DDL scripts from application development teams, ensuring performance and data integrity.
- Assist developers with complex queries, query tuning, and schema refinements.
**Support and Maintenance:**
- Implement and maintain monitoring solutions for critical databases and database processes.
- Troubleshoot and resolve database issues promptly to minimize downtime.
- Apply third-party application database update scripts, patches, and security best practices.
- Maintain comprehensive documentation for database objects, processes, and procedures.
- Provide training and knowledge transfer to team members to ensure best practices are followed.
- Proactively monitor SQL Server maintenance tasks, troubleshoot issues, and implement backup and recovery methods that meet business Recovery Point Objectives (RPO).
**Education and Experience:**
- Bachelor's degree in Computer Science or a related field.
- A minimum of 5 years of experience as an enterprise SQL Server DBA.
- Strong preference for candidates with Azure DBA certifications (e.g., Azure Database Administrator Associate).
- At least 2 years of experience supporting Windows failover cluster-based Always-on HA architecture in production.
- A minimum of 5 years of experience developing and supporting reports and packages with SSRS and SSIS.
- At least 1 year of experience migrating SQL Server HA architecture to serverless Azure native SQL database services.
- Experience supporting highly available enterprise-scale Azure environments is highly desirable.
**Why Join Us?**
As a Senior SQL Database Administrator, you'll be joining a dynamic team focused on innovation and excellence. Your expertise will directly contribute to the security, performance, and modernization of our database infrastructure. If you're passionate about SQL Server and eager to be at the forefront of cloud migration, we want to hear from you!