SUMMARY

• 6+ years of IT experience with increasing levels of responsibility.
• Experience managing a Global IT infrastructure team.
• Significant experience with outsourced IT service providers.6+ years of budget responsibility.
• Experience with high volume, high performance database systems.
• Experience with enterprise - scale data warehouse systems.
• Experience saving money and time based on new solutions and proposals.
• Experience in the design, maintenance, and administration of ORACLE 12c/11g/10g/9i.
• Experience writing, creating, and tuning SQL.
• Experience in monitoring and runtime optimization of applications, data jobs, replication, and ETL activities including Informatica.
• Proposed, sold, designed, documented, and deployed many infrastructure projects saving the client significant money in managed cost and cost avoidance. Solutions proposed, architected, deployed include HP-UX to Linux platform migration, New oracle VM farm, disk snapshot and clones, advanced compression, Real Applications Clusters (RAC), Database migrations
• Development and implementation of Enterprise database services standards, guidelines, processes & procedures, and best practices.
• Extensive knowledge on database administration for ORACLE 12c/11g/10g/9iwith experience within very large scale database environment and mission critical large OLTP and OLAP systems
• Expert with planning, creation, administration and troubleshooting of ORACLE 12c/11g/10g/9i OLTP (multiple instances)/OLAP databases in production.
• Handful of experience in Oracle Installations, Upgrades, Patches, Critical Patch Updates (CPU’s) in various environments.
• Worked on HP-UX, AIX, and Sun Solaris, RED HAT Linux and Oracle Linux and Windows environments.
• Implemented OLTP COMPRESSION, PARTITIONING, Hybrid Columnar Compression for databases on EXADATA, and the basic, low, high compression methodologies.
• Installed, configured and maintained databases on EXADATA X2-2 half rack.
• Applying patches using OPatch and OPatch Auto
• OracleGolden Gate installation, configuration, troubleshooting Golden Gate EXTRACT and BIDIRECTIONAL REPLICAT issues.
• Solid experience in disaster recovery, Database backup concepts and options such as user-managed backup, RMAN-managed backup with or without catalog, operating system backup, cold and hot backup, full backup, incremental, cumulative backup and implementing backup and recovery strategies.
• Backup, Recovery and Cloning of databases using RMAN also profound in using the new oracle 11g features in these utilities.
• Writing scripts in the UNIX based environments for managing the user's roles and privileges, scheduled backups (using Data pump /cold backups), manage statistics, Disk space management Data transferring and Refreshing with export/import utilities, Data Pump and data loading using SQL*Loader and External tables.
• Performance tuning of the database - SQL Tuning, Used Tuning utilities like STATSPACK, UTLESTAT, AWR, ADDM and Tuning of SGA, Distribution of disk I/O, Sizing of tables and indexes.
• Expertise in Using EXPLAIN PLAN for query optimization and Performance diagnostic tools like SQL Trace and TKPROF.
• Experience in writing PL/SQL Stored Procedures, Functions Packages and Triggers, various scripting languages such as Perl, awk and UNIX Shell Scripting.
• Experience in advanced Oracle features such as table partitioning, Oracle Streams (Replication).
• Extensively used BMC Remedy and Service Now Ticketing systems for monitoring.
• Excellent interpersonal and strong analytical, problem-solving skills combined with strong customer service attitude.
• Proven abilities in establishing effective task priorities, working independently, and participating as an integral part of a team in fast-paced and multitasking environment.

TECHNICAL SKILLS

Operating Systems: HP-UX 10.x,11.x, Sun Solaris5.8,8,9,10, AIX 5.1,5.2, Red Hat Linux 4.x,5.x,6.x and windows 2003/2005

RDBMS: Oracle 12c/11g/10g/9i, Oracle 11g Real Application Cluster (RAC), ASM

Tools: and Utilities: RMAN, OEM, TOAD, SQL*Loader, Export/Import, Data pump, Query builder, Net Backup, SQL Tuning/Access Advisor, SQL Performance Analyzer, Data Guard, Cloning, Migrations

Languages: C, SQL, PL/SQL, UNIX/NT Shell Scripting, Awk Scripting, Perl.

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

Web Technology: Web Portals, BMC Remedy, HP Quality Center, HP Java ITO (OVO) console

PROFESSIONAL EXPERIENCE

Confidential, ATLANTA, GA

Sr. Oracle DBA

Responsibilities:

• Installed, configured and maintained Oracle 11GR2 Real Application Cluster (RAC) 3 node RAC.
• Performed administrative maintenance, monitoring on Oracle database systems in a global 24x7 operational environment
• Migrating single Instance Databases to 3 Node RAC environments.
• Performed the 12c Upgrade of RAC cluster ware from 11g.
• Duplicated issues and tested solutions to make sure problems were resolved properly
• Assisted Development and Business analyst teams by capacity planning and cloning of databases to the test environments so they could develop custom applications and perform a variety of tests for quality assurance and issue resolution
• Installed the 3 node RAC for the 12c database and administered the 12c databases on these RAC server’s.
• Managed testing, assisted Developers, and created backups by Exporting and Importing tables when needed and Established performance tuning best practices used by the DBA and Development teams
• Performed the Instance caging for the Exadata databases and Modified configuration settings when needed due to growth, upgrades and changes to keep system resources adequate
• Proactive performance management, optimization and capacity estimation of database environments
• Investigation and validation of New database services technology
• Manage customer relations on a daily basis.
• Attended Developer’s code review meetings and made recommendations to improve Efficiencies
• Streamlined and improved job efficiency by creating scripts for common maintenance tasks
• Kept team members and management updated on major issues so they have a clear picture of situation
• Worked on databases on EXADATA various compression methodologies including OLTP compression HCC and EXADATA Query specific
• Evaluate all Performance tuning tools used by the team including Toad, Sql Developer, and OEM.
• Performed quality control audits
• Worked on SRDF (EMC STORAGE) Technology for the replication of the data from source to target.
• Supported development teams by providing SQL statement Tuning and removing load and query performance bottlenecks by using tools EXPLAIN PLAN, STATSPACK, and TKPROF.
• Create repeatable consistent processes used by Developers and DBA’s to ensure a quality and efficient product that enables productivity from non-experts on day one.
• Tune Oracle databases and application code using various techniques geared for their unique purposes:
• Retek: RESA, RMS, RSS, REPLISMENT, POS, and customized modules.
• Data Warehouse: Large extracts, Rollups, Data Mining and Customer relationship management of performance requests (ensure customer is aware of the plan, vision, and scope)
• Ensured that the system was Secured according to company policies and procedures by granting and revoking privileges, giving and removing responsibilities, and defining system profiles for users
• Installed and configured EM12C CLOUD Control and Installation and maintenance of Oracle 10g, 11g Data Guard.
• Worked extensively on Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Statistics.
• Installed STANDALONE servers on ASM, Red hat LINUX.
• Provided a positive impression of support center by documenting, tracking, and following-up on all solutions making sure end-user problems were resolved to their satisfaction
• Extensively used the Database Resource Manager on the Exadata Server’s and Backup and recovery using RMAN.
• Worked on Exadata Production databases and providing the Technical support to Application Support team for performance and database related issues.
• Worked on Service now Ticketing system to resolve the incidents based on Severity.
• UNIX shell scripting as and when required based on the requirement.
• OracleGolden Gate installation, configuration, troubleshooting Golden Gate Extract and Replicat issues.
• Worked on SOX compliance establish internal controls and procedures for financial reporting to reduce the possibility of corporate fraud.
• Provided appropriate security for users of databases, applications, servers, and systems, by setting and managing accounts, keeping sensitive data secure
• Provided on-call support 24x7 for any issues with system by receiving text messages when an issue arose and logging in remotely to resolve those issues
• Applying PSU Patches and interim patches whenever required to make the database software up to date.
• Creation of new scripts to automate the procedures to generate statistics on database space management for proactive monitoring.
• Worked with Oracle Support on more complex and unresolved issues

Environment: Oracle12c/11g/10g/9i, Oracle EXADATA X2-2 HALF RACK, Sun Solaris, Red Hat Linux, RMAN, SQL server, Data Guard, Golden Gate,OEM, Grid Control, STATSPACK, Patching, AWR, Explain Plan.

Confidential, Austin TX

Sr. Oracle DBA

Responsibilities:

• Performed Upgrades, Bug fixes, Enhancements, and regular maintenance to system by researching, planning, as well as applying patches to databases and E-Business suite to keep them up-to-date.
• Provided Technical support and issue resolution to Enterprise applications, hardware, networks, and databases by root cause analysis, assessment, development, and implementation of solutions that meet the needs of users and kept them productive with minimal disruption
• Kept databases, applications, and operating systems up-to-date through assessing, planning, and implementing upgrades and patches
• Improved the database integrity and increased data accuracy for end-users and management by proficiently using SQL language to troubleshoot, query, insert, update, and delete table data
• Installation, configuration and maintenance of Oracle 10g and 11g database on OEL.
• Supported more than 130 production and development databases
• Upgraded the Oracle 10g database to 11g version and also applied patch set and interim patches whenever required to make the database software up to date.
• Monitoring Day-to-Day Backups, Log’s & recovering them as per the requirement.
• Successfully implemented Backup & Recovery using RMAN, Hot and Cold backups.
• Taking the RMAN incremental and cumulative backups.
• Scheduling the databases backup using Cron tab and VERITAS net backup.
• Extensive experience in RMAN recovery in RAC and standalone database.
• Implemented Data Guard with maximum availability, protection and performance configurations and worked with Data Guard Fail over and Switch over cases at the times of up gradation and migration.
• Managed and monitored the Oracle Real Application Cluster (2 node RAC) running on VERITAS storage.
• Performed Tuning, coding and Monitoring for Oracle Real Application Clusters (RAC) nodes, Production Standalone Servers via Toad.
• Implemented DRP (Disaster recovery plan) for critical databases using Streams.
• Provided Instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical I/O and Memory Usage.
• Always monitoring the Oracle Instances, Users, Tables, Tablespaces, Memory structures, and Rollback segments, Redo logs, Archived Redo logs and Alerts.
• Created, monitoring database objects like Tables, Indexes, Views, Users, and DB Links
• Responsible for capacity planning, recovery planning and installing patches.
• Worked extensively on monitoring 10G grid control database, configuration of error notifications, installing listeners, and adding them to the grid control.
• Assisted users with performing their job functions more efficiently by installing, configuring, problem solving, maintaining, and uninstalling software on servers and laptops

Environment: Oracle 9i, 10g, 11g, SQL, PL/SQL, Oracle Grid Control, Oracle Enterprise Manager Database Control, TOAD, SQL Developer, SQL*Loader, NT, Red Hat Enterprise Linux, ASM.

Confidential

Oracle Developer

Responsibilities:

• Database monitoring and performance tuning using OEM (Oracle Enterprise Manager) and Statspack.
• Installation, Maintenance and administration of Oracle 10g on Red hat Linux.
• Implemented Data guard and administered the production database.
• Installed Oracle 10g RAC database on RHEL and applied all current patches.
• Database Restore using RMAN, Cold Backup and Export/Import.
• Responsible for planning, testing and implementing different backup and recovery strategies.
• Used Flashback table to restore tables which is a new feature of Oracle 10g.
• Performance tuning i.e. Tuning RAC, tuning applications, shared pool, I/O distribution, rollback segments, buffer cache, redo mechanisms.
• Extensive application tuning through STATSPACK, explain plan, SQL*Trace.
• Implemented scripts to capture high resource utilization queries.
• Implemented Oracle Advanced Security Options.
• Maintained multiple terabyte databases on Oracle.
• Cloned the production database periodically to the testing databases through RMAN.
• Used Enterprise Manager on Oracle10g for diagnostic summary, host CPU utilization, finding wait events, alert Log errors etc.
• On-Call 24x7 DBA support for production databases.
• Extensively used SQL Queries (Sub queries, correlated sub queries and Join conditions) to handle data mapping.
• Tuned the SGA. Monitored the shared Pool, Database buffer cache and Redo log buffers. Monitored Tablespaces and Segment fragmentation. Performed trouble shooting activities, created new users and assigned privileges and roles to users.

Environment: IBM AIX 5.3, RHEL, Oracle 9i/10g PL/SQL, SQL*PLUS, Exceed 6.2, Oracle Enterprise Manager 9.2.0/10g, Quest Software (5.0), VERITAS Cluster, RMAN.