SUMMARY:

• Database professional with more than ten years industry experience in Database Administration Production/Development-OLTP environments.
• As an Oracle Certified DBA for Oracle 10g, experienced in the administration of Oracle 11g/10g/9i/8i/8/7.x on both Unix and Windows NT platforms
• Expertise in logical and physical data architecture using Erwin.
• Extensive experience in analysis, design, maintenance and documentation of High-level Design databases for Q A plan Integration test and Stress test and expertise in transition/implementation of new applications.
• Hands on experience in Installing, Configuring and Maintaining 11gR3/10g Real Application Clusters RAC 2 node clusters with Automatic Storage Management ASM
• Extensively worked on tuning the databases like memory tuning for database buffer cache, shared pool and log buffer, identifying and resolving contention for system resources, latch contention, data block contention free list, init trans rollback segment header and undo blocks, enqueues, identifying hot spots for I/O contention and suggesting remedies for avoiding excessive I/O wait using Explain Plan, Statspack, SQL Trace, TKprof.
• Experience in Database Patching, predicting growth trends and Capacity Planning.
• Migrated Databases from lower to higher versions and Cross-platform data migrations.
• Experience with SOX audit implementation.
• Extensive experience with very large databases over 15 Terabytes
• Experienced in Shell Scripts Borne Shell, Korn Shell, and C Shell .
• Experience on duplicating databases using RMAN.
• Extensive experience in installing and managing Oracle Grid Control.
• Experience on SQL SERVER administration.
• Strong understanding of OS management, networking, trouble shooting, hardware compatibility and system Administration on Windows UNIX
• Provided production database administration support for a 24x7 for Fortune 500 Company.
• Implemented successful High Availability solutions viz. Oracle Dataguard, RAC, Oracle Advance Replication, Golden Gate and Quest Shareplex.
• Excellent communication and interpersonal skills together with a positive approach to undertaking challenges.

TECHNICAL SKILLS:

• Hardware: SUN M5000, SUN Fire 880, HP-9000, IBM RS-6000, Dell Power Edge 4400/2650/2550.
• EMC storage, VERITAS Volume Manager
• Operating Systems: SOLARIS 10, HP-UX 10.2, AIX 4.3.4/5.2, Red hat Linux 6.2/7.1, Windows
• RDBMS: ORACLE 11gR3 RAC/10g/9i/8i, Grid, ASM, MS-SQL Server 2000
• Software: ORACLE PORTAL, PL/SQL, DEVELOPER 2000, C, SQL, HTML, UNIX Shell Script, Web Sphere.
• Tools: OEM, SQL NAVIGATOR, PL/SQL, RMAN, Statspack, Data Guard, Advanced Replication, SQL LOADER, SQL NET, Diagnostic Pack, Explain Plan, Tkprof, Toad
• Backup Tools: Rman, ARC serve, Veritas, Legato.
• Case Tools: SILVERRUN, Erwin
• Other Tools: MS Visual Source Safe VSS Version Manager , PVCS, CVS, PR-Tracker, Autosys, OEM
• Oracle HA: Data Guard, Oracle Advanced Replication, Shareplex 7.2 , Golden Gate, RAC Real Application Clusters

CERTIFICATIONS:

Oracle Certified Database Administrator OCP Microsoft Certified Product Specialist MCP EXPERIENCE

Confidential

Sr. Oracle DBA/Team Lead

