Resume

Sign in

laxmi narsimha konatham

Location:
Norcross, Georgia, United States
Posted:
January 25, 2017

Contact this candidate

Laxminarsimha konatham

(678)-***-****

acyg0z@r.postjobfree.com

Oracle Database Administrator

Summary

Over 8 years of professional experience as Oracle Database Administrator having good experience in database administration, database installation, upgrade, migration, applying patches, performance tuning, RAC installation and maintenance, setting up and configuring Data-guard, performing all kinds of backups and recoveries, cloning databases, auditing and product support

Hands on experience on Oracle (9i/10g/11gR1/11gR2/12C), installed and configured Oracle databases on different platforms of UNIX (RHEL 4/5, OEL 5/ 6, Solaris 10, HP-UX) and Installing, upgrading and configuring Red Hat Linux.

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

Hands on experience in migrating databases and Expertise in troubleshooting Oracle GI (Grid Infrastructure (RAC+ASM)) issues.

Extensive experience with Oracle Advanced Security Option and Label Security like TDE, Network Encryption and strong authentication.

Upgraded and configured OEM 12c from 11g with dual OMS and Installed/rolled out OEM agent processes on all database, middleware and application servers.

Upgraded OEM Cloud Control and all server agents from 12.1.0.2 to 12.1.0.3.

Working Experience in Exadata x3-2, x4-2 migrated databases to Exadata RAC environment

Extensive experience in Dataguard Configuration, Implementing and Maintaining Standby Databases i.e. Active Dataguard & Snapshot Standby

Configured Dataguard broker for both RAC and standby databases in environment and Maintained Data-guard Server and troubleshooting issues

Working experience in Installation of 12C RDBMS S/W, Installation 12c RAC and Maintenance, setting up and configuring Data-guard, performing all kinds of Backups and Recoveries, Cloning databases

Hands on experience in Installing Golden-gate Replication, tools in GoldenGate logdump, defgen for troubleshooting issues in environment

Applied Oracle PSU patches (Security Patches) using Opatch utility and upgraded databases from 9i/10g to 10g/11gr2/12C and expert in applying Oracle PSU and CPU patches.

Installed and supported the Clean Address add-on product for Banner and Used Data masking to protect private and confidential data by replacing sensitive information with dummy data

Experience in Performance Tuning, tuned various large critical OLAP and OLTP databases of Terabytes size using various tools like STATSPACK, AWR, SQL-Trace, Tkprof, Analyze, ADDM and Explain Plan Methods

Extensive knowledge in Database Backup and Recovery concepts using RMAN utilities (scheduling full/incremental/cumulative backups, hot/cold backups writing/editing UNIX Shell Scripts for RMAN).

Experience in logical backups and Database migration tools with Datapump, Export/Import and Transportable Table-spaces.

Good experience in Patching and Upgradation from 10g, 11g to 12.1.0.2

Extensive experience in configuring and implementing ASM and proficiency in using ASMCMD and ASMLIB, Flash-Back Technology, Log Miner.

Experience in implementation of enterprise databases on enterprise Storage Solutions using Storage area Networks (SAN) / Network Attached Storage (NAS).

Used oracle configuration assistants like Database Configuration Assistant (DBCA) for creating databases, Database Upgrade Assistant (DBUA) for upgrading databases and Network Configuration Assistant (NETCA) for creating a Listener, TNS names to establish a Client-Server environment.

Experienced in creating Amazon EC2 instances and setting up security groups.

Developed Scripts for AWS Orchestration and Configured Elastic Load Balancers with EC2 Auto Scaling groups

Have good knowledge about Physical and Logical structure of a database

Experience in database cloning with RMAN, Capacity Planning, Database Refresh and Patch management.

Experienced in maintaining databases on large Production, Testing and DEV environments.

Experience as On-Call 24x7production DBA support, application/development DBA.

Handled daily production problems/change requests (DBCRS) with Oracle.

Developed database monitoring/health check alert scripts for database uptime/downtime status, and sizing issues using grid control (OEM).

