What are the responsibilities and job description for the Senior Oracle Developer @ Onsite (Only w2) position at Ender-IT?
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
