Description :

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.