Skills:
SQL, Solarwinds, Patch Management, Powershell, Database Administration, Backup and Recovery, Disaster Recovery,
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
Experience
Minimum 5-8 years of hands-on experience in database administration roles
Reporting To
SDM
Key Responsibilities
RESPONSIBILITIES (INCLUDES ALL TASKS):
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
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
