SUMMARY

• Over 10+ years of experience in Information Technology.
• 8+ years experience as an Oracle DBA on Linux, UNIX operating system environments.
• 2 Years experience as 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.
• Knowledge on Cassandra database.
• 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.
• Good Knowledge on Oracle 12c new features.

TECHNICAL SKILLS

Data Bases: Oracle (8i, 9i, 10g, 11g,12c). Cassandra

Operating Systems: Sun Solaris, IBM AIX, HP-UX, Windows 2000/2003/2008 , Windows NT, RedHat Linux.

Programming Scripting Languages: C, C++, C#, Java, J2EE, SQL, PL/SQL, Shell/Perl scripting.

Tools: and Utilities: Oracle OEM 12c,11g,10g Grid Control, SQL*Loader, RMAN, Toad, SQL Developer, LogMiner, Statspack, AWR, ADDM, ASM, TKPROF, Data-pump, DBCA, DBUA, Golden-Gate.

Application Server: IBM WebSphere, weblogic, Tomcat. Apache etc.

PROFESSIONAL EXPERIENCE

Confidential, NC

Sr. Oracle DBA

Environment: Oracle 10g/11g/12c, RHEL 5, AIX 6.1, OEM/Grid, Weblogic 10g

Responsibilities:

• 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, Dev and QA 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.
• 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.

Confidential, NJ

Sr. Oracle DBA

Environment: Oracle 9i/10g/11g, Solaris 10, RHEL, AIX5.3, OEM/Grid, RMAN.

Responsibilities:

• 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.
• 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
• 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 .

Confidential

Oracle DBA

Environment: Oracle 9i/10g/11g, 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.
• 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.

Confidential

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.
• 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.

Confidential

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).
• 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.