• Oracle database administrator role to oversee all aspects of the database, including database architecture design through implementation, administration, monitoring, tuning, backup, migration and support.
• Provided support for 40 Oracle instances running on Oracle 11.2.0.2.
• Managing Customer Care Reporting database ranging to 15 Terabyte.
• Migrated production Reporting Database from Oracle 10.2.0.5 to 11gR2 with Shareplex Multi-master Replication.
• Extensively involved in Data Center Migration and Disaster Recovery plans and Implementation.
• Migration includes Cross platform migration, and upgrade HP- UX to Sun Solaris .
• Lead the Tech refresh project successfully migrating CCES application from one database into multiple databases to provide better performance and manageability with near zero downtime and without any post migration issues in a planned timeframe.
• Supported the RAC project migrating single node customer care database into 5-node RAC database for better availability.
• Worked on IP address changes on RAC and non-rac databases including shareplex VIP's.
• Handle performance related issues during Oracle Upgrade using home grown scripts comparing 10g and 11g same sql comparison base on Elapsed time, CPU time and executions.
• Created Test cases using Shareplex multimaster replication between 10g and 11g to ensure integrity of data.
• Managed database on Cluster environment with failover and Switchover logic using using Veritas Cluster Services VCS
• Implemented Block change tracking BCT Incremental backups and Incremental merge backups for faster completion of backup and recovery of Terabyte Databases.
• Worked extensively on tablespace consolidations and remaps.
• Worked on Performance issues related to statistics on different datacenters.
• Attended technical meeting during design phase of features going in particular deployment and provided SQL enhancement recommendations. Supported monthly application releases.
• Perform Data Warehouse operations like loading data into reporting database using SQL Loader into temporary table, Exchange table with original table, Rebuilt Indexes and Gather statistics after loading data.
• Set up separate profiles for database and application accounts for SOX and non-SOX related databases.
• Setup Grid for monitoring all databases in a centralized server.
• OEM used for tuning the databases.
• Experience with ETL tool Dmexpress to load daily data into tables using CDC method.
• Experience in installation, configuration and managing Oracle Grid Control.
• Played active role in Database consolidation to avoid data redundancy and ease maintenance and database upgrade tasks.
• Lead the efforts of conducting/maintain CPU/PSU and back port patches across Enterprise systems.
• Pioneer in design/preparation and implementation of Data copy thru True copy for Data center migration.
• Converted non partition table to partition tables with local indexes for better table management and performance.
• Created procedure to add interval partitions in advance and copied the stats to new partitions using dbms stats.
• Design a new data archival mechanism for Verizon Wireless to keep data for seven years. Wrote a stored procedure which takes inputs for archival month duration of different tables and it generates a flat file of the data.
• Controlling and monitoring user access to the database and maintaining system security. Manage system resources by creating default profile and specific user profiles.
• Work closely with architecture/hardware team on Firewall rules.
• Involved and implemented for Quartley DR solutions using Data Guard and flash back technologies.
• Monitored the Shareplex and resolved the issues related to Shareplex. Co-ordinate with other teams for releases of shareplex.
• Conduct Shareplex/Oracle High Availability trainings to the Enterprise team members.
• Communicate status reports and issues to the Manager on timely basis.

ENVIRONMENT: ORACLE 11gR3 Real Application Cluster 9I/10g/11gR2 Enterprise Edition, Sun Solaris, Veritas storage foundation, DMExpress, Oracle Grid Control, Toad, SQL Navigator, Web Logic, Golden Gate, Shareplex

Confidential

Sr. Oracle DBA/Team Lead

• Analyzed existing environment from SPOF single point of failure and provided architectural alternatives for system redundancy and performance to host 24x7 mission-critical applications.
• Implemented HA systems Dataguard, RAC, Oracle Replication and Quest Shareplex .
• Monitoring of the replication process using Quest Shareplex, Advanced Replication and Data Guard between Production Databases and Disaster Recovery Database.
• Performed Unit Testing, load Testing, stress Testing and tuned database response time.
• Performed Corporate Disaster Test for Site failure.
• Analyzed statspack reports for optimization of Database performance periodically.
• Co-ordinated the migration of schema changes from Test to Pre-Production, then to Production.
• Developed and executed new backup, recovery and archiving policies and procedures. Tested procedures completely and ensured DBA staff is fully trained in recovery operation.
• Implementation of Oracle Management server for administrating the enterprise wide databases.
• Performed Shareplex upgrade from 4.5 to 5.3 on various systems.

ENVIRONMENT: ORACLE 9I v9.2.0.5 /8.1.6 IBM AIX v5.2, Oracle 10g 10.1.2 , SQL Plus, PL/SQL, Toad, SQL Navigator, WebLogic, VSS, Autosys.

Confidential

Sr. Oracle DBA/Team Lead

