Senior Database Management Specialist

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 over