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.

PRESENT POSITION:

Confidential

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

Confidential

• 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

Confidential

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:

• Department Of Human Resource, Baltimore, MD, KDOT Kansas Department of Transportation , Kansas
• DLLR Department of Labor Licensing Regulations , Baltimore, MD,
• US Department of Agriculture, 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

Worked as a database designer for KDOT to design their data warehousing project. Co-ordinate with various level of administrative officials to understand the business flow and designed the table structures Star schema, Dimensions .

Environment: Windows NT 4.0, ORACLE 8.1.7, ORACLE Warehouse Builder.

Confidential

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

Confidential

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