JOBS Azure SQL Database Administrator
Azure SQL Database Administrator
TYPE: CONTRACT–TO–HIRE
PAY TERMS: W2, C2C
LOCATION: REMOTE
ELIGIBILITY: USC, GC, EAD
We are seeking a skilled and experienced Azure SQL Database Administrator to join our team. The ideal candidate will be responsible for the deployment, maintenance, and performance optimization of Azure SQL databases. This role requires a deep understanding of cloud environments, database performance tuning, disaster recovery, high availability, and a proactive approach to managing data integrity and security. The Azure SQL DBA will work closely with application development, infrastructure, and security teams to ensure the highest database performance, resilience, and availability levels.
Primary Responsibilities:
- Install, configure, and manage Azure SQL Databases, ensuring high availability and performance.
- Monitor, optimize, and tune database performance, managing both resource utilization and database storage.
- Implement robust backup and disaster recovery solutions, ensuring data protection and availability.
- Develop and test database backup and recovery processes to safeguard data.
- Implement security best practices to safeguard sensitive data, including encryption, access control, and audit logs.
- Ensure compliance with industry standards and regulatory requirements, including GDPR, HIPAA, etc.
- Conduct regular database performance analysis and recommend improvements.
- Identify, diagnose, and resolve performance bottlenecks using tools such as SQL Profiler, Query Store, and Dynamic Management Views (DMVs).
- Configure and maintain high-availability features like Always On Availability Groups, geo-replication, and automated failover.
- Implement and monitor automated recovery procedures to reduce downtime.
- Use Azure tools (e.g., Azure Monitor, Azure SQL Analytics) for proactive monitoring and alerting.
- Optimize storage and resources to ensure scalability and cost efficiency.
- Work closely with development teams to support database design, SQL query optimization, and performance tuning.
- Assist with database migrations and provide database expertise to development and infrastructure teams.
- Automate database management tasks using PowerShell, T-SQL, or other scripting languages.
- Develop and maintain scripts for routine maintenance, reporting, and data synchronization.
Required Experience:
- Bachelor’s degree in Computer Science, Information Technology, or a related field. Equivalent work experience may be considered.
- 5+ years of experience as a SQL Database Administrator, with at least 2 years focused on Azure SQL Database management.
- Proficient in SQL Server administration, configuration, and maintenance in cloud environments (Azure SQL Database, Managed Instances, SQL Server on Azure VMs).
- Expertise in SQL Server Database Administration, SQL Server performance tuning, backup, and restore.
- Strong knowledge of Azure ecosystem, including Azure Monitor, Azure SQL Analytics, and Azure Active Directory integration.
- Proficiency in T-SQL, PowerShell, and scripting for automation.
- Familiarity with tools like SQL Profiler, Query Store, and Dynamic Management Views (DMVs) for performance troubleshooting.
- Understanding of high availability (HA) and disaster recovery (DR) solutions, such as Always On Availability Groups, geo-replication, and automated failover.
- Experience with additional Azure data services like Azure Data Factory, Azure Synapse Analytics, and Data Lake is a plus.
- Familiarity with DevOps practices, including CI/CD pipelines and infrastructure as code (IaC) using tools like Azure DevOps and ARM templates.
- Azure-related certifications (e.g., Microsoft Certified: Azure Database Administrator Associate, Microsoft Certified: Azure Solutions Architect) are highly preferred.
