Database Administrator

Company: Spatial Front
Location: Washington
Posted on: November 23, 2021

Job Description:

The National Highway Traffic Safety Administration (NHTSA) is an agency of the U.S. Department of Transportation (DoT). Within NHTSA, the Office of Defects Investigation (ODI) strives to successfully manage information processing challenges that effectively meet statutory obligations and deadlines while processing increasing volumes and managing the complexities of incoming information and an expanding user base. The ability to identify serious safety defects early in the vehicle/equipment component production cycle and to influence recalls early in the cycle depends largely on the efficient use of information processing resources that provide NHTSA staff with the maximum information available on a particular subject as soon as possible after identifying the possibility of a defect.Candidates for Database Administrator Position will be contributing to the Operations and Maintenance of mission critical databases, as well as updating them for sustained product life.Summary of Work: Ensure the stability and availability of mission critical on-prem and could based Oracle and future state databases. Work as an essential part of the O&M team to resolve data dependencies associated with system defects and outages. Preserve and test the health of the databases and ensure their security and integrity. Cloud experience is a must have.Primary Responsibilities:Configure, test, deploy, and validate Oracle cluster and standalone database upgradesInstall, configure, and apply all required security patchesPerform critical maintenance and database upgrades to preserve system uptimePerform routine maintenance and database upgrades to ensure system healthPerform daily database health checks in concert with the rest of the O&M teamProvide consultation and guidance regarding best approaches to database maintenance and upgrades including, but not limited to LOE and time to resolveResolve configuration issues and triage to resolution data centered or data adjacent defectsProvide break/fix support to Government equipmentSupport and update/upgrade AWS Cloud database instancesRoutine database administration, including running ad hoc queries on demand, technical troubleshooting, and root cause analysisData migration responsibilities include: troubleshoot DMS issues, backup & restore backups, Cloud watch logsCoding Cloudformation templates for DMS and AlarmsCoding in Postgres databaseRequirements:Priority of skill set (must have)Knowledge of DMS (Data Migration System)Should able to: troubleshoot DMS Issue review cloud watch logs review RDS and DMS alarm and coordinate necessary actions code Stored functions, ad-hoc queries and tune-up functions/code in Postgres databasePostgres Database expertiseCode Cloudformation template for DMS, and AlarmsAdvanced expert on Oracle WebLogic, Oracle Fusion Middleware, Oracle Database and SQL ServerExpert with Red Hat Enterprise Linux servers and Window 2008+ ServersDatabase Exports and Imports, Database Archiving Skills, Provisioning DatabasesSQL TuningPL/SQL Development: Experience writing & modifying stored procedures and SQL functionsAbility to quickly diagnose and troubleshoot issues with customer equipmentAbility to install hardware components and peripheralsMust be able to work a shift between 7:00 am - 5:00 pm M-F Eastern TimeMust be able to occasionally work outside of core hours for systems upgrades or in response to a system outageEducation/Experience:B.S. Computer Engineering or equivalentMicrosoft Azure experience is a plusExcellent follow-throughProfessional appearanceTakes initiative and can work independentlyMust be able to multi-task and manage time amongst clientsFlexibility and ability to pivot between projects quicklyAll candidates will be subject to a complete background check to include, but not limited to Criminal History, Education Verification, Professional Certification Verification, Verification of Previous Employment and Credit History.Public Trust is required for this position. Must have lived in the US for the past three (3) years.As a Federal Contractor, all Spatial Front Employees are required to be fully vaccinated against Covid-19 and provide proof of vaccination prior to the first date of employment.EOE/AA/M/F/D/VSpatial Front Inc. participates in E-Verify***NO THIRD-PARTIES/AGENCIES/C2C PLEASE***

Keywords: Spatial Front, Washington DC , Database Administrator, IT / Software / Systems , Washington, DC