MSSQL DBA Full Time

Primary Skill (Technical Skill) MS SQL DBA

Secondary Skill (Technical Skill) Oracle DB, Open Source DB, Azure SQL & AWS RDS Services

Educational Qualifications B.E. / B.Sc. / Diploma

Experience Level 8 – 12 Years

Role & Responsibilities

• Handled large database estates and managed TB size of databases
• Install, configure and administer the SQL Server enterprise of 2022, 2019, 2017,2014, 2012, 2008 R2 on Windows server

Plan and execute upgrades, migrations, and patching with minimal downtime

• Manage large-scale (TB+) database estates with high availability requirements
• Define and enforce configuration, capacity, and lifecycle standards.
• Perform deep performance analysis using wait stats, Query Store, execution plans
• Diagnose memory, IO, TempDB, and concurrency issues
• Install and configure database monitoring tools
• Database refresh (Prod to Dev, QA)
• Database auditing and compliance
• Plan the instance upgrade, migration and patching
• Define backup and restore strategy
• Proactively analysis the performance and tuning recommendation.
• Database Environment Technical Assessment & Gap Analysis, remediation.
• Database In place , side by side upgrade , Cross DB & Cloud Migrations planning, Implementation & post migration troubleshooting
• Implement and troubleshoot DTS packages
• SSIS & SSRS configuration & advance troubleshooting.
• Experience in application DBA support and deployment activities
• Design, setup and configure load balancing on clusters
• Develop database re-usable components
• Database disaster recovery (DR) strategy like AOAG/mirroring / log shipping / replication configuration & troubleshooting
• Develop data purging, archival management methods and best practices
• OS level activities related to database tasks and windows administration
• Coordinate and work with vendors for bug fixes and major incident resolution
• Primarily role is supporting the production and non-prod database environments
• Provide 24×7 and on call support for critical application databases
• Cloud:-
• L1/L2 in Cloud SQL administration.
• Expert in MS SQL Database administration.
• Expert in Database Replication on Cloud to On-Prem or Cloud to Cloud
• Expert in SQL DB IaaS , PaaS troubleshooting and performance tuning.
• Experience in Microsoft SQL Server database backup, recovery & restore.
• Experience in SSMS, Query Store, and SQL Sentry would be a plus.
• Role & Responsibilities 5+ years of experience in MS SQL and 2+ in MS Cloud SQL Design, Architect and Build a cloud-based multi-tenant platform hosted on Azure.
• Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability and security. Ability to identify and troubleshoot SQL Server issues related to CPU, memory, I/O, disk space

Skills Must have Nice to Have

Technical Skills (Core & Top-Up)

• Strong installation and database administration experience on SQL 2016 , SQL 2017 , SQL 2019 , SQL 2022 & SQL 2025.
• Strong experience on log shipping, mirroring and replication, AOAG.
• Design and implement cluster high availability solution (Active-Active/Active-Passive) , Always on Availability Groups
• Configure, implement and troubleshoot DTS, SSIS and SSRS packages
• performance tuning and troubleshooting experience
• Experience windows administration on database activities
• Oracle/MySQL/PostgreSQL & Cloud Azure SQL / AWS RDS operational experience
• Technical Assessment and gap Analysis , Mitigation for Database Environment
• PRE at scale
• Define Automated incident response
• Understanding of ERP & Enterprise Apps (EBS, SAP, Microsoft etc)
• SIPs, Cost & Effort Optimization Initiative driven mindset

Programming Skills:

• Power shell/Python /DB scripting and automate routine tasks
• Python, CI/CD pipelines
• Complex Ansible/Cloud orchestration
• IaC
• Multi-cloud automation
• Advance AIOps Platforms integration
• Cloud Skills

AI-Enhanced:

• Building AI-driven automation pipelines
• Integrating AI for query optimization, incident analysis, troubleshooting, and predictive maintenance
• Using AI for proactive scaling & self-healing systems
• Designing resilient systems with AI insights
• Microsoft Certified Solutions Associate (MCSA)
• Cloud Certification
• Enterprise-level Terraform
• Advanced Ansible frameworks
• Hybrid cloud orchestration
• AI-driven anomaly resolution, predictive analytics at scale
• Advance PRE Lifecycle
• Containerized Platforms
• OpenShift/Nutanix
• ERP & Enterprise Applications (EBS, SAP, Microsoft etc)
• CSP Architect (AWS/Azure/GCP/OCI)
• DBA Architect (MSSQL/Oracle/PostgreSQL/MySQL)
• Containers Professional (KCNA/CKA/CKAD)
• OS Professional (RHEL/Windows)
• AI – Level 3 (Oracle AI / OCI AI / Azure AI / AWS AI)

Process & Tools

• Service Request and Incident, Problem, Change managements
• Configuration, Capacity planning and Knowledge management
• Experience on ITIL Tools like Service now Remedy, Peregrine
• Identify and implement the service improvement plan
• Continuous Improvement Drives
• Database Environment Assessment, Risk Analysis & remediation, recommendations
• ITIL Foundation certified

Behavioral Skill

• Strong verbal and written communication skills
• Team management and motivation
• Flexibility, good attitude
• Manage the global infrastructure customer and projects