SUMMARY:

• Over 17 Years of IT experience and 15 years as an Oracle DBA in 7.x/8.0/8i/9i/10g/11g/12c, currently working as a Senior Manager.
• Deployed/Implemented and currently maintaining RAC Cluster databases with ASM storage on Redhat Linux environments for a variety of tier - 1 applications.
• Coordinator for various integration, production and development projects on site.
• Project Management Experience: Database Management Proposal Writing, Completing of DBA Part in the proposal. Preparing weightage models for resource planning
• Strong analytical skills, excellent ability to debug and resolve technical problems in complex systems. Able to learn new technologies and business terminologies quickly.
• Highly experienced in setting up Zero Down time solutions using Goldengate to perform upgrades and Migrations
• Experience working and implementing database solutions with Oracle FS1,XFS, ACFS,3par,EMC-Vmax,Clarion,Hitachi storage technologies.
• Experience in Database Installation, Creation, Upgrade, Applying Patches, Cross platform database Migrations and supporting physical standby databases.
• Planning/Implementation of Backup and Recovery plan for 24X7 environment.
• Expertise in various oracle RMAN Backup and Recovery scenarios
• Database Performance Tuning: SQL*Trace, TK *Prof, Explain Plan, Statspack and by 13C grid control (SQL Tuning advisor, ADDM,AWR)
• A good hands on managing very Large Databases (VLDB) with Table/Index Partitioning and Database reorganization.
• Database Maintenance operation: Database Analyzing, Index Rebuilding Table Reorganization, Veritas Node failover
• Oracle Utilities & Tools: Exp/imp/SQL*Loader, OEM, Diagcollection,OSWather
• Experience in Database Security, Role Management, and Auditing using Audit Trail and Complex Triggers/Procedures and Vault.
• Setup VDP column/PII data masking / obfuscation
• Hands on in Unix Shell Scripting using different types of Shell (csh/ksh/bash)
• Exposure to SQL server & MYSQL database administration which is my secondary skill
• Implement and Maintain DELPHIX to refresh production to non-production dataabses
• Install, configure, maintain, Tune Golden Gate replication
• Create, modify, manage, archive, purge activities on database objects
• Administration of transaction processing applications
• Have handled production databases of over 100 TB in a 24*7 environment.
• Configuration of Standby database, Database Replication etc...
• Advance Queuing, Oracle Streams & CDC implementation, tuning and administration .
• DB Migration from 9i to 10 g, 10g to 11g and 11G to 12c
• Have Supported Multiple Clients on Implementation and Database Design.
• Exposure not restricted to Retail, Banking, Telecommunication, Insurance, and Manufacturing domains.
• MCA (Master of Computer Applications) from University of Madras, Chennai, India in April 2000.
• B.Sc (Computer Science) from Barathidasan University,Thanjavore, India in Apr 1996
• Oracle Certified Professional.
• Oracle Certified Associate.

TECHNICAL SKILLS:

Operating Systems: Windows NT, Windows 2000, DOS, Sun Solaris & SCO - Unix, Red Hat Linux, AIX,zlinux

Os Utilities: Unix Shell Programming, Awk programming, Dos Batch Programming.

Front-End Tools & Language: SQL Developer, SQL/PLSQL, Visual Basic(System Programming), Low level Pro*c, C, C++, PascalTOAD, DB-Design, DB Artisan, Fact broker (BI Tool).

Database Administration: Oracle 7.x, 8.x, 9.x, 10G, 11G SQL Server 7.0, 2000

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Oracle DBA Lead

Responsibilities:

• DBA release management & interfacing between Business owners & the DBA’s for major / minor releases.
• Reviewing overall physical database structures for data integrity, performance quality, recoverability, maintenance, and space requirement considerations including capacity planning & trending.
• Piloted, Designed and lead the Database upgrade/migration project across the landscape from legacy versions to the newest 11gr2 and also from older servers to the new servers giving extreme performance to business users and taking advantage of the new features.
• Planned and Migrated all the databases from datacenter to new datacenter
• Database Replication using Hot/Cold Backups, RMAN and 11g Active Database Duplication.
• Reviewing the critical Database list periodically and ensuring heightened Administration, Monitoring with periodic Health checks.
• Recovery of Database (Recovering from Media Failure, Recovering tables dropped, Recoveries from Block Corruptions).
• Lead the team on converting the database backup strategy from the legacy hot backups/exports to the Oracle standard and best practiced RMAN backups using EMC Data Domain storage & S3 CLOUD working along with the Backup & Storage team.
• Troubleshooting errors that occurs one daily basis and resolving problems quickly and efficiently and giving suggestions to developers when they are required for tuning the code to maximize performance of the database.
• Initiated and designed the process of applying the Quarterly CPU patches across the landscape fixing the database bugs.
• Used OEM extensively and set up Rules for alert notification and schedule RMAN backups with Failure notification.
• Involved in OEM alert paging set up for DBAs
• Worked on Automated reports from OEM for any open alerts for the targets / Target availability
• Good at tuning Top/Bad SQL’s using SQL Profiling by creating them using SQLT and implementing them.
• Performing periodic Database refreshes and specific process-bound refreshes.
• Trouble shooting the daily Production/Development/Test environment problems.
• Performing copy backs and system builds during various Test cycles (UAT,SIT,Integration) with the largest system size being 40 Tb using RMAN.
• Writing Linux/Unix Shell scripts, RMAN scripts etc for backups, Log/Trace files space maintenance.
• Communicating complex technical information to Business / Application owners in a concise and articulate manner. Helping audit teams with data collection related to database SOX compliance. E.g. User privileges, profiles, passwords.
• Regularly meeting Application teams, business owners to discuss their future requirements, DB capacity forecast & DB design changes.

