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.
