Jini Mathew

Cell: +1-331-***-****

Email: acznos@r.postjobfree.com

Certified Oracle EBS Applications DBA

PROFESSIONAL SUMMARY

* ***** ** ** ********** as Oracle Application DBA, Oracle DBA this includes Oracle database production support and Application Production Support, WebLogic administration, data ware housing technology etc.

Working with Accenture supporting various Clients and Leading Onsite and Offshore DBA Team.

Provided 24/7 support and on call as required for different projects.

Experience in administering oracle databases 10g, 11g and 12c.

Strong experience on the administration of E-Business application versions 11i, R12, R12.2

Have good understanding of the internals of the Oracle concurrent manager and understand how to monitor and tune Oracle E-business suite Applications.

Experience in Cloning, export/import, exp/imp, sql loader and Patching.

Experience on R12.2 upgrade of e-business suite application.

Experience in Middleware application support such as WebLogic products, SOA, BPEL, JBOSS etc.

Took Backups on scheduled time and monitoring scheduled Backups

Performed backups and recoveries using RMAN conventional hot backups.

Established and Document Backup and Recovery strategies and procedures after evaluating various options including RMAN.

Creating and implementing Disaster Recovery Plan.

Experience in performing regular Backups and scheduling tasks.

Cloning of Ebiz Application and Databases.

Administering Large Databases from capacity planning to database design and maintenance.

Maintenance of Oracle RAC databases.

Performing code deployments in PROD to make the new changes once deployed and tested in lower instances.

Cloning (Refresh) from PROD to lower instances on regular intervals.

Managing Security (Creating and dropping of users, granting and revoking rights as and when required).

Perform day-to-day break-fix, troubleshooting, performance tuning etc.

Monitoring Database performance and optimizing performance.

Experience AWR reports, Wait events and also Performance issues of long running jobs.

Used TKPROF, EXPLAIN PLAN and AWR, statspack for the Better Database performance.

Experience in analyzing long running slow queries and tune the same to optimize application and system performance.

Experience in configured High Availability like Datagurad and RAC.

Experience in ASM administration.

Migrated existing databases into RAC configuration.

Providing connectivity and troubleshooting of connectivity problems.

Creating Weekly and Monthly analysis reports for the Database Growth and Performance Statistics.

Participation of team meeting on a by-weekly basic for a discussion on the ongoing activities.

Perform Oracle Application DBA responsibilities as needed.

Having Good knowledge in Oracle WebLogic Administration.

Good experience in OBIEE and ODI administration.

Applying patches on Apps and databases.

Experience in Database and OEM upgrades.

Experience in golden gate.

Provide operational support to all Oracle database servers in development, testing, and production environments.

Worked as informatica tool admin(ETL Administration) for archiving and purging for production data.

OEM 12c administration and monitoring databases through OEM.

Strong experience in Client interaction and understanding business applications, business data flow and data relations for them.

Expertise in writing UNIX shell scripts to automate daily manual tasks of DBA.

Experience in perl scripting.

Implemented automated backup strategy using the UNIX shell script.

Experience in patching of oracle database and applications.

Experience in online patching of R12.2 E-business suite application.

Experience in writing SQL and PL/SQL codes.

Experience in Jenkins tool for automating the deployment and testing.

Experience in SOAPUI for web service testing.

Experience in SQL server administration.

Analytical and Communication skills, planning and Co-ordination skills, Experience with project management.

TECHNICAL SKILLS

Operating Systems

UNIX and SOLARIS, RHEL

Databases

Oracle 11g

Applications

Oracle Apps 11i and R12.1,R12.2

Languages

SQL and Shell scripting

Storage Technology

Oracle ASM

Middleware

Oracle WebLogic server, BPEL 10g, OBIEE,JBOSS etc

Clustering Technology

RAC

Utilities

Export/Import, SQL Loader

Development and Administration tools

OEM 12C, SQL Developer

PROFESSIONAL EXPERIENCE

Organization

Accenture USA

Project

Logistics Managed Service

Client

Sprint

Duration

March 2016 - March 2017

Location

Kansas city,USA

Role

Oracle Application DBA, Oracle DBA lead onsite

Sprint is one of the leading wireless providers, the third largest wireless telecommunication network in the United States, with 51 million customers. My role was to provide support for production, development and test environment with respect to installation, availability, reliability, and integrity of database systems. Worked as the lead, interacting with clients and coordinating with offshore teams.

RESPONSIBILITIES:

Managing and administering 24/7 production databases, development and test instances.

Working on client location, interacting with clients and coordinating with offshore team.

Administering very large (near to 10TB) databases.

User Management which includes create and maintain users and roles, Granting of privileges etc.

Maintained and administered oracle database security by granting and revoking system/object

Privileges, roles, auditing user actions in the database.

Developed and implemented new UNIX shell scripts for various tasks such as automated the

System health check and send summary email to clients daily.

Developed perl scripts to automate the deployments .

Write shell scripts to automate daily tasks and schedule in cron .

Developed PL/SQL codes such as triggers to prevent some datatypes beings used while creating

Tables in database.

Assisted functional team to automate their daily manual works to automate and send mail alerts

Using UNIX shell scripts.

Conducting sizing and capacity planning for oracle databases which includes analyzing the

Storage on year end for mount points and ASM disk groups to find the growth and requested additional space for the coming year accordingly.

Used Automatic Workload Repository (AWR) & Automatic Database Diagnostic Monitor (ADDM)

in RAC for Performance Tuning.

Generated AWR reports from Oracle database and analyzed the reports for Oracle wait events,

time consuming SQL queries, tablespace growth, database growth etc.

Ensuring security of the database by creating profiles and monitoring user sessions.

Handle day-to- day DBA activities using Oracle utilities and tools, monitoring space and memory

Requirements.

Checking Alert Logs, Archive Logs, Trace files, backup verifications & Health checkups of database.

Cluster maintenance of RAC and ASM.

Good understanding of server cluster technique.

Maintenance of concurrent processing requests and concurrent managers.

Interact with functional team; define responsibilities, menus, request groups, users.

Handle multi-tier architecture: Desktop tier, Application tier (Web server, Form server, and

Concurrent processing server and Administration server) and Database tier of E-business suite application.

Use different Oracle E-business suite Applications tools like adop,Adadmin, Adctrl, Adpatch

etc for maintaining Database and applications.

Identify the impact of patches though using patch analyzer, apply latest releases of the

Application patches from Oracle on Production, and test instance to resolve application issues.

Coordinate in resolving various performance issues by tuning SQL query and provided tuning

Recommendation to ERP jobs, time/CPU consuming queries etc.

Experience of execution plans and how to use them to optimize/improve query costs and create

new indexes.

Monitor trends in the application: thresholds, locks and contentions; memory allocations.

Configure and tune hardware and software to insure optimum performance and resource

Utilization.

Database analysis and updates for functional releases on the Oracle database.

Maintain and update stored procedures.

Analyze Oracle ADDM, AWR, ASH reports as well as database configuration to research and resolve database or application issues.

Manage activity between the application and DB tier

Ad-hoc SQL support.

Coordinate with Oracle vendor to resolve software/database issues.

Code deployment for custom development from Development, TEST, PROD instances.

Weekend maintenance of the production, which includes application, and cluster bounce.

Checking the data guard sync report, analyzing, and fixing the gaps.

Monitor the critical programs and identify the issues of failures.

Worked on SSH configurations as part of automated file transfer from one server to another.

Using OEM 12c for system monitoring which includes activities such as managing groups, incident rules, managing targets etc.

Purging and re-org of tables on regular intervals. Identify the tables eligible for purging and

Re-org to improve the performance.

Cloning (Refresh)of test instances from PRODUCTION on a regular basis using RMAN restore,

Duplicate etc. for database.

Scheduled and monitoring of RMAN backups on a daily basis on production and weekly basis on

Test instances.

Document the process and steps involved for day to day activities of DBA and share with the

Team. Prepares Standard Operating Procedure document for new and modified systems, environments, or databases.

Archiving and purging of tables via Informatica tool. Using the scheduled jobs in informatica to

Archive the system data older than 10years in production and another set of jobs to purge 5year

Old data from archive database.

Administration of Informatica tool such as user access accounts, roles, setting standards etc.

Perform Informatica software upgrades as needed.

