We are looking for an experienced SQL Server DBA to manage and maintain our SQL Server databases, ensuring their availability, security, and performance.
The candidate will be responsible for database installation, configuration, upgrades, backups, performance tuning, and troubleshooting in a high-availability environment.
Key Responsibilities:
- Install, configure, and maintain Microsoft SQL Server databases (versions 2012 and above).
- Monitor database performance, identify bottlenecks, and implement tuning solutions.
- Perform regular backups, restore procedures, and disaster recovery planning.
- Manage database security, including user access control and permissions.
- Automate routine database maintenance tasks using scripts and tools.
- Support database development activities by providing guidance on SQL query optimization and schema design.
- Troubleshoot and resolve database-related issues in production and non-production environments.
- Plan and execute database upgrades, patches, and migrations.
- Maintain high availability and disaster recovery solutions, such as Always On Availability Groups, Replication, and Log Shipping.
- Collaborate with application teams to optimize database access and improve application performance.
- Maintain detailed documentation of database configurations, policies, and procedures.
- Ensure compliance with data governance, security policies, and regulatory standards.
Required Skills & Qualifications:
- 4 to 6 years of hands-on experience as a SQL Server DBA.
- Strong knowledge of SQL Server architecture, backup and recovery techniques, and performance tuning.
- Experience with T-SQL, stored procedures, triggers, and query optimization.
- Familiarity with high availability and disaster recovery (HA/DR) solutions.
- Proficiency in monitoring tools such as SQL Server Profiler, Database Tuning Advisor, and third-party tools.
- Knowledge of Windows Server environment and PowerShell scripting.
- Understanding of database security best practices.
- Experience working in Agile or DevOps environments is a plus.
- Good communication skills and ability to work with cross-functional teams.
Preferred Skills (Good to Have):
- Experience with Azure SQL Database or other cloud-based SQL services.
- Familiarity with SSIS, SSRS, and SSAS.
- Knowledge of automation tools like Ansible or Terraform for infrastructure management.
- Certifications such as Microsoft Certified: Azure Database Administrator Associate or MCSA: SQL Server.
Skills Required
Aws, Azure, Gcp, Python, Powershell, Automation