Job Summary:
Provide proficient knowledge of database management to support IT Infrastructure. Evaluate, design, implement and maintain databases, identify data sources, construct data decomposition diagrams, provide data flow diagrams and document the processes. Writes code for accessing or modifying databases which include stored procedures. Ensures internal controls are adhered to in relation to audit, security, systems and data integrity. Requires high level of technical expertise related to studying and analyzing IT system requirements for data base structures. Ongoing responsibility on a 24 X 7 basis for maintenance of database environments to include on-call duty rotation.
Required Skills and Years of Experience (Provide the required skills and years of experience for this position.):
7+ years with the following skillsets:
Oracle Golden-Gate (OCC) 19c or 21c (Configuration, Performance tuning, Internal mechanism, and OCC HA)
OEM 13.x Cloud Control SME (administration, installation, configuration)
Performance tuning SME
SQL / PL /SQL
AIX / Linux
Scripting Shell, Perl, Python (at least 1)
System administration or development background
RMAN
RAC
ASM
Weblogic
3+ Years with the following skillsets:
Oracle Exadata
Preferred Skills and Years of Experience (Provide the preferred skills and years of experience for this position.):
10+ years with the following skillsets:
E-Business Suite / Oracle apps (nice to have)
Data Guard (nice to have)
Golden Gate (nice to have)
Exadata (nice to have)
Work Effort (Provide the tasks for this position and the estimated hours per task.):
Analyze and resolve database performance issues, database capacity - 40%
Issues, replication/clone/restores, quarterly patching, database upgrades and other database issues
Provide technical OGG resource/training to lead staff - 20%
Interface with development staff, project mgmt and sr mgmt - 15%
Database design and new software compliance - 15%
Required profile
Experience
Spoken language(s):
English
Check out the description to know which languages are mandatory.