PostgreSQL DBA

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.

• Install and configure MS SQL Server; configure SQL clustering and SQL Always On Availability Groups.
• Manage MS SQL Server and Postgre
  
  SQL administration and maintenance on Azure.
• Perform capacity planning based on database growth; troubleshoot SQL Server clustering and Postgre
  
  SQL 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 Postgre
  
  SQL; 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.

• 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 Postgre
  
  SQL 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 Postgre
  
  SQL environments.
• Monitor and maintain database systems; troubleshoot problems that arise.
• Strong analytical skills, data modeling, and performance tuning in MS SQL Server and Postgre
  
  SQL.
• Experience upgrading databases and migrating from SQL Server to Postgre
  
  SQL.
• 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.

• Experience with Qlik Attunity, Solar Winds DPA, and Delphix.
• Power Shell programming.
• Backup and restore tools (e.g., EMC Net Worker, Comm Vault).
• Planning and coordination skills.
• Experience with mergers and acquisitions is a plus.
• Good communication and analytical skills.

• Full-time

• Information Technology

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