Hybrid Details: Dallas, TX - Hybrid Onsite/Remote

Duration: 6 months to start

Job Description
The Department of Information Resources – Enterprise Databases division is seeking a Senior Database System Engineer to join our team. This critical role requires deep expertise in cloud platforms and modern database management systems. The ideal candidate will demonstrate a strong track record in cloud-based solutions, database performance tuning, security, and automation.

Cloud Platform Expertise

• Microsoft Azure (Required):  Advanced proficiency in Azure SQL Database, SQL Managed Instances, Azure Databricks, Cosmos DB, Power BI, Fabric, and related services.
• Amazon Web Services (AWS) (Optional):  Familiarity with database services such as Amazon Aurora (SQL Server, MySQL, PostgreSQL), Oracle, and Amazon EMR.
• Google Cloud Platform (GCP) (Optional):  Basic knowledge of Cloud SQL, Cloud Spanner, Bigtable, and BigQuery.

• Configure and manage databases on Azure, including SQL Databases, Managed Instances, Cosmos DB, and Azure Database for MySQL/PostgreSQL.
• Lead migration of on-premises databases to Azure, ensuring minimal downtime and enhanced performance through cloud-native features.
• Monitor and optimize performance using Azure SQL Analytics, SSMS, and Query Performance Insights.
• Implement automated backup strategies and disaster recovery plans to ensure data integrity and high availability.
• Enforce security policies including encryption, access control, authentication, and authorization.
• Apply updates, patches, and hotfixes to both on-premises and cloud-hosted databases.
• Design and support high availability solutions such as Always-On Availability Groups, geo-replication, and failover clusters.
• Analyze database usage and scale infrastructure to meet growing performance demands.
• Automate recurring tasks with Azure Automation, PowerShell, and other scripting tools.
• Troubleshoot and resolve database issues related to performance, downtime, or security.
• Continuously monitor database health and performance using Azure Monitor, Log Analytics, SolarWinds, and similar tools.

• Minimum 10 years of on-premises SQL Server database administration experience in large enterprise environments.
• Minimum 5 years of hands-on experience with SQL Server in an Azure environment (Azure SQL, Managed Instances, or SQL VMs).
• Proven expertise with Always-On Availability Groups, failover clustering, and DR/HA strategies.
• Experience in securing databases and ensuring compliance with industry standards (HIPAA, SOC, PCI, PII).
• Strong skills in performance tuning, query optimization, and index management.

• Bachelor’s degree in Computer Science or a related field.