Install, Patch and Clone Oracle e-Business Suite Applications & Database system for Development, QA and Production environments on advanced platform : Oracle Engineered System ( Exadata , Exalogic).
Optimize physical design and environment for different access methods and performance. Monitor performance and provide recommendations for schema enhancements using Oracle Enterprise Manager and more advanced utilities and features of Exadata Storage like smart scans.
Design, create and tune physical database objects to support normalized and dimensional models, maintaining the referential integrity of the database
NoSQL and Graph DBs : Cassandra, Neo4J; Spark & Kafka.
Monitor and tune the enterprise network for optimal performance, working with developers in tuning with PL/SQL.
Providing SOX/PCI/IA compliance support by implementing security best practices on all applications and databases.
Develop database management productivity tools, including database monitoring procedures and utilities.
Provide ongoing support of the environment by developing processes and executing object migrations, security and access privilege setup.
Setup PCP (Parallel Concurrent Processing) and Load Balancing configuration within Oracle E-Business Suite QA and Production environments.
Mentor and develop skills of Application Database Administrators and Associate Database Administrators.
Develop and test disaster recovery procedures using advanced DB features like Active Dataguard.
Perform Oracle Database backup and recovery using Oracle Recovery Manager Tool.
Provide 24x7 support and ensure all critical Oracle Database and Oracle e-Business Suite Application system problems are resolved in a timely manner