ASHOK Emai:

Sr.Oracle Dba Consultant Mobile: (+91) 9738740967

OBJECTIVE

Seeking a challenging and responsible position in software industry to enhance my professional skills, self-development and keep up with cutting edge technologies to serve my organization in best possible way with sheer determination and commitment.

Professional Summary

  • Performing L1-L2 DBA activities, it also includes addressing Sev 1/2/3 incident tickets
  • 24*7 Production Support that includes off hours and weekend support and always available for secondary escalation contact.
  • Installed and maintained 10g/11g and 12c databases for testing, development and production
  • Monitoring the production databases, running the health check database scripts.
  • Diagnosing / troubleshooting the database issues using alert.log and related trace files.
  • Monitoring the File System mount points, archived log mount points and tablespace usage on databases.
  • Managing the database storage and administration creating / altering the different types of tablespace creation.
  • Managing the database users: granting /revoking the privileges, allocation storage quota and password and profile maintenances.
  • Checking Database Health, Hit ratio, Backup, CPU Utilization, Archive Log Check, Space growth of Tablespaces and O/S File System.
  • Performed Cold backup, hot backup using conventional back ups and RMAN, recovered various and critical Production databases.
  • Prepared backup schedule which include offline, online and logical backups.
  • Used Export/Import, Data Pump Utilities to move the data between different databases and for backups.
  • Worked on Data Guard and setup physical standby database and validating log gaps.
  • Worked on role switch over/failover in primary and standby environment.
  • Apply patches, upgrades, Clone and create databases for Oracle databases
  • Use of Crontab, DBMS JOBS to automate the monitoring jobs.
  • Worked in Oracle 10g/11g RAC environment and troubleshooting for RAC issues.
  • Maintaining Goldengate database monitoring lag and trobleshooting.

CAREER CONTOUR

Working as an Oracle Database Administrator with IBM IND PVT LTD

From MAY 2015 to till date.

Worked as an Oracle Database Administrator withIBM(CONTRACTOR)

 From SEP 2013to MAR 2015.

TECHNICAL SKILLS

Databases : Oracle 11g/10g,12c and RAC and Golden Gate

Languages : SQL, PL/SQL and C.

Operating Systems : Linux (AS4,AS5), Windows (2003,Xp,Vista,Win7),Sun Solaris Sparc,

 Aix

Hardware : Dell power edge server

Oracle Tools : Database Control ,RMAN,EXPDB, Putty,OEM

Business Tools : Remedy,Service now and SiteScope

EDUCATIONAL QUALIFICATION

MASTER OF COMPUTER APPLICATIONS FROM JNTU(H).

PROJECT DETAILS

Client/Project Name : SUNCOR ENERGY(Energy)

Role : Oracle DBA

Environment : Oracle 12c/11g, RMAN, ASM, DATA GUARD.

Responsibilities:

  • Performing L1-L2 DBA activities, it also includes addressing Sev 1/2/3 incident tickets
  • 24*7 Production Support that includes off hours and weekend support and always available for secondary escalation contact.
  • Monitoring the production databases, running the health check database scripts.
  • Diagnosing / troubleshooting the database issues using alert.log and related trace files.
  • Monitoring the File System mount points, archived log mount points and tablespace usage on databases.
  • Managing the database storage and administration creating / altering the different types of tablespace creation.
  • Managing the database users: granting /revoking the privileges, allocation storage quota and password and profile maintenances.
  • Checking Database Health, Hit ratio, Backup, CPU Utilization, Archive Log Check, Space growth of Tablespaces and O/S File System.
  • Worked on Data Guard and setup physical standby database and validating log gaps.
  • Worked on role switch over/failover in primary and standby environment.
  • Apply patches, upgrades, Clone and create databases for Oracle databases
  • Maintaining Goldengate database monitoring lag and trobleshooting
  • Validating and working on RMAN backup/restoration/recovery and job failures activities on production environment.
  • Cloning and refreshing the production database with development and test environments using Data Pump, Cold/hot backup, RMAN duplicate database using TAPE backup.
  • Generating AWR,ASH and ADDM reports as requested by SME and application team.
  • Monitoring the production databases, running the health check database scripts.
  • Worked closely with the project teams to deploy their changes in the database and servers.

Client/Project Name : CAPITAL ONE(Banking Domain)

Role : Consultant Oracle DBA

Environment : Oracle Database 10g, SQL, RMAN, Red Hat Linux

Responsibility:

  • Installed oracle software / database creation / database upgrade
  • Created various database objects like table, views, indexes, database links and synonyms
  • Identifying invalid objects and validating them using utlrp.sql script.
  • Maintenance activities such as partition addition, partition dropping to/from partitioned tables and implementing purging policies for the database tables.
  • Monitored the File System mount points, archived log mount points and tablespace usage on databases.
  • Analyzing tables and rebuilding the indexes to improve the performance on weekly basis.
  • Scheduling and running the adhoc hot and cold backups as requested and required.
  • Monitored the production databases, running the health check database scripts.
  • Performed recovery scenarios as per demand.
  • Diagnosed / troubleshooted database issues reported in alert.log and related trace files.
  • Day to day database administration tasks like creating / altering of tablespace creation, adding/resizing data files etc.
  • Applied patches ( PSU/CPU) on test/UAT and production environment as per schedule.
  • Managed the database users: granting /revoking the privileges, allocation of storage quota, password resets and profile assignments.
  • Worked on Data Guard and setup physical standby database and validating log gaps.
  • Worked on role switch over/failover in primary and standby environment.
  • Change the protection mode on database and setup Snapshot Standby database for testing propose.

Client/Project Name : KAISER PERMANANTE(Insurence)

Role : Oracle DBA

Environment : LINUX AS4, Oracle 11G/10g, SQL, Export/Import, RMAN.

Project & Role Description

  • Administering the database security, creating users, granting roles, privileges to users
  • Cloning the database using the traditional manner as well as using RMAN.
  • Regular Monitoring Alert Log Files on day-to-day basis
  • Managing Redo logs and Data files like adding, renaming and resizing
  • Managing Control files like adding, recreating and tracing to physical locations and tracing backup
  • Monitoring of free space and extents in table spaces.
  • Managing Data files like adding, renaming and resizing
  • Setting up the users, their privileges through different roles.
  • Taking of the Export, Import for backing certain tables.
  • Maintaining Archive logs and their space for routine administration alert and trace monitoring.
  • Monitoring cold, hot backup operations.