Talent.com
Database Developer Specialist
Database Developer SpecialistTriTech Enterprise Systems, Inc. • Baltimore, MD, US
Database Developer Specialist

Database Developer Specialist

TriTech Enterprise Systems, Inc. • Baltimore, MD, US
Hace 2 días
Tipo de contrato
  • A tiempo completo
Descripción del trabajo

Job Description

Job Description

  • Candidate must be a U.S. Citizen or have a green card status.

TriTech Enterprise Systems Inc. (TriTech) is seeking a "Senior Database Specialist" to support a Maryland State contract.  This candidate will design, develop, optimize, administer, govern, and maintain complex databases and provide various database operational support services for the Maryland Health Benefit Exchange (HBX) and other systems.

The Maryland Health Benefit Exchange (MHBE), an independent unit of state government, provides accessible, affordable health coverage to Marylanders.  MHBE administers Maryland Health Connection (MHC), the state’s health insurance marketplace. Through MHC, Maryland residents explore health insurance plans, compare rates, and determine their eligibility for advanced premium tax credits (APTC), cost-sharing reductions (CSR), and public assistance programs such as Medicaid and the Maryland Children’s Health Insurance Program (MCHP).

Duties / Responsibilities :

  • Design, develop, and maintain complex enterprise databases, data lakes, and data warehouses.
  • Design complex database architecture, including data modeling, database schema design, and database security.
  • Design, develop, and implement plans for migrating data.
  • Support implementation of data-centric, integrated software, hardware, cloud, and mobile solutions to meet system requirements.
  • Provide database maintenance and operations recommendations for implementing complex web applications, data-sharing initiatives, reports, and dashboards.
  • Review and provide expert support for database integrations to ensure operational and security compliance.
  • Determine usage details and perform supporting tasks for implementing optimizations and cost-reduction strategies for database infrastructure, batches, and product deployments.
  • Collaborate and consult with applications, infrastructure, and system operations teams to help automate the end-to-end operations of applications and systems in AWS Cloud.
  • Develop standards and data scripts to monitor and alert various cloud-based systems and applications to help ensure Service Level Agreements and other performance metrics are met.
  • Design, develop, and support Extract Transform and Load (ETL) processes to extract data from various sources, transform it to meet the needs of the organization, and load complex data elements into multiple databases, data lakes, and data warehouses.
  • Monitor database performance, troubleshoot errors, and debug.
  • Perform tasks in implementing complex data strategies, system development processes, architectural planning, system integration testing, operations, and implementation.
  • Administer HBX databases, including monitoring, backup and recovery, and database security, and optimize the database performance, including identifying and resolving performance issues and ensuring that the database meets performance requirements.
  • Perform tasks ensuring data quality and governance, including creating data validation rules, data quality checks, and metadata management, and understanding the unique data requirements and challenges of the health insurance marketplace.
  • Provide innovative ideas for data extraction, data sharing, and data development approaches, and support database and application integration efforts.
  • Provide data-related support for all system testing efforts, including unit testing, load testing, end-to-end testing, validation testing, and user acceptance testing.
  • Perform PostgreSQL Server database administration, manage role-based (RBAC) user and system accounts, patch Management, and maintain Replication and Disaster Recovery (DR) Environments.
  • Perform Database migration for PostgreSQL and MongoDB databases between various environments, including data centers and cloud environments such as Amazon Web Services (AWS).
  • Monitor all production database activity for operational improvements, including CPU, Disk, and memory, and space utilization.
  • Evaluate and perform security hardening on PostgreSQL and MongoDB databases, including configurations related to access control, authorizations, OS(Linux) Configuration parameters, and file system encryption.
  • Evaluate Security infractions and overall performance of databases to develop and implement corrective measures for database issues / problems found during monitoring.
  • Analyze performance issues in the application and database tiers.
  • Perform disaster recovery principles and practices, including planning and testing backup and restore.
  • Perform hands-on maintenance activities such as vacuum and full vacuum, and analyze the PostgreSQL Database.
  • Perform database server maintenance, including upgrades of the PostgreSQL Database and storage management of PostgreSQL and MongoDB.
  • Perform Installation and maintenance of the MongoDB database for high availability.
  • Develop SQL queries for optimal performance on PostgreSQL, create and manage indices, and develop NoSQL queries on MongoDB and create and manage indices.
  • Actively participate in the deployment playbook development, sequencing, and executing batches, and monitoring system health activities.
  • Work collaboratively with developers and other database team members to define, build consensus around, and implement enterprise systems and application architectures to ensure performance, scalability, maintainability, extensibility, and application integration with external systems.
  • Work closely with cross-functional teams, including developers, data analysts, and business stakeholders, to ensure that the database environment meets the needs of the business and supports the long-term IT strategy.
  • Adhere to all security, change control, and MHBE Project Management Office (PMO) policies, processes, and methodologies.
  • Note : The candidate must be flexible to work overtime as needed, including weekends, holidays, and off-hours.
  • 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 the 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, 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.
  • TriTech is an equal opportunity employer!

    Powered by JazzHR

    gQkKjpvEQZ

    Crear una alerta de empleo para esta búsqueda

    Database Developer Specialist • Baltimore, MD, US

    Ofertas similares
    Vector Database Engineer

    Vector Database Engineer

    VirtualVocations • Baltimore, Maryland, United States
    A tiempo completo
    A company is looking for a Vector Database Engineer.Key Responsibilities Develop and optimize scalable semantic search and retrieval systems using vector databases Implement machine learning pip...Mostrar más
    Última actualización: hace 6 horas • Oferta promocionada • Nueva oferta
    DB2 Database Administrator

    DB2 Database Administrator

    Patriot, LLC • Annapolis Junction, MD, US
    A tiempo completo
    Quick Apply
    Patriot, LLC seems a DB2 DBA with a current Active Secret Clearance to join our team in Annapolis Junction, MD.Requirements Active Secret clearance is required. Due to contract requirements, only US...Mostrar más
    Última actualización: hace 8 días
    Database Engineer 3

    Database Engineer 3

    ClearanceJobs • Linthicum Heights, MD, United States
    A tiempo completo
    CACI is seeking a Database Engineer to be a part of the Secure the Enterprise initiative, develop capabilities to shift from the current manual system security evaluation and authorization process ...Mostrar más
    Última actualización: hace 4 días • Oferta promocionada
    Database Engineer / Oracle Database Administrator - CLEARANCE and POLYGRAPH REQUIRED

    Database Engineer / Oracle Database Administrator - CLEARANCE and POLYGRAPH REQUIRED

    Constellation Technologies, Inc • Fort Meade, MD, United States
    A tiempo completo
    Due to federal contract requirements.United States citizenship and an active TS / SCI security clearance and polygraph are required for the position. Must have TS / SCI clearance w / active polygraph.Bac...Mostrar más
    Última actualización: hace 2 días • Oferta promocionada
    PostgreSQL Database Developer

    PostgreSQL Database Developer

    Contact Government Services, LLC • Baltimore, MD, US
    A tiempo completo
    Employment Type : Full Time, Experienced level.Department : Information Technology.CGS is seeking a PostgreSQL Database Developer to join our team supporting a rapidly growing Data Analytics and Busi...Mostrar más
    Última actualización: hace más de 30 días • Oferta promocionada
    Oracle DBE (ORA-1747-03.021823)

    Oracle DBE (ORA-1747-03.021823)

    Capital Solutions Group • Fort Meade, MD, US
    A tiempo completo
    TS / SCI with Polygraphs are required.Designing and building databases -.Well versed with database concepts as well as database design. Install and configure the database.Strong understanding of...Mostrar más
    Última actualización: hace más de 30 días • Oferta promocionada
    Senior Database Management Specialist

    Senior Database Management Specialist

    California Creative Solutions Inc. • Baltimore, MD, United States
    A tiempo completo
    Quick Apply
    Roles / Responsibilities : Design, develop, and maintain complex enterprise databases, data lakes, and data warehouses.Design complex database architecture,...Mostrar más
    Última actualización: hace 4 días
    Database Engineer

    Database Engineer

    Mount Indie • Linthicum, MD, US
    A tiempo completo
    Help Shape Data-Driven Solutions with Impact.If you're passionate about cloud technologies, open-source databases like MongoDB or MariaDB, and working in agile, mission-driven environments, thi...Mostrar más
    Última actualización: hace más de 30 días • Oferta promocionada
    Database Engineer 0

    Database Engineer 0

    Wyetech • Annapolis Junction, MD, US
    A tiempo completo
    At Wyetech, you’ll be at the center of an award-winning corporate culture, breaking technological barriers and solving real-world problems for our federal government customers.We are committe...Mostrar más
    Última actualización: hace más de 30 días • Oferta promocionada
    Database Management Specialist 2

    Database Management Specialist 2

    DUIT • Glen Burnie, MD, US
    A tiempo completo
    We are on several winning teams.Come join us! Our work environment is limitless, you matter to us, your great work will be recognized, and there are many opportunities for advancement.Davis Unlimit...Mostrar más
    Última actualización: hace más de 30 días • Oferta promocionada
    Senior Database Management Specialist

    Senior Database Management Specialist

    Powersolv Inc • Baltimore, MD, United States
    A tiempo completo
    Quick Apply
    Duties & Responsibilities Design, develop, and maintain complex enterprise databases, data lakes, and data warehouses.Design complex database ...Mostrar más
    Última actualización: hace 4 días
    Senior Database Management Specialist

    Senior Database Management Specialist

    VGroup Inc • Baltimore, MD, United States
    A tiempo completo
    Quick Apply
    For more details, please connect with Soumya Nayak at Senior Database Management Specialist &l...Mostrar más
    Última actualización: hace 4 días
    Database Architect

    Database Architect

    MATRIX SYSTEMS & TECHNOLOGIES INC • Bowie, MD, US
    A tiempo completo
    Candidate must hold MBI Clearance with IRS experience • •.System-Level Software Development.Performance and Capacity Management. Containerization and Cloud Technologies.High Availability and Fault Tol...Mostrar más
    Última actualización: hace más de 30 días • Oferta promocionada
    Mid - Senior Level Database Engineer

    Mid - Senior Level Database Engineer

    Belay Technologies • Annapolis Junction, MD, US
    A tiempo completo
    Belay Technologies has been voted Baltimore Business Journal's (BBJ) Best Places to Work 2019, runner up in 2020 and a finalist in 2021!. Belay Technologies is seeking a Database Engineer to joi...Mostrar más
    Última actualización: hace 13 horas • Oferta promocionada • Nueva oferta
    Database Engineer 3

    Database Engineer 3

    Wyetech LLC • Linthicum Heights, MD, United States
    A tiempo completo
    Database Engineer 3 / h2pAt Wyetech, youll be at the center of an award-winning corporate culture, breaking technological barriers and solving real-world problems for our federal government customers...Mostrar más
    Última actualización: hace 4 días • Oferta promocionada
    Database Engineer / Oracle Database Administrator TS / SCI Polygraph

    Database Engineer / Oracle Database Administrator TS / SCI Polygraph

    Leidos Inc • Annapolis Junction, MD, United States
    A tiempo completo
    Database Engineer / Oracle Database Administrator.Database Engineer / Oracle Database Administrator.Intel Sector's Cyber & Analytics Business Area (CABA). Our talented team is at the forefront in Se...Mostrar más
    Última actualización: hace 7 días • Oferta promocionada
    Senior Database Administrator / Engineer - Exadata

    Senior Database Administrator / Engineer - Exadata

    GliaCell Technologies • Annapolis Junction, MD, US
    A tiempo completo
    Are you a Senior Database Administrator / Engineer who is ready for a new challenge that will launch your career to the next level?. Tired of being treated like a company drone?....Mostrar más
    Última actualización: hace más de 30 días • Oferta promocionada
    Senior Database Engineer

    Senior Database Engineer

    ClearEdge • Annapolis Junction, MD, US
    A tiempo completo
    Join ClearEdge and be part of a mission-focused team solving some of the DoD’s most complex technical challenges.Every day, ClearEdge supports government and industry customers by delivering ...Mostrar más
    Última actualización: hace más de 30 días • Oferta promocionada