SUMMARY:

• Over 7+ years of professional IT experience in Administration, Systems Design Development, Maintenance, Testing, Integration, documentation in high - availability environments such as Telecom & Finance Sectors.
• Expertise in leading the teams for maintenance of 24X7 high-availability applications.
• Expert in Architecture of Oracle Databases 11g, 10g, 9i, 8i with objectives of saving costs and time.
• Strong experience in supporting development, unit test, system test, Integration test, certification test, production databases under almost all flavors of UNIX (Sun Solaris, IBM AIX, HP UX Red Hat).
• Expertise in cloning using RMAN Duplicate DB and hot backups to create Test, QA, DEV Instances.
• Expertise in applying Oracle Database patches using Opatch Utility.
• Experience in Upgrading databases. (10g R2 to 11g, 10g R1 to 10gR2, 9i to 10gR1).
• Experience in configuring Oracle BI Discoverer 10.1.2.
• Experience in Integration of OID/SSO.
• Experience in Managing/working/converting RAC databases.
• Created the Migration Scripts for the migration from old system to new system.
• Oracle Cluster ware installed to provide infrastructure for RAC and configured 3 node Oracle 10g RAC with ASM.
• Load data from OLTP systems into data warehouse databases.
• Installed and configured the oracle10G RAC on RED HAT Linux AS4 and have migrated 8 databases in different platforms to same single centralized database server
• Expertise in Database Space Management, Memory Tuning and Application Tuning.
• Expertise in troubleshooting and performance tuning.
• Experience in implementing 10g Grid monitoring application to monitor the Oracle Applications and Database.
• Experience in creating and managing Standby database using Data guard.
• Expertise in Backup and Recovery activities using RMAN utilities.
• Worked with several Multi node and multi tier environments.
• Experience in implementing security policies to meet SOX Compliances.
• Excellent work experience in developing applications using ORACLE SQL Scripts, PL/SQL, Shell Programming, and PRO*C.
• Flexibility to work on on-call hours.
• Expertise in Oracle Data Guard, Cloning of Database.
• Involved in supporting the SOX teams by providing the necessary data and execute task for SOX compliance.
• Expert in configuration of 11gRAC, 10gRAC, 9iRAC on Linux and Solaris using ASM and RAW devices and Oracle CRS.
• Experience in using Golden Gate i
• Expertise in identifying and resolving issues related to Golden Gate.
• Expertise in Oracle GoldenGate, Veridata installation, configuration, troubleshooting GG issues.
• Experience in installing and configuring GoldenGate 9.5.
• Up gradation and Migration of Database from 10g to 11g and applying patches whenever required.
• Expert in configuration of Hardware Clusters Environment with HACMP, VCS, VCFS.
• Proven experience with mission critical databases high availability and disaster recovery environments configuration in 24*7 environments using 9i Data Guard, 10g data guard with real time apply.
• Extensive experience with AWR, ADDM, ASH STATSPACK, ORADEBUG, HANGANALYZE, PSTACK, TRUSS.
• Extensive experience with DBMS API’S and V$VIEWS, TOAD, Quest Spot Light, BMC Patrol and 10g Grid.
• Worked extensively with configuring database backups in RMAN environments using TSM, Netback up and Commvalut backup utilities.
• Excellent experience in OLTP/DSS database systems, implementing and managing large Oracle databases.
• Extensive experience with proactive monitoring the databases using 10g Grid Control Monitoring.
• Exposure to MS SQL Server 2000 Installation, Configuration, Maintenance, Backups & Restores, Security Management, DTS import/export, Performance Tuning.
• Strong knowledge and experience of managing Oracle 9i,10g and 11g RAC environments using the OEM Grid Control tools.
• In-depth knowledge of SQL (DDL, DML, and DCL), and PL/SQL and experience in writing stored procedures, packages, functions, and triggers.
• Expertise in Replication of Oracle Databases using Logical Standby and Streams and Shareplex.

TECHNICAL SKILLS:

Database Administration: Oracle 11g, Oracle 10g, Oracle 10 RAC, Oracle 9i, 9iRAC, Oracle 8i, Performance Tuning, Backup and Recovery using Cold, Hot, and RMAN and Other Utilities

Programming: PL/SQL, Pro*C, SQL*Plus, C, C++, Perl Scripting, Shell Scripting. Exposure to J2EE

