PROFESSIONAL SUMMARY

• Experience as Oracle DBA providing support to many Production, Development, Test, CRP instances comprising of some of the more complex and challenging environments from versions 9i to 11g releases.
• Pre-patch analysis for the patches and document preparation with pre and post patch installation steps.
• Extensive work experience on Single instance, Oracle RAC databases in both OLTP and OLAP environments.
• Installation, configuration and upgrade of Oracle 10g, 11g RAC.
• Designing, modeling, administration, implementation, troubleshooting, and quality management for several production/test systems on Oracle 8i, 9i, 10g, 11g Databases. Involved system administrators groups in designing the logical and physical model of the databases.
• 8 years of extensive experience as an Oracle DBA in Production, Test and Development environments.
• Installing and Upgrading Oracle Server 10g to 11i, 11gR1, 11gR2.
• Administering Oracle 10g, 11g Instances.
• Multiple upgrades of Oracle server older versions to newer versions.
• Performed Cross Platform migration of Oracle and Advanced Planning and Scheduling from HP to AIX.
• Configuring, Upgrading and installing Oracle Server 9i/10g/11g.
• Troubleshooting and Administration of Oracle 9i/10g/11g Server.
• Oracle 11g Server Enterprise load balanced setup and configuration using multiple Oracle RAC databases for metadata repositories, Active/Active node, and Active/Passive node.
• Refreshed full database from RAC to single node and RAC to RAC database using hot backup.
• Oracle 10g,11g RAC Database setup and administration using Dell/EMC SAN for storage and Oracle Recovery Manager RMAN for backups.
• Implementing High Availability solutions with Oracle 11g RAC, Standby Data Guard .
• Installing, configuring and maintaining Oracle Grid Monitoring.
• Extensive knowledge in working with the tools like OEM, TOAD, QUEST, Export/ Import, Stats pack, SQL Loader, SQL Analyze, TKPROF, Explain Plan, and Oracle Supplied DBMS PACKAGE.
• Hot and cold Backup and recovery of Oracle 10g, 11g database using tools like RMAN.
• Scripting and scheduling of oracle database backup using RMAN.
• Good experience of Oracle PL/SQL, Procedures, Triggers, Cursors and Functions.
• Cloning of database for development teams, import and export of data.
• Involved in SQL tuning and refreshing statistics of database objects. Other duties included performance tuning database as well as applications by reducing disk contention, fragmentation, tuning SGA.
• Experience in writing complex SQL Queries, created materialized views.
• Developed UNIX shell scripts and SQL scripts to carry out routine checks on databases. This includes checking whether all databases are running, listener is running, disk space availability, checking for errors in alert logs etc.
• Proven ability to adapt to demanding schedules and changing priorities.
• Ability to function successfully in a highly stressful, 24x7 mission critical environment.
• Involved and implemented with analysts, developers, programmers and project managers in a project system development life cycle SDLC phases.
• Strong analytical problem solving and good communication skills with ability to work within team environment and independently when needed.
• Responsible data refresh from production database to other environments by using data pumps
• Responsible RAC installation for three node cluster
• Responsible for RAC database administration

TECHNICAL SKILLS

PROFESSIONAL EXPERIENCES

Oracle DBA

Responsibilities:

• Patching, Monitoring, tuning, cloning Oracle 11g instances and building test instances.
• Oracle tuning for latch wait, hot block, using ASH, AWR, ADDM tools.
• Install, Configure and implement 11gR2 nodes TEST, DEV and PRODUCTION RAC on RHL 5
• Install, configure, and administer in 11g database administration.
• Cloning RAC Database and Applications.
• Troubleshooting implementation issues and performance issues on RAC.
• Configure backup using RMAN on ASM enabled disk systems.
• Patching Oracle and RAC and Applications.
• 24/7 Production system support.
• Troubleshooting and Tuning Database, SQL and applications.
• Install 11g grid control and configure for all database and applications.
• Reasonable disaster recovery setups configuration
• Implementing the rolling Partitions for tables with multi million records for better maintenance, performance and data management with complete knowledge of Partition Tables, Partition Indexes, Partition splitting etc Responsible data base administration all the database by using grid control OEM
• Responsible Taking the report by using ASH,AWR and ADDM for tuning
• Responsible applying the rolling patches which recommended oracle support
• Providing functional inputs and database application design inputs to the programmers
• Responsible for moving data between different environments using transportable table spaces, exp/imp, SQL Loader , data pump, external tables etc
• Responsible data refresh from production database to other environments by using data pumps
• Responsible RAC installation for three node cluster
• Responsible for RAC database administration
• Responsible writing complex SQL queries and checking explain plan
• Responsible for creating index/rebuild index for tuning purpose
• Familiar with Toad and SQL Developer tools.
• Tuning of SQL queries using various techniques like explain plan, TKPROF, generating trace files, quest tools, Oracle trace and OEMs diagnostic pack etc.
• Responsible created triggers for implementing public synonyms for objects
• Monitoring Oracle's ASM Automatic Storage Management
• Monitoring status of Databases using Grid Control
• Measure, identify and optimize the queries, stored procedures and other data processes for better performance
• Responsible Data migration from SQL Server Integration Services SSIS to oracle database
• Responsible for peer review and code review for all supporting application initiatives
• Responsible for creating and maintaining shell scripts required to monitor database disk space , CPU and memory utilization and send alerts as and when required
• Managing and Administering multiple databases in development, testing and Production environments
• Defining, documenting and maintaining database standards for the applications to ensure consistency in database creation and other database objects
• Responsible for planning, creating and implementing monthly purge activity based on complex criteria to delete millions rows from tables and to re org and rebuild the data to eliminate fragmentation
• Responsible for planning and evaluating the use of Oracle RAC for various applications
• Documenting and maintaining meta data details, Design changes for all the supporting applications based on which logical and physical models has to be developed
• Planning and coordinating the testing of the new release for each database and each application area
• Creating duplicating database by using RMAN for testing and recovery purpose.
• Cloning the database as required
• Estimating and forecasting the resources like storage, CPU and memory required
• Responsible for trouble shooting and working with the application team in all the phases of development i.e. from development, unit test, integration test and moving the code to production
• 24X7 support for multiple Mission critical applications
• Responsible for stress test for new environment by using Swing Bench test.
• Responsible for Configuring Golden Gate for data replication and administration
• Responsible writing shell script for data move one database to another database.
• Responsible for OSWATCHER for monitoring system memory usage.
• Configured Data broker for Data Guard and Create physical stand by Data Guard.

Environment: Oracle 11g, Aix 6.1, Linux RH 5, ASM, RMAN, Golden Gate

Confidential

Oracle DBA

Responsibilities

• Front-line support and maintenance for Oracle systems globally
• Accountable for troubleshooting and Performance Tuning of all the support issues/requests
• Continuous Performance monitoring and tuning of the databases and application using OEM Tuning Pack, Diagnostics Pack and AWR
• Tuning Oracle 10g/11g database servers using tools dynamic dictionary views, Stats pack, ADDM, AWR Diagnostic and tuning packages.
• Monitoring of the queries with high response time and high disk reads per execution and tuning the same using Explain Plan, TKPROF
• Experience in using Unix tools like TOP, PRSTAT, VMSTAT, IOSTAT, NETSTAT, GLANCE, TOPAS, NMOM, SAR etc
• Monitored and Tuned/optimized the SQL queries using SQL Tuning Advisor, SQL Access, hints, Explain Plan, SQL trace, Tkprof reports and parallel
• Experience in checking the Database wait events resolving the issues by taking the required actions
• Incident management in mission critical environment
• Demonstrated ability in Oracle streams, RAC and non-RAC environments
• Converted Single instances to RAC
• Installation / Configuration of RAC Databases on Active/Active node, Active/Passive on Linux, AIX
• Refreshed full database from RAC to single node and RAC to RAC database using hot backup.
• Performed 10G, 11G RAC switchover and failover configuration
• Troubleshooted various RAC Performance Tuning Issues.
• Performed RAC Backup/Recovery of Oracle databases using backup tool Upstream
• Configured Automatic Storage Management ASM for 10g, 11g RAC databases
• Creating and sizing of database objects tablespaces, tables, and indexes
• Database Backup and crash/Recovery both local and remote.
• Management of Users, Roles and Privileges.
• Scripts to monitor online Database objects and SGA.

Replicating the tables, schemas and database

Backed-up database and database objects using different techniques such as user-managed backup, RMAN backup with or without catalog, operating system backup, cold and hot backup, full backup, incremental and cumulative backup.

• Hot and cold Backup and recovery of Oracle 11g database using tools like RMAN.
• Daily monitoring and checking the Background Dump File alert SID Logs and User Dump Files for errors.
• Expert knowledge of oracle data-dictionary configuration of OEM: DB Control

Environment: Oracle10g/11g, RHE Linux, Aix 5.3, ASM, OEM, RMAN, TOAD

Confidential

Oracle DBA

Responsibilities

• Worked in 24x7 Production Oracle Databases environment.
• Involved in both managing and supporting all Production, Development and Test instances of Oracle Version and Oracle Applications.
• Creating the Customized Menus, Responsibilities, Request groups, Request sets and Application Users as part of sysadmin.
• Experience in cloning, Patching, Installation and problem solving in the Oracle E-Business Suite EBS .
• Maintaining the Oracle Applications EBS Systems including Oracle databases, Middle tier IAS Applications.
• Working closely with Functional/Developers and helping them in issues.
• Database Backup and crash/Recovery both local and remote.
• Documented the Backup and Recovery procedures.
• Scripts to monitor online Database objects and SGA.
• Setup a crontab for Production Environment to receive alerts related to TS issues, OS level space issues, locking issues etc.
• Implemented Change Tracking File with RMAN and reduced the backup time significantly.
• Performed full database recovery as well as incomplete recovery using Tablespace Point in Time Recovery TSPITR . Knowledge of cross platform migration of databases.
• Experienced in cloning database using RMAN Duplicate and cold hot backups.
• Backed-up database and database objects using different techniques such as user-managed backup, RMAN backup with or without catalog, operating system backup, cold and hot backup, full backup, incremental and cumulative backup.
• Generated reports for displaying the metadata in the metadata manager using Informatica data analyzer tool.
• Responsible for Extract Transform and Loading from various systems to Oracle Data warehouse and developed Loader Scripts for various ETL Operations
• Designed ETL jobs and Autosys jobs to extract data from java applications into metadata manager repository
• Good experience in SQL, PL/SQL, Shell Scripting, Partitioning, Data modeling with utilities like OLAP, Logical and Physical Database Design, Backup and Recovery procedures.
• Managed Resumable Space Allocation using Resumable Time out parameter.
• Good experience with multi master replication setup Administer with Golden Gate
• Replicating the tables, schemas and database using the replicating tool Golden gate.
• Successfully implemented Data Guard on physical, logical standby databases.
• Adding a Disk group, removing a disk group, movement of data between disk groups in an ASM storage platform.
• Installed, configured and troubleshoot Oracle Clusterware Cluster Ready Service CRS for RAC. Used Oracle 11g specific features like Automatic Memory Management AMM , Result Cache parameters.
• Troubleshoot RAC database by verifying alert logs. Configured Rapid connect-time failover and Transparent Application Failover in RAC environment and working knowledge in Maximum Available Architecture MAA .
• Experience in Installing, configuring and administrating database in RAC environment.
• Hot and cold Backup and recovery of Oracle 11g database using tools like RMAN.
• Maintain database security, user roles and access profiles, Involved in taking cold and hot backups.
• Performed installation and configuration of Oracle fusion middleware as team member.
• Daily monitoring and checking the Background Dump File alert SID Logs and User Dump Files for errors.
• Ability to function successfully in a highly stressful, 24x7 mission critical environment.
• Strong analytical problem solving and good communication skills with ability to work within team environment and independently when needed.

Environment: Oracle10g/11g, RHE Linux, Solaris10, Dataguard, RMAN, 11g OEM

