Description:Under general direction, leads and participates in the development and maintenance of database systems while also providing database development services to the development team. Required to review and provide technical solutions to projects which may be in different stages of the development life cycle. As part of consulting activities, produces database-related analyses and technical documentation to support recommended solutions. Performs all functional duties independently. Works on high-visibility programs, or mission critical aspects of assigned program(s). Oversees the efforts of direct reporting resources and/or is responsible for the efforts of all staff assigned to a specific job.
In-depth Technical knowledge of Oracle Forms and Reports, libraries, objects, menus
Technical expertise in writing and tuning complex SQL Queries.
Technical expertise writing and tuning PL/SQL.
Expert knowledge of the Unix operating system and shell scripting
Technical knowledge of WebSphere
Technical knowledge of network firewalls, and understanding of how they are implemented to provide secure enclaves to protect server and database resources.
Technical knowledge of security certificates and how they are used to protect transmission of data between various computer devices.
Experience upgrading both Oracle Database and OFM software, and knowledge of tuning them.
Expert knowledge of Oracle database objects, triggers, packages, functions, procedures, tables etc.
Knowledge of software tools to manage application development and testing – Toad, SQL Developer, Oracle Forms and Reports Builder
Expert ability to perform analysis of customer requirements and design technical solutions
Ability to perform project management functions.
Familiarity with Agile/Scrum processes and management tools such as VersionOne.
Knowledge of and experience in an IT Service management System (preferably ServiceNow) and ITIL processes Ability to lead / mentor junior developers on development projects
Additional Required Skills/Experience:
A minimum of ten (10) years’ experience in software development, database design, database administration, and/or related field;
A degree from an accredited College/University in Software Engineering, Computer Science, or related discipline is preferred;
Able to perform all functional duties independently on high-visibility programs, or mission critical aspects of a given program;
Able to oversee the efforts of direct reporting resources and/or be responsible for the efforts of all staff assigned to a specific job;
Experience training/mentoring less experienced personnel;
Extensive knowledge of and experience with designing, constructing, and maintaining large relational database systems;
Extensive experience with Oracle or MS SQL Server DBMS, SQL Language, Unix/Linux including basic shell commands, data warehousing, report generation, job scheduling and monitoring tools, XML, HTML, open source development, and technical documenting skills (Windows Office/Visio/Cvs, etc.). ;
Advanced Oracle or Microsoft SQL Server certification required;
Extensive experience producing database-related documentation such as technical analyses and technical designs;
Able to obtain clearance;
Excellent communication skills.
Pass both a client mandated clearance process to include drug screening, criminal history check and credit check.
Once candidate’s resume is approved and interview passed, the agency is responsible for providing drug screening. Failure to submit the drug screening results will delay the security clearance process.
If a candidate is given an interim clearance, continuation of employment is then based on the candidate receiving a sensitive clearance.
All candidates must be a US Citizen, or have permanent residence status (Green Card) or hold an H-1B Visa.
Candidate must have lived in the US for the past 5 years.
Cannot have more than 6 months travel outside the United States within the last five years. Military Service excluded. (Exception does not include military family members.)