Lead Database Developer

29 Jun 2024

Vacancy expired!

Title : Lead Database Developer

Location : Fort Detrick, MD

Duration

: Direct hire

Clearance Required: Active Secret is preferred

Certification Required: IAT Level II preferred (but can obtain after being hired but BEFORE starting)

Job Description:
  • Responsible for leading the design, development, testing, and deployment of application code supported by Oracle and MS SQL Server databases.
  • Assist in design, develop, and configure Oracle and SQL Server database products based on the knowledge map and taxonomy of information in support of user and system requirements
  • Complete migration of Oracle Forms and Reports to web-based, database independent applications.
  • Create and maintain complex MS SQL Server database objects, queries, functions, stored procedures, triggers.
  • Create and maintain Oracle database objects, complex Oracle Procedural Language/Structured Query Language (PL/SQL) programs, queries, packages, functions, procedures, and triggers.
  • Create new Extract, Transform, Load (ETL) and SQL scripts to support a data warehouse.
  • Creates installation scripts and other documentation describing changes; creates an un- install script to facilitate testing and complete rollback if needed.
  • Design, develop, and debug production applications using Oracle and/or MS SQL databases.
  • Designed and deployed data table structures, forms, reports, and queries using MS SQL server and Oracle
  • Identified inefficiencies in current databases and investigate solutions including migrating Oracle forms to ,Net or other methods .
  • Implements source control for Oracle Forms and Reports using folder directories and developing procedures for the check-in/check-out processing of source code.
  • Perform query optimization and performance tuning
  • Understanding of Client Reports, JASPER Reports, and Crystal Reports
  • Uses FormsAPI Master to perform impact analysis of existing forms, reports, and packages.
  • Works with USAMRDC DBAs to implement a working Oracle 12c/19 environment using pluggable databases.

Required Skills:
  • 5+ years’ experience in design, modeling and development using DB technologies like Oracle 12c/19, PL/SQL, SQL, Toad, PLSQL Developer, ETL, OLTP, OLAP, Query Tuning and Optimization

  • ID: #43689370
  • State: Maryland Frederick 21702 Frederick USA
  • City: Frederick
  • Salary: Depends on Experience
  • Job type: Contract
  • Showed: 2022-06-29
  • Deadline: 2022-08-26
  • Category: Et cetera