Proficient in raising TAR with Oracle Support and using Meta-link 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:

Database

Oracle 13c,12cR1, 11gR2, Oracle 11gR1, Oracle 10gR2, Oracle 9i, SQL server 2008 R2, 2012

Oracle Products

OEM 12C, 11g (Grid Control), Oracle cluster ware, Data guard broker, RMAN, Data pumps, ASM, AWR, ASH, ADDM, CRSCTL.

Operating System

Red Hat Enterprise Linux (RHEL) 4.x, 5.x, 6.x, Sun Solaris 5.8, 5.9, 5.10, Windows /XP/2003/2008, IBM AIX, HP UNIX 11i.

Languages

Core JAVA, JDBC, SQL, PL/SQL, UNIX shell scripting.

Tools

OEM, TOAD, Fog light, Redgate

Professional Experience

Morton Salt, Chicago, IL Jan2015 – Till date

Role: Sr. Oracle Infrastructure DBA / Sr Oracle Database Admin

Responsibilities:

Oracle Infrastructure and Operation database administrator support and Responsible to provide 24x7 database administrative activities over different database servers

Installed OEM 13C, registering databases, creating OEM users, deploying agents, monitoring databases, registered Databases in OEM Administering Oracle Database 10g, 11g and 12c using Enterprise Manager

Implemented Monitoring Templates and Incident Rule notifications using OEM cloud control 12C/13c for database alerting.

Configure Auditing on Oracle database to suite needs of security and managements.

Setup, configure, developed database automatic monitoring of alert log, database status, space usage, connectivity, SGA etc.

Implement Oracle TDE column encryption for advanced security.

Performed DB migration from Windows to Solaris, implemented Oracle TDE to satisfy PCI requirements for credit card data Redaction.

Worked in Build stage, Responsible for Installation of 12c RAC and Managing RAC Environment efficiently and involved in migration of standalone databases to RAC

Involved in capacity planning, Tuning the RAC interconnect, Finding RAC wait events. And Tuning the RAC using the Enterprise Manager Grid Control.

Maintaining ASM in RAC environment and Monitoring Health checks OCR, voting files and Interconnect for better performance and troubleshooting issues in RAC environment (11GR2 and 12c)

Faced and fixed database upgrade issues while working on ASM upgrade in Oracle restart environments

Configured Mutimaster Active- Active configuration using GoldenGate and configured extract and replicate pumps for goldengate replication 11g/12c and troubleshooting issues using report files, Monitor status, lag and Checkpoint with goldengate

Performed Cross platform migration and used Oracle Golden Gate to transfer database from Hp-unix to RHEL

configured integrated extract, integrated replicate and coordinated replicate on oracle multitenant databses 12.1.0.2

Created blackouts in OEM to disable alerts from OEM while performing database maintenance activities such as PSU patching

Exadata and Involved in moving databases in Exadata x4-2, x3-2 Environments

Worked with oracle platinum support, applied Security patches to Exadata Quarter Rack

Worked on with Oracle on Exadata related Issues/Investigations & Troubleshooting Exadata using cellcli and IORM

Installed Disaster recovery databases using Data Guard and configured standby databases in maximum availability and maximum performance modes.

Configured Physical Standby databases using data guard and converted Physical standby to Snapshot Standby and active data-guard depend on Business Requirement.

Used Dataguard broker to monitor Dataguard status periodically and Maintained DR server and troubleshooting issues in Data Guard environment

Proactively Monitored and identified areas that need to be improved in the application and database using Stats pack, AWR, ASH, ADDM and OEM Grid Monitoring.

Experience in creating and managing user accounts, security, rights, disk space, quotas and process monitoring in Red hat Linux.

Manage deployment, maintenance, support and upgrade of servers, hardware, software, operating systems in server environment.

Used Oracle Enterprise Manager to protect sensitive data in production databases.

Enforced Security administration, system monitoring by adding and removing users, configuring quotas, auditing at different levels, and analyzing security problems

Applied patching on 11g/12c and Up-gradation of Hp-unix critical databases from 11.2.3.x to 11.2.4.x.(11gr2)

