Oracle Database administrator with two years experience

Objective -

Seeking a position to utilize my skills and abilities to the best in

the Information Technology Industry that offers professional growth while

being resourceful, innovative and flexible. I aspire to deliver the best in

whatever is the task being assigned to. I purely believe in the fact that

continual learning and dedication is the key to success. Thereby, I work

keeping growth as the sole target.

Professional Experience -

Two Years of experience in IT Industry working as a Primary Oracle

DBA & Secondary skills (dual responsibility) on CA Service Desk Tool

Reporting (Crystal Reports, Infoview, etc.).

Overall Experience Summary -

. Experience in maintaining, administrating, managing and

troubleshooting 10g /11g and RAC 11g enterprise databases.

. Creating, customizing and scheduling a variety of reports for the CA

Service Desk system which acts as a ticketing tool for the project

operations/tasks.

. Supporting 24/7 Production & other critical Environments.

Technical Profile:

Operating Systems : Windows, REDHAT Linux.

Database : Oracle 10g, 11g.

Database Utilities : OUI, OEM, SQL*PLUS, 11g GRID, TKProf, Imp/Exp,

RMAN

Programming Languages: C, C++, SQL and PL/SQL.

Oracle Certifications:

. Oracle Certified SQL Expert (1Z0 - 047).

. OCA 11g (Oracle Certified Associate 11g).

Work Experience -

Overall Experience: 2+ years (from: 04th Sept 2012 till present date)

Company: Cognizant Technology Solutions (P) Ltd.

Project: Allegis Group.

Role: Level 1+ DBA - analyst and support.

Description of the project:

Allegis Group, headquartered in Hanover, Maryland, United States, is

one of the largest privately held staffing companies in the world, with

$8.28 billion in revenue in 2012.

Founded in 1983 by Steve Bisciotti and Jim Davis, the company, and

then known as Aerotek, originally focused on providing technically skilled

people to the expanding engineering and aerospace industry.

Allegis Group currently has over 300 offices in the United States and

also does business through several operating companies.

Responsibilities & Tasks -

Technical Front:

1.) DBA front -

(a) Monitoring:

. Monitoring of CPU, I/O, Logs and fragmentation.

. Monitoring of Oracle Errors (ORA-ERR) and resolving it.

. Used different v$views to study the database activities.

0. Monitoring Optimizer Stats jobs to enhance performance.

(b) Administration:

. Creating and managing DB User accounts.

. Granting, revoking Privileges & Roles for DB Users.

. Managing Tablespace(s) and Quotas.

. Creating & administering user profiles.

. Setting threshold limits for Metrics predefined.

(c) Implementation:

. Creating and upgrading DB's as per business requirement through DBCA

& DBUA.

. Configuration of Listener through NETCA.

(d) Backup:

. Taking Exp/Imp, Cold & Hot backup of the database regularly.

. Taking RMAN backups of the databases regularly.

(e) Refresh/cloning:

. Moving data between database using utilities like Export/Import.

. Performed cloning of a database to generate reports.

(f) Tuning:

. Evaluate the performance of SQL statement using oracle utilities.

. Frequent interaction with Developers, and working with them in

developing the applications using SQL Trace and Explain Plan

utilities.

2.) CA Service Desk Reporting Front

. Creating and customizing the reports as per business requirement.

. Scheduling reports in Infoview on demand basis.

. Work on fetching Proactive SLA Measure, Backlog Report,

Monthly/Weekly/Daily Ticket Reports, On Demand Reports shared with

client.

Process Front:

. Managing Project Daily Dashboard and others reports referred by

management.

. Performing periodic ticket audits and working towards process

improvement.

. Creating and managing knowledge base documents in form of SOP's,

KEDB's

. Proposing best practices & CSI's keeping customer satisfaction as

primary focus.

Academic Profile:

. Bachelors of engineering in Electronics and Inst. from Anna

University, 2012 with 8.92 CGPA.

. Higher secondary - SRM Nightingale School, 2008 with 95%.

. High school - Annai Velankanni Matriculation School, 2006 with 89%.

. Received several awards for academic excellence achievements

and University Rank Holder

Personal Competencies:

. Highly enthusiastic with good commitment in meeting deadlines.

. Honest, sincere and hard working with a high level of integrity.

. Adaptable to any situation and a great team player.

. Excellent written and verbal communication skills.

Hobbies:

. Playing cricket

. Surfing net

. Social Networking

Personal Profile

Name : Ramakrishnan.N

Date of Birth : 20 -Jan 1991

Father Name : P.Natarajan

Resident Location : Chennai

Current Location : Bangalore

Languages Known : English, Tamil

Nationality : Indian

I hereby declare that the above mentioned information is true

to the best of my knowledge.

(RAMAKRISHNAN.N)

Contact this candidate