Job Role: Senior Database Management Specialist
Location: Baltimore, MD
Job Type: Contract/Hybrid
Job Description:
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.
Prefered 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.