Senior Database Administrator

Pro Trans International

Indianapolis (IN)

Presencial

USD 95.000 - 145.000

Jornada completa

14 días+

Consigue una respuesta de este empleador

Tu currículum y tu carta de presentación, adaptados exactamente a lo que buscan contratar.

Supera los filtros ATS

Descripción de la vacante

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.

Formación

  • 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.

Responsabilidades

  • 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.

Conocimientos

Leadership & mentorship
Analytical thinking
Problem-solving
Communication skills
On-call experience

Educación

Bachelor's degree in Computer Science or Information Technology

Herramientas

Microsoft SQL Server
Always On Availability Groups
Azure
SQL Server Agent
PowerShell

Descripción del empleo

MUST BE ABLE TO WORK ON SITE IN THE INDIANAPOLIS OFFICE 3 DAYS PER WEEK. REMOTE CANDIDATES WILL NOT BE CONSIDERED FOR THIS OPPORTUNITY.

Senior Database Administrator - Position Overview

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. This role includes Microsoft SQL Server database administration, performance monitoring and tuning, migrations, lifecycle management, high availability, disaster recovery and advanced troubleshooting. The Senior DBA will provide technical leadership, act as the final escalation point for complex database issues and collaborate across teams to architect and deliver scalable, secure and reliable database solutions.

Key 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.
  • 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.

Basic Qualifications:

  • Bachelor's degree in Computer Science, Information Technology, or a related field.
  • Minimum of 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 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.

Preferred Qualifications:

  • Experience in relational database administration including MS SQL Server, Azure SQL Managed Instance, Azure SQL Database.
  • Experience with PowerShell or other scripting languages.
  • Experience with database migration to Azure SQL.
  • Experience in 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, SolarWinds.
  • Experience deploying and maintaining NoSQL database technologies such as CosmosDB.
Consigue la evaluación confidencial y gratuita de tu currículum.

o arrastra y suelta tu archivo aquí

Similar jobs

Puestos de trabajo similares que vale la pena comparar

Senior Database Administrator
Senior Database Administrator

Digitailor • Indianapolis (IN)

Presencial
USD 110.000 - 170.000
SQL DBA
SQL DBA

eBusiness Solutions Inc. • Columbus (OH)

Híbrido
USD 90.000 - 130.000
Senior Database Administrator (SQL Server & Azure Data Platform)
Senior Database Administrator (SQL Server & Azure Data Platform)

Madison-Davis • New Jersey

Híbrido
USD 120.000 - 180.000
Sr. SQL Server Performance Engineer/ DBA
Sr. SQL Server Performance Engineer/ DBA

Advanced Tech Placement • Florham Park (NJ)

Presencial
USD 110.000 - 140.000
Database Administrator
Database Administrator

Insight Global (United States) • Louisville (KY)

Presencial
USD 110.000 - 140.000
Senior SQL Server DBA
Senior SQL Server DBA

Aegistech • New Jersey

Híbrido
USD 120.000 - 170.000
On-Site Indianapolis Senior SQL DBA - High Availability
On-Site Indianapolis Senior SQL DBA - High Availability

Pro Trans International • Indianapolis (IN)

Presencial
USD 95.000 - 145.000
Senior SQL Database Administrator
Senior SQL Database Administrator

Verra Mobility • Mesa (AZ)

Presencial
USD 100.000 - 130.000
Senior SQL Server DBA – On-Site Indianapolis, HA & DR
Senior SQL Server DBA – On-Site Indianapolis, HA & DR

Digitailor • Indianapolis (IN)

Presencial
USD 110.000 - 170.000
SQL Database Administrator
SQL Database Administrator

COGENT Infotech • Baltimore (MD)

Presencial
USD 90.000 - 130.000