Database Engineer
Summary
Index Analytics is hiring a remote Database Engineer to design, administer, and optimize cloud database services for a large federal data warehouse. Day-to-day work spans Snowflake and PostgreSQL administration, SQL performance tuning, CI/CD-managed schema changes, and Python/automation with AWS services like S3, Lambda, and Secrets Manager.
ABOUT INDEX ANALYTICS
Index Analytics, LLC delivers mission-critical health, data, technology and consulting solutions for the federal government. We foster a collaborative, employee-focused culture that supports professional growth, continuous learning, flexibility and meaningful work that improves public outcomes.
POSITION OVERVIEW
Index Analytics is seeking a Database Engineer to design, administer and optimize cloud-based database services supporting a large federal data warehouse. Working with Data Engineers, Cloud Architects, DevSecOps Engineers, security personnel and analytics teams, this role combines database engineering, automation and production administration across Aurora, Postgres, Snowflake and AWS-based services.
RESPONSIBILITIES
Design and maintain database schemas, data models, objects and interfaces that support structured and semi-structured data.
Administer Snowflake and PostgreSQL environments, including user provisioning, role-based access control, row-level security and object permissions.
Develop, review and deploy DDL and database changes through controlled CI/CD and change-management processes.
Write and optimize complex SQL; monitor performance, workload utilization, storage and cost; tune queries and database resources.
Develop Python scripts and infrastructure-as-code components to automate administration, deployment and validation tasks.
Support integration among databases and AWS services such as S3, Secrets Manager and Lambda.
Implement database security, auditing, encryption, retention, backup, recovery and continuity controls in partnership with security teams.
Troubleshoot database access, performance, deployment and production issues; document root cause and corrective action.
Maintain database standards, architecture documentation, runbooks and Confluence content.