SUMMARY:

• 8+ years of experience inIT industry as an Oracle Database Administrator on different flavors of UNIX and Windows environments
• Experienced as Oracle DBA in production environments, Oracle performance tuning, SQL tuning and Real Application Clusters (RAC), specializing in tuning and monitoring for high availability
• Extensive performance tuning experience, specializing in instance tuning, Oracle RAC tuning and SQL Optimization.
• Extensive experience with designing and implementing Oracle databases, including systems architect, project management, data warehouse design, implementation and tuning.
• Administering and maintaining production apps 11i and OLTP, 24X7 production database support and maintenance.
• Experience on OracleGoldenGate 10.4.1 on AIX - Migration Oracle 9iR2 AIX 5 to 11gR1 AIX 6 Auditing an Oracle 11gR1 RAC (Linux)
• Administering production databases as large as 3TB on RAC installation
• Proficient in Oracle tools, Cloning and Patching
• Creating, Implementing and maintaining Backup policies for several database clusters
• Responsible for Database Cloning, Patch Application, Unix Shell Scripting, Backup& Recovery and Documentation. Installing and Configuring Oracle11g grid and Data Guardmaintenance in large environments.
• Creating database and database objects like table, index, table space, rollback/undo segments and views and analyzed relevant objects to collect statistics to tune the system performance
• Data loading using SQL*LOADER, logical backups using full export and DATAPUMP.
• Detecting and diagnosing production system performance tuning of the database - SQL tuning, used tuning utilities like STATSPACK, TKPROF, EXPLAIN PLAN, AWR, ADDM and Tuning of SGA, distribution of disk I/O, sizing of tables and indexes measuring system and database activity, querying Oracle dynamic performance views
• Database replication using snapshots, materialized views, import/export and advanced replication methods
• Experience in Oracle Golden Gate installation, configuration and troubleshooting Golden Gate issues
• Interacting with the Oracle support on Service Requests and implementing the solutions for successful completion of the tasks.
• Proficient working in various Operating Systems: Windows, Linux, Unix.
• Experience in Java build tools such asAntandMaven.

TECHNICAL SKILLS:

Operating Systems: Windows, UNIX, Linux, AIX

Middleware SOA Integration Products: JCAPS 6.3 & 5.1.3, eGate SRE 5.x, Glassfish ESB, MTS, IBM MQ Series, BMC PATROL WebSphere MQ 4.1, IBM Websphere MQ Explorer 7.1, MQ Visual Edit 1.6.4.1, Introscope

Languages/Integration: Java, XML, Web Services, JAX-WS (SOAP), JAX-RS (REST), XSD, JIBX

Oracle / Tools: Oracle 11gR2, 10g, 9i, SQL Server 2005 and 2008Oracle Products:Oracle10g (Grid Control), OEM (Oracle Enterprise Manager), RMAN, OEM 12C, SQL*Loader, Import and Export(EXPdp/IMPdp), ASM, TKPROF, SRVCTL, SQL* Loader and SQL * Net, Golden Gate.

Web Technologies: J2EE (Servlets, JSP, EJB), JDBC, AJAX, JQuery, JavaScript, AngularJS, HTML, CSS

Testing: Junit, Integration, Regression, UAT and Post-Production Testing

Framework: MVC Architecture, Jakarta Struts 1.1, Spring 3.1, Hibernate 3.1, JSF 2.0, Axis

QualityTools: Win CVS, CMVC, Tortoise SVN 1.8.4, Confidential Quality Center 10

IDETools: NetBeans 6.9, MEB 2013 (My Eclipse Blue 11.0), WSAD 5.x

Tools: and Packages: Ant 1.7.1, Apache Maven 3.0.5, Log4J, UML, RAD, FTP, MS Visio, BMC Remedy 7.5, Service Now, Requestit, Microsoft Solution Center, JIRA 6.0, Splunk, Atlassian Bamboo 4.3, Altova XML Spy, Access Now

Servers: WebLogic Server 10.3.5, IBM WebSphere Server 8.5 (WAS 8.5), Tomcat Server 7.x, Glassfish V2

PROFESSIONAL EXPERIENCE:

Confidential, NY

Sr. Oracle Administrator

Responsibilities:

