Senior Database Management Specialist

CoreHive Computing, founded in 2003, is a leading technology consulting and solutions organization providing best-in-class IT consulting, advanced and managed services, HPC administration and architecture, cloud migration, and technical support services to organizations in all vertical markets.

CoreHive is seeking a full-time Senior Database Management Specialist to join our team in support of our Maryland-based customer. The Senior Database Management Specialist will design, develop, optimize, administer, govern, and maintain complex databases and provide various database operational support services.

The work location is Baltimore, Maryland and may include a hybrid work model. Flexibility required to work overtime, as needed. Must be eligible to work in the United States and, if selected, successfully complete a background check.

DUTIES AND 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.
• 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.
• 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.
• Perform tasks ensuring data quality and governance.
• 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.
• 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.
• Monitor all production database activity for operational improvements.
• 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.
• 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.

MINIMUM REQUIREMENTS

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