SUMMARY

• Over 7 years IT Experience in Oracle products, both production and development environments spanning several industries: 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.
• Installed 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 Data guard, 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, Stats pack, Tkprof, Explain plan, Analyze, AWR and ADDM.
• 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.
• Write and modify UNIX shell scripts, Perl scripts to manage Oracle environment.
• Extensive knowledge of Oracle Architecture, SGA, PGA,Binarystructure,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 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:

• Review of Database logical and Physical design.
• Install, upgrade and maintain Oracle 10g/11gR2 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.
• Write and modify 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.

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:

• Have worked in a CPS- DBA Team and coordinate in meetings and providing solutions to mission critical relational databases.
• Working on Incident tickets Supporting 24*7 support and on call for Production database and supporting developers & end-users.
• Have worked as Data modular building complex logical data models using sophisticated modeling techniques and tools like Erwin.
• Responsible for 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.
• Worked closely with application teams in the migration process of the 9i and 10g databases doing performance testing and designing optimal migration process
• Created and managed database objects such as tables, indexes, partition tables and views.
• Created and managed users, roles, privileges, profiles, schemas.
• Involving in technical specifications with Team in all the SDLC cycle of the Apps/DB Team.
• Involved in the process of tuning and refining queries of various applications.
• 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.
• Manage data architects, data administrators and client requests.
• 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.
• Involved in Tuning the DB servers with relevant to Web/Apps Servers Performance issues.
• Worked on Schema Refresh Requests using import/export, export data pump/import data pump.
• Creating and rebuilding indexes and optimizing the code to improve the performance.
• Have done database backup and recovery using (Cold backup/ Hot backup/ Logical).
• Setup backup and recovery procedures using RMAN/Snapshot backup Mirroring for high volume DB’s.
• Upgrade and Migration of Database from 9.2.0.6 to 10g/11g.
• Installation and Setting up of 10g and 11g RAC with ASM on AIX 5.3,AIX-6 and Red Hat 5.
• 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. Having stored outlines before and after Database tuning to stabilize and optimize the database by changing the parameters.
• Configuration, maintenance and tuning of 11g R-2 Two node RAC Cluster.
• Applying Patches for 10g/11g Database, Quarterly released PSU’s by Oracle
• 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.
• Set-up & Troubleshooting of Bi-directional Streams to Replicate the data from Source DB to Target DB for Different applications.
• 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.
• Security User Management, Privileges, Roles, Profiling, OS Authentication.
• Trouble shooting of various database performances by proper diagnosis at all levels like SQL, PL/SQL, database design, database tables, indexes, Instance, memory, operating system and java calls

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.
• Worked on 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 Database Administrator

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.
• Provided maintenance of user accounts, privileges, profiles and roles.
• 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 Pump, Diagnostic and Tuning Advisors.

Confidential

Oracle DBA Developer

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.