SUMMARY:

• 13+ years of experience in Oracle Database Administration including 11+ years in 10g,11gRAC and5+years of experience into engineered systems like Exadata, ODA.
• Oracle Certified Professionals in oracle 11g.
• More than 12 years of experience into Production support.
• Migration experience of legacy databases to DBaaS environment.
• Experience in upgrades of clustered and non clustered database from 10g to 11g R2.
• Exposure to Goldengate and sharplex replication technologies.
• Experience in planning migration of windows database to ODA (Oracle Database Appliance).
• Strong installation experience of oracle 9i,10g,11g R2 on Operating systems like Windows,Red Hat, AIX.
• Experience in installing Oracle 10g, 11g R2 Real Application clusters on Linux, AIX, Solaris, administering,troubleshooting, managing clusterware.
• Experience of handling very large Databases like 47 TB.
• Experience various performance tuning aspects like Statement tuning, instance tuning. RAC database tuning, slowperformance etc.
• Experience in using various new features of 10g, 11g R2 like Automatic Storage management(ASM), AWR reportsgeneration and review and recommendations.
• Experience in OEM 10g, 11g and 12c grid control agent installation, monitoring, configuring targets.
• Experience in contacting Oracle support, reviewing TAR, following up TAR, patching database.
• Strong communication skills in handling clients, users, other support organizations.
• Knowledge of Oracle Application 11i.
• Experience in defining strategies for implementing RMAN backups using TSM, Veritas, new functionality,enhancements, non ASM file system migration to ASM storage.
• Experience in designing Disaster Recovery strategy and implementing 10g, 11g R2 RAC dataguard on AIX Solaris,Linux environments.
• Experience in troubleshooting CRS, Database, Performance issues.
• Experience in handing onsite - offshore model for different clients.
• Experience in planning of best practices implementation for ASM, RAC, Dataguard, Backup & recovery in variousenvironments and review time to time to enhance new features into existing environments.
• Experience in Veritas Active-passive cluster configuration from oracle perspective.

TECHNICAL SKILLS:

PROGRMMING LANGUAGES: C, C++,Java1.2, VB6.0,VC++.

OPERATING SYSTEMS: SCO-Unix, Linux, AIX, Solaris.

DBMS: Foxpro, Access.

RDBMS: Oracle 8,8i,9i,10g,10g RAC, 11g, 11gR2 RAC

Engineered systems: Exadata, ODA (Oracle database appliance)

SOFTWARE ENGINEERING: Project Management, Requirement Analysis, Software Development Life Cycle, Software Configuration, Software Testing, Software Quality Assurance

PROFESSIONAL EXPERIENCE:

Confidential

Manager

Responsibilities:

• Managing more than g, 11g RAC production/Dev/QA clusters, Exadata and ODA databases on variousplatforms like Linux, Solaris.
• Handled Product End of Life Cycle for Oracle databases, planning, coordinating, implementing Oracle upgrades or migrations based on requirement.
• Testing DBaaS environment for different infrastructure release within Confidential realms like migration (RMAN, export-import), database provisioning, converting to RAC, Implementing Data-guard, compliance etc.
• Providing L3 support to support team on various issues like performance, backup-recovery, provisioning etc.
• Handling support for highly volatile Autosys application, periodic check of Performance in legacy/DBaaS environment,working closely with application team for L2-L3 escalated issues related to databases.
• Active member of Migration project to migrate legacy databases to DBaaS environment using different methods like RMAN clone, export-import, Transportable tablespaces etc.
• Experience into Data center migration projects.
• Testing Golden Gate upgrades from version 8 to 11.
• Working knowledge Commvault Simpana backup solution for Oracle.

Confidential

Sr. Consultant

Responsibilities:

