Senior Oracle Developer # 26-16705

US Tech Solutions, Inc.
2 days ago

Role details

Contract type
Temporary contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior
Compensation
$ 125K

Job location

Tech stack

C
Backup Devices
Bash
Unix
Client Server Models
Computer Programming
Databases
Data Integration
Data Integrity
ETL
Data Warehousing
Database Design
Database Storage Structures
Korn Shell
PostgreSQL
Microsoft SQL Server
MongoDB
MySQL
Oracle Applications
Oracle SQL Developer
Pentaho Data Integration
Query Optimization
Shell Script
Software Engineering
PL-SQL
SQL*Plus
SQL Databases
Backup and Restore
Database Optimization
Analytic Functions
Database Performance
Toad (Software)

Requirements

  • language i.e., Bash, C, KornShell, Bourne shell - Knowledgeable about data integration tools like Actian/Pentaho

  • Excellent verbal and written communication

  • Extensive expertise in one or multiple database management systems (DBMS) such as Oracle, Microsoft SQL Server, MySQL, PostgreSQL, or MongoDB, encompassing tasks such as installation, configuration, maintenance, and troubleshooting of these systems

  • Robust abilities in database design and data modeling, encompassing tasks such as crafting efficient database schemas, establishing relationships between tables, maintaining data integrity, and enhancing database structures for optimal performance

  • Comprehensive grasp of backup and recovery strategies to formulate backup plans, schedule backup procedures, validate restore processes through testing, and execute disaster recovery plans.

  • Skilled in monitoring and enhancing database performance by addressing performance bottlenecks, fine-tuning SQL queries, adjusting database parameters, deploying indexing strategies, and analyzing database statistics

  • Proficient in one more Unix scripting Experience Required:

  • 5 years of programming experience as an Oracle PL/SQL Developer

  • 3 years of creating Shell Scripts experience for invoking SQL scripts

  • 5 years of Oracle performance-related features such as Query Optimizer, Execution Plans, and Indexes.

  • 5 years of client-server application development using Oracle 19c, PL/SQL, SQL *Plus, and TOAD

  • 5 years of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-write and Transportable table spaces

  • 2 years of experience with data warehouse concepts, ETL

Apply for this position