Proactively monitor development, test and production Informatica implementation servers.

Provides technical consulting on complex projects considering ETL best practices & desired

results.

Provide user support by investigating issues/problems, enforcing standards, and answering

Inquiries.

Works with different teams to ensure best practices for code development are followed and

optimal configuration of ETL infrastructure.

Troubleshoots performance issues with Informatica software & code as needed.

Administration of middleware applications such as JBOSS and BPEL application.

SSH configuration for making automated file transfer between servers by copying authorized

keys etc.

Supporting DEVELOPMENT team to help them with their development activities which includes

Creating PL/SQL programs such as packages, procedures, functions, triggers, etc.

Patching on all the quarter releases for database.

Interface with Oracle Corporation for technical support.

Weekend maintenance of production instance which includes code deployment and system

Bounce.

Use expdp/impdb tool to export and import of tables, schemas etc.

Working on R12.2 upgrade of oracle E-business suite application.

Experience on R12.2 online patching of E-business suite applications.

Trouble shooting of issues related to DB ad Application to find the root cause of the issue and

Prepare RCA document for the same to present to client.

Environment: Oracle Database 11g with RAC, Dataguard and ASM, Apps 11i with shared appl_top and PCP, BPEL10g, JBOSS, OEM12c.

Organization

Accenture India

Project

CalHEERS

Client

California Health

Duration

June 2012- Feb 2016

Location

Bangalore, India

Role

Oracle Application DBA, Oracle DBA, Oracle WebLogic Admin,Datawarehosing etc.

The California Healthcare Eligibility, Enrollment, and Retention System (CalHEERS) is an automated system that serves as the consolidated system support for eligibility, enrollment, and retention for the California Health Benefit Exchange (also known as Covered California), Medi-Cal, and Healthy Families. Streamlines resources from which individuals and small businesses will be able to research, compare, check their eligibility for, and purchase health coverage. Worked as Oracle Application DBA and WebLogic administrator. Supported R12 apps and different WebLogic applications like OIM, OAM, Webcenter etc. and 11g databases.

. RESPONSIBILITIES:

Managing and administering 24/7 production databases, development and test instances.

Administered large 11g and 12c databases.

Administering of Oracle E-business suite application R12.1 which includes, administering concurrent request, concurrent manager, patching, cloning etc.

Worked on the administering of different WebLogic products and OBIEE&ODI.

Experience in OSB and SOA.

OEM agent installation, adding targets to OEM and monitoring.

OEM 12cR3 upgrade to OEM12cR4.

Database upgrades from 11.2.0.2 to 11.2.0.4(11g).

Ensuring security of the database by creating profiles and monitoring user sessions. Handle day-to- day DBA activities using Oracle utilities and tools, monitoring space and memory requirements.

Checking Alert Logs, Archive Logs, Trace files, backup verifications & Health checkups of database.

Monitor system for invalid objects

Cluster maintenance of RAC and ASM.

Experience with Dataguard and golden gate.

Adpatch and opatch on different test instances of applications and databases.

RMAN backup, restore, duplication of databases.

Cloning of applications and databases.

Installation, configuration, administering of different WebLogic products.

Document the process and steps and pass it to the team. Prepared Standard Operating Procedure documents for new and Modified systems, environments, or databases.

Regular cloning(Refresh) of TEST instances using RMAN for databases.

Automated the day to day activities using unix shell scripts.

Automated the application deployments using perl scripting.

Perform application tuning and performance monitoring

Interface with Oracle Corporation for technical support.

Patch Management and Version Control.

Assist developers with database activities.

Weekend maintenance of production and test instances.

Collaborate with application teams to design database solutions.

Monitor application related jobs and data replication activities

SQL coding to help developers and migration of objects across instances.

Patching on all the quarter releases for database.

Create database objects (tables, indexes, etc.)

Worked on SSH configurations as part of automated file transfer from one server to another.

Troubleshoots with problems regarding the databases, applications and

Development tools.

Interact with different application teams to fix the P1 issues in PRODUCTION.

Coordinate with Oracle vendor to resolve software/database issues

Weekly status reports.

Analyze Oracle ADDM, AWR, ASH reports as well as database configuration to research and resolve database or application issues.

Work with design teams and create/clone new test instances for new releases.

Worked on the administration of OBIEE and ODI which includes installation, deployment etc.

Experience with Jenkins tool, worked to automate the deployment and web service testing of various WebLogic products.

Experience in SOAPUI testing, which is used as a basic web service testing after the deployment and before releasing to the testing team.

Environment: Oracle Database 11g with RAC, Dataguard and ASM, Apps R12, WebLogic 12c products, OBIEE11g, ODI11g. OEM12c.

Organization

Accenture India

Project

Cardinal Health, Winter Park

Client

Cardinal Health, Winter Park

Duration

June 2011- June 2012

Location

Bangalore, India

Role

Oracle Application DBA, Oracle DBA,Oracle WebLogic Admin,Datawarehosing etc.

The MOH Holdings (MOHH) is the holding company of Singapore's public healthcare entities. It also acts as a strategic partner to Ministry of Health (MOH), in ensuring the smooth implementation of healthcare policies across public healthcare institutions.

RESPONSIBILITIES:

User manager management on Oracle Database and applications.

Worked on the management of 11g databases.

Worked on the administration of Oracle E-business suite application R12.1 which includes patching, cloning etc.

Documented new system and created the entire Database Runbook(Standared Operating Procedure) documents.

Experienced in Export & Import user level, tablespace level, and database level.

Monitoring & Managing the Tablespaces and Datafiles growth.

Monitoring locks and various sessions using OEM.

OEM agent installation.

Control database privileges and Managing user Accounts.

Creating and administrating database objects like table, views, indexes etc.

Coded UNIX shell scripts to execute Oracle Custom Packages.

Deployment of new code and Oracle Apps and WebLogic products.

Coordinate and perform migration of data and database objects between environments.

Worked actively with Oracle metal ink to identify and fix new issues.

Adpatch and opatch on different test instances of applications and databases.

RMAN backup, restore, duplication of databases.

Checking Alert Logs, Archive Logs, Trace files, backup verifications & Health checkups of database.

Monitor system for invalid objects

OBIEE and ODI administration.

Interact with application teams to fix the application related issues.

Performs ongoing tuning of the database instances.

Complete DBA support in DEV, TEST instances.

Ensure database consistency and integrity

SQL and PL/SQL coding with DEV team.

Code deployment in DEV, TEST and once finalized deploy to PROD on weekend.

Troubleshoots with problems regarding the databases, applications and

Development tools.

Provides technical support to application development teams.

Plans and implements backup and recovery of the Oracle database.

Worked on different ad utilities to handle application related activities.

Evaluating Oracle features and Oracle-related products.

Performing monthly and annual performance reports for trend analysis and capacity planning (Plan for and monitor database space usage).

Interface with Oracle Corporation for technical support.

Managing and administering SQL servers.

Environment: Oracle 11g database with ASM, Apps R12, WebLogic 11g, OBIEE11g, ODI11g, OEM12c.

Organization

Amal Jyothi

Project

HMS (Hostel Management System)

Client

Amal Jyothi college hostel

Duration

June 2010- June 2011

Location

Kerala

Role

Oracle DBA

HMS is hostel management system, to get record of all the members in the hostel and manage all the activities like rental, member change etc was established by one of the leading college hostel in India.

RESPONSIBILITIES:

User manager management on Oracle Database and applications.

Installation, creation and configuration of Oracle Database.

Monitoring & Managing the Tablespaces and Data files growth.

Checking Alert Logs, Archive Logs, Trace files, backup verifications & Health checkups of database.

Code Migrations.

Writing shell scripts to automate the day-to-day works.

Provides technical support to application development teams.

Plans and implements backup and recovery of the Oracle database.

Assist developers with database activities.

Interface with Oracle Corporation for technical support.

Performs ongoing tuning of the database instances.

Coded UNIX shell scripts to execute Oracle Custom Packages.

Create database objects (tables, indexes, etc.)

Collaborate with the technical and functional team to understand the business and performance requirements to help define a detailed sizing of the infrastructure components required to support the implementation.

Create, update and Document Standard Operating Procedure (SOP) docs for Production DBAs for new features released to production

EDUCATION - Bachelor of Technology, Information Technology Engineering, India 2011

Contact this candidate