Oracle DBA Position

Srikanth kanneganti

Email:************@*****.*** Ph.no:209-***-****

Professional Summary:

Around 8+ years of experience as Oracle Database administrator, having hands on experience in database administration, production support, installation, configuration, upgrades, performance tuning, backup and recovery, cloning, space management, and database security with Oracle (9i, 10g, 11g, 12c) and also Oracle Real Application Clusters (RAC), Automatic Storage Management (ASM), Data guard, goldengate on Sun Solaris, Red Hat Linux, HP-UX, AIX, and Windows Platform. Experience with very large scale database environments and mission critical OLTP and OLAP systems and in Installation, Patching, Cloning, and Upgrade of Oracle Databases and in Backup & Recovery, Disaster Recovery options, Oracle Recovery Manager (RMAN) and in Oracle Enterprise Manager (OEM).

Professional Experience

Experience in managing Oracle databases running on MS-Windows, NT Server, UNIX/Linux, Sun Solaris, HP-UX & AIX and RHEL.

Hands on experience in Oracle 10g/11g/12c RAC implementation & administration (Oracle Cluster ware setup and configuration, RAC installation using ASM, Grid Installation).

Extensive Experience in database administration for Oracle 9i, 10g, 11g and 12c, with experience in very large scale database environment and mission critical large OLTP and OLAP systems

Involved with installation and maintenance of ORACLE 10g RAC/ORACLE 11g RAC/ORACLE 12cRAC and standby database for High Availability and Disaster Recovery purpose

Good experience RAC Clusterware administration, Configuration and Patching.

Extensive experience in Dataguard configuration, implementing and maintaining standby databases.

Hands on experience in Grid control, Streams, GoldenGate Replication.

Experience in Performance Tuning using EXPLAIN PLAN, SQLTRACE, TKPROF, STATSPACK, AWR and ADDM.

Setup Oracle Enterprise Manager (OEM) 10g, 11g & Grid Control (11g) for database monitoring/performance/diagnostics.

Extensive experience in Database Backups RMAN (Full/Incremental backups) and in traditional hot/cold backups.

Experienced in Data migration using Amazon DMS service.

Experienced in creating AWS EC2 instances.

Experienced in using AWS RDS.

Experience in LOGICAL BACKUPS and Database migration tools with DATA PUMP, Export/Import and Transportable Tablespaces.

Installation, configuration and maintenance of Physical Standby using Oracle Data Guard for Disaster recovery process on Oracle 12c/11g/ 10g.

Developing and Implementing Disaster Recovery (DR) Plan using Datagaurd

Good experience in writing/editing UNIX Shell Scripts.

Good experience in PATCHING AND UPGRADATION. Expertise in upgrading Oracle Development and Production databases from 9i to 10g & 11g, 10g to 11g, 11g to 12c.

Extensive knowledge and experience on managing very large Data Warehouse databases.

Proficient in SQL, PL/SQL, Stored Procedures, Functions, Cursors and Triggers.

Extensive experience in configuring and implementing ASM and proficiency in using ASMCMD and ASMLIB.

Experience in Flash-Back Technology, Database Refresh and patch management and in Database cloning with RMAN and manual methods.’

Experience in Capacity Planning and Bench Marking and Developed database monitoring/health check alert scripts for database uptime/downtime status, and sizing issues using grid control

Proficient in raising TAR with Oracle Support and using Metalink to resolve the bottlenecks in the database environments.

Excellent Communication skills, co-ordination and communication with system administrators, business data analysts and development teams.

TECHNICAL SKILLS:

Operating Systems

Red Hat Linux RHEL 3.x, 4.x, 5.x, 6.x, HP-UX 10.x, 11.x,

Sun Solaris 9.0/10.0, AIX 5.1, 5.2

Data Bases

Oracle 12c/11g/10g/9i, Oracle 12c, 11g/10g Real Application Cluster (RAC),

ASM, MySQL, SQL SERVER 2008/2012, Mongo DB

