SQL Database Administrator

JOB TITLE:

Database Administrator L2 (Indore India)

JOB PURPOSE:

The Database Administrator (L2) supports day-to-day operations and maintenance of Microsoft SQL Server environments across hybrid infrastructures. This role involves performing health checks managing backups and restores optimizing performance applying patches and coordinating with internal teams. It contributes to database stability compliance and effective service delivery under senior guidance.

QUALIFICATION:

Engineering Degree (Computers / Electronics)

CERTIFICATIONS:

• Microsoft Certified: Azure Database Administrator Associate or equivalent
• ITIL Foundation
• CompTIA Server
• AI-related training or certification will be considered an added advantage

RESPONSIBILITIES (INCLUDES ALL TASKS):

Key Responsibilities

Database Maintenance & Support

• Perform routine health checks on SQL Server instances
• Monitor database performance and optimize queries/indexes
• Manage backup and restore operations using native tools or third-party solutions
• Apply patches and service packs as per schedule
• Assist in incident resolution and escalate complex issues to L3
• Maintain database documentation and change logs

Virtualization & Cloud Assistance

• Operate under guidance in hybrid environments (on-prem & Azure SQL)
• Support migration activities from on-prem to cloud databases
• Monitor resource utilization and storage thresholds

Security & Compliance

• Enforce database security policies and access controls
• Assist with vulnerability scan follow-ups and patch compliance
• Contribute to ISO/SOC audit preparations by maintaining DB records

Asset & Documentation Management

• Update CMDB entries for database assets
• Maintain SOPs runbooks and checklists
• Coordinate with procurement teams for licensing and lifecycle status

Tools & Automation

• Good understanding of monitoring tools like SolarWinds Manage Engine (DB modules)
• Utilize basic automation scripts (PowerShell T-SQL) for repetitive tasks
• Support development of performance and compliance reports

Collaboration & Escalation

• Work alongside L1 engineers and escalate unresolved DB issues to L3 or vendor support
• Coordinate with application infra and network teams on scheduled tasks
• Contribute to onboarding processes and database readiness checklists
• Understanding and experience in managing disaster recovery operations and procedures

TECHNICAL SKILLS / COMPETENCIES:

MANDATORY

Certainly Praveen. Heres a structured table for the Mandatory Technical Skillsets section of the Database Administrator L2 (Microsoft SQL) JD:

Mandatory Technical Skillsets

Category

Details

Platform Exposure

Microsoft SQL Server (2016 and above) SSMS Active Directory integration

Backup & Recovery

Experience with native SQL backups Veeam Veritas

Monitoring Tools

SolarWinds Manage Engine or similar DB monitoring tools

Patch Management

Strong knowledge of SQL patching and service pack updates

Automation Skills

Working knowledge of PowerShell T-SQL scripting

Disaster Recovery

Experience in managing DR setups (Log Shipping Always On Replication)

Documentation

Good practice in DB documentation and SOP writing

Compliance Awareness

Exposure to ISO/SOC controls and patching standards

OPTIONAL

Experience with AI-based database optimization or support will be considered an added advantage.

SOFT SKILLS:

MANDATORY

• Strong analytical and problem-solving ability
• Excellent written verbal communication and presentation skills
• Clear and accurate documentation skills
• Proven experience in team collaboration and cross-functional coordination
• High attention to detail and proactive security mindset
• Self-confidence motivation and ability to work independently and in a team
• Strong customer service orientation