SUMMARY

• Over 17 years of experience as an Oracle (7/8/8i/9i/10g/11g) Database Administrator having hands on experience in database creation, administration, installation, configuration, upgrades, patches, performance tuning, backup and recovery, space management, database security, cloning, migration, trouble shooting.
• Experienced in maintaining large DEV, QA, UAT, SIT and Production environments.
• Worked extensively on DB and EBS versions upgrades, migrations and patching.
• Configured Oracle on different operating systems for OLTP & Data Warehousing environments.
• Implemented DR & High Availability Oracle solutions by installing, configuring and maintaining Data Guard and RAC databases on various platforms.
• Proficiency using Flash - Back Recovery and performing manual recoveries by using RMAN managed backups with or without catalog, archive logs, cold and hot backups, full backups, incremental and cumulative backups. Integrating NetBackup, Tivoli, Omniback, Veritas, Sepaton software for backups. Designing and implementing data networking for fast backups to disk, tape and silos
• Implemented data transfer using conventional Exp/Imp utilities and Data Pump.
• Expertise reinforcing databases security configurations by using software for vulnerability scans and applying databases baselines to remove users, configuring quotas, auditing, closing file system security holes, SSL protocols, setting up DB parameter files and integrating DB and EBS authentication with IBM Tivoli Access Management and Global AS Critical Watch.
• Dealing with databases security auditing and shell scripting to analyze data manipulation.
• Tuned the database at various levels such as Application Tuning, Memory Tuning, SQL Tuning, Database Contention Tuning, I/O Tuning and Capacity Planning analysis by using TK Prof, Explain Plan, SQL Trace, UTLSTAT, Stats Pack and AWR generating reports of Automatic Database Diagnostic Manager (ADDM).
• Extensive experience on databases monitoring for health check by programming shells scripts and also doing installations and integrations of OEM (Cloud Control 12c) with databases and applications such as EBS, OBIEE, SOA and OID. Managing Events monitoring and automated Incident tickets creation into Remedy, Peregrine SC and iTop by using OEM Plugins, crontabs, jobs, and SOAP protocols. Setting up components such as: database uptime/downtime status, listeners, space sizing, user locks, long running queries, free space, extents growth, user connections, backups fails, Web Services, Concurrent Programs, Workflows, etc.
• Installation and integration of Oracle Golden Gate to manage replication of databases or tables.
• Configured and implemented different types of Advanced Replication Models of distributed databases.
• Extensive experience writing Stored Procedures, Functions, Triggers and Packages by using Oracle products such as Pro*C, PL/SQL, MOD PLSQL, Forms and Reports.
• Assisted in designing conceptual, logical and physical data models by using Erwin, SDesigner and Oracle Designer.
• Used Repository Manager to manage Very Large Scale Databases (VLSD).
• Experienced in loading data from flat files into database tables using SQL*Loader, Shells Script with AWK and ETL Tools like Polaris and Data Stage.
• Worked as a team member to provide 24x7 on call support for databases and applications.
• Excellent communication skills, with strong troubleshooting and team work ability.

TECHNICAL SKILLS

Languages: C, Pro*C, Shell Script, PL/SQL, MOD PLSQL, Oracle Open Interfaces, Oracle Forms, Oracle Reports, HTML, PHP and OQL.

Operating System: UNIX (HPUX 10-11, Solaris 5-9, AIX 4-5, Linux SCO, SuSE & RH 5.5.-6.2), Windows Servers NT-2012

RDBMS: Oracle 7, 8, 8i, 9i, 10g, 11g, MS SQL Server, Sybase ASE 15, MySQL 5-6.

Tools: Sql*Plus, Quest Foghlight, TOAD, DBArtisan, SQL*Developer, SQL*Loader, OEM/Cloud Control 12c, Orion Solar Winds, Remedy, Peregrine Service Center, iTop, MyOracle Support (Metalink).

Oracle DB Components: RAC, Active/Pasive Data Guard, Golden Gate, RMAN, ASM, Exp/Imp & Data pump, SQL*Loader, Upgrades, Patching, Partitioning.

Oracle EBS: OM, AP, GL, Inv, Time and Labor, HR and Payroll Modules; OWF, Concurrent Programs, Security Users, Plugins, Packages, etc.

Middleware: Oracle Application Server 10g, Oracle Fusion Middle Ware 11g, WebLogic Server, PHP Server, Apache Server, Oracle Apex. Oracle Business Intelligence, Oracle SOA Suite, OEM, OID, Oracle eBusiness Suite.

PROFESSIONAL EXPERIENCE

Confidential, Oak Brook, IL

Sr. Oracle Applications DBA

Responsibilities:

• Applying scheduled changes for triggers, stored procedures, Reports, DB, RAC, ASM, Rman and OEM configurations, patches, upgrades, refreshes, etc.
• Extensive experience recovering with RMAN on Real Application Cluster (RAC) and standalone databases. Recovered several databases when UNDO, TEMP, SYSTEM table spaces and Control Files got corrupted.
• To Clone DBs and EBS Applications (1+ TB) using RMAN and OS Backups.
• Monitoring Day-Day Backups, Log’s & recovering them as per the requirement. Utilized LOG MINER Technology & applied Application Database Transactions on other Databases.
• RAC and ASM Support for RAC administration: Monitoring space usage and ASM administration using ASMCMD command. Adding disk to disk groups and performing ASM disk group rebalance when required. Good hands on experience in Oracle Grid Infrastructure by using SRVCTL and CRSCTL commands to start, stop, configure, modify and verify the cluster resources.
• Implemented Data Guard with high availability, performance configurations and participated in Data Guard Fail Over tests.
• Successfully implemented Backup & Recovery using RMAN which includes Hot backups and Cold backups.
• Managing Golden Gate, installations, integrations, setting up replication using GGSCI with Extract, Extract Pump and Replicate instructions, etc.
• Provided instance level performance monitoring reports and tuning for Event Waits, Sessions, Physical and Logical IO and Memory Usage.
• Worked extensively on performance tuning of queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics.
• Supported development teams by providing SQL statement tuning and optimizing ETL procedures by using tools EXPLAIN PLAN, AWR, ADDM and TKPROF.

Environment: Oracle 9i, 10g, 11g: RAC, ASM, Rman, Golden Gate, Data Guard; Oracle eBiz 11i, 12i: HR, Time and Labor, OWF and Project modules, NetBackup, Tivoli, Veritas, Oracle Gateway, Remedy, Peregrine SC, OEM, SQL Server, MySQL, HPUX, Solaris, AIX, Linux.

Confidential, Raleigh, NC

Sr. Oracle DBA

Responsibilities:

• Installation and configuration of Oracle 11g/10g on Windows, Solaris and AIX Servers.
• Successfully installed Oracle 11gR2 on Linux platforms and built standalone databases.
• Upgrading Oracle 10g and Oracle 11g databases and applying required patches.
• Successfully implemented oracle 11gR2 Physical Standby database using Oracle Data guard in high availability configuration.
• Enforced database security on User accounts and Roles assigning and revoking Privileges.
• Implemented disaster recovery procedures documenting Rman, RAC and ADG activities.
• Worked closely with application developers in troubleshooting application tuning.
• Created, scheduled and worked on database maintenance tasks such as upgrades, patching, Golden Gate password changes, tables/indexes analysis, index rebuild, materialized views refresh, db exports and regular day-to-day tasks.
• Monitoring production databases through Oracle Enterprise Manager to troubleshoot and diagnose database problems.
• Developing unix shell scripts and setting up cron jobs.
• Used Secure SCP & SFTP extensively for the file transfers from machines to remote servers.
• Managed CRONTAB file, rescheduling the failed jobs (due to errors), changing timings for the scripts to run if the job fails.
• Diagnosed Oracle bugs and coordinated with Oracle support through Metalink to resolve them in timely manner.
• Implemented Data Guard with high availability.

Environment: Oracle 11g/10g,RAC,ASM,Grid Infrastructure(Cluster ware),Golden gate, Data guard, Sun Solaris 10, PL/Sql, AIX 5.1, Data guard, Shell scripting, OEM, Putty, Toad.

Confidential, Malvern, PA

Sr. Oracle DBA

Responsibilities:

• Installation and configuration of Oracle 11g/10g/9i on Windows and AIX series.
• Monitoring and supporting more than 40 databases.
• Involved in construction of DR sites for all the Production environments.
• Performed Database Refresh from Production to QA, UAT and Development databases.
• Implemented and managed optimum physical database design (table spaces, data files, extents, redo logs, archive logs) and assessed database capacity by monitoring online storage, growth and file system space, in adherence to the Optimal Flex Architecture.
• Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical IO and Memory Usage.
• Extensive experience in RMAN recovery testing, RAC and standalone database
• Recovered huge Database when UNDO table space got corrupted in Real Application Cluster (RAC).
• Created a Clone Database using RMAN on remote Server and used SRVCTL commands for Real Application Cluster (RAC) Databases administration.
• Implemented Data Guard with high availability and performance configurations.
• Worked with streams in En-queuing and de-queuing messages. Starting and stopping streams processes. Perform troubleshooting of streams environment.
• Monitoring Day-Day Backups, Log’s & recovering them as per the requirement. Utilized LOG MINER Technology & applied Application Database Transactions on other Databases.
• Successfully implemented Backup & Recovery using RMAN which includes hot backups and Cold backups.
• Worked extensively on performance tuning of queries by maintaining Aggregates, Compression, partitions, indexing and use of Hints, Stored outlines, Statistics.
• Supported development teams by providing SQL statement tuning and optimizing ETL procedures and removing load and query performance bottlenecks by using tools EXPLAIN PLAN, STATSPACK, and TKPROF.
• Cloned schemas, objects and data on new server using Exports from 10g database and imported in 11g using Data Pump.
• Responsible for capacity planning, database security, recovery planning and installing patches.
• Worked extensively on monitoring database, configuration of error notifications, setting up listeners, and adding them to the 10g Grid Control.

