Oracle PL/SQL Developer

Job Description:

Performs planning, design, development, testing, migration to production, and the maintenance of applications using Oracle and third-party tools.
Experience writing complex queries, using advanced PL/SQL concepts and performance tuning. Assist in defect triage, impact analysis, resolution planning and implementation
Analyzing and converting business requirements to technical requirements, followed by designing and implementing the solutions
Experience in reviewing the Oracle ADDM and AWR reports and recommending query optimization based on the analysis
Leverage Oracle 12C features to their fullest on a large-scale multi-terabyte system
Support team members including DBAs, database developers, requirements analysts, and others, in understanding data and meeting user requirements
Participate in project work groups with Subject Matter Experts and stakeholders to understand data specific needs
Participate in performance tuning activities
Provide production deployment and production support as needed
Involved in all aspects of the software development life cycle; demonstrate abilities to learn both the business processes as well as new and existing technologies
Work on sprint team in agile, rapid development and deployment environment.
Strong written, oral, and interpersonal communication skills.
Ability to conduct research into software-related issues and products.
Ability to work both independently and in a team-oriented, collaborative environment.


Education:

Bachelor's degree in Computer Science or related discipline preferred. 


Skills

Required - 10+ years of hands-on experience in advanced PL/SQL programming using Oracle Database versions 11g and 12c, TOAD/SQL Developer, Operating systems such as Linux, Unix and Windows and ability to participate in multiple projects at the same time.

Preferred - MS SQL Server, Java, Fusion Middleware 11g (BPEL, B2B, Spring Bean, OSB), WebLogic, Visual Studio, .NET Framework, Cloud Computing, Team Foundation Server, Internet technologies like HTML, DHTML, XML, CSS, XSLT, SOAP, WSDL, SOA, Scripting languages, ServiceNow, knowledge of SDLC activities on development projects and Electric/Gas industry experience