Oracle Project
Resume:
Koushick P
Email: aboc24@r.postjobfree.com, Phone: +91-988*******
Experience Summary
. Working as an IT analyst with Tata Consultancy Services since Nov,
. Worked as a oncall DBA for Motorola having more than 1500 database who
is a client of TCS.
. Worked in Motorola Head office in Schaumburg, Chicago and co-ordinated
with clients to provide support on an onsite-offshore model.
. Worked in oracle reports and oracle ERP in initial part of career.
Business Area:
Domain : Telecom
Technical Specialization : Oracle DBA. (Versions: 8i, 9i, 10g,
11g)
Qualifications
Degree and Period Institute Major and
Specialization
Bachelor of Madha engineering Information Technology
Engineering (2001 - College,
2005) Anna University
Professional Memberships / Certifications
Professional Society / Certification Member Since / Date
Certified
Oracle Certified Associate (Oracle 9i) 2007
Project Thesis 1:
Feb 2008 - to till date.
Database support services (Oracle DBA - Offshore Shift lead):
. Worked as Oncall DBA to support and manage more than 1500 Oracle
databases of Motorola from Offshore.
. Monitoring long running jobs in oracle database and checking the
reason for long running and providing the fix to the application team.
. Performed role as team lead to manage the shift during oncall
activities.
. Responsible Space management and capacity planning for the databases.
. Create and maintain users and roles, assign privileges.
. Daily co- coordinating with the Client manager with status call and
giving solution for the day to day problem faced by the Business
users.
. Maintaining ASM disk groups and creates table space and data files.
. Maintaining RAC databases and monitoring long running jobs in OLAP
environments.
. Analyzing the execution plan for SQL queries using EXPLAIN PLAN and
TKPROF utility and creating necessary indexes to improve the
response time
. Providing permanent fix to the frequent occurring issues in various
databases by scheduling various jobs in Cron.
. Creating Users, Roles, Profiles and Auditing of users according to the
application Requirements.
. Monitoring RMAN backup and fixing issues on backups.
. Monitoring DR's of various versions (oracle7, 8i, 9i, and 10g) and
then work on the DR's that are not in sync with production.
. Well versed with ITIL process as I have worked on various change
requests and presented to the client the change request details.
. Worked in Motorola Schaumburg office in Chicago as a Oncall DBA for
motorola based on onsite-offshore model.
. Doing DR rebuilds.
. Managing DR site and applying lags log and sync the database
. Analyzing Backup Failure and sent to the RCA to customer
. Monitoring the OEM Alert and analyzing the CPU and Memory utilization
of the database Sever
. Applied CPU patches to database.
. Daily coordinating with the Client manager with status call and giving
solution for the day to day problem faced by the Business users.
. Taking Export, Hot backup, and monitoring RMAN backups and fixing
errors.
. Applied CPU patches to database.
. Applied pre and post requisite patches (Application Patches) for
Oracle Apps
. Analyzing Backup Failure and sent to the RCA to customer
. Migrating database using transportable table space for different OS
platform.
. Analyzing AWR & ADDM report for database performance issues.
. Data migration using transportable tablespace option in oracle 10g.
Project Thesis 2:
Sep 2007 - Feb 2008
Database support services (Oracle DBA - Motorola, Onsite, Schaumburg):
. Working with clients to schedule the change requests for the coming
month as per the ITIL process.
. Working with application team leads on their frequently occurring DB
issues and providing permanent fixes where ever possible.
. DB refresh and DR rebuild.
. Working with SOX team to check for any violations as Motorola has
many SOX level 1 database.
. Providing Oncall Support during onsite window.
. Presenting the weekly status report to clients.
Project Thesis 3:
Jan 2007 - Aug 2007
Motorola Offshore Oncall support
. Taken up the On Call DBA Responsibilities (L1 & L2 support)
. Involved in the weekly & Monthly maintenance activities like Re-org of
tables and scheduled activities.
. Refreshing the Test and Development database with Production Database
on customer requests.
. Applying database and application related patches by working with
Oracle assistance.
. Having experience in creation and maintenance of the users along with
security roles and privileges in production.
Project Thesis 4:
Aug 2006 to Jan 2007
Motorola Chennai Oracle ERP Phase II: Oracle reports:
The objective of this project is to make modifications to the existing code
in order to enable the new org id to function to be a part Motorola's ERP
system. Motorola opened a new manufacturing centre in Chennai. Hence all
the existing code needed to be modified so that the new organization can be
included in the
Motorola's ERP system.
. Prepare oracle reports for the new factory.
. PL/sql code change to in-cooperate the new org id in the Motorola ERP.
. Make modifications to a optio file so that it can be used to print
orders in the new Chennai Organization.
. Create new optio file that will send the report output as a mail.
Project Thesis 5:
Jan 2006 to July 2006
CMWSSB (Chennai Metropolitan Water Supply and sewage supply board) Rollout.
The objective of this project is to Roll out the oracle applications in
CMWSSB. New oracle reports needed to be created as part of Chennai The
reports needed to be modified as per the users request and certain
functionality has to be changed in order to make the required changes.
. Work on Oracle D2k reports and and modify pl/sql's for the rollout.
. Work with the customers to modify the existing oracle reports as per
the requirement.
Personal Details
Date of Birth 20-01-1984
Nationality INDIAN
Gender Male
Marital Status Single
Date of Joining TCS 28-Nov-2005
Designation IT Analyst
Email aboc24@r.postjobfree.com
Contact this candidate