SUMMARY

• Over 7 years IT Experience in Oracle products, both production and development environments spanning several industries: Health care, Insurance, Financials(High - Volume), Telecom and high- tech.
• 24*7 production database support with Support to System Admins, developers & end-users.
• Extensive knowledge on database administration for Oracle 8i, 9i,10g and 11g with experience within very large scale database environment and mission critical Tier-1 large OLTP and OLAP systems.
• Good in installing Oracle 9i/10g/11g for very large production -Tier-1, Tier-2 database environments with Database Implementation in AIX 5.3/6.1, Red Hat Linux4.0, Solaris OS.
• Expertise in Unix Shell scripting, and good knowledge in scripting.
• Extensive experience in Dataguard, Grid control, and Replication.
• Extensive knowledge and experience on Data Warehouse using ETL.
• Experience in a variety of hardware and software platforms including; MS-Windows 2000, 2003, NT Server, UNIX/Linux, Sun Solaris, HP-UX & AIX.
• Expertise in Oracle Enterprise Manager (OEM), Grid Control and configuring metrics and alerts.
• Proficient in all DBA responsibilities such as user management (synonyms/privileges, roles, quotas, table partitioning, index, sequence), space management (tablespaces, rollback segment), monitoring (alert log, memory, disk I/O, CPU, network activity).
• Experience with Installation, configuration Oracle 11g R1/R2 RAC Two node server.
• Expertise in supporting client server GUI software and Operating system.
• Vast experience in Performance Tuning (I/O, Memory & SQL Tuning etc) by using tools/utilities like BSTAT/ESTAT, Statspack, Tkprof, Explain plan, Analyze, AWR and ADDM.
• Good in Performance tuning and diagnosing DBMS and individual database.
• Experience in implementation of enterprise databases on enterprise Storage Solutions using Storage area Networks (SAN) /Network Attached Storage (NAS)
• Experience in Auditing using Oracle packages.
• Hands on experience in writing and modifying UNIX shell scripts, Perl scripts to manage Oracle environment.
• Extensive knowledge of Oracle Architecture, SGA, PGA, Binary structure, Listener, TNSNames, SQLNet, V$ and DBA views.
• Extensive knowledge on database backup/recovery strategy (RMAN), VERITAS Net Backup, Import/Export & Datapump), Capacity Planning, Advanced Replication (Streams), standby databases using Netapp filer/Snap Mirror, Oracle configuration management, Dataguard, database cloning, refreshing the DB and patch management.
• Good in co-ordination and communication with system administrators, business data analysts and development teams.

TECHNICAL SKILLS

OPERATING SYSTEMS: HP-UX 10.x, 11.x, Sun Solaris 2.5, 2.6, 8, 9, 10, AIX 5.1, 5.2, IBM, Red Hat Linux RHEL 2.1, 3.x, 4.x and Windows 95/98/NT/2000/XP.

RDBMS: Oracle 9i/8i/7i, Oracle 10g, 11g&Sql Server.

LANGUAGES: SQL, PL/SQL, C#, C, C++, XML, UNIX Shell Scripting.

SOFTWARE / APPLICATIONS/ TOOLS: ORACLE 7.x/8.x/9i/10g, OAS 10g Recovery Manager (RMAN), STATSPACK, ERWIN, Clusters, VERITAS net Backup, SQL Loader, TOAD 7.6/7.5, PL/SQL DEVELOPER V6.0, SQL DEVELOPER 1.2, Embarcadaro-DBartesian 8.6v, Oracle Enterprise Manager, HP service manager

WEB TOOLS: HTML, XML, PHP

PROFESSIONAL EXPERIENCE

Confidential, Peoria, IL

Oracle DBA

Responsibilities:

• Installing, upgrading and maintain Oracle 10g/11gR2 /12c on Linux, Sun Solaris and Windows 2003.
• Database monitoring and performance tuning using 12C Grid (Oracle Enterprise Manager) and AWR reports.
• JDE 9.1 Application Tuning by tuning queries, identifying problematic code, creation of indexes, re-writing queries using an optimized path, Creation of Materialized Views and gathering necessary statistics on objects etc.
• Implementing Database Security, Management of role-based security
• Database Restore using RMAN, Cold Backup and Export.
• Applying Patches to 10g/11g Databases and applying Oracle DST Patches on Oracle database
• Performing day-to-day database administration tasks like Tablespace usage, checking alert log, trace files, monitoring disk usage, Table/index analyze jobs, database backup logs etc.
• Writing and modifying UNIX shell scripts to manage Oracle environment.
• Problem analysis involving interactions/dependencies between UNIX and Oracle.
• Net backup, Legato, EMC (Time finder and SRDF), RAID, RAW Devices.
• OLAP on Oracle platform using Oracle Express (OLAP server), Relational Access Administrator (RAM), Data Migration as part of enterprise data warehouse project.
• Logical and physical data modeling using Erwin, Dimensional / OLAP Data Modeling, Relational / OLTP modeling.
• Extensive Performance Tuning, Memory (SGA) Tuning, Net backup, EMC (Time finder and SRDF), RAID, RAW Devices.
• Cloning databases using scripts as well as RMAN. Installation, setup and configuration of Data guard.
• Installation/creation of 12C database for the JDE and APEX applications.
• Used PL/SQL, SQL Loader as part of ETL process to populate the operational data store.
• Performed scheduling Control-m for scheduling jobs.
• Security User Management, Privileges, Roles, Auditing, Profiling, Authentication.
• Used Oracle Advanced replication feature to set up multi-master replication, dealt with conflict resolution and performance issues.
• Using Expdp and Impdp utility upgraded the database from 10g to 11gr2

Environment: Oracle 10g/11g RAC, ASM, SQL, PL/SQL, SQL plus, TOAD, C, C++, 12C Grid control Enterprise Manager, RMAN, Sun Solaris, Linux RHEL.

Confidential, Eagan, MN

Oracle DBA

Responsibilities:

• Worked as Data modular building complex logical data models using sophisticated modeling techniques and tools like Erwin.
• Data Modeling and converting Domain model to Data model- logical and physical database design, implementation, transforming logical data models into physical databases, and defining strategies for database implementation, High performance, failover and Disaster Recovery.
• Installation and Setting up of 11gr2 RAC on Linux.
• Performing day-to-day database administration tasks like Tablespace usage, Monitoring alert log, trace files, monitoring disk usage, Table/index analyze jobs, database backup logs etc.,
• Performing the Yearly Standby- Dataguard Tests (Fail-over/Switch over) using DG Broker.
• Co-ordinate with UNIX Administrators for space management on various servers and help in Oracle installation, upgrading according to the standards & Quality assurance.
• Experience ensuring the high availability and integrity of databases to applications.
• Supported in Oracle 9i/10g OLTP/OLAP Over TB on 24*7 Production Environment.
• Experience in using the 11g R2 New features Database and Sql Performance Analyzer.
• Configuring Advance Security monitoring Auditing using oracle packages (SA, FGA).
• Set-up Installed & configured 11g on RHEL, AIX-5.
• Writing scripts for creation of users, creation and assignment of roles, analyze space requirements and maintain Tablespace and other database objects and also did the patch management for oracle upgrade.
• Experienced with Data Modelling Reverse engineering/Forward engineering and complete compare features in Erwin.
• Worked on Schema Refresh Requests using import/export, export data pump/import data pump.
• Setup backup and recovery procedures using RMAN/Snapshot backup Mirroring for high volume DB’s.
• Implemented Oracle Dataguard for maintained Oracle disaster recovery.
• SQL tuning and Database tuning has been done based on reports generated by SQL Trace, TKPROF Reports, AWR, Stats pack, Explain Plans and monitor the database performance on daily basis.
• Installed Golden gate 11.1 Installation and Configuration to replicate data from DB2 to oracle.
• Upgrade Golden gate 11.1 to 11.2 With patch-set Provided by oracle.
• Performed database and memory tuning using tools like STATSPACK, TKPROF, EXPLAIN PLAN, OPTIMIZER and SQL tuning advisor.
• Analysis and management of Oracle problems/defects using SR’s and/or Metalink with Oracle and Follow Up with the Issues raised with Oracle Metalink support.

Environment: SUN SOLARIES 9.0, RHEL 5.2, PL/SQL DEVELOPER v6, TOAD, Embarcadaro-DBartesian 8.6v, ERWIN 4.1, ASM, DATA GUARD, Oracle 10g/9i RAC, Oracle 11g, Oracle Streams, Auto-Sys, SDLC, PLAN VIEW, SQL*Plus, OEM, Grid Control.

Confidential, Milwaukee, WI

Oracle DBA

Responsibilities:

• Installed Oracle Database 11g with Real Application Cluster (RAC) with CRS and ASM in SOLARIS environment.
• Configured RAC Physical standby database for RAC primary using ASM filesystem.
• Creation and deletion of RAC resources like listener/instance and database.
• Tuned databases for memory tuning by adjusting Buffer cache size, log switches and reducing check pointing, increasing sort area sizes, shared pool area, prioritizing oracle processes and increasing SGA overall.
• Hands on experience in troubleshooting RAC environment, using srvctl, crs stat and crs profile.
• Capacity Planning: Allocate system storage and plan future storage requirements.
• Monitoring and maintenance of multiple databases for production, development, testing.
• Perform Daily Monitoring of Oracle instances using Oracle Enterprise Manager, monitor users, table spaces, memory structures, rollback segments, logs and alerts.
• 24 X 7 on call support of all production environments in --group supported by our team.
• Utilized Various Raid levels such as mirroring and stripping with parity.
• Data migration between environments using Export/Import, expdp/impdp, Transportable Tablespace and Oracle Streams.
• Implemented Golden Gate Technology on Oracle 10g.
• Monitoring and maintenance of multiple databases for production, development, testing and Staging purposes using utilities like OEM and Toad.
• Worked on development of PL/SQL stored procedures, Triggers.
• Applying upgrade patches, maintenance and interim patches on all the databases.
• Performance monitoring and tuning the database using OEM, AWR and ADDM analysis.
• Have automated/monitored backup strategies for different databases.
• Administered Oracle Real Application cluster (RAC) system.
• Written Shell scripting which monitors the server’s performance and logs output on periodic basis to database.

Environment: Oracle 11g/10g, RAC, RMAN, PL/SQL, Stored procedures, SQL*Loader, Toad for Oracle, OEM, SQL Loader, UNIX, Solaris, Linux, AIX 5.x, Windows.

Confidential, Fortworth, TX

Oracle DBA

Responsibilities:

• Installation and Maintenance of Oracle 10g, 11gR2 RAC on IBM-AIX, LINUX platforms.
• Involved in upgrading and migrating the databases from 10g to 11gR2.
• Initiated 11g new feature implementations such as ACFS, Scan name, compression features, DBMS Scheduler, AMM and Active Dataguard to improve performance and manageability.
• Implemented the Oracle 11g, Physical Data Guard in Maximum performance mode for production system in case of disaster recovery, maintained primary and standby databases.
• Applied Patches on RAC, Standalone, Standby databases based on the requirements.
• Evaluated mix of backup and recovery methods based on organizational needs. Implemented, tested and documented various backup/recovery scenarios for knowledge base.
• Utilized Grid Control to administer multi-node RAC database also managed redo and undo in the RAC environment. Load balancing of RAC instances.
• Experience on working with data guard physical/logical standby databases.
• Used Data Pump for export and import. Wrote scripts for Backup of databases, maintenance of archive logs for databases.
• Streamlined backup procedures and implemented RMAN for backup and disaster recovery.
• Database Refreshing / Replication from production to testing using Data pump.
• Performed Table Partitioning, created Index Organized tables and Locally Managed Tablespaces.
• Monitored and provided weekly reports on the server’s memory, disk and CPU I/O using HP tools and UNIX command-line utilities.
• Planned and configured disk layout, mount points and capacity requirements for servers.
• Designed, developed and maintained UNIX shell scripts to collect and monitor database metrics and generated AWR, ADDM reports to get RCA on contention issues.
• Involved with OLTP relational databases system analysis, design, implementation and management.
• Experience in implementation of enterprise databases on enterprise Storage Solutions using Storage Area Networks (SAN) and Network attached storage (NAS).
• Administered (10g/11gR2 RAC) environments adding and removing nodes to the cluster and handled performance tuning using AWR, SQL Profiles and SQL Tuning Advisor.
• Supported off-hour on call support for database related issues.
• Created logical and physical design installed and upgraded databases.
• Documented the Standard Processes for peers to follow. Provided 24X7 supports

Environment: IBM-AIX, Oracle 10g/11gR2, RAC, TOAD, OEM, DATAGUARD, RMAN, Data PumpDiagnostic and Tuning Advisors.

Confidential

Oracle DBA

Responsibilities:

• Database Installations, Creations and Upgrades of 8i/9i on Windows 2000/NT.
• Analyzed the structures using Analyze command.
• Involvement in all phases of the project life cycle.
• Written, tested and implemented various UNIX Shell, PL/SQL and SQL scripts to monitor the pulse of the database and system.
• Assuring appropriate backup and recovery procedures to be in place to meet the Company’s requirements.
• Worked closely with developers in Designing Schema / tuning PL*SQL/ SQL code.
• Performed Database Tuning for Oracle 8i & 9i servers including reorganization, SGA, kernel, redo log tuning, Rollback tuning.
• Implemented automated backup strategy using the UNIX shell script CRON UTILITY.

Environment: Windows 98/NT / 2000, HP-UX, Oracle 9i/8i/7, TOAD, Database Tools/Utilities.