Scheduled Oracle Jobs using DBMS_SCHEDULER and Backups using CRONTAB.

Configured Goldengate 12c RAC -RAC Active configuration with 12c database and Weblogic Administrator for Fusion Applications with SOA

Restoration and Recovery of databases at the times of occurrence of critical failures and Performed Block Recovery and Data file recovery using RMAN

Used Datapump for exporting and importing of database objects between databases

Used RMAN for backups and recovery and configured databases in Catalog server and involved in backup of Catalog database

Data Refresh from Production to lower environments using RMAN Duplicate Database

Handling service requests within Service line agreement and Assisting in implementation of change control process in production and Handled daily production problems/change requests (DBCRS) with Oracle

Installed and supported the Clean Address add-on product for Banner.

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

Configured and Installed Oracle-Wallet-Management (OWM) for Data Security.

Daily Health Check Up of the Database and SQL Queries using AWR, ADDM and TKPROF and Tuned the SQL’s using TKPROF and STATSPACK reports.

Developed PL/SQL Stored procedures, Triggers and Functions and embedded them in packages and Involved in fine tuning stored procedures by making use of PL/SQL Collections and its Bulk Fetch and Bulk Insert features

Trouble shooting various database performances by proper diagnosis at all levels like SQL, PL/SQL, database design, database tables, indexes, instance, memory, OS and java calls

Performance Tuning for SQL queries which are Running slow and taking more CPU cost and creating tables with different partition techniques and maintenance

Involvement in day to day activities like Space management, rectification of Lock problems, managed quotas, Table partitioning to improve I/O access.

Worked on Cloud Migration project, worked on servers and databases running on VMware

Alert log Monitoring for critical databases every day in the production environment

Used BMC Remedy tool for all change management process

On-Call 24x7 production DBA support and Worked with off-shore and coordinating work with prod support for managing databases

