Post Job Free

Resume

Sign in

Oracle Database

Location:
Chennai, TN, India
Posted:
November 23, 2017

Contact this candidate

Resume:

Stephen Alexander S

Email: ac3f9f@r.postjobfree.com

Mobile: 0091-735-***-****

Experience Summary

Over 4+ years of industry experience, which includes my present job profile as Oracle Database Administration.

Worked as a team member to provide 24x7 on production database support, monitoring and maintaining development, testing and production environments.

Had done various projects using RMAN for Backup and recovery, Data guard for Disaster recovery, Installation, Configuration, Migration, Upgrade, Cloning, Patching and Performance Tuning.

Ready to take leading responsibility and professionally looking forward to work inline with clients and winning client’s confidence.

Work Experience – 4 years of Industry Exp (Including 4 yrs of DBA)

Software Engineer (Oracle DBA) Zod Infotech Pvt. Ltd., Chennai

From Dec, 2013 to till date

Oracle Courses and Certifications

Completed Oracle 11g Certified Associate (OCA) Course.

Completed Oracle 11g Certified Professional (OCP) Course.

Educational Background

Master of Computer Applications, Loyola College, Chennai (2009-2012).

Bachelor of Science (Information Technology & Management), Arulanadar College, Madurai (2006-2009).

HSC (Bio-Maths), A.P.T Durairaj Higher Secondary School, Madurai (2006).

SSLC, St. Mary’s Higher Secondary school, Madurai (2004).

Professional Summary

Working as a part of team and providing 24x7 supports on a Production database and system support environment.

Implementation and maintaining Database Security (create and maintain users and roles, assign privileges).

Fresh installation of the oracle binaries and creating databases under different releases under RFS activity. (Request For Service)

Exporting & importing the database objects like tablespaces, user schemas, and tables and performing full database backups.

Reorg of database, Rebuilt of index.

Schemas refresh using Export/Import & Datapump utilities.

Implementing Hot and Cold backups and recovery for database using user managed backups.

Performing Full, Incremental & Cumulative RMAN backups

Creation of clone database using RMAN for Development/Testing Environments.

Configuring recovery catalog for RMAN backups and IMPORT CATALOG to new database.

Performing snapshot backup of oracle databases.

Analyzing the SQL Query using Explain plan, Generated AWR reports for tuning.

Creating and maintaining the Physical standby databases.

Switchover the database from primary to standby and standby to primary.

Upgrading of ORACLE database from 10gR2 to 11gR2 on RHEL Linux and Windows platform of DEVELOPMENT Environment.

Patching of ORACLE database from 10.2.0.1.0 to 10.2.0.4.0 and also 11g on RHEL Linux and Windows platform.

Implemented platform migration ORACLE 10.2.0.4.0 from Sun Solaris OS 5.10 to RHEL 5.0.

Experience in configuration and troubleshooting Datagaurd. (Standby )

Trouble shooting performance issues in long running query and connectivity’s issues in databases.

Got appreciations for the work delivered within the time scales.

Knowledge on RAC.

Technical Expertise

Operating Systems : Red Hat Enterprise Linux 4.0, 5.0, Windows XP/NT/2000.

Database : Oracle 10g, Oracle 11g.

Utilities : RMAN, Export/Import, Datapump, Statspack, AWR.

Languages : SQL, PL/SQL, Shell programming (basic level).

Software Tools : Putty, Toad.

High Technologies : Data Guard.

Projects Experience and Achievements

Project 2

Organization : Zod Infotech

Client : Mercendes Benz

Role : L2 Support

Time : June, 2016 to Till Date

Responsibilities

Creating synonyms and access privileges using roles, controlling access to the database using operating system and Oracle security.

Limiting the memory space and granting the necessary roles, privileges and profiles to the users.

Gathering statistics of tables, indexes, schemas and database to improve the performance

Monitoring the database growth, tablespace, disk level.

Refresh schema and database as per requirement.

Creating database links to share the objects from one Database to another.

Performing logical backup through Export/Import and Datapump utility.

Taking incremental level 0, level 1 backup using RMAN.

Refresh Database from Production using RMAN

Cloning the database using RMAN, Performing backup and recovery using RMAN.

Applying patches from 10.2.0.1.0 to 10.2.0.4.0

Upgrade Oracle 10G to 11G on Linux platform.

Collecting and storing database statistics using AWR report generation.

Configured standby database for disaster recovery and performed switchover

Implementing Dataguard using RMAN Backup and maintaining

Found Archive log Gap and resolved in Dataguard.

Perform switchover operation in Dataguard environment.

Perform snapshot standby in Dataguard environment.

Analyzing the SQL Query using explain plan and TKprof.

Generating and interpreting Database statistics using STATSPACK, AWR.

Project 1

Organization : Zod Infotech

Client : Al Raffah Hospital (Muscat)

Role : L1 Support

Time : Dec, 2013 to Oct, 2015

Responsibilities:

Platform Installation of Oracle 10G on Linux

Creating Schema with quota maintenance and roles and privileges

Creating tablespace, datafiles, tables, indexes, partition as per requirement

Check alert log errors and making necessary action to rectify them.

Frequent analysis of objects or schema to improve the speed of the database.

Building index for new tables and rebuilding Index to rectify Index fragmentation.

Adding log file groups and members into a group

Export/Import of tables, tablespaces, and full databases.

Creating catalog mode and register the database in RMAN.

Loading data into the database using SQL Loader.

To manage control file multiplexing and to trace the control file

Monitoring the growth of database, tablespace, disk level

Monitoring the unwanted user session and killing them if required.

Backup and recovery using RMAN

Perform hot and cold backup.

Analyzing the SQL Query using Explain plan.

Generating and interpreting Database statistics using STATSPACK, AWR.

Personal Data

Date of Birth : 13th June, 1986

Gender : Male

Marital Status : Single

Languages Known : English, Hindi.

Location Preference : Anywhere in India

Father Name : Savariappan S

Mother Name : Rose Mary S

Permanent Residence : 18, Chinthamani Road,

Samiyar Lane,

Madurai-625001

Present Residence : Gandhi Street,

West Mambalam,

Chennai.

Hobbies : Cooking, Playing games.

Declaration

I hereby declare that the above particulars are true to the best of my knowledge.



Contact this candidate