Description
Job Summary:
We are seeking a highly experienced MSSQL DBA to manage, optimize, and support enterprise-level SQL Server environments. The primary focus of this role is Microsoft SQL Server Administration (70%), with additional responsibilities in Oracle (20%) and PostgreSQL (10%) environments. The ideal candidate will have strong expertise in performance tuning, high availability, disaster recovery, automation, and multi-database platform support.
Key Responsibilities:
MS SQL Server Administration (Primary – 70%):
Installation & Configuration:
- Install, configure, and upgrade SQL Server (2016/2019/2022)
- Deploy SQL Server on Windows and Linux platforms
- Configure Azure SQL Database, Managed Instance, and SQL VMs
- Set up development, QA, and production environments
- Implement Always On Availability Groups and Failover Cluster Instances
- Configure database mirroring and log shipping
Performance & Optimization:
- Monitor and tune performance using DMVs, Extended Events, and Query Store
- Analyze and optimize execution plans
- Implement indexing strategies (clustered, non-clustered, columnstore)
- Perform statistics updates and index maintenance
- Configure Resource Governor
- Optimize tempdb configuration
- Conduct capacity planning and baseline analysis
Backup & Recovery:
- Design and implement full, differential, and transaction log backups
- Perform restores and point-in-time recovery
- Test and document DR procedures (RTO/RPO compliance)
- Implement backup compression, encryption, and retention policies
- Automate backup verification processes
High Availability & Disaster Recovery:
- Configure and maintain Always On Availability Groups
- Manage Failover Cluster Instances (FCI)
- Implement log shipping and mirroring
- Design multi-datacenter DR strategies
- Perform failover testing and monitor synchronization health
Automation & Scripting:
- Develop T-SQL automation scripts
- Manage SQL Server Agent jobs
- Implement PowerShell automation
- Automate deployments and database refresh processes
- Build monitoring and alerting frameworks
SSIS, SSRS, SSAS Administration:
- Deploy and manage SSIS packages
- Configure and maintain SSRS environments
- Support SSAS tabular and multidimensional models
- Troubleshoot ETL processes and optimize performance
Oracle Database Administration (Secondary – 20%):
- Manage Oracle 11g/12c/19c instances
- Perform user, tablespace, and backup management
- Monitor performance and apply patches/upgrades
- Support Oracle-related application issues
- Assist with Oracle to SQL Server migrations
PostgreSQL Administration (Secondary – 10%):
- Deploy and maintain PostgreSQL (v12+)
- Configure replication and high availability
- Perform backup and recovery (pg_dump, pg_basebackup)
- Monitor and tune PostgreSQL performance
- Manage roles, authentication, and security
- Assist in PostgreSQL to SQL Server migrations
General Responsibilities:
- Develop database standards and best practices
- Provide 24/7 on-call production support
- Conduct root cause analysis and incident resolution
- Collaborate with development and infrastructure teams
- Plan and execute database migrations and consolidations
- Mentor junior DBAs and provide technical guidance
- Participate in change management and release processes
Required Skills & Experience:
- 10+ years of MSSQL DBA experience
- Strong expertise in SQL Server 2016/2019/2022
- Hands-on experience with Always On, Clustering, Log Shipping
- Advanced performance tuning and troubleshooting skills
- Experience with Azure SQL platforms
- Strong T-SQL and PowerShell scripting skills
- Experience with SSIS, SSRS, SSAS
- Working knowledge of Oracle and PostgreSQL administration
- Strong documentation and communication skills
Competencies:
- MSSQL DBA
- High Availability & Disaster Recovery
- Performance Tuning & Optimization
- Multi-Database Platform Administration
- Enterprise Database Security
Desirable Skills:
- MySQL exposure
- Oracle E-Business Suite – Application DBA knowledge
- Cloud database migration experience
- Automation and DevOps integration experience