Environment: Oracle 11g/10g, Oracle 10g/RAC, Linux, Solaris 10, Informatica, TOAD, Veritas, OEM, Erwin 7.2, SQL, PL/SQL, TKPROF, WebLogic, EXPLAIN PLAN, Business Objects XI, Data Guard.

Confidential, Atlanta, GA

Sr. Oracle DBA

Responsibilities:

• Cloned schemas by using export/import and table spaces transported in 11g.
• Responsible for database security and installing patches.
• Worked on monitoring DB with Grid Control 10g, configuration of error notifications.
• Responsible to analyze and to understand functional customer requirements and assigning and supervising development activities of Oracle Reports, JDeveloper and Shell scripting teams.
• Coordinated interfaces integration project between Oracle EBS and Amdutch application by using Oracle Open Interfaces.
• Worked doing minor and mayor upgrades into EBS and databases.

Environment: Oracle Applications 12i, Oracle DB 10g, 11i, Solaris, JDeveloper, Forms, Reports, Pro*C, Shell Script.

Confidential, Tampa, FL.

Sr. Oracle DBA

Responsibilities:

• Installation, creation, configuration and upgrades of Oracle 8i/9i/10g databases.
• Installation and implementation of Oracle StandBy and Active Data Guard for production databases with high availability and performance configurations and participated in Data Guard Fail Over tests.
• Performed Database Refresh from Production to DEV, QA and UAT environments.
• Tuning DB for Event Waits, Sessions, Physical and Logical IO and Memory Usage.
• Extensive experience in RMAN configuring Hot and Cold Backups and recovering huge Database when UNDO, TEMP, SYSTEM table spaces and control files got corrupted.
• Cloned Databases using RMAN and OS Cold Backups.
• Worked extensively on Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Statistics, etc.
• Supported development teams by elaborating manuals for SQL statement tuning and optimizing ETL procedures and removing bottlenecks issues by using EXPLAIN PLAN, STATSPACK, and TKPROF.

Environment: Internet Applications 9i, Oracle DB 8i & 9i, Storage Tech, Meta4, SAS ERP, HPUX, SQL Server, OEM 9i, Omniback II, Veritas, Database Scanner, ISS, MOD PLSQL, PLSQL, Forms, Reports, Pro*C, Shell Script.

Confidential

Oracle DBA Applications Lead

Responsibilities:

• Responsible to analyze and understand functional operation of old Bimbo legacy systems in order to design interfaces for the communication with Oracle Applications 11i by using Open Interfaces.
• Team leading responsible to supervise programmer s activities to migrate data from Bimbo legacy systems to Oracle Databases by using Exp/Imp, SQL*Loader, Pro*C, C ANSII Language with sockets and shell scripting with AWK and Make.
• Oracle DBA activities such as database links, DB Spaces, DB and applications tunings, Rman Backups.

Environment: Oracle Applications 11i, Oracle DB 81 & 9i, Solaris, JDeveloper, Forms, Reports, Pro*C, Shell Script.

Confidential

Oracle and HPUX Consultant

Responsibilities:

• HPUX administrator: troubleshooting, LVM, tuning, kernel configurations, HP Omniback II Integration, MC Service Guard cluster administration.
• Oracle DB 7.0.4 - 8.1.5 : Installations, tuning, cloning, RMan, migrations, etc.
• Tuning databases with UTLSTATS and TKPROF and personal health check queries scripts.
• SCO Unixware administrator: Java Installation, troubleshooting, Apache admin, etc.

Environment: Oracle 8i & 9i, Solaris, HPUX, Solaris, Pro*C, Shell Script, Forte, Linux SCO, Omniback II, HPUX MC Service Guard, OEM.

Confidential

Oracle DBA

Responsibilities:

• Supervising developer team and programming in Forms and Reports.
• Daily activities as Oracle DBA: Installations, backups, tuning, migrations from Clipper5.3.as to Oracle 7 and troubleshooting with Metalink.
• Doing maintenance for old databases developed on DBase and Clipper 5.3a.
• Installing NT and Novell networking (cables, switches and routers setup), SNA workstations.

Environment: Oracle 7, 8, & 8i, Solaris, Oracle Developer 2000, Clipper, NT, Novell, SNA.

Confidential

IT Coordinator

Responsibilities:

• To analyze, DB design and programming Inventory Systems.
• I was OS and DB administrator of Intel and MAC Servers and responsible of IT support area.

Environment: DBase, FoxProLN, Clipper, FORTRAN.

Confidential

System’s Coordinator

Responsibilities:

• To analyze, design and develop of National Directory for the Governor (Clipper/FoxPro).
• Backup’s Administrator: Responsible of cadastre maps backups of whole Veracruz State.
• At the beginning I was doing automated cadastre maps using AU2C Systems.

Environment: DBase, FoxProLN, Clipper, AUD2C.