Professional SUMMARY

• Certified Oracle DBA with over 10 years of Exposure on Production, Systems Analysis, Design, Development, Implementation and Testing of Relational Database Management systems for Business solutions.
• Extensive experience in Application Development, Database development and 24x7 production system support handling large databases using Oracle 11g, 10g, 9i, 8x, 7.x, on various platforms like AIX 4.3.to 5.3. ASM ,Solaris 5.9/RedhatEL 4.0/ ScoUnix 5.3.2/UnixWare 7.0/ HP UNIX 11.0 and WinNT 4.0/2000/2003
• Extensive experience as Oracle Server DBA and proficient in Oracle 9i,10g,11g software installations, database Capacity Planning, Backup Implementation, Tuning Oracle 9i,10g on Unix and Linux platform
• Well conversant in translating business requirements into creation of database objects: tables, indexes, constraints, packages, stored procedures and functions using Oracle tools.
• Experienced in maintaining Oracle Data Guard Standby Database and providing critical solution with strategic disaster recovery plans with different recovery procedures and methods Created and designed Oracle best practice documents for the DBA's which has the environment details, understand the Technical, Functional concepts, Process and Structure of the Database. These documents where very useful for the developers and DBA's in identifying and analyzing the problems for resolving the errors in quick time to meet the SLA.
• Initiated in conducting the weekly meetings for DBA's and developers to discuss the issues and plan the maintenance activities well before in order to avoid the database downtimes.
• Initiated in speaking to the team members to analyze the problems and issues by escalating it to the higher level.
• Took the initiative in making the necessary changes in the designing of the Database and Backup strategies.
• Awarded as the best employee for my tremendous performance as a team member in 2007.
• Rewarded for Training and Knowledge Transfer to the fresher's in Oracle 9i/10G.

Technical skills

Databases : Oracle 11G/10G/9i/8i, Exadata, SQL Server 2000, Sybase

Oracle High Availability : 10G/11G RAC, ASM, Advanced Replication, Data Guard

Oracle Tools : Reports 6i, SQL Plus, OEM 12 C

Oracle Utilities : SQL Loader/Expdp /Impdp/RMAN

Operating Systems : Linux/Solaris 8.0/HP UX/Windows 2003 server

Storage Technologies : SAN EMC DMX, BCV, SRDF, OCFS, Oracle ASM

Backup Recovery : RAMN IMP/EXP, flashback, Legato, Net Backup, EMC, GC

Languages : SQL, PL/SQL, Shell Scripting Visual basic

Other Tools : Erwin, TOAD, SCP, FTP, VNC, X Manager, Exceed

Professional Experience:

Confidential

Senior Database Administrator

Responsibilities

• Communicated with Oracle to get the necessary patches required to fix up the database changes needed using TAR Support and coordinating the patches and implementing the necessary changes.
• Maintain and Monitoring of Oracle 11G DG physical standby databases, manually apply the missing logs to standby from primary.
• Applied BUG patches which are caused by Ora- errors.
• Applying PUS patches for both RAC and Non RAC databases.
• Monitoring and maintain the database using Oracle Schedulers, Maestro scheduler and Unix Cron job scripts for package startup/shutdown and backups
• Monitor and Maintain the Autosys jobs.
• Monitoring and maintain the database using Oracle Schedulers and Unix Cron job scripts for package startup/shutdown and backups
• Extensively worked on 12C grid control to Monitor and Maintain the Databases
• Performed switch over and fail over on Standby database using datagaurd broker.
• Performance, Monitoring, determines the size SGA/PGA, Hit Ration, estimate the number of users, CPU, and Disk space management, ADDM, AWR, OEM.
• Monitoring the CPU utilization and troubleshooting if it crosses the threshold value.
• Resolving the locks on the database.
• Created Plans for PL/SQL to find out the issue causing the performance.
• Monitor batch process and resolve them if they run more than expected time, Resolving locks, long running jobs,
• Find out the proper execution plan to improve the performance of the query.
• Monitoring performance using AWR reports and ADDM Reports.
• Tune SQL and PL/SQL, analyze them to find out the performance issue.
• Used Recovery Manager RMAN and Enterprise Manager for various maintenance tasks like backing up of database, restoration and recovery of database.
• Involved in taking logical backups using EXPORT, IMPORT and DATA PUMPS.
• Provided 24x7 on-call supports. Worked beyond regular hours based on business demands.

Environment

