Oracle Database Developer
ACS -
Albany, United States of America
11 days ago
Role details
Contract type
Permanent contract Employment type
Full-time (> 32 hours) Working hours
Regular working hours Languages
EnglishJob location
Albany, United States of America
Tech stack
Business Logic
COBOL
Databases
Data Files
ETL
Data Manipulation Languages
Data Normalization
Data Warehousing
Oracle
Oracle Applications
Performance Tuning
SQL Stored Procedures
PL-SQL
Systems Architecture
Data Processing
User Administration
Requirements
- Demonstrated experience working with Oracle Database (12c or higher), including development using PL/SQL, functions, stored procedures, sequences, table design, performance tuning, data normalization, and dataset management.
- Experience supporting and maintaining Micro Focus COBOL runtime environments in both production and development settings, including upgrades and maintenance of technologies such as Micro Focus COBOL and Oracle Pro*COBOL to ensure stable operational environments.
- Hands-on experience in Oracle Database administration, including performance tuning, storage and schema management, table design, and user administration.
- Experience in data warehousing and ETL processes within Oracle environments, including extensive use of PL/SQL for business logic implementation and DDL/DML operations for data processing and transformation.
- Experience preparing and maintaining technical documentation, including system architecture specifications and technical design documents.