Experienced Oracle PL/SQL Developer w/ PERL development expertise.
Develop, update and modify new and existing Oracle PL/SQL code on multiple versions of Oracle backend databases. Tune and troubleshoot PL/SQL and SQL related issues related to performance & functionality. Perform and participate in code reviews, data migrations, database migrations, data masking/scrubbing and numerous other development activities as presented. Integration & execution of PL/SQL code through Linux/Windows scripting and Perl integration. Support development of coding of complex SQL in support of non oracle-based access requests from PowerBI, PowerBuilder, Perl, Java, Salesforce, Dynamics CRM and PowerApps.
Participate in design & requirements sessions, support creation of test plan, data validation scripting and requests for SQL support. Creation of automation scripts in support of batch processing, QA testing and BOT automation initiatives.
Requires a depth and breadth of database knowledge that shall help with formal design of relational databases and provides insight into strategic data manipulation. Must be able to review/interpret complex PL/SQL and SQL scripts.
Must be able to leverage cloud technologies in support of moving database between on-premise and cloud architectures. Must be able to work on windows and Linux servers in support of PL/SQL and SQL support services.
Must be able to train/mentor peers on creating analyzing and modifying PL/SQL and SQL elements.
Develop, review and update Perl scripts to support business/customer requests.
SKILLS
Oracle PL/SQL Development Required 10 Years
Writing, analyzing and debugging complex SQL Required 10 Years
High-Level of understanding of the Oracle database environment (objects, connectivity, database features) Required 10 Years
Experience developing Perl scripts Desired 2 Years
Experience developing in Salesforce Lightning Nice to have 2 Years
Experience working with PowerBI Nice to have 10 Years
Experience working with Dynamics CRM (PowerApps) Nice to have 10 Years