Job Description
The Senior Database Management Specialist
is responsible for the design, development, administration, optimization, and support of complex enterprise database environments. This role supports large-scale data systems, cloud-based infrastructure, data integration initiatives, and enterprise applications. The ideal candidate brings deep expertise in
PostgreSQL, MongoDB, AWS cloud environments, ETL processes, database security, performance tuning, and large-scale data migrations .
Key Duties and Responsibilities Database Architecture & Design Design, develop, and maintain complex enterprise databases, data lakes, and data warehouses. Architect database solutions including
data modeling, schema design, normalization, indexing, partitioning, and replication. Design and implement secure database architectures and access control strategies. Develop and implement data migration strategies across environments including on-premise and cloud platforms. Database Administration & Operations Administer PostgreSQL and MongoDB databases including monitoring, backup and recovery, patch management, replication, and disaster recovery (DR). Perform installation and maintenance of high-availability database environments. Monitor production database activity including
CPU, disk, memory, space utilization, and batch jobs. Perform hands-on database maintenance including
vacuum/full vacuum, analyze operations, and storage management. Upgrade database servers and manage database storage infrastructure. Performance Optimization & Security Analyze and resolve database and application-tier performance issues. Optimize
SQL queries and NoSQL queries ; create and manage indexes. Implement database performance tuning and capacity planning strategies. Conduct security hardening of databases including
access controls, RBAC, OS configuration, encryption, and authorization mechanisms . Evaluate security incidents and implement corrective actions. Cloud & DevOps Support Support applications hosted in
AWS cloud environments
including
EC2
and related services. Collaborate with infrastructure and application teams to automate end-to-end cloud operations. Develop monitoring scripts and alerts to ensure service-level performance targets are met. Participate in CI/CD processes using tools such as
Jenkins, Bamboo, Maven, Bitbucket, Jira, and Git. Contribute to deployment playbooks, batch sequencing, and system health monitoring. Data Engineering & ETL Design, develop, and support
ETL processes
to extract, transform, and load data across enterprise systems. Build complex data extractions, queries, and reports. Support large-volume database migration initiatives. Implement
data quality checks, validation rules, and governance controls. Maintain metadata repositories and data dictionaries. Testing & Integration Provide data-related support for unit testing, load testing, integration testing, validation testing, and user acceptance testing. Review and support database integrations to ensure operational and security compliance. Support complex web applications, dashboards, and data-sharing initiatives. Collaboration & Governance Work closely with developers, analysts, and business stakeholders to align database environments with enterprise IT strategy. Establish and monitor
data governance policies and procedures . Ensure adherence to security and change control processes. Support architectural planning, system integration testing, and implementation activities. Additional Requirements Flexibility to work overtime, including weekends, holidays, and off-hours as required. Requirements Minimum Qualifications
Minimum
six (6) years
of experience designing databases, queries, reports, and solutions for large-scale enterprise environments. Minimum
four (4) years
of experience building complex data extractions and databases using
PostgreSQL, Informatica, and MongoDB . Minimum
four (4) years
of PostgreSQL administration including patch management, complex SQL development, stored procedures, and data extractions. Minimum
four (4) years
of hands-on database maintenance in production and lower environments. Minimum
four (4) years
of experience supporting cloud-based applications in
AWS environments (EC2, CI/CD processes) . Minimum
four (4) years
of experience with
DevOps tools such as Jenkins, Bamboo, Maven, Bitbucket, Jira, and Git. Minimum
four (4) years
of experience in document management systems. Minimum
four (4) years
of monitoring production database activities and batch jobs. Minimum
two (2) years
of experience supporting large-volume database migrations. Strong understanding of database architecture principles including normalization, indexing, partitioning, replication, and high availability. Experience in
data modeling, ETL development, and data warehousing . Experience optimizing
SQL queries and batch performance . Preferred Qualifications Experience supporting large-scale marketplace, eligibility, or health and human services systems. Experience processing
EDI transaction sets such as 834, 820, 999, 270/271 . Strong knowledge of disaster recovery planning and validation of backup/restore processes. Experience implementing best practices and performance tuning strategies for
PostgreSQL and MongoDB . Experience with
NoSQL databases and analytics tools
such as
Tableau, QlikSense, or Power BI . Experience with business rules engines and complex rule implementations. Experience establishing data governance programs, compliance monitoring, and data quality frameworks. Familiarity with integrated eligibility or large enterprise healthcare-related systems. Experience working within structured project management and change control environments.
is responsible for the design, development, administration, optimization, and support of complex enterprise database environments. This role supports large-scale data systems, cloud-based infrastructure, data integration initiatives, and enterprise applications. The ideal candidate brings deep expertise in
PostgreSQL, MongoDB, AWS cloud environments, ETL processes, database security, performance tuning, and large-scale data migrations .
Key Duties and Responsibilities Database Architecture & Design Design, develop, and maintain complex enterprise databases, data lakes, and data warehouses. Architect database solutions including
data modeling, schema design, normalization, indexing, partitioning, and replication. Design and implement secure database architectures and access control strategies. Develop and implement data migration strategies across environments including on-premise and cloud platforms. Database Administration & Operations Administer PostgreSQL and MongoDB databases including monitoring, backup and recovery, patch management, replication, and disaster recovery (DR). Perform installation and maintenance of high-availability database environments. Monitor production database activity including
CPU, disk, memory, space utilization, and batch jobs. Perform hands-on database maintenance including
vacuum/full vacuum, analyze operations, and storage management. Upgrade database servers and manage database storage infrastructure. Performance Optimization & Security Analyze and resolve database and application-tier performance issues. Optimize
SQL queries and NoSQL queries ; create and manage indexes. Implement database performance tuning and capacity planning strategies. Conduct security hardening of databases including
access controls, RBAC, OS configuration, encryption, and authorization mechanisms . Evaluate security incidents and implement corrective actions. Cloud & DevOps Support Support applications hosted in
AWS cloud environments
including
EC2
and related services. Collaborate with infrastructure and application teams to automate end-to-end cloud operations. Develop monitoring scripts and alerts to ensure service-level performance targets are met. Participate in CI/CD processes using tools such as
Jenkins, Bamboo, Maven, Bitbucket, Jira, and Git. Contribute to deployment playbooks, batch sequencing, and system health monitoring. Data Engineering & ETL Design, develop, and support
ETL processes
to extract, transform, and load data across enterprise systems. Build complex data extractions, queries, and reports. Support large-volume database migration initiatives. Implement
data quality checks, validation rules, and governance controls. Maintain metadata repositories and data dictionaries. Testing & Integration Provide data-related support for unit testing, load testing, integration testing, validation testing, and user acceptance testing. Review and support database integrations to ensure operational and security compliance. Support complex web applications, dashboards, and data-sharing initiatives. Collaboration & Governance Work closely with developers, analysts, and business stakeholders to align database environments with enterprise IT strategy. Establish and monitor
data governance policies and procedures . Ensure adherence to security and change control processes. Support architectural planning, system integration testing, and implementation activities. Additional Requirements Flexibility to work overtime, including weekends, holidays, and off-hours as required. Requirements Minimum Qualifications
Minimum
six (6) years
of experience designing databases, queries, reports, and solutions for large-scale enterprise environments. Minimum
four (4) years
of experience building complex data extractions and databases using
PostgreSQL, Informatica, and MongoDB . Minimum
four (4) years
of PostgreSQL administration including patch management, complex SQL development, stored procedures, and data extractions. Minimum
four (4) years
of hands-on database maintenance in production and lower environments. Minimum
four (4) years
of experience supporting cloud-based applications in
AWS environments (EC2, CI/CD processes) . Minimum
four (4) years
of experience with
DevOps tools such as Jenkins, Bamboo, Maven, Bitbucket, Jira, and Git. Minimum
four (4) years
of experience in document management systems. Minimum
four (4) years
of monitoring production database activities and batch jobs. Minimum
two (2) years
of experience supporting large-volume database migrations. Strong understanding of database architecture principles including normalization, indexing, partitioning, replication, and high availability. Experience in
data modeling, ETL development, and data warehousing . Experience optimizing
SQL queries and batch performance . Preferred Qualifications Experience supporting large-scale marketplace, eligibility, or health and human services systems. Experience processing
EDI transaction sets such as 834, 820, 999, 270/271 . Strong knowledge of disaster recovery planning and validation of backup/restore processes. Experience implementing best practices and performance tuning strategies for
PostgreSQL and MongoDB . Experience with
NoSQL databases and analytics tools
such as
Tableau, QlikSense, or Power BI . Experience with business rules engines and complex rule implementations. Experience establishing data governance programs, compliance monitoring, and data quality frameworks. Familiarity with integrated eligibility or large enterprise healthcare-related systems. Experience working within structured project management and change control environments.