Senior SQL Server DBA — On‑Site in Indianapolis

ProTrans; Indianapolis (IN); On-site; USD 110,000 - 160,000; Full time

Job summary

ProTrans is seeking a Senior Database Administrator to ensure the performance, availability, security and reliability of enterprise databases in a on-site Indianapolis office. The role focuses on Microsoft SQL Server administration, Always-On availability, upgrades, migrations and DR planning to support critical business operations.

You will lead incident resolution, optimize queries and backups, collaborate with developers and BI teams, and mentor peers while refining DBA processes and best

Qualifications

• Bachelor's degree in Computer Science, Information Technology, or a related field.
• Bilingual in Spanish HIGHLY PRFERRED
• Minimum 5 years of experience administering enterprise production database 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 the ability to mentor other team members.
• Familiarity with database security best practices, high availability and disaster recovery.
• Understanding of ETL vs ELT concepts.
• Understanding of OLTP vs OLAP, BI tools and their integration with databases.

Responsibilities

• Provide technical leadership on database systems and escalation point for issues.
• Manage, maintain, implement and support MS SQL Server databases in high-availability cloud environments.
• Plan and execute SQL Server upgrades, migrations and lifecycle management.
• Perform capacity planning, storage forecasting and resource utilization analysis.
• Conduct research, monitoring and profiling to improve performance and availability.
• Ensure data integrity, quality and security across all databases.
• Participate in Disaster Recovery planning and testing; backup and restore validation.
• Architect and maintain databases for optimal performance and scalability.
• Manage maintenance: index optimization, statistics, SQL Agent jobs.
• Deploy and maintain database security controls; support audits.
• Cross-train peers and refine DBA processes with SOPs and scripts.
• Participate in on-call rotation and code reviews with developers and BI teams.
• Collaborate to ensure reliability and integrate BI tools with databases.
• Evaluate, test, and recommend new technologies and tools.

Skills

Bilingual in Spanish

Analytical thinking

Problem solving

Mentoring

Strong communication

Education

Bachelor's degree in Computer Science, Information Technology, or a related field

Tools

Microsoft SQL Server

Azure

PowerShell

Git

NoSQL (CosmosDB)

Dynatrace

Redgate/SolarWinds

Job description

ProTrans is seeking a Senior Database Administrator to ensure the performance, availability, security and reliability of enterprise databases in a on-site Indianapolis office. The role focuses on Microsoft SQL Server administration, Always-On availability, upgrades, migrations and DR planning to support critical business operations.

You will lead incident resolution, optimize queries and backups, collaborate with developers and BI teams, and mentor peers while refining DBA processes and best