Surya Kiran

Oracle DBA

Ph: 510-***-****

acy7z1@r.postjobfree.com

f

Obj100

PROFILE

Around 8 years of experience in Oracle DBA & Data Analyst on Linux, UNIX and

Windows operating system environments.

Experience as a Production support/Operations DBA with 24x7/large databases and as a

Application support and Development Engineer/Data Warehouse DBA.

Creation of database objects

Experience in configuring Data Guard -- Physical Standby Databases.

Very good experience BMC Remedy Tool for ticketing system.

Excellent experience in Installation, configuration, Maintenance of Oracle 12C,11g,10g, 9i

RAC/Non RAC databases on Operating Systems UNIX, Solaris, Linux,AIX and Windows

platforms.

Expert in Performance Tuning i.e. tuning applications, shared pool, I/O distribution, rollback

segments, buffer cache, redo mechanisms.

Upgraded the Databases from Oracle 10g/11g to 11g and 12c and applied patches according

to the client requirement in RAC and NON RAC environments with ASM and Non ASM storage.

Involved in application upgrades with Oracle Applications (11.5.8, 11.5.9, 11.5.10,

R12.0.6,R12.1.3)/ Oracle E Business Suite

Worked in Oracle EBS System Administration to manage concurrent managers, application

user setup, defining responsibilities, value sets, registering forms & reports, custom application

registration & printer setup.

Implemented Heterogeneous replication and Bi-Directional Replication

using Golden Gate (Oracle to oracle, db2, SQL Server) and troubleshoot issues using Log

miner.

Experience in Auditing and Capacity Planning, Configuring & Managing Hot Standby Databases

(Data Guard).

Worked extensively on Exadata environment.

Setup and configured Oracle 10g/11g Physical Standby database (Data Guard) to ensure high

availability

Experience with Oracle Streams which enable the propagation and management of data,

transactions and events in a data stream either within a database, or from one database to

another.

Proficient in implementing/configuring and using OEM 10g, 11g and12c Grid control.

Excellent knowledge in Hot/Cold Backup and Recovery and Cloning of databases using

RMAN.

Experience in DATAPUMP, AWR, ASM, ADDM, Grid Monitoring & Oracle Enterprise Manager

(OEM).

Expertise in performance-tuning, SQL tuning services with EXPLAINS PLAN, TKPROF,

STATSPACK, SQL TRACE, AWR, ADDM to collect and maintain performance statistics and

improve the database performance.

Experience in User management, Space Management, Capacity Planning.

Experience in setting backup and recovery procedures using RMAN and Flashback

Technologies-Flashback Databases, Flashback Tables etc.

Experienced in setting up/installation and configuration of release 11g R1 RAC with

ASM and Raw Devices and 11g CRS

Experience as a Production support/Operations DBA with Multi-Terabyte 24x7/large

databases and as a Development Engineer/Data Warehouse DBA.

Expert in maintaining very Large Databases involved in Data warehouse and ERP

Applications of various sizes 5TB.

Responsible for both managing and supporting all Production, Development and Staging

instances of Oracle Versions 8i, 9i, 10g & 11g.

Configured and maintained Real Application Clusters environment for high availability

and scalability.

Experience in configuring Data Guard -- Physical Standby and Logical Standby

Databases.

Experience in setting backup and recovery procedures using RMAN and Flashback

Technologies-Flashback Databases, Flashback Tables etc.

Experience in implementing Automatic Storage Management for simple storage interface.

Experience in installing and configuring/Monitoring Enterprise Manager Grid Control.

Experience in working and administrating ORACLE Golden Gate 9, 10.

Experience in configuring and Installing/using various Quest Tools- TOAD.

Expertise in SQL and PL/SQL, writing stored procedures, triggers and functions.

Extensive knowledge in working with the tools like Grid Control, Oracle Enterprise

Manager, TOAD, SQL developer, Datapump, Exp/Imp.

Extensive knowledge in working with the tools like Grid Control, Oracle Enterprise

Manager, TOAD, SQL developer, Datapump, Exp/Imp.

Oracle 11.2.0.3/11.2.0.1/11.1.0.7/10.2.0.4, Quarter/Half/Full RACK, OEM 12c, LINUX,

IBM AIX, TOAD.

CERTIFICATIONS:

ORACLE Certified Professional.

TECHNICAL SKILLS:

Database: Oracle (8i, 9i, 10g, 11g,12C), MS SQL 2000/2005,