Confidential

Oracle DBA

Responsibilities:

• Responsible for maintaining Oracle 10g/11g databases for different clients.
• Designing, modeling, administration, implementation, troubleshooting, and quality management for several production and test systems on Oracle 10g, 11g Databases
• Implement Physical Standby database for High availability Disaster Recovery using Data guard.
• Installed, Configured and deployed SOA on single node and cluster node.
• Created and Configured Data Servers, Physical Schemas, Logical Schemas, Models, Interfaces for source and target Data Mapping and Packages.
• Tested different Journalizing Knowledge Modules to ensure better performance.
• Good knowledge of data warehouse architectures, concepts and technologies.
• Conceptual data modeling logical and physical data modeling.
• Cloning and Patching.
• Good understanding in data modeling, entity-relationship modeling.
• Implemented cloning of Production database on TEST environment to provide users the live data for testing purposes.
• Export and Import of Oracle Internet Directory Single Sign On Users with ldap utility.
• Continuous Performance monitoring and tuning of the databases and application using OEM Tuning Pack, Diagnostics Pack and AWR.
• Reviewed the procedures and methods used to manage the staging and production data feeds all via materialized views replication .
• Configuration of OEM11g.
• Applying Oracle Applications patches Maintenance Pack, Interoperability patch, Family pack, one offs Patches etc .
• Expert knowledge of oracle data-dictionary configuration of Oracle Enterprise Manager OEM : DB Control, Grid Control 9i/10g/11g.
• Skilled in database upgrades 8i to 9i, 9i to 10g R2 and 10g to 11g.
• Oracle 11g RAC Database setup and administration using Oracle Recovery Manager RMAN for backups.
• Oracle 11g Application Server Enterprise load balanced setup and configuration using multiple Oracle RAC databases for metadata repositories.
• Planning and Administration of backup and recovery strategies.
• Creating Application Users, Profiles, and Responsibilities for the user.

Environment: Oracle 9i/10g/11g, Aix 5.3, ASM, OEM, RMAN, Golden Gate

Confidential

Oracle DBA

Responsibilities

• Controlling User access: Creating Users, User system Privileges, Granting system privileges, Creating Role, Creating granting Privileges to a Role, Changing user password, Granting Object Privileges.
• Backing up system using RMAN backup.
• Constantly monitor the performance V dynamic performance views at peak load of the Databases and viewing Alert log files Trace files.
• Creating Maintaining Tablespaces.
• Creating monitoring alerts in OEM 10g Grid.
• Setting new threshold values based on the alert history and business requirements.
• Tuning applications.
• Schema, Table, Database refreshes on demand for development teams.
• Monitoring the CPU usage, IO statistics, and CPU time to identify any OS level Performance killers.
• Working experience with Very-Large databases VLDB up to 4 terabytes, data migration, against Oracle other databases such as SQL Server, MYSQL etc.
• Experience in job scheduling for Windows, UNIX crontab .
• Installation of Oracle clusterware, ASM, Configuring public and private network VIP. Used SRVCTL utility for managing multiple instances nodes, Managed multiplex Voting Disk and OCR file for maximum RAC availability.
• Shell scripting for the database and application monitoring.
• Capacity planning space management, ongoing maintenance of production and development environments.
• Analyze SQL statements, reorganize database objects and design indexes to improve response of queries.
• Resolving dataguard DR site sync issues.
• UNIX Shell scripting to simplify the day to day activities.

OS: Sun Solaris 10, UNIX

Software: 10g, 11gOAM, OEM Grid Control, UNIX Shell Scripting, UNIX Cronjobs, RMAN, TOAD

Replication Software/ Tools /Utilities: RMAN, OEM, SQL Loader, EXP, IMP, Expdp, Impdp

Confidential

Oracle DBA

Responsibilities

Involved in SQL tuning and refreshing statistics of database objects. Other duties included performance tuning database as well as applications by reducing disk contention, fragmentation, tuning SGA.

Used Export/Import and Datapump utilities for full/partial backup.

