PostgreSQL DBA

Omm Inc.

Indianapolis (IN)

On-site

USD 90,000 - 120,000

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

A leading IT consulting firm is seeking an Onsite Database Administrator in Indianapolis, IN. The role requires extensive experience in MS SQL Server and PostgreSQL on Azure. You will manage, maintain, and troubleshoot database systems, perform capacity planning, and implement backup strategies. This is a full-time onsite position requiring strong analytical skills and the ability to work a rotating shift schedule.

Qualifications

  • Minimum 7 years of IT experience.
  • At least 6 years in MS SQL Server and PostgreSQL on Azure.
  • Strong analytical skills and performance tuning.

Responsibilities

  • Install and configure MS SQL Server.
  • Manage MS SQL Server and PostgreSQL on Azure.
  • Monitor and troubleshoot database systems.

Skills

SQL Server administration
PostgreSQL administration
Performance tuning
Troubleshooting
Capacity planning

Education

Bachelor's degree in relevant field

Tools

SQL Profiler
SQL Server Management Studio
PostgreSQL
PowerShell

Job description

Overview

Onsite Database Administrator position located in Indianapolis, IN. This is a 100% onsite role. Candidate must be located within commuting distance or willing to relocate to Indianapolis and be available to work a rotating shift schedule to provide 24/7 support, including early mornings, late nights, weekends, and on-call coverage.

Responsibilities
  • Install and configure MS SQL Server; configure SQL clustering and SQL Always On Availability Groups.
  • Manage MS SQL Server and PostgreSQL administration and maintenance on Azure.
  • Perform capacity planning based on database growth; troubleshoot SQL Server clustering and PostgreSQL environments.
  • Monitor, maintain, and troubleshoot database systems; manage performance tuning and query optimization using tools such as SQL Profiler, execution plans, and index recommendations.
  • Upgrade databases to newer versions and migrate databases from SQL Server to PostgreSQL; ensure data integrity and security (manage roles and permissions).
  • Implement backup, restoration, and replication strategies; manage SQL Server Integration Services (SSIS), Reporting Services (SSRS), and Analysis Services (SSAS).
  • Utilize replication and Change Data Capture processes; ensure reporting environment stays in sync with database updates.
  • Create detailed documentation including diagrams of database infrastructure; understand business processes, data flow, and dependencies.
Required Qualifications
  • Bachelor’s degree or foreign equivalent required from an accredited institution. Three years of progressive experience in the specialty may be considered in lieu of every year of education.
  • At least 7 years of Information Technology experience.
  • At least 6 years of experience in MS SQL Server on Azure and PostgreSQL administration and maintenance.
  • Understanding of Azure framework; MS SQL Server in Azure is required.
  • Able to install and configure MS SQL Server, configure SQL clustering, and SQL Always On Availability Groups.
  • Able to perform capacity planning and database growth assessments.
  • Strong troubleshooting skills in SQL Server clustering and PostgreSQL environments.
  • Monitor and maintain database systems; troubleshoot problems that arise.
  • Strong analytical skills, data modeling, and performance tuning in MS SQL Server and PostgreSQL.
  • Experience upgrading databases and migrating from SQL Server to PostgreSQL.
  • Maintain data integrity and security (manage database user roles and permissions).
  • Experience with SQL Server tools such as SQL Profiler, Database Tuning Advisor, Execution Plans; provide index recommendations.
  • Generate traces and execution plans; identify and resolve performance issues, including deadlocks and contention.
  • Develop and implement backup, restoration, and replication strategies.
  • Strong knowledge of SQL Server Integration Services (SSIS), Reporting Services (SSRS), and Analysis Services (SSAS).
  • Familiarity with SQL replication functions and Change Data Capture processes.
  • Ability to complete regular database refreshes and keep reporting environments in sync.
  • Experience creating documentation and diagrams of database infrastructure; understand business processes and data dependencies.
  • U.S. citizens and those authorized to work in the U.S. are encouraged to apply. We are unable to sponsor at this time.
Preferred Qualifications
  • Experience with Qlik Attunity, SolarWinds DPA, and Delphix.
  • PowerShell programming.
  • Backup and restore tools (e.g., EMC NetWorker, CommVault).
  • Planning and coordination skills.
  • Experience with mergers and acquisitions is a plus.
  • Good communication and analytical skills.
Employment type
  • Full-time
Job function
  • Information Technology
Industries
  • IT Services and IT Consulting

We are framing this as a general candidate outreach and do not include extraneous job recommendations or unrelated postings within the description.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

PostgreSQL Database Administrator
PostgreSQL Database Administrator

Atser, Lp • Houston (TX)

On-site
USD 100,000 - 130,000
Senior PostgreSQL & Azure DBA — Onsite 24/7 Support
Senior PostgreSQL & Azure DBA — Onsite 24/7 Support

Omm Inc. • Indianapolis (IN)

On-site
USD 90,000 - 120,000
Senior DBA - Azure SQL & PostgreSQL (Onsite Indianapolis)
Senior DBA - Azure SQL & PostgreSQL (Onsite Indianapolis)

Omm IT Solutions • Indianapolis (IN)

On-site
USD 120,000 - 150,000
Senior PostgreSQL DBA
Senior PostgreSQL DBA

Quantum Technologies LLC • New Jersey

On-site
USD 95,000 - 128,000
Senior PostgreSQL DBA
Senior PostgreSQL DBA

Robotics Technologies LLC • New Jersey

On-site
USD 92,000 - 131,000
Senior PostgreSQL DBA
Senior PostgreSQL DBA

Valiant Technologies LLC • New Jersey

On-site
USD 92,000 - 131,000
Senior PostgreSQL DBA
Senior PostgreSQL DBA

Ethereum Technologies LLC • New Jersey

On-site
USD 92,000 - 131,000
Senior PostgreSQL DBA
Senior PostgreSQL DBA

Robotic Process Automation LLC • New Jersey

On-site
USD 92,000 - 131,000
Omm2701J
Omm2701J

Omm IT Solutions • Richardson (TX)

On-site
USD 110,000 - 150,000
Database Administrator (PostgreSQL)
Database Administrator (PostgreSQL)

Prestige Staffing • Atlanta (GA)

Hybrid
USD 120,000 - 130,000