DATABASE ENGINEER

All levels of Database Engineer will have one or more of the responsibilities listed below, depending upon the specifics required for each position. Each level may have additional education, skill and/or experience requirements.

The Database Engineer provides technical expertise for database design, development, implementation, information storage and retrieval, data flow and analysis. Develops relational and/or Object-Oriented databases, database parser software, and database loading software. Projects long-range requirements for database administration and design. Responsible for developing 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. The Database Engineer works primarily at the front end of the lifecycle-requirements through system acceptance testing and Initial Operational Capability (IOC). Develops requirements from a project’s inception to its conclusion for a particular business and Information Technology (IT) subject matter area (i.e., simple to complex systems). Assist with recommendations for, and analysis and evaluation of systems improvements, optimization, development, and/or maintenance efforts. Translates a set of requirements and data into a usable document by creating or recreating ad hoc queries, scripts, and macros; updates existing queries, creates new ones to manipulate data into a master file; and builds complex systems using queries, tables, Open Database Connectivity and database storage and retrieval using Cloud methodologies.

REQUIRED SKILLS:

• Active Top Secret/Sensitive Compartmented Information (TS/SCI) security clearance required.
• U.S. Citizenship required.
• Apache Hadoop, PostgresSQL, MYSQL or VMware or Oracle DBMS knowledge
• Possess knowledge of SQL Server and its tools including the facets of successfully administering a wide range of simple to highly complex environments.
• Experience with data and schema design and engineering
• Demonstrated practical experience with data migration from legacy systems to central repositories
• Industry-standard exchange schema implementation experience (E.g. Cybox or Capec)
• Be able to evaluate and install new software releases, patches and system upgrades.
• Knowledge and understanding of all aspects of database tuning: software configuration, memory usage, data access, data manipulation, SQL, and physical storage.
• Experience supporting technology strategy/roadmap.
• Experience with the development and execution of database security policies, procedures and auditing-experience with database authentication methods, authorization methods, and data encryption techniques.
• Possess good communication skills, both oral and written.
• Must work well in a team environment as well as independently.
• Must exhibit good time management skills, independent decision-making capability; focus on customer service.
• Ability to work with the other technical members of the team to administer and support the overall database and applications environment.

DESIRED SKILLS:

• Experience database engineering support to DHS, DoD or Intelligence Customers
• Data Scientist skills and experience
• Understanding of Certification and Accreditation (NIST 800-53) processes as they apply to database technologies
• Operating system and hardware platform knowledge preferred.
• Experience working with large unstructured data sets
• Experience with Map/Reduce technologies
• Experience with process development and deployment
• Trained in Six Sigma Methodology
• ITIL knowledge and certification

DESIRED CERTIFICATIONS:

• Cloudera Certified Professional (CCP): Data Scientist

• CCDH: Cloudera Certified Developer for Apache Hadoop

• CCAH: Cloudera Certified Administrator for Apache Hadoop

• CCSHB: Cloudera Certified Specialist in Apache HBase

• CSSLP Certified Secure Software Lifecycle Professional

• Database specific certifications as appropriate to position

• DODI 8570.1 Compliance at IAT Level I certification highly desired.

• DB01: Database Engineer – I

• No demonstrated experience required.

• Bachelor’s degree in Computer Science, Mathematics, Statistics OR related field. [Four (4) years of experience may be substituted for a degree.]

• DB02: Database Engineer – II

• Two (2) or more years of database engineering experience required. [A Master’s degree in a related discipline may substitute for two (2) years of experience]

• Bachelor’s degree in Computer Science, Mathematics, Statistics OR related field. [Four (4) years of experience (for a total of six (6) or more years) may be substituted for a degree.]

ADDITIONAL RESPONSIBILITIES:

• Translates a set of requirements and data 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.

• Assists in developing databases, database parser software, and database loading software.

• Assists in developing database structures that fit into the overall architecture of the system under development

• DB03: Database Engineer – Senior I

• Four (4) or more years of database engineering experience required. [A Master’s degree in a related discipline may substitute for two (2) years of experience]

• Bachelor’s degree in Computer Science, Mathematics, Statistics OR related field [Six (6) years of experience (for a total of ten (10) or more years) may be substituted for a degree.]

ADDITIONAL RESPONSIBILITIES:

• Leads the development of databases, database parser software, and database loading software.

• Leads the development of database structures that fit into the overall architecture of the system under development.

• Develops requirement recommendations from a project’s inception to its conclusion for a particular Business and IT subject matter area (i.e. simple to complex systems)

• DB04: Database Engineer – Senior II

• Six (6) or more years of database engineering experience required. [A Master’s degree in a related discipline may substitute for two (2) years of experience]

• Bachelor’s degree in Computer Science, Mathematics, Statistics OR related field [Eight (8) years of experience (for a total of fourteen (14) or more years) may be substituted for a degree.]

• Master’s degree preferred.

ADDITIONAL RESPONSIBILITIES:

• Supervises the development of databases, database parser software, and database loading software.
• Coordinates development of database structures that fit into the overall architecture of the system under development.
• Assesses requirement recommendations from a project’s inception to its conclusion for a particular Business and IT subject matter area (i.e. simple to complex systems)

CERTIFICATIONS:

• DODI 8570.1 Compliance at IAT Level I certification required.

• DB05: Database Engineer – Principal I

• Eight (8) or more years of database engineering experience required. [A Master’s degree in a related discipline may substitute for two (2) years of experience]

• Bachelor’s degree in Computer Science, Mathematics, Statistics OR related field. [Ten (10) years of experience (for a total of eighteen (18) or more years) may be substituted for a degree.]

ADDITIONAL RESPONSIBILITIES:

• Supervises 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.
• Supports fulfillment of requirements from a project’s inception to its conclusion Advises on the organization of requirements and data into a usable database schema by directing the development of ad hoc queries, scripts, macros, updates to existing queries.
• Assists in the development of complex systems using queries, tables, Open Database Connectivity and database storage, and retrieval using Cloud methodologies Level 3

CERTIFICATIONS:

• DODI 8570.1 Compliance at IAT Level I certification required.

• DB06: Database Engineer – Principal II

• Ten (10) or more years of database engineering experience required. [A Master’s degree in a related discipline may substitute for two (2) years of experience]

• Bachelor’s degree in Computer Science, Mathematics, Statistics OR related field [Twelve (12) years of experience (for a total of twenty-two (22) or more years) may be substituted for a degree.]

• Master’s degree preferred.

ADDITIONAL RESPONSIBILITIES

• Directs 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
• Directs fulfillment of requirements from a project’s inception to it conclusion
• Directs organization of requirements and data into a usable database schema by directing the development of ad hoc queries, scripts, macros, updates to existing queries
• Directs the development of complex systems using queries, tables, Open Database Connectivity and database storage, and retrieval using Cloud methodologies Level 3

CERTIFICATIONS:

• DODI 8570.1 Compliance at IAT Level I certification required.