Hardware: Digital DEC Alpha Server 8400, HP UX 10.2, SunOS 10, 9, DYNIX 4.0,Linux RHEL ES/AS 3, AIX5L Windows 9x/NT, UNIX, DOS

Tools: TOAD, PL/SQL Developer, BMC Patrol, Quest Spotlight, Netback up, TSM, Commvalut.

Domain Experience: Financial Services, Telecom.

EMPLOYMENT HISTORY:

Confidential, HOUSTON, TX

Sr Oracle Database Administrator

Responsibilities:

• Providing 24x7x365 support 10+ RAC clusters and 30+ single instances for prod/dev/test/dss databases.
• Part of a 7 member DBA team which was involved in the maintenance of the Oracle 9i/10g/11g database for the Production as well as the development environments.
• Setup and configured 3 node Oracle 10g RAC with ASM.
• Implemented Data Guard, Standby, and Oracle Streams technologies in mission critical systems and configured Switch over and Failovers with Physical standby database on Windows and Linux environments.
• Experience in implementing Unidirectional GOLDEN GATE, from Source to a Repository Database.
• Worked on installation of GOLDEN GATE 9.2 on Oracle Servers.
• Performed Initial load, extract, replicat, trial files and exporting data onto Repository Database using GOLDEN GATE tool.
• Upgrade/Migrated the production and development databases from 9i to 10g, 10g to 11g.
• Supported Real Application Cluster (RAC) on Oracle 10g using Automatic Storage Management (ASM).
• Actively involved in monitoring the lock processes, releasing locks in case of resource blockage and gathering statistics.
• Migrated Oracle 9i and 10g databases to 11gr2. Platforms include Windows, AIX and Solaris .
• Monitoring the table space growth and resizing the table space on 9i RAC environment.
• Backup and recover using RMAN. Cloning and refreshing the UAT and development databases using RMAN.
• Identify Top SQL that are consuming heavy resources and provide support to the development team in identifying SQL queries that are consuming high resources and interact with the development team to see if these queries can be fine tuned further.
• Tuned SQL queries using AUTOTRACE and EXPLAIN Plan.
• Implementation and configuration of OEM Grid, Oracle Management Server for maintenance and monitoring data.
• Performed Export/Import of Oracle 10g Databases.
• Design, configuration and maintenance of backup and recovery policies including RMAN backups.
• Responsible for working on database design and data requirement analysis using ERWIN data modeler and Toad for Data Analysts.
• Implemented Standby Database and Database Replication to realize database high availability. Created partitions for large table to improve performance.
• Database cloning using RMAN and hot backups.
• Oracle Cluster ware installed to provide infrastructure for RAC and configured 3 node Oracle 10g RAC with ASM.
• Extensively worked with ASMCMD for managing ASM environment.
• Performance issue tracking and solution making using Stats pack. Explain plan used to diagnose the long running queries, tuning applied if it required.
• Performed SQL tuning and assisted developers with coding PL/SQL.
• Assisted in planning and implementing data migration from Access 2K to SQL Server 7.
• Oracle Cluster ware installed to provide infrastructure for RAC and configured 3 node Oracle 10g RAC with ASM.
• Installed and implemented Oracle 10g and 11g databases on AIX 5L and performed Data Pump to move large amounts of data from one instance to another.
• Taking periodic backups of the database and the software using Cold, Hot and RMAN strategies.
• Configured DATA GUARD to provide high availability by implementing Physical stand by database and experience with Oracle 10g features: Streams, 10g Grid Control and Automatic Storage Management (ASM).
• Trouble shooting performance issues using Explain Plan and TKPROF and well versed with STATSPACK.
• Optimization and tuning SQL queries using TRACE FILE, TKPROF, EXPLAIN PLAN.
• Upgrade/Migrated the production and development databases from 9i to 10g, 9i to 11g, 10g to 11g.
• Configured DATA GUARD to provide high availability by implementing Physical stand by database and experience with Oracle 10g features: Streams, 10g Grid Control and Automatic Storage Management (ASM).
• Configure ASM and handling issues and suggesting feasible workarounds for ASM Metadata corruption.
• Used Oracle 10g AWR & ADDM to monitor database activities and performance tuning.
• Hot / Cold backups of the database through RMAN, Hot backups & BCV’s.
• Other duties include applying oracle database patches, creation of database users, monitoring, tuning, troubleshooting, and backup and recoveries, monitoring and optimizing database performance.
• OEM installation and configuration for monitoring and performance tuning.
• Used Oracle 10g AWR & ADDM to monitor database activities and performance tuning.