Environment: Oracle 11gR2/12C, RHEL 6.X,OEM cloud control 12C/13c/11g/10g, RAC, NFS, Data guard, GoldenGate, VMWARE, AWR, ASH, ADDM, EXPLAIN PLAN, opatch auto, VMSTAT, DSTAT, UPGRADATION 11g TO 12C, Oracle Transparent Data Encryption, EXADATA, Data pump, SQL, TOAD, UNIX, AWS (EC2, Auto-Scaling, S3, putty and Winscp.

AEGON USA, IA Jan2014 – Dec 2014

Role: Sr. Oracle DBA

Responsibilities:

Implemented Oracle Database 11gR2 2 node Real Application Cluster (RAC) using Oracle Cluster-ware on UNIX and Installed RAC on Linux.

Installed, setup and configured Oracle Enterprise Manager Cloud Control 12c as a tool of administration, performance tuning, monitoring and alerts.

Installed and Configured Oracle 11g databases on AIX 6.1 and RHEL 6.X

Worked on large databases size greater than 12TB.

Installation, Maintenance, Administration and troubleshooting of Red hat Enterprise Linux 5.x/6.x servers on various hardware platforms.

Administrate Enterprise User Security for advanced security options using Enterprise Security Management.

Created and maintained users and groups with proper security.

Implemented Oracle TDE to satisfy PCI requirements for credit card data encryption (Oracle Advanced Security)

The Data Redaction policies enable you to create a wide variety of function conditions based on SYS_CONTEXT values, which can be used at runtime to decide when the Data Redaction policies will apply to the results of the application user's query.

Performed DB migration from Windows to Solaris, implemented Oracle TDE to satisfy PCI requirements for credit card data encryption.

Used Automatic Workload Repository (AWR) & Automatic Database Diagnostic Monitor (ADDM) in RAC for Performance Tuning.

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

Setup ODI 12c -- upgrade existing ODI 11 -- Integrate with OWB and Setup OEM 12c Ops Center for upgrading and patching Linux, Solaris and Databases and added and deleted RAC nodes using Oracle OEM Provisioning Pack.

Resolved numerous issues involving 10g/11g databases on 11g R2 Grid/RAC and 11g ASM.

Maintained systems configuration and managed the installation and integration of systems patches, updates and enhancement.

Implemented Best Practices for migration databases to Oracle EXADATA x3-2

We successfully switched over databases to secondary databases during DR testing using Dataguard broker and Configured Dataguard broker

Involved in designing of Disaster Recovery using Data Guard and High Availability using 11g RAC.

Achieved High Availability, Data protection and Maximum performance by maintaining both Physical and Logical Standby databases.

Used Dataguard broker to monitor Dataguard status periodically.

Installed 7 standalone servers on ASM and maintained DR databases on it.

Performed various tasks on ASM, creating a disk group, adding a disk to disk group, making disk Online and Offline and troubleshooting issues in ASM environment.

Installed Golden gate on source and target side for Replication and implemented load balancing topology using Goldengate.

Configured Golden Gate Parameter files for Extract and Replica process for replication

Converted Classic extract into Integrated Extract and used “batchsql” to improve performance of GoldenGate Installation

Used Shareplex to provide Data Accuracy and Integrity to ensure that target instances are accurate representations of the source database.

Performed automated backups and scheduling using scripting.

Configured RMAN and registered databases in Catalog server.

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

Implemented Oracle database backup & recovery solutions using RMAN.

Extensive use of Oracle Data Pumps Exports/Imports utility for moving data among the servers.

Generated AWR reports, ADDM reports for fine performance tuning and worked closed with PL/SQL developers to tune TOP SQL running queries in databases

Used Invisible Indexes, and turn off indexes temporarily to check how queries perform without them and Effectively made use of Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views & Query Re-Write

Perform other regular DBA activities including space management and performance monitoring and Optimization and tuning SQL queries using TRACE FILE, TKPROF, EXPLAIN PLAN

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

Performed Quick System Review by using Education Performance Index (EPI), System Performance Index (SPI) and Memory Performance Index (MPI). Disk Performance Index (DPI). And calculated the Total Performance Index (TPI).

Created User accounts, Roles and granting required access permissions and privileges. Written Stored Procedures and Triggers for database maintenance and management using PL/SQL, UNIX Shell Scripts for backups.

Maintained application and security polices and resolve hardware/software interface problems

Installed, Configured & Upgrade of Linux operating system and Performed LAMP installation and configuration on Ubuntu, Red hat and Amazon Linux Instances.

Performed installations of SQL 2008\R2\2012 on clustered and standalone servers

Upgradation of SQL server versions and applying patches and hot fixes.

Adding nodes to already existing clustered servers as a part of data load\High availability

Configured Transactional Replication and Log Shipping with SQL Server Management

Tuned the Database with Initialization Parameters. Viewing the Initialization Parameters with Enterprise Manager. Increasing Performance by Tuning the DB_CACHE_SIZE parameter.

Implementation of SQL server logins, Roles and Authentication modes as a part of security policies.

Environment: Oracle, 10g, 11g, Unix, Sun Solaris, Linux, RAC, DBCA, GOLDENGATE v11,v10, Dataguard, EXPLAIN PLAN, DATAPUMP,EXADATA x3-2,ASM, AVAMAR, RMAN Cloning, OEM 11g,OEM Cloud Control 12c, STATSPACK, TKPROF and putty, Oracle Transparent Data Encryption, SQL Server 2008,2008R2,2012, log shipping, Mirroring

Guardian Life Insurance, NY Oct 2011 –Dec 2013

Role: Sr. ORACLE DBA

Responsibilities:

Installed, setup and configured Oracle Enterprise Manager Cloud Control 12c as a tool of administration, performance tuning, monitoring and alerts.

Installed and configured 2 Node RAC on 11gR2 and performing Monitoring Health checks in RAC environment.

Migrated Oracle R12.2.6 to Oracle Cloud and Upgraded over 65 Oracle 11.2 to 12c PDB database -- setup TDE security

System is a multi-application tier node with a 3 node RAC environment and Implement Oracle TDE column encryption for advanced security.

Setup, configure, developed database automatic monitoring of alert log, database status, space usage, connectivity, SGA etc.

Installed 13 standalone servers on ASM and migrated databases to ASM environment.

Developed, implemented, administered, and maintained policies and procedures for ensuring the security and integrity of the company's databases.

Implemented database backup & recovery, data models, database designs,

Configured Oracle Data guard on 10G for Oracle Disaster recovery. Worked on both Physical standby and Logical standby databases and resolved issues in DR environment.

Converting Physical standby to Snapshot standby for testing purposes.

Achieved High Availability, Data Protection and Maximum performance by maintaining both physical and logical standby databases.

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.

Installed Golden gate on source and target side for Replication and implemented load-balancing topology using Goldengate.

Implemented Oracle database backup & recovery solutions using RMAN

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

Performed cloning and refresh of Database from production environment to test environment using RMAN Duplicate database and Data pump import export.

Identified and fixed the logical block corruption using RMAN.

Handling service requests within Service line agreement.

Upgraded databases using Database Upgrade Assistance (DBUA).

Involved in the optimization of various SQL and PL/SQL using EXPLAIN PLAN and TKPROF and Creation and administration of Virtual Machines using VMware.

Designed bash scripts to automate application and system management activities.

Performed DB migration from Windows to Solaris, implemented Oracle TDE to satisfy PCI requirements for credit card data encryption (Oracle Advanced Security).

These scripts provided the following functionality: application startup and shutdown, monitored systems and applications health, and web site management.

Involved in optimizing SQL statements using Indexes and Hints.

Made use of the REF CURSORS in stored procedures for report generation.

Involved in the creation and modification of different PL/SQL object like Packages, Stored Procedures and Triggers.

Involved in configuration files like Listener.ora, Tnsname.ora for Client–Server environment using network configuration assistant.

Environment: Oracle 9i, 10g, Sun Solaris, windows, Unix, RMAN, DBCA, Informatica, GOLDENGATE, Data guard, EXPLAIN PLAN, Cloning, OEM cloud control 12C, STATSPACK, RHEL 5.x/6.x, VMware, Web Servers, Oracle Transparent Data Encryption,TKPROF and putty

Magna InfoTech, Bengaluru, INDIA Aug 2008 – Sep 2011

Role: Oracle DBA

Responsibilities:

Implemented Oracle Database 10g R2 Node Real Application Cluster (RAC).

Maintained and troubleshooting cluster-ware components in 10G RAC environment.

Installed 10g standalone servers on Sun Solaris and installed databases on it.

Used oracle configuration assistants like Database Configuration Assistant (DBCA) for creating databases, Database Upgrade Assistant (DBUA) for upgrading databases.

Configured listener and TNS names manually.

Involved in Up-gradation of databases from 9i to 10g.

Configured Oracle Data-guard for Oracle Disaster recovery on 10g Solaris.

Achieved High availability, Data protection and maximum performance by maintaining both physical and logical standby databases.

Converted physical standby databases to Snapshot standby database.

Implemented Oracle database backup & recovery solutions using RMAN.

Configured and Tuned RMAN for better performance and backup strategies.

Involved in writing for shell scripts for taking RMAN backups.

Restored and Recovered database at the times of occurrence of critical failures.

Created user accounts, roles and granting required access permissions and privileges to the database based on the application they are accessing.

Experience in Installing, upgrading and configuring Red Hat Linux.

Experience in administering, installation, configuration, support and maintenance of Linux.

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

Performed automated backups and scheduling using scripting.

Written Stored Procedure and Triggers for database maintenance and management using PL/SQL and Involved in gathering requirements from end users.

Estimate growth of database size by detail analysis of the company's future policies and generating reports for the management to act in advance.

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

Environment: Oracle /10g/9i, Sun Solaris 5.x, Unix, OEM 10g, Shell Scripting, Oracle 10g RAC, TOAD, putty, STATSPACK, EXPLAIN PLAN.

Educational details:

Bachelor of Technology, JNTU, INDIA.



Contact this candidate