SUMMARY

• 6.5 years of experience as a Oracle Database Administrator on a variety of UNIX (Solaris, HP - UX, AIX), Linux, Windows NT 4.0/2000/2003 with Oracle (9i, 10g, 11g, 12c ), 10G RAC,11G RAC,12C RAC, Data Guard, Advanced replication, Installation, Configuration, Migration, Sizing and Space management, Backup and Recovery, Performance tuning and troubleshooting.
• Experience Golden Gate. Experience in data loading/extraction using SQL*Loader, Import/Export, data pump and configuring ASM flashback database.
• Experience in OEM configuration, installation, monitoring for the application running environments.
• Configuration, run-time administration, upgrade and 24x7 supports for production databases.
• Expert understanding of Oracle utilities, including DBMS packages, RMAN, ADDM and AWR report.
• Excellent work ethic with ability to work alone and in a team environment.
• Strong analytical/problem solving, interpersonal, written and verbal skills.

TECHNICAL SKILLS

Languages & Program: SQL, Shell Scripting

Database: Oracle 9i, 10g, 11.2.0.3, 11.2.0.4, 12cR1, 12cR2

Operating Systems: Linux, Solaris, Aix,HP, Windows 2000

Tools: DBverify, Exp/Imp, expdp/impdp, Log Miner, Oracle Enterprise Manager Grid ControlGolden Gate, TKPROF

PROFESSIONAL EXPERIENCE

Confidential

Oracle Database Administrator

Environment: ORACLE DATABASE 11g, 12C, RAC, OEM, Golden Gate, Exadata

Responsibilities:

• Responsible for administration and support of Oracle 11g and 12c databases.
• Upgraded databases in11g and 12c, applied multiple off set patches to correct Bug and issues in server.
• Applied PSU/CPU and Grid patches for security purpose and covered all issue in 11g/12c.
• Responsible to Support UNIX, SAN and Application team with their requirement and upgrades.
• Worked on Veritas cluster to avoid of failover of services during maintenance task.
• Migrating databases across different platforms and standalone servers to EXADATA
• Worked on troubleshooting Golden Gate Replication issues.
• Configured the Uni directional and Bi-directional replication.
• Worked with developers to implement newer versions of oracle products.
• Clone databases using scripts as well as RMAN.
• Work on troubleshooting database related issues with or without Oracle support.
• Worked on IIS (Infrastructure Solution Delivery) and tested and implemented the Golden gate.
• Successfully implemented and managed Physical Standby Database using Oracle DATAGAURD feature for Disaster Recovery.
• Expertise in performing Switch Over and Switch Back activity from production to standby and vice versa and performing Fail Over of live database to standby database during criticalities
• Create databases for development, testing and production (including RAC databases and NON-RAC databases).
• Successfully implemented Oracle 11gR2 RAC One node cluster environment and migrated databases
• Patching RAC or Non RAC environments with no downtime on RAC environments in rolling.
• Upgrade databases from Oracle 11g to 12c in RAC Environment.
• Rman backup configuration for newly inducted databases.
• Restoring databases from RAC to Non-RAC Environment and Non-RAC to RAC.
• Expertise in performing Table Reorg,Re Indexing and Analyze Activities during off peak hours.
• Develop UNIX shell scripts, SQL scripts to carry out routine checks on databases and automation.
• Experience in working with Oracle support.
• Hands on experience in Migrations of Databases from various versions
• Proactively monitoring of databases and handle escalation of production issues.
• Strong exposure in performing critical production database recoveries.
• Working closely with various teams like OS support, Applications and Business people as a point of contact from Oracle Database services team during critical incidents or planning activities.
• Creating and Registering New Databases in RAC Environment
• Administration and management of the entire development, QA and production environment.

Confidential

Oracle Database Administrator

Environment: ORACLE DATABASE 11g, 12C, RAC, GOLDEN GATE, OEM

Responsibilities:

• Managing 24/7 production servers
• Configured the Uni directional and Bi-directional replication.
• Experianced in managing the VLDB databases with more than 30TB database size.
• Installations of standalone & RAC databases & configurations of Oracle 10g, 11g, 12c on Linux & Windows
• Oracle RAC configuration & Troubleshooting.
• Worked on Oracle 12c Multitenant CDB, PDB.
• Appling PSU patches on production databases
• Installation of OEM grid control 12c, 13c agents using silent mode and Pushing Binaries from DB console.
• Analyze and solve performance issues using AWR, ASH and ADDM reports, 10046, 10053 and ORADEBUG traces.
• Expertise in database up gradation from 10g/11g to 11g/12c for Standalone and RAC Environments.
• Upgraded the databases from 10g to 11g, 11g to 12c manually and DBUA.
• Applied PSU, CPU patches on RAC Environment and Non RAC Environment.
• Resolving Database connectivity issues & Resolve application to database connectivity issues by modifying TNSNAMES.ORA file as required.
• Transporting & Loading data between Oracle Databases using Import/Export & Data pump Utility.
• Provide continuous support to database related activities like monitoring, administration and troubleshooting of multiple standalone databases of different versions on different platforms.
• Installation of Oracle 9i,10g,11g & 12c database Software as well as Clients using GUI & silent mode in Windows, AIX and Solaris.
• Managing database security. Creating users and roles and assigning different roles to users.
• Creation & Rebuilding of Indexes on tables as maintenance activities.
• Performed the Table Re-org and eliminating the Row chaining.
• Performed the RAC Restorations.
• Performed the Switchover and Switchback for RAC Critical databases.
• Identify the locking on database objects and resolve them appropriately by identifying and killing the blocking sessions.
• Analyzing DB level & Schema level statistics at regular intervals.
• Refreshing UAT/ development databases from production databases using export and import & data pump.
• Data Guard configuration, Switchover & Failover.
• Perform SCN Incremental backups to sync the DR database with PRODUCTION if lagging behind.
• Moving or backing up old archives with RMAN, if File System is filled
• Scheduling and managing crontab jobs
• Coordinating with other teams like testing/Developers for fixing up issues
• Executing Code given by developers on Dev as well as Production Systems

Confidential

Oracle Database Administrator

Environment: ORACLE 9i, 10g, 11g RAC

Responsibilities:

• Regular checking of the alert log file, space usage and proper execution of the scheduled jobs
• Creating user schemas, grant privileges as per the requirement
• Monitoring the sessions and kill if necessary
• Taking backups using expdp/impdp, hot and moving to the test environment
• Monitoring the CPU and free disk space on the servers
• Daily generating the AWR Reports and ADDM reports and take necessity actions to improve the database performance
• Monitoring the backend processes at the server level like CPU and memory utilization
• Online rebuilding of indexes
• Identifying and creation of the indexes on tables
• Monitoring the backups regularly
• Creating and altering table spaces
• Monitoring Filesystem usage, CPU Utilization, Tablespace growth
• Database creation and deletion
• Database startup and shutdown
• Oracle installation (Server & Client)
• Creating and deleting users
• Creating roles and assigning it to the users
• Granting and revoking privilege from users
• Controlling & monitoring user access
• Creating tablespaces and assigning to users
• Export and import of database
• Scheduling and managing crontab jobs
• Backup of Database (Online/offline/Rman)
• Managing Archive logs and Full Back up by RMAN
• Moving or backing up old archives with RMAN, if File System is filled
• Development of necessary tools (Unix Scripts) for monitoring & maintenance of Database