Database Management Specialist

Job Title: Database Management Specialist (PostgreSQL)

Location: Baltimore, MD (Hybrid, 3 Days onsite, 2 days remote)

Duration/Type: Contract

Pay Rate: Best as per Market

Rate $80/hr C2C

Must Have:

• Need 3 Professional References from current one project only.
• Local or willing to relocate are also welcome.

Need Consultant from Healthcare domain Familiarity with below standards.

• Health and human services systems or applications.
• EDI transaction sets such as 834, 820, 999, etc.
• 270/271 Health Care Eligibility Benefit Inquiry and Response transactions.
• Integrated Eligibility, Affordable Care Act, or similar large Health and Human Service enterprise level Applications.

Job Summary:

A PostgreSQL (Database Management Specialist) to support database design, administration, optimization, and operational support across enterprise systems.

Minimum Qualification:

• 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.

Desired Qualification:

• 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.