Database Management Specialist
hace 3 días
Baltimore
Job Description Database Management Specialist Full-Time | Hybrid (Onsite & Remote) Location: Baltimore, MD (onsite days required) Overview We are seeking an experienced Database Management Specialist to design, administer, optimize, and support complex enterprise database environments supporting large-scale, mission-critical systems. This role requires deep hands-on expertise with PostgreSQL and MongoDB in cloud-hosted environments, strong operational discipline, and the ability to support production systems with high availability, security, and performance requirements. This is a senior-level role in scope and responsibility, though the title has been intentionally kept streamlined. What You’ll Do • Design, develop, administer, and maintain complex enterprise databases, data lakes, and data warehouses, • Architect database schemas, data models, security structures, and replication strategies, • Administer PostgreSQL and MongoDB databases, including installation, upgrades, patching, backup/recovery, replication, and disaster recovery, • Perform database performance monitoring, tuning, troubleshooting, and capacity planning in production and lower environments, • Support large-scale data migrations across on‐prem and cloud environments (AWS), • Design and support ETL processes and complex data extractions, • Develop and optimize complex SQL and NoSQL queries, indices, and batch jobs, • Monitor production database activity (CPU, memory, disk, space utilization) and implement operational improvements, • Implement and support high-availability database architectures, • Apply database security hardening practices, including access controls, encryption, OS-level configurations, and compliance remediation, • Support application deployments, CI/CD pipelines, and batch sequencing activities, • Collaborate closely with developers, infrastructure teams, system operations, and business stakeholders, • Participate in testing efforts including unit, integration, load, validation, and UAT testing, • Adhere to security, change control, and project management policies, • Provide on-call or after-hours support as required (evenings, weekends, holidays) Required Experience & Qualifications (Non‐Negotiable) Candidates must meet all minimum requirements below to be considered: • 6+ years of experience designing and supporting enterprise-scale databases, • 4+ years of hands-on experience with:, • PostgreSQL database administration (production environments), • MongoDB, • Complex SQL development, stored procedures, and performance tuning, • 4+ years of experience building complex data extractions, queries, or databases using PostgreSQL, Informatica, and MongoDB, • 4+ years of experience supporting applications in AWS cloud environments (EC2, AMIs, CI/CD), • 4+ years of experience monitoring production databases and batch operations, • 4+ years of hands-on database maintenance experience (production and lower environments), • 2+ years of experience supporting large-volume database migrations, • Experience with high-availability database environments, • Strong understanding of database architecture, normalization, indexing, partitioning, and replication, • Experience with ETL processes and data warehousing concepts, • Experience with CI/CD and development tools such as Jenkins, Bamboo, Maven, Git, Bitbucket, Jira, etc., • Experience working in structured, regulated environments with formal change control Preferred Experience (Highly Desired) • Experience supporting state or federal health systems, marketplaces, or large human services platforms, • Experience with EDI transactions (834, 820, 999, 270/271), • Experience supporting health insurance exchange (HIX) systems, • Strong understanding of data governance, data quality controls, and metadata management, • Experience with disaster recovery planning and validation, • Experience optimizing large databases for performance and scalability, • Familiarity with analytics and reporting tools (e.g., Tableau, Power BI, Qlik), • Experience working closely with PMOs and enterprise stakeholders Work Authorization Requirements (Strict) Due to contractual and background investigation requirements: • Candidates must be legally authorized to work in the United States without sponsorship, • No H‐1B, F‐1, CPT, OPT, or other temporary work authorization candidates will be considered, • Proof of eligibility to work in the U.S. will be required Location & Relocation Expectations This is a hybrid role requiring regular onsite presence in Baltimore, MD and availability for on-call support. Relocation assistance is not provided. Candidates must already reside within reasonable commuting distance or be willing and able to relocate at their own expense prior to the start date. Priority consideration will be given to candidates who are local or can relocate without restrictions or delays. Background & Compliance Requirements This role requires access to sensitive federal information. Employment is contingent upon: • Favorable FBI fingerprint‐based criminal background check, • Citizenship / residency verification confirming legal eligibility to work in the U.S., • Local law enforcement background check, • Ongoing compliance with reporting requirements Application & Documentation Requirements (Read Carefully) To be considered, candidates must be willing and able to provide all of the following: • Detailed resume aligned to the requirements above, • Three (3) professional references (will be contacted), • Copy of bachelor’s degree (mandatory), • Copies of certifications (if applicable) Additional Notes • Hybrid role with onsite presence required in Baltimore, MD, • Standard work hours with flexibility for after-hours support as needed, • Only one candidate may be submitted for this opportunity, • No third‐party or layered subcontracting arrangements are permitted If you meet the requirements above and are prepared for a senior‐level database role with significant responsibility and impact, we encourage you to apply.Company DescriptionTenacity Solutions, LLC (Tenacity) is a Service-Disabled Veteran Owned Small Business (SDVOSB) founded by our CEO, Gabriel Brown, CAPT, USN (Ret). Tenacity is an innovative company, leveraging talent, skill, and knowledge with cutting-edge and proven practices to deliver solutions and products that exceed customers’ requirements and surpasses their expectations. Tenacity immediately has become a leading technology and management solutions provider with a mission to advance healthcare services for specialized populations including Veterans and their families. Headquartered in North, Bethesda, Maryland (DMV), our talented resources are located across the United States. We bring diverse talent to design solutions that help customers with their greatest challenges.Tenacity Solutions, LLC (Tenacity) is a Service-Disabled Veteran Owned Small Business (SDVOSB) founded by our CEO, Gabriel Brown, CAPT, USN (Ret). Tenacity is an innovative company, leveraging talent, skill, and knowledge with cutting-edge and proven practices to deliver solutions and products that exceed customers’ requirements and surpasses their expectations. Tenacity immediately has become a leading technology and management solutions provider with a mission to advance healthcare services for specialized populations including Veterans and their families. Headquartered in North, Bethesda, Maryland (DMV), our talented resources are located across the United States. We bring diverse talent to design solutions that help customers with their greatest challenges.