Database Administrator (SQL Server & Azure)
Database Administrator (SQL Server & Azure) Job Summary We are seeking a skilled and detail-oriented Database Administrator (DBA) to manage, maintain, and optimize our SQL Server and Azure-based database environments. The ideal candidate will have strong expertise in SQL Server administration, Azure SQL technologies, performance tuning, database security, and automation using PowerShell and Azure CLI. This role requires a proactive individual who can ensure high availability, performance, and security of enterprise data systems.
Key Responsibilities
Database Administration & Operations
- Install, configure, and maintain Microsoft SQL Server instances across on-premises and Azure environments.
- Manage Azure SQL Databases, Managed Instances, and SQL Servers.
- Perform database upgrades, patching, migrations, and deployments.
- Monitor database health, availability, and capacity planning.
Performance Tuning & Optimization
- Analyze and troubleshoot SQL performance issues, including query optimization and index tuning.
- Monitor execution plans, waits, and resource utilization to improve performance.
- Implement best practices for database design and performance.
Security & Compliance
- Implement and maintain SQL Server and Azure SQL security (authentication, authorization, encryption, auditing).
- Manage roles, permissions, and data access controls.
- Ensure compliance with organizational and regulatory data security standards.
Backup, Recovery & High Availability
- Design and implement backup and recovery strategies.
- Configure and manage high availability solutions such as Always On Availability Groups, failover clustering, and geo-replication in Azure.
- Perform disaster recovery testing and ensure data integrity.
Automation & Scripting
- Develop and maintain automation scripts using PowerShell and Azure CLI.
- Automate routine tasks such as provisioning, monitoring, backups, and deployments.
Azure Cloud Management
- Manage and optimize resources in Azure Cloud environment.
- Implement cost optimization strategies for Azure SQL workloads.
- Use Azure monitoring tools (Azure Monitor, Log Analytics) for proactive maintenance.
Troubleshooting & Support
- Diagnose and resolve database-related issues in a timely manner.
- Provide support for development teams on database-related activities.
- Maintain documentation for database configurations and processes.
Required Skills & Qualifications
- Strong hands-on experience with SQL Server Administration (2016/2019/2022 or later).
- Experience with Azure SQL (Azure SQL DB, Managed Instance, Azure VMs).
- Expertise in SQL performance tuning and query optimization.
- In-depth knowledge of SQL Server security and Azure security best practices.
- Proficiency in PowerShell scripting and Azure CLI.
- Solid understanding of Azure Cloud fundamentals and services.
- Experience with backup, recovery, and high availability solutions.
- Strong troubleshooting and analytical skills.
Preferred Qualifications
- Microsoft certifications (e.g., Azure Database Administrator Associate, Azure Fundamentals).
- Experience with DevOps practices and CI/CD pipelines.
- Knowledge of Infrastructure as Code (ARM templates, Bicep, Terraform).
- Familiarity with monitoring tools and performance dashboards.
Soft Skills
- Strong problem-solving and critical thinking abilities.
- Excellent communication and collaboration skills.
- Ability to work independently and manage multiple priorities.
Education
- Bachelor s degree in Computer Science, Information Technology, or related field (or equivalent experience).