Environment: Oracle 9i,10g,11g, RHEL 4, 11g GRID, 10g RAC (3 node), AIX, Solaris 8.0, Windows 10gRAC, Oracle10g (10.2.0.2), Oracle 11g (11.1.0.7), PL/SQL, SQL Scripts, TOAD, RMAN, RAC, ASM, Data Guard, OEM.

Confidential, ILLINOIS, CHICAGO

Sr Oracle Database Administrator

Responsibilities:

• Managing multiple production, testing, QA and development Utility database instances.
• Providing 24x7x365 support 10+ RAC clusters and 30+ single instances for prod/dev/test/qa databases.
• Managing more than more 120 productions, test and development instances in 24*7 environment.
• Administering ORACLE Databases 10g (10.2.0.2), 11g (11.1.0.7) with over 2 TB in size.
• Upgrade database 10.1 to 10.2 and applied patchset 10.2.0.2 to multiple databases.
• Experience in managing databases on high availability environment using Sun Cluster.
• Oracle Cluster ware installed to provide infrastructure for RAC and configured 3 node Oracle 10g RAC with ASM.
• Upgraded Dev and Test instances to 11g (11.1.0.7).
• Developed RMAN scripts for database backup and recovery including hot and cold backup options for both RAC and stand alone instances.
• Monitoring the table space growth and resizing the table space on 9i RAC environment.
• Applied database patches using Opatch utility & building Clone instances for Development and Test teams.
• Proactively tuning JVM for performance issues, adding new JVMs.
• Worked on Distributed Database Configuration, Creation of Database links and Snapshots used Streams for 2 way replication of data.
• Expert in configuration of 11gRAC, 10gRAC, 9iRAC on Linux and Solaris using ASM and RAW devices and Oracle CRS
• Created shell scripts and scheduled them for monitoring Oracle Databases.
• Experienced in using 10g features Data pump, Flash-Back Recovery, AWR, ADDM, Grid Monitoring, Recycle Bin.
• Performance tuning and Monitoring using Grid Control database & managing instances using OEM.
• ORACLE TAR Management: Raised and monitored TAR s with Oracle Corporation for issue resolutions.
• Weekends on call support and Payroll support. & database backups using RMAN on tape and Disk.
• Custom code migrations to Test and PROD environments using PVCS.
• Working with Development, QA and other teams to support the related issues.
• Worked on Oracle Streams by managing Oracle environment, either by creating a new user with the appropriate privileges or grant these privileges to an existing user.
• Creating primary database storage structures (table spaces), altering, and modifying the database structure according to the company’s requirement as necessary, from information given by the application developers.
• Installation, Configure, setup of 10g RAC and add new nodes to RAC 10g Cluster to distribute the load
• Planning and implementing Backup and Recovery procedures (Hot Backups, and RMAN), scheduling daily backups and performed periodic recovery tests.
• Migrated Oracle 9i, 10g to 11g on AIX, Linux, windows, hp-ux.
• SQL tuning using SQL Trace and TKPROF, explain plan and SQL Analyze.
• Tuning init.ora parameters for optimal performance and scalability. Running ULTBSTAT & ESTAT to figure out where the bottleneck is and where most of the CPU time is going.
• Database Maintenance and clearing of deadlocks, cleaning of database logs, Re-indexing, Table space monitoring, database objects monitoring.
• Implemented Oracle RAC with Data Guard implementation for disaster recovery.
• Supported offshore setup of Oracle10g with Automatic Storage Management (ASM).
• Designing and developing packages in the database layer, stored procedures, functions and triggers.
• Querying V$ dynamic performance tables to figure out bottlenecks in throughput and Scalability.
• UNIX scripting for automation of statistics collection as well as for other processes.
• Worked with Very large Databases (VLDB) upto150 GB.
• Writing Shell Scripts to automate various routine jobs & designing the logical and physical database structure.
• Designing the security and database access strategies & cloning databases and partitioning tables.
• Performing backups and recoveries using RMAN/ conventional hot backups.
• SQL tuning using SQL Trace and TKPROF, explain plan and SQL Analyze.
• Configured Data guard to provide high availability by implementing Physical stand by database and experience with Oracle 10g features: Streams, 10g Grid Control and Automatic Storage Management (ASM).
• Creating and refreshing materialized views & performing SQL*loader jobs for data loading.
• Writing PL/SQL procedures for Extraction Transformation and Loading of data.
• Managing multiple production, testing, QA and development instances.
• Expertise in data archive and purge methodologies using partitioning.
• Administering ORACLE Databases 10g, 10g RAC & Upgrade database 10.1 to 10.2 and applied patchset 10.2.0.3 to multiple databases.
• Applied database patches using Opatch utility & worked on conversion from single node to 2 Node RAC database for SIT and UAT systems.
• Assisted in planning and implementing data migration from Access 2K to SQL Server 7
• Building Clone instances for SIT and UAT environments.
• ORACLE TAR Management: Raised and monitored TAR s with Oracle Corporation for issue resolutions.
• Performance tuning and Monitoring using Grid Control database.
• Created shell scripts and scheduled them for monitoring Oracle Applications and Databases.
• Weekends on call support & weekly hot back backup activities production, cold backup on Test/dev databases.
• Users and responsibilities Maintenance.
• Custom code migrations to Test and Prod are done using MKS tool based on development requests.
• Problem resolution repository is built in custom DBA ticketing tool.
• Working with Development, QA and other teams to support the related issues.