Languages

SQL, PL/SQL, UNIX Shell Scripting

Tools/

Utilities

RAC, OEM Grid Control, SQL* Loader, ASM, SQL Server, Export/Import,

RMAN, NETCA, DBCA, TOAD, Exadata, Patch Management, SQLNET,

ODBC, Export/Import, Data pump, Data-Guard, Erwin, OEL, Log-miner, APEX

MS Visio, VERITAS Net Backup, BMC remedy, Pac 2000, VMware, Crontab

Tuning Tools

TKPROF, EXPLAIN PLAN, STATSPACK, ADDM, AWR

Terminal Emulation

Putty, Telnet, FTP, TOAD

Work Experience:

Client: Amgen Thousand oaks, CA

Senior Oracle DBA Duration: Jan 15 – Present

Description: Amgen is an American multinational biopharmaceutical company headquarters in California. Amgen is world’s largest independent bio technology firm. In 2013 Amgen introduced two product line which are closely related to drugs in prevention of infection in patients who are undergoing cancer chemotherapy.

Responsibilities:

Installation and use of High Availability and Disaster Recovery components; Oracle GRID Infrastructure / Clusterware, Oracle 12c two node RAC for the database tier.

Created ASM volumes using ASMCA and Created ACFS for GoldenGate v12.

Installed GoldenGate on 12c RAC ACFS Configured Integrated Extract and Replicate on Multitenant database 12.1.0.2.

Performed Cross platform migration and used Oracle GoldenGate to migrate database from IBM-AIX 6.1 to OEL 6.1.

Configured Extract and Replicate pumps for GoldenGate replication 11g/12c and Troubleshooting issues in GoldenGate Environment.

Used Log dump Utility to investigate data on the trail and defgen to create definition files used for replication.

Performed Zero-Down Time migration from Hp-Unix to Oracle Enterprise Linux using Expdp and GoldenGate.

Oracle 11gR2 2-node RAC & OEM Cloud Implementation for all Production databases.

Configure and Migrating oracle databases to AWS cloud infrastructure.

Experience in maintaining Oracle Data Guard & Standby Database and providing critical solution with strategic disaster recovery plans with different recovery procedures and methods. Developing and Implementing Disaster Recovery (DR) Plan using Datagaurd.

Configured Data Guard Broker and used for switchover and stopping and Starting Media recovery process.

Ongoing proactive database-level performance tuning, with a good working knowledge of Oracle internals.

Used OEM 11g/12c and Administering Oracle Database 10g, 11g and 12c databases and masking sensitive data in production databases.

Experience in creating physical and logical database design Data Models using Erwin Tool.

Generation of DDL scripts using Erwin Tools.

Patching & upgrades on Oracle 12c database (whilst minimizing or eliminating the impact to live services, i.e. using rolling node patching).

Created Oracle Apex Application from Scratch.

Developed and maintained operational and system level documentation. Developed applications using Oracle Application Express (APEX).

Created documentation, design and implemented rich user interfaces using Oracle Apex.

Have designed a monitoring Dashboard which is projected on the wall for operation team to monitor.

Upgraded databases from 11.2.0.4 to 12c in QA and Prod environments.

Worked on Oracle Enterprise Manager Express for Oracle 12c RAC standard.

Working with logical backup using Data pump and Exports/Imports Utility.

Database Load and Transformation Techniques (SQL Loader, External Tables).

Created scripts and scheduled backups in Autosys for RMAN database backups and recoveries and Cloned databases using RMAN Utility.

Installation and use of Oracle ASM (as well as traditional file system storage).

Monitored DR (Data Guard) implementations regarding connectivity issues and "log shipping" to failover site.

Creation of Users and granting them the required Roles and Privileges accordingly.

Responsible for all database activities such as User management, space management, database security management, rollback segments & creation of DB links between oracle servers.

Installed and configured Oracle 12c WebLogic server and Oracle 12c HTTP servers for the application tier and web tier.

