SUMMARY

• 8 years of professional experience as Oracle Database Administrator having good experience in database administration, database installation, up-gradation, migration, installing patches, performance tuning, RAC installation and maintenance, setting up and configuring Data-guard, performing all kinds of backups and recoveries, cloning databases, replications using golden gate, auditing and product support
• Hands on experience on Oracle 9i/10g/11gR1/11gR2/12C , installing and configuring, maintaining Oracle databases on different operating systems like UNIX RHEL 4/5, AIX 6.1, OEL 5/6, Solaris10, HP-UX 7 for OLTP OLAP environment.
• Having good experience in 10g/11g/12c database administration Real Application Cluster.
• Experience in configuring high availability systems like Real Application Cluster 10g/11g on RHEL 4 / 5.8, OEL 6.1.

TECHNICAL SKILLS:

PROFESSIONAL EXPERIENCE:

Confidential

Role: SR. Oracle DBA

Responsibilities:

• Installation, configuration, and maintenance of Oracle 10g, 11g on RHEL 4 and 11g on RHEL 5, HP-UX, AIX and Windows 2003 Server and Upgradation from Oracle 10g to 11g.
• Upgraded databases from 11.2.0.4 to 12C in QA and Prod environments
• Responsible for setup and implementation of two node and three node RAC on Oracle 11g.
• Configured Oracle Dataguard for Oracle Disaster Recovery.
• Performed switchover/switchback from primary database to standby database for testing purpose for the application teams when required.
• Worked on SQL SERVER 2005,2008.
• Performed day to day administrative tasks by analyzing the database like checking for failed processors, verifying the query for particular issues and validating disk space.
• Migration of large number of databases from 10g to 11g.
• Implemented ASM on RAC and stand-alone databases.
• Migration of non ASM database to ASM database.
• Using list partitions for large tables and bitmap indexes for the OLAP databases.
• Cloned databases using RMAN Utility.
• Installation and configuration of Goldengate .
• Replication of data using Oracle Goldengate.
• Applied Interim patches Critical patches in both 10g 11g.
• Looking into day-to-day activities of Production database, Monitoring its growth and performance.
• Creation of users and granting them their roles and privileges.
• Configuration of Listener and TNS names using NETCA and NETMGR.
• Daily incremental backups and weekly cumulative backups using RMAN.
• Done exports and imports of tables, schemas and tablespaces with datapump.
• Archive weekly all production database exports to Tapes.
• Developed and enforced both database and OS-level security policies for data protection.
• Monitored all the databases in the areas of maintenance, tuning, performance, and troubleshooting.
• Installed and configured OEM 12c and monitored databases from OEM 10g/12c.
• Post installation process, kernel upgrade, applying support packs and add-ons.
• Worked extensively on Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics.
• Worked extensively on monitoring grid control database, configuration of error notifications, installing listeners, and adding them to the grid control.
• Efficiently used Oracle Tools like OEM, SQL Plus, SQL Loader, TKPROF, LOGMINER, AWR, ADDM, STATSPACK, Data Pump, FLASHBACK and RMAN.
• SQL tuning and Database tuning has been done based on reports generated by Run time SQL execution plans, AWR Reports, ASH reports, Explain Plans and monitor the database performance on daily basis.
• Developed Scripts for transferring data from production server to testing/development servers.
• Cloning of databases using RMAN and also user managed.
• Management of databases on multiple servers.
• Developed table structures, PL SQL stored procedures and database triggers to implement business rules.
• Managing and providing 24X7 supports for various versions of databases.
• Performed on-call technical support to minimize the impact of system disruptions.

Environment: Oracle 10g,11g,Linux 6.3, Oracle Enterprise Manager, Grid Control, HP-UX, AIX, Windows 2003, OEM Database control, PL/SQL, Oracle SQL Developer, Shell Scripting, TOAD, ASM, Golden Gate, Data Guard.

Confidential

Role: SR. Oracle DBA

Responsibilities:

• performed fresh installation of 11.2.0.3 RAC on Automatic storage Management and created databases in RAC environment
• Migration of SQL SERVER databases from 2005 to 2008.
• Installed OEM repository database, 12c agents on hosts and discovered targets and created new Groups, Templates, Incident Rule sets in OEM 12c
• Configured Physical standby, Snapshot Standby and Active data-guard and performed Troubleshooting data guard environment
• Up-gradation / MIGRATION of dev/test/prod databases from 10g to 11g
• Migrated applications from Unix to Linux using golden gate with minimum down time and resolved issues in golden-gate
• Applied patch set and interim patches whenever required to make the database software up to date
• Involved in measuring smart scan, storage index and measuring offload statistics for individual SQL Cursors on Exadata
• Focusing on Exadata administration
• used Flashback mechanism for logical corruption of databases
• Installed and Implemented Backup Recovery procedures, Implement Hot, Cold and Logical backup plans
• Performed tasks like Database Sizing, Table space Management and Rollback Tablespace Management, Transaction Management and Security Administration
• cloned databases for development and test environments using RMAN
• Taking periodic Backup of the Database and the software using RMAN and supporting VERITAS Net-backup Team
• Creation of Users and granting them the required Roles and Privileges accordingly and Involvement in space management, rectification of lock problems, managed quotas
• Managed Oracle space, performed Oracle table space management tasks, maintained tables, database objects and Rebuilding indexes for better performance of Oracle database.
• Worked extensively in Performance Tuning at various levels including instance tuning, Query tuning, Database performance tuning
• Used oracle tools like AWR, ADDM, Advisories, TKPROF, EXPLAIN PLAN for the Better database performance
• Extensive Performance Tuning, Memory SGA Tuning, RAID, RAW Devices
• Involved in Writing SQL scripts to monitor table space and extent growth
• Familiar with ORA-600 error Involved with this ERROR
• Provided support to Application Database Administrators in designing the database
• Tested many scenarios in RAC, Dataguard and RMAN environment
• prepared documentation for maintenance, knowledge transfer and Mentoring level 2 DBA's
• 24 X 7 Production database administration, support and monitoring to ensure Proactive problem recognition and resolution of database issues

Environment: Oracle 10g/11gR2, Sun Solaris 5.9, RHEL 5.x, OEL 6.3, OEM 11g/12C, EXADATA, RAC 10g/11g, ASM, Data guard 10g/11g, Data pumps, RMAN, TDE, AWR, ADDM, ASH, TTS.

Confidential

Role: Oracle DBA

Responsibilities:

• Installation, configuration and maintenance of Oracle 11g databases
• Estimated growth of database size by detail analysis of the company's future policies and generating reports for the management to act in advance.
• Performed up-gradation of grid infrastructure from 11.2.0.2 to 11.2.0.3
• Performed health checks of RAC instances using Crsctl and Srvctl utility
• Worked on X3-2 machine half RAC
• Worked on some stages in Exadata performing Smart scan, Storage Index, DBFS mount points and Flash cache
• Focusing on Exadata administration.
• Monitoring and managing of Oracle instances using Enterprise Manager Grid Control OEM grid 11g/12C
• Configured pfile, Listener and Net service names manually for production and physical standby databases in Data-guard environment
• Migrated databases from File system to ASM troubleshooting issues in ASM 11g
• Installed Golden Gate for replication between cross platforms
• Configured parameters files for extracts, replicat's
• Applied patches on standalone servers using Opatch utility
• Performed Migration of databases from 10g Unix to 11g on Linux
• Implemented data transfer using Data Pumps and Export/Import utilities
• Registered databases in catalog server and Performed Cloning of databases using RMAN from production to test and dev environment
• Involved in scheduling incremental, cumulative and full backups and configured retention policy using RMAN
• Configured listener for external procedure calls, Worked closely with ETL applications team
• Performed daily maintenance tasks like space management, rectified locking problems, managed quotas
• configured network components like TNSNAMES, Names Server, Connection Manager, for easy and effective management of Oracle networking
• Extensively used AWR, ADDM and EXPLAIN PLAN for Generating reports
• Develop and enforce both database and OS-level security policies for data protection.
• Involved in Setup the Oracle Wallet for Encryption Functions and Expertise in protecting the Oracle wallet with ACFS access controls
• Created Tables That Contain Encrypted Columns and Oracle Wallet Management for Transparent Data Encryption
• Involved in administration of all databases in the areas of maintenance, tuning, performance, and troubleshooting and debugging SQL/PL SQL involved in Application development
• Efficient in using the Oracle Tools like OEM, SQL Plus, SQL Loader, TKPROF, LOGMINER, STATSPACK, SQL Net, IMPORT/EXPORT, and RMAN
• Involved in writing for shell scripts for monitoring health checks and also for taking RMAN backups and Developed Scripts for transferring data from production server to testing/development servers

