SUMMARY

• 7+ years of experience in Oracle Software Installation and configuration, database server administration, database performance tuning, backup and recovery, database design and modeling.
• Proficient, hands on experience using advanced features such as RAC, Data Guard, Oracle Streams, Database Cloning, memory management, data warehousing, patches, data security and grid control.
• Administered oracle 11g/10g/9i/8i databases (OLTP, OLAP) on platforms HP - UX, SUN Solaris, AIX, RedHat Enterprise Linux and Windows NT.
• Installation, Configuration and Maintenance of Oracle 11gR2/11gR1/10g/ 9i Real Application Cluster Database and achieving High Availability, Performance and Scalability by choosing teh best hardware configuration and determining teh best Cluster architecture for Oracle RAC.
• Expertise in Performing Migration on production, development environments from Oracle 8i/9i to 10g/11g RAC.
• Experience in configuring, managing and monitoring of ASM (Automatic Storage management) for both standalone and RAC databases.
• Expertise in applying Patchset, Critical Patch Updates (CPU)/Patch Set Updates (PSU) and Interim patches using Opatch utility.
• Configured physical and logical Standby databases (Data Guard) for BCP/DRP (Business continuity plan and Disaster Recovery Plan) on various windows and UNIX platforms.
• Experience in setting up, configuration and administration of replication using Oracle Streams (unidirectional table level) and also used Gloden Gate, teh leading data replication tool.
• Performed Backup and Recovery (complete & incomplete) of database, using user managed - HOT, COLD and RMAN- Full database, cumulative and differential.
• Experience in performing SQL, Database and Application Tuning which involves tuning of I/O, Memory, SGA, Shared Pool, Buffers and CPU utilization using Oracle’s performance tuning tools like Explain Plan, SQL Trace, TKPROF, STATSPACK, AWR, ADDM,ASH,ASMM.
• Expertise in cloning and refreshing databases for creating test/staging environments.
• Expertise in implementing advanced Security features like Database trigger, TDE (Transparent Data Encryption), Virtual Private Database (VPD), Auditing, Tablespace Encryption.
• Implemented advanced features in Oracle 10g like Fined-Grained Auditing, RDA, TAF, Flashback technologies.
• Experience in Data Modeling, System Design Using Entity relationship diagrams, Data Flow Diagrams, Normalization for removing data redundancy.
• Experience in solving client connectivity issues using OCI, ODBC, JDBC, and JBoss.
• Expertise in writing SQL, PL/SQL procedures, functions, database triggers, packages.
• Created database objects like materialized views, partition tables, DB links in Data Warehousing environment.
• Experience in handling tools such as Toad, Oracle Enterprise Manager (OEM) Grid Control, Log Miner, DBVERIFY, DBARTISAN, ERWIN, Apache Tomcat and Veritas NetBackup.
• Experience in performing Data Migrations using oracle export/import, DataPump, SQL loader.
• Knowledge of SQL server 2000/2005 administration.
• TEMPEffectively handled multiple tasks simultaneously and has ability to acquire and apply noledge rapidly and also co-ordination wif Oracle Corporation for technical support.
• Self-motivated, reliable player wif set of strong technical, interpersonal & communication skills.

TECHNICAL SKILLS

Operating Systems: HP-UX, IBM AIX, Sun Solaris, REDHAT Linux, Windows.

Databases: Oracle 8i/9i/10g RAC, 11g RAC, MySQL & SQL server

Languages: SQL, PL/SQL, C, Shell scripting, Perl Scripting.

Tools: OEM Grid Control, Data Pump, Exp/Imp, RMAN, TOAD, SQL Loader, AWR, ADDM, STATSPACK, EXPLAIN PLAN, TKPROF, VERITAS NetBackup, LOG MINER, ERWIN, DBartisan, DBVERIFY.

Web Tools: XML, HTML, JavaScript, VB 6.0

PROFESSIONAL EXPERIENCE

Confidential, Burbank, CA

Sr. Oracle DBA

Responsibilities:

• Installed configured and administered 11gR1/R2/10g of a 3 node Real Application Cluster (RAC) on RHEL and configured public and private network.
• Maintaining Oracle10g Real Application Cluster Database for High Availability, Scalability and Performance by determining teh best Cluster architecture and choosing teh best RAC servers.
• Performed adding/removing a node in a 4 node RAC environment.
• Performed Upgrade/Migration of teh oracle databases from Oracle 10.x to 11.2.0.2.
• Successfully implemented physical standby database in maximum performance mode using Oracle Data Guard feature for disaster recovery and high availability.
• Setting up ASM environment and migrating databases from NON-ASM to ASM.
• Cloning of teh production databases using RMAN for staging/testing purposes.
• Successfully applied patch sets CPU/PSU as required, and also interim, oneoff patches using Opatch utility.
• Installed, configured and monitered targets using Oracle Enterprise Manager(OEM) Grid Control, TOAD.
• Performed incremental level 1 differential backups every day and level 0 full database backups weekly using RMAN.
• Performed Point in time recovery (PITR) and Tablespace point in time recovery (TSPITR) using RMAN.
• Implemented Oracle partition tables.
• For migration/cloning of small sized databases used imp/exp utilities 9i/10g and Data pump to migrate data between 10g and 11g environments.
• Efficient in using teh advanced Oracle Tools like ERWIN, RDA, TKPROF, STATSPACK, LOGMINER, SQL Net, Analyze, Data Pump, DBartisan, FLASHBACK, Recycle Bin.
• SQL/memory tuning is performed wif teh help of tools such as TRACE FILE, Explain Plan, and TKPROF.
• Upgrade of MySQL databases from 5.0.5 to 5.5.27
• Backup, export and import of MySQL databases using utilities like mysqldump.
• Managing databases and Troubleshooting Database performance issues using Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM).
• Performed SQL query optimization by optimizing server kernel, instance and adjusting optimizer statistics and parameters.
• Configuration of Listener and Net Service names using NETCA and NETMGR.
• 24x7 on-call production support, ensuring great performance and 99.99% uptime of databases.
• Performed Environment refresh and continuous alert log monitoring.
• Performed teh Detection of corrupted blocks using DBVERIFY utility to improve teh health of teh database.
• Performed space management by assigning quotas and resolving dead locks.
• Proper Operational documentation is maintained.
• Monitoring teh pulse and performing health checks of teh database by writing UNIX, PL SQL, SQL scripts and scheduling cron jobs on teh database servers.

Environment: - Oracle 9i, 10g RAC and 11g RAC, Oracle Streams, ASM, Data Guard, SQL Server 2005, Oracle Enterprise Manager (OEM) Grid Control, RMAN, VERITAS Net Backup, Opatch, Data Pump, SQL Loader, TOAD, PL/SQL Developer, MySQL, HP-UX 11, RHEL 4.x and 5.x and Sun Solaris10, Windows.

Confidential, Harrisburg, PA

Sr. Oracle DBA

Responsibilities:

• Installed, configured and maintained Oracle 11gR1/11gR2/10g RAC (Real Application Cluster) 2-node.
• Implemented TAF, FAN and Load Balancing for RAC environment to achieve high availability.
• Performed Performance Tuning and Monitoring for Oracle Real Application Clusters, OEM on Sun Solaris platform wif ASM and NFS (network file system).
• Installed, configured and administered OEM Grid Control.
• Performed Migration of production, developmentenvironments from Oracle 8i/9i toOracle10g RAC environment.
• Successfully Created Logical Standby, using oracle Data Guard feature for reporting.
• Applied patches on both client and server, and upgraded patches using Opatch utility.
• Configured and maintained physical standby database (Data Guard) to provide disaster recovery.
• Replicated data using M-view, snapshot and ORM (Oracle Replication Manager).
• Performed migration of data between servers using Oracle streams, Gloden Gate tool.
• Performed SQL Server Replication, Log Shipping and Database Mirroring.
• Experience in installing/configuring Gloden Gate which replicates data between platforms at high level of performance wif guaranteed transaction reliability.
• Worked on Gloden Gate, teh leading tool used for data replication.
• Maintained Database Security by creating users and granting teh users wif appropriate privileges.
• Used Oracle Streams for data replication and loading data warehouse staging areas.
• Replicated data using M-view, snapshot and ORM (Oracle Replication Manager).
• Experience in Data Modeling, System Design Using Entity relationship diagrams, Data Flow Diagrams, Normalization for removing data redundancy.
• Performance tuning of instance, database, SGA, I/O is done efficiently using OEM Grid Control.
• Performed SQL Server Data Transformation Services (DTS).
• Performed backup and recovery of databases using RMAN.
• Performed level 0 backups every week and level 1 incremental backup every day using RMAN and making sure all teh backups are taken wifout any corruption.
• Collecting performance related statistics using AWR, ADDM, and STATSPACK for self-tuning and problem detection.
• Rebuilding indexes to improve performance and for avoiding fragmentation, removing unused indexes and monitoring index usage.
• Successfully implemented automated backups and recoveries using CRON utility.
• Implemented advanced security features such as Database trigger, TDE (Transparent Data Encryption), Virtual Private Database (VPD), Auditing, Tablespace Encryption.
• Utilized Oracle Support and Meta Link to troubleshoot teh problems and issues.
• Transported table spaces between production and development databases.
• Monitoring teh pulse and performing health checks of teh database by writing UNIX, PL SQL and SQL scripts.
• TEMPEffective communication wif UNIX admin to add space and to avoid any space related issues.
• Managed exceptions by setting up alarms.

Environment: - Oracle 10gRAC on Sun Solaris, HP-UX, ASM, Data Guard, Opatch, RMAN, Veritas NetBackup, DataPump, Exp 9i/10g/11g Imp 9i/10g/11g, SQL Loader, Service Now Tool, FTP professional, DBVERIFY, DBartisan, ANALYZE, putty, TOAD.

Confidential, Detroit, MI

Sr. Oracle DBA

Responsibilities:

• Monitored Oracle RAC (Real Application Cluster) 2 node wif ASM on AIX.
• Upgraded databases from Oracle 8i to Oracle 9i.
• Performed migration from 8.1.7.4 to 9.1.0.1
• Implemented Disaster Recovery plan using Data Guard.
• Applied Interim patches on databases using Opatch.
• Installed and Implemented different Backup & Recovery procedures.
• Implemented Hot, Cold and Logical backup plans.
• Backup of database by using Logical (import and export) and Physical (hot and cold) procedures and also using RMAN.
• Perform SQL tuning and assist developers wif coding PL/SQL.
• Implement “Stored Procedures and Triggers” based on business plans using PL/SQL.
• Proactive database monitoring using automated scripts based on v$views.
• Frequent Database audits to maintain teh security standards.
• Performed Auditing activities and Capacity Planning.
• Transported table spaces between production and development databases.
• Performed reorganization of large tables for better performances.
• Used to run teh scripts to check teh status of databases such as growing table sizes, extent allocation, free space, used space, fragmentation etc.
• Performed escalation of different critical TARs.

Environment: - Oracle 9i/10gRAC on AIX, RHEL, RMAN, Opatch, Exp, Imp

Confidential, Cleveland, OH

Oracle DBA

Responsibilities:

• Monitored Oracle RAC (Real Application Cluster) 2 node wif ASM on AIX.
• Participated in Upgrading databases from Oracle 8i to Oracle 9i.
• Performing all teh Database Administration activity like space management in database, user and roles administration, schema management, checking alert log of all teh databases.
• Management of table space growth, monitoring data files additions, extent growth.
• Assisting in planning Backup and Recovery Strategies for various database environments.
• Remote Database Maintenance.
• Done resetting of storage parameters by series of exports and imports of tables, used conventional as well as direct path loads to upload teh data into teh server using SQL loader.
• Performed logical design, modeling, E-R diagram activities using Data Modeling Tools, normalization, indexing, foreign key constraints.
• Resolved Inconsistency Issues, Shared Memory Allocations, long Transactions, Locking Issues and Deadlocks.
• Assured Load balancing, monitored disk I/O statistics, Data file I/O statistics, read/write ratios and fixed problems.
• Multiplexing datafiles redo files and control files.
• Granted/Revoked Permissions to/from users. Enforced usage of Roles.

Environment: - Oracle 8i/9i on RHEL, Windows-NT

Confidential 

Oracle DBA

Responsibilities:

• Performed backup and recovery of databases using RMAN.
• Performed level 0 backups every week and level 1 incremental backup every day using RMAN and making sure all teh backups are taken wifout any corruption.
• Proactive database monitoring using automated scripts based on v$views.
• Frequent Database audits to maintain teh security standards
• Data refresh from Live to Dev using exp/imp and expdp/impdp.
• Creating daily reports for teh Application developers.
• Preparing teh documentation and runbooks.
• Monitoring Cron jobs.