Job Title

Senior SQL Server DB AdminAbout 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.