HP UX, Solaris, Linux, AIX, Oracle 10g, 11g, RAC, 12C OEM, ASM, Golden Gate, Exadata, Delphix, Autosys, Sybase.

Confidential

Senior Database Administrator

Responsibilities

• Applied BUG patches which are caused by Ora 600 and Ora 7445.
• Tune the Databases for optimization using Statspack and Explain Plan, Estimating Table Index Size. Upgraded multiple production RAC environments from 10gR1 to 10gR2.
• Install and configure Oracle databases on various platforms. Backup, restore, modify, monitor and tune databases as required. Identify and tune problematic SQL. Monitor RAC configurations.
• Install, monitor and tune Oracle Application Server/Fusion Middleware software. Upgrade systems from Oracle Application Server to Weblogic.
• Deploy Java code in Oracle Application Servers, Fusion Middleware Servers, Weblogic, Apache Tomcat, Jboss and WebSphere servers.
• Maintain security protocols such as SSL and SSO. Monitor system performance to identify and recommend solutions for performance.
• Applying PUS patches for both RAC and Non RAC databases.
• Monitoring and maintain the database using Oracle Schedulers, Maestro scheduler and Unix Cron job scripts for package startup/shutdown and backups
• Monitoring and maintain the database using Oracle Schedulers and Unix Cron job scripts for package startup/shutdown and backups
• Implemented shared appltops on NFS mounted disks across web farms supporting dedicated Apache servers for Discoverer and Configurator,
• Performed switch over and fail over on Standby database.
• Performance, Monitoring, determines the size SGA/PGA, Hit Ration, estimate the number of users, CPU, and Disk space management, ADDM, AWR, OEM.
• Monitoring the CPU utilization and troubleshooting if it crosses the threshold value.
• Resolving the locks on the database.
• Monitoring performance using AWR reports and ADDM Reports.

Confidential

Senior Database Administrator

Responsibilities

• Applied BUG patches which are caused by Ora 600 and Ora 7445.
• Upgraded multiple production RAC environments from 10gR1 to 10gR2.
• Installed and managed Oracle Fusion middleware and configured the tech stack for Identity Management, Single sign-on, Windows authentication, and configuring Oracle Portal administration.
• Applying PUS patches for both RAC and Non RAC databases.
• Monitoring and maintain the database using Oracle Schedulers, Maestro scheduler and Unix Cron job scripts for package startup/shutdown and backups
• Monitoring and maintain the database using Oracle Schedulers and Unix Cron job scripts for package startup/shutdown and backups
• Maintain and Monitoring of Oracle 10G DG physical standby databases, manually apply the missing logs to standby from primary.
• Performed switch over and fail over on Standby database.
• Performance, Monitoring, determines the size SGA/PGA, Hit Ration, estimate the number of users, CPU, and Disk space management, ADDM, AWR, OEM.
• Monitoring the CPU utilization and troubleshooting if it crosses the threshold value.
• Resolving the locks on the database.
• Monitoring performance using AWR reports and ADDM Reports.
• Used Recovery Manager RMAN and Enterprise Manager for various maintenance tasks like backing up of database, restoration and recovery of database.
• Involved in taking logical backups using EXPORT, IMPORT and DATA PUMPS.
• Communicated with Oracle to get the necessary patches required to fix up the database changes needed using TAR Support and coordinating the patches and implementing the necessary changes.
• Provided 24x7 on-call supports. Worked beyond regular hours based on business demands.

Environment

HP UX, Solaris, Linux Oracle 9i, 10g, 11g, RAC, ASM, OCFS2

Confidential

Senior Database Administrator

Responsibilities