• The client is a hosting company. It publishes over 50 business publications, stages over 50 trade shows and conferences and operates more than 200 business-to-business electronic products.
• Managed Oracle Multimaster Replication databases for production and development.
• Supported Oracle partition and materialized views snapshots on multimaster replication environment.
• Implemented physical Oracle Data Guard for 500 Gig database.
• Work closely with branch managers/supervisors in maintaining uninterrupted daily operations.
• Wrote appropriate scripts for changes to the schema, stored procedures, and triggers.
• Developed database monitoring shell scripts thru cron jobs.
• Installed and Configured Oracle OMS server for monitoring of Oracle Database.
• Reviewed Reporting Software's from vendors and submitted recommendations to management.
• Accomplished adding new features into the project on time under high-pressure environment.
• Installed and configured Oracle 10gAS for Oracle Portal 10g environment.
• Configured and implemented RMAN utility for backups and recovery.
• Conducted database monitoring, debugging, troubleshooting, performance tuning and other database administrator duties

• Rebuild intermedia indexes TEXT indexes periodically for high transaction tables to minimize fragmentation.

• Upgraded, patch and configured Oracle 9i database.

ENVIRONMENT: ORACLE 9I v9.2.0.5 /8.1.7.4, Oracle Webdb 3.0, Sun Solaris v5.8/v9.0, Oracle 10g 10.1.2.0 AS Oracle Portal, SQL Plus, PL/SQL, Toad 7.6, Perl, WebSphere, CVS.

Confidential

Sr. Oracle DBA/Developer/System Administrator

Worked for a major insurance annuity client:

• Confidential for the set up of both deferred and payout products by developing functionality required to major insurance company's payout business into the deferred system. This system is based on distributing computing architecture with Java and C libraries communicating via stored procedures in Oracle database through BAPI a C abstraction and corba implementation layer. The user interface was developed in JSP and HTML.
• Installed, created and upgraded Oracle databases as needed for development and QA effort. Worked with Application team to design and implement common database objects and resources tables, views, packages, stored procedures and triggers etc. .
• Extracted the delta between the different production/development Database schemas through SQL, Toad and shell script and then applying the changes to the combined system.
• Created tables, constraints, indexes, views, sequences and synonyms using various normalization techniques and database design rules.
• Configured database control parameters for database DB Block Size, DB Cache Size, Open Cursors, Query Rewrite Enabled, Enqueue Resources, Tuning of SGA viz. Shared Pool by Tuning of Library Cache, Tuning of OS by Reducing Paging/Swapping and Tuning memory.
• Performed application tuning during the stress test.
• Performed database tuning using Oracle Statspack, DBA Studio, Spotlight and TOAD.
• Worked with development team for migrating code from Development/Test and Test/Production.
• Worked on Database enhancements depending on the client's functionality.
• Scheduled backups, schema analyze jobs using AT command.
• Cached the Packages, Stored Procedures and Functions in SGA using DBMS Application supplied Stored Procedures.
• Maintained all the Oracle databases QA/Staging and production and helped developers in trouble shooting and resolving all issues related to SQL, PL/SQL and WebSphere. Mentored the developers and helped them resolving, tuning and programming issues.
• Managed VSS Version Control to manage the source code and new releases.

ENVIRONMENT: ORACLE 8.1.7, Windows 95/2000, Dell Power Edge 2650/2550, PL/SQL, Toad, Veritas, Pr tracker, MKS-Toolkit, WebSphere, VSS and PVCS.

Confidential

Senior Oracle DBA/Unix Administrator

• Pace is a representative company for 10 producers of asbestos or asbestos related products to settle the meritorious asbestos claims on a speedy and cost effective basis. It serves as an interface between the company and the injured party.
• Installed, configured and supported numerous databases including: Oracle8i on both Linux and Windows 2000/NT 4.0 platforms and Oracle 7.3.4. database on VMS 7.1 system.
• Periodical cloning of production Database and rollover to development and test environment.
• Tuned database for better performance and modified OS Kernel initialization parameters based on the database size and nature of the application such as shared memory segments, semaphores
• Reverse engineered existing database into object models using Erwin Case tool.
• Various DBA activities like performance tuning and day-to-day database monitoring activities.
• Installed Red Hat Linux 6.2/7.1 for new pace testing sever.
• Performed UNIX Administration for Linux 6.2/7.1 running on Dell Power Edge 4400, including kernel configuration, file system partitioning and troubleshooting on Linux.

