SUMMARY:

• Having 8+ years of experience in Oracle Database Administration
• Experience in Installation and Administration of Oracle database server10g/11g on UNIX/LINUX environments
• Experienced at administering database security by create users, grant/revoke roles, privileges to the users
• Good experience with the tools like data pump and traditional export/import
• Experience in taking regular Hot, Cold backups and performing Recovery activities using RMAN
• Experience in managing DATA GUARD environment
• Experience in Switchover the database
• Administration of RAC Instances using SRVCTL Utility
• Monitoring and supporting 10g/11g RAC Database and ASM technologies
• Generated AWR/ADDM reports for database performance health checkups
• Cloning the databases using RMAN and hot/cold for test, reporting environments
• Managing and monitoring the Indexes for better performance
• Patched and upgraded 10.2.0.1 databases to 10.2.0.4 and 11.2.0.2 to 11.2.0.3
• Working with Production and Standby Databases and managing Dev & UAT Database
• Configured oracle - to-oracle unidirectional replication using Oracle Golden Gate.
• Configured the schema level replication with and without datapump process in Golden Gate.
• Configured the column level replication setup using defgen parameter file
• Setup Data Guard on 10g R2 and 11g R2
• Experience in working with Cost-Based Optimizer and SQL Tuning Advisor.
• Resource monitoring (servers, storage) using Grid Control.
• Worked in the team environment supporting 24X7 production supports
• Managing Database Structure, Storage Allocation, Table/Index segments, Rollback Segments, Undo Segments, and Constraints.

TECHNICAL SKILLS:

Databases: Oracle 9i, 10g and 11G

Operating Systems: Linux, AIX, Solaris and windows

Tools: & Utilities: Dbca, Dbua, Export/Import, Expdp/Impdp, SQL Trace, Explain Plan, RMAN, Data Guard, AWR, ADDM

PROFESSIONAL EXPERIENCE:

Confidential

Oracle Database Administrator

Environment: Oracle 9i/10g/11g on Solaris, LINUX, Windows

Responsibilities:

• Maintained disaster recovery site using Oracle Data guard
• Performed Database Switchover
• Configured Physical standby database for the production environment using Oracle Data guard using ASM storage.
• Understanding execution plan of top SQL statements by using Explain plan, Auto trace and Tkprof
• Configured the Oracle Golden Gate on Oracle Enterprise Linux 6 for data replication.
• Configured oracle-oracle bidirectional replication with Oracle Golden Gate for a new schema with CDR.
• Configured Initial extract process and replicat to perform 'Initial Load' in Golden Gate
• Performed Instantiations in Golden Gate using exp/imp and expdp/impdp at table level
• Analyzed Golden Gate trail files using logdump utility.
• Patched and upgraded 10.2.0.1 databases to 10.2.0.4 and 11.2.0.2 databases to 11.2.0.3
• Monitoring/housekeeping Archives destination
• Restored databases using RMAN to fix corruption and storage issues.
• RMAN Backup validations which was scheduled to crontab
• Applied database patches using OPatch utility
• Performed Index Rebuilding to enhance the performance
• Worked on rotation of production on call support, responding and resolving issues in timely manner.
• Worked on troubleshooting the on-call issues such as Space, Job Failures, login locked out, blocking and slow running queries.
• Involved in the Life Cycle Management process to make sure all the databases should meet all compliance standards
• Checking Alert log, trace files, listener log and other database job logs

Confidential

Environment: Oracle 10g/11g on LINUX, Solaris

Responsibilities:

• Check out CRS status and Administration of RAC Instances using SRVCTL Utility
• Taking backup of OCR and voting files using cluster utilities
• Monitoring the ASM Disk Groups
• Maintained database backup and recovery using RMAN/HOT backup
• Creating and managing DBLINK to link schema objects residing on remote database
• Troubleshooting application SQLs and database performance tuning, table partitioning, table space re-org
• Tuned performance of RAC and non RAC databases. Found bottlenecking queries that impede application performance and fine-tuned them.
• Converted single instance database into RAC
• Scheduled and executed several planned maintenance operations like Patching, upgrading, redesigning, de normalizing, and partitioning
• Supporting to the end users while working on development and test databases
• Adding datafiles to tablespaces and datafile resizing when required
• Providing 24/7 support for all prod, dev & test instances
• Generated AWR report for database performance health checkups

Confidential

Environment: Oracle 10g/11g on LINUX, Solaris, AIX, HP-UX.

Responsibilities:

• Creating users, allocation to appropriate Table spaces, Quotas with necessary privileges and roles for all databases
• Checking whether all Databases/Listeners are available and running
• Taking the backup of the database regularly using Logical, Cold and Hot Backups
• Performed Backup and Recovery activities using RMAN
• Configured Flash Recovery Area in Dev databases.
• Involved in the manual switchover testing of the physical standby once in a quarter to test the application functionality on standby data centre.
• Perform manual Backups using EXPDP and IMPDP
• Monitoring scheduled jobs and data replication activities.
• Monitored and tuned long running jobs by working closely with the application development team and analyzing objects, created or rebuilt indexes, query tuning using SQL TRACE, TKPROF, Explain Plan.

Confidential

Oracle Database Administrator

Environment: Oracle 10g, 11g on LINUX

Responsibilities:

• Creating users, allocation to appropriate Table spaces, Quotas with necessary privileges and roles for all databases
• Resizing the data files and adding data files to table spaces as per the requirement
• Taking the backup of the database regularly using Logical, Cold and Hot Backups
• Performed Backup and Recovery activities using RMAN
• Maintaining data files, control files, online redo log files and archive log files
• Monitoring Alert logs for any errors, problems or processes running
• Restored databases using RMAN to fix corruption and storage issues.
• Experience in Partitioning and creating Global, Local Indexes on Partitioned Tables
• Maintaining data files, control files, online redo log files and archive log files
• Administered databases on Linux, Centos, HPUX and Solaris.
• Performed daily maintenance tasks like space management, rectified locking problems, managed quotas etc., configured network components like TNSNAMES etc. for easy and effective management of Oracle networking.

Confidential

Environment: Oracle 10g/11g on LINUX, Solaris.

Responsibilities:

• Performed schema refresh using logical backups
• Worked on troubleshooting the issues such as Space, Job Failures, login locked out, blocking and slow running queries.
• Maintained database backup and recovery using RMAN/HOT backup
• Creating and managing DBLINK to link schema objects residing on remote database
• Adding datafiles to tablespaces and datafile resizing when required
• Providing 24/7 support for all prod, dev & test instances
• Generated AWR report for database performance health checkups
• Performed Index Rebuilding to enhance the performance
• Managing Database Structure, Storage Allocation, Table/Index segments, Rollback Segments, Undo Segments, and Constraints.