• Upgraded multiple production RAC environments from 10gR1 to 10gR2.
• Involved in Migration of databases from Windows 2003 to UNIX and UNIX to Windows 2003.
• Applying patches on 3 nodes and 2 nodes RAC databases.
• Responsible for RAC Systems Support and maintenance of database sizes of more than 20TB
• Monitoring and maintain the database using Oracle Schedulers, Maestro scheduler and Unix Cron job scripts for package startup/shutdown and backups.
• Installed and managed SOA Middleware components for Dev, Stage and Production instances
• Applied Middleware Patches to patch level the instances
• Designed logical and physical Data Models of database at schema levels using ERWIN.
• Applied BUG patches which are caused by Ora 600 and Ora 7445.
• Monitoring and maintain the database using Oracle Schedulers and Unix Cron job scripts for package startup/shutdown and backups
• Maintain and Monitoring of Oracle 10G DG physical standby databases, manually apply the missing logs to standby from primary.
• Performed switch over and fail over on Standby database.
• Performance, Monitoring, determines the size SGA/PGA, Hit Ration, estimate the number of users, CPU, and Disk space management, ADDM, AWR, OEM.
• Monitoring performance using AWR reports and ADDM Reports.
• Used Recovery Manager RMAN and Enterprise Manager for various maintenance tasks like backing up of database, restoration and recovery of database.
• Installed and configured Oracle 10gRAC maintained the RAC set up, Performance Tuning, coding and Monitoring for Oracle Application Clusters, Oracle Management Server, and OEM on Red Hat Linux 4 Advanced Server with 2 nodes server side load balancing using ASM.
• Monitoring and maintain the database using Oracle Schedulers and Unix Cron job scripts for package startup/shutdown and backups
• Extensively used SQL Loader to migrate the legacy data to the new instance
• Audit of the Data/Database objects for auditors.
• Provided 24x7 on-call supports. Worked beyond regular hours based on business demands.
• Communicated with Oracle to get the necessary patches required to fix up the database changes needed using TAR Support and coordinating the patches and implementing the necessary changes.
• Involved in taking logical backups using EXPORT, IMPORT and DATA PUMPS.
• Installed and configured Oracle Enterprise Manager to monitor the Databases.
• Maintenance of Oracle 10G DG physical standby databases. Configuring Data Protector using RMAN to take DB backups.
• Experience in High availability design with VERITAS Cluster and Volume Management.
• Experience in monitoring the VERITAS Net Backups.
• Performance, Monitoring, determines the size SGA/PGA, Hit Ration, estimate the number of users, CPU, and Disk space management, ADDM, AWR and OEM.
• Involved in Physical and Logical design of Data MODEL using ERWIN.
• Designed, Implemented and Tested Backup Recovery strategies for database using Data Pump and RMAN Utilities.
• Used Recovery Manager RMAN and Enterprise Manager for various maintenance tasks like backing up of database, restoration and recovery of database.
• Experience in maintaining Oracle Data Guard Standby Database and providing critical solution with strategic disaster recovery plans with different recovery
• Successfully implemented physical standby database using Oracle Data Guard feature for High availability configuration.
• Experience with ecommerce applications in Java/tomcat.
• Communicated with Oracle to get the necessary patches required to fix up the database changes needed using TAR Support and coordinating the patches and implementing the necessary changes.
• Documentation of Data Base Setup and administration of Server Environment.
• Provided 24x7 on-call supports. Worked beyond regular hours based on business demands.
• Created and Maintained Users and Roles with Appropriate Privileges and Profiles
• Audit of the Data/Database objects for auditors
• Involved in evaluation and capacity planning process of deciding the central storage hardware for the new RAC environment.
• Attending meetings with developers, managers and the users to discuss the change or enhancements to the legacy system
• Checks for Oracle database.
• Extensively used SQL Loader to migrate the legacy data to the new instance
• Involved in DB Upgrade from 8i to 9i for Oracle Applications
• Installation, creation, configuration and Performance tuning of database.
• Performance tuning for Oracle Day-To-Day Maintenance and management of the several different databases in development, test, and production environments.
• Understanding the existing Database Structure and suggesting the database reorganization.
• Oracle 10g Installation and Configuration.
• Upgraded databases from 9.2.0.1 to 10gR2 and applied critical patches update CPU for latest versions.
• Actively involved in installation and configuration of Real Application Clusters RAC running on 2 node clusters.
• Involved in project of upgradation of standalone databases to 10g RAC environment.
• Worked on SAN
• Maintained and Monitored the VERITAS Net backups.
• Configured Bigfile Tablespace for Very Large Scale Database VLSD .
• Tune the Databases for optimization using Statspack and Explain Plan, Estimating Table Index Size.
• Wrote shell script, which generate Statspack Report at regular interval.
• Resolved performance issues by Automated Workload Repository AWR and Automatic Database Diagnostics Monitor ADDM .
• Automated the Database refresh process from Production to TEST environment.
• Data loading using Oracle SQL Loader and also developed SQL Loader script to load data with fine tune setting for optimum performance of the SQL loader.
• Extensively used new features of 10g like Import, Export and Data Pump logical backup.
• Wrote a shell script for taking backup using Export/Import.
• Involved in Physical and Logical design of Data MODEL using ERWIN.
• Automation of lot of process to keep the systems up to date and to reduce manual errors by developing shell scripts and using CRONTAB in UNIX.
• Created Database link to access the object on remote database and scrip to check the connectivity among all the databases.
• Audit of the Data/Database objects for auditors.
• Monitored and tuned Rollback Segment, Temporary Tablespace, Redo Log Buffer, Sort Area Size, and Flash Recovery Area.
• Storage Management, Managing Space, Tablespaces, Segments and Extents, Rollback Segments Data Dictionary.
• Granted and Revoked privileges and roles to the users on different objects depending on their work requirement and provided the necessary security to the database.
• Supported test and development environments to ensure smooth transition of applications into production.
• Served as Oracle DBA in a 24x7 Production environment managing several Database instances.