Operating systems: Sun Solaris, AIX, HP-UX, Windows 2000/2003/2008, Windows NT,

Redhat Linux.

Programming & Scripting Languages: SQL, PL/SQL, Shell/Perl scripting.

Tools: Oracle Grid Control 11g/12c, SQL*Loader, RMAN, Toad, Remedy, Quest tools, SQL

Developer.PL/SQL Developer, Golden Gate

PROJECT EXPERIENCE:

AT&T, NJ Jul 2015 Till Date

Oracle DBA

Environment: Oracle 9i/10g/11g/12c, Solaris 10, REDHAT Linux 4, Windows Server 2008,

Oracle Grid Control RMAN, Remedy and Toad.

Responsibilities:

Providing full life cycle on DBA/on call support for Production Databases,

Administering, UAT, Development and QA databases.

Installed & Configured ORACLE 10g RAC, 11g on Red Hat ES Linux Servers.

Upgrade oracle 10g databases to 11.2.0 version

Provided On-Call rotation and 24x7 supports for very large databases

Installed, configured Oracle 11g grid infrastructure for standalone & RAC databases

Good experience with Oracle 11g RAC including installation & managing the databases

in ASM & non-ASM.

Upgraded Oracle 10g/12C to the Oracle 11g R2 database version.

Implement backup and recovery procedures using (RMAN) for Oracle databases and test

regularly in conjunction with Operations.

Implemented the Golden Gate Replication

Extensively worked in migration & up gradation projects i.e. from Oracle 9i/10g to

Oracle 11g in cross platform.

Setup the Oracle Advanced Replication using DB links & materialized views.

Good experiences with UNIX shell scripting.

Having experience with Oracle Partitioning

Good experience with Oracle performance issues in both application tuning &memory

tuning.

Responsible for maintaining Oracle 11g data guard and 9i standby databases.

Very good experience with Oracle RMAN & other backup utilities

Applied the Oracle security patches and application patches using the OPATCH

utilities.

Created and monitored Physical standby databases on maximum protection,

performance mode using Dataguard for Disaster Recovery and performing production

databases Maintenance.

Setup classic capture replication mechanism using goldengate.

Supported installation and setup of ORACLE Clusters and RAC database.

Monitoring and Administrating ORACLE RAC databases on ORACLE 11g Clusters.

Having experience with Bigdata databases.

Experience with BMC Remedy tool for all change management process.

Upgraded few production databases from version ORACLE 11g to ORACLE 12c.

Creating Materialized views and Materialized View Logs for Data Replication.

Working with optimizer Hints and Explain Plan for estimating performance and to

generate optimal solutions.

Worked on building and rolling out new 12c databases for test/dev/qa environments.

Implemented oracle 12c active standby database for test database environment

Handled my group of 4 people in all and lead them for getting best results

Installed GoldenGate software in Test and dev instances

Performance Tuning for Optimized results using Explain-Plan, SQL-Trace, STATS

PACK reports and AWR Reports. Provided recommendations using ADDM reports.

Analyzed the trace files Using TKPROF utility.

Monitoring Scheduled jobs of the daily activities for the performance of all the

databases.

Installing and removing software packages and patches on Solaris.

Well versed in developing the complex SQL queries, unions and multiple table joins

and experience with Views.

Experience in database programming in PL/SQL (Stored Procedures, Triggers and

Packages).

skills in Data Analysis, Data Requirement Analysis and Data Mapping for ETL

processes.

Monitoring and performance enhancement using session Tracing, Statspack and CPU

utilization.

Monitoring databases and setting alerts using Oracle Grid Control/Enterprise

Manager.

Performed software cloning, tuning, patch management and deployment using

Configuration and Provisioning, Diagnostic and Tuning Packs.

Performing Backups (BLI, Full, Cumulative, Differential), Recoveries using RMAN-

Netbackup.

Experience includes using Golden Gate to support data replication in the Oracle

database environment

Used Flashback technologies-Flashback Table, Flashback Query & Flashback

Database to recover from user errors and minimize the Full/Incomplete database

recoveries.

Performing Database Refreshes using Exp/Imp, Datapump, Sql*Loader and RMAN.

Wrote Shell and Perl scripts for monitoring and automating tasks of various

Databases.

Merrill Lynch, Pennington, NJ Oct 2014Apr 2015

Sr.Oracle DBA

Environment: Oracle 9i/10g/11g, 10g/11g RAC, Solaris 10, RHEL, AIX5.3, OEM/Grid,