Performing Backup/Recovery of all the Oracle databases using RMAN, also setup RMAN catalog for the same.

Performed backup validations using RMAN, Database monitoring, troubleshoot and resolve the issues.

• Oracle Systems Administration. RMAN used in recovery, hot and cold backup of Oracle10G database.
• Planning and Administration of backup and recovery strategies.
• Creating Application Users, Profiles, Responsibilities, Roles, Functions for the user.
• Performance tuning of Oracle Database, applications and queries.
• Experience in testing and validating backups using Recovery Manager.
• 24x7 Production Oracle Administrations.
• Maintaining production, development test databases and applications.
• Upgraded Oracle server Database Version 8.1.7.4 to 10g 10.2.0.4 on Solaris.
• Upgraded Oracle Database 9.2.0.8 to 10g.
• Upgraded database from Oracle 9i to Oracle 10g RAC on Windows.
• Installation and configuration of 9iAS/10gAS and performance tuning of Oracle RAC.
• Applied patches using ADPATCH, ADCTRL utilities.
• Performed database and application cloning of Production database on TEST environment to provide users the live data for testing purposes.
• Was involved in developing a disaster recovery DR plan.
• Continuous Performance monitoring and tuning of the databases and application using OEM Tuning Pack, Diagnostics Pack and STATSPACK.
• Supported installation and configuration of Oracle WebDB, Oracle OAS and Oracle 9i.
• Tuning heavy data loads. Monitoring and Performance tuning.
• Experience in using Flash-Back Recovery, AWR, ASM, ASH and ADDM.

OS: Linux, UNIX, Solaris

Software: 10g, OEM Grid Control, UNIX Shell Scripting, UNIX Cronjobs, RMAN, TOAD

Confidential

Oracle DBA

Responsibilities

• Database Re-organization database, Tablespaces, tables etc. . Re-org is done from time to time for the primary storage objects like tables, indexes.
• Monitoring the CPU usage, IO statistics, and CPU time to identify any OS level Performance killers.
• Management of schemas, objects partitioning the tables indexes.
• Designing the logical and physical database structure.
• Taking Backups on scheduled time and monitoring scheduled Backups.
• Stress test worked with Test Engineer and evaluated the performance.
• Tuned the slow running concurrent requests.
• Creating the Customized Roles, Responsibilities, groups, Request sets and Application Users as part of sysadmin.
• Creating and Managing Primary Objects like Custom tables, Procedures, Packages, Triggers, Alerts Functions, Views, Indexes, user accounts, roles, grants and performing day-to-day operations.
• Database Upgrade from 8.1.7 to 9.2.0.6 and 10g.
• Developed and maintained database designs, Meta data and data dictionaries.
• Rebuilding Database indexes.
• Monitoring table space usages.
• Configuring SQL Net through tnsnames.ora and listener.ora.
• Upgrading JDK versions from 1.4.2 to 1.5 and 1.6
• OS: HP-Unix, AIX, Linux
• Software: Oracle database 8i 9i.

Confidential

Oracle DBA

Responsibilities:

• Creating and sizing of database objects tablespaces, tables, and indexes .
• Database Backup and crash/Recovery both local and remote.
• Documented the Backup and Recovery procedures.
• Management of Users, Roles and Privileges.
• Database performance tuning, table sizing and administration.
• Scripts to monitor online Database objects and SGA.
• Diagnose the bottlenecks and problems causing poor performance.
• Database reorganization to minimize fragmentation.
• Rebuilding indexes for faster access and to reduce disk I/O.
• Data extraction and Loading using Export/Import and SQL Loader.
• Responsible for security on production database like creating roles and provide access to application schemas to users and maintain separate table spaces for data, indexes and temporary applications.
• Created different synonyms views as per business needs. Created materialized views and snapshots for high end application usage.
• Planning for storage spaces requirements and placing them for optimum I/O performance.
• Tuning the databases for optimal performance.
• Experience in implementing hot, cold and RMAN backups and performance tuning of SQL statements
• OS: HP-Unix, AIX, Linux, Windows, Solaris,
• Software: Oracle database 8i 9i.