Description

Provision and manage Oracle database instances on AWS/Linux
Install, configure, and troubleshoot Golden Gate for batch and online process synchronization for high volume database
Set up replication and high availability for Oracle databases using tools like Golden gate
Monitor Oracle database performance
Troubleshoot Oracle database problems
Perform backups and restores of Oracle databases
Work with application developers to identify and refine data requirements, table/database design, assist in SQL writing

Demonstrable skills in designing schema, access patterns, locking strategy, SQL development, and tuning Oracle Databases in an enterprise environment
Modifying the database structure, creation, and update to existing database objects per application needs
Experience in configuring, monitoring, and Cache management for Oracle database servers
Strong experience in allocating system storage and planning future storage requirements for the database system
Experience in Install, configure, and troubleshoot/maintain Golden Gate
Must have experience in implementing and supporting Oracle on AWS including EC2, RDS and S3
Experience authoring code in SQL, PL/SQL on Unix/Linux
Proficiency in one or more shell scripting languages
Hands-on experience enrolling users and maintaining system security, Controlling user access to the database, Locking down host access
Monitoring performance metrics, response times, and request rates
Designing and implementing backup/restore service and disaster recovery (DR) solutions
Installing and upgrading the database software, Patching the software that powers database
Good Analytical,Technical,TimeManagement and Communication Skills
Participate in on-call rotation and weekend work
Experience with advanced security and Oracle DataGuard replication
Experience in Oracle Data Masking and Subsetting
Demonstrable skills with Cúram Software and database schema

Education

Any Graduate