SUMMARY

• Over 6+ years of experience as an Oracle DBA with proficiency in installation of Oracle 11g/10g/9i/8x on Unix as well as Win NT/2000 Operating Systems, planning for necessary databases, storage space requirements.
• Excellent proficiency with various database architectures including relational, OLAP and data marts designs.
• Experience in Physical / Logical Database Design (LDM/PDM) as per customer requirements and place the Data Models in Data Modular Repository as well as Impact Analysis of the changes in Physical Design.
• Hands on experience in design and implementation of test, integration, and production environments and supporting multiple databases.
• Technically sophisticated with Database management products like DATAGUARD, Grid Control, OEM 10g utilities like AWR, ASH, ADDM, Advisors.
• Experience in analyzing, testing, and implementing physical database designs to support various business applications.
• Plans, analyzes, designs, implements, maintains, and controls the organization databases.
• Expertise in setting up of 10g RAC on Linux using ASM (2 Node cluster).
• Moving the objects using data mover to migrate objects from dev to test and test to production.
• Experienced in Resource Management like allocating and managing physical storage structures like data files, online redo log files, control files. Allocating logical storage structures like tables space and schemas and extents.
• Experience in implementing Oracle 10g Grid control to monitor Enterprise Databases
• Experience in configuring basic and advance replication using Oracle Streams.
• Expertise in ORACLE Database Administration including Planning/implementing backup /recovery strategies and disaster recovery plans.
• Expertise in Monitoring and performance tuning, optimization, capacity planning, standby databases.
• Led several tuning efforts using Statspack, SQL tuning, and the wait events interface that resulted in significant improvements in response times for both application and data migration modules.
• Experience in backup and recovery, RMAN, export/import and data pump.
• Migration of databases between Software versions, Platforms and database products.
• Experience in Unix shell, Perl and windows batch Scripting.
• Experience in writing stored procedures, functions, packages, triggers, along with UNIX shell scripts and experience in Data Warehousing concepts and data modeling techniques.
• Expertise in writing UNIX shell scripts and SQL / PL/SQL scripts for database monitoring and administration.
• Involved in production DBA support in solving the database problems and co - ordination with Confidential Corporation.
• Excellent interpersonal, analytical, and problem-solving skills.

TECHNICAL SKILLS

Hardware /OS: Solaris 8, Solaris 9, SUN 6000, SUN 4500, SUN e15K, RedHat Linux 6.2 / 7.x/8.0/2.1/3.0 AS/ES, HP-UX 11/11i, IBM/AIX 5.2,Windows NT 4.0 and Windows 2000/2003

RDBMS: Oracle 11g/10g/9i/8.x, MS-SQL Server 2000/2005/2008

Languages & Scripting: C,PL/SQL, SQL*PLUS, UNIX Shell scripts.

Tools: / Utilities: Recovery Manager, DBVerify, Exp/Imp, Server Manager, TKPROF, TOAD, Cygwin,, PSADMIN,People Tools 8.4, Tuxedo 8.1, Patch Install 1.3,SAPDBA, and EMC tools- time finder, Erwin, Oracle Enterprise Manager (OEM)2.2, 10g Grid, SAP R/3, T-Sql 4.6C, PeopleSoft 8.8, BEA Weblogic8/9, IBM WebSphere, Tuxedo8.x.

UNIX Admin Exp: UNIX File Systems designing (Database Perspective) for Installation of Oracle on both standalone and HA environments.

PROFESSIONAL EXPERIENCE

Confidential, Blue Ash, OH

Oracle Database administration

Responsibilities:

• Content deployment using team site tool on DEV/QA/UAT and PROD databases.
• Monitored database performance and tuned configuration parameters.
• Migration of database (from 9.2.0.5 to 10.2.0.1) on cross platform.
• Performed backups of the databases and recovered them, if needed. Performed export of the different Schemas. Monitored backups, export, space usage and user activity.
• Writing various data extraction script to extract finish data using Spool, UTL file Packages and transfer the files using FTP to different applications servers to AML Server.
• Implementation of Hot backup using RMAN and shell scripts
• Synced up the database at schema level.
• Performed technical troubleshooting and provided consultation to development teams.
• Monitored applications at the database level and identified problem areas and hot spots while isolating issues and recommending solutions.
• Managed database of 5GB to 5 TB and Supported database on performance over 23 databases on UNIX and 10 databases on Windows.
• Installation of Oracle 10g databases on RAC Servers to the latest patch in 10g (10.2.0.4).
• Installation of Oracle 10g grid control, agent and client deployment.
• Installation and Maintenance of 2 node 10g RAC database using ASM on Linux platform.
• Expertise in maintaining RAC Environment using Oracle utilities like srvctl, crsctl etc.
• Using Stats Pack, AWR Reports Analysis prepares the database performance reports.
• Extensively created various scripts and jobs to schedule various Batch jobs.
• Writing Unix Korn Shell Scripting for schedule the jobs.
• Co- ordinate with Development team and provide database level support.
• Documenting database maintenance procedures and Release management.
• Checked alert logs, archive logs and backup verifications.

Environment: RedHat Linux ES 3.0, Windows 2008,IBM/AIX 5.2,Oracle 10g R2, Export/Import, Server Manager, Oracle Enterprise Manager(OEM) and utilities, TKPROF, Erwin, IPMS 7.2,Oracle SQL developer.

Confidential, Rochester, NY

Oracle Database administration

Responsibilities:

• Installation, maintenance and tuning of Oracle 11g RAC databases including ASM and CRS in Dev, test, QA, PERF,DR and Prod Environments as per the company standard.
• Performed upgrades from Oracle 10.2.0.3 to 11.1.0.7 on IBM-AIX.
• Configured, administered, and monitored a Streams environment using various tools like OEM console.
• Using the application platform from sun solaris 10 to RHEL 5.3 on HL DL 585 G5 servers, also provide day-to-day support for existing Unix/Linux Servers during KeOnization.
• Installation and migrations of database on design of web app tier of the application used in network load balancing in PROD,DR,QA,and PERF environments on virtualized environment using VMWARE ESX servres,
• Support and Monitor Oracle 11.1.0.7 Application instances.
• Applying Patches and Cloning 11i instances.
• Installation and Maintenance of 2 node 11g RAC database using ASM on Linux platform.
• Expertise in maintaining RAC Environment using Oracle utilities like srvctl, crsctl etc.
• Successfully migrated databases from Intel boxes (windows 2000, windows 2003 servers) running oracle 10g over IBM-AIX running oracle 11g and non-ASM instance to ASM instance.
• Responsible as a team for performance, backup and recovery related issues of over 67 databases with 11 productions, 15 developments, 15 DR, 11 test and 15 QA databases.
• Worked on import/export, export data pump/import data pump and SQL- loader.
• Installed and Implemented Backup & Recovery procedures, Implemented Hot, Cold, Logical backup plans.
• Set up, configured and maintained oracle Data Guard to ensure disaster recovery, high availability and data protection.
• UNIX shell scripting in csh, ksh to be controlled from Crontab
• Monitored database performance and tuned configuration parameters.
• Migration of database (from 10.2.0.3 to 11.1.0.7) on cross platform.
• Performed backups of the databases and recovered them, if needed. Performed export of the different Schemas. Monitored backups, export, space usage and user activity.
• Implementation of Hot backup using RMAN and shell scripts
• Performed technical troubleshooting and provided consultation to development teams.
• Monitored applications at the database level and identified problem areas and hot spots while isolating issues and recommending solutions.
• Managed database of 5GB to 5 TB and Supported database on performance over 57 databases on Linux and 10 databases on Windows.
• Created and maintained various views and PL/SQL stored procedures, functions and packages for the application. This includes making changes to support fix bugs, new enhancements or performance improvements.
• Installation of Oracle 11g databases on RAC Servers to the latest patch in 11g (11.1.0.7).
• Our production systems were multi-home oracle 11g Linux system which held 22 Oracle instances
• Maintained system security and object privileges.
• Provided production support direct to the client from the offshore team.

