The Level 3 Database Engineer (DE) shall possess the following capabilities:
• Support the database design, development, implementation, information storage and retrieval, data flow and analysis activities
• Support the analysis and evaluation of system improvements, optimization, development and/or maintenance efforts
• Support the development of long and short term requirements for database administration and design
• Assist in developing databases, database parser software, and database loading software
• Translate a set of requirements and date into a usable database schema by creating or recreating ad hoc queries, scripts and macros, updates existing queries, creates new ones to manipulate data into a master file
• Assist in developing database structures that fit into the overall architecture of the system
under development
• Lead development of database structures that fit into the overall architecture of the system
tinder development
• Lead development of databases, database parser software, and database loading software
• Develop requirement recommendations from a projects inception to its conclusion for a
particular Business and IT subject matter area (i.e. simple to complex systems)
• Develop a database structure that fits into the overall architecture of the system under
development and has to make trades among data volumes, number of users, logical and
physical distribution, response times, retention rules, security and domain controls
• Direct fulfillment of requirements from a project’s inception to it conclusion
• Direct organization of requirements and data into a usable database schema by directing
development of ad hoc queries, scripts, macros, updates to existing queries
• Direct the overall database structure that fits into the overall architecture of the system
under development and has to make trades among data volumes, number of users, logical
and physical distribution, response times, retention rules, security and domain controls
• Direct the development of complex systems using queries, tables, Open Database
Connectivity and database storage and retrieval using Cloud methodologies
- Salary Range: $190,000-$215,000
QUALIFICATIONS:
Ten (10) years’ experience as a DBE in programs and contracts of similar scope, type, and complexity is required. Bachelor’s degree in a technical discipline from an accredited college or university is required. Five (5) years of DBE experience may be substituted for a bachelor’s degree.
Task Required Skills
- Experience using the Linux CLI
- Experience writing scripts using Bash/Python
- Minimum 3 years RDBMS administration experience
- Minimum 3 years NoSQL database administration experience
- Experience with the planning, data modeling and development of database tables into usable database schemas
- Experience developing complex ad hoc queries for database storage and retrieval
- Experience with Performance Tuning and Optimization (PTO) using native database monitoring and troubleshooting tools
- Knowledge of database backup and restore best practices
- Knowledge of database High Availability (HA) and Disaster Recovery (DR) best practices
- Experience with troubleshooting and sustaining one or more databases in a critical Linux production environment
- Familiar with testing various processing, storage, and retrieval systems using backend databases such as MySQL, Elasticsearch, MongoDB, OpenTSDB, and ArrangoDB