Sr. Oracle Developer (Exadata)_Only w2 @ Onsite

Sr. Oracle Developer

Total Openings: 1

Contract Length: 12 -24 months Contract to Hire .

Start Date: 2-3 weeks upon offer based on equipment arrival.

Interview process: 1 round 1 hour zoom interview / Onsite uptown . They will undergo a white board Coding Test.

APPROVED LOCATIONS: CIC, 1525 W WT Harris Blvd, Charlotte 28262 This is the ONLY location.

Business Objective:

They are doing integration of Trust within WIM. Bringing 4 different applications under one app Customer Review Center (CRC).

Day to Day:

• Participate in the technical solutioning and sustainment of our digital applications.
• Lead moderately complex initiatives and deliverables within technical domain environments.
• Contribute to large scale planning of strategies.
• Design, code, test, debug, and document for projects and programs associated with technology domain, including upgrades and deployments.
• Review moderately complex technical challenges that require an in-depth evaluation of technologies and produres
• Resolve moderately complex issues and lead a team to meet existing client needs or potential new clients' needs while leveraging solid understanding of the function, policies, procedures, or compliance requirements.
• Collaborate and consult with peers, colleagues, and mid-level managers to resolve technical challenges and achieve goals.
• Lead projects and act as an escalation point, provide guidance and direction to less experienced staff.
• Experience with large partitioned tables and query optimization.
• Ability to read, write, debug, tune and maintain large, complex queries including analytic and aggregation clauses.
• Experience with PL/SQL including Oracle Object types and Pipelined Table Functions.
• Familiarity with the Oracle privilege model and how to use PL/SQL procedures to enable specific privileged operations while restricting the privileges of the application user accounts.
• Experience with partition operations/maintenance including creating, merging, dropping and exchanging partitions.
• Experience building and supporting large batch systems.
• Familiarity with DBMS_PARALLEL_EXECUTE.
• Familiarity with partition based procedural parallelism.
• Experience with Unix scripting languages.
• Exadata
• Perl.

Nice to Haves:

Python exp

Hands on development experience in :

1) Oracle 9i/10g/11g/12c, TOAD

2) SQL, PL/SQL

3) Exp with Performance Tuning, Partitioning, Parallelism, B-Tree and Bitmap Indexes, Large DataSets and Compression

4) Dynamic SQL, Collections, Bulk Operations

5) Exp with Direct-Path, Conventional Loading.

6) Unix, Shell Scripting, Autosys

8) Agile