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