Senior Database Administrator
Shift Technology
Total years of experience :13 years, 8 Months
More than 12+ years of experience in the area of Oracle Database Administration.
Currently associate with Shift Technology, as a Senior Oracle Database Administrator(Expert) in Shift technologies (Client : GOSI) overall I have 12+ Years of DBA experience (Oracle & MSSQL Server)
Previously working in Oracle Corporation India Private Limited as an IC-4 Oracle DBA (Principal Software Engineer)
Worked in various projects for many multinational companies including HCL Comnet, Wipro infotech, Hewlett Packard and ORACLE India PVT LTD
Expert in Oracle Exadata Concepts
Helping oracle customer to resolve all type of Oracle database DBA issues at their environment..
Expertise in Database planning, design, administration, performance tuning, migration, backup and recovery.
Experienced in RMAN, Oracle Real Application clusters (RAC) and oracle high availability solutions - oracle dataguard Etc.
Ensure Oracle database systems operate efficiently and securely
Handled Oracle 8i/9i/10G/11G/12C Databases
Working knowledge in oracle Apps DBA (EBS R12)
Superior communication, presentation, analytical and problem solving skill. Work well with all levels of business
SQL Server Database
Installed SQL Server 2005-2008, 2012, 2014 and Share Point and applied Service Packs and hot fixes on production, development and backup servers
Implemented techniques like backups, restore, clustering, replication, Log Shipping and DB Mirroring in SQL Server.
Database Upgraded from 10G to 11G (11.2.0.3) Standalone & RAC environment with Dataguard (MAA) + DataBroker Setup, used RMAN Techniques for Upgrade from 10g to 11G
Configured 11G Dataguard switchover test using manual & DG Broker method
11G Tablespace Encryption & Wallet
Configured Three Node 10G RAC servers with 1TB ASM Disk
Implemented Necessary Patches in the RAC Nodes
RAC Database migration between the Data centres
RMAN DB Cloning & Adding the RAC Instance
10g to 11g migration (11.2.0.3)
12C Database(PDB/CDB) Backup management using RMAN
Implemented Necessary Patches in the RAC Nodes
Extensively used Oracle utilities like Export/Import, Datapump, Log Miner, DBVerify, Oracle Trace, DBCA, DBUA, TKPROF
Extensive Troubleshooting Highly/Medium/Less Critical Jobs of Production/QA/Test
Installation, configuration and upgrading of Oracle server software and related products.
Version up gradation and patch installation.
Creating primary database storage structures and modifying the database structures as and when require.
Standby database creation with/without data guard and maintenance.
Standby database switchover/Failover testing.
Duplicate database creation.
Schema refresh.
Monitoring/Maintaining the database and Performance tuning as per requirement.
Oracle User account, profile and role management..
Environment being in abend due to different reasons like Insufficient Space, User Account Being Lock, Backup Issues, Object Statistics Being Locked etc
Using Shell script, sending mails for alert errors, locks, Invalid objects, broken jobs, etc.
Working SQLSERVER on purging Transaction logs.
Oracle Installation - Install Oracle at Production DB server and Production Application Server.
Space Allocation Plan - Check No of Mount points available. Plan place for data files and other files to be placed.
Database Creation - Create Empty Database, Creating User, Schemas, Tablespaces as per the requirement
Create Tables, Views, Indexes, Sequences and then alter tables and view as per the scripts ( created for informix structure)
Check all the tables should be partitioned properly.
Data Extraction from Tape - Extracting data from tape drive and unconverting them into readable format ie untarring files
Data Loading - Checking the data loaded using the SQL loader utility. Tables having Column of data type interval is firstly loaded into intermediate oracle tables and then into target Oracle tables.
CPU/PSU patches applied
Creating Database Design, Data Dictionary
Implementing Standards/Strategies (Backup/Recovery, Capacity Planning
Database Cloning
Database Up-gradation from 8i to 9i and apply requisite Patches
Database Recovery and Periodic Backups using both Conventional Method and RMAN
Database Tuning using Troubleshooting and Performance Views
SQL Statement Tuning - Analysis of Explain Plans, SQL Trace, TKPROF, Tuning Hints and Analysis of STATPACK
Database Creation Managing Oracle Instances, control file, redo log files
Managing Users, Privileges & roles
Export / Import utility
Monitoring and Managing Storage,
EXPDP/IMPDP utility to refresh schema and database level
Install ORACLE software(oracle8i, oracle9i DB), applying patches& administer databases
Establish and maintain sound backup and recovery policies (ONLINE & OFFLINE) and procedures.
Implement and maintain database security (create and maintain users and roles, assign privileges), client/server database connectivity.
Support application developers with schema design and SQL statement tuning (SQL queries)
Setup and maintain documentation and standards
migration and logical backups(export, import-table, user level, tablespace, database)
Creating tablespaces, schemas and resizing the datafiles.
☑ MCA from IGNOU.
Recived Master of computer Application degree in IGNOU. Presently working as a Oracle DBA in Oracle Corporation