As an Oracle PL/SQL Developer, you will be a key member of the Database Group responsible for providing overall database support with a concentration in back-end programming. The PL/SQL Developer will be responsible for maintaining source code sets and necessary technical documentation and assisting the DBA's in overall database maintenance. In this role, you'll leverage your knowledge of Oracle database development and be instrumental in the successful implementation of our browser-based, enterprise software product.

Essential Functions:

• Will work as a part of the SQL Development team by designing a schema, tables, views, indexed views, developing stored procedures.
• Create complex queries, SSIS jobs, and SSRS / Power BI Reports.
• Will be well versed with the latest T-SQL language features and have experience dealing with large volumes of data.

Required Skills:

• 5-8 years of IT development/programming/coding professional work experience.
• Diamond and PowerBuilder experience.

Qualifications:

• 5-8 years of IT development/programming/coding professional work experience or equivalent combination of transferable experience and education.
• Experience with Oracle Version 10g, 11g, 12c.
• Must possess expert programming and troubleshooting skills.
• Must possess expert performance tuning skills and dynamic SQL skills.
• Must be willing to jump into anyone’s code at any time to solve the problem.
• Must be able to reverse engineer anyone else’s code and be able to modify it to solve the problem in a better or more efficient way.
• Strong experience with Oracle functions, procedures, triggers, packages & performance tuning.
• Ensure that database programs are in compliance with V3 standards.
• Performance tune SQL's, application programs, and instances.
• Application programming experience in .NET, C#, ASP.NET, MVC 5, JavaScript, JSON, JQuery.
• Demonstrated knowledge in XML and web services.
• Experience and understanding of unit testing, release procedures, coding design, and documentation protocol as well as change management procedures.
• Proficiency in using versioning tools like Git.
• Proficiency programming in more than one object-oriented programming language.
• Proficiency in using standard desktop applications such as MS Suite and flow-charting tools such as Visio.
• Proficiency in using debugging tools.
• Experience mentoring / or leading other development staff.
• Proven leadership abilities including effective knowledge sharing, conflict resolution, facilitation of open discussions, fairness, and displaying appropriate levels of assertiveness.
• 24x7 Production support experience supporting a large scale.
• Experience with complex indexing strategies including column store indexing.

Required Education:

• Bachelor’s Degree in Computer Science or Mathematics or relevant work experience
• Relevant Development certifications