Environment: Oracle10g, 11G SQL Server 2000, J2EE (EJB 2.0, JSP, XML), Oracle Sun Solaris 2.8, Linux Red hat, Windows 2000, IBM AIX, HP9000/RS6000, HP-UX10.00, Exadata

Confidential, New York

Sr. Oracle DBA

Responsibilities:

• ASM File System Maintenance
• Backup using RMAN
• Maintaining Cluster Databases
• Performed DB Migration from 10G to 11G
• Awk, Shell Scripting
• Interact with Hardware Support Engineer, Internal Software Engineers & Clients
• Database design, logical-physical design conversion, & instance tuning.
• Rebuild Index to rectify segment fragmentation.
• Install oracle and apply patches to upgrade oracle
• Monitor physical and logical backup
• Recovery of lost objects and datafiles
• Database design for new projects.
• Created installation scripts in Unix
• Tuning SQL Query Optimization
• Created & managing Replication & Standby Databases.
• Implement and manage Oracle Fine Grained Auditing
• Migration from SQL Server to Oracle.
• Datawarehouse.
• Also managed Oracle 9i Application Server.
• Managing SQL server 2000.

Environment: Oracle10g, 11G SQL Server 2000, J2EE (EJB 2.0, JSP, XML), Oracle Sun Solaris 2.8, Linux Red hat, Windows 2000, IBM AIX, HP9000/RS6000, HP-UX10.00

Confidential, New York, NY

Sr. Oracle DBA

Responsibilities:

• File System Maintenance
• Backup using RMAN
• Backup Monitoring
• Awk, Shell Scripting
• Interact with Hardware Support Engineer, Internal Software Engineers & Clients
• Database design, logical-physical design conversion, & instance tuning.
• Rebuild Index to rectify segment fragmentation.
• Install oracle and apply patches to upgrade oracle
• Monitor physical and logical backup
• Recovery of lost objects and datafiles
• Database design for new projects.
• Migration from Clarify CRM to in-house CRM.
• Created installation scripts in Unix
• Tuning SQL Query Optimization
• Created & managing Replication & Standby Databases.
• Implement and manage Oracle Fine Grained Auditing
• Migration from SQL Server to Oracle.
• Datawarehouse.
• Also managed Oracle 9i Application Server.

Environment: Oracle8i, 9i & 10g, SQL Server 7.0, 2000, J2EE (EJB 2.0, JSP, XML), Oracle

9i Application Server, Sun Solaris 2.8, Windows 2000

Confidential

Database Administrator

Responsibilities:

• File System Maintenance
• Backup using RMAN
• Backup Monitoring
• Awk, Shell Scripting
• Interact with Hardware Support Engineer
• Database design, logical-physical design conversion, sql & instance tuning.
• Rebuild Index to rectify segment fragmentation.
• Install oracle and apply patches to upgrade oracle
• Net 8 - Configuring network files
• Monitor physical and logical backup
• Recovery of lost objects and datafiles
• Implement and manage Database Audits.

Environment: Oracle9i & Oracle8i, Java, JSP, Apache, Tomcat, Solaris 2.7, Windows 2000Linux

Confidential

Database Administrator

Responsibilities:

• Maintaining all the objects of the database.
• Migrated from SQLserver2000 to Oracle9i
• Logical-physical design conversion, SQL & instance tuning.
• Rebuild Index to rectify segment fragmentation.
• Automatic Scheduling of logical backup
• Recovery of lost objects and data files.
• Monitoring the database growth, Re-Organization of Tables.
• Tuning SQL Query Optimization

Environment: VB, Oracle Application Server, Oracle8i & SQL Server 2000, Windows 2000

Confidential

Database Administrator

Responsibilities:

• File System Maintenance
• Awk, Shell Scripting
• Interact with Hardware Support Engineer
• Maintaining all the objects of the database.
• Prepared HLD and LLD
• Created Materialized Views
• Database design, logical-physical design conversion, sql & instance tuning.
• Rebuild Index to rectify segment fragmentation.
• Install oracle and apply patches to upgrade oracle
• Monitor physical and logical backup
• Monitoring the database for CPU utilization, Blocking Locks and changing priority or killing unwanted user processes.
• Monitoring the database growth, Re-Organization of Tables.

Environment: JAVA, JSP, Weblogic, Tomcat, Oracle8i, Solaris, Windows NT

Confidential

Programmer

Responsibilities:

• Team coordination.
• Involved in design of application and writing Server - side programs which are responsible for retrieving/inserting data from / to ORACLE database.
• Involved in coding and implementation.
• Testing.

Environment: Pentium 200MMX, Windows NT4.0, VB, SQL, PL/SQL