Overview
Skills
Job Details
Ardent Technologies, Inc. is an accredited small business providing a full range of IT support services, cybersecurity services, staff augmentation, fiscal management, and administrative support. Headquarters in Dayton, OH, near Wright-Patterson Air Force Base, Ardent has served federal, state/local government, commercial, and higher education markets across the US since 2000. Our commitment to excellence, integrity, and client satisfaction drives our growth and yours.
Job Description
- We are currently seeking a highly motivated Senior Database Management Specialist to join our team for a project with our esteemed client. The ideal candidate will possess deep expertise in PostgreSQL, Informatica,MongoDB , Bamboo, Jenkins, Maven, Bitbucket, Jira, GIT, Amazon Web Services, CI/CD, ETL, SQL proven track record of delivering quality results.
Mandatory Skills and Experience:
Minimum Qualifications
- 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 Qualifications
- 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, 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.
Submit your resume to or apply directly through Dice. For immediate consideration, please include Senior Database Management Specialist in the subject line.
Equal Opportunity Employer
Ardent Technologies, Inc., is an equal opportunity employer that relies on the strength of a diverse workforce. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or veteran status.