Oracle Manager
Resume:
Naveen Kumar Mobile: +91-995*******
Sr.Oracle DBA with 5.7 yrs.Exp. Email:************@*****.***
To work in a professional and challenging environment, while best utilizing my talent and keeping abreast with the latest technical advancement in the field of Oracle DBA, by which I can derive utmost job satisfaction and knowledge of the field and to become a successful in Oracle Database Administration activities.
Core dbaSkills
Good experience in Installation and Administration of Oracle 11g, 10g on Linux/Windows
Experience in supporting production (PROD), development (DEV) and testing (TEST) databases
Good knowledge on Oracle database architecture
Creating and maintaining tablespaces, Resizing tablespaces and adding new database files
Creating database users and assigning quotas, roles, privileges and profiles to users
Experience in Resolving tablespaces issues and user management issues
Converting Database from no archive log mode to archive log mode
Experience in implementation of backup and recovery strategies.
Performed backup using HOT backup, Cold backup, RMAN.
Database refreshes (Cloning) using RMAN & Manual HOT or COLD backups.
Having good experience with the tools like Datapump (Expdp&Impdp).
Generating and analyzing AWR,ADDM,ASH Reports
Creating the Private, Public database links for distributing database.
Monitoring of alert log files and trace files.
Configuring LISTNER and TNSNAMES in network applications.
Applying Patches Using OPatch, OUI as per need.
Upgrading databases from lower to higher version.
Experience in Flashback Features.
Implemented Oracle 11g Data guard – Physical Standby.
Experienced in Installing and Administering Oracle 11gR2 (RAC) grid Infrastructure.
Implementing and managing jobs using AUTOSYS tool.
24/7 customer support.
Professional Experience
Working for Tech Mahindra, Hyderabad from July 2015 to till date.
Worked for Navayuga InfoTech Pvt Ltd, Hyderabad from November 2010 to June 2015.
Technical Expertise
Operating System: Windows 2008/XP, Red Hat Enterprise Linux AS5,Solaris
Languages: SQL, PL/SQL
Case Tools: Toad, Putty, and FileZilla,Autosys
Oracle Utilities: RMAN and OEM.
Project Profile
Project #1
Title IT Project Coordinators
Client Synchrony Financial
Work Profile Senior Oracle Database Administrator
Team Size 8
Roles and Responsibilities:
Working on 2 nodes RAC 11g release 2 on Solaris servers for Production setup.
Monitoring and configuring RAC Environment using by SRVCTL.
Responsible for taking regular backups including Rman,cold / hot backups, Expdp/ Impdp of database.
Clone/Refresh of Production databases to Testing and training environments using RMAN.
Create and manage multiple databases on one server for testing.
Up gradation from 11.2.0.1 to 11.2.0.4.
Design and implementation of database backup recovery strategy using RMAN.
Provide database administration on production, testing and development database servers.
Creation of database objects like tables, indexes, stored procedures and views etc.
Creation of users and roles and maintaining system security.
Estimate Storage requirement, Creation of Tablespaces and other Database Primary Objects.
Using Flashback Table and Flashback Drop to recover dropped tables.
Responsible configuring listeners for network connectivity and security.
Applied critical patch updates (CPU) released by oracle quarterly.
Implementing shell scripts for backup of databases and scheduling the scripts from Autosys.
Administer an Oracle database and its users using Oracle Enterprise Manager.
Consistently interacted with client and team in resolving the queries.
Project #2
Title The Nairobi Hospital
Client Nairobi
Work Profile Oracle Database Administrator
Team Size 6
Roles and Responsibilities:
Implemented 2 nodes RAC 11g release 2 on Linux servers for Production setup.
Monitoring and configuring RAC Environment using by SRVCTL.
Implemented oracle high availability solution using oracle 11g PHYSICAL STANDBY.
Responsible for taking regular backups including cold / hot backups, Export / Import of database, using RMAN, and recovery in case of disasters.
Clone/Refresh of Production databases to Testing and training environments using RMAN
Create and manage multiple databases on one server for testing.
Patch Upgradation from 10.2.0.4 to 11.2.0.3.
Performed logical backups using Export / Import utilities and Data Pump.
Design and implementation of database backup recovery strategy using RMAN.
Provide database administration on production, testing and development database servers.
Creation of database objects like tables, indexes, stored procedures and views etc.
Creation of users and roles and maintaining system security.
Estimate Storage requirement, Creation of Tablespaces and other Database Primary Objects.
Using Flashback Table and Flashback Drop to recover dropped tables.
Responsible configuring listeners for network connectivity and security.
Applied critical patch updates (CPU) released by oracle quarterly.
Implementing shell scripts for backup of databases and scheduling the scripts from crontab.
Experience in Data Loading from flat files using SQL * Loader.
Administer an Oracle database and its users using Oracle Enterprise Manager.
Consistently interacted with client and team in resolving the queries.
Project #3
Title IHCIMS (Integrated Healthcare Information Management Systems)
Client Government of Namibia.
Work Profile Oracle Database Administrator.
Team Size 4
Roles and Responsibilities:
Monitor and analyze Oracle trace files and alert log for Oracle errors.
Resolving user’s day-to-day issues and resolving the tickets.
Clone/Refresh of Production databases to Testing and training environments using RMAN Duplicate.
Create and manage multiple databases on one server for testing.
Perform Oracle 10g software installation and latest patch installation.
Performed logical backups using Export / Import utilities and Data Pump.
Design and implementation of database backup recovery strategy using RMAN.
Provide database administration on production, testing and development database servers.
Creation of database objects like tables, indexes, stored procedures and views etc.
Creation of users and roles and maintaining system security.
Estimate Storage requirement, Creation of Tablespaces and other Database Primary Objects.
Using Flashback Table and Flashback Drop to recover dropped tables.
Responsible configuring listeners for network connectivity and security.
Implementing shell scripts for backup of databases and scheduling the scripts from crontab.
Applied critical patch updates (CPU) released by oracle quarterly.
Administer an Oracle database and its users using Oracle Enterprise Manager.
Patched and upgraded 10.2.0.1 databases to 10.2.0.4.
Consistently interacted with client and team in resolving the queries.
Project #4
Title EPMS (Enterprise Port Management System)
Client Krishnapatnam Port Company Ltd
Work Profile Junior Database Administrator.
Team Size 4
Roles and Responsibilities:
Monitor and analyze Oracle trace files and alert log for Oracle errors.
Resolving user’s day-to-day issues and resolving the tickets.
Create and manage multiple databases on one server for testing.
Perform Oracle 10g software installation and latest patch installation.
Performed logical backups using Export / Import utilities and Data Pump.
Provide database administration on production, testing and development database servers.
Creation of database objects like tables, indexes, stored procedures and views etc.
Creation of users and roles and maintaining system security.
Estimate Storage requirement, Creation of Tablespaces and other Database Primary Objects.
Using Flashback Table and Flashback Drop to recover dropped tables.
Responsible configuring listeners for network connectivity and security.
Administer an Oracle database and its users using Oracle Enterprise Manager.
Consistently interacted with client and team in resolving the queries.
Contact this candidate