Senior DBA - Onsite in Indianapolis, SQL Server & HA Expert

PROTRANS INTERNATIONAL LLC

Bridgeport (IN)

On-site

USD 110,000 - 140,000

Full time

2 days ago

Be an early applicant

Application generator

Don’t send a generic resume — generate a resume and cover letter tailored to this exact role.

Get past ATS filters

Job summary

PROTRANS INTERNATIONAL LLC in Indianapolis seeks a Senior Database Administrator to ensure performance, availability, security and reliability of enterprise databases. The role focuses on Microsoft SQL Server, Always-On, replication, and cloud-based deployments in Azure.

You will lead implementations, upgrades, and disaster recovery testing, monitor performance, and mentor team members while collaborating with developers, BI, and IT staff to deliver scalable database solutions on-site three days

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.
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 solutions and act as the final technical 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.
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.