Critical Role: Oracle PL/SQL Developer
Location: Las Vegas, NV (Day 1 -On-site)
Duration: Long Term Contract
Experience
Must have 6+ years PL/SQL Developer working experience on Oracle Database 10g, 11g and/or 12c.
Job description:
In this role, the PL/SQL Developer will design, build, test, and deploy quality database solutions that are consistent with project objectives, technology architecture standards and departmental best practices. The PL/SQL Developer will contribute to project plans, technical analysis, troubleshooting and technical architecture design.
The PL/SQL Developer will engage in all phases of the software development lifecycle and will develop and support database solutions/processes that maximize system availability, efficiency, effectiveness, integrity, recoverability, and supportability. Specific responsibilities include:
- Document detailed system specifications and participate in evaluating, troubleshooting, and fixing issues with applications.
- Database and PL/SQL optimization including performance tuning, query optimization and supportability.
- Work with development project teams to design and implement database solutions to meet business requirements.
- Support of the nightly ETL processing
- Project Estimation process - including attending project kick-offs and design reviews as necessary to appropriately size new projects.
- Develop and implement Database security polices and controls and procedures, in line with corporate objectives
- Provide overall database support with concentration on back-end programming
- Should be able to understand the project scope, deliverables, and timelines and involve in the design, development and integration of solutions.
- Should be able to use best practices and use performance tunings skills and dynamic SQL skills to develop scalable solutions.
- Must have 6+ years PL/SQL Developer working experience on Oracle Database 10g, 11g and/or 12c.
- Must be knowledgeable and experienced working with multiple operating systems including Microsoft Windows and Linux.
- Strong skills in Oracle server side programming which includes SQL, SQL*Plus, PL/SQL Packages, Stored Procedures, Functions, Cursors, Triggers, Views, Materialize Views, Temporary tables.
- Experience in Exception Handling and debugging PL/SQL Code, DDL, DML, and DBMS jobs.
- Strong skills in PL/SQL and UNIX/Linux Shell Scripting
- Strong SQL and PL/SQL Design, Development, Tuning and debugging skills
- Experience in creating Materialized Views and Indexes for better performance of summary tables, Autonomous Transactions, and developing Dynamic SQL Statements.
- Experience in writing Cursors, User-defined Object types, Records, and Tables in PL/SQL Programming for generating worksheets, Arrays & Queues.
- Strong experience in developing and supporting end-to-end jobs as part of ETL Process.
- Excellent communication skills and ability to Collaborate with onshore and offshore teams as needed
- Ability to maintain a positive attitude while working with high demands and short deadlines
- Ability to prioritize heavy workload with minimum supervision.
- Must have excellent communications and interpersonal skills.
- Support interfaces and back-end integration with applications.
- Strong Troubleshooting Skills.
- Strong organizational and analytical skills.
- Understanding of High Availability and Disaster Recovery requirements and solutions.
- Not Required, but Preferred:
- Oracle Education and Certifications (OCP) are a plus.
- Experience in programming languages like C# and Python.
- Understanding of or experience supporting .NET application.
- Security and compliance experience including Encryption, Audit, Authentication, PCI, GLBA, SOX, etc.
- Experience in software development and Agile processes.
- Experience in data modeling and DM tools such as Oracle Data Modeler, Erwin, Toad, Visio, etc.
- Understanding of or experience with virtual environments.