Design and build custom applications using Oracle databases and tools in Linux, UNIX Shell Scripting, Control M Scheduler and Windows environments. Write PL/SQL, SQL programs, views, synonyms, functions, procedures, packages, triggers, cursors, and collections using Toad to maintain complex integrity constraints and to implement the business rules. Develop advanced file and database structures and interfaces between internal and external systems. Conduct performance tuning of databases larger than 10TB with a daily volume of 2.5 to 4 billion records per data feed using SQL Tuning and Performance Advisor. Work on Oracle export/import utilities and data pump utilities. Design and develop reports, collect data, and implement process and control procedures for assigned systems. Develop criteria for testing and debugging applications, programs, and reports, and evaluate the results of design and testing. Perform and supervise full systems testing, implementation, and evaluation. Utilize Oracle Database 11g/10g/9i, Toad 10.1/10.6, SQL Plus, JIRA, Putty, Windows, and Control M Scheduler. Provide third-tier user support, training and end-user documentation. Create and maintain documentation. Communicate with managers and business partners on business systems and project status.
Bachelor's degree or foreign equivalent in Information Technology, Computer Science or Engineering, and four (4) years of experience in a related occupation. Work experience or academic coursework must have included: Oracle Database 9i/10g/11g, PL/SQL, UNIX Shell Scripting, TOAD/SQL Tuning and Performance Advisor; SQL*Loader.