Sr. SQL Server DBA

Senior SQL Server DB Admin

About the Role:

We are seeking a highly skilled Senior SQL Server Database Administrator to setup, manage, optimize, and support our SQL Server in a mission-critical, high-performance environment. The ideal candidate will have deep expertise in database tuning, backups, high availability, monitoring and automation.

As a key member of the data team, you will collaborate closely with business stakeholders, cross-functional data teams, and subject matter experts (SMEs) to implement data solutions that support data-driven decision-making at scale.

Key Responsibilities:

Database Architecture & Design

• Partner with application developers to design, test, refine and maintain efficient transactional and analytical data models.
• Participate in the evaluation, design, implementation, maintenance and enhancement of complex database systems and technologies.
• Support the creation and maintenance of architecture diagrams and data process flow documentation.
• Define and document policies, procedures and standards related to database administration.

Performance, Configuration & Optimization

• Lead or participate in tuning, upgrade and configuration initiatives to improve performance and ensure system stability.
• Troubleshoot database performance issues and resolve SQL Server errors, failures, and bottlenecks.
• Handle various ad-hoc data loading, manipulation and processing tasks.

Backup, Recovery & Environment Management

• Manage and optimize backup jobs, schedules and recovery processes across Production, DR and Development environments.
• Document, test and validate all backup and recovery procedures.
• Ensure service-level availability for all production and non-production SQL Server environments.
• Oversee database security, integrity, transaction activity and resource utilization.

Operations, Maintenance & Support

• Troubleshoot database and data-related issues as they arise.
• Install and maintain SQL Server software and related components.
• Create, maintain and monitor scheduled tasks, data processing scripts and automation workflows.

Data Management & Reporting

• Provide ad-hoc data pulls, queries and reporting support for Analytics teams.
• Manage routine data exports for clients, partners and subject-matter experts.
• Document data collection, processing and presentation procedures.

About Candidate:

You are an experienced SQL Server Database Administrator with a proven track record of designing implementing, maintaining and optimizing data solutions at an enterprise scale. You are a problem solver who thrives in a collaborative environment and can effectively manage multiple stakeholders across the organization.

Qualifications:

Experience :

• Minimum of 10+ years of experience in data, digital, technology or analytical roles.
• Install and configure SQL Server to set up Test, Development, Staging, and Production environments.
• Implement and maintain disaster recovery plans for critical databases.
• Create and manage linked servers to SQL Server and external databases
• Design and maintain a comprehensive backup and restoration strategy.
• Provide 24x7 on-call support as part of the database administration team.
• Monitor scheduled backups to ensure they run successfully and consistently.
• Perform point-in-time database recoveries when requested.
• Configure high-availability solutions as part of the disaster recovery strategy, including Failover Clustering, Database Mirroring, Log Shipping, Replication, and Always On.
• Troubleshoot and resolve day-to-day issues by reviewing SQL Server error logs and alert notifications.
• Conduct performance monitoring and tuning at the server, database, and query levels, including index management, memory configuration, CPU and disk I/O analysis, and avoiding unnecessary database shrinking.
• Document major SQL Server changes, configurations, and updates.
• Apply service packs, patches, and updates to maintain system stability and security.
• Experience in Cloud Architecture (Azure)

Technical Skills :

• Strong knowledge of Database Administration
• Hands-on expertise in Cloud-based Architecture on Azure.
• Experience in integrating AI/ML frameworks into data platforms. (Good to have)
• Ability to write clear design specifications and technical documentation.
• Proven ability to mentor and guide teams on Data Architecture Principles .

Certifications :

• Relevant certifications in Cloud-based Architecture (Azure) are a plus.