Environment: Solaris 10, 8, HP UX 11 and 10.20, Linux RHEL ES/AS 3, AIX, 8i, 9.2.0.2, 10gRAC, Oracle10g (10.2.0.2), Oracle 11g (11.1.0.7), Oracle BI Discoverer 10.1.2, PL/SQL, SQL Scripts, Shell Programming, TOAD.

Confidential, Elk Grove, CA

Sr Oracle Database Administrator

Responsibilities:

• Managing more than more 200 productions, test and development instances in 15 TB Environment.
• Administering ORACLE Databases 10g, 9i.
• Applications Patch management: Patch impact analysis, patch application and trouble shooting.
• Applied database patches using Opatch utility.
• Involved in a project, which analyzes and applies quarterly Security patches (CPU).
• Implemented Concurrent manager profiling across the 4 Node RAC to minimize the Interconnect traffic.
• 4th node has been added to existing 3 nodes RAC.
• Migration from Oracle applications to data in DB2/400, in addition to any Oracle server data
• Experienced with Data Guard implementation and Point in time Recovery.
• Involved in implementing Dashboard-based Monitoring solution by developing shell scripts and SQL scripts.
• ORACLE TAR Management: Raised and monitored TAR s with Oracle Corporation for issue resolutions.
• 24 x 7 technical support, 24 x 7 during quarter and month close and weekends on call support.
• Performance Tuning of Applications and Databases using precise tool, tkprof, explain plan.
• Generating trace files for problem resolution.
• Responsible for backup/recovery using RMAN utilities.
• Expert in using BITMAP, B-Tree Indexes, Composite indexes, Hash partitioning and Histograms.
• Responsible for setting-up and managing Standby database using Data guard for DR sites.
• Worked on managing and configuring Single Sign-on (SSO/OID) environment.
• Ad-Hoc Technical Requests: Ad-Hoc Queries - SOX/Audit/Security.
• User Maintenance (Creation, modification and deletions).
• Custom code migrations using Kintana tool to test and Prod environments.
• Experience in managing the migration of SQL Server 2000 databases to SQL Server 2005.
• Worked on user documentation like Instance strategy, Instance management, Problem manager, Setup document and Change management docs.
• Problem resolution repository, using Clarify solution linking utility has been created to reduce issue resolution timings.
• Working with Development, QA and other teams to support the related issues.
• Installation, Configuration and Administration of Oracle 10g/9i databases on various Operating Systems.
• Creating primary database storage structures (table spaces), altering, and modifying the database structure according to the company’s requirement as necessary, from information given by the application developers.
• Creating and managing users, roles and profiles, auditing and monitoring databases and user access.
• Planning and implementing Backup strategy for the databases using RMAN, Scripting backups, once in two weeks on the application database.
• Planning and implementing Backup and Recovery procedures (Hot Backups, and RMAN), scheduling daily backups and performed periodic recovery tests.
• Allocated system storage and planned for future storage requirement for the database.
• Created primary database storage structure for developers to develop and test the Application.
• Created primary database objects.
• Created reverse engineering scripts, scripts for table space usage, table sizes and SGA Usage.
• Documenting each and every change in the database.
• Used SQL-Backtrack and NT backup manager for backups.
• Data loading using Oracle SQL Loader, developing SQL Loader scripts to load global data, and fine tuned SQL Loader performance using Direct-load mechanism.
• Estimating the space requirements for database growth for next 12 months and availability of hardware to support the processes.
• Developing, Implementing and administering database policies and procedures.