ENVIRONMENT: ORACLE 8.1.7/8.1.6/7.3.4, Developer 2000/6i, Oracle Forms 4.5/6.0, Erwin, Redhat Linux 6.2/7.1, Open VMS 7.1, Windows 95/2000, PL/SQL, SQL Navigator, ARCSERV.

Confidential

Oracle DBA/Unix Administrator

• Implemented the standard Oracle Environment SOE for CSI that includes consistent set of scripts and directory structure across all hosts in the Oracle environment.
• Installed Oracle on Compaq ES40/Production, IBM RS6000/test and on Compaq DS20/development.
• Was responsible for migration of multiple Oracle 7.3.4 Instances from AIX 4.3.4 to Oracle 8i on Compaq Tru64 UNIX. Created/Migrated database objects like tables, indexes, procedures and triggers.
• Created tablespaces and schema objects with appropriate storage parameters.
• Used SQL Trace utility to analyze and tune the poor SQL Statements.
• Continuously monitored Oracle buffers and identified bottlenecks hindering the database.
• Interfaced with Oracle Corporation with respect to support licensing, and bug reporting.
• Developed Database monitoring scripts for cron jobs.
• Re-organized tablespace contents online, in order to reduce fragmentation.
• Implemented Oracle Recovery Manager RMAN
• Performed UNIX Administration for Compaq ES40 system running Compaq Tru64 Unix v5.1 operating system.

ENVIRONMENT: ORACLE 8.1.6/7.3.4, Compaq ES40, IBM-RS 6000, Compaq Tru64 v5.1, AIX 4.3.4, PL/SQL, Toad, OEM.

Confidential

Database Administrator/Unix and Windows NT Administrator

• Was responsible for all aspects of database support and administration.
• Installed Oracle Software version 7.3.4, 8.0.5 and related patches.
• Performed Database modeling that included calculation of object sizes, Tablespaces and database sizes using Silverrun CASE.
• Statistics gathering using UTLBSTAT/UTLESTAT to pro actively tune memory, I/O, sort areas, latch and rollback contention.
• Wrote Standard documentation for database environment, security guidelines, object-naming standards, data synchronization and backup/recovery procedures.
• Created scripts to automate data processing, data validation, loading and updating data using SQL Loader and database triggers.
• Regularly maintain Oracle's functional mechanism such as RBS, Redo logs, sort segments, tables, indexes and object fragmentation.
• Developed shell scripts to automate database cold and hot backup.
• Provided 24-hour support to operations and the development community to ensure that daily production business requirements were met.

ENVIRONMENT: Oracle 8.0.5/7.3.4, HP-9000, Windows NT 4.0, PL/SQL, ERwin, SILVERRUN, Visual Basic.

Confidential

Database Administrator

• Was responsible for Oracle databases Administration on multiple SUN and NT environment
• Upgraded Databases to newer Oracle Releases and migrated data.
• Created and configured multiple instances for test, development and production environments.
• Monitored and tuned the database for optimal database performance using Oracle Enterprise Manager, SQL Trace, and re-organizing fragmented tables and indexes periodically.
• Tuned for maximum performance for various nightly batch jobs drastically.
• Successfully performed full and point in time database recovery whenever required.
• Performed daily administrative tasks on Solaris/Windows NT 3.51 servers.

ENVIRONMENT: SUN SPARC ULTRA II, SOLARIS 2.51, WINDOWS NT 3.51, ORACLE 7.X

Confidential

Programmer/Database Administrator/Desktop Engineer

• Designed, developed and implemented Bank Customer Information system to perform basic banking operations using PRO C, Forms 3.0, Reportwriter 1.0 on Oracle 6.X.
• Involved in each and every phase of system design, testing and tuning.
• Developed data and application security standards. Designed and implemented change control procedures.
• Performed software analysis, software installation, software customization and programming, software performance monitoring and software upgrades, for custom build applications.
• Provided daily support to in-house end users for all software, MS-Exchange Mail, hardware and network connectivity issues 2nd and 3rd level support .
• Performed all hardware and software upgrades on HP and Compaq DeskPro PC's.

PERSONAL:

• Self-motivated, self-starter and a fast learner.
• Good analytical and problem solving skills.
• Capable of handling multiple responsibilities independently.
• Success oriented, dedicated with positive attitude.
• Good communication skills, believe in Teamwork, with leadership qualities.
• Highly organized with attention to detail.