Senior PostgreSQL Database Engineer / Administrator

Senior PostgreSQL Database Engineer / Administrator

Location: Austin or Southlake, TX - Onsite

Employment Type: Contract or Full-Time (FTE)

Position Overview

We are looking for an experienced Senior PostgreSQL Database Engineer/Administrator to support large-scale database modernization, migration, and automation initiatives. This position combines strong PostgreSQL engineering and administration expertise with scripting and emerging AI-assisted development technologies.

Key Responsibilities

• Design, develop, maintain, and optimize PostgreSQL databases, queries, stored functions, and related database components.
• Manage database modernization and schema migration initiatives across enterprise environments.
• Analyze and improve database performance through query tuning, indexing strategies, and database optimization.
• Develop automated solutions for DDL creation, code validation, migration testing, and access management.
• Create database and operational automation using Python, PowerShell, SQL, and scripting tools.
• Support AI-enabled engineering automation using GitHub Copilot, AI agents, and related technologies.
• Establish and maintain database security, role-based permissions, GRANT controls, and sensitive-data governance.
• Troubleshoot complex database issues involving performance, migrations, security, and application integrations.
• Partner with database administrators, application developers, architects, security teams, and other stakeholders to deliver reliable and scalable solutions.

Required Qualifications

• 7+ years of professional experience in database engineering, database administration, or software engineering.
• Advanced hands-on knowledge of PostgreSQL and PL/pgSQL.
• Strong experience with database migrations, schema design, indexing, performance optimization, and JSONB.
• Experience developing automation with Python, PowerShell, SQL, Git, and CI/CD pipelines.
• Understanding of database security practices, access provisioning, role/permission management, and sensitive-data controls.
• Exposure to GitHub Copilot, AI-assisted software development, prompt engineering, or AI agents.
• Ability to diagnose complex database and application performance issues.
• Strong communication skills with the ability to collaborate across technical and business teams.