Sr. Database Management Specialist (Hybrid Schedule)

Description

Description

COMSO, Inc. is a powerhouse when it comes to empowering federal government stakeholders to fulfill their mission with confidence and efficiency. Our staff brings knowledgeable IT systems expertise, software development proficiency, innovative learning solutions for workforce development, and exceptional operations and production support. We were founded in 1988, and remain a recognized woman owned small business, operating in several states including Maryland, Georgia, Hawaii, Texas, and Alaska. We are honored to be recognized as a Top Workplace for eight years running by the Baltimore Sun Media Group.

Please note: This position has a firm application deadline of February 17th, and the posting period may be shorter than usual.

Qualifications:

• U.S. CITIZENSHIP IS REQUIRED

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

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