Oracle DBA

Professional Summary

Oracle & SQL Server Certified DBA having over 7 years of experience of database administration on various platforms like UNIX (AIX, Solaris, and HP-UX), Linux (RHEL, OEL) and Windows (2003) environments. Worked extensively on database Installations, maintenance, migration, upgrade, patching, High Availability & DR (RAC, Dataguard, Replication), performance tuning, backup recovery, designing and Used several both Oracle and SQL Server utilities and third party tools to get the job done. Managed Multi Terabyte OLAP/DW Informatica Databases.

Strengths Include RAC,ASM,OEM/GridControl,DataGuard/Standby, RMAN, Datapump,Export/Import, SQL loader, Scripting ,CPU & PSU Patches, Cloning/Refresh , AWR/Stats pack, 24/7 database support, performance tuning, designing Backup and recovery strategies, Change Management ,Release Management , User Management ,Capacity planning. I also have Hands on experience using Oracle EBS, Oracle 10gAS, APEX and Crystal Reports and Microstrategy reports Administration. Worked with the BMC Patrol team to setup Monitoring on MSSQL and Oracle Databases. Worked closely with VSU team for DB Snapshots

Familiar with VERITAS Clusters failover, File systems mounting, Startup and Shutdown procedures, Monitoring Swap Space, Process Management, working with remote machines, User and Group Management, File System management, Scheduling jobs and also experienced in implementation of enterprise databases on enterprise Storage Solutions using Storage area Networks (SAN) /Network Attached Storage (NAS). I am a self-motivated individual and I possess good communication and interpersonal skills and works well both independently and in a team environment.

Technical Skills

Database Servers Oracle(11.1.x,11.2.x,10.1.x,10.2.x,9.2.x),Oracle10XE,SQLServer

2005, 2008,MySQL

Application Suites RMS 13,Oracle EBS 11i(E-Business Suites),Oracle 10gAS,APEX 4.0.3.0

Clustering Oracle 10g RAC, VERITAS Cluster Ware ,Microsoft Cluster Server,CRS

10.2.05, 11.1.0

Operating Systems Sun Solaris (2.6,5.6, 8, 7), RHEL (4.7,5.5),OEL (4,5), HP-UX 10.x, 11.x,

IBM- AIX 5.1, 5.2, 5.3, Windows NT/2003/XP/Vista

Languages SQL, PLSQL,T-SQl, C, C++,C#,HTML

Scripting Shell , Perl, Windows Power Shell 2.0

Oracle Tools, Sql*Plus, Data pump, Grid Control/Oracle Enterprise Manager(OEM),

Utilities & Features (OMS/OMR),DBVerify,Dataguard,RMAN,LogMiner,SQL*Loader, Export/Import, ASM, TKPROF, AWR, OPATCH, DBCA, DBUA, Statspack, External tables, Oracle Performance analyzer, OEM Change Management Pack, Streams, SQL Developer Migration Workbench

SQL Server tools & Management studio, BCP , profiler, query Analyzer, SQL Server Agent

Utilities & Features Bulk Load, export/import, ODBC DSN, OpenDataSource, Compressed Backup (2008), Linked Server, Replication Monitor

Reporting tools Crystal Reports, SQL Developer 1.5,microstrategy 8.2

Scheduling, Monitoring Cron jobs, Oracle Enterprise Manager/Grid Control, SQLServer Agent,

& Backup Tools Windows Scheduler, BMC Patrol, VSU Snapshots (Backup)

Third-party Tools TOAD,SQL Developer, Sql Navigator,plsql Developer, Putty, SSH, BMC

Remedy, BMC Patrol, Erwin, Workbench, CollabNet Subversion v1.6.5

Virtualization VMware server ,VMware Workstation, Oracle VM, Virtual Box, Oracle

VM Server 2.1.5, Xen Hypervisor

Data Warehouse & Erwin R7, SQL Developer Data Modeler (1.5.5, 1.2),Informatica 8.1,8.6

Modeling , SSIS

Education & Certifications:

Masters in Computer Science

Oracle 11g Database Certified Associate (OCA)

SUN Solaris 10 (SCSAS) certified

Microsoft SQL Server 2005 certified Technology Specialist (MCTS)

Certified in “EMBEDDED SYSTEMS” from UTL Technologies, India

