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.