Database Management SpecialistMATRIX SYSTEMS & TECHNOLOGIES INC • Baltimore, MD, US
Database Management Specialist
MATRIX SYSTEMS & TECHNOLOGIES INC • Baltimore, MD, US
4 days ago
Job type
- Full-time
Job descriptionDesign, 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. 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. A minimum of five (5) years of experience as a database expert or equivalent designing, developing, performing data extractions, developing reports, and / or supporting federal or state-based marketplace systems or complex health and human services systems or applications. A minimum of five (5) years of experience with processing EDI transaction sets such as 834, 820, 999, etc. A minimum of four (4) years of experience working with 270 / 271 Health Care Eligibility Benefit Inquiry and Response transactions. A minimum of four (4) years of experience working with complex databases, systems, and applications hosted on Amazon Web Services (AWS). A minimum of four (4) years of experience in developing and implementing best practices, data fixes for database issues, and problems found during performance tuning of PostgreSQL DB and MongoDB. Experience with or strong knowledge of disaster recovery principles and practices, including planning and validating backup and restoring database backups in production and lower environments. A minimum of five (5) years of experience with Integrated Eligibility, Affordable Care Act, or similar large Health and Human Service enterprise level Applications. Strong knowledge of Corticon implementations catering to complex business rules. Experience optimizing large databases, including performance tuning through complex SQL queries and capacity planning. Experience in data modeling, ETL processes, and EDI transaction sets. Hands-on experience with PostgreSQL, MongoDB, and SQL complex queries designing, developing, and maintaining large-scale databases, developing complex reports or data extractions. Experience with NoSQL database or equivalent, as well as experience in analytics tools such as Tableau, QlikSense, or Power BI. Familiarity with the operations of a Health Insurance Exchange (HIX) marketplace, including knowledge of healthcare policies, benefits packages, plan design, eligibility, and enrollment processes and understanding the unique data requirements and challenges of this industry. Experience working closely with business stakeholders and other data professionals to establish governance policies and procedures, monitor compliance, and implement data quality checks and controls. Experience in developing and maintaining a data dictionary or metadata repository and data governance program to align with best practices and regulatory requirements. Experience working with the Project Management Office (PMO) processes, policies, and procedures.
Benefits :
- Health insurance
- Paid time off
- Training & development
Duties / Responsibilities :
Qualifications :
Create a job alert for this search
Database Management Specialist • Baltimore, MD, US
Similar jobs
Oracle Database Administrator with 10+ years Oracle database administration experience supporting large scale or enterprise level database services.
Practice / Technical Director provides technology a...Show more
Project Manager - Healthcare Construction - St.This Jobot Job is hosted by : Kelly Anne Wight.Are you a fit? Easy Apply now by clicking the "Apply" button and sending us your resume.Salary : $100,000...Show more)
Employment Type : Full Time, Mid-Level.Department : Information Technology.CGS is seeking a Senior FOIA Analyst to join our team supporting the legal mission of a large federal agency.The successful ...Show more
Rowe Price, we identify and actively invest in opportunities to help people thrive in an evolving world.As a premier global asset management organization with more than 85 years of experience, we p...Show more
Are you a Senior Database Administrator / Engineer who is ready for a new challenge that will launch your career to the next level?.
Tired of being treated like a company drone?....Show more
We are a gambling technology company looking for individuals to join our focus group on an.You will earn $800 to $1,200 for about 20 hours of participation, with opportunities for continued.This is...Show more
A technology solutions provider in Jessup, Maryland is seeking an experienced Senior Database Engineer to design and maintain crucial databases.
The successful candidate will have over 10 years of e...Show more
Due to federal contract requirements.United States citizenship and an active TS / SCI security clearance and polygraph are required for the position.
Must have TS / SCI clearance w / active polygraph.Bac...Show more
MANTECH seeks a motivated, career and customer-oriented Oracle Database Administrator to join our team in the Ft.In this role, you will provide technical expertise for database design, development,...Show more
A government agency is seeking an IT Specialist (APPSW) to design, develop, and maintain mainframe applications using COBOL and related technologies.
The role involves supporting data integration an...Show more
Poly Required Ten (10) years' experience as a DBE in programs and contracts of similar scope, type, and complexity is required.
Bachelor's degree in a technical discipline from an accredited college...Show more
The Database Engineer provides technical expertise in database design, development, implementation, information storage and retrieval, and data flow / analysis.
This role develops relational and / or ob...Show more
Senior Treasury Management Sales Analyst.This is a full-time, hybrid career opportunity based out of one of our Fulton Bank locations within our five-state footprint of PA, NJ, DE, MD, VA.Typical w...Show more
Job Title : Database Management Specialist (PostgreSQL) Location : Baltimore, MD (Hybrid, 3 Days onsite, 2 days remote) Dur...Show more
Join TurboTax as a TurboTax Product Expert and be the friendly face our customers rely on during tax season.We're looking for individuals with excellent communication skills and a passion for assis...Show more
Peraton is hiring a skilled Systems Engineer (SE) that has experience planning for and managing data storage solutions.The SE will support our customer's large High Performance Computing (HPC) rela...Show more
Database Engineer (MongoDB or MariaDB).Themis Insight solves difficult business, IT, and analytic problems by addressing the whole problem not just the symptoms using interdisciplinary approaches t...Show more
Maximus is a trusted federal partner supporting mission?critical programs across national security, defense, and public service delivery.
Recent contract awards in cybersecurity and operational read...Show more
Sr. Database Admin / Engineer - Exadata
Columbia Technology Partners • Annapolis Junction, MD, USA
Full-time
Quick Apply
Last updated: 10 days ago
Tax Manager
Jobot • Sparks, MD, US
Full-time
Last updated: 10 days ago • Promoted
Senior FOIA Analyst
CGS Federal (Contact Government Services) • Baltimore, MD, United States
Full-time
Last updated: 2 days ago • Promoted
Senior Manager, Problem Management
T. Rowe Price • Baltimore, MD, United States
Full-time
Last updated: 6 days ago • Promoted
Senior Database Administrator / Engineer - Exadata
GliaCell Technologies • Annapolis Junction, MD, MD, US
Full-time
Quick Apply
Last updated: 30+ days ago
Research Study Participant
Reel Edge • Shrewsbury, PA, US
Full-time +1
Last updated: 30+ days ago • Promoted
Senior Database Engineer TS / SCI Poly, Cloud Systems
DeNovo Solutions, LLC • Jessup, MD, United States
Full-time
Last updated: 5 days ago • Promoted
Database Engineer / Oracle Database Administrator - CLEARANCE and POLYGRAPH REQUIRED
Constellation Technologies, Inc • Fort Meade, MD, United States
Full-time
Last updated: 11 days ago • Promoted
Oracle Database Administrator
Maryland Staffing • Fort Meade, MD, United States
Full-time
Last updated: 3 days ago • Promoted
Mainframe Modernization & AI Dev Specialist
Social Security Administration • Gwynn Oak, MD, United States
Full-time
Last updated: 11 days ago • Promoted
Database Engineer
ClearanceJobs • Fort Meade, MD, United States
Full-time
Last updated: 8 days ago • Promoted
Database Engineer (DE)
Avint LLC • Fort Meade, MD, United States
Full-time
Last updated: 3 days ago • Promoted
Senior Treasury Management Sales Analyst
New Jersey Staffing • Cockeysville, MD, United States
Full-time
Last updated: 1 day ago • Promoted
Database Management Specialist
Gov Services Hub • MD, United States
Full-time
Quick Apply
Last updated: 3 days ago
Remote TurboTax Product Expert - Schedule of Your Choice
Intuit - TurboTax • New Freedom, PA, US
Remote
Full-time
Last updated: 20 days ago • Promoted
Data Storage Planning & Management Senior High Performance Computing Systems Engineer
Peraton • Fort Meade, MD, United States
Full-time
Last updated: 6 days ago • Promoted
Sr. Database Engineer (MongoDB or MariaDB)
Themis Insight LLC • Linthicum Heights, MD, United States
Full-time
Last updated: 6 days ago • Promoted
Database Engineer
MAXIMUS • Fort Meade, MD, United States
Full-time
Last updated: 20 hours ago • Promoted • New!