Description
SUMMARY: * 9 years of IT Industry experience in the field of Oracle database administration. * Good experience and through knowledge in the Implementation and configuration of Oracle Real Application clusters 11g, 10g on active-active architecture, 10g/12c Grid Control, Recovery manager (RMAN), Data Guard, Automatic Storage Management (ASM), Advanced Replication, Disaster Recovery. * Experienced in implementation of Large Data Warehouse databases in Oracle 10g/11g with several key features like RAC, ASM, Partitioning and Password Complexity. * Experienced in different phases of oracle 9i/10g/11g upgrade process involving planning, database preparation, database upgrade and post 10g upgrade activities. Had performed 50+ database upgrades from Oracle 9i/10g and from 10g to 11g. * Experienced in writing shell scripts, PL/SQL stored procedures, Functions, Triggers, Packages, space management and storage allocation. * Good experience in different UNIX flavors like HP UNIX, IBM AIX, Sun Solaris and RedHat Linux. * Have thorough experience on testing several oracle components handling service requests, tar on Metal ink Support. * Design and maintain database solutions for new and existing projects by understanding the business requirements * Develop and maintain database structures that utilize database architectural standards (normalized tables, primary keys, foreign keys, events, triggers, etc.) * Write scripts to create, optimize, and maintain databases, tables, constraints, functions, stored procedures, indexes, and triggers. * Provide primary support for the organization's data repositories and will be responsible for requested SQL or Oracle reports * Work with managers of each functional area to identify and prioritize data information needs and requirements * Troubleshooting the performance issue in oracle Database. * Implementing the Golden Gate Unidirectional for reporting database. * Migration data from SQL server database to Oracle. * ASM SAN migration. * Implementing the Schell scripting to automate the database task, Alert and Reports. * Strong functional knowledge in the Largest Media and Entertainment Company & Investment Banking and Retails. * Installation of web logic for 12c OEM. * ZFS snapshots & rollbacks * Upgrading 10g database to 12c. * Good communication and Interpersonal skills. Experienced in client-facing roles. * Migration data from SQL Server database to Oracle Database. * Using KSH programming to automate the database monitor and activities.
Accomplishments
Highlights:
Keywords
