Senior Database Engineer– Hybrid-Baltimore MD

Senior Database Engineer– Hybrid-Baltimore MD  

About us 

Creative Information Technology Inc (CITI) is an esteemed IT enterprise renowned for its exceptional customer service and innovation. We serve both government and commercial sectors, offering a range of solutions such as Healthcare IT, Human Services, Identity Credentialing, Cloud Computing, and Big Data Analytics. With clients in the US and abroad, we hold key contract vehicles including GSA IT Schedule 70, NIH CIO-SP3, GSA Alliant, and DHS-Eagle II.

Join us in driving growth and seizing new business opportunities.

Role and Responsibilities 

We are seeking Senior Database Management Specialists with strong experience in designing, developing, maintaining, and optimizing complex databases (PostgreSQL, MongoDB) in cloud environments. This role involves supporting critical systems like Maryland Health Connection, with a focus on data integrity, performance, security, and cost-efficiency.

• Database Architecture & Design: Lead the design, development, and maintenance of complex enterprise databases, data lakes, and data warehouses, including data modelling, 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 analyse 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 centres 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 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 fo