SQL Database Administrator

As a Database Administrator, your primary responsibility will be to design, install, configure, upgrade, and maintain databases to ensure their smooth operation. Your role will involve optimizing database performance, managing security, performing regular backups, and implementing high availability solutions. You will oversee SQL Server databases across multiple environments, ensuring scalability, reliability, and efficiency. Managing database replication, clustering, Always On availability groups, and other HA/DR strategies will be a crucial part of your responsibilities. Your expertise will be essential in administering SQL Server instances hosted on Azure, optimizing cloud database performance, and ensuring seamless migrations from on-premises environments. You will be responsible for developing and optimizing complex T-SQL queries, troubleshooting performance issues, and designing efficient database schemas. Automation is a key aspect of this role, requiring you to implement scripts and processes to streamline database maintenance, backups, and health checks using PowerShell and SQL Server Agent Jobs. You will also be responsible for implementing Change Data Capture (CDC), job monitoring, and alerts to ensure database health. Collaboration with development teams and stakeholders will be essential to align database architecture with business goals. You will provide on-call support for production issues and contribute to documentation and process improvement initiatives.