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

Key Skills

Education

Any Graduate