Anil Reddy

Oracle DBA

M: 219-***-**** EMAIL : ac0w3w@r.postjobfree.com

Around 2+ years of experience as an Oracle Database Administrator having hands on experience in database administration and performed different tasks like installation, configuration, upgrades, patches, performance tuning, backup and recovery, production support, space management, database security.

Oracle DBA Experience:

Experience in Installation, Configuration and Monitoring of Oracle Server on UNIX, Linux, AIX and Windows Environments.

Experience in monitoring and managing of Oracle instances using Enterprise Manage Grid Control (OEM Grid) 10g/11g/12c

Performed Migration and Upgradation of databases to 12c and 11g.

Experience in developing scripts to perform Backups using RMAN.

Implemented RMAN backup (Full, incremental and cumulative) and recovery and disaster recovery.

Experience in taking logical backup of the database using DATAPUMP (Expdp/Impdp).

Experience in Oracle Patching for 10G, 11G and 12C.

Supporting a production environment as necessary.

Experience in Performance Tuning for better performance. Identifying bottlenecks with memory and disk contentions.

Generate and interpret Automatic Workload Repository (AWR), Active Session History (ASH) and Automatic Database Diagnostic Monitor (ADDM) reports.

Experience in UNIX Bash Shell Scripting.

PL/SQL experience

Technical Skills:

Databases : Oracle 12c, 11g

Oracle Products : OEM (Oracle EnterpriseManager), RMAN, OEM 12C,

SQL*Loader, Import and Export

(EXPdp/IMPdp), ASM, SQL* Loader

And SQL * Net.

Operating System : RHEL 4, RHEL 5, OEL 4, WIN NT/2003/2008, Solaris 10,

HP-UX Itanium, IBM AIX

Languages : SQL, PL/SQL, UNIX Shell Scripting.

Other Tools : TOAD, Putty, SQL Developer, Erwin.

Client: Fannie Mae, VA JULY 2016 – JAN 2017

Role: Oracle DBA

Responsibilities:

Ensure high availability and performance (24 hrs production support).

Ongoing proactive database-level performance tuning and Pro-actively monitor database systems to ensure secure services with minimum downtime.

Experience in setting up FLYWAY configuration.

Expert level DBA development skills in CICS and DB2 for IBM z/OS

Worked and have experience on setting up the DELPHIX environment for the databases

Migration of databases from 10g to 11g using export/import and data pump export/import utilities and Performed database refresh activities for business requirement and tuning purposes.

Monitored system resource availability and responded to system memory and data issues.

Develop stored procedures, database triggers and SQL queries where needed.

Interacting with development teams, business owners, and various levels of management

Expert consultation in the installation and support of DB2 for IBM z/OS.

Provide 24/7 support for the applications and taking the responsibility for ON CALL.

Taking care of the production tickets/defects and solving problem with in time frame with accurate decisions and identifying the root cause and fixing the same.

Enforced need of regular data purging processes from production, design and development, to deployment.

Worked in design, development and implementation of DB2 databases as per the requirement.

Manage all database objects in a large mission critical system and able to provide end to end DBA support system and application side.

Analyze and resolve complex technical problems regarding the integration of object-oriented applications and infrastructure with relational database technology.

Also worked in performance tuning issues for DB2 databases.

Changes were made dynamically whenever possible to fulfill high-availability requirements.

Responsible for implementation and release of database changes as submitted by the development team.

Working on the regular tickets as per the requirement.

Experienced in managing space issues in the Database Level for table space and Regular file system cleanup at UNIX level.

Responsible for monitoring database, diagnosing errors, building, deploy, maintain and trouble shoot database objects.

Coordinate all Oracle system changes with the Operational DBA teams.

Work with DBA’s and Data architects to plan and implementing appropriate data partitioning strategy for an Enterprise Data Warehouse.

Managed appropriate use of free space within tablespaces, reclaimed space whenever possible. Reorganized tables and indexes within databases when needed.

Generated AWR, ADDM and ASH reports for database issues

Installed 12c agents on hosts and discovered targets.

Created new Groups, Templates, and Incident Rule sets in OEM 12C.

Designed and tested patching through OEM 12C.

Environment:Oracle /11g/12c, RDBMS, RMAN, Data Guard, Erwin Data Modeler, shell scripting, 12c and 11G OEM Grid control.

Client: Logic-Loops, GA JAN 2016 - JUNE 2016

Role: Oracle DBA (Intership)

Responsibilities:

Ensure high availability and performance (24 hrs production support).

Ongoing proactive database-level performance tuning and Pro-actively monitor database systems to ensure secure services with minimum downtime

Manage all database objects in a large mission critical system and able to provide end to end DBA support system and application side.

Analyze and resolve complex technical problems regarding the integration of object-oriented applications and infrastructure with relational database technology.

Work with DBA’s and Data architects to plan and implementing appropriate data partitioning strategy for an Enterprise Data Warehouse.

Changes were made dynamically whenever possible to fulfill high-availability requirements.

Responsible for implementation and release of database changes as submitted by the development team.

Interacting with development teams, business owners, and various levels of management.

Coordinate all Oracle system changes with the Operational DBA teams.

Develop stored procedures, database triggers and SQL queries where needed.

Enforced need of regular data purging processes from production, design and development, to deployment.

Responsible for two critical online applications db’s performance which have a huge business/revenue impact.

Taking care of the production tickets/defects and solving problem with in time frame with accurate decisions and identifying the root cause and fixing the same.

Managed appropriate use of free space within tablespaces, reclaimed space whenever possible. Reorganized tables and indexes within databases when needed.

Monitored system resource availability and responded to system memory and data issues.

Environment:Oracle 10g/11g, RDBMS, RMAN, RHEL 4.x, 5.x, shell scripting, 10G, and 11G OEM Grid control.

EDUCATION:

Masters in Information Technology. (Valparaiso University)

Bachelor of Technology (JNTU).

Contact this candidate