Working with the Oracle Support Mechanisms; My Oracle Support (Metalink), Raising Service Requests.

Environment: Oracle 12c, RHEL 5/6, OEM, RMAN, Grid, Dataguard, ACFS, RAC, ASM, GoldenGate, TOAD, APEX, SQL LOADER, Performance Tuning, Data pumps, Exports/Imports

Client: XEROX, Richmond, VA.

Oracle DBA Duration: Oct 14 –Dec 14

DESCRIPTION: Xerox Corporation is one of the world’s leading publicly traded providers of business process and document management services. The company offers a range of copiers, multifunctional printers and related supplies. The company offers data management and business modeling software.

Responsibilities:

Involved in 24x7 production database maintenance and on-call support

Worked on maintenance of Oracle 10g/11g RAC databases on Linux and Configured 2 Node RAC on Grid Infrastructure

Administered and monitored over 150 databases both on 10g/11g on prod/test/dev environments

Administering Oracle Databases 10g/11g of sizes ranging from 100GB to 30 TB

Migrated databases from File-system to Automatic Storage Management (ASM)

Involved in migrating applications from Solaris 10g/11g to Linux 11.2.0.3 using Transportable Tablespace, RMAN Convert

Up-gradation of single instance databases from 10.2.0.4 to 11.2.0.3 on Linux

Responsible for using Flashback query mechanism along with automatic undo management

Experience in Creating Physical and logical database design Data Models using Erwin Tool.

Installed 12C grid control and Used Oracle Enterprise Manager Grid control 11g/12c for monitoring databases

Creating stored procedures using PL SQL scripting.

Developed Test Cases and Test Scripts for System and UAT Testing.

Programming in shell to create shell scripts that automate the database backups and maintenance.

Involved in Mass Agent Deployment using Oracle Enterprise Manager 12c

Implemented Data Guard with maximum availability and performance configurations for production databases

Worked on Active data guard, Fail over and Switch over cases

Hands on Experience in SQL Tuning and SQL Optimization.

Created Oracle Tables, Table Partitions, Views, and Materialized Views

First hands-on experiences in software and firmware maintenance of both the Database and Storage servers in the Exadata database machine including upgrades and patching.

Configured Exadata Quarter Rack and Supported Other Oracle projects on Exadata X3 and X4. Recovery testing, and Dataguard creation.

In Exadata X3. Did exachk, exaconf.sh, DB Migration, cell server addition, metrics and DB stats, DB List Partitioning, Scripted RMAN for backup

Worked on database security, Transparent Data Encryption, Created tables with Encrypted Columns and Managed Encryption Keys

Implemented the TDE column encryption to encrypt sensitive data stored in Tables for Security Remediation.

Configured Oracle Wallet for Encryption functions and involved in setting up Transparent Data Encryption for protecting sensitive data in the database.

Creation of Users and granting them the required Roles and Privileges accordingly

Cloned schemas, objects and data on new server using Data pump utility

Migration of client's spatial data to cloud based instance of Oracle 12c databases.

Decreased Contention by reducing the Wait Events as a part of Performance Tuning

Implemented Backup and Recovery Strategies using RMAN and used Recovery advisor to repair data block corruptions & data dictionary corruptions

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

Responsible for all database activities such as User management, space management, database security management, rollback segments & creation of DB links between oracle servers

Involved in Tuning Query's, Stored procedures by making use of PL/SQL collections and its BULK FETCH and BULK INSERT features

Ability to work effectively and can liaise as a part of team monitoring proactively

Environment: Oracle 10g, 11g, RHEL 5/6, SOLARIS, IBM AIX, OEM, RMAN, Grid, RAC, ASM, Data-guard, Golden Gate, Oracle Spatial, TOAD, TDE, SQL*LOADER, Oracle X4 full rack Exadata machine Performance Tuning, AWR, ADDM, ASH, Data pumps, Exports/Import.

Client: Bremer Bank, Eau Claire, WI.

Oracle DBA Duration: Sept 11 –June 14

DESCRIPTION: Bermer bank provides a comprehensive range of banking, investment,trust and insurance services.Bremer financial corporation is a privately held,$10 billion regional financial services company jointly owned by the Otto bermer trust.

Responsibilities:

Involved in 24x7 production database maintenance and on-call support.

Installed, configured, and maintained Oracle 10g and 11gR2.

Upgraded databases from Oracle 9i, 10g to 11g.

Involved with installation and maintenance of ORACLE 10g RAC/ORACLE 11g RAC and Standby Databases (Oracle DataGuard) for High Availability and Disaster Recovery purpose.

Restoration and Recovery of databases at the times of occurrence of critical failures.

Responsible for installing, upgrading and configuring the Oracle environment by creating databases, storage structures and objects, database backup and recovery, monitoring and optimizing database performance.

Applied CPU patches.

Implemented Oracle database backup & recovery solutions using RMAN and manual methods.

Performed block recovery using RMAN.

Moving data between databases using Data Pump.

Performed large batch jobs, and tuning of SQL queries and database systems.

Created User accounts, Roles and granting required access permissions and privileges to the database based on the applications they are accessing.

Partitioned large tables for better performance and manageability.

Installed and configured GoldenGate for replication.

Responsible in configuring and backing up database using RMAN, Hot backups, Cold backups and Logical backups.

Migrated databases from Sun Solaris, HP-UX to IBM AIX, and Windows to Linux.

Written PL/SQL Stored Procedures, Packages, Functions and Triggers.

Worked with Data Pump to take the logical backups of databases.

Experienced in performing Point-in-Time Recovery.

Performed Capacity Planning and Bench Marking

Load and Transform data using SQL*Loader and External Tables

Logical and Physical Database Design

Clear documentation was prepared on all the processes like program specification, bugs fixing logs & change requests for future reference.

Performed capacity planning, Extracting, Transforming and Loading (ETL) data using SQL*Loader and External Tables.

Environment: Oracle 11g RAC/10g RAC, HP-UX, REDHAT LINUX, SUN SOLARIS, IBM AIX, ASM,OEM (Grid Control), RMAN, Explain Plan, AWR, ADDM, Data Pump, SQL*Loader, GoldenGate

Client: South Central Railway, Chennai, India.

Role Oracle DBA Duration: Aug 08 – July 11

DESCRIPTION: South central railway is one of the 16 railway zones in India .south central railway zone is the second revenue earning zone in Indian railway zone. Every year 500 million passengers travel on this network and it earns 110 billion. It covers 5,752 km of track

Responsibilities:

Maintenance of Oracle Production, Development, Testing and QA databases.

Installation and configuration of Oracle 9i, 10g databases.

End-user requests in terms of assisting them in effectively create tables, views, packages, sequences, schema refreshes.

Worked with developers to provide queries and tuning the queries for better performance.

Issues related to Space Management, Locks, Database Hit Ratios, Backup failures and UNIX related On-Call alerts.

Resource Management (Create and manage Indexes, Clusters, Tables), allocate and manage physical storage structures like Data files, Redo logs, Control files. Allocate and Manage logical storage structures like Table spaces.

Database backup & Recovery.

Load data using SQL Loader.

Alert monitoring and Ticketing.

Developed SQL, PL/SQL Programs such as procedures, functions, packages and triggers

Coordinated with developers and users connecting to different databases, setting policy and procedures as they relate to database maintenance, security, backup & recovery, SQL coding guide lines.

Coordinating Backup and Recovery operations over all databases.

Creation of users and Granting them privileges and roles.

Export and Import Data according to the users request.

Environment: Oracle 10g RAC/9i/8i, SUN SOLARIS, REDHAT LINUX, OEM (Grid Control), RMAN, Explain Plan, Data Pump, EXP/IMP, SQL Loader, STATSPACK, AWR, ADDM

Contact this candidate