We are seeking a highly skilled and experienced SQL Server Database Administrator (DBA) to join our dynamic IT team. The ideal candidate will have a strong background in SQL Server migration and upgrades, database performance tuning, and the configuration of high availability and disaster recovery (HA/DR) strategies. This role is critical to the ongoing stability, performance, and security of our data infrastructure.
Key Responsibilities
SQL Server Upgradation & Migration
- Lead the planning and execution of SQL Server version upgrades and migrations across environments, ensuring minimal downtime and data integrity.
- Analyze and assess existing database systems and recommend upgrade strategies in line with business needs and best practices.
- Collaborate with stakeholders to ensure successful transitions with appropriate pre- and post-migration validation.
SQL Server Maintenance & Job Scheduling
- Create and manage database maintenance plans, including indexing, integrity checks, and statistics updates to maintain performance.
- Develop, schedule, and monitor SQL Server Agent jobs for automated tasks such as backups, reports, data imports/exports, and alerting.
- Troubleshoot job failures and implement corrective measures to ensure continuous database operations.
SQL Server Replication
- Configure and maintain SQL Server replication solutions (Snapshot, Merge, and Transactional Replication) to ensure high availability and data consistency across systems.
- Monitor replication health and resolve latency or synchronization issues proactively.
SQL Server Feature Management (SSIS, SSAS, SSRS)
- Implement and manage SQL Server Integration Services (SSIS) packages for ETL processes and data transformation workflows.
- Maintain and deploy SQL Server Analysis Services (SSAS) cubes to support BI and analytical requirements.
- Design, deploy, and manage SQL Server Reporting Services (SSRS) reports for business units, ensuring data is accurately represented.
Performance Tuning and Optimization
- Conduct in-depth performance analysis, identifying bottlenecks in queries, indexes, and configurations.
- Optimize T-SQL queries, indexing strategies, and server parameters to improve overall system performance.
- Use tools like SQL Profiler, Extended Events, Query Store, and DMVs to monitor and fine-tune workloads.
High Availability & Disaster Recovery (HA/DR)
- Design and implement HA/DR strategies such as AlwaysOn Availability Groups, Database Mirroring, Log Shipping, and Clustering.
- Conduct regular DR drills, ensuring full preparedness for system outages or failures.
- Ensure data redundancy and business continuity through proper configuration and documentation.
Backup and Recovery
- Develop robust backup policies and strategies aligned with RTO and RPO requirements.
- Perform regular backups (Full, Differential, Transaction Log) and ensure backup integrity.
- Conduct database restorations for testing or in response to incidents, ensuring minimal data loss.
Security, User Management & Compliance
- Manage users, roles, and permissions to ensure proper access control and compliance with security policies.
- Regularly audit permissions and log access to identify potential vulnerabilities or violations.
- Work with InfoSec teams to implement data security best practices and policies.
Patch Management & Configuration
- Plan and execute SQL Server and Windows service pack upgrades and cumulative updates.
- Ensure all database servers are running on secure, stable, and supported versions.
- Document configuration changes and validate performance after patch deployment.
Qualifications and Experience
- Bachelor's degree in Computer Science, Information Technology, or a related field.
- Minimum of 5–8 years of experience in SQL Server Database Administration in a production environment.
- Proven expertise in SQL Server versions 2012, 2016, 2019, and above.
- Strong understanding of database architecture, data modeling, and query optimization.
- Hands-on experience with SSIS, SSAS, SSRS.
- Experience in managing large-scale enterprise databases and high transaction environments.
- Excellent troubleshooting and analytical skills.
- Knowledge of PowerShell scripting is a plus.
Soft Skills
- Strong verbal and written communication skills.
- Ability to work independently and collaboratively across teams.
- Proactive mindset with attention to detail and a commitment to delivering high-quality results.
- Strong documentation and organizational skills.
This is a fantastic opportunity for a motivated and detail-oriented individual who is passionate about databases and performance. If you enjoy working in a fast-paced environment with complex challenges and have a drive for continuous improvement, we'd love to hear from you.