CAREER OBJECTIVE

To work as Senior Oracle DBA/Technical Specialist/Consultant position in a challenging environment where I can utilize my experience with an opportunity for growth and advancement.

SUMMARY:

• Oracle Certified Professional Database Administrator (OCP) and Microsoft Certified Database Administrator (MCDBA).
• Over 20 Years’ experience of Database / Design / Migration / Transformation/ Implementation / Support and Administration.
• Extensive project management Lead experience.
• Problem solving, data gathering, analysis and translation of Business Requirements.
• Strong hands - on experience batch scripting.
• Excellent oral, written and presentation skills.
• Extensive experience of RAC / Data Guard / Golden Gate /Replication / Failover Clustering / Log Shipping/Database Mirroring /Performance Tuning / Disaster Recovery / RMAN / DTS / ETL / Data Warehouse / Change Management / Security Administration .

TECHNICAL SKILLS:

Operating Systems:: UNIX (Solaris, HPUX, AIX ), Windows ( NT, 2000, 2003, XP )

Databases & Tools:: Oracle 7.3, 8.x, 8i, 9i, 10g, SQL Server 2000, 2005, SQL, PL/SQL, Quest Tools (TOAD, SQL*Navigator, Spotlight, Space Manager, Schema Manager), SQL*NET, Imp/Exp, Exceed, Reflection, OEM, MMC, Query Analyzer, RMAN, SQLLDR, TKPROF, Statspack, AWR, ADDM, Web Logic, Broadvision, Iplanet, E-Trust, OEM Grid Control

High Availability Technologies: RAC, DataGuard, Standby Database, Replication, Log Shipping, Database Mirroring, Always On, Failover Clustering, Sun Cluster, Veritas Cluster (Storage Foundation for RAC, SFRAC), HP MC Service Guard, Windows Cluster, SGeRAC, Storage Area Network (SAN): EMC (VMAX/SSD), IBM (3PAR), ZFS, PURE Storage HP XP Disk Arrays, HP EVA6000, Veritas Cluster File System (VCFS), UNIX Raw Devices, EMC Thin Provisioning

Backup Tools:: Veritas Netbackup, HP Data Protector, EMC BCV, EVA6000, SnapClone

Change Management Tools: ServiceNow, Infoman, HP OpenView ServiceDesk

Batch Scheduling Tool: Autosys, AppWorx

EMPLOYMENT HISTORY:

Confidential, Miami, FL

Sr. Oracle DBA

• Lead and responsible for Oracle and SQL Server databases patching (CPU, PSU, one off patches).
• Responsible for planning and implementing Exadata and ODA Patching strategy using N-1 approach.
• Lead and responsible for Exadata and ODA deployments from end to end including connectivity to ZFS over InfiniBand Interface for faster database backups / restore (Exadata X2-2,3-2,4-2,5-2,6-2,7-2)
• Plan and implement Oracle Databases Migration strategy from HP UX to Exadata,
• Performed Oracle Databases Migration from Exadata to Linux VMs connected to PURE SAN (SSD)
• Implemented Golden Gate in High Availability setup by setting up GG Master on Failover IP on Exadata and define this Failover VIP as Oracle CRS Resource for HA Solution.
• Migrate/Upgrade Oracle 9i databases to Oracle 10g R2.
• Migrate/Upgrade Oracle 10g R2 databases to Oracle 11g R1 and Oracle 11g R2.
• Install and configure Oracle RAC 10g and 11g on Sun Solaris servers.
• Plan and implement strategies to migrate all NON-ASM databases to ASM on standalone and RAC databases.
• Plan and implement Disaster Recovery solution for business critical databases using Physical Standby databases.
• Design and implement infrastructure for Oracle Enterprise Manager (OEM).
• Installed and configure oracle 10g, 11g databases on Linux, Solaris and HP UX based servers and applied the 10.2.0.4 and 11.1.0.7 patch set respectively on Test and Production environment, also applied Quarterly Patches and supported non-prod and prod databases.
• Recover/Cloned the database from ASM to ASM, ASM to File System, File System to ASM using RMAN duplicate command.
• Extensive use of Data Pump expdp/impdp to clone/refresh Schema, database from Production to Test and Development Environment.
• Created (Dataguard) physical standby database as DR Solution for production database using RMAN create standby database command, also setup Data Guard Broker to manage data guard environment.
• Database management include physical storage management such as data files, control files and redo log files.
• Database sizing, space requirements analysis and space management using shell scripts and PL/SQL code.
• Created and Implemented security policy for database users by creating appropriate Roles, privileges.
• Created partitions on tables and Indexes as part of performance improvement.
• Created required database objects (tables, global temporary tables, Index organized tables, views, indexes, synonyms, packages, procedures, functions, triggers etc.)
• Performance Tuning for long running queries using AWR reports, analyze, DBMS STATS, SQL trace, explain plan. Re-designing of tables into partitioning tables. Analyzing existing table structures and fine tuning if required.
• Gather stats for tables, Indexes to help with performance improvement.
• Design and implement a business management process (BPM) for EXP MACESS application on SQL Server 2005 Failover Clustering with DR solution using Database Mirroring.
• Documenting project activities periodically.

