SUMMARY

• Over 7 years of experience in IT Industry as a Oracle DBA in the various sectors of Telecommunication, HealthCare, Banking, Retail, Education, Manufacturing and E - Commerce.
• Experienced in working with State projects oriented towards Human Services Welfare.
• Responsibilities include Database Creation, Tuning/reorganization, developing SQL Queries, Stored Procedures, Backup and Recovery, Troubleshooting, UNIX Shell Scripting, Documentation and End User training.
• Experienced in Administration, monitoring and support of Databases of size up to 12 TB.
• Expert in Performance Tuning of Database, SQL Queries using TKPROF, Explain Plan, AWR, ADDM.
• Experienced in Design and Implementation of Backup and Recovery Strategy using RMAN, TSM, Symantec Netbackup, Backtrack, Omnibackup, and SQL. Installed and configured RMAN, Oversee, improve and implement scripts, processes, emergency procedures and testing of all RMAN operations.
• Experienced in Installation, Configuration, support of RAC on AIX, HP-UX, Linux using raw disk, ASM. Monitoring and Managing RAC performance issue using tool NMON, RDA and OSWatcher. Testing of Oracle10g Transparent Application Failover (TAF).
• Experienced in Oracle 8i/9i/10g/11g features (OPS, RAC, Data Guard, Streams and Log Miner), Java, J2EE.
• Expert in Installation and configuration of Oracle 10g/11g Data Guard with RAC databases.
• Worked on Switchover and Failover scenarios for high availability Server with DG Broker.
• Worked on Migration of Databases from 9i to 10g using Golden Gate. Installed, configured Golden Gate and its Processes with File permission for Cross Platform Migration, Replication.
• Installed 10g GRID Server, OEM agents and managing databases using GRID Control
• Installed and configured Oracle 9i/10g/11g RAC on Linux 4 AS 64bit, HP-UX11i, AIX5.x and Solaris 9/10
• Experience in deployement of web applications on Tomcat, JBoss, Weblogic and Websphere application server. Installation of Oracle 11g SOA Suite and configuration of Weblogic 11g server
• Experienced in logical, physical database design, relational models for OLTP and Dimensional model for OLAP, DSS databases, star schemas and snowflake schemas using Erwin, Oracle Designer and MS Visio.
• Experience on ETL Tool Informatica Power Center 7.0/ 8.x, AB Initio 2.14 and ODI 10.x.
• Worked on Refreshing development & test schema/tables using Export/import, Datapump.
• Expert level knowledge of creating and maintaining Tables, Partitioning, indexes, Materialized Views, Parallel Execution, Global Temporary Tables, Triggers, Stored procedures.
• Worked on Database security skills to design controls and monitoring capabilities for user access.
• Worked on User Account Management - Creating database Users, Quota, Roles, Privileges, Password management, Connectivity issues related to Listener, tnsnames, ODBC.
• Strong database knowledge in terms of structuring complex SQL Queries, Joins and materialized views.
• Expertise in handling Very Large Database (OLAP) and OLTP environment.
• Writing Unix CRON script to automate OS and database related process schedules
• Expertise in developing SQL Queries, Functions, Stored procedures, PL/SQL using cursors in Oracle.
• Excellent organizational, interpersonal, communication and problem solving skills.
• 24X7 support for production database and maintain uptime of 99.99 %.

TECHNICAL SKILLS

Databases: Oracle 7.x/8.0, Oracle 8i (8.1.5, 8.1.7), Oracle 9i, Oracle 10g & 11gMS-SQL Server 2000/2005, IBM UDB V6.1/7.1, MYSSQL 4.6/5.1

Operating Systems: Sun Solaris (2.4, 2.5, 2.6, 2.8,9/10), Digital Alpha OpenVMS, HP-UX 11iI IBM-AIX 4.3/4.7/5.1/5.3 , Windows NT/2000/2008, SCO UNIXRedHat Linux, Novell Netware4.1.

ERP and Domains: SAP 4.6c, Oracle EBS 11.5.7, 11.5.9, Siebel CRM, Peoplesoft HRMS Logistics Domain OTM 5.5, Kewill Flagship, Manugistics Healthcare Domains Cerner Millennium, EPIC Educational Domains Sungard Banner, Peoplesoft Digital Campus

Languages: C, Java, SQL, PL/ SQL, XML, Business Objects (6.1, 5.1.x, 5.0.x), Oracle Enterprise Manager (OEM), Oracle Management Server(OMS),DBA Studio, DBVerify, DBArtisan, Oracle Fail Safe (OFS), UTLSTAT,Explain Plan, TKPROF, Logminer, SVRMGR, SQLDBA, SQL*PLUS, SQL*NET (V2), Net8, SQL*Forms, SQL*Report Writer, SQL*Loader, Import / Export, Designer 6i, TOAD, RMAN, Erwin, ShellScripts, Crystal Reports, Omniback II 2.55/3.0/3.1/3.5 (SAP/EMC-SRDF & Oracle Integration), Veritas NetBackup integrated with Oracle, SFRAC

PROFESSIONAL EXPERIENCE

Confidential, Towson, MD

Sr. Oracle DBA

Responsibilities:

• Setup and configured 11g RAC on veritas cluster system. Resolve issues related to Oracle11g rel-2 RAC performance issues related to new features.
• Resolve connection issues for OBIEE with RAC Config and worked with SAP Basis for BR Tools, Cloning of DB.
• Installed Oracle 12c Grid to monitor all the databases and HP Openview for OS monitoring to alarm point.
• Written pl/sql code for business objects related to Warehouse, Global Logistics and Trade along with financial settlements
• Written korn shell scripts to monitor Oracle 9i databases after De-Support from Oracle Corp
• Administered all database objects, including tables, clusters, indexes, views sequences packages and procedures troubleshoots with regards to database problems, applications
• Did migration of Oracle datafiles to ASM filesystem and written technical docs for this conversion.
• Done performance and tuning, monitoring, backup and recovery, auditing for both Oracle and Sql Server DBs . Oracle experience/skills with logical and physical database design, setting up of high-availability and disaster recovery solutions.
• Created different types of Indexes (B tree, reverse key, IOT and function based etc), different types of partitions (List, hash, composite etc) on different tables.
• Responsibilities included Datawarehouse database design using Erwin (Physical and Logical layouts). Creation of Partition tables and implement of parallel query.
• Done performance tuning using SQL application tuning using TKPROF, SQL TRACE for session, STATSPACK, Explain plan. Provided tuning support for SGA (shared pool, buffer pool and log buffer pool etc).
• Setting up of high-availability and disaster recovery solutions.
• Data loads using SQL*Loader, export-imports for backing certain tables.

Environment: Oracle 11g/10g/9i, SAP 6.4c, Solaris2.10,AIX5.3, Red Hat Linux, SQL Server2000, Erwin, ClearCase

Confidential, Cincinnati, OH

Sr. Oracle DBA

Responsibilities:

• Working on different CORE applications with automated database objects scripts deployment in different environments, providing support to fine tune process, supporting different application groups for problem resolution with root cause analysis, performance tuning on queries with alternate solutions depends on application requirements. Supported tests, performance analysis in very rapid application deployment cycle with timeframe decided by different in-house application groups.
• DB/Schema refresh and involved in Load test, playback and performance test with new configuration
• Upgradation/Migration of 9i,10g CRS, Logical Volume DB on EMC Storage to 11g Release-2 with a new installs of ASM instances
• Architect their Replication environment with Reference DB hubs with implementation of Goldengate and conversion of Streams processes
• Install and setup Oracle 10g Grid control, Agents in RAC environment and implementation of dbms scheduler to automate jobs.
• Re-write adhoc queries with new approach to improve performance in terms of elapsed time, cost.
• Work on projects for implementation of RMAN incremental backups, Partition tables for OLTP, OLAP environment, Parallel Query, configuration of DBMS Workload Repository

Environment: Oracle 11g/10g, AIX, TSM, Goldengate 11.1, SAP 6.4, SQL Server 2000,Java

Confidential, Kansas City, MO

Oracle DBA

Responsibilities:

• Install, Setup and configured 10g/11gRAC on Red Hat Linux, Solaris, Window,HP-UX (add/delete instances), AIX5.3 using Automatic Storage Management (ASM).
• Install GoldenGate 9/10 and configure new features, parameters for new version 10 as prescribe by Goldengate
• Migrated Oracle 8i,9i OpenVMS to 10g aix/hpus/redhat using Goldengate with zero downtime
• DB Replication configuration of primary database with secondary with GoldengateTDM and veridata for live-record Comparisons to avoid discrepancies in SQL reporting Server.
• Administered all database objects, including tables with blob, clusters, indexes, views packages and procedures troubleshoots with regards to database problems, applications and tool support for Goldengate components.
• Done performance and tuning, monitoring, backup and recovery. Oracle experience/skills with logical and physical database design, setting up of high-availability and disaster recovery solutions.
• Installation of Oracle 10g(10.2.0.1) Grid control, patch upgrade it to 10.2.0.5 and configure all roles, monitoring events, user profiles.
• Did migration of data files from raw file to ASM disk
• Install/configure 11g Dataguard with RAC databases on aix and work with failover/switch scenarios for high availability along with rolling upgrade of primary/standby from 10g to 11g
• Written custom shell scripts for RMAN backup to implement networker and netbackup. Played a lead role for rman backups for Midwest datacenter client.
• Handled the tuning using the explan plan,tkprof deciding based on disk, CPU, SGA and undo load. Monitored indexes.
• Written custom applications using pl/sql to monitor the DB events, applications using Oracle
• Proficient in Microsoft SQL Server 2000, 2003 & 2005 with T-SQL programming, creating Stored Procedures, Triggers, Views, Indexes, Joins, User Defined Functions and Cursors.
• Familiarity with hp-ux(sam,shm,sim,glance)aix(nomon,topas) redhat (LVM). Creation VG,LVs on AIX/HP-UX/Solaris/LINUX

Environment: Oracle 10g/9i/8i, HP-UX 11i, Manugistic,Peoplesoft HRMS, SQL Server 2000/2005, Windows, Unix, Sun Solaris, Toad, SQL, Java, J2EE, XML, Web Services.

Confidential, Bowling Green, KY

Oracle DBA

Responsibilities:

• Setup and configured 10g RAC on Win2003 /Redhat Linux /AIX 5.2(add/delete instances) with ASM and 10g Grid Control monitor.
• Created Schema (tables, Indexes, views, sequences, synonyms, roles, packages), grant roles to users.
• Installation of Oracle Forms/Reports 6i on Redhat for HSMS application and resolve all technical issues.
• Database recovery / crashes using hot /cold backups and dump/loads.
• Configured and implemented Physical Standby DB (DataGuard) for Oracle 10g RAC environment.
• Created/modified universes with Oracle backend and exported to repository.
• Reorganized existing database to standardize the placement of various databases related files.
• Managed logical/physical backups for these databases depending on the nature of database set up either full export, partial export or export of just the structure of schema objects.
• Using TCP/IP protocol configured SQL*Net files on server / client machines, and resolved client connectivity issues.
• Implemented & designed Oracle Portal 10gAS in 3 tier enterprise distributed architecture with SSO/DAS in secure DMZ tier with configuration of HTTPS/SSL and split the customer database (metadata) on different cluster environment for better performance, availability and scalability
• Installation and Up gradation of Sql Server 2000. Monitoring the DB Server health and tunning accordingly.
• Configured Oracle transparent gateway with Microsoft SQL Server2000.

Environment: Oracle 10g, BMC Patrol, Oracle 10g Portal, peoplesoft8.4,Windows 2003, Oracle 10g AS, Solaris2.6, Red Hat Linux, SQL Server2000, Mysql 4.x,Java, J2EE, Veritas NetBackup, EMC

Confidential

Oracle DBA

Responsibilities:

• Refreshing of Databases
• RMAN Backup and Recovery procedures with Lagato/VERITAS as MML
• Logical Backups (export/import) Tasks
• Applying Critical security patches
• Database Creation and Reorganization
• Creating Primary database structures altering according to the user requirements
• Modifying the database structures as necessary to accumulate application growth
• Responsible for Managing Database Files, schema objects, table spaces, objects and disk spaces.
• Maintenance of Development, Production, QA Test Databases
• RMAN backup and recovery procedures and conventional shell scripts
• Controlling and monitoring user access to database