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.