Experience Summary: 
15 years of service and maintenance experience with 12 years of core Oracle database administration, system administration. Experience includes Oracle development and management using ORACLE 10.2.0.4 / 11gR2. Also have system administration experience in Windows, Sun Sparc 8, 9 &10 platforms (64 bit), Redhat Linux 4/5.X kernels and other flavors.

Qualifications:
Oracle Certified Database Administrator (OCP) Oracle 8, 10, 11 
Microsoft Certified System Engineer Windows NT 4.0 stream – MCSE, 
Diploma in Information and Systems Management 
B.S in Science

PRESENT POSITION:

Database Analyst, Principal
Confidential 2009 June – 2011 Jan
Confidential 2011 June – 2012 Jan
Duties/Responsibilities: 
Knowledge of designing, developing, and implementing very large scale Oracle 10g and 11g databases, in PeopleSoft, OLTP and OLAP environments. Architectured many cross platform migration projects between databases for datacenter consolidation. Designed and implemented 11G data guard using online database method. Designed & Implemented RMAN & Netbackup integration for database backups. Well experienced with RMAN & Datapump utilities. Extensive knowledge to evaluate and install new software releases, patches, and system upgrades. Hands on experience with 10, 11 RAC with ASM & clusterware. Installed and configured EM Grid with agents in all DBs. Work with developers and tune poorly performing SQLs using SQL profiles using plan evolve and freeze methods. Capable of analyzing traces using tkprof & trcsess utilities as well as explain plans. Expert level knowledge on understanding contentions and tune Memory, IO, CPU. Capable of understanding and evaluate AWR, ASH, ADDR reports. Capable of writing & debugging procedures, functions & packages. Knowledge of SQL Server 2005. Good oral and written communication skills and ability to convey technical information to management. 
Work with application Architect team to gather information and translate into database design. Work with change management team and prepare release packages. Coordinate between developers and QA folks for release based changes. Deploy code in DEV, QA and Prod environments. Troubleshoot issues during major release and fix problems. Write PL-SQL procedures, packages & triggers on demand basis. 
Work with Server architecture team and design enterprise level plans which includes but not limited to LUN presentation methods, OS and hardware selections. Provide annual capacity planning for storage, hardware to management. Provide reports on monthly database growth.
Implemented HA architecture using data guard and golden gate replication methods. Performed successful switchovers using physical standbys. Installed configured GoldenGate 11.1 for database replication. Created extract, datapumps & replicates for Active-Passive & Active-Active replications. Troubleshoot conflict deduction and resoluction menthods. Implemented active monitoring for Golden gate process for lag reporting.
Environment: HP-UX, Redhat5,Hitachi SAN, Peoplesoft 8.9/ 9.1,ORACLE 10.2.0.4/11.2.0.3, SQL Server 2005, ASM, Openfiler,iSCSI,Clusterware, OCFS2, RAC, RMAN, GirdControl, Data Guard, , Shell scripts, Golden Gate 10, 11. VISIO, MS Project. HCM &LM 9.1, People Tools 8.5

Lead: Database Architect & Management
Client: Confidential 
2007 January – 2009 May
Duties/Responsibilities: Manage and lead a team of 5 DBAs and developers. Contribute to application & Architecture team in analysis,design & implementation till the final product. Experience in leading business requirements gathering and translating those into system requirements. Responsible for many critical business database systems (VLDBs 6TB) which should be available 24X7 with very minimal outage and acceptable performance. Patch & upgrade management and bug reporting to ORACLE. Implemented standard operating environment for DBs. Benchmarking different hardware with different configurations with simulated workload. Planned and executed database migrations between UNIX to Linux and Windows to Linux including different and same endian formats. Standby database (Data Guard) management. Performed switchover,failovers to deploy high availability during patching. Successfully migrated data centers with minimal downtimes. Interpret ADDM, AWR, ASH findings and configure database accordingly. Support peoplesoft databases(HR, Finance modules) by coordinating with Peoplesoft Administators. Worked closely with Peoplesoft administrators during migrations. Perform preventive database maintenance, performance monitoring, tuning, and optimization. Coordinate with vendors and purchase team to procure necessary software. Working with outsourced technology teams involving incident, configuration management teams at various occasions. Involve with enterprise problem management teams and report and analyze Srv 1 outages biweekly basis. 
Implementations: Designed and implemented two nodes RAC in ORACLE 10g/11g and RedHat 5. using ASM and OCFS2 & ACFS. Implemented and configured Grid for database monitoring. RMAN setup using Netbackup & Data Protector. Implemented MAA using RAC and Data Guard.
Environment: Sun Solaris Sparc 9&10,Redhat 4&5 on HP Proliant DL580G4/G5, HP HSG,EVA(SAN), EMC,Peoplesoft 8.9/ 9.1,ORACLE 10.2.0.4/11g, ASM, Openfiler,iSCSI,Clusterware, OCFS2, RAC, RMAN, Spatial, GirdControl, Data Guard, Quest BenchmarkFactory 5.5, Shell scripts, VISIO, MS Project.