Environment

HP UX 11.00, Linux, AIX, Oracle 8i, 9i,10g and SQL server, My SQL

Confidential

Database Administrator

Responsibilities

• Proactive monitoring and managing the 21 instances involved
• Provide support for code movement to production
• User, Roles and Privilege management
• Handling Replication related Issues.
• Space Management Issues
• Move to Production activities
• Resolving ORA errors
• Responsible for monitoring and maintain the SQL servers.
• Handling Tuning Related issues.
• Backup and Recovery issues, also included RMAN
• Supported Oracle RMAN backups and VERITAS Net Backup
• Documentation of the dataflow and system design.
• Database administration, database design and database development work with Oracle 8i, Installation and maintaining Oracle server 8i on LINUX.
• Database administration, managing table spaces, objects and disk space.
• Worked on database performance monitoring using OEM.
• Creation of oracle users, Oracle roles, granting privileges etc.
• Query Optimization using Explain plan and SQL trace with TKPROF Assist Sr.Oracle DBA in day-to-day Administration.
• Involve in Data Maintenance, using Explain plan, SQL Hints, Table and Index Partitioning to improve the Performance.
• Database performance and SQL tuning
• Developed procedures to load data using SQL loader with direct/conventional parallel modes.
• Installation of Oracle severs on various operating systems.
• Creation and maintaining the databases as per OFA standards.
• Participate with application development team to design Oracle database.
• Creating tables, indexes, sequences, constraints, triggers and procedures.
• Control user access to resource and information.
• Security Management by allocating proper privileges.
• Monitoring alert logs

Environment

HP UX 11.00, Oracle 9.2.0, SQL server

Confidential

Database Administrator

Responsibilities

• Performing daily checks like log monitoring, health checks, tablespace depletion
• checks for Oracle database
• Backup validation checks.
• Tablespace standard checks.
• Installation of oracle database software 8 and 9i.
• Cloned the Database from production to development environment.
• Migration of database 9.1.0.5 from SunOS 5.6 to SunOS 5.9.
• Upgraded database from 9.2.1.0 to 9.8.0.8 on SUN Solaris using Database Upgrade Assistance DBUA and manual upgrade method.
• Upgraded and patched Oracle software, Setup brand new machines including Oracle
• Software installation.
• Converted tablespaces to locally managed tablespaces to eliminate fragmentation,
• Better performance and reduced maintenance.
• Wrote the SQL Loader scripts to load the external files into the Oracle Database.
• Configured Oracle Enterprise Manager OEM and monitored production databases.
• Extensively used Explain Plan to identify the poorly performing query.
• Utilized Crontab and DBMS JOBS to automate the monitoring jobs.
• Created and Maintained Users and Roles with Appropriate Privileges and Profiles. Granted
• and Revoked privileges and roles to the users on different objects depending on their work
• requirement and provided the necessary security to the database
• Implemented database refresh with the hot backup using DUPLICATE or full export.
• Designed and implemented of Backup Strategy for the production databases.
• Extensively Used RMAN for hot backup as well as Developed or modified some
• Oracle Backup and Recovery Scripts.
• Design, deployment, monitoring and troubleshooting of rollback segments.
• Supported the development team and supporting production Environment.
• Performance tuning by doing Partitions of large table and Created Indexes by
• Analyzing and rebuilding of Indexes for better performance.
• Performing code release and Refresh as change release
• Performance tuning, monitoring system health, applying patches.
• Query performance using better joins and used Hints appropriately.
• Performed SQL tuning by using Explain Plan
• Resolving incidents and implementing change request
• Documentation of procedures/process wherever required.
• Worked on mount points free space monitoring.
• Worked on database setup and monitored the database growth on daily basis
• Developed oracle reports as per the user requirement
• Used SQL Plus to access the Procedures and Functions

Environment

HP UX 11.00, Linux, Solaris, AIX Oracle 7, 8, 9i