Environment: SUN Solaris 5.9, AIX 5, 4.33 Linux RHEL ES/AS 3, Oracle10g, Oracle 9i, Oracle 8i,Database, AD Utilities, PL/SQL, SQL Scripts, Shell Programming, Clarify, Mercury Test Director, Kintana

Confidential

Jr Oracle Database Administrator

Responsibilities:

• Managing Users, roles and privileges, space management Creating storage structures, Performance Tuning
• Responsible for maintaining multiple instances and a production instance.
• Scheduled Backup using RMAN.
• Checking for Invalids and compiling them.
• Logging & Monitoring TAR with Oracle Support Service & maintaining issue resolution documentation.
• Configuring client machine to access Oracle Instance.
• Training of Client users & Maintained good documentation of DB.
• Monitoring Applications proactively and scheduled shell scripts.
• Actively involved in gathering requirements, system design, development, and application support.
• Worked as a Developer to implement the Customer Data mart creation of Qwest residential customers for Marketing Supporting systems.
• Scripts (PL/SQL, SQL, PRO*C, Shell) were developed to extract the customer data from Corporate Data Warehouse and loaded into the Customer Data Mart for MDSS.
• Performance tuning was done to improve the performance of the queries using EXPLAINPLAN. Queries performance was improved by creating new Indexes, forcing indexes, parallel processing, and modifying Where Clauses, etc.
• Re-organization of Table spaces and Application and Database Performance tuning
• Troubleshooting DB related issues and providing scripts for taking regular backups.
• Performed day-to-day database administration and ensured integrity, security, and availability of the database.
• Managed Instance and Schema objects
• User Maintenance (Creation, modification and deletions).
• Storage management, sizing the database objects, monitoring file systems, and table space growth.
• Performance tuning of the queries using Explain Plan, tkprof.
• Purge strategy was defined and implemented.
• Standby Database has been setup and monitoring using Data Guard.
• Provided On Call DBA support.
• Alerts setup for Database monitoring.
• Planned and implemented Backup and Recovery strategies.
• Taking physical backups such as Hot backups regularly using RMAN Utilities.
• Provided Ad-Hoc reports from the Data Warehouse for management.
• Worked with Unix Core and storage teams for any issues related to OS level or storage issues.
• Developed user documentation for supporting tools and database and created problem resolution repository.

Environment: Solaris 2.6, RHEL ES/AS 2.1, Shell Programming, Oracle 9i, PL/SQL, NetCool Reporter, Remedy, Oracle 8i, 9i

Confidential

Jr Oracle Database Administrator

Responsibilities:

• Provided administrative supports for PEOPLESOFT 7.5 and 8 with Oracle running on HP.
• Upgraded the application from 7.5 to 8.0. Provided migrations of SQL and SQR patches.
• Setup SQL trace, PeopleCode trace, and Application Engine trace. Monitored and tuned AppSever performance.
• Identified, resolved, or provided recommendations to other different kinds of the performance problems ranging from Database performance problems to I/O hardware performance problems.
• The tools used mainly are Savant, TKPROF, Explain Plan, and some my own scripts. The tool called SQL Expert from Leccotech for SQL statement tuning was also used.
• Upgraded People Tools for Dev., Test, and Production environments.
• Created domains, configured AppServer, setup Process Scheduler, brought up Web Server, updated report repository and changed passwords through Application Design, etc. for PEOPLESOFT 7.5 and 8.
• Provided Oracle database administrative supports for other different applications, NUCLEUS, CONTERPARTY, CONTRACT, and DOCUMENT MANAGEMENT SYSTEM.
• Created new databases and users, setup RMAN backups, Export, and other monitoring scripts.
• Provided 24x7 on call production support.

Environment: Oracle 8.1.7, Solaris 2.8, Sun E4500, ERWin 4.0, Oracle DBA Studio.