Senior Database Engineer (DBA) with SQL/NoSQL and Linux experience

LED FastStart • Louisiana, MO

11h • Remote

About The Position

We are seeking an experienced Senior/Principal Database Engineer to join our Scientific Modeling, Application, Visualization, Computational Science, Software, and Statistical Support (SMAVCS4) Team to support the Environmental Protection Agency's Office of Chemical Safety and Pollution Prevention (OCSPP), a scientific organization working to support Agency decisions by providing solutions-driven research to rapidly evaluate the potential human health and environmental risks due to exposures to environmental chemicals and ensure the integrity of the freshwater environment and its capacity to support human well-being.
The selected candidate will interface with the EPA Product Team and developers and will be responsible for, but not limited to, installation, capacity planning, configuration, database design, migration, performance monitoring, security, administration & management of user accounts, troubleshooting, disaster recovery as well as backup and data recovery to ensure the availability and consistent performance of OCSPP’s software and applications.
The selected candidate for this role must have a high degree of attention to detail as well as a collaborative and solution-oriented working style.
Description of Function:
Install, configure, administer, manage, and document MySQL, PostgreSQL, NoSQL (MongoDB) in a Master with Replicas configuration across several nodes already procured by CCTE for high availability and high-performance scenarios
Independently analyze, solve, and correct issues in real time, providing end-to-end problem resolution
Advise Division management officials regarding integration of IT programs with other programs of equivalent scope and complexity. Lead engineering and architecture activities related to database performance monitoring & optimization
Develop new theories, concepts principles and work methods to significantly improve relational and non-relational data stores for designing, configuring, implementing, and documenting relational and non-relational data stores consisting of main-replica systems. Manage database assets including maintenance of inventory and related documentation

Requirements

• Must have experience working in Linux environments
• Strong command-line experience including AWS CLI, PowerShell, and Unix shell scripting skills
• Experience with Administering SQL (e.g., PostgreSQL, MySQL, etc.) and NoSQL (e.g., MongoDB) technologies
• Ability to perform complex command-line scripts and perform SQL queries
• Experience with AWS RDS Administration
• Ability to thrive in an environment without a database management service
• Advanced knowledge of database security, backup and recovery, and performance monitoring standards
• Ability to prioritize and complete a wide variety of tasking workloads with critical deadlines
• Excellent critical thinking and problem-solving skills
• Superior communications skills, and a demonstrated ability to maintain a patient and professional demeanor, with a can-do attitude
• Ability to communicate technical concepts clearly and professionally to both technical and non-technical parties (who may be key stakeholders)
• Ability to manage equipment and services in remote locations
• Ability to work effectively in a remote team environment
• Workability to perform well under pressure
• Strong customer service orientation
• Ability to maintain an organized workflow, with a high degree of attention to detail

Nice To Haves

• Experience with MongoDB OpsManager is highly preferred
• Experience working on Federal Sector Contracts
• Professional Certification(s)
• Familiarity with DevOps, ITIL Agile processes

Responsibilities

• Provide expert level DBA services for production, stage, and development databases across all platforms.
• Works closely with senior developers and data modelers to perform physical database design for critical business applications/databases with the largest numbers of interfaces and users and complex query tuning and schema
• Use expert communication and collaboration skills to advise leadership regarding integration of IT programs with other programs of equivalent scope and complexity; lead engineering and architecture activities; provide domain and technical expertise, provide technical mentorship and cross-training to peers and team members
• Work involves analyzing the user experience of a variety of Agency IT programs and recommending design changes that can enhance the user experience
• Advanced knowledge of database security, backup and recovery, and performance monitoring standards

Benefits

• Our benefits package for all US-based employees includes a variety of medical plan options, some with Health Savings Accounts, dental plan options, a vision plan, and a 401(k) plan offering the ability to contribute both pre and post-tax dollars up to the IRS annual limits and receive a company match.
• To encourage work/life balance, GDIT offers employees full flex work weeks where possible and a variety of paid time off plans, including vacation, sick and personal time, holidays, paid parental, military, bereavement and jury duty leave.
• GDIT typically provides new employees with 15 days of paid leave per calendar year to be used for vacations, personal business, and illness and an additional 10 paid holidays per year.
• Paid leave and paid holidays are prorated based on the employee’s date of hire.
• The GDIT Paid Family Leave program provides a total of up to 160 hours of paid leave in a rolling 12 month period for eligible employees.
• To ensure our employees are able to protect their income, other offerings such as short and long-term disability benefits, life, accidental death and dismemberment, personal accident, critical illness and business travel and accident insurance are provided or available.
• We regularly review our Total Rewards package to ensure our offerings are competitive and reflect what our employees have told us they value most.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level