Talent.com
Sr. SQL Server DBA

Sr. SQL Server DBA

ConfidentialKota, IN
5 hours ago
Job description

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.
  • Create a job alert for this search

    Sql Dba • Kota, IN