Lead Infrastructure Engineer - Microsoft SQL Server, PostgreSQL

Job responsibilities

• Provides recommendations and insight on data management, governance procedures, and intricacies applicable to the acquisition, maintenance, validation, and utilization of data.

• Works with other team members, including offshore teams, to resolve high-priority issues.

• Helps manage GAIA application pools.

• Designs and maintains reliable software solutions for monitoring and alerting as needed.

• Works with the team on database performance issues, including code and infrastructure issues, sometimes using SQL Sentry.

• Monitors and troubleshoots SQL Server Availability Groups, including replication issues, database failovers, and general troubleshooting.

• Works with the team on certificate tracking and renewals.

• Supports PostgreSQL environments and vector database platforms used for AI/ML retrieval workloads, including embedding storage, indexing, and query performance.

• Uses AI tools and agents in day-to-day work to increase productivity, automate routine tasks, and speed up issue diagnosis and resolution.

• Partners with offshore and globally distributed teams to ensure consistent coverage, knowledge sharing, and delivery across time zones.

• Supports the on-call rotation for the team.

• Adds to a team culture of diversity, equity, inclusion, and respect.

Required qualifications, capabilities, and skills

• 7+ years of hands-on experience managing enterprise databases and supporting infrastructure in large-scale, mission-critical environments.

• Deep hands-on experience with relational databases, particularly Microsoft SQL Server, plus working experience with PostgreSQL.

• Proficiency with Transact-SQL (T-SQL).

• Experience designing, deploying, and troubleshooting SQL infrastructure, including Availability Groups (replication and failover).

• Working knowledge of vector databases (e.g., pgvector, Pinecone, Milvus, Chroma) and how they support AI/LLM retrieval and search workloads.

• Experience with PowerShell scripting and ETL processes.

• Experience with database performance troubleshooting and tuning, including tools such as SQL Sentry.

• Experience designing and maintaining monitoring and alerting solutions at scale.

• Ability to work collaboratively with cross-functional teams, including non-technical business stakeholders and offshore teams.

• Experience with internal cloud applications.

• Strong communication skills, with the ability to convey complex technical concepts to non-technical audiences.

• Experience with version control systems like Git and Bitbucket for data.

• A track record of applying AI tools to automate database operations, modernize workflows, and resolve issues more efficiently.

• A forward-looking mindset toward AI-driven transformation, with a demonstrated interest in modernizing database automation and tooling using AI capabilities.

Preferred qualifications, capabilities, and skills

• Experience with SQL Server Availability Groups.

• Proficiency with PowerShell.

• Solid understanding of Transact-SQL.

• Experience with internal cloud application infrastructure.

• Experience with overall SQL troubleshooting.

• Experience working with offshore or globally distributed engineering teams.

• Experience with PostgreSQL administration and performance tuning.

• Experience with vector database platforms and retrieval-augmented generation (RAG) architectures.

• Experience with developing AI agents, Skills, MCPs, and custom targeted agent profiles.

• Hands-on experience using AI coding assistants (GitHub Copilot and/or Claude) and applying them to database automation, scripting, and operational tooling.