Senior Sql Database Administrator

BayOne Solutions; United States; On-site; USD 110,000 - 170,000; Full time

Job summary

BayOne Solutions is seeking a Senior Database Administrator to optimize SQL Server performance across multiple platforms. The role emphasizes diagnosing inefficiencies, tuning queries, and guiding development teams toward high-performing database solutions.

Responsibilities include maintenance, backups, security, and DR planning, with involvement in Airflow/dbt pipelines and AWS services. A strong ETL/ELT background is essential for success.

Qualifications

• Bachelor's degree in CS/IS or related field or equivalent experience.
• 5-7 years as a DBA with emphasis on SQL Server performance tuning.
• Strong query tuning, indexing strategies, and execution plan analysis.
• Familiarity with DMVs, SQL Profiler, Extended Events and Query Store.
• 2+ years Snowflake and dbt for data warehousing.
• 3+ years AWS cloud services (S3, Glue, DMS, Lambda, Redshift).
• Solid ETL/ELT understanding with Airflow emphasis.
• Strong T-SQL and scripting (PowerShell or Python).
• HA/DR design experience (Always On, log shipping, clustering).
• Translate performance insights to developers and infra teams.
• Willing to apply AI to DBA tasks and processes.

Responsibilities

• Analyze, tune, and optimize database performance for mission-critical SQL Server environments.
• Perform deep analysis of slow-running queries, indexes, and workloads using advanced monitoring tools.
• Partner with developers to improve SQL code, optimize schema, and ensure scalable architecture.
• Implement, maintain, and support database monitoring tools for proactive detection of issues.
• Administer and support SQL Server databases: user access, backups, patching, replication.
• Provide performance reviews and configurations for Oracle, PostgreSQL, and MySQL as needed.
• Develop and maintain documentation for performance standards and tuning methodologies.
• Participate in capacity planning, workload forecasting, and resource reviews.
• Ensure high availability and disaster recovery strategies are optimized and cost-effective.
• Manage multiple projects and tune databases for several enterprise products.
• Monitor and support data pipelines built in Airflow and dbt.
• Work on AWS to monitor and handle ETL/ELT tools like Glue and DMS.
• Communicate clearly with stakeholders in a fast-paced multi-database environment.

Skills

SQL Server performance tuning

Query optimization

Indexing strategies

T-SQL scripting

Automation scripting (PowerShell/Py

ETL/ELT concepts

Communication with developers

AI for DBA tasks

Education

Bachelor's degree in Computer Science / Information Systems or equivalent

Tools

Snowflake

dbt

Airflow

AWS (S3, Glue, DMS, Lambda, Redshift)

SolarWinds DPA

Redgate SQL Monitor

SentryOne

Oracle

PostgreSQL

MySQL

Job description

We're looking for a Senior Database Administrator who excels at performance optimization and database tuning across multiple platforms, with a strong focus on Microsoft SQL Server. This position is ideal for a hands-on DBA who enjoys diagnosing inefficiencies, improving application performance, and guiding development teams in building high performing database solutions. While performance is the primary focus, the role includes the full spectrum of database administration duties such as maintenance, monitoring, backup, recovery, and security management. In addition to this candidate is expected to have a strong understanding of ETL/Data warehousing concepts. This role would also focus on monitoring and debugging Production grade ETL pipelines.

What You Will Do:

• Analyze, tune, and optimize database performance for mission-critical SQL Server environments.
• Perform deep analysis of slow-running queries, indexes, and workloads using advanced performance monitoring tools.
• Partner with developers to improve SQL code efficiency, optimize schema design, and ensure scalable architecture.
• Implement, maintain, and support database monitoring tools for proactive detection and resolution of performance issues.
• Administer and support SQL Server databases, including user access, backups, patching, and replication.
• Provide performance reviews and configurations for Oracle, PostgreSQL, and MySQL systems as needed.
• Develop and maintain documentation for performance standards, baselines, and tuning methodologies.
• Participate in capacity planning, workload forecasting, and resource utilization reviews.
• Ensure high availability and disaster recovery strategies are performance-optimized and cost-effective.
• Manage multiple concurrent projects and tune databases supporting several enterprise products.
• Monitor and support data pipelines built in Airflow and dbt.
• Work on AWS to implement monitoring and error handling on ETL/ELT tools such as Glue and DMS.
• Excellent communication skills, attention to detail, and ability to prioritize in a fast paced, multi-database environment.

Who You Are :

• Bachelor's degree in computer science, Information Systems, or a related field (or equivalent practical experience).
• 5-7 years of experience as a DBA with a strong emphasis on SQL Server performance tuning and optimization.
• Expertise in query tuning, indexing strategies, query store analysis, execution plan interpretation, and hardware resource analysis.
• Familiarity with dynamic management views (DMVs), SQL Profiler, Extended Events, and Query Store.
• 2+ years of experience with Snowflake and dbt for data warehousing.
• 3+ years of hands-on experience with AWS cloud services (S3, Glue, DMS, Lambda, Redshift, etc.).
• Solid understanding of ETL/ELT pipelines and data orchestration with strong focus on Airflow.
• Strong background in T-SQL and scripting for automation (e.g., PowerShell or Python).
• Experience with HA/DR design (Always On, log shipping, clustering) and its impact on performance.
• Ability to translate performance insights into actionable recommendations for developers and infrastructure teams.
• Ability to leverage AI for DBA tasks as well as implementing AI to improve current processes.

Preferred Qualifications:

• Experience with CI/CD pipelines for data Engineering Workflows.
• Experience with cloud-based databases (Azure SQL, AWS RDS, or Google Cloud SQL).
• Working knowledge of Oracle, PostgreSQL, and MySQL administration and performance troubleshooting a plus.
• Well versed with database monitoring and analytics tools such as SolarWinds DPA, Redgate SQL Monitor, or SentryOne. Certifications such as Microsoft Certified: Azure Database Administrator Associate or SQL Server Performance Tuning Specialist.
• Participation in performance benchmarking and scalability testing of enterprise applications.
• Experience with CI/CD pipelines for data Engineering workflows.
• Dynamic and collaborative IT organization supporting diverse business applications.
• May require periodic after-hours or weekend support during performance testing or maintenance windows.