Amit Singh Kushwah
Email: adh7bi@r.postjobfree.com
Mobile: +917*********
PROFESSIONAL OBJECTIVE:
To excel in the field of Information Technology as Oracle Database Administrator by contributing continuously towards organizational growth by providing seamless database support and to utilize every opportunity to achieve both personal and professional development.
PROFESSIONAL EXPERIENCE:
Having 3+ years of experience as an Oracle DBA, currently working at Capgemini Ltd
OTHER PROFESSIONAL ACTIVITIES
* Training new associates have trained over 300 freshers in Linux, Database, Hardware, Application & Storage Technologies.
* Conducted Simulation Lab for freshers in MS SQL and Oracle DB.
BRIEF CAREER PROFILE:
Experience in DBA activities like Primary and physical standby Database Creation, Tablespace management, User management, Table/Index management.
Experience in installation, upgrading and migrating various versions of database (11g/12c/18c/19c) on different platforms i.e. Red Hat Linux, side Linux, aix and Windows.
Experience in database cloning, restoration of databases using RMAN
Experience in installation and configuration of Oracle 11g,12C,18C,19C Data guard, switchover and failover.
Experience in implementation of Backup and Recovery Strategies.
Experience in patching (PSU) for RDBMS and Grid Home
Experience in table reorg activity, index rebuilding activity
Experience in Container/Pluggable Database creation, upgrade and patching
Knowledge about OEM
Knowledge about ASM and RAC
knowledge about MSSQL DB
TECHNICAL SUMMARY:
Database : Oracle 11G, 12C, 18C, 19C.
Operating Systems : Linux, Windows Server.
Tools : RMAN, DBUA, DBCA, PUTTY,expdp,Toad,SQL DEVL.
.
ACADEMIC QUALIFICATION:
Degree / Certificate
University / Board
Percentage
B.E. (2013 - 2017)
RGPV Bhopal
66.9%
H.S.C (2012)
Central Board of Secondary and Higher Secondary Education, Delhi.
63.7%
S.S.C (2010)
Central Board of Secondary and Secondary Education, Delhi.
64.8
PROJECT THESIS:
Project
Volvo Cars
Customer
Volvo cars
Description
Volvo Cars, stylized as VOLVO, is a luxury vehicles brand and a subsidiary of the Chinese automotive company Geely. It is headquartered in Torslanda in Gothenburg, Sweden. The company manufactures and markets sport utility vehicles, station wagons, sedans and compact executive sedans.
Role: As Oracle Database Administrator
Responsibilities:
Client interactions
Working in 24x7 production environment and provided on-call and day-to-day support.
Day to Day monitoring of all the production databases. Doing all the DBA housekeeping activities like monitoring the load, free space check, disk space, CPU check
Oracle installation on various platforms like linux,unix and windows
Creation of the Databases on Oracle 11g, 12C,18C,19C for Production, development and testing.
Configured Primary, Dataguard and testing databases.
Managing databases in Production and Standby environment
Monitoring the database growth and allocating necessary resources.
Upgradation of databases from 11g to 12c
Migration of database from one platform to another
Managing tablespaces, user profiles, indexes, storage parameters and privileges.
Experience in performing exports/Imports, Datapump, Hot & Cold Backup on Database.
Administrated various production databases under oracle 11g,12c,18C,19C environment.
Monthly Production database backup
Backup, Restore and Recovery of the databases using RMAN.
Applying PSU patches to oracle binaries & keeping binaries updated with latest BUG fixes
Scheduling scripts for daily and weekly backups by using RMAN.
Standby database creation using RMAN, Hot & Cold backup.
Reorganizing tables and re-building indexes within databases whenever required.
Worked in Production environment’s Monitoring, administration and troubleshooting.
Generating AWR report from database for performance analysis purpose.
Creation of additional tablespaces and adding data files to tablespaces whenever required.
Identifying and solving the problems faced by Oracle Developers.
Perform DR-Drill, the activity that is performed once or twice every year
Responsible for giving presentation to newly joined trainees in Oracle
Having good analytical, problem-solving and learning skills.
Very good team player takes ownership and work towards the goals of an organization.
PERSONAL ATTRIBUTE:
Communications -- Good written and verbal presentation skills.
Interpersonal Skills -- Able to get along well with co-workers and accept supervision.
Flexible -- Willing to try new things and am interested in improving efficiency on assigned tasks.
Attention to Detail -- Concerned with quality. Produce work that is orderly and attractive. Ensure tasks are completed correctly and on time
AWARDS AND RECOGNITIONS:
Star of the Month award by Database team higher Management
Recognized by my team Leader and won On the Spot Award for successfully performing Data Guard Physical Standby set up and DR-Drill.
.
PERSONAL INFORMATION:
Name : Amit Singh Kushwah
Date of birth : 10/03/1995
Permanent Address : M8, Sky City, near Airforce station
Mahrajpur, Gwalior-474020
Gender : Male
Martial Status : Unmarried
Nationality : Indian
Fathers Name : Ramkishore Singh
Mothers Name : Meera Devi
Current Location : Bangalore
DECLARATION:
I hereby certify that all the information recorded above is true up to my knowledge and I should be held responsible in any case of incorrectness of the provided information.
Date:
Amit Singh Kushwah