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 / 11 gR2. Also have system administration experience in Windows, Sun Sparc 8, 9 &10 platforms (64 bit), Redhat Linux 4/5.X kernels and other flavors.

PROFESSIONAL EXPERIENCE:

Database Analyst, Principal

Confidential

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 & ManagementConfidential

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.
• 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/11 g, ASM, Openfiler,iSCSI,Clusterware, OCFS2, RAC, RMAN, Spatial, GirdControl, Data Guard, Quest BenchmarkFactory 5.5, Shell scripts, VISIO, MS Project.

Lead ORACLE DBA

Confidential, Columbia, MD

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.

Sr. Oracle DBA/Analyst

Confidential, Baltimore, MD

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