Database Administrator - SQL Server

SQL Server Database Administrator (DBA)

Key Responsibilities

Database Administration

• Install, configure, and maintain SQL Server instances (on-premises and/or cloud-based)
• Perform database backups, restores, and recovery operations
• Manage and enforce SQL Server security including authentication, roles, and permissions
• Implement and manage high availability (HA) and disaster recovery (DR) solutions

Performance Tuning & Monitoring

• Monitor database performance and troubleshoot bottlenecks and outages
• Optimize T-SQL queries and indexes for better performance
• Use tools such as SQL Profiler, Extended Events, and third-party solutions like Redgate or SolarWinds

Automation & Maintenance

• Automate routine DBA tasks using T-SQL, PowerShell, or other scripting tools
• Perform capacity planning, storage management, and patching
• Collaborate with development and support teams for performance improvements and project deployments

Documentation & Collaboration

• Maintain comprehensive technical documentation and standard operating procedures
• Support database deployments and CI/CD pipelines where applicable
• Coordinate with cloud platform teams for database hosting (Azure, AWS, or GCP)

Required Skills and Qualifications

• Proven experience as a SQL Server DBA (SQL Server 2012/2016/2019/2022)
• Proficiency in T-SQL and SQL Server Management Studio (SSMS)
• Experience with performance tuning, query optimization, and indexing
• Strong knowledge of backup and recovery strategies
• Experience with HA/DR solutions like AlwaysOn, Log Shipping, and Clustering
• Familiarity with monitoring tools (SQL Profiler, Extended Events, Redgate, SolarWinds)
• Strong analytical, troubleshooting, and problem-solving abilities
• Excellent communication and documentation skills

Preferred Qualifications

• Microsoft Certified: Azure Database Administrator Associate or equivalent
• Experience with cloud database platforms such as Azure SQL Database, AWS RDS, or SQL Managed Instance
• Exposure to SSIS, SSRS, and SSAS
• Knowledge of DevOps, CI/CD for database deployment
• Familiarity with cloud-native tools and database-as-a-service models