Senior Database Management Specialist

  • Baltimore, MD
  • Posted 4 hours ago | Updated 4 hours ago

Overview

On Site
$120,000 - $142,000
Full Time

Skills

NoSQL
ETL
EDI
PostgreSQL
Bamboo
Jenkins
Jira

Job Details

Outcomes. Delivered.

Voyatek delivers outcome-driven technology solutions to public sector agencies and higher education institutions nationwide.

For example, our technology:

  • Facilitates access to nutritious food for children of mothers participating in the WIC program
  • Supports first responders in reducing opioid overdoses within their communities
  • Empowers colleges and universities to identify and thwart financial aid fraud
  • Equips teachers with valuable insights to identify students requiring additional support
  • Enhances efficiency for state tax agencies, leading to 99% faster return processing and quicker refunds for taxpayers

With a focus on Tax & Revenue, Health & Human Services, and Justice & Public Safety, Voyatek combines the scale to support large complex projects with the agility and accessibility of a boutique solutions provider. Together, Voyatek and its customers work to improve population wellbeing, create safer communities, and foster a thriving economy.

We re more than a technology company -- we re an outcomes company.

We encourage our employees to think differently, ask tough questions, and relentlessly pursue what s best for our customers and the residents they serve.

We believe that the value of technology is defined by its human impact. If you agree, you ve come to the right place.

Voyatek is seeking applicants to occupy the position of Senior Database Management Specialist within our team. Please note that this position requires a commitment to full-time employment and is not open to contractors.

Key Responsibilities:

  • 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.

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.

Preferred Qualifications:

  • 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.

The wage range for this role reflects the wide array of factors considered in compensation decisions. These factors include, but are not limited to, skill sets, experience, training, licensure and certifications, and geographic location. Compensation decisions are based on the unique facts and circumstances of each case. A reasonable estimate of the annual range is $120,000.00 - $142,800.00.

At Voyatek, we believe in supporting our employees with a comprehensive benefits package designed to enhance their well-being and professional growth. Please note that eligibility for certain benefits may vary based on your role and employment status.

  • Flexible Work Schedules
  • Health, Dental, and Vision Insurance
  • Medical, Limited, & Dependent Flexible Spending Accounts (FSA)
  • Health Savings Account (HSA) with Employer Contributions
  • Company-Paid and Voluntary Life Insurance
  • Long and Short-Term Disability Insurance
  • Accident, Critical Illness, & Hospital Indemnity Insurance
  • 401(k) Retirement Plan with Company Match and Immediate Vesting
  • Wellhub Fitness and Wellness Platform
  • Pet Insurance
  • Training Opportunities
  • Employee Referral Bonus Program

We are committed to fostering a workplace that supports both your personal and professional aspirations.

As part of our commitment to maintaining a compliant workplace, all final candidates will undergo and must successfully pass a pre-employment (post offer) background check. The background check may include, but is not limited to, verification of employment history, education, criminal records, and other relevant checks. Background check results will be evaluated in accordance with applicable law. For certain positions, additional client-specific background screenings may be required at the time of hire or in the future, in accordance with client requirements.

If you think you are a good fit for us, we encourage you to apply. Check out our career website for all open positions!

Voyatek provides equal employment opportunities to all employees and applicants for employment. Voyatek will make employment decisions without regard to race, color, creed, ancestry, national origin, citizenship, sex or gender (including pregnancy, childbirth, and pregnancy-related conditions), gender identity or expression (including transgender status), sexual orientation, marital status or domestic violence victim status, religion, age, disability, genetic information, service in the military, or any other characteristic protected by applicable federal, state, or local laws and ordinances. Employment decisions include all terms and conditions of employment, including recruitment and hiring, job assignment/ placement, promotion, upgrading, demotion, termination, layoff, recall, transfer, leave of absence, rates of pay or other compensation, internship, and training.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.