Confidential

Sr. Oracle DBA

• Worked as a Lead of HA (High Availability) databases deployment / support team, focusing on 7*24 * 365 up time of mission critical databases.
• Installed Oracle Binaries 11.2.0.4, Configured Very Large Databases (VLDB) using Oracle RAC.
• To manage regular databases maintenance performing de-fragmentation / re-building indexes etc.
• To implement code drops to enhance business functionality.
• To implement databases monitoring using HP Openview / DBMON and configure ITO alerting which routed all databases related critical issues to DBA-On-Call pager for immediate attention.
• To Implement EMC BCV / HP XP-Disk Array Re-Sync and Split mechanism for VLDB, to perform Online database backups within very short time interval (1 - 2 hours depending of database sizes and activity since last split).
• Worked with vendors (Oracle / Microsoft) support for various database related issues on variously severity cases...
• Configured online full database backups using RMAN / HP Data Protector for small - medium size databases.
• To Install Oracle Binaries / patches / critical patches for 10g RAC and databases migration from OPS to RAC.
• To perform performance tuning of oracle RAC at instance level and to perform SQL Optimization for better execution.
• To Configure Transparent Application Fail-over (TAF) for Oracle RAC.
• Configured OEM on Sun Solaris Box to monitor all production databases.
• To gather volumetric information for Capacity Planning, on databases especially having very high transaction rates.
• Tune and configure Oracle RAC for improved functionality (undo management, SGA and PGA resource Allocation).
• Worked on VLDB up to size of 7TB.
• Configured Standby databases on OPS databases using SRDF technology of EMC, rolled forwarded standby databases located at two geographical different locations (no direct connectivity b/w Primary and Standby servers due to much secured firewalls, so we opted to use SRDF for archived logs transportation).
• Configured Dataguard (using Physical Standby Approach) on Oracle RAC in Max Performance and Max Availibility Modes.
• Worked with QA/Testing team, to verify fail-over testing for common scenarios including node and component failure in Oracle RAC using shutdown transaction on database level and simulating server failure ( typically performing init 6 on Sun Solaris servers).
• Designed and implemented disaster recovery scenarios, validated by testing.
• Implemented ETL jobs for this SQL Server Failover Clustering using DTS.
• Due to huge size of these SQL Server databases EVA6000 SnapClone was implemented for backups (Freeze I/O at database instance level and perform Split) and Split copy the backed up to tapes during business hours causing no impact to Production Databases and can be copied back to production instance in case of disaster.
• Transaction Logs of these SQL Server were backed up using Data Protector to perform point of Failure Restore / Recover.

Confidential, Miami, Florida

Database Administrator

