Vacancy expired!
- 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.
- 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