Senior Database Administrator

ProTrans • Indianapolis, IN

1d • Hybrid

About The Position

The Senior Database Administrator is a highly skilled technical role responsible for the performance, availability, security, and reliability of enterprise database systems supporting critical business operations. The role covers Microsoft SQL Server administration, performance monitoring and tuning, migrations, lifecycle management, high availability, disaster recovery, and advanced troubleshooting. The Senior DBA provides technical leadership, serves as the final escalation point for complex database issues, and collaborates across teams to architect and deliver scalable, secure, and reliable database solutions.

The position requires working onsite in the Indianapolis office three days per week; remote candidates will not be considered. The DBA participates in an on-call rotation supporting business-critical systems.

Requirements

• Bachelor's degree in Computer Science, Information Technology, or a related field.
• At least 5 years of experience administering enterprise production database environments.
• Excellent analytical, strategic thinking, and problem-solving skills.
• Experience supporting mission-critical production environments.
• Expertise in Microsoft SQL Server, including Always On, replication, mirroring, and performance tuning.
• Advanced troubleshooting and performance tuning experience, including execution plans, indexing strategies, wait statistics, and query optimization.
• Familiarity with Azure cloud services and experience managing databases in virtual machines within Azure.
• Knowledge of database monitoring tools.
• Strong communication skills and ability to mentor team members.
• Familiarity with database security best practices, high availability, and disaster recovery.
• Understanding of ETL versus ELT concepts.
• Understanding of OLTP versus OLAP, BI tools, and their integration with databases.
• Able to work onsite in the Indianapolis office three days per week; remote candidates will not be considered.

Nice To Haves

• Bilingual in Spanish (highly preferred).
• Experience administering relational databases including MS SQL Server, Azure SQL Managed Instance, and Azure SQL Database.
• Experience with PowerShell or other scripting languages.
• Experience migrating databases to Azure SQL.
• Experience architecting databases for near-real-time reporting.
• Experience with database automation, CI/CD pipelines, and DevOps practices.
• Experience using source control systems such as Git.
• Experience with enterprise database monitoring platforms such as Redgate, Dynatrace, or SolarWinds.
• Experience deploying and maintaining NoSQL database technologies such as CosmosDB.
• Relevant certifications.

Responsibilities

• Provide technical leadership on database systems and solutions and serve as the final technical escalation point for database-related issues.
• Manage, maintain, implement, and support Microsoft SQL Server databases in a cloud-hosted high-availability environment, using SQL on virtual machines, Always-On Availability Groups, mirroring, and replication.
• Plan and execute SQL Server upgrades, migrations, and lifecycle management initiatives.
• Perform database capacity planning, storage forecasting, and resource utilization analysis.
• Research, analyze, monitor, and profile databases to improve performance, functionality, recoverability, and availability.
• Ensure data integrity, quality, and security across database systems.
• Participate in disaster recovery planning and testing; manage and validate backup, restore, and recovery strategies; and perform regular recovery testing.
• Architect and maintain databases for optimal performance and scalability.
• Manage database maintenance, including index optimization, statistics maintenance, and SQL Agent job management.
• Deploy and maintain database security controls and support security initiatives and audits.
• Cross-train peers and team members and guide them on complex database issues.
• Set and maintain standards and best practices for database systems; refine, automate, and document DBA processes through diagrams, SOPs, and scripts.
• Manage and tune database monitoring systems.
• Participate in an on-call rotation supporting business-critical systems.
• Participate in development code reviews to promote SQL coding standards and best practices.
• Collaborate with developers, BI, management, and other IT staff to ensure database reliability and performance and address complex data challenges.
• Evaluate, test, and recommend new technologies and tools.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior