PREFESSIONAL SUMMARY:

• Around 8+ years of experience in Oracle 11g/10g/9i DBA and have been involved in Installation, Configuration, Up gradation, Patching, Backup and Recovery, Migration, Memory and Space Management, Cloning, Replication, Performance Tuning, RMAN, RAC, Data Guard, OEM Grid Control.
• Experience in Installation, Configuration and Troubleshooting of Oracle Database on Solaris OS, IBM - AIX, Red Hat Enterprise Linux (RHEL) and Windows on highly transactive and Very large databases (VLDB).
• Expert level experience in Oracle 10g RAC implementation & administration using Oracle Cluster-ware, Sun Cluster and VERITAS Cluster Server (Oracle Cluster ware setup and configuration, RAC installation, Configuration and Patching, RAC Backup and Recovery)
• Configured Automatic Storage Management (ASM) to fulfil storage needs.
• Experience in Implementing, configuring, trouble shooting, switchover, failover of Physical Standby Data Guard on 10g and 11g.
• Configured and maintained replication using Oracle Golden Gate.
• Experience in Backup & Recovery techniques of databases running in ARCHIVELOG MODE using RMAN.
• Experience in Cumulative and Differential Incremental backups using RMAN.
• Used ADDM (Automatic Database Diagnostic Monitor), AWR (Automatic Workload Repository), and ASH (Active Session History) for analyzing the database performance and tuning.
• Experience in up gradation of Data bases in 10g and 11g.
• Experience in Data Migration using Data pump utility.
• Database Refresh from Production to Development and from Development to Test environments.
• Replication of tables to cross platform and Creating Materialized Views.
• Managing Table/Index segments, Rollback Segments, Undo Segments, and Constraints.
• Planning and scheduling Physical Backups (offline/online) and Logical Backups.
• Experience in implementing Flash Back Pointing Time Recovery.
• Experience in User Management by Granting, Revoking Privileges according to requirement.
• Experience in Space Management by Monitoring and Managing Tablespaces.
• Keeping the database up to date by applying the latest CPU and PSU using the OPATCH utility.
• Configured network components like TNSNAMES, Names Server, Connection Manager, etc. For easy and TEMPeffective management of Oracle networking. Configured Listener for external procedure calls.
• Performance Tuning of SQL statements and Database using tools like Explain plan, TKPROF, SQL Analyze, STATSPACK and Dynamic Performance Views.
• Diagnosed and trouble-shooted typical SQL Tuning issues using SQLTXPLAIN.SQL
• Experience in Partitioning and creating Global, Local Indexes on Partitioned Tables.
• Experience in Administering Oracle Database using Oracle Enterprise Manager, Toad, PL/SQL Developer.
• Managed Databases on Exadata Machines.
• Monitoring Alert log for any errors and issues.
• Communicated and interfaced with Oracle support via Metal-link to troubleshoot day-to-day database issues.
• Experience in UNIX shell programming.
• Hands on experience working on High Availability Environments.
• 24 X 7 Production Database on Call Support.
• Strong analytical and problem solving skills. Willingness and ability to quickly adapt to new environments and learn new technologies.

TECHNICAL SKILLS:

Operating Systems: Red Hat Linux RHEL 2.1, 3.x, 4.x, 5, Windows 95/98/NT/2000/XP Sun Solaris 2.5, 2.6, 8, 9, 10, AIX 5.1, 5.2,5.3 and HP UNIX.

RDBMS: Oracle 11g R1/R2, 10g R1/R2,9i.

Languages: UNIX Shell Scripting SQL, PL/SQL, C, HTML.

Tools/Utilities: RMAN, OEM, Oracle Management Server, SQL*Loader, SQL Server, Export/Import, TOAD, Data pump, VB, MS Access, Oracle Streams, VMWARE, VSS, VERITAS Net Backup, Quest, Putty, VERITAS cluster manager.

Tuning Tools: AWR, ADDM, TKPROF, EXPLAIN PLAN, STATSPACK, AND ASH.

Database Modelling: Erwin 4.0, 7.3; Oracle Designer.

