Senior Database Management Specialist
Company: Ashburn Consulting
Location: Baltimore
Posted on: February 17, 2026
|
|
|
Job Description:
Job Description Job Description Company Description Ashburn
Consulting, a Small Business based in the Washington, DC
metropolitan area, specializes in providing network and network
security solutions in complex environments to a select set of
government and business clients. The company, an established leader
in its field, is composed of an elite team of engineers and
business consultants, each of whom is recognized —and highly
regarded—within the network and security communities. Job
Description 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
PostgreSQL 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 PostgreSQL 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 PostgreSQL and MongoDB 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,
and full vacuum, and Analyze the PostgreSQL Database. Perform
database server maintenance, including upgrades of the PostgreSQL
Database and storage management of PostgreSQL and MongoDB. Perform
Installation and maintenance of MongoDB database for high
availability. Develop SQL queries for optimal performance on
PostgreSQL, create and manage indices and develop No SQL queries on
MongoDB and create and manage indices. Actively participate in the
deployment playbook development, sequencing and executing batches,
and monitoring system health activities. Work collaboratively with
developers and other database team members to define, build
consensus around, and implement enterprise systems and application
architectures to ensure performance, scalability, maintainability,
extensibility, and application integration with external systems.
Work closely with cross-functional teams, including developers,
data analysts, and business stakeholders, to ensure that the
database environment meets the needs of the business, and supports
the long-term IT strategy. Adhere to all security, change control,
and MHBE Project Management Office (PMO) policies, processes, and
methodologies. Qualifications A minimum of six (6) years of
experience designing databases, queries, reports, and/or providing
solutions for large-scale enterprise database requirements. A
minimum of four (4) years of experience in a complex environment
building complex data extractions, queries, or databases utilizing
PostgreSQL, Informatica, and MongoDB. A minimum of four (4) years
of experience with tools such as Bamboo, Jenkins, Maven, Bitbucket,
Jira, GIT, etc. A minimum of four (4) years of experience in
document management systems. A minimum of four (4) years of
experience with supporting applications in a Cloud infrastructure
on AWS (Amazon Web Services) and computing AMI virtual machines on
Elastic Compute Cloud (EC2), continuous integration (CI), and
Continuous deployment (CD) processes. A minimum of four (4) years
of experience monitoring production database activities and batch
jobs for operational improvements. A minimum of two (2) years of
experience in large-volume database migration efforts. A minimum of
four (4) years of experience in PostgreSQL Server database
administration, patch management, maintenance, and/or writing
complex SQL codes, stored procedures, and performing data
extractions. A minimum of four (4) years of hands-on experience
with performing database maintenance activities in production
and/or lower environments. Experience with supporting installation
and maintenance of databases for high availability. Strong
understanding of database architecture and design, including
normalization, indexing, partitioning, and replication. Experience
managing and optimizing large databases, including performance
tuning and capacity planning. Experience in data modeling, ETL
processes, and data warehousing. Experience in SQL complex queries
and batch performance optimizations. Additional Information Equal
Opportunity Employer/Veterans/Disabled. An Equal Opportunity
Employer. All qualified applicants will receive consideration for
employment without regard to race, color, religion, sex, sexual
orientation, gender identity, national origin, or protected veteran
status Ashburn Consulting is an Equal Opportunity Affirmative
Action Employer. In compliance with the American with Disabilities
Act Amendments Act (ADAAA), if you have a disability and would like
to request and accommodation in order to apply for a position with
Ashburn Consulting, please e-mail hr@ashburnconsulting.com. ”
Keywords: Ashburn Consulting, Alexandria , Senior Database Management Specialist, IT / Software / Systems , Baltimore, Virginia