On-Site Indianapolis Senior SQL DBA - High Availability

Pro Trans International; Indianapolis (IN); On-site; USD 95,000 - 145,000; Full time

Job summary

Pro Trans International in Indianapolis seeks a Senior Database Administrator to safeguard and optimize our enterprise SQL Server environments. This on-site role requires hands-on leadership, performance tuning, high availability, security, and disaster recovery across cloud and on-premises deployments.

You will plan migrations, manage upgrades, mentor teammates, participate in on-call rotations, and collaborate with BI, development and IT to resolve complex data challenges.

Qualifications

• Bachelor's degree in Computer Science, Information Technology, or a related field.
• Minimum of 5 years of experience administering enterprise production database environments.
• Expertise in Microsoft SQL Server including Always On, replication, mirroring and performance tuning.
• Familiarity with Azure cloud services and experience managing databases in virtual machines within Azure.
• Strong communication skills and the ability to mentor other team members.

Responsibilities

• Provide technical leadership on database systems and act as the final escalation point for all database-related issues.
• Manage, maintain, implement and support Microsoft SQL Server databases in a high-availability environment hosted in the cloud (SQL on VMs), using 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.
• Conduct research, analysis, monitoring and profiling to improve database performance, functionality, recoverability and availability.
• Ensure data integrity, quality and security across all database systems.
• Participate in the Disaster Recovery Planning and Testing to manage and validate backup, restore and recovery strategies and perform regular recovery testing to ensure recoverability of business-critical databases.
• Architect and maintain databases for optimal performance and scalability.
• Manage database maintenance activities 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 provide guidance on complex database issues.
• Set and maintain high standards and best practices for database systems while refining, automating and documenting DBA processes through diagrams, SOPs and scripts.
• Manage and tune database monitoring systems.
• Participate in on-call rotation supporting business-critical systems.
• Participate in development code reviews to educate on SQL coding standards and best practices.
• Collaborate with developers, BI, management and other IT staff to ensure database system reliability, performance and provide solutions to complex data challenges.
• Evaluate, test, and recommend new technologies and tools.

Skills

Leadership & mentorship

Analytical thinking

Problem-solving

Communication skills

On-call experience

Education

Bachelor's degree in Computer Science or Information Technology

Tools

Microsoft SQL Server

Always On Availability Groups

Azure

SQL Server Agent

PowerShell

Job description

Pro Trans International in Indianapolis seeks a Senior Database Administrator to safeguard and optimize our enterprise SQL Server environments. This on-site role requires hands-on leadership, performance tuning, high availability, security, and disaster recovery across cloud and on-premises deployments.

You will plan migrations, manage upgrades, mentor teammates, participate in on-call rotations, and collaborate with BI, development and IT to resolve complex data challenges.