PROFESSIONAL EXPERIENCE:

Confidential, TX

SR ORACLE DBA.

Responsibilities:

• Installed, configured and maintainedOracle 11GR2Real Application Cluster (RAC)4 node RAC on Linux servers 5.8
• Installed, configured, and maintained Oracle 11g R2 on RHEL and also Upgraded from Oracle 11g to 12c
• Implemented new TDE setup on 11g and 12c on all Ticketing Database
• Applied level n-1 PSU patch set update on supported database on quarterly release.
• Performed schema refresh every 9 weeks on all INT, CERT and PROD database.
• Created services in RAC USING SRVCTL and Used CRSCTL to manager cluster ware resources
• Troubleshooting RAC wait events and improving performance of database
• Execute changes to database based on preapproved change requests
• Backup/Restore & Recover of the databases using RMAN and FLASHBACK database procedures.
• Implementing Best Practices for migration regular databases to Oracle Exadata
• Backup and recovery procedures using RMAN. Created scripts for RMAN incremental backups and also for full database backups using datapump.
• User management, Table space management, file system space management, backups management
• Expertise in troubleshooting RAC issues, very strong in using ocrconfig to backup OCR and Voting files
• Implementeddatabase refreshwith the hotbackup using full export. Used EXPORT/IMPORT to do table level and full database defragmentation.
• Monitor disk space, database health checks, database backups and error log scanning. Configure Servers to achieve the best performance
• Troubleshooting RAC wait events and improving performance of database
• Experience working with Database Resource Management
• Responsible for granting required privileges and roles to users.
• Monitoring Alert log file and Trace file.
• Monitoring performance using Advisors, AWR, ADDM, SQL Tuning etc.
• Upgrade the database by applying patches using OPatch.
• TEMPEffective Production Support and off hour support, support handover, off-shore co- ordination.
• Involved in creating Golden Gate EXTRACT and REPLICAT files
• Performed Schema as well as Table level Replication using Oracle Golden-Gate
• Set up Disaster Recovery solution using Golden-Gate.
• Install and configure Cloud Control 12c(OEM) and deploy 12c agents

Environment:Oracle 12c/11g/10gon Unix/Aix/Linux,Oracle 11g,Red Hat Linux 5.8, AIX 6, OEM 12c, RAC, Oracle Advanced Security, Golden gate 11.me, Sybase, Teradata, DBMS COMPARISION, Logdump, Defgen utility, 12c Data guard including DG Broker setup, DGMGRL, RMAN, Partitioning, Compression, OEM 12c, RAC, Pluggable databases, DBFS, Performance tuning, OPatch Auto.

Confidential, Chicago, IL

SR ORACLE DBA

Responsibilities:

• Installed, configured, and maintained Oracle 10g and 11g R2 on RHEL and also Upgraded from Oracle 10g to 11g
• 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.
• Migrated 30 TB Databases from HP UNIX to RHEL with minimal down time.
• Used to perform backup and recovery using VERITAS Netback-upintegrated intoRMAN.
• Involved in migration of applications of the clients.
• Responsible for setup and implementation of 4 Node RAC on RHEL 12c.
• Performed daily maintenance tasks like space management, rectified locking problems, managed quotas etc., configured network components like TNSNAMES, Names Server, Connection Manager, etc. for easy and TEMPeffective management of Oracle networking. Configured listener for external procedure calls.
• Perform Daily Monitoring of Oracle Instances, monitor users, and table spaces, Memory Structures, Rollback Segments, Logs and Alerts.
• Oracle Goldengate Installation for EDGE application, configuration and maintenance
• Upgrading the Oracle 10g to the latest Release 2 and applied patches as required.
• Used to Perform Cold/Hot Backups and also performed database cloning using RMAN.
• Upgrading the Oracle 10g to the latest Release 2 and applied patches as required.
• Daily Health Check Up of the Database using AWR, ADDM.
• Configured Flash Recovery Area in Dev databases.
• Replication of tables to cross platform and Creating Materialized Views.
• Database backup & Recovery with export and import for non-archive and archive database with RMAN commands.
• Assisted in management and database administration of Oracle database applications on Exadata platforms
• Worked on Hybrid Columnar Compression (HCC) dat provides dramatic reductions in storage for large databases
• Participated in analysis and designing of Oracle Exadata Server for infrastructure and related projects.
• Assisted in integration of Exadata applications into current IT actionable events and solutions.
• Migrating databases to Oracle Exadata Database Machine for different clients
• Develop and enforce both database and OS-level security policies for data protection.
• Administer all databases in the areas of maintenance, tuning, performance, and troubleshooting.
• Efficient in using the Oracle Tools like OEM, SQL* Plus, SQL* Loader, TKPROF, LOGMINER, STATSPACK, SQL*Net, IMPORT/EXPORT, and RMAN.
• Developed Scripts for transferring data from production server to testing/development servers.
• Diagnosed and trouble-shooted typical SQL Tuning issues using SQLTXPLAIN.SQL
• Shell scripting and PL/SQL programming to resolve business problems of various nature.
• Migration of database from one server to another server.
• Managing databases on multiple servers.
• Developed table structures, PL*SQL stored procedures and database triggers to implement business rules.