Abercrombie & Fitch, OH March’11 –Till date

Oracle RETEK/Retail Merchandising System (RMS) DBA /Application DBA

Responsibilities:

Worked as Application DBA in RMS team and responsible for Change Management and Performance tuning of all the Prod/test/QA/DVLP environments Which are in 2 -Node RAC configuration on IBM 590

Worked on Performance tuning of PO ,RPM and RESA modules of RETEK

Responsible for Change Management and DB Requests from the developers

Closely worked with the developers to understand the RMS code and suggest changes in the code to increase performance

Responsible for bringing down the PO(Purchase Order) time from 9 mins to 2 mins

Responsible for implementing Multi-threading in PO Breakout by calling Shell and Pro*c executable's from Oracle Forms which resulted in 4 times faster performance gain

Created plsql Packages for Maintenance jobs like Gathering & Import stats when new partitions are created and Index rebuild when the index is fragmented

Responsible for Scheduling OEM jobs,chains ,Schedules and Oracle external Jobs using shell scripts

Work closely with the developers and end users to resolve locks and trace their sessions to identify performance issues

Worked with developer to tune independent SQL's by adding Oracle Hints if necessary

Responsible for Creating Materialized views & Pinning Frequently used Packages to Shared Pool to increase query performance

Created and maintained new DB Users and Roles and Privileges needed by them

Created ASH/AWR/ADDM reports in OEM for performance tuning

Created a triggers to track logons and create a trace of the db session

Identified the unnecessary loops in code using the tkprof output of the trace files and worked with the developers to implement bulk-inserts by using GTT /plsql objects to increase performance

Created Db-links and additional constraints and indexes when requested by developers

Monitored the Db change management using HP Quality Center and Subversion

Worked with the Release Engineers during the Monthly releases

Responsible for On-call Support/Investigating the Batch Failures and suggest changes

Worked with offshore Production/Operations support team and documented the process and procedures

Environment:

Oracle 10.2.0.4,RAC,ASM 11.1.0.6.0,AIX 5.3.0.0 (64 -bit),OEM 11g ,tkprof , RMS13, Oracle Forms ,SVN,Erwin,HP Quality Center 10.00,Toad 10.6.1.3, IBM 9119-590(20 cpu's),Erwin, pl/sql

Frontier Communications, NJ, MN

Verizon Data Services, FL November’ 09– March’11

Verizon Business, VA

Oracle/MS Sql Database Administrator

Responsibilities:

Worked for the IDEAS-DBE team for Production support and core DBA functions .Involved in “Project North(Verizon – Frontier Deal)” for Database Support and Migration of more than 25 Environments of NSA, NMP/DSS, WEB-GUI, Vsolve, Vconnect ,OASR,Drivethru, MOGs,MOQA etc .., which include both Oracle and SQL Server databases

Worked on the Infrastructure Projects like upgrading CRS 10.2.0.1 to 10.2.0.5,Upgrading BDMS-FTTP,BDMS-ADSL and VCAS databases from 10gR2 to 11gR2, upgrading NMS from 10.2.0.4 to 10.2.0.5 to avoid stability issue found in 10.2.0.4, such as ASM hang issues

Worked on 9.2.0.8/ IBM AIX 5.2 to 10.2.0.4/RHEL 4 Upgrade

Worked on Production support of 3 node 10.2.0.4 / Oracle Clusterware 11.1.0 on RHEL 4.7 which support two clustered databases with the 10.1.0.4.0 Grid Control/OEM repository (OMR & OMS 10G)

Installation and configuration of oracle 11g R1/10g on HP-UX, UNIX RHEL 5.x series

Developed a DB Monitoring tool for the Manager to track the team tasks and Monitor the DB status

Supporting Data Migration Team for all their activities like, installing source, stage and swing databases, refreshing DM servers with production data, etc.

Supported Data warehouse team by Partitioning, Defrag, Space management and Tuning the 5 Terabyte Informatica database and in building the design of the database and support

Supported the NSA and WEB-GUI Applications team with their Weblogic, Genesys Vsolve,Vconnect and several other application database related problems, provided development support to maintain application schema and distribution of data

Involved in the Design of Backup and Recovery Strategies using RMAN to both Disk and Tape, and Configuring Oracle Data Guard for the Data migration

Developed UNIX Shell scripts and scheduled them for daily database backups and other scheduled database /Space monitoring jobs and to get alerts for ORA errors and failed jobs .

Extensively used SQL SERVER BCP Utility and Import/ Export to load the database from text files received from different applications.

Created SSIS Packages for data loading and used SQL Server Export/import tool also.

Configured transactional Replication between primary Server and Read-Only servers with separate distributed servers.

Worked on SQLserver Heterogeneous Replication (SqlServer ->Oracle )

Worked on complex data loading (implemented the batch data cleansing and data loading).

Scheduled new jobs on production environment to perform Backups and Monitor the database

Setting up database backup and recovery procedures to take Full /Diffrential backups ,T-log backups for production and development servers

Created login accounts and database user accounts and managed database security using groups and roles

Created store procedures using T-Sql to implement several DB Changes

Monitoring MS SQL Server performance using performance monitor and SQL Server profiler to generate traces

Interact with POC/SMI's to get the feeds from different Interfaces

Performed all aspects of database administration including installs, builds, upgrades, object sizing, object creation, Partitioning, Defragmentation, backup/recovery, patches, monitoring, exp/imp and SQL loader/External tables, Scheduling Database Jobs

Performed weekly and monthly Releases for both Oracle and SQL server based applications

Involved in capacity and resource planning. Estimated the size of data files and redo log files considering transactions rate, transaction records size, transaction type, recovery time allowed etc

Performed Health check and assisted in Go/No go decisions in the final cut-over for more than 25 Oracle and SQl Server databases during data migration's

24/7 Database support of multi-terabyte oracle 10g and Sql server databases by attending the CMIS tickets/IR.

Created Tasks plans/CA's and Initiated change control for Database releases and changes using Nchange and MTACT for all the applications I support

Interact with the Netbackup,VSU Snaps and BMC Patrol teams for Backups and Monitoring of both Oracle and SQL Servers

Coordinated with multiple application,SA,Storage,Network and Security teams for Tech refreshes and Releases

Evaluate 3rd prarty software and make recommendations to Sr Management

Conducted training sessions for offshore Production/Operations support team and documented the process and procedures

Environment:

Oracle 11.1.0.x,10.1.x, 10.2.x, 9.2.x,SQL Server 2005/2008,Oracle APEX 3.0/4.0,Windows 2003,Sun OS 5, HP-UX, IBM- AIX,RHEL 4.x,5.x, RAC, OEM,VERITAS Clusters ,Windows Clusters, Oracle Dataguard, Toad, Informatica 8.1, Web logic, Microstrategy 8.2 ,SQL Server Agent ,.net 2.0,C# ,asp.net,Visual Studio 2005,Siebel,BMC Portal ,VSU ,T-sql,Pl/SQL

Stanford University, CA May’ 08 – September’ 09

Sr. Oracle Database Administrator

Responsibilities:

Involved in the database support for the Production/Development Environment of , “Campus Manager and E-Student Manager ” projects

Responsible for Data Migration from oracle 9i to oracle 11g database

Installed and configured Oracle Enterprise Manager Grid(OEM) control and Intelligent Agent to collect the metrics for Grid Control and Upgraded Oracle management Service(OMS) and Oracle management Repository(OMR) to the latest release

Supported and Implemented Data Guard/Standby Database as a part of the Disaster recovery (DR/COB)

Supported and Implemented Advanced Replication/Streams and Documented the procedure

Responsible for applying Patchsets and One-Off Patch of databases and upgrade them to current Patchset and also Applied Patch Set Update which also contains latest CPU Patch with OPATCH

Provided weekly Clones; Created post clone procedures; performed Refreshes when necessary

Performed logical & RMAN backups to take full and incremental backup and scheduled Cron jobs for daily and weekly backup

Used SQL*Loader and external tables to export/import data from flat files

Responsible for Implementing and Documenting Data Pump tasks to move large amounts of data from one database/schema to another based on the requirement

Monitored database performance using STAT_PACK/AWR, homegrown scripts , server utilities, ADDM, OEM DB Console, and DB Advisor

Optimized and tuned SQL queries using TRACE FILE, TKPROF, EXPLAIN PLAN and Interpret ASH/AWR reports and prescribe recommendations to DBA/Dev team

Responsible for tuning SGA, sizing UNDO, Shrinking the segment size and avoiding Row Chaining and Row Migration by doing Re-org (CTAS)

Wrote scripts to monitor and manage space, alert logs daily for oracle errors and Scripted jobs that generate monitoring reports and send it to the respective user’s mail box

24/7 Production Database support of oracle 10g database.

Executed typical DBA activities, such as Installation, Creation, shared support of controlled and non-controlled Oracle instances, Space Management, Re-org of tables and adding data files to Tablespace, User Management, managing the tablespaces to reduce I/O contention & Tablespace Fragmentation, creating database triggers, managing redo log groups, and undo Tablespace

Environment:

Linux RHEL 4, Solaris 8, 9 & 10,OEL(5,4),Oracle EBS 11i,Oracle 10g AS, Oracle 11.1.0.6,10.1.x,10.2.x, 9.2.x, Oracle RAC, OEM /Grid control, Dataguard, OPATCH 10.2.0.4.7, Toad

Cardinal Health, OH July’ 07 – March’ 08

Sr. Oracle DB Administrator

Responsibilities:

Supported Oracle E-business Suite on Solaris 9 running on Sun Fire 6800 servers. The Oracle 9i RAC database is running on the same platform using attached to HITACHI SAN Storage

Created and Refreshed Materialized Views to increase query execution performance

Ensuring High Availability - Maintaining Standby databases to ensure they are in synch with production database

Performed installation , creation of Oracle 9i/10g on Solaris and RHEL

Restored Tablespace from traditional Hot backup using Tablespace Point in Time Recovery (TSPITR)

Upgraded Oracle binaries and applied one-off patch from the oracle support for bug fixesUsed Transportable tablespace / traditional Export, Import or Datapump to transfer elements of a schema between two databases

Designed RMAN backup strategy for all Development , UAT and Production environments

Performed planned backups and Recoveries from logical and RMAN backups

Performed Cloning and Refreshes

Monitored the alert logs daily

Loaded data from flat files into Oracle tables using SQL*Loader

User Management and Space Management

Worked with Grid control/OEM tools like UNDO advisor, Segment advisor

Change Management including maintenance of multiple development, test, QA, and production environments

Perform capacity and resource planning and estimate the size of data files and redo log files

Used latest 10g Automatic Workload Repository (AWR) & Automatic Database Diagnostic Monitoring (ADDM) reports for the health check of the databases, and used the notification tool to send the alerts in OEM Grid Control

Used OEM Diagnostic and tuning packs to tune the application and SQL queries

Analyzed the statistics periodically and took remedial action

Continuous monitoring of database performance using STATSPACK

Used Oracle Diagnostics tools such as Explain Plan, SQL Trace, TKPROF to analyze timing and execution plan for SQL query to tune the SQL statements

Wrote and scheduled scripts to find Highwater mark, to perform server clean up, analyze tables and indexes, perform backups ,monitor percentage of the tablespace used and to monitor the cache hit and miss ratio

Identified long-running database queries, refined queries for better performance, and worked with end-users to implement changes

Monitoring system performance using UNIX utilities like vmstat, iostat and monitor processes using SAR,TOP

Daily activities included monitoring the system and session waits, adding datafiles, creating datafiles rebuilding indexes, attending the issue calls

Environment:

Oracle (10.1.x, 10.2.x, 9.2.x), RHEL (4, 3), Sun Solaris, Windows NT, Oracle 9i RAC, Grid Control/OEM, VERITAS Advanced Clustering 3.4, OPATCH, Remedy, TOAD

Wells Fargo, MN December 06 – June 07

Oracle Database Administrator

Responsibilities:

Created Users and granted Roles & Privileges to users

Created Table space for new applications and Added new data files when needed

Refreshed schemas from one environment to another using exp/imp utility

Responsible for scheduling daily incremental backups using RMAN and recover when needed

Created automated backup scripts using Data Pump and traditional exp/imp utilities for seamlessly refreshing the development databases with testing database

Imported data using SQL* Loader to Interface tables

Responsible for Partitioning the tables as the business demands and Rebuild Indexes when required

Created scripts for complete database report that shows the database hit ratio, shared pool, rollback segment stat, and table space statistics

Participate in the planning, design and usage of data resources

Reorganized & Rebuild tables and indexes based on Planed Outage work

Alert logs Monitoring

Used SQL*Loader to export/import data from flat files

Optimized and tuned SQL queries using TRACE FILE, TKPROF, EXPLAIN PLAN and assisted Oracle developers tune source code

Participated with the application development team to design Oracle Database and to enforce the coding standards and developed triggers

Wrote scripts to automate database startup with the server startup for the databases in the testing environment

Monitored long running SQL queries and killed sessions running expensive SQL operations consuming high CPU and effecting database performance

Created Triggers on the schema level to track DML/DDL statements

Exported Data from SQL Server database to Flat File and converted the date format as per Oracle Database and imported the data

Providing support to databases for their highly critical OLTP and voluminous (VLDB) production databases on different cluster/noncluster platforms

Tuning of SGA viz. Shared Pool by Tuning of Library Cache, Dictionary Cache, and Buffer Cache, and tuning of OS by Reducing Paging/Swapping, I/O Tuning and tuning of memory allocation

Cleaning the udump, cdump, bdump directories of large core files, user dumps

Ensured database security using appropriate roles and privileges; Responsible for standards and implemented the security policies for user profiles

Troubleshoot database issues including backup failures, ORA errors; Created SR’s with Oracle for the issues

Environment:

Oracle (10.1.x, 9.2.x), SQL Server (2005,2000), RHEL 4, OEL 4, OEM, OPATCH, Remedy, Windows 2003

Hindustan Lever Limited September 05 – November 06

Oracle Database Administrator

Responsibilities:

Performed day-to-day DBA jobs for managing 15+ Prod/Dev databases

Assisted in supporting Oracle databases and applications under the direction of a Senior Oracle DBA

Oracle Databases installation, creating and managing instances, schemas, users, profiles

Performance monitoring, tuning, storage management, capacity planning, Backup and recovery

Maintained and monitored multiple Oracle database instances in production, development, and test environments

Used DBVerify to check the database integrity and the integrity of the backups before restoring them

Wrote Unix Shell Scripts to automate jobs

Participated in testing and development of performance standards

Performed and verified database backups and recovery procedures using RMAN

Performed and wrote scripts to Automate Refresh of non-production databases.

Performed SQL queries using SQL Worksheet and SQL Plus, Data researched and analysis

Administered Oracle databases and its users using Oracle Enterprise Manager and DBA Studio

Environment: Oracle (9i, 8i), Solaris, RHEL 4, SQL Plus

SunTec Info Systems Pvt. Ltd., India January 05 – August 05

Oracle DBA/Developer

Responsibilities:

Provide technical assistance at various client (BSNL) sites in India using oracle tools (Sql Loader, Sql Plus, Oracle Reports, PL/SQL, Tablespace maintenance, Import and export, Database Administration, Backup and Recovery, Troubleshooting)

Database Recovery & Recreation, Oracle Tuning, Backup & Recovery

Implement Oracle Database and customize Software on Unix platform

Cloning and Refreshing of the instances with the Live Production database every Week

Meter Reading conversion- uploading, Trunk Call conversion, Local call charging through pl/sql programs, triggers for logging billing manipulations etc.

Check the Oracle log files and the trace files from the udump, bdump and cdump directories basically the last entries and specially the Oracle Errors. And then troubleshooting them

Running monitoring scripts for complete database report that will give the database hit ratio, shared pool, rollback segment stat, and tablespace stats

Installation of Oracle with Database Recreation and Software Implementation

Create and Planning Backup Strategies

Perform database tuning and performance monitoring using oracle tools like Oracle enterprise manager, tkproof utility and also run various monitoring scripts for taking database report to troubleshoot performance issues

Tune the Oracle Database in regard to performance optimization

Test all the modules running in the software as desired with proper output.

Meter Reading conversion- uploading, Trunk Call conversion, Local call charging through pl/sql programs, triggers for logging billing manipulations etc.

Supporting 2 Cycles of Test billing and final issue of live bill.

Writing control script, for data uploading through sql loader etc..,

Performed basic DBA functionalities

Give training to BSNL concerned users.

Environment: Solaris (9, 8, 2.6), Oracle (9.2.x, 8i), SQL, PL/SQL, UNIX shell scripting, XML, SQL Loader, TOAD, VI editor, Export/ Import, SQL*PLUS

Contact this candidate