Job Description

Job Role : Senior Database Management Specialist

Experience : 6+ Yrs

Location : Maryland (Onsite)

Preferred : USC/GC/H1B.

Qualifications:

• 6+ years of experience in designing databases, writing complex queries and reports, and delivering scalable enterprise database solutions.
• 4+ years of experience building complex data extractions and queries using PostgreSQL , Informatica , and MongoDB in enterprise environments.
• 4+ years of experience with CI/CD tools such as Jenkins , Maven , Bamboo , Bitbucket , Git , JIRA , etc.
• 4+ years of experience performing database maintenance in production and lower environments, including monitoring batch jobs and production activity for operational improvements.
• 4+ years of experience in document management systems and related integrations
• . 2+ years of experience leading or contributing to large-volume database migration efforts.
• Proven hands-on experience with PostgreSQL administration , including patch management, performance tuning, writing stored procedures, and maintaining high-availability setups.
• Solid understanding of database architecture and design , including normalization, indexing, partitioning, and replication.
• Proficient in data modeling , ETL processes , data warehousing , and SQL performance optimization .
• Experience supporting applications on AWS cloud infrastructure , including AMI , EC2 , CI/CD pipelines , and cloud-native operations.

Key Responsibilities:

• Design, develop, and maintain enterprise databases , data lakes , and data warehouses , including schema design, data modeling, and security architecture.
• Build and manage ETL pipelines , data migration plans, and database integrations to support data-driven applications and reporting solutions.
• Administer PostgreSQL and MongoDB databases, including backup/recovery, replication, DR environments, role-based access control (RBAC), patching, and performance tuning.Monitor and optimize database performance (CPU, memory, disk, indexing), analyze logs, and resolve bottlenecks in both application and database tiers.
• Ensure data quality and governance via validation rules, metadata management, and adherence to industry compliance standards.
• Implement security hardening and access controls in PostgreSQL and MongoDB;
• Perform audits and resolve security infractions.Collaborate with DevOps teams to automate database operations in AWS Cloud , monitor systems, and maintain SLAs.
• Perform database server maintenance tasks (e.g., upgrades, vacuum, analyze) and storage management.
• Develop optimized SQL and NoSQL queries, create indexes, and support both structured and unstructured data needs.
• Support full system testing efforts (unit, integration, UAT), and work closely with cross-functional teams to align data solutions with business goals.
• Lead planning and execution of disaster recovery , ensure system reliability, and contribute to deployment playbooks and batch execution sequencing.
• Provide innovative solutions for data extraction, sharing , and infrastructure cost optimization.

Participate in architectural planning to ensure scalability, maintainability , and integration with external systems, particularly in the health insurance marketplace domain.

Job Tags

Similar Jobs