Senior Database Management Specialist

Overview

Diverse Agile Solutions is seeking a Senior Database Management Specialist to 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.

• 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 Postgre
  
  SQL 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 Postgre
  
  SQL and Mongo DB 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 Postgre
  
  SQL and Mongo
  
  DB 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, full vacuum, and analyze the Postgre
  
  SQL Database.
• Perform database server maintenance, including upgrades of the Postgre
  
  SQL Database and storage management of Postgre
  
  SQL and Mongo
  
  DB.
• Develop SQL queries for optimal performance on Postgre
  
  SQL, create and manage indices and develop No SQL queries on Mongo
  
  DB and create and manage…