Lead ORACLE DBA 2004 October – 2007 January
Client: Confidential,Columbia,MD
Duties/Responsibilities: Managed 20 production / dev. databases located at remote places and local office in RAC and standalone environment. Designed and implemented two way replication using Shareplex. Monitor and troubleshoot replication activities and other database related activities. Coordinate with help desk to resolve various user related issues. Analyze and implement database securities. Data modeling using Erwin/OWB for production database incorporating OLAP and OLTP techniques. Loading data using sqlloader & external table techniques. Fine tune the SQL queries using explain plan. Deploy current patches.Upgraded 9.2.0.1 RAC and standalone oracle instances to 9.2.0.8. Coordinate with system administrator to complete OS related tasks. Provide the management reports about the database as well as application side regular basis. . Designed and implemented the automated database backup methodologies (RMAN, logical, physical backups). Implemented RAC with two node cluster using SUN fire 880 clusters using Veritas clusters on Clarion storage devices. Designed and implemented two nodes x86 RAC clusters using unbreakable Linux (ORACLE version) using ASM storage. Implemented oracle Grid in 10g. 
Environment: Sun Solaris Sparc 9.0 / 10.0 on Sun fire V224 / V880, Windows 2003, ORACLE 9.2.0.8/10.2.0.2, Linux(Fedora 2.6), Unbreakable Linux 2.6, ASM, Veritas Clusters, OCFS2, PLSQL, Erwin cold fusion 7.0, Shareplex 5.1.7, Dimension Modeling, Oracle Warehouse Builder, RAC, , RMAN, Shell scripts.

Designation: Sr. Oracle DBA/Analyst – Computer Sciences Corporation 
Clients Handled: 
Confidential, MD, KDOT 
Confidential, Baltimore, MD, 
Confidential, Washington DC 
2001 January – 2004 october
Duties/Responsibilities: Responsibility includes installing Oracle instances and databases based on customer requirements, configuring the SGA and semaphores (SUN) to allocate appropriate memory and distributing the I/O to obtain optimum data retrieval, assisting the ASP/ASP.net programmers in resolving complex queries, planning and implementing the backup disaster recovery procedures & plans using RMAN and other methods available. Creating and updating the Entity Relationship Diagrams and data dictionaries. Upgrading, patching the databases with security updates and document the same. Data loads using Pl/SQL, imp & exp utilities and SQL loader. Create stand by database using data guards. Fine tuning the queries. Writing PL/SQL procedures, functions, triggers & packages. Managing the databases using Enterprises Manager. Implement security policies within the database. Gather database statistics by analyzing the tables and indexes. Table partitioning. Coordinate with software deployment team for application deployment. Coordinate with ORACLE for software procurement, licensing issues, patch installation and maintenance contract etc. Dealing with metalink portal engineers for any critical issue (creating tar etc). Manage the storage system using Solstice, SUN volume manager and VERITAS. Writing Shell scripts to create cron jobs to backup and run maintenance related scripts inside ORACLE databases. 
Environment: Sun Solaris Sparc 8.0 on Enterprises 5500 server, Sun volume manager, Sun Blade Sparc Workstations, Windows NT 2000 & 2003, Windows XP Pro, ASP/ASP.net Oracle 8.1.7 / 9.2.0.6 / 10.0.1.4 Serves, SQL server 2000, PL/SQL, ODBC, Advanced Replication, Data Guard(Stand by DB), RMAN, TKPROF, Erwin 4.0, Shell Scripts

Client: Confidential– Jeffersonville, Indiana June 1999 – December 2000
Designation: Oracle DBA 
Responsibilities included: worked on one of the world’s biggest imaging projects(US Census 2000) involving Sun Solaris, Windows NT 4.0 servers and clients and Tivoli, providing maintenance and support for 15 8.0.5 and 8i databases with sizes over 50 GB, creating databases, installing Oracle software in a RAID 5 environment, designing and planning backup strategies, performing logical and physical backups, writing backup scripts, migrating tables and schemas using the import/export utility, tuning the SGA, redo logs, and rollback segments, designing rollback segments for proper storage values, creating tables and indexes with proper percent used and percent free values, creating users, roles, performing optimization on table spaces, tables, and indexes, recovering the table spaces and data files when necessary, and rebuilding indexes for DML intensive databases. 
Environment: SUN Solaris 2.6 (Sparc), Windows NT 4.0, Oracle 8.1.5 (8i), Tivoli 

Client: Confidential. June 1993 – April 1999 
Designation: Oracle DBA, System Administration
Responsibilities included: Oracle / Sybase database administration and networking for several customers and agencies in India. Specific responsibilities included: creating Oracle Instances, test and production database, loading data into the database using SQL*Loader, performing hot and cold backups for the databases, performing imports and exports of the databases for backup purposes, performing load testing, and performance tuning on the SGA, configuring Net 8.0 connections, migrating schemas, rebuilding indexes for performance, performing database recovery when necessary, writing all backup procedures and recovery procedures. Other responsibilities included: creating database users for security purposes, working with Oracle 7.3.4 and all associated servers for payroll systems, creating packages for Microsoft Courseware, supporting network and system related issues on the Windows NT and Novell 3.11 servers, creating reports using MS Access 97, Crystal Reports, and Visual Basic for reporting purposes. Environment: Windows NT 4.0, Novell Netware 3.11, Exchange 5.0, Proxy Server 2.0, Oracle 8.0.5, Sybase, Access 97, Visual Basic 5.0, Windows 95 and Windows 98