• Managing more than g, 11g RAC production/Dev/QA clusters, Exadata and ODA databases on variousplatforms like Linux, Solaris, AIX.
• Implementing upgrade strategies for RAC and Non RAC databases.
• Preparing and performing upgrade for RAC and non RAC databases/ CRS from 10g to 11g Release 2.
• Building new clustered as well non clustered databases as per build standards.
• Building logical standby, upgrade to 11g with 10g primary to lessen downtime for critical production databases.
• Experience for OEM 10g, 11g, 12c cloud control.
• Troubleshooting CRS and Database issues in RAC and non RAC environment.
• Raising issues with Oracle supports for cluster, ORA 600, standby hang etc, constant follow up, implementing in dev/qa/production environment after co-ordination with application team.
• Best practices documentation for ASM, RMAN and implementing them in production environment (like putting crsctldiag wait, multiplexing voting disk and ocr, I/O multipating, Listener to listen on VIP, ntp - x on all Cluster nodes onAIX etc.) on all RAC clusters on various platforms and implementing platform related RAC practices (in progress).
• Troubleshooting backup failures, diagnosing net backup log files and suggest possible solutions.
• Suggesting various recovery scenarios for manual failures like table drop, tablespace drop, non system datafile drop.
• Day to day issues/alerts resolution for 300+ Production/DEV/Staging clustered and non clustered databases.
• Attending incident bridges for any production issues and working with app team to solve the issues at earliest.
• Daily monitoring through scripts, OEM Grid control 11g and 12c and resolving the alerts within SLA time as percriticality of the issues and application.
• Documenting new processes and updating existing process standards related to Database build, Backups, RACand non-RAC cluster upgrades.
• Experience in Veritas Active-Active and Active-passive cluster configuration at oracle end.
• Working with internal customer to migrate database to ODA environment from different regions.
• RMAN Backup migration to new versions of Oracle catalog.
• Working with Netbackup and Unix Team for migration of database backups to dedupe domain.
• Experience in exadata and goldengate implementation.

Confidential

Sr. Oracle-DBA

Responsibilities:

• Managing 10g RAC production cluster and other production databases size up to 5.5 TB.
• Troubleshooting CRS and Database issues in RAC and non RAC environment.
• Designing strategy for Upgrade from 10.2.0.3 to 10.2.0.4 Cluster and non cluster databases.
• Coordinating with Oracle support for various recommended patches on top of 10.2.0.4 and applying them in Test environment, DEV/QA environment and in production environment.
• Best practices documentation for ASM, RMAN and implementing them in production environment (like puttingcrsctl diag wait, multiplexing voting disk and ocr, I/O multipating, Listener to listen on VIP, ntp - x on all
• Cluster nodes on AIX etc. Also increasing sequence size as per RAT team recommendations).
• Best practices documentation for Backup and recovery and implementing them in critical databases (like full block checking, duplex log groups, check logical while taking backup, backup validation, keep each datafilein single piece etc).
• Working on TAF and load balancing project (application and database server/client load balancing) which includessetting up of application on app servers and testing performance for high and medium workload. Testing includes AWR analysis, interconnect performance queries, CPU, Paging, OS level private interconnect statistics. Documentationf test case results and then comparison and recommendations based on results.
• Automating App users password rotation policy (as per security guidelines ) at extent of 80% using scripts.
• Troubleshooting block corruption in production database and performing block recovery.
• Performing datafile recovery and applying archive logs in a large database like 5.5 TB.
• Daily AWR reports analysis for prod databases and provide recommendations. (Checking global cache events, sequence contention, I/O contention and other wait events and SQL statements).
• Daily monitoring through BMC patrol (for database and application), OS watcher.

Confidential

Oracle-DBA -Lead

Responsibilities:

• Implementation of 10g RAC on AIX 5.3 for Powercard application.
• Performing High Availability testing like EVMD failure testing, OCLSOMON failure testing, OPROCD failure testing, RACGIMON failure testing.
• Performing system testing like OCR failure, voting disk failure, system tablespace failure, All disk failure at one sideand both sides(mirror side also), data group failure, redo log failure.
• Performing Transaction processing testing while PMON failure, Listener failure, CRS daemon failure, CSS daemonfailure, Node failure.
• Documenting failure test case scenarios and expected behavior.
• Change enhancement with co-ordination with IBM and oracle at entire system level.
• Designing optimal Disaster recovery strategy using Data guard and Implementation of DR plan.

Confidential

Oracle-DBA

Responsibilities:

• Handling 250 databases including production, development, QA.
• Checking success of RMAN database backup to tape.
• Reactive tuning of database, user queries as per request.
• Suggesting approaches for implementation of 10g RAC and 10g RAC with dataguard depending on criticality ofdatabase.
• Checking Space, allocating space and estimating future requirements.
• Reviewing TARs, Updating and implementing solutions as suggested by Oracle.
• Implementing changes as suggested by application developers at schema level.
• Statistics gathering and Reviewing performance on a regular basis from STATS PACK reports that identifyingproblematic areas, monitor the performance overall.
• Export-import at schema level of some users.
• Moving data from one database to another for testing.
• Managing user privileges, profiles and security administration.

Environment: OS - Solaris, Windows, AIX. Oracle Version -Oracle 8i, 9.1, 9.2, 10g

Confidential

Responsibilities:

• Checking Alerts on the production as well as development database (47TB) and taking corrective measures.
• Checking space and adding space in the database.
• Defining Statistics generation strategy and implementation for production database.
• Reviewing TARs and patching to the database.
• Monitoring Data loading, taking corrective actions for failed tables, Suggesting Alternative approaches for fasterloading.
• Tuning Long running queries and suggesting alternative approach.
• Reviewing AWR reports and implementing recommendations.
• ASM rebalancing and space allocation (adding disks to diskgroups).
• Statistics generation.
• Export-Import of schema from production into development as per User request.
• Creation of new schema and user objects as per User request for testing in development (10.2.0.1.0 ).
• Database creation on higher version for testing.

Environment: OS - RHAS 4 on Linux Itanium with SAN storage Oracle Version - Oracle 10.1.0.3 RAC Grid10.2.0.1 RAC, 9.2.0.1

Confidential

Responsibilities:

• Resizing tablespaces for indexes and data.
• Loading the data from flat files to oracle 10g.
• Scheduling snapshots for AWR and analysis of report.
• Tuning SQL statements while comparing execution of same statements in InterBase.
• Oracle server tuning by adjusting initialization parameters to achieve desired performance goals.
• Implementing and configuring Oracle 10g RAC on RHAS3.

Environment: OS- Solaris 5.8 Oracle version -10g

Confidential

DATABASE ADMINISTRATOR (Oracle-DBA)

Responsibilities:

• Installation of Red Hat Advanced Server 3 and oracle 10g on RHAS 3 and documentation of installation procedure.
• Installation of 9.2.0.1 and patch for 9.2.0.4 on RHAS 3, Installation of RHAS 3.
• Creation of database and configuring various options (in 10g and 9.2).
• Taking export backup on production server.
• Formulation of new backup strategy for production server using RMAN.
• Supporting users for different databases at different locations all over India.
• Performing recovery of databases at failed locations.
• Supposed to implement 10g RAC on HP-Ux 11i Itanium server and preparation the document for 10g RAC
• Periodical performance check of the databases.(the largest size is 260GB).

Environment: OS - Red Hat Advanced Server 3 Oracle version - 10g

Confidential

DATABASE ADMINISTRATOR (Oracle-DBA,SQL Server)

Responsibilities:

• Installation of oracle 9i on Windows 2000, Unix.
• Supporting 40 GB,25 GB production databases.
• Supporting 300 users and 100 concurrent users.
• Establishing and maintenance of 24 X 7 need of database.
• Oracle Server & Client Installation.
• Tuning queries using Explain Plan, Statspack.
• Deciding on Logical Structures such as Table spaces, Segment size.
• Monitoring and maintaining long running jobs.
• Performing incremental backup every day and weekly full online backup through scripts.
• Maintaining Network Administration.
• Checking space usage, adding space and segregating large objects into separate tablespaces.
• Recovering backup of production databases on other server for testing of recovery.

Confidential

Responsibilities:

• Establishing and maintenance of 24 X 7 need of database.
• Oracle Server & Client Installation for test purposes.
• Tuning instance and memory structures.
• Performing online full backup every day.
• Performed routine checks of space utilization and free space in tablespaces and disk fragmentation.
• Implementing standby database for one database.

Confidential

Responsibilities:

• Oracle Server & Client Installation.
• Tuning queries using Explain Path, TKProf.
• Performing offline full backup weekly and generating archive logs on two different servers.
• Performing network connectivity through Hostnaming.
• Performing weekly logical backup for some users.

Confidential

Responsibilities:

• Taking backup through database maintenance wizard.
• Supporting 70 developers.
• Tuning and helping the developers to write efficient SQL procedures, triggers and SQL Statements.
• Performing centralized control for creation of objects in the databases.