• Oracle Apps Patching, Cloning, User/Responsibility/Menu creation/modification
• Oracle Sysadmin Support,Concurrent Manager issue troubleshooting
• Oracle DBA support, Production Health Check, Migration and Releases
• Maintaining the Mobile Web Applications,Maintain Oracle Applications using AD Utilities
• Used file handling in Oracle to read and write into files associated with the modules.
• Worked on SQL- Loader to load data from flat files obtained from various facilities every day.
• Created and modified several UNIX shellScripts according to the changing needs of the project and client requirements.
• Followed Agile methodology, accomplishing the tasks to meet tight deadlines.
• Maintaining and creating new Scripts for Monitoring and maintenance
• Involved in the continuous enhancements and fixing of production problems.
• Familiar with ADOP utility, and applied application patches
• Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• Worked on logical and physical database design using datamodeling tools like Navicat,Oracle data modeler.
• Worked on star schema, snowflake schema, facts and dimensions.
• Worked on building highly available systems using amazon web services.
• Worked on installing, upgrading and managing database clusters on amazon EC2 instances.
• Created reporting system, including data model and dictionary, ETL, and Web reports.
• Extensively worked with troubleshooting of reporting, and ETL issues with distributed teams.
• Created BFF (backup file format) packages for AIX to install third party tools.
• Wrote ksh scripts from system admin tasks.
• Installed & configured KVM guests RHEL5 & RHEL6
• Responsible for the AIX & RHEL Servers 3rd level support for 300+ servers
• Responsible for the development and support custom written UNIX shell scripts for automation.
• Responsible for the effective provisioning, installation/configuration, operation, and maintenance of systems hardware and software and related infrastructure, both physical and virtual (VMware), in a Windows and AIX/Linux/Solaris environment.
• Worked on Installation - AIX including PowerVM, AIX with PSSP (SP), BSDI, Linux
• Upgraded the SP2 several times - it is now a 33 node SP2 running AIX 4.2.1 and 4.3.1 and PSSP 3.1 and 2.4
• Worked on Performance Tuning and Capacity on all brands of UNIX but specifically AIX
• Worked on Performance and security for AIX and VIOS
• Created, and maintained AIX vio servers, and LPARs inAIX 5.3, and AIX 6.1.
• Wrote Korn and awk scripts to analyze security of AIX pSeries boxes.
• Worked on Securing AIX systems and implementing TCP Wrappers and Secure shell.
• Developed PL/SQL triggers and master tables for automatic creation of primary keys.
• Handled JSP compilation and worked on remote applications
• Actively participated in R12 upgrade with 4 member team
• Production Support for SOA and Agile Applications
• Developed Maven Script for the build and dependency process.
• Monitored and scheduled the UNIX scripting jobs.
• Version Controlwas mandated throughSubversion.
• Performed Unit Testing UsingJunit.
• ImplementedLog4Jto trace logs and to track information.
• Created PL/SQL scripts to extract the data from the operational database into simple flat text files
• Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus.

Environment: Oracle 10g, 11g, Oracle Enterprise Manager, ASM, AIX, Database Control, TOAD, OEM 11g r2/12c, Data Guard, Siebel eScript / VB script, SQL, PL/SQL, Shell script

Oracle Administrator.

Responsibilities:

• Implemented various customized Oracle reports using different techniques in Oracle sql/pl-sql.
• Analyzed and converted application requirements into functional design.
• Regular database activities, backups monitoring, issue resolving through Remedy.
• Backup and restoration of database schemas/tables by EXPDP and IMPDP.
• Worked in ASM databases.
• Worked on Oracle ERP modules including; PIM, Agile PLM, CRM, Service Management, Financial Management, HR, Project Management, Procurement and Supply Chain Management, SOA and XMLGateway; both functionally and technically.
• Worked with clients to create custom datamarts with Oracle ERP.
• Converted existing Oracle BI Discoverer reports from Oracle ERP Apps 12.x to Tableau.
• Worked with the Data Warehouse team using the existing ETL tool for modeling and importing Oracle ERP Financials data.
• Monitored TEMP tablespace, monitored alert logs for errors, Identify CPU issues in the Middle tier and eliminated them.
• Coordinated and interfaced with Oracle support for issues.
• Performed Database point Upgrades
• Used several Oracle predefined functions NVL, NVL2, DECODE, CASE STATMENT.
• Worked on inline and correlated sub queries based on business context.
• Performed number of dev, test and stage cloning from PROD databases.
• Added database triggers to some history tables of the database.
• Involved in working on Oracle Pseudo columns like ROWID, ROWNUM, SYSDATE, SYSTEMTIMESTAM, USER etc.
• Experience in using various oracle pl/sql collections VARRAYS,NESTED TABLE, ASSOCIATIVEARRAYS with INDEX BY VARCHAR2
• Involved in creating various utility scripts to generate log files in UNIX using shell scripts.
• Assisted in migrating IVMs, and VIOS servers on Power-6, and Power-7.
• Migrated LPARs on IVM, and VIOS from local storage to SAN storage including setting up redundancy.
• Contract to implement security, AFS and SSH on AIX 4.3.3
• Performed VIOS OS updates.
• Performed partitioning of tables in datawarehouse environment.
• Managed and monitored the data guard, Creation Of core Databases.
• Restored unknown backup to create new Databases for Corporate applications.
• Managed tablespaces and other database objects.
• Support and Maintenance of over 4000 core Databases for CISCO.
• OEM monitoring for CISCO databases.
• HandledPSU and CPU new releases and applied the recommended patches .
• Managed RMAN reports and oracle version mismatch.
• Created unit test scripts withJUnittool for covering code in various modules.
• UsedLog4J to log various events and exception when performing various transactions by the users for debugging purposes.
• Used Subversion/SVNas a version control and source repository system.
• Implemented the Maven framework to ease the development, build and dependencies management thus saving huge development time to the organization.
• Created Oracle objects like tables, types, packages, procedures and functions.
• Provided Production Support by interacting with the testers and fixing bugs.

