Senior Database Administrator

Republic Airways Inc.; Carmel (IN); On-site; USD 110,000 - 150,000; Full time

Job summary

Republic Airways Inc. is seeking a Senior SQL Server DBA to own core database operations and drive modernization across the data platform.

You will deploy, configure, and manage SQL Server instances in clustered, standalone, and Azure environments, while leading governance and security enhancements. The role requires 8+ years of enterprise SQL Server experience, expert T-SQL skills, and working knowledge of Azure SQL and Synapse.

Qualifications

• Bachelor's degree or equivalent coupled with extensive SQL Server DBA experience.
• 8+ years in enterprise SQL Server environments with strong T-SQL expertise.
• Hands-on Azure SQL and Synapse administration and migrations.
• Proven HA/DR design, security hardening, and performance tuning.

Responsibilities

• Own core DBA duties including SQL Server installation, configuration and patching.
• Monitor, analyze and optimize performance; tune queries, indexes, and workloads.
• Design backup/recovery strategies and test DR plans regularly.
• Lead modernization efforts toward Azure SQL, Synapse, and cloud adoption.
• Enforce security, roles, permissions, encryption and audit readiness.
• Develop automation with PowerShell and CI/CD for DB changes.

Skills

SQL Server DBA

T-SQL

Azure SQL

HA/DR

Security hardening

Leadership

Education

Bachelor's degree in CS or related field

Tools

Ansible

Terraform

PowerShell

CI/CD for databases

dbatools

Job description

Job Category: Information Technology

POSITION PURPOSE This is a mixed operational and strategic role that has evolved beyond the traditional core DBA responsibilities. In addition to owning core DBA responsibilities, the Senior DBA will help drive modernization initiatives that improve reliability, security, performance, and governance across the enterprise data platform.

ESSENTIAL DUTIES

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. Reasonable accommodation may be made to enable individuals with disabilities to perform the essential functions.

• Database installation & configuration: Deploy and configure SQL Server instances across clustered, standalone, and Azure environments.
• Performance monitoring & tuning: Monitor SQL Server health, analyze query execution plans, optimize indexes, and troubleshoot performance bottlenecks across OLTP and analytical workloads.
• T-SQL development & optimization: Write, review, and optimize complex queries, stored procedures, and scripts for performance and scalability.
• Backup & recovery management: Design and maintain backup strategies (full, differential, transaction log), perform regular restore tests, and ensure compliance with RPO/RTO targets.
• High availability & disaster recovery: Implement and maintain HA/DR solutions including Always On Availability Groups, replication, and failover clustering.
• Security & compliance: Enforce database security standards, manage roles and permissions, implement encryption (TDE, Always Encrypted), and maintain audit readiness.
• Job scheduling & automation: Manage SQL Agent jobs, resolve scheduling conflicts, and develop automation using PowerShell and T-SQL.
• Capacity, patch & upgrade management: Monitor disk and compute utilization, forecast growth, apply cumulative updates and service packs, coordinate version upgrades, and validate changes in lower environments.
• Documentation & standards: Maintain runbooks, configuration documentation, and operational standards.
• On-call support: Provide 24/7 coverage for critical production systems, responding promptly to alerts and incidents.
• Strategic Modernization Leadership: Cloud and platform modernization: Lead consolidation of legacy SQL Server instances, evaluate workloads for cloud migration (Azure SQL, Managed Instance, Synapse), and optimize licensing posture.
• Synapse and Fabric administration: Maintain Azure Synapse IAM, implement row-level security in Microsoft Fabric workspaces, and tune MPP workloads (distribution, partitioning, statistics, workload management).
• Alerting and DR standardization: Standardize alerting and paging coverage across critical pipelines, own the enterprise backup strategy, and validate DR plans through scheduled exercises.
• Governance partnership: Partner with the data governance team on Microsoft Purview cataloging, lineage, sensitivity labeling, and data dictionary initiatives.
• Standards and automation: Drive connection naming standards, infrastructure-as-code adoption for database deployments, and CI/CD pipelines for schema changes.
• Knowledge transfer and mentorship: Author DBA runbooks, enforce best practices, and lead structured knowledge-sharing sessions with data engineers and BI developers.

REQUIRED KNOWLEDGE, SKILLS AND ABILITIES

The requirements listed below are representative of the knowledge, skill, and/or ability necessary to perform this job.

