Experience - 7 plus years
Role Overview
We are looking for an experienced SQL Server Database Administrator with strong expertise in handling day-to-day DB Administration activities in a multi-platform enterprise environment, owning and driving scheduled and ad-hoc maintenance tasks, strong performance analysis, tuning, troubleshooting, production incident resolution, and query optimization. The ideal candidate has supported large-scale global enterprises (>$10B annual revenue) and can quickly analyze and resolve performance-related issues in mission-critical environments.
Key Responsibilities
- Installation & Configuration: Set up and maintain SQL Server instances, including patching and upgrades.
- Performance Tuning: Monitor, analyze and optimize database performance, queries, and scalability.
- Backup & Recovery: Design, implement, and test robust backup and disaster recovery plans.
- Security: Manage user accounts, roles, permissions, and conduct security audits to protect data.
- Maintenance: Perform routine tasks like index maintenance, space management, and applying updates.
- High Availability: Administer solutions like Always-on Availability Groups, mirroring, and replication.
- Troubleshooting: Resolve database incidents and determine root causes.
- Collaboration: Work with developers to design efficient database solutions and optimize code.
- Documentation: Create and maintain documentation for database configurations and procedures.
- Automation: Write scripts (T-SQL, PowerShell) to automate repetitive tasks.
Essential Skills & Qualifications
- Proficiency in SQL Server Administration, Security, Performance Tuning, Backup/Recovery.
- Strong understanding of T-SQL.
- Experience with High Availability/Disaster Recovery (HA/DR) technologies.
- Ability to automate tasks.
- Strong problem-solving and communication skills.
- Lead critical production incident resolution including triage, RCA, and permanent fixes.
- Perform database upgrades, patching, and capacity planning.
- Ensure database security, auditing, and compliance.
- Automate repeatable DBA tasks and maintain documentation.
- Analyze and investigate reason for job failures, long-running queries, and provide recommendations to improve overall system performance.
Required Experience
- 7+ years of hands-on SQL Server DBA experience in enterprise environments.
- Experience supporting organizations with >$10B revenue or large-scale operational workloads.
- Hands-on experience with SSMS, SSRS.
Strong Expertise In
- SQL tuning.
- Query execution plans and explain plan interpretation.
- Wait events & performance diagnostics.
