SUMMARY

• Results oriented Database Administrator with 10 years of multi - platforms experiences in Windows, Linux, and Unix Operating Systems.
• Experienced in the maintenance and administration of Oracle database instances, 24X7 Production Database Support with RAC, Dataguard, RMAN, GoldenGate and business applications. Seeking a career in Oracle Database to utilize my working experiences, skills and abilities in Information Technology that offers professional growth while being resourceful, innovative and flexible.
• Accomplished Oracle DBA with 9 + years of experiences and having expertise in performance tuning, crisis management, maximize productivity and increase high availability with reliability with a complex problem solving skills and communication skills. Areas of expertise include:
• Hands on experience on 12c, 11g, 10g and 9i on AIX, HP-UX, SOLARIS, Linux, and Windows servers; experience with RMAN, and standard backup and recovery procedures; practicality of Data Guard, upgrades and patches, knowledge of SQL Server databases.
• 24x7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues.
• Expertise as a DBA in various Oracle versions from 9i, 10g, 11g and sizes up to terabytes and 300 databases in single environment along with custom support for third party application/tools.
• Installation, configured, and maintenance of Oracle 10g/11g RAC and Data Guard on Win, Linux and Solaris.
• Proficient in Oracle Database Administration activities such as Upgrades, Migrations, Patches, Backup and Recovery, Performance Tuning, Capacity Planning, Shell Scripting, PL/SQL, and Documentation.
• Strong experience in Backup and Recovery strategies using RMAN, Export/Import, Data pump, Hot and Cold backups.
• Setup Replication using Materialized Views, Oracle GoldenGate and manual scripting and Implemented GoldenGate bidirectional setup between different data centers.
• Use flashback for testing purpose on the developing and testing environment for unexpected incident. After utilizing flashback, test the database if everything is in place.
• Proficiency in standby database (Data guard) installation, configuration, maintenance, and administration for disaster recovery.
• Extensive knowledge on database administration of Oracle 9i, 10g, 11g with experience on very large scale database environment and mission critical large OLTP and OLAP systems.
• Experienced in troubleshooting traditional export/import and data pump export/import.
• Hands on experience in Installing, Migrating, Upgrading, Patching and Maintaining different oracle versions on HP-UX, UNIX, AIX, Linux and windows Platforms.
• Use performance tuning utilities like SQL trace, tkprof, explain plan, dbms profiler and statspack to monitor performance and made the appropriate changes to improve performance.
• Performed DB patching, Cloning, DB Installation, troubleshoot issues/errors/incidents, Collaborate with Oracle support for bugs & issues resolutions and personal research.
• Experienced in Lead, Design and Develop the ETL processes for Data Warehouse environment.
• Troubleshooting of Performance and Tuning problems in Oracle database using tools like AWR, ASH, ADDM, SATSPACK, OEM Grid Control and manual scripts.
• Experienced in using AWR (Automatic Workload Repository) and ADDM for analyzing the database performance.
• Perform Daily Monitoring of Oracle instances using Oracle Enterprise Manager, ADDM, TOAD, monitor users, table spaces, memory structures, rollback segments, logs, and alerts.
• Excellent communication skills and the ability to work independently or in a team environment.
• Strong presentation, troubleshooting, analytical and problem solving skill with excellent interpersonal and communication skills. Work well with all levels of business stakeholders.

TECHNICAL SKILLS

Databases Systems: Oracle 12c, Oracle RAC 11gR2, 10g,, 9i, Sybase 10 and SQL Server 2005 and 2008

ERP: Oracle Applications R12 ( 12.1.x), 11.0.3, 10.7 (Client Server, NCA)

Programming Lang: PL/SQL, SQL, Unix Shell Script, Java, VBScripting

Application Servers: WebLogic, Apache, IIS, Oracle Application Server

Operating Systems: Oracle Enterprise Linux 6.x, 5.x, 4.x, Red Hat Enterprise Linux (AS) 3.x, 2.x SunOS/Solaris 2.6, 2.7, 2.8, Confidential AIX 4.3, HP-UX 9.x, /10.2, Windows XP and Win 7

DB Management Tools/ Utilities: Oracle Enterprise Manager-Database Control, Grid Control, RAC, Dataguard, ASM, Import Export, Datapump, SQL*Loader, AWR, ADDM, Oracle Scheduler, lsnrctl, srvctl, crsctl, Tkprof,Statspack, Oracle GoldenGate, Data Pump, Shell Script, RMAN

PROFESSIONAL EXPERIENCE

Confidential, Arlington, VA

Sr. Oracle DBA

Responsibilities:

• Installed, configured, and Maintained Oracle Databases in Development, Test, and Production environment.
• Installation, Configuration, Upgrade, patching of Oracle RDBMS and applications Work on different versions of Databases with OEM Grid control to maintain the database effectively.
• Evolved a good backup strategy for the production databases using RMAN and also created standby database for minimal down time.
• Developed RMAN scripts for database back up and recovery, including hot and cold backup options for both RAC and stand alone instances.
• Developed shell scripts for tracing Oracle errors, free space in the tablespaces and free disk space in Archive destination for production database.
• Applying/adding management packs/plugins and target for 11g and 12c and Administration of OEM repositories.
• Implementing quarterly patch cycles for databases systems in 12c, 11g RAC/Non RAC databases. Experienced to patch through both manual (using opatch) and through OEM 11g, OEM12c.
• Upgrade and Migration of Databases from 10.2.0.5 to 11.2.0.2 and applying patches whenever required Splitting Database Objects from one schema to another schema for reorganizing user Applications.
• Architect Golden Gate (10.x and 11.x) replication solutions to facilitate data flow between heterogeneous (SQL Server and Oracle) environments.
• Planned Golden Gate setup to achieve Unidirectional replication.
• Configured Golden Gate to achieve unidirectional and bidirectional replication.
• Fulfilled DBA daily activities such as user management (creating users, synonyms, privileges, roles, quotas, tables, indexes, sequences), space allocation, and monitoring.
• Database cloning, renaming, and refresh for development and Test Environments.
• Planning and scheduling for the backup of databases information using UNIX shell scripts and Crontab jobs.
• Optimizing the SQL’s for optimum performance by using Explain Plan, Tkprof, Statspack, Trace Analyzer, AWR, and ADDM.
• Logical Backup/Restoration strategy using Expdp/ Impdp (Data Pump) utility.
• Successfully implemented Physical Standby Database using Oracle Data Guard feature for High availability configuration.
• Managing Instances, redolog files, Tablespaces, Datafiles, storage structures, Undo segments, Temporary segments, Indexes.
• Configured Listener.ora and Tnsnames.ora manually as well as using NetMgr and NetCA uitilities.
• Database health check and ensuring implementation of all standards and securities prior to database environment transition to Production phase.
• Perform performance tuning for production, and development databases. Run AWR and ADDM report as needed.
• Monitored and tuned the Shared Pool, Database Buffer Cache and Redo Log Buffers for best performance. Troubleshooting and Recovery of Database from Data file losses. Backup and Recovery involving archiving, redo logs, data files using RMAN

Environment: Sun Solaris, Linux, Oracle 10g/11g/12c, RAC, RMAN, Solaris, HPUX, Linux (Red hat), Toad, Database schema. OEM 11g, Oracle Enterprise Manager (OEM) 12c and OEM Grid Control. Export/Import, Data Pump, SQL*Loader, DGMGRL, ASMCMD

Confidential, Washington, DC

Sr. Oracle DBA

Responsibilities:

• 24x7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues.
• Installed, configured, and Maintained Oracle Databases in Development, Test, and Production environment.
• Setup 2 nodes Oracle 11g RAC in Development, Test, and Production.
• Involved in Cross-Platform Databases Migration from HPUX Tru64 to Solaris.
• Upgrade and Migration of Databases from 10.2.0.5 to 11.2.0.2 and applying patches whenever required.
• Splitting Database Objects from one schema to another schema for reorganizing user Applications.
• Applying PSU/CPU patches quarterly on Grid Control Infrastructure and RDBMS homes.
• Database Planning and Designing which involves deciding about Logical Storage Structures and Forecasting Future Expansions.
• Fulfilled DBA daily activities such as user management (creating users, synonyms, privileges, roles, quotas, tables, indexes, sequences), space allocation, and monitoring.
• Developed RMAN scripts for database back up and recovery, including hot and cold backup options for both RAC and stand alone instances. Configured Oracle OEM (Oracle Enterprise Manager) to monitor database and report on events as defined by the DBA group.
• Created custom Statspack scripts and implementation documentation for corporate wide roll out to all databases for automatic periodic statistics gathering and reporting.
• Used Sybase Power Designer version 11 for application data modeling. Performed production system problem analysis and recommend corrective measures in a timely manner.
• Installed, configured, upgraded, and patched Oracle RDBMS and associated utilities & software.
• Database Planning and Designing which involves deciding about Logical Storage Structures and Forecasting Future Expansions.
• Schema using Expdp/Impdp (Data Pump) utility.Expert on Data guard configuration on Creating a Physical Standby Database on the same Server and Creating a Physical Standby Database on a Remote (DR) Site Servers.
• Monitor archive logs, tablespace issues, database links validation to avoid any downtime. Report block corruption to System Admins if needed, and test after changes. Monitor if standby databases in sync to the primary
• Setup job to backup databases using RMAN. Verify notification if the backup is not successful and make necessary changes. Setup incremental backup.
• Security Administration and Creation of Users, Managing their roles and privileges.
• Implanted uni directional and Bi-directional replication using various versions of Golden gate.
• Installed Golden Gate software in Test and dev instances.
• Helps in Performing Golden Gate replication monitoring, tuning, and capacity planning.
• Upgrade and character set conversion of RAC databases with the aid of Oracle's Goldengate utility.
• Configured Oracle OEM (Oracle Enterprise Manager) to monitor database and report on events as defined by the DBA group.
• Working with Off-shore Team and Performed Leadership role for implementing Offshore-Resource solution for Oracle DBA Team. My effort to implement solution included to articulate and document a process and methodology to follow by offshore team as well local technical team.
• Support production databases for 24x7 on rotation basis.

Environment: HP-UX, AIX, Linux, NetApps, Windows XP/7, Solaris, Linux (Red hat), Oracle 10g/11g, RAC, RMAN, ASM, AWR, ADDM, ERwin, TOAD, JIRA ticketing system, GoldenGate and OEM Grid Control

Confidential, Vienna, VA

Oracle Dba

Responsibilities:

• Responsible for 24x7 supports for large 9i & 10g databases for production Environments.
• Created databases manually and decided the naming conventions of controlfiles, redolog files, datafiles and tablespaces.
• Database Cloning on Test servers from OffLine/Cold and OnLine/Hot Backups of Production Database.
• Document and communicate changes to the OLTP, OLAP systems and data warehouse teams, including Data Modeling, ETL and Database teams.
• Used Automatic Workload Repository (AWR) & Automatic Database Diagnostic Monitor (ADDM) in RAC for Performance Tuning.
• Setup of High Availability of the database using RAC, Standby, Data guard.
• DBA activities such as configuring Grid events, Regular Backup's, Replication, Tuning, and troubleshooting performance issues.
• Maintain, upgrade, troubleshoot all enterprise oracle and SQL server databases
• Advanced Backup and Recovery using Oracle RMAN software; used offline/online for recovery in a production environment via Kornshell scripting.
• Perform other regular DBA activities including space management and performance monitoring.
• Performed SQL Statement Tuning, using SQL TRACE, Explain Plan,TKPROF, and STATSPACK.
• Optimization and tuning SQL queries using TRACE FILE, TKPROF, EXPLAIN PLAN.
• Design, development, testing, performance tuning, deployment, and support in Data warehouse system
• Performance Tuning of Databases, Oracle instances, and Applications. Finding Performance Bottlenecks using STATSPACK, EXPLAINPLAN, SQLTRACE, TKPROF, AWR, and ADDM
• Improved company's Data Warehouse system ETL performance from 16 hours to 2 hours, backup process from 12 hours to 2 hours and Global report performance from 15 minutes to 4 seconds
• Patch, upgrade, migration, cloning of databases and implementation of Dataguard setup, RAC setup on VCS, OCFS file systems
• Capacity Planning, Storage Allocation and Space Monitoring and Management Monitoring Lock and various sessions using OEM & TOAD.
• Installed, upgraded, patched of Oracle Binary and utilities software.
• Write monitoring/health check scripts to alert the team of database uptime/downtime status and sizing issues, which ensured availability 99.99% of the time.
• Closely working with Business stakeholders and provide consultative and technical support services for all major database development and system integration tasks including test strategy, data conversion, version upgrade, migration, space management, implementation of backup and recovery strategy and database security.

Environment: Confidential AIX,Oracle 9i/10g, Oracle Enterprise Manager, Solaris, HP UNIX, PL/SQL, TOAD & SQL *Plus. RHEL 5, AIX 5.X, OEM grid control, TOAD, Datapump, DataGuard, RMAN, Shell Scripts, SQL DeveloperEducation: B.S in Information System of Management.