Oracle Manager
Resume:
Madhu
PROFESSIONAL SUMMARY
Over **+ years of experience in Information Technology.
•
8+ years experience as an Oracle DBA on Linux, UNIX operating system environments.
•
* ***** ********** *s a Java/J2EE Developer.
•
• Providing 24/7 support of non prod(STG,DEV,QA,INT) and PROD 11g/10g/9i databases on
UNIX/LINUX and Windows environments.
• Proficient in Database Administration activities such as Upgrades, Patches, Cloning, Backup and
Recovery, Performance Tuning, capacity planning, script development, and documentation.
• Excellent experience in OLTP/DSS database systems, implementing and managing very large Oracle
databases as huge as 40 TB.
• Excellent experience in Oracle database installations 9i, 10g and 11g in IBM AIX, Linux, HP UX,
SUN Solaris.
• Migrated single instance databases to multimode 10g, 11g R1 and R2 RAC environments for
high availability and load balancing.
• Expertise in propagation of information and to support data replication in the oracle database
environment using Golden Gate.
Extensive experience in performance tuning of database, memory & I/O using tools such as AWR,
•
ADDM, STATSPACK and analyzing queries using EXPLAIN PLAN, SQL TRACE, TKPROF.
Extensive experience in performing Backup policy and tested crash recoveries using RMAN.
•
• Expert in providing the full database dumps and schema level dumps to non prod database environments
using DataPump Export/Import. and database reorganization regularly for removing row migrations
and fragmentation using export and import utilities.
Installing ASM environment and migrating database from NON ASM to ASM
•
Experience of daily monitoring Oracle instances and maintenance of databases using OEM12c,11g and
•
10g Grid monitoring tool.
• Maintained Databases by evaluating high availability options and disaster recovery plans implementing
DATAGUARD with different protection modes according to business requirements.
Experience in shell scripting for various CRON jobs to be run for automating DBA tasks.
•
• Proficient in SQL, PL/SQL, stored procedures, packages, triggers.
• Experience in using 10g features Flash-Back Recovery, Data Pump, AWR, ASM, ADDM,
ASH, Recycle Bin.
• Efficient in security administration by creating, maintaining and Auditing users with appropriate
profiles, roles and privileges to access database resources.
• Experience through all parts of Software Development Life Cycle(SDLC) in developing web applications
using JAVA, J2EE, JSP, Servlets, JDBC, JMS, XML, Struts and etc.
• Experience in Client Server, J2EE technologies and MVC frameworks.
Madhu
CERTIFICATIONS
ORACLE Certified Professional.
TECHNICAL SKILLS
Oracle (8i, 9i, 10g, 11g).
Data Bases:
Sun Solaris, IBM AIX, HP UX, Windows 2000/2003/2008, Windows NT,
Operating Systems:
RedHat Linux.
C, C++, C#, Java, J2EE, SQL, PL/SQL, Shell/Perl scripting.
Programming &
Oracle OEM 12c,11g,10g Grid Control, SQL*Loader, RMAN, Toad, SQL
Tools and Utilities
Developer, LogMiner, Statspack, AWR, ADDM, ASM,TKPROF, Data
pump, DBCA, DBUA, Golden Gate.
IBM WebSphere, weblogic, Tomcat. Apache etc.
Application Server:
PROFESSIONAL EXPERIENCE
Belk Inc, NC May 14 – Till Date
Sr. Oracle DBA
Environment: Oracle 10g/11g, RHEL 5, AIX 6.1, OEM/Grid, Weblogic 10g
• Created and maintained 50 RAC Databases size of varying from 20GB to 40TB for
Production,Staging,Integration,Development and Testing using Oracle 10g, 11g.
• Provided 24x7on call support for all the Production,Staging,Integration and Development databases.
• Installed and upgraded databases from 10gR2 to 11gR1/11gR2 on Linux, Sun Solaris, HP UX,AIX.
• Implemented and configured of Oracle Enterprise manager OEM 12C and Oracle Management
Server for maintenance and monitoring of production databases.
• Applied latest PSU and One off patches for both Oracle Grid and RDBMS homes.
• Experience in Real Application Clusters (RAC) configuration and cluster interconnection with
Automatic Storage Management (ASM), configured user log on load balancing and failover on RAC
database for high availability.
Madhu
• Performed the RCA (Root Cause Analysis) for Node Eviction and also for CRS reboots & other
issues.
• Worked with different utilities like DATAGUARD broker (DGMGRL), SRVCTL, CRSCTL and
CLUVFY.
• Configured ASM and worked extensively with ASMCMD for managing ASM environment.
• Implemented shell scripts, which monitor database health check and to maintain the database
activities at regular interval.
• Created and managed tablespaces monitored the datafiles space, resizing and adding new datafiles
etc.
• Coordinating with the teams during maintenance activities and system reboots.
• Database monitoring and maintenance activities which include checking alert logs, space
management, database locking issues, gathering database statistics, scheduling of jobs, creation of
users, schemas, tablespaces and other database objects.
• Database Reorganization regularly for removing row migrations and fragmentation using export and
import utilities Taking care of tablespace related issues like increasing the storage parameter values,
resizing the datafiles, adding new datafiles etc.
• Cloned databases and Implemented 11gR2 DATAGUARD using RMAN duplicate.
• Worked on installing the data guard on RAC databases for disaster recovery and setup the
DATAGUARD broker.
• Tested and performed DATAGUARD switchover on the RAC databases manually.
• Configured and monitored RMAN backups in OEM 11g grid control and performed DATAGUARD
sync using RMAN.
• Developed Oracle backup and recovery scripts using RMAN utility.
• Used Automatic Workload Repository (AWR) & Automatic Database Diagnostic Monitor (ADDM)
in RAC for Performance Tuning.
• Optimization and tuning SQL queries using SQL*Trace, TKPROF, EXPLAIN PLAN
• Proficiency with Installation and maintenance of replication tool GOLDEN GATE by creating
extract process, extract pump, and replicate.
• Performed Database refresh using expdp/impdp utilities.
NYK Line, NJ Jan 13 – Apr 14
Sr. Oracle DBA
Environment: Oracle 9i/10g/11g, Solaris 10, RHEL, AIX5.3, OEM/Grid, RMAN.
• Installed, Configured, Upgraded & Applied patches and bug fixes for Prod, Test & Dev Servers.
• Administered Oracle 11g/10g/9i production, test, development environment on RHEL, IBM AIX,
Solaris, HP UX.
• Provided 24x7on call support for all the Production,Staging,Integration and Development databases.
Madhu
• Upgraded databases, Oracle RDBMS 10g Real Application Clusters (10g RAC) to 11g Real
Application clusters on Linux (11g RAC).
• Responsible for configuration of 11gRAC, 10gRAC on Linux and Solaris using ASM and RAW
devices and Oracle CRS.
• Configured 11g R1 3 Node RAC for Data warehouse project with ASM environment.
• Administering ORACLE Databases 10g (10.2.0.2), 11g (11.1.0.7) with over 10 TB in size.
• RAC Troubleshooting(worked on RAC REIP, SCAN IP issue and DB Unknown issue).
• Worked extensively on monitoring 10G grid control database, configuration of error notifications,
installing listeners, and adding them to the grid control.
• Configured ASM and handled issues and suggested feasible workarounds for ASM Metadata
corruption.
• Experience in creating and managing physical and logical Standby database using Data guard for
HIGH AVAILABILITY.
• Experienced in performing manual recovery using archived logs, RMAN managed backup with or
without catalog, operating system backup, cold and hot backup, full backup, incremental and
cumulative backups.
• Installing ASM environment and migrating database from NON ASM to ASM.
• Configured and monitored RMAN backups in 11g OEM grid control and performed DATAGUARD
sync using RMAN whenever DR went out of SYNC.
• Implemented and managed optimum physical database design (tablespaces, datafiles, extents, redo
logs, archive logs) and assessed database capacity by monitoring online storage, growth and file system
space, in adherence to the Optimal Flex Architecture.
• Monitoring Day Day Backups, Log’s & recovering them as per the requirement. Utilized LOG
MINER Technology & applied Application Database Transactions on other Databases.
• Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and
use of Hints, Stored outlines, Statistics.
• Worked on OLTP systems having large numbers of users that are generally not skilled in query
usage and access the system through an application interface.
• Experience in Design and Development of Data warehousing (OLAP), Transactional Database
(OLTP) applications on Oracle 9i/10g/11g, Oracle Designer 6i, Sun Solaris, HPUX platforms.
• Supported development teams by providing SQL statement tuning and optimizing ETL procedures
and removing load and query performance bottlenecks by using tools EXPLAIN PLAN, AWR, and
TKPROF.
• Cloned schemas, objects and data on new server using exports from 10g database and imported in
11g using data pump.
• Responsible for capacity planning, database security, recovery planning and installing patches.
• Implemented Stream, Golden Gates for Active Active Replication between the Datacenter for High
Availability.
• Periodic data refresh from production to testing environments, Re organizing database structures
using the expdp/impdp utility on a very regular basis and Troubleshooting errors.
• Applied patches using OPATCH and Patch sets using OUI
Madhu
• Monitored the operating system response in terms of CPU usage, disk space, and swap space by
using various UNIX utilities like SAR, vmstat and top.
• Continuous review of Business critical Database to proactively identify space issues, performance
tuning issues.
• Expertise in Database Performance Tuning, Performance Monitoring and Optimization using tools
such as PL/SQL, Oracle Hints, SQL Trace, Explain plans.
• Implemented RMAN Backups, Creation of catalog database, Developed RMAN scripts and tuned
various parameters.
• Installed ORACLE Enterprise Manager (OEM 11g) GRIDCONTROL and configured it server
targets for a centralized monitoring system.
• Identifying performance issues by making use of diagnostic pack by generating AWR, ASH and
ADDM reports and resolved performance .
IBM India Pvt Ltd May 09 Dec 12
British petroleum
Oracle DBA
Environment: Oracle 8i/9i/10g, Solaris 9, Red Hat Enterprise Linux 4, HP UX, RAC, Windows 2003,
Grid Control, TOAD, and SQL developer.
Responsibilities:
• Implemented advanced features of Oracle 10g such as Automatic Database Diagnostic Monitor
(ADDM), Automatic Workload Repository (AWR) for monitoring database performance.
• Oracle Clusterware installed to provide infrastructure for RAC and configured 2 node Oracle 10g
RAC with ASM.
• Involved in Migration of Database from 9i to 10g and applying patches whenever required.
• Experienced in performing manual recovery using archived logs, RMAN managed backup with or
without catalog, operating system backup, cold and hot backup, full backup, incremental and
cumulative backups.
• Experience in Upgrading Dev and Test instances to 11g (11.1.0.7).
• Configured 10g 4 Node RAC for Data warehouse project with ASM environment.
• Installing ASM environment and migrating database from NON ASM to ASM.
• Configuration of system to achieve High Availability, Load balancing and automatic fail over
functionality.
• Successfully implemented Backup & Recovery using RMAN which includes hot backups and Cold
backups.
• Provided 24x7on call support for all the Production,Staging,Integration and Development databases.
• Experienced in configuration of 10gRAC on Linux and Solaris using ASM and RAW devices and
Oracle CRS and Veritas Net backup as a media management layer.
Madhu
• Worked extensively on monitoring 10G grid control database, configuration of error notifications,
installing listeners, and adding them to the grid control.
• Worked on configuring Oracle DATAGUARD and EMC Symmetric Remote Data Facility on
production server.
• Involved in the installation of 11gR1 RAC on LINUX environment.
• Involved in Migration of Database from 9i to 10g and applying patches whenever required.
• First line Oracle support on multiple platforms (HP UX, Linux, WIN, and AIX) with production
instances 30+, development instances 100+.
• Prepared a step by step installation document for the 11g RAC on Linux operating system.
• Implemented the Oracle HIGH AVAILABILITY databases using Data guard and Oracle 11g / 10g
RAC databases for various applications such as DW / OLTP on RHEL.
• Periodic data refresh from production to testing environments, Re organizing database structures
etc.
• Applied patches using OPATCH and Patch sets using OUI.
• Periodic data refresh from production to testing environments, Re organizing database structures
using the expdp/impdp utility on a very regular basis and Troubleshooting errors.
• Performed database cloning to setup test and development database.
• Expertise in Database Performance Tuning, Performance Monitoring and Optimization using tools
such as PL/SQL, Oracle Hints, SQL Trace, Explain plans.
• Developed RMAN scripts for database backup and recovery including hot and cold backup options
for both RAC and stand alone instances.
• Patch and Upgrade Oracle – All the databases are patched up to date with latest Oracle CPUs.
• Installed ORACLE Enterprise Manager (OEM 10g) GRIDCONTROL and configured it server
targets for a centralized monitoring system.
• Configured and monitored RMAN backups and performed DATAGUARD sync using RMAN.
• Identifying performance issues by making use of diagnostic pack by generating AWR and
STATSPACK reports and resolved performance.
• Good experiences with UNIX shell scripting.
NESS Technologies June 06 – April 09
Standard & Poor’s
Oracle DBA
Environment: Oracle 9i/8i, Sun Solaris, AIX, Windows 2003, TOAD, RMAN, OEM, ERWin Designer.
Responsibilities:
• Database Administrator for Production, Development and UAT databases and provided on call
production database support.
• Configured Physical Standby Databases.
• Installed ORACLE 9i/10g software’s on Windows and Unix Platforms.
Madhu
• Involved in Setup and Upgrade ORACLE 8i to 9i databases and ORACLE 9i to 10g databases.
• Wrote Stored Procedures and Packages in PL/SQL that are called by Java code to perform back end
processing.
• Creating primary database storage structures (table spaces, rollback segments, etc).
• Developed new PL/SQL programs – Triggers, Functions, Procedures and Packages to manage
various business functionalities.
• Involved in process improvement, Oracle Server Installations/Upgrades/Patches, Space
Management, Capacity Planning, Backup & Recovery, Disaster Recovery, Database Performance
Tuning, Memory Tuning, Application Tuning, Security Administration, Data Warehousing,
DATAGUARD, Oracle Advanced Replication, Real Application Clusters, Oracle standby services.
• Design and development of Database Objects and Users as per the business needs.
• Maintained control files, log file, data files, table spaces and rollback segments.
• Performed Database Tuning using STATSPACK and SQL trace utility.
• Scheduled cron jobs and database updates for reports generation, statistics collection and database
backups.
• Designed and implemented hot backups using a combination of incremental differential and full
backups using RMAN and Hot/Cold.
• Created tables, indexes, table spaces, users, integrity constraints and supported all phases of a
development cycle.
• Contributed to team effort by accomplishing related results as needed.
• Monitored Alert log and wrote scripts for quick health check of the databases.
• Responsible for optimizing the queries and application tuning.
• Controlling and monitoring user access to the database for new and existing databases.
• Involved in numerous Shell Scripting pertaining to the activities of the DBA.
• Using SQL*Loader, Export, Import in order to Extract and Load Data.
• Worked with database export & import scripts to backup database structures and automation
procedures.
• Generated daily, weekly and monthly reports regarding total revenue management.
NESS Technologies June 2004 May 2006
M&T Bank
Java/J2EE Developer
Environment: Java, J2EE (JSP, Servlets), Struts, Hibernate, Oracle 9i, Log4J, VSS, Java Script, Web Logic
8.1, Eclipse, Windows XP/Solaris 5.8.
Responsibilities:
• Used UML for the design phase of the Controllers (Use cases, class diagrams, and sequence
diagrams).
Madhu
• Involvement in supporting to customer as required.
• Analyzed CR’s (Change Requests) and prepared the impact & design document.
• Developed Hibernate Queries for the DAO module.
• Integration and deployment of EAR in Trifrok AS and OC4J.
• Maintained version control through CVS.
• Used Eclipse IDE for the development.
• Developed JSP pages and Struts for the GUI module.
• Worked extensively in HTML, JavaScript, and CSS.
• Done code reviews, bug tracking and defects solving.
• Used Log4j for logging the application errors and messages.
• Developed build scripts u
• sing ANT
• Used IntelliJ IDEA 8.0 IDE for the development.
• Developed JSP pages for the GUI module.
• Worked extensively in HTML, JavaScript, AJAX and CSS.
• Done code reviews, bug tracking and defects fixing.
• Used CVS 2.1.1 for version control.
• Done deployments of Web Applications developed in J2EE technologies in Web Logic 8.1 Server.
Contact this candidate