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.