Environment: RedHat Linux ES 3.0, Windows 2003,IBM/AIX 5.2,Oracle 11g R1, Export/Import, Server Manager, RAC, ASM,11g Grid, Toad, OEM, Data Guard, Ds Virtualized web app server ESX VM, KeOnization,OCFS.

Confidential, Chicago, IL

Oracle/SQL Database administrator

Responsibilities:

• Installation, maintenance and tuning of Oracle 11g RAC databases including ASM and CRS.
• Performed upgrades from Oracle 10.2.0.3 to 11.1.0.1 on IBM-AIX.
• Configured Streams to capture propagate, apply changes in multiple databases.
• Configured, administered, and monitored a Streams environment using various tools like OEM console.
• Support and Monitor Oracle 11.1.0.1 Application instances.
• Applying Patches and Cloning 11i instances.
• Successfully migrated databases from Intel boxes (windows 2000, windows 2003 servers) running oracle 10g over IBM-AIX running oracle 11g and non-ASM instance to ASM instance.
• Set up, configured and maintained oracle data guard (primary and standby databases) to ensure disaster recovery, high availability and data protection
• Data Migration as part of enterprise data warehouse project.
• Personally responsible for performance, backup and recovery related issues of over 56 databases with 11 production, 23 development and 22 QA databases.
• Used shell scripting for automation of job Scripts, for Startup and Shutdown, Health Check of Oracle/SQL Databases, Analyzing of Tables and Rebuilding of Indexes
• Data Modeling, Database Design and Creation using ER-Win, Visio.
• Worked on import/export, export data pump/import data pump and SQL- loader.
• Installed and Implemented Backup & Recovery procedures, Implemented Hot, Cold, Logical backup plans.
• Installing and configuring RMAN and Flash Recovery. Cloning databases using RMAN as well as scripts
• Extensive Performance Tuning, Memory (SGA) Tuning, Net backup, EMC (Time finder and SRDF),RAW Devices
• UNIX shell scripting in csh, ksh to be controlled from Crontab
• Downsizing and defragmenting the Very Large Databases by export / import, cloning those using RMAN duplicate features and then upgrading them to Oracle 11g.
• Load balancing, Databases/Schema/Table Re-Organization for faster performance using export/import & Move procedures.
• Data Refresh in Test and Integration Databases using Transportable Table spaces
• Storage Management Managing Space, Table spaces, Segments and Extents, Rollback Segments & Data Dictionary
• WebSphere Monitoring inNetwork Deployment modeis provided
• Also Monitors performance statistics such as database connection pool, JVM memory usage, user sessions, etc. alarms can be configured for these parameters.
• Based on the thresholds configured, notifications and alarms are generated. Actions are executed and gathering performance data for planning, analysis, and reporting.
• Monitored log apply rates, capturing diagnostic information, and detecting problems quickly with centralized monitoring, testing, and performance tools in physical/logical databases
• Installed Oracle 11g Enterprise Manager (OEM) (Grid Control) for diagnosing and monitoring performance related problems and configured with Application servers on databases
• Designing the security and database access strategies using tools like ESM
• Indexed at the database level and used pre-tuned queries at the application level to tune OLTP.

Environment: Oracle 11g, Red hat Linux 5.X, IBM-AIX 5.X, Oracle 10g RAC/9i, Toad, Sql navigator, PL/SQL, SQL*Loader, windows 2000/2003, ODBC, ASM, OLTP, Telnet, Flashback, OEM, Data Guard, websphere 6.1, Erwin 4.1.2,MS Access.

Confidential, Kansas City, KS

Oracle/SQL Database Administrator

Responsibilities:

• Writing various data extraction script to extract finish data using Spool, UTL file Packages and transfer the files using FTP to different applications servers to AML Server.
• Monitored database performance and tuned configuration parameters.
• Migration of database (from 9.2.0.5 to 10.2.0.1) on cross platform.
• Performed backups of the databases and recovered them, if needed. Performed export of the different Schemas. Monitored backups, export, space usage and user activity.
• Implementation of Hot backup using RMAN and shell scripts
• Performed technical troubleshooting and provided consultation to development teams.
• Monitored applications at the database level and identified problem areas and hot spots while isolating issues and recommending solutions.
• Managed database of 5GB to 5 TB and Supported database on performance over 75 databases on UNIX and 10 databases on Windows.
• Created and maintained various views and PL/SQL stored procedures, functions and packages for the application.
• This includes making changes to support fix bugs, new enhancements or performance improvements.
• Installation of Oracle 10g databases on RAC Servers to the latest patch in 10g (10.2.0.4).
• Installation of Oracle 10g grid control, agent and client deployment.
• Set up, configured and maintained oracle data guard (primary and standby databases) to ensure disaster recovery, high availability and data protection.
• Our production system(s) were multi-home oracle 10g Unix system which held 16 Oracle instances
• Configured the Database Hosts, cluster databases, Database instances, ASM instances in Grid control.
• Installation and Maintenance of 2 node 10g RAC database using ASM on Linux platform.
• Expertise in maintaining RAC Environment using Oracle utilities like srvctl, crsctl etc.
• Using Stats Pack, AWR Reports Analysis prepares the database performance reports.
• Extensively created various scripts and jobs to schedule various Batch jobs.
• Configured Oracle Streams and exchanged data between two locations.
• Maintained documentation, review release notes; upgraded user guides, and middleware documents etc.
• Writing Unix Korn Shell Scripting for schedule the jobs.
• Written Stored Procedures and Triggers for database maintenance and management using PL/SQL.
• Created production standby database environments using DataGuard.
• Documenting database maintenance procedures and Release management.
• Checked alert logs, archive logs and backup verifications.
• Maintained system security and object privileges.
• 24x7 production support DBA working on a primary/ secondary pager rotation; and supported on holidays, weekends and beyond regular hours.

Environment: RedHat Linux ES 3.0, Windows 2003,IBM/AIX 5.2,Oracle 10g R2,Informatica, Export/Import, Server Manager, TKPROF, RAC, ASM,10g Grid, J2EE(JSP, EJB, JMS, XML and Struts), Pramati 5.0,Erwin, TOAD

Confidential

Database administrator

Responsibilities:

• Responsible for SQL, PL/SQL Forms, and Oracle Reports Development.
• Developed PL/SQL Procedure, Functions, Triggers and packages.
• Worked on Data Replication, Advance Queuing, Data Migration and Mapping for Application version Upgrades.
• Used SQL*Loader, Export, Import in order to Extract and Load Data.
• Involved Design, Creation of Help Desk Database Application using Oracle Forms and Reports.
• Written Test Cases and Acceptance Testing for new Developed Application.
• Maintained Application Security System and Object Privileges for Enterprise-wide Data integrity.
• Scheduled the Export, Cold Backup, FTP and Database Monitoring Jobs.
• Developing Unix shell scripts, SQL scripts to carry out routine checks on databases.
• Assisted Sr. Oracle DBA in day-to-day Administration.

Environment: Oracle 8i, Visual Basic 6.0, Crystal Reports, Data Reports, SQL Loader, Oracle Advance Replication, Import, Export, Oracle Enterprise Manager (OEM) and utilities, TOADErwin, Windows NT 4.0.

Confidential

Database administrator

Responsibilities:

• Managed database of 5GB to 500 GB and Supported database on performance over 10 databases on Windows.
• Estimating table sizes, table spaces.
• Created database objects like tables, tablespaces, buffer pools, indexes and views.
• Developed a number of Reports using Oracle Reports 2.5
• Individual module Testing was performed.
• Tuned Application using Explain Plan and SQL Trace.
• Database backup schedule using shell scripts.
• Database recovery and restore.
• Wrote shell scripts for hot backup for all servers and PL/SQL for code extractions from DBA source and DBA views.
• Optimized the Application Database by encapsulating Procedures, Functions, database Triggers in a Package.

Environment: Oracle 7.3, Forms 4.5, Reports 2.5, Designer/2000, PL/SQL, Windows NT