• Education: Bachelor's degree in Computer Science, Information Systems, or a related field preferred; equivalent hands-on experience will be considered in lieu of a degree.
• Experience: 8 years of experience as a SQL Server DBA in enterprise environments.
• T-SQL: Expert-level T-SQL skills for query development, optimization, and troubleshooting.
• Monitoring: Experience with monitoring tools and dashboards for observing database health, query performance, and resource utilization.
• Upgrades & migrations: Proven ability to upgrade and migrate legacy SQL Server versions (2012/2016) to currently supported releases.
• HA/DR and security: Hands-on expertise in HA/DR, performance tuning, and security hardening.
• Lifecycle management: Strong knowledge of patching, upgrades, and lifecycle management.
• Azure: Working knowledge of Azure SQL and Azure Synapse Analytics.
• Incident tooling: Experience with incident and alerting platforms (PagerDuty, Opsgenie, or similar).
• Leadership: Proven ability to lead cross-functional projects and communicate effectively with both technical and non-technical stakeholders.

PREFERRED EDUCATION and/or EXPERIENCE

• Multi-engine exposure: Hands-on experience with Amazon DynamoDB (data modeling, capacity/throughput management, application integration) and/or PostgreSQL or other relational/NoSQL platforms in production.
• Automation and DevOps: Experience with infrastructure-as-code and configuration management using Ansible and Terraform (PowerShell, SSIS, dbatools, CI/CD for databases).
• Synapse MPP: Experience including distribution strategy, partitioning, and workload management.
• Microsoft Fabric: Administration and row-level security implementation.
• Monitoring platforms: Datadog alerting and dashboarding familiarity.
• Governance: Microsoft Purview or comparable data governance experience.
• Compliance: Knowledge of compliance frameworks and audit-readiness practices.

LANGUAGE SKILLS

Ability to read, analyze, and interpret general business periodicals, professional journals, technical procedures, and governmental regulations.

Ability to write clear reports, business correspondence, and procedure manuals.

Strong written and verbal communicator, able to explain technical database decisions — performance tradeoffs, risk, cost — in terms that resonate with both engineers and business leadership, and to present confidently to groups of managers, clients, and stakeholders.

REASONING/PROBLEM SOLVING ABILITY

Ability to solve practical problems and deal with a variety of concrete variables in situations where only limited standardization exists.

Ability to interpret a variety of instructions furnished in written, oral, diagram, or schedule form.

DECISION MAKING

Exercises independent judgment on database architecture, performance tuning, and DR strategy.

Has authority to approve emergency changes and failover decisions during incidents; budget-impacting decisions (e.g., licensing, hardware) are made in partnership with IT leadership.

PHYSICAL DEMANDS

The physical demands described here are representative of those that must be met by an associate to successfully perform the essential functions of this job. Mobility: Able to move about the work environment. Presence: Frequently required to stand, walk, sit, talk and hear. Vision: Able to focus with clear vision at 20 inches or less (computer screen).

WORK ENVIRONMENT

The work environment characteristics described here are representative of those an associate encounters while performing the essential functions of this job. Typically not exposed to extreme environmental conditions.

TRAVEL REQUIREMENTS

Travel up to 5% of the time, primarily for offsite visits.

EQUAL OPPORTUNITY EMPLOYER, DISABILITY, AND VETERAN ACCOMMODATIONS

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.

Equal Opportunity Employer, Disability and Veteran Accommodations All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.

Founded in 1974 and headquartered in Indianapolis, Indiana, Republic Airways is one of the largest regional airlines in North America. Republic operates a fleet of 200+ Embraer 170/175 aircraft and offers scheduled passenger service with 900 daily flights to 80+ cities in the U.S. and Canada. Republic continues to lead the way in innovation and operational excellence for 50 years. The unrivaled work being done by our over 6,000 Associates sets us apart from the competition. We are in an era of growth and untapped potential across the aviation industry. It’s an exciting time to be part of our Company, from corporate positions to the flight deck. No matter your role, your opportunities are elevated at Republic Airways. Republic Airways fosters a culture of trust, respect, care and fun. We believe our people and the passion they bring to their work is what distinguishes us. We work to encourage, support and invest in our Associates both professionally and personally. We live and breathe our Vision, Mission, Culture Statement and Guiding Principles — those words are put into action each and every day at Republic.