SUMMARY

• Around 6+ years of experience in the IT industry involving Production Database Administration.
• Oracle Database Administration experience in variety of different environments like HP - UX, SUN SOLARIS, AIX, RedHat Linux and Windows.
• Proficient in database administration, production support, installation, configuration, upgrades, patches, performance tuning, backup and recovery, cloning, space management, database security, auditing, troubleshooting, database design, TAR support, Unix shell scripting and documentation.
• Migrating and Upgrading the Databases in different environments and versions.
• Experienced in installing and setting up Oracle 11g R1/R2, 10g, 9i, 8i databases.
• Planned and implemented high availability solutions using Oracle 10g RAC, Standby Database using Oracle Data Guard.
• Efficient knowledge Monitoring, Troubleshooting RAC cluster using Srvctl, oradebug, TAF.
• Strong experience in implementing and monitoring Physical Standby Database for Data Guard disaster recovery technique and DGMGRL.
• Proficient knowledge in configuring ASM for RAC databases.
• Demonstrated ability to identify root causes of problems, consider both long and short-term impact of proposed solutions and develop workable solution. Ability to manage multiple project tasks with changing priorities and tight deadlines.
• Extensively worked on Oracle Utilities Data Guard, Data Pump, Flash Back, SQL Loader, and RMAN.
• Worked with EXP/IMP, EXPDP/IMPDP to refresh the schemas and to restore the Dev, Test databases.
• Strong Exposure on High Availability Concepts (RAC, Standby), Database Cloning, and Oracle Streams.
• Expertise in Oracle performance tunning using statspack, tkprof, explain plan.
• Experience in Oracle 11g features like partitioning of tables,and caching and pooling.
• Effective troubleshooting of database and performance problems.
• Experience in SQL, PL/SQL. Experience in Data Modeling, Logical and Physical database design.
• Worked with development teams and data administration staff to enhance Database and application performance.
• Implemented database replication using shareplex.
• Expertise in Replication of Oracle Databases using Logical Standby and Streams and Shareplex.
• Worked with Quest Software to resolve issues with Shareplex.
• Upgraded Shareplex from 5.0 to 5.3.2
• Proactive monitoring, identifying areas that need to be improved in the application and database.
• Management of schemas, objects & partitioning the tables & indexes.
• Experience in managing large Oracle databases (VLDB) which includes OLTP as well as DSS. Experience in Data warehousing and ETL.
• Experience in CDC( change data capture) in Oracle 9i.
• Expertise in Replication of Oracle Databases using Logical Standby and Streams and Shareplex.
• Implemented Data Guard, Standby, and Oracle Streams technologies in mission critical systems and configured Switch over and Failovers with Physical standby database on Windows and Linux environments.
• Expertise in Oracle Golden Gate software.
• Experience in using Golden Gate to support data replication in the Oracle database environment.
• Experienced in setting up/installation and configuration of release 11g R1 RAC with ASM and Raw Devices and 11g CRS
• Experience in Data Migrations using oracle export/import, datapump, sqlldr.
• Experience in Benchmarking and capacity planning using oracle statspack historical data analysis.
• Performed backups and tested crash recoveries using conventional hot & cold backups and RMAN.
• Proficient in using OEM and RMAN.
• Good experience in SQL, PL/SQL, Shell Scripting, Partitioning, Data modeling, OLAP, Logical and Physical Database Design, Backup and Recovery procedures.
• Designing the logical and physical database structure.
• Schema design experience using ERwin, expert scripting experience in Perl and all Unix shell scripting variations.
• Excellent experience in OLTP/DSS database systems, implementing and managing large Oracle databases (VLDB) of size 4 TB. Expertiese in data warehousing design and ETL.
• Automated many common tasks using Crontab including: Backups, exports and imports, archiving old records and verification of such processes.
• Expertise in Oracle Architecture, I/O tuning, Capacity planning, space management, Memory Tuning, Performance tuning, Backups, Recoveries, RMAN backups, Optimization, Networking, Troubleshooting.
• Good experience in applying Critical Patch Update (CPU Patches) on Databases.
• Performance Tuning for Optimized results using Explain-Plan, SQL-Trace, STATSPACK/AWR, TKPROF and ADDM reports.
• Experience in Oracle Enterprise Manager (OEM) Grid Control, TOAD, RMAN.
• Proven ability of providing production support for 24X7 on multiple databases.
• Experience in accessing and managing contracts in SAP Contract Management system and integrating data from SAP to Datamart.

TECHNICAL SKILLS

Languages: SQL, T-SQL, PL/SQL, C, C++, UNIX Shell Scripting, Perl, XML, HTML.

Databases: Oracle 11g/10g/9i, MS-SQL Server 2000/2005/2008, MS Access

Platforms: Sun Solaris, Linux, HP-UX, Windows

DBA tools: SQL*Loader, SQL*Plus, Toad, EXP/IMP, EXPDP/IMPDP, OEMRMAN, Tkprof, DBCA, DBUA, Erwin Data Modeler r7/r8

ETL Tools: Informatica PowerCenter, SAP BOBJ Data Integrator

PROFESSIONAL EXPERIENCE

Confidential, Southlake, TX

Sr.Oracle DBA

Responsibilities:

• Planning, Implementing and Validating various versions of Oracle Databases to 10g Release 2(10.2.0.1, 10.2.0.2 and 10.2.0.4)& 11g Release 2(11.2.0.2,11.2.0.3) upgrades on all the environments (in a procedural approach Dev, Test, Stage and Production) also Planning of back out procedures like downgrades/building parallel environments and also working on proof of concept for Oracle 11gR2 upgrades.
• Implemented Oracle Patches (CPU, PSU) on the Compliance databases Device a plan to patch them quarterly so that we can cover all the databases in a year.
• Checking Databases Backup and Restore validity periodically, and Data refreshes from Production to Non-Production environment, Creation Duplicate Databases using RMAN Backups.
• Prepared test environments for backup/recovery using RMAN. Recovering Databases when there is any Physical or Logical Corruption.
• Implemented Physical standbys (Active to Active, Active to Passive) to Production.
• Enabled Auditing settings on all Non-Production and Production Databases.
• Used DBMS * packages to schedule jobs, re-engineering, gathering statistics, mview refresh...so on.
• Scheduling jobs through oracle JOB SCHEDULAR, Control M, Crontab (UNIX), Scheduled Tasks (Windows) .
• Writing UNIX shell Scripts and Scheduling through Crontab.
• Writing Audit Scripts to enable the Auditing in all Non-Prod and Prod Databases.
• Working closely with clients, business analysts, server administrators, systems programmers, and application developers to define and resolve information flow and content issues—helping to transform business requirements into environment specific databases
• Good experience in SQL, PL/SQL, Shell Scripting, Partitioning, OLAP, Logical and Physical Database Design, Backup and Recovery procedures.
• Designing the logical and physical database structure.
• Contacting Application Team and clients to gather the information for migration. Reviewed architecture.
• Implementation of RAC, ASM, DATAPUMP,FLASH BACK Recovery
• Configured Standby Database in manually managed mode. Shell scripts and Cronjobs are written to transfer the logs to standby site (Disaster Recovery site) at frequent intervals and apply to the Standby Database as per Business requirements.
• Troubleshooting and maintaining, Database Recovery, Automation of the Database Start up and Shut down. Database Migrations.

Environment: Oracle 10.2.0.4, 11.1.0.6, 11.2.0.2, IBM Maximo, JIRA Ticketing system, OEM 11g grid, SQL*Loader, Windows XP, LINUX, TOAD, SQL Developer.

Confidential, Detroit, MI

Sr.Oracle DBA

Responsibilities:

• Planning, Implementing and Validating various versions of Oracle Databases to 10g Release 2(10.2.0.1, 10.2.0.2 and 10.2.0.4)& 11g Release 1(11.1.0.6,11.1.0.7) upgrades on all the environments (in a procedural approach Dev, Test, Stage and Production) also Planning of back out procedures like downgrades/building parallel environments and also working on proof of concept for Oracle 11g upgrades.
• Performance Tuning for Optimized results using Explain-Plan, SQL-Trace, STATS PACK Reports and AWR Reports.
• Production Support for Critical Application Databases, work closely with Application Team in identifying issues and provide solutions for various issues (created via IBM-CMR,IMR in-terms of incidents and work orders of different severity levels like Sev1, Sev2, Sev3, Sev4).Used IBM Mange Now.
• Implemented Oracle Patches (CPU, PSU) on the Compliance databases Device a plan to patch them quarterly so that we can cover all the databases in a year.
• Checking Databases Backup and Restore validity periodically, and Data refreshes from Production to Non-Production environment, Creation Duplicate Databases using RMAN Backups.
• Experience with Replication concepts and used Golden Gate Software to do the replication.
• Implemented backup policy using oracle RMAN.
• Tune, optimize and monitor the database clusters and instances to achieve optimal performance in meeting defined SLAs (Service Level Agreements).
• Prepared test environments for backup/recovery using RMAN. Recovering Databases when there is any Physical or Logical Corruption.
• Created routines for Daily, Weekly & Monthly partitioning of tables. Created/Altered Partitioned tables for large customer related data.
• Implemented Transparent Data Encryption (TDE) for compliance related databases.
• Involved with enterprise-wide database security implementation and enforced many checks and balances to improve auditing, security and password protection. Also did Capacity Planning.
• Responsible for purging and archiving the production databases.
• Detected locks and resolving in-doubt transactions manually.
• Tuned oracle SQL statement by tracing.
• Golden gate migration and upgrading is performed.
• Tuned database servers by using new 10g features ADDM, AWR, Keep/pin objects, tune recovery time, ran SQL trace and generated TKPROF reports.
• Providing support to clients/developers regarding SQL queries, applications errors, database errors Prepared and managed system for Data replication. Loading flat file data into tables using SQL Loader.
• High level of tracing of Optimizer and SQL performance with events 10053, and 10046 etc, recommend any changes required.
• Upgrade and character set conversion of RAC databases with the aid of Oracle Golden Gate utility.
• Knowledge of the Oracle Golden Gate installation, configuration, troubleshooting GG issues.
• Schema design experience using Erwin, expert scripting experience in Perl and all Unix shell scripting variations.
• Assisted developers with the Tuning during the development and tuned the applications.

Environment: Oracle 9i,10.2.0.4,11.1.0.6,IBM Manage NOW, Remedy, SQL Server 2000/2005, OEM 10g grid, SQL*Loader, Windows XP, LINUX,WebSphere,Solaris5.9,TOAD,SQL Developer.

Confidential

Oracle DBA

Responsibilities:

• Configured Standby Database in manually managed mode. Shell scripts and Cronjobs are written to transfer the logs to standby site (Disaster Recovery site) at frequent intervals and apply to the Standby Database as per Business requirements.
• Scripts are developed to monitor the growth of the Database and purging policy is implemented at frequent intervals by raising change.
• By monitoring production Database through Instance Monitor, suggested some parameters for Database Tuning.
• Performed Smoke testing during the installation of every full build for application to validate the fitness of the application for testing.
• Functionality testing has been performed against the identified modules.
• Volume management using Verities Volume manager to configure Disk group.
• Configured Verities Net Backup R3.2 is to automate the physical Backup of the Database.
• Scripts are developed to monitor the growth of the Database and purging policy is implemented at frequent intervals by raising change controls.
• Experience in CDC (Change Data Capture) in Oracle 9i.
• Expertise in Replication of Oracle Databases using Logical Standby and Streams and Shareplex.
• By monitoring production Database through Instance Monitor, suggested some parameters for Database Tuning.
• User names are changed to new names as per business requirement during migration time.
• Suggested for the Backup strategy as per affordable downtime of production system.
• Worked on Recovery manager to recover the Database.
• Also involved in SQL performance tuning.
• Creation of database links
• Estimating the size of Databases.
• Creating Databases
• Upgraded the databases from 9.2.0.7 to 10.2.0.2
• Monitoring Standby Database whether all the logs transferred to Standby site and applied properly.
• Checking the Alert Logs of production Databases for any errors reported by Oracle.
• Adopting change control Mechanism (Lotus Notes Server) for replicating the changes made to the production Databases.
• Export and Import of databases from one database to another databases.
• Monitoring the performance of production database through Instance Monitor (Quest Tool) and growth of the database and suggesting for change in parameters if required.
• Writing the shell scripts to automate the Backup and copying the production copies to Test environment. (Scripts to copy from one test database to another database)
• Attending specific requests from online, bug fixing, Bulk rate, Data warehouse Teams.

Environment: SQL Navigator, Oracle 9i, 10.0, data Stage, Remedy, clear quest, Sun Solaris, H.P, Windows2000, PL/SQL, Shell Scripts, Maestro,ERWin4.0,TOAD.

Confidential

Oracle DBA

Responsibilities:

• Database Design, Backup & Recovery.
• Tuning the Database and Analyzing the Database.
• Coding PL/SQL & Shell Scripts, Design/Code reviews.
• The activities included the database administration of the various databases assigned to the division for the internal as well as external clients.
• Installation of the Databases, Environment Building to OFA compliancy.
• Backup Cold, Hot, Online, Exports, Performance Tuning, Remote sessions tracing.
• Recovery Manager (RMAN) Implementation and strategies, Various Database Recovery scenarios verification in advance.
• Altering the Database objects and files during maintenance.
• Implementation of RAC Technology.
• Database Maintenance, Data warehousing. Data Modeling using Erwin.
• Software design of medium/large business applications, Design methodologies.
• Database (SQL) design, E-R Modeling, Design and Development Of database design.
• Jobs Scheduling, Exports/ Imports, Space Management.
• Hot and Cold Database Backups and recovery, Shell Scripting, Restoration Tuning Memory.
• SGA, I/O, OTIMIZATION, SQL- tuning, Security Management.
• Remote Database Access Security management 24 x 7 Monitoring.
• Snapshots creations and Refreshing.
• Managing the network and service changes on the network of the databases.
• STANDBY Database implementation and Automation of the process (KSH, LOADER, PL-SQL scripting combination) of ftp download of files to proper load and update on tables.
• Writing shell scripts, Loading data into the database from the flat files with SQL*Loader.

Environment: Solaris 2.6/2.8, Oracle 8.0.5, PL/SQL, shareplex, Perl, Windows NT shell scripting, TOAD.