Environment: Oracle 9.2.0.8/10.2.0.4/11.2.0.3, RHEL 5.8, Hp- Unix 7, Solaris 10, ASM, RMAN, RAC Oracle Enterprise Manager Grid Control, Oracle Goldengate, RDBMS, SQLPLUS, PL/SQL, Shell Scripting, Stored Procedures.

Confidential, BrookField, WI

Sr. Oracle DBA

Responsibilities:

• Installed, configured, and maintained Oracle 10g and 11 g R2 on Linux and also Upgraded from Oracle 10g to 11g
• 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.
• Responsible for setup and implementation of 3, 4 Node RAC on Linux in 10g and 11g R2 using VERITAS Cluster Server.
• Configured and maintained Oracle Cluster-ware.
• Configured and maintained replication using Oracle Golden Gate.
• Used to Perform Cold/Hot Backups.
• Used to perform backup and recovery using VERITAS Net Backupintegrated intoRMAN.
• Implemented and Managed Oracle Data Guard on Oracle 11gR2
• Upgrading the Oracle 10g to the latest Release 2 and applied patches as required.
• Perform Daily Monitoring of Oracle Instances, monitor users, and table spaces, Memory Structures, Rollback Segments, Logs and Alerts.
• Daily Health Check Up of the Database using AWR, ADDM.
• Configured Flash Recovery Area in Dev databases.
• Involved in migration of applications of the clients.
• Created Users with limited rights as per specific module under specific client. Granting roles and profiles as per system study to users.
• Replication of tables to cross platform and Creating Materialized Views.
• Performed daily maintenance tasks like space management, rectified locking problems, managed quotas etc., configured network components like TNSNAMES, Names Server, Connection Manager, etc. for easy and TEMPeffective management of Oracle networking. Configured listener for external procedure calls.
• Database backup & Recovery with export and import for non-archive and archive database with RMAN commands.
• Also configured database cloning using RMAN.
• Implemented Data Guard on production database.
• Develop and enforce both database and OS-level security policies for data protection.
• Administer all databases in the areas of maintenance, tuning, performance, and troubleshooting.
• Efficient in using the Oracle Tools like OEM, SQL* Plus, SQL* Loader, TKPROF, LOGMINER, STATSPACK, SQL*Net, IMPORT/EXPORT, and RMAN.
• Developed Scripts for transferring data from production server to testing/development servers.
• Shell scripting and PL/SQL programming to resolve business problems of various nature.
• Developed and maintained the applications by utilizing ASP.NET.
• Migration of database from one server to another server.
• Managing databases on multiple servers.
• Disk Space Monitoring.
• Developed table structures, PL*SQL stored procedures and database triggers to implement business rules.

Environment: Oracle 10.2.0.3/11.2.0.3, Linux, Solaris 10, ASM, RMAN, RAC, Oracle Enterprise Manager Grid Control, RDBMS, SQLPLUS, PL/SQL, Shell Scripting, Stored Procedures.