Database Engineer

Index Analytics; Baltimore (MD); Híbrido; USD 135 000 - 165 000; Tempo integral

Vantagens oferecidas por esta oferta de emprego

Health benefits

Retirement plan

Professional development reimbursement

Resumo da oferta

Index Analytics, LLC is seeking a Database Engineer to design, administer and optimize cloud-based database services for a large federal data warehouse. You will work with Data Engineers, Cloud Architects, DevSecOps, and analytics teams to manage Snowflake, PostgreSQL and AWS-based databases.

The role emphasizes automation, production operations, security, and cost optimization, with a remote-first setup that supports flexibility while meeting client needs in the Eastern Time zone.

Qualificações

• Bachelor's degree in CS/IT or related field with 8+ years of relevant experience.
• Hands-on Snowflake and SQL experience.
• Experience with AWS cloud services and production databases.
• Experience with performance analysis, query tuning, sizing and cost optimization.
• Experience with Python automation, access controls and database CI/CD.
• Strong analytical, troubleshooting, communication and collaboration skills.

Responsabilidades

• Design and maintain database schemas, data models, objects and interfaces for structured and semi-structured data.
• Administer Snowflake and PostgreSQL environments, including user provisioning and RBAC.
• Develop, review and deploy DDL and database changes through CI/CD and change-management processes.
• Write and optimize complex SQL; monitor performance, workload utilization, storage and cost.
• Develop Python scripts and IaC components to automate administration and deployment tasks.
• Support integration among databases and AWS services (S3, Secrets Manager, Lambda).
• Implement database security, auditing, encryption, retention, backup and continuity controls.
• Troubleshoot access, performance and production issues; document root cause and actions.
• Maintain architecture runbooks and Confluence content.

Conhecimentos

Analytical skills

Troubleshooting

Communication

Collaboration

Formação académica

Bachelor's degree in computer science, information technology, or related discipline

Ferramentas

Snowflake

SQL

AWS

Terraform

CloudFormation

PostgreSQL

Oracle

Teradata

Databricks

Descrição da oferta de emprego

Job Details

Level: Experienced, Job Location: Remote - Baltimore, MD, Education Level: 4 Year Degree, Salary Range: $135000.00 - $165000.00Salary/year, 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.

QUALIFICATIONS: MINIMUM QUALIFICATIONS

• Bachelor's degree in computer science, information technology, or a related discipline and at least eight (8) years of relevant experience, or equivalent specialized experience.
• Hands-on database engineering or administration experience with Snowflake and SQL.
• Experience with AWS cloud services and production database environments.
• Experience with performance analysis, query tuning, sizing and cost optimization.
• Experience with Python automation, access controls and database CI/CD.
• Strong analytical, troubleshooting, communication and collaboration skills.

PREFERRED QUALIFICATIONS

• Experience with PostgreSQL, Oracle, Teradata, Databricks, or other enterprise data platforms.
• Snowflake or AWS certification.
• Experience with Terraform, CloudFormation, data governance, metadata management, or federal health programs.

WORK AUTHORIZATION AND CLEARANCE REQUIREMENTS

Applicants must be legally authorized to work in the United States. Where required by the assigned work, candidates must be able to obtain and maintain a federal client badge and successfully complete a Public Trust background investigation.

LOCATION AND WORK ENVIRONMENT

This position is remote-first and open to candidates residing in the United States. Occasional travel and on-site presence may be required to support client meetings, project activities, training, or other organizational needs. Standard business hours are aligned with Eastern Time; however, availability outside normal business hours may occasionally be required for releases, incidents, deadlines, surge support, or other business-critical situations.

COMPENSATION

The salary range provided represents the anticipated compensation for this role and applies across all geographic locations. Final compensation will be determined based on factors including skills, qualifications, relevant experience, internal equity and market conditions.

In addition to a competitive base salary, Index Analytics offers a comprehensive benefits package that includes medical, dental and vision coverage, retirement savings options, discretionary bonus opportunities and reimbursement for professional development and continuing education.

RECRUITMENT PROCESS AND CANDIDATE NOTICE

We are committed to maintaining a secure, transparent and positive candidate experience. All recruiting-related communications will originate from either an official Index Analytics email address (@index-analytics.com) or our secure recruiting platform (@msg.paycomonline.com). If you have concerns about the legitimacy of a communication, please contact [e-mail].

The organization reserves the rightright to prohibit the use of artificial intelligence (AI) tools during the interview process, including AI-generated responses, automated assistance, or real-time answer generation. We value authentic interactions and seek to evaluate each candidate's individual experience, skills and communication abilities. Unauthorized use of AI tools during interviews may result in removal from consideration.

EQUAL EMPLOYMENT OPPORTUNITY

Index Analytics provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state, or local laws. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation and training.