Education and Experiencebr br Bachelors degree or foreign education equivalent in Computer Science, Engineering, Information Technology, Information Systems, Mathematics, or a closely related field and five 5 years of experience in the job offered or five 5 years of experience performing Oracle database administration in a financial services environment.br br Or, alternatively, Masters degree or foreign education equivalent in Computer Science, Engineering, Information Technology, Information Systems, Mathematics, or a closely related field and three 3 years of experience in the job offered or three 3 years of experience performing Oracle database administration in a financial services environment.br br Skills and Knowledgebr br Candidate must also possessbr br Demonstrated Expertise DE performing Oracle database administration across Oracle Exadata, ESX RAC, Linux RAC platforms, and Oracle on EC2 in AWS, using Oracle Enterprise Manager OEM, TOAD, Oracle SQL Developer, Oracle SQLPlus, Oracle AWR Automatic Work Repository, and Database Configuration Assistant DBCA.br br DE performing database SQL tuning and troubleshooting in realtime mission critical database applications, using Oracle Enterprise Manager 13c; and identifying bottlenecks and providing performance tuning and optimization recommendations based on Oracle AWR, ASH, and SQLT reports and system diagnostics.br br DE building Continuous Integration and Continuous Deployment CICD pipelines in AWS using Stash, Jenkins, Artifacts, Concourse, CloudFormation Template and uDeploy; configuring database replication to AWS S3 using GoldenGate Big Data Connector; and supporting GoldenGate Big Data Connector Rehydration.br br DE diagnosing endtoend batch performance, performing PLSQL development and SQL query troubleshooting, including writing PLSQL scripts to embedded financial advisor business logic customer patterns and interactions to measure and rank advisor performance, using Oracle AWR, Oracle Active Session History Oracle ASH, Automatic Database Diagnostic Monitor ADDM, and SQL monitor reports.
Categories: eb3
0 Comments