Senior Database Engineer

Job Description:

Key Responsibilities:

• Database Architecture & Design: Lead the design, development, and maintenance of complex enterprise databases, data lakes, and data warehouses, including data modeling, schema design, and security architecture.
• Data Platform Management: Administer, monitor, and optimize performance for PostgreSQL and MongoDB databases, ensuring high availability, replication, and disaster recovery. This includes managing user accounts, patching, and storage.
• ETL & Data Strategy: Design, develop, and support robust ETL processes for extracting, transforming, and loading complex data into various data stores. Provide innovative ideas for data extraction, sharing, and overall data strategy.
• Cloud & Automation: Automate end-to-end operations of databases and applications in AWS Cloud. Develop standards and scripts for monitoring, alerting, and performance metrics (SLAs).
• Performance & Troubleshooting: Proactively monitor and analyze database and application tier performance, troubleshoot errors, debug, and implement corrective measures.
• Data Quality & Governance: Implement data quality checks, validation rules, and metadata management, ensuring adherence to data governance principles and unique health insurance marketplace requirements.
• Security Hardening: Evaluate and perform security hardening on PostgreSQL and MongoDB, focusing on access control, authorizations, OS configurations, and file system encryption.
• Migration & Testing: Design and implement data migration plans (including PostgreSQL and MongoDB between data centers and AWS). Provide data-related support for all system testing efforts (unit, load, E2E, UAT).
• Collaboration & Compliance: Work collaboratively with cross-functional teams (developers, analysts, stakeholders) to define and implement enterprise data architectures. Adhere strictly to all security, change control, and MHBE PMO policies and methodologies.

Minimum Requirements:

• A minimum of six (6) years of experience designing databases, queries, reports, and/or providing solutions for large-scale enterprise database requirements.
• A minimum of four (4) years of experience in a complex environment building complex data extractions, queries, or databases utilizing PostgreSQL, Informatica, and MongoDB.
• A minimum of four (4) years of experience with tools such as Bamboo, Jenkins, Maven, Bitbucket, Jira, GIT, etc.
• A minimum of four (4) years of experience in document management systems.
• A minimum of four (4) years of experience with supporting applications in a Cloud infrastructure on AWS (Amazon Web Services) and computing AMI virtual machines on Elastic Compute Cloud (EC2), continuous integration (CI), and Continuous deployment (CD) processes.
• A minimum of four (4) years of experience monitoring production database activities and batch jobs for operational improvements.
• A minimum of two (2) years of experience in large-volume database migration efforts.
• A minimum of four (4) years of experience in PostgreSQL Server database administration, patch management, maintenance, and/or writing complex SQL codes, stored procedures, and performing data extractions.
• A minimum of four (4) years of hands-on experience with performing database maintenance activities in production and/or lower environments.
• Experience with supporting installation and maintenance of databases for high availability.
• Strong understanding of database architecture and design, including normalization, indexing, partitioning, and replication.
• Experience managing and optimizing large databases, including performance tuning and capacity planning.
• Experience in data modeling, ETL processes, and data warehousing.
• Experience in SQL complex queries and batch performance optimizations.

Preferred Skills:

• A minimum of five (5) years of experience as a database expert or equivalent designing, developing, performing data extractions, developing reports, and/or supporting federal or state-based marketplace systems or complex health and human services systems or applications.
• A minimum of five (5) years of experience with processing EDI transaction sets such as 834, 820, 999, etc.
• A minimum of four (4) years of experience working with 270/271 Health Care Eligibility Benefit Inquiry and Response transactions.
• A minimum of four (4) years of experience working with complex databases, systems, and applications hosted on Amazon Web Services (AWS).
• A minimum of four (4) years of experience in developing and implementing best practices, data fixes for database issues, and problems found during performance tuning of PostgreSQL DB and MongoDB.
• Experience with or strong knowledge of disaster recovery principles and practices, including planning and validating backup and restoring database backups in production and lower environments.
• A minimum of five (5) years of experience with Integrated Eligibility, Affordable Care Act, or similar large Health and Human Service enterprise level Applications.
• Strong knowledge of Corticon implementations catering to complex business rules.
• Experience optimizing large databases, including performance tuning through complex SQL queries and capacity planning.
• Experience in data modeling, ETL processes, and EDI transaction sets.
• Hands-on experience with PostgreSQL, MongoDB, and SQL complex queries designing, developing, and maintaining large-scale databases, developing complex reports or data extractions.
• Experience with NoSQL database or equivalent, as well as experience in analytics tools such as Tableau, QlikSense, or Power BI.
• Familiarity with the operations of a Health Insurance Exchange (HIX) marketplace, including knowledge of healthcare policies, benefits packages, plan design, eligibility, and enrollment processes and understanding the unique data requirements and challenges of this industry.
• Experience working closely with business stakeholders and other data professionals to establish governance policies and procedures, monitor compliance, and implement data quality checks and controls.
• Experience in developing and maintaining a data dictionary or metadata repository and data governance program to align with best practices and regulatory requirements.
• Experience working with the Project Management Office (PMO) processes, policies, and procedures.