RMAN.

Configured and Installed ORACLE 10g, 11g software on Red Hat Linux 4 Servers.

Upgrade oracle 10g databases to 11.2.0 version

Created and monitored Physical standby databases on maximum protection, performance

mode using Dataguard for Disaster Recovery and performing production databases

Maintenance.

Configured Automatic Storage Management (ASM) for 10g RAC databases for reducing

disk

Performing Database Refreshes using Exp/Imp, Datapump, Sql*Loader and RMAN.

Installed, configured Oracle 10g & 11g RAC with advanced features

Very good experience with Oracle 10g RAC administration and HA environment.

Setup reporting server using ORACLE Streams from various data sources.

Setup the Oracle Advanced Replication using DB links & materialized views.

Good experiences with UNIX shell scripting.

Identifying instance Top Waits root cause and bad queries, writing suggested solution

reports about Instance tuning and Query tuning.

Experience in setting backup and recovery procedures using RMAN and Flashback

Technologies-Flashback Databases, Flashback Tables etc

Very good experience with Oracle RMAN & other backup utilities

Partitioned the table using split & merge utilities

Good experience with Oracle database & application performance tuning.

Creating Tables, indexes, & triggers to assist developers.

Managing, troubleshooting and resolving oracle database, RAC and applications issues.

Refresh/Cloning of Database and applications for development and testing purpose.

Was involved in developing a disaster recovery (DR) plan.

Knowledge of the Oracle Golden Gate installation, configuration, troubleshooting GG

issues.

Performing Backup/Recovery of all the Oracle databases using RMAN.

Scripts for Health Check of Databases.

Reading Alert Logs and User trace Files and Diagnosing the Problem.

Writing UNIX shell Scripts and Scheduling through crontab.

Providing Solutions to the Problems Faced by end Users or Programmers.

OS level activities like space monitoring of Mount points.

Scripts for Analyzing of Tables and Rebuilding of Indexes.

Taking periodic backup of the database and the software.

Automation of Backups.

Interfacing with Oracle Corporation for technical support.

Unilever, CT Jan2012 Jul 2014

Oracle DBA

Environment: Oracle 8i, 9i/10g/11g, 10g RAC, Oracle AS, Solaris 10, REDHAT Linux 4,

Windows Server 2008, HP-UX 11.2, Oracle Grid Control 5, SAN, Data pump,

RMAN, Golden Gate, SQL *Loader, Exp/Imp, Toad.

Responsibilities:

24x7 Oracle Database Administration of Production, Development, Testing databases.

Setup and configured Standby Databases for disaster recovery and reports generation in

maximum performance mode using Dataguard.

Setup and Configured Physical Standby and Logical Standby Databases for various

production systems.

Involved in Data Modeling, Design, Implementation and Creation of Databases.

Worked closely with System Administrators, Network Administrators to build the RAC

environment.

Involved in setting up of ORACLE 10g RAC Databases for test prototype environment

with three nodes-cluster on Red hat Enterprise Linux 4.

Setup Automatic Storage Management to reduce I/O contention and support RAC

databases.

Patched/Upgraded ORACLE 9i Databases to ORACLE 10g databases using

DBUA/Manually.

Documented the procedures for adding a node for current DATAGUARD environment.

Involved in Capacity and Resource planning. Estimated the size of Data files and Redo

log files based current transactions rate, time for recoveries etc.

Installed and configured software/databases as of Oracles Optimal Flexible Architecture

(OFA).

Designed various Backups/Recovery strategies for Oracle databases as per SLA

requirements.

Configured users into consumer groups and set the resource utilization based upon

business activity using RESOURCE MANAGER.

Configured and performed automated and various levels of backups using RMAN.

Very good experience with Oracle Application Server & WEBLOGIC servers middle tier.

Installed ORACLE Enterprise Manager GRID CONTROL and configured it server

targets for a centralized monitoring system.

Monitored databases Performance using ORACLE Enterprise Manager (OEM) and Grid

Control.

Monitored and maintained Security by managing Roles/Privileges for users of the

databases.

Worked on AWR repository, Statspack report and Session Trace 10046 to find/fix root

causes for performance degradation in the databases.

Responsible for Instance Tuning, I/O Tuning, Identifying and fixed contention waits.

Used ORACLE Wait Interface, to identify the top most wait events and their causes.

Used advisor, tasks like ADDM, SQL Tune, Access Tune and Undo Advisors for

performance tuning.

Resolved several performance bottlenecks and poorly tuned Ad hoc SQL Statements.

Installed and updates critical security Patches using Enterprise Manager and O PATCH.

Worked extensively with tools like SQL * Loader, Datapump, Exp/Imp, for loading data

into database and monitoring and querying databases using TOAD etc.

Created Indexes-Bitmap/Join Indexes, Function-Based Indexes etc as per the given

structures, operations, data in the tables for increased performance.

Documented the entire core procedures required for the oracle database maintenance.

Created Materialized Views/Snapshots for replications and increase query performance.

Partitioned Tables, Index for increased query performance and easier maintenance.

Analyzed query plan using Plan Table, Explain Plan, optimizer Hints and for estimating

CPU & Query costs.

Refreshed PROD, DEV, UAT databases using Datapump, RMAN, Transportable

Tablespaces etc.

Resolved Shared Memory Allocations, long Transactions, Locking Issues and Deadlocks.

Developed Shell Scripts and SQL scripts to carry out routine checks on databases and

perform various tasks on the database.

Concentrix, India

Oracle DBA Oct 2010-Sep2011

Environment: Windows-NT, Oracle 8x/9i,10g,Redhat Linux, TOAD, C/C++, Oracle 8i,9i,

Reports2.5, Oracle Designer, PL/SQL, Solaris 5, Windows 2000/NT

Responsibilities:

Configured and Installed ORACLE 10g, 11g software on Red Hat Linux 4 Servers.

Upgrade oracle 10g databases to 11.2.0 version

Created and monitored Physical standby databases on maximum protection, performance

mode using Dataguard for Disaster Recovery and performing production databases

Maintenance.

Configured Automatic Storage Management (ASM) for 10g RAC databases for reducing

disk

Performing Database Refreshes using Exp/Imp, Datapump, Sql*Loader and RMAN.

Installed, configured Oracle 10g & 11g RAC with advanced features

Very good experience with Oracle 10g RAC administration and HA environment.

Setup reporting server using ORACLE Streams from various data sources.

Setup the Oracle Advanced Replication using DB links & materialized views.

Good experiences with UNIX shell scripting.

Installing new versions of database software and perform maintenance functions of the

database.

Compiling and debugging packages with in-house code, and assisting the developers with

optimizing and tuning the PL/SQL code.

Wrote Scripts to perform HOT/COLD backups.

Created users and maintained security with roles and privileges.

Cloning/Refreshing databases from hot/cold backups.

Setup connectivity to databases using NET 8 for clients and server side.

Developed and maintained the system using Oracle Forms, Oracle Reports, SQL*Plus

and PL/SQL.

Creating database objects such as tables, views, procedures and functions and executed

them using SQL*Plus. Created indexes to improve the system performance.

Involving in creation of triggers and handling exceptions.

Wrote Embedded SQL in C (Pro * C).

Developing various Business and ad-hoc Reports.

Creating Data Flow Diagram, Entity Relationship Diagram from Designer.

Involving in writing PL/SQL Triggers, Procedures, Functions and Packages.

Convergys, Hyderabad, India

Jr. Oracle DBA/Developer Mar 2008 Aug2010

Environment: C/C++, Oracle 8i,9i, Reports2.5, Oracle Designer, PL/SQL, Solaris 5, Windows

2000/NT

Responsibilities:

Installing new versions of database software and perform maintenance functions of the

database.

Compiling and debugging packages with in-house code, and assisting the developers with

optimizing and tuning the PL/SQL code.

Wrote Scripts to perform HOT/COLD backups.

Created users and maintained security with roles and privileges.

Cloning/Refreshing databases from hot/cold backups.

Setup connectivity to databases using NET 8 for clients and server side.

Developed and maintained the system using Oracle Forms, Oracle Reports, SQL*Plus

and PL/SQL.

Creating database objects such as tables, views, procedures and functions and executed

them using SQL*Plus. Created indexes to improve the system performance.

Involving in creation of triggers and handling exceptions.

Wrote Embedded SQL in C (Pro * C).

Developing various Business and ad-hoc Reports.

Creating Data Flow Diagram, Entity Relationship Diagram from Designer.

Involving in writing PL/SQL Triggers, Procedures, Functions and Packages.

Various stored procedures were written to achieve the back end functionality.

Analyzed performance bottlenecks and provide appropriate solutions.

Wrote various scripts in PERL and SHELL for database health and space checks.

Development, Testing, Implementation and Training.

Contact this candidate