Environment : Oracle 10g, 11gR1,11gR2 AIX 6.1, HP-Unix 7i , OEM, DBUA, RMAN, People-soft, Golden gate, Grid, RAC, ASM, Data guard, SQL LOADER, AWR, ADDM, ASH, TTS, Oracle Wallet, TDE, Data pumps

Confidential

Role: Oracle DBA

Responsibilities:

• Worked on database Sizes > 3TB
• Responsible for capacity planning, database security, recovery planning and installing patches
• Involved in UP-GRADATION of databases from 10.2.0.2 to 10.2.0.4 on Sun Solaris
• Installed 10.2.0.4 agent and involved in registering of databases in OEM
• Installed STANDALONE servers on ASM and migrated databases to ASM
• Worked extensively on monitoring 10g grid control database, configuration of error notifications, installing listeners, and adding them to the grid control
• Collected ADDM recommendations using OEM 10g/11g to tune the TOP running SQL Query's
• Implemented Disaster Recovery Plan for critical databases using DATAGUARD
• Worked on physical and snapshot standby 11gR1 databases in Data-guard environment
• Involved in construction of Disaster Recovery DR for all the production databases using DATAGUARD
• Performed Database Refresh from production to testing and development environment and used EXPDP for schema level
• Worked closely with PL/SQL developers for fine performance tuning
• Supported development teams by providing SQL statement tuning and removing load and query performance bottlenecks by using tools EXPLAIN PLAN, STATSPACK, and TKPROF
• Experienced in scheduling the database backup jobs using Crontab
• Created a Clone database using RMAN on remote server
• Involved in database design and used Erwin as a Data Modeling tool Designing the ETL processes
• Involvement in space management, rectification of lock problems, managed quotas
• Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical I/O and Memory Usage.
• Created and monitored database objects like Tables, Indexes, Views, Users and DB links
• Conducted time to time analysis and monitoring of the software and hardware requirements and act accordingly.

Environment: Oracle 11g/10g, Windows 2008, Sun Solaris 5.x, Oracle RAC, TOAD, VERITAS, OEM, LOGMINER, Informatica, DB Links, SQL, PL/SQL, TKPROF, EXPLAIN PLAN.

Confidential

Role: Oracle Developer/DBA

Responsibilities:

• Configured Oracle Data-guard for Oracle Disaster recovery on 10g Solaris.
• Achieved High availability, Data protection and maximum performance by maintaining physical standby databases
• Implemented Oracle database backup recovery solutions using RMAN
• Configured and Tuned RMAN for better performance and backup strategies
• Involved in writing for shell scripts for taking RMAN backups
• Worked extensively on performance tuning of queries by maintaining Aggregates, Compression, partition, indexing and use of statistics
• Restored and Recovered database at the times of occurrence of critical failures.
• Created user accounts, roles and granting required access permissions and privileges to the database based on the application they are accessing
• Performed large batch jobs and tuning of SQL queries and database systems
• Monitored Oracle Instances, Users, Tables, Table-spaces, Memory structures, and Rollback segments, Redo-logs, Archived Redo-logs and Alerts
• Performed automated backups and scheduling using scripting
• Written Stored Procedure and Triggers for database maintenance and management using PL/SQL and Involved in gathering requirements from end users
• Estimate growth of database size by detail analysis of the company's future policies and generating reports for the management to act in advance
• Clear documentation was prepared on all the processes like program specification, bugs fixing logs change requests for future reference

Environment: Oracle /10g/9i, Sun Solaris 5.x, HP-UX 7.x, OEM 10g, Shell Scripting, TOAD, putty, STATSPACK,EXPLAIN PLAN.