Environment: Oracle 10g, 11g, Oracle Enterprise Manager, ASM, AIX, Database Control, TOAD, OEM 11g r2/12c, Data Guard, Siebel8. Client Application Configuration, SiebelEIM and EAI (Inbound and Outbound Web Services), eScript& Administration and Workflows

Confidential, Charlotte, NC

Oracle DBA

Responsibilities:

• Involved in developing modules in Javato create cases based onvarious visual charts like bar/line charts using custom MVC frameworketc.
• Extensively used DTS package in Migration of the data from the previous timesheet database in SQL Server database to Oracle 10g.
• Extensively involved in tuning the queries and applying hints for faster and better performance of the SQL queries.
• Involved in developing screens and generating reports.
• Implemented various UNIX scripts to generate the data in CSV format.
• Tuned several Oracle SQLstatements using Explain Plan, Auto Trace utilities.
• Created the PL/SQL packages, procedures, functions applying the business logic to update the database.
• Handled production tickets/defects and solved problem with in time frame with accurate decisions and identified the root cause and fixed the same.
• Proficient in RAC Performance Tuning.
• Performance tuning of queries consuming excessive resources or slow running queries by providing required hints to the query.
• Supported development effort by providing SQL statement tuning and optimizing ETL procedures and removing load and query performance bottlenecks by using Explain Plan.
• Was responsible for monitoring database, diagnosing errors, building, deploy, maintain and trouble shoot database objects.
• Expert Confidential database tuning, application tuning and performance monitoring. Fine tuning Initialization parameters, I/O, memory and operating system kernel parameters.
• Managed appropriate use of free space within tablespaces, reclaimed space whenever possible. Reorganized tables and indexes within databases when needed.
• Monitored system resource availability and responded to system memory and data issues.

Environment: Oracle 10g, 11g, Oracle Enterprise Manager, ASM, AIX, Database Control, TOAD, OEM 11g r2, Data Guard.

Confidential, Hartford, CT

Responsibilities:

• Involved in Design, Development and Support phases of Software Development Life Cycle (SDLC).
• Ensured high availability and performance(24 hrs production support)
• Ongoing proactive database-level performance tuning and pro-actively monitor database systems to ensure secure services with minimum downtime
• Managedall database objects in a large mission critical system and provided end to end DBA support system and application side.
• Analyzed and resolved complex technical problems regarding the integration of object-oriented applications and infrastructure with relational database technology.
• Monitored databases and performs tuning enhancements to optimize their performance. Developed and maintained utilities to automate problem determination, change implementation, and monitoring activities.
• Participated as a team-member in data management strategies. Integrated data architecture with appropriate components of the extended enterprise, transaction factories, and the data warehouse.
• Helped my team to use existing infrastructure to achieve maximum benefit to reduce cost and maximum performance.
• Changes were made dynamically whenever possible to fulfill high-availability requirements
• Was responsible for implementation and release of database changes as submitted by the development team.
• Interacted with development teams, business owners, and various levels of management.
• Participated in data-sourcing, import and data validation activities.
• Provided database change and release management.
• Coordinated all Oracle system changes with the Operational DBA teams.
• Enforced need of regular data purging processes from production, design and development, to deployment.
• Was responsible for two critical online applications database’sperformance which has a hugebusiness/revenue impact

Environment: Oracle 10g, Oracle Enterprise Manager, ASM, AIX, Database Control, TOAD, Data Guard.

Confidential. Austin TX

Oracle DBA

Responsibilities:

• Responsible for database administration for a large and complex database system using Oracle6 and Oracle7, IDMS, IDMS/R and DB2.Responsibilities included performance & tuning, database design, data modeling, database installation, technical support, and investigation of new technologies.
• Installed Oracle DB 10g, 11g RDBMS, RAC on ASM, Applied Oracle critical patch updates, Implemented and Managed Data Guard, Replication, Backup and Recovery support and performance tuning
• Migrated Non-ASM databases to ASM environment for high availability using RCONFIG.
• Worked troubleshooting RAC and implemented ASM features.
• Applied necessary patches during installation and also in up-gradation of databases.
• Resolved the issues in conflicts between the target and source database in Goldengate.
• Migration of databases from using export/import and data pump export/import utilities and performed database refresh activities for business requirement and tuning purposes.
• Having good experience in user management, table space management, session management, undo management issues.
• Used datapump for schema refresh, and RMAN for database refresh and for backing up databases
• Well Experienced in taking cold backup for a very huge 15-Tb Database.
• Experienced in user management, table space management, session management, undo management issues.
• Experienced in managing space issues in the database level for table space and regular file system cleanup Confidential UNIX level.
• Generated AWR, ADDM and ASHreports for database issues

Environment: Oracle 10g, 11g, Oracle Enterprise Manager, EXADATA X2-2, ASM, AIX, Golden Gate, Database Control, TOAD, ASM, AIX, Golden gate, Tivoli