PostgreSQL Engineer

Ampcus Inc; Scottsdale (AZ); On-site; USD 110,000 - 140,000; Full time

Job summary

Ampcus Inc. is seeking a Database Engineer to manage and optimize PostgreSQL and SQL Server environments with exposure to Oracle. The role includes automating provisioning with Ansible and collaborating across DevOps and infrastructure teams to ensure performance, scalability, and security.

Ideal candidates will have strong hands-on database experience, tuning skills, and a proactive approach to automation and reliability in a fast-paced technology consulting setting.

Qualifications

• Strong hands-on experience with PostgreSQL and MS SQL Server.
• Exposure to Oracle and automation using Ansible.
• Proficiency in database performance tuning and optimization.

Responsibilities

• Install, configure, and administer PostgreSQL and SQL Server databases.
• Tune performance, optimize queries, and ensure high availability.
• Manage backup, recovery, replication, and patching activities.
• Automate provisioning and configuration using Ansible.
• Monitor health and troubleshoot performance/availability issues.
• Collaborate with application, DevOps, and infrastructure teams.
• Ensure database security and access control adherence.

Skills

PostgreSQL

Microsoft SQL Server

Oracle

Ansible

Scripting (Shell/Python/PowerShell)

Tools

Ansible

Job description

Ampcus Inc. is a certified global provider of a broad range of Technology and Business consulting services. We are in search of a highly motivated candidate to join our talented Team.

Role Overview

We are looking for a skilled Database Engineer with strong expertise in PostgreSQL and SQL Server, along with exposure to Oracle and automation using Ansible. The role involves managing, optimizing, and automating database environments to ensure high availability, performance, and scalability.

Key Responsibilities

• Install, configure, and administer PostgreSQL and SQL Server databases across environments
• Perform database tuning, performance optimization, and query optimization
• Manage backup, recovery, replication, and high availability setups
• Automate database provisioning and configuration using Ansible
• Monitor database health and troubleshoot performance or availability issuesSupport database migrations, upgrades, and patching activities
• Work closely with application, DevOps, and infrastructure teams
• Ensure database security, access control, and compliance standards

Technical Skills Required

Core Database Skills

• Strong hands-on experience in:
  • PostgreSQL (Primary skill)
  • Microsoft SQL Server
• Working knowledge of:
  • Oracle (Good to h

  Automation & Tools

  • Experience with Ansible for database automation and configuration management
  • Exposure to scripting (Shell/Python/PowerShell) is an added advantage

  Expected Skill Proficiency (Evaluation Benchmark)

  • PostgreSQL: 8.5 / 10 (Expert level, must-have)
  • SQL Server: 7 / 10 (Strong working knowledge)
  • Oracle: 5 / 10 (Basic to intermediate - optional)
  • Ansible: 6 / 10 (Moderate automation capability)

  Ampcus is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, protected veterans or individuals with disabilities.