• Identify performance bottleneck on high volume transaction systems. Analyze SQL statements by using explain plan and tkprof, generate Statspack reports and tuned most waited events.
• Implemented Table / Index Partitioning for Very Large tables, having size more than 30GB and wrote customize scripts, which perform partition split at end of each month, create partition for new month and purge the oldest partition, using this approach data retrieval / insertion etc performance dramatically increased.
• Automated Oracle (RMAN) and MS SQL Online Database backups through scheduling Tools
• Automated Database Refresh / cloning jobs for Reporting and Development needs.
• As DBA Team Lead, manage and Mentor Database Administrators Team.
• Being DBA Lead, created Road Maps, Future Strategies and Presented to Management for awareness and approvals to keep up with Database Industry Trends.
• Attended Oracle Open World in San Francisco in 2008 to keep up with Latest Database / Appliances Industry Trends.
• Scheduled quarterly Database Audit Reports for AvMed Security Team for Compliance.
• Configured Data Guard using Physical Standby option for Tier 1 Oracle Databases at DR Site.
• Configured Log Shipping for MS SQL Tier 1 databases at DR Site.
• Configure Maintenance jobs for Stats Gathering / Index Rebuild and Listener logs rotation etc for Oracle Databases.
• Configured Maintenance jobs for Stats Gather and Index Rebuild for MS SQL Databases.
• Helped tuning databases queries to improve performance on high transaction systems
• Support several vendors’ health industry application databases including Billing, Claims, Member Services like Amisys, ClaimsXten, Acuity, Macess EXP, Pivotal, Taurus, EDI etc.
• Created goals and guidelines for system-wide performance and infrastructure usage, establishing performance baselines and management of any deviations.
• Assess change requests, defects, trouble reports, and ad hoc database query requests and make recommendations to management / development teams on design approaches and alternatives.
• Skilled in scripting to automate DBA tasks
• Proven analytical and problem solving skills with ability to adapt in a dynamic environment
• On call rotation and after hours support
• Upgraded Oracle Databases from 9i to 10g
• Upgraded MS SQL Databases from MS SQL 2000 to MS SQL 2005 / 2008 R2.
• Migrated Amisys database to HP9000 to Oracle Platform, this was one of the major and critical Project at AvMed.
• Migrated Macess EXP from Standalone Server to Windows 2005 Cluster using MS SQL Failover Cluster for High Availability.
• Setup up Windows Cluster with MS SQL 2005 Failover Clustering for Acuity as medical platform critical databases.

Confidential

Database Consultant

• Project lead of HA (High Availability) database deployment / support team, focusing on 7 X 24 X 365 up time of mission critical databases.
• Identify performance bottleneck on high volume transaction systems. Analyze SQL statements by using explain plan and tkprof, generate Statspack reports and tuned most waited events.
• Perform pro-active and regular databases maintenance tasks such as de-fragmentation / re-building indexes, etc.
• Implement code drops to enhance business functionality.
• Implement databases monitoring using HP Openview / DBMON and configure ITO alerting which routed all databases related critical issues to DBA-On-Call pager for immediate attention.
• Implement EMC BCV / HP XP-Disk Array Re-Sync and Split mechanism for VLDB, to perform Online database.
• Worked with vendors (Oracle / Microsoft) support for various database related issues on variously severity cases..
• Configured online full database backups using RMAN / HP Data Protector for small - medium size databases.
• Install Oracle Binaries / patches / critical patches for 9i, 10g RAC and databases migration from OPS to RAC.
• Perform performance tuning of oracle RAC at instance level and to perform SQL Optimization for better execution.
• Configure Transparent Application Fail-over (TAF) for Oracle RAC.
• Gather usage information for capacity planning, on databases specially having very high transaction rates.
• Tune and configure Oracle RAC for improved functionality (undo management, SGA and PGA resource Allocation).
• Worked on VLDB up to size of 2TB.
• Configured Dataguard (Physical Standby) on Oracle RAC in Max Performance and Max Availability Modes.
• Write customized scripts, which check the Both Databases within Dataguard are in Sync., Archived Logs Gap Status, and delete archived log from Standby after making sure, they have been applied to Standby databases for Oracle 9i.
• Implemented Table / Index Partitioning for Very Large tables, to improve performance.
• Implemented Oracle 9i High Availability Solutions using HP MC Service Guard, on multi nodes clusters, and configured Listeners on all nodes at Virtual IP for Clustered Oracle Package, so that application connectivity to database is independent of node name.
• Wrote various UNIX shell scripts to automate various daily routine jobs, for example exp/imp, schema cleanup for Testing / QA teams etc.
• Recommended standards, guidelines, procedures and policies to ensure best practices, that is, outlined various regular routine checks.
• Worked with QA/Testing team, to verify fail-over testing for common scenarios including node and component failure in Oracle RAC using shutdown transaction on database level and simulating server
• Designed and implemented disaster recovery scenarios, validated by testing and used a few times, in real disasters.
• Installed / implemented SQL Server 2000 / 2005 Multi Instance, Failover Clustering on multi nodes windows clusters where SQL Server binaries were installed locally and databases were configured on SAN (HP EVA6000), databases sizes were well above 4 Tera Bytes. (It’s a Joint Venture.
• Implemented ETL jobs for SQL Server Failover Clustering using DTS.
• Implemented Log Shipping for various pairs of SQL Servers.
• Upgraded SQL Server databases from 2000 to 2005, implemented Service Packs and hot fixes.
• Good exposure of to change management procedure as ITIL framework, useing infoman and OVSD software tools, to create various change orders / incidents / problem records, make sure to get all necessary approvals before implementing any change to database, in order to make sure, all activity should be logged for any audit purpose.
• Oracle 10g RAC on Extended Distance Cluster

Confidential

System Administrator/Oracle DBA

• Re-engineering of an existing LAN, implementing DHCP, DNS, IIS, WINS coupled with the upgrade of all existing servers to NT 4.0.
• Assisted in the upgrade and troubleshooting of Microsoft Exchange Server 5.0 concurrent with the roll out of a combination of Outlook 97 and the latest Exchange Clients.
• Responsible for reviewing all error logs and directing that necessary action is taken to reduce overall faults.
• Reviewed, evaluated and recommended software for inclusion in a new standard desktop environment along with multiple Network Monitoring programs that would allow operation with proper System Security, and the smallest number of onsite personnel possible.
• Deployed network printers using HP Jet Direct hardware and software.
• Normal end user support and emergency support as needed.
• Installation/Upgrade of Database to Oracle to current release.
• SGA tuning to avoid fragmentation of shared pool and memory structures.
• Database Sizing, tablespaces and Rollback Segments management.
• Developed and implemented methods and procedures for monitoring and maintaining production, test, and QA, Reporting and Training databases.
• Monitoring and tuning the application code using TKPROF, Explain Plan and SQL Trace.
• Developed, tested and implemented the hot backup strategy for production databases using RMAN.
• Used IMP/EXP utilities with different parameters and used memory pipes for bigger size dump files preparation through export and then imports that dump file whenever need arises.
• De-Fragmented indexes and tables by rebuilding and moving to other segments.
• Continuously monitoring the tablespace fragmentation, disk space capacity, objects requiring more extents and free space.
• Monitoring and tuned the performance variables for paging rate, disk I/O, data dictionary, buffer and library cache miss ratios.
• Worked with Oracle support for various Oracle database related issues.
• Provided support to Unix Administrators to configure Storage Solution and performed testing of all possible scenarios of database/tablespace/datafile backup/restores and recover.
• Configure and support Standby databases.
• General Oracle DBA Support to Production, UAT, Development, Quality Assurance, Reporting environments.
• Prepare support documentation for database operation and to cross train UNIX and NT Administrators.