Kondal Rao

Sr. ORACLE DATABASE ADMINISTRATOR

Email: acucy0@r.postjobfree.com

PHONE: 425-***-****)

EXPERIENCE SUMMARY:

About 9+ Years of experience in IT industry as Oracle Database Administrator having hands on experience in database administration, production support, installation, configuration, upgrades, patches, performance tuning, backup and recovery, cloning, space management, database security and performing upgrades of Oracle RDBMS environments on various platforms LINUX, AIX, UNIX, SUN SOLARIS

Extensive knowledge on database administration of Oracle 9i, 10g, 11g,12c with experience within very large scale database environment and mission critical large OLTP and OLAP systems.

24*7 production database support with Support to developers & end-users.

Expertise in Installation, maintenance and tuning of RAC Applications.

Implemented and supported Oracle databases 8i/9i/10g/11g/12c in variety of different environments including Unix, Sun Solaris, Red hat Linux IBM-AIX, HP-UX, Microsoft Windows 2000/NT Servers and Linux.

Proficient in Exadata configuration, maintenance, support, dataguard, backup, recovery, failover, switchover.

Implementation of High Availability solutions with Oracle 10g RAC, Oracle 11g RAC Standby Database Data guard, Replication.

Expertise in requirements analysis, database development, debugging, problem solving and user support.

Expertise in SQL Server Clustering and Database Mirroring implementation.

Expertise in Multi-server management features of SQL Server by using linked servers.

Hands on experience of MS SQL Server 2008 & 2012 Enterprise servers on production, Test and Dev boxes.

Actively involved in database Performance tuning-monitoring the 2000, 2005 and 2008 (r2) SQL server, planning and implementation of new database installations and upgrades and making configuration changes.

Expertise in development of stored procedures, packages, triggers, SQL queries, reports, forms and scripts.

Experience in Design, development, testing, performance tuning, deployment, and support in Datawarehouse system.

Proficient in Client Interaction for activities such as initial Requirements gathering, Tracking requirement changes, building functional test scenarios, coordinating performance testing, user acceptance testing and Production Support.

Expertise in 11g features like Database Replay, Partitioning, Schema Management, Transaction management, Caching and Pooling, Resiliency, Case sensitive passwords, Virtual columns and Security.

Administered DB2 subsystems in Prod, QA, Test and Development regions

Experienced in setting up/installation and configuration of release 11g R1 RAC with ASM and Raw Devices and 11g CRS.

Expertise in Oracle Goldengate installation, configuration.

Hands on experience in implementing goldengate classic and integrated capture and integrated replicate process.

Experience in configuring uni directional and bi-directional goldengate replication.

Hands on experience with Installation, Configuration, Migrations, Oracle Data Guard, Backup and Recovery using RMAN, Disaster Recovery and Patching, upgrading and administering of Oracle Databases on Oracle 11g/10g/9i.

Expertise in Oracle Architecture, I/O tuning, Capacity planning, space management, Memory Tuning, Performance tuning, Backups, Recoveries, RMAN backups, Networking, troubleshooting.

Proven ability of providing production support for 24X7 on multiple and large databases of over 4 TB using Oracle 11g,10g RAC, 9i, 8i,

Experience with Oracle database including SQL, PL/SQL, and UNIX shell scripts.

Installed and configured Goldengate 9.5,10.2,11.2. Experience in using Goldengate in moving large volumes of transactional data, with minimal impact to online systems.

Expertise in performance tuning using STATSPACK, EXPLAINS PLAN, SQL TRACE, TKPROF, AWR and ADDM reports.

Installed, configured and maintained ASM enabled RAC and single instance databases.

Expertise in Oracle Enterprise Manager (OEM) Grid Control, TOAD, RMAN.

Applied patches, Migration of database across different platforms and Cloning/Data Refresh from production environment to setup test and development environments.

Expertise in Oracle Architecture and experience in installation, upgrades, patches and TAR support.

Expertise in maintaining Database Security using auditing.

Expertise in designing and implementing Oracle databases, cloning of databases and setting up RAC database.

Proficient in all DBA responsibilities such as Instance tuning, user management, space management, monitoring.

Migrated single instance databases to multi node 10g RAC environment for high availability and load balancing. .

Extensive performance tuning experience, specializing in instance tuning, Oracle9i and 10g RAC tuning and SQL optimization.

Installation, configuration, upgrade and performance tuning of Oracle RAC.

Performed backups and tested crash recoveries using conventional hot & cold backups and RMAN.

Proven ability with mission critical databases high availability and disaster recovery environments configuration in 24*7 environments using 9i Data guard, 10g data guard with real time apply.

Managing Users, roles and privileges, space management Creating storage structures, Performance tuning.

Point-In-Time Recovery through RMAN.

Worked in both OLTP and DSS environments.

Implemented oracle streams, data guard physical standby databases, expert in BCV’S, SRDF, and managing of partitions and clustering of tables.

Excellent knowledge in Hot/Cold Backup and Recovery and Cloning of databases using RMAN, VERITAS Net Backup, IBM Tivoli Storage Manager (TSM).

Extensive knowledge on creating physical standby databases with Active dataguard.

Expertise in upgrading the Oracle databases from Oracle 10g to Oracle 11g and to Oracle 12c.

Experience in implementation of enterprise databases on enterprise storage solution using Storage Area Network (SAN)..

Good Interpersonal communication skills and Documentation Skills.

SKILLS PROFILE:

Databases Skills: Oracle 10g/11gR2, Oracle 11g/10g RAC/9i/8i, Exadata V1/V2/X2-2/X2-8, Microsoft SQL Server 2005, 2008

Tools : Oracle Enterprise Manager, TOAD, SQL Developer, Putty, F-Secure Client, Hummingbird, SQL*PLUS, iSQL*Plus, Cute FTP, Smart FTP 1.0, ERWIN 4.14, SQL- Navigator, ERWIN, Goldengate, MS Visio, Database Replay, LogMiner and Flashback data Archive.

Operating systems: Unix, AIX 4.3, AIX 5.3, Red Hat Linux RHEL 3, RHEL 4, RHEL 5,, Fedora, Ubuntu, Solaris10,9,8, HP-UX. Windows (NT 4, 2000/2003 Prof/Adv Server, XP Professional),

Database Advance Feature: RAC, Data Guard, ASM, Standby Database, Oracle Golden Gate,, Grid Control.

Oracle Utility: RMAN, RCONFIG, 12cOEM, Export/Import, DataPump, SQL*Loader, DGMGRL, ASMCMD.

Performance Tuning: Grid control, AWR, ADDM, ASH report, SQL performance analyzer (SPA), SQL Optimizer, STATSPACK, DB Artisan and OS Watcher.

EDUCATION :

Bachelor of Engineering from JNTU, Hyderabad, India.

Professional Experience

Client: T-mobile, Bothell, WA Feb 2014 – till date

Role: Sr. Oracle Database Administrator

Role & Responsibilities:

Setting up Enterprise wide RAC implementation strategies for client.

Provided production support for the 24x7Oracle database availability.

Maintenance and monitoring of oracle 12c/11g/10g database instances hosted on Linux and Sun platform.

Support multiple clients and over 500 servers, 8 ZFS appliances, several racks of Exadata and Exalogic as well as Infiniband Switch management.

Worked on creating SQL server partitioning of large TB size databases.

Worked on Exadata administration with nodes ranging from 2 to 8 and incorporating Dataguarded Exadata clusters for maximum availability.

Supported Disaster recovery of Exadata Dataguard Physical Standby. Failover, Switchover, Loss of service, Rebuild, Corruption, Loss of datafile testing.

Managed SQL Server installation (2000, 2005 and 2008), configuration, patches (service packs and security), SSIS, SSAS, SSRS, linked services, import and export data, SQL server locking, Indexing, troubleshooting and error handling. Changed control management systems such as JIRA, Version controlling (VCS) and Remedy.

Effectively made use of PL/SQL features such as Bulk Collections/Exceptions/Inserts, Bulk Binding, Ref-Cursors, Multi Table inserts, SQL Types in Bulk Operations for better performance and readability, Query optimization, PL/SQL Performance Tuning using Oracle Cost based Optimization techniques, Explain Plan, Trace, Hints and Tkprof, SQL, PL/SQL and UNIX shell scripting.

Disaster recovery of Exadata Dataguard Physical Standby. Failover/Switchover/Loss of service/Rebuild/Corruption/Loss of datafile testing.

Implemented Monitoring Templates and Incident Rule notifications using OEM 12C for database alerting.

Worked extensively on 12C OEM and configured DB alerts for DBA

Effectively made use of Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views & Query Re-Write.

Supported functional datawarehouse projects.

Developed strategies for data extraction from various source systems, transformation and loading into datawarehouse target systems.

Installed and implemented 10g/11g RAC with 4 nodes.

Responsible for Database schema optimization and Data modeling.

Worked with functional analyst to prepare the Source Target mapping specs with the business logic and also helped in data modeling

Configured Data guard to provide high availability by implementing Physical stand by database.

Worked to improve the efficiency of datawarehouse application through the use of indexes, compression, materialized views and other techniques.

Cluster Installation and Configuration, Administering databases in clusters for high availability

Upgrade and Migration of Databases from 10g R2 to 11g R1 and applying patches as per requirement.

Administered DB2 subsystems in Prod, Qual, Test and Development regions

Ensured proper backup and recovery by maintaining DB2 image copies and recovery JCLs.

Efficiently carried out DBA responsibilities in planning DB2 version migration activities, in migration phases and in performing post migration tasks.

Responsible for installing and configuring GoldenGate 9.5, Goldengate 10.4.0.19, 11.1.1.1. and upgraded to 11.2.1.0.24 on Oracle Servers.

Implemented Goldengate Solution to replicate data to provide real time data closer to user’s physical location via Active/Active Bi-directional replication in oracle databases.

Setup of High Availability of the database using RAC, Standby, Data guard.

DBA activities such as configuring Grid events, Regular Backup’s, Replication, Tuning, and troubleshooting performance issues.

Setup schemas using export and import utilities. Create users, roles and grant privileges based on the user requirements.

Developed some Unix Shell scripts to automate database operation and database monitoring.

Involve in code test and migration on all the environments. Handle requests from application team and also resolve issues reported. Set up rules in OEM to monitor space for all the environments and schedule scripts through OEM and crontabs.

Simulated copy of production databases into test databases for the application and upgrade testing.

Supported and advised the development teams on database related issues.

Assisted developers in tuning SQL statements in the applications.

Tuning heavy data loads. Monitoring and Performance tuning.

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

Space Management which includes table space creation, adding new data files.

Implemented 11i on an active/passive VERITAS Cluster Server (VCS) when 11i was not cluster-aware.

Managed Table spaces, Rollback Segments, Redo Logs and other database object.

Oracle installation, creation of database, which includes physical and logical design.

Recovered databases and clone applications Using RMAN.

Assisted developers in creating stored Procedures, Triggers, Functions, Cursors and Packages.

Responsible for monitoring and resizing Oracle database objects (Table spaces, Tables, Indexes etc)

Responsible for memory and Application tuning of the databases using the Oracle utilities like OEM, SQL Trace, TK Prof and Explain Plan.

Installed Oracle Application Express on Oracle 11g.

Partitioning of large tables for fine tuning performance.

Disaster recovery of Exadata Dataguard Physical Standby. Failover/Switchover/Loss of service/Rebuild/Corruption/Loss of datafile testing.

Upgradation and Migration of Database from 10g to 11g and applying patches whenever required.

Designed and implemented crash recovery strategies, and Hot, Cold and Logical backup plans.

Taking periodic Backup of the Database and the software using Recovery Manager and VERITAS.

Generated regular Stats-Pack reports for the performance tuning of the databases.

Experience with DBUA/Export and Import to migrate the database.

Responsible for optimizing data access and performance by tuning indexes.

Performed Replication of the Production database for setting up instances for the QA and Testing teams.

Managed the existing databases by applying new required release modification to existing database structure and applied new Oracle patches as required.

Generated Automatic Workload Repository (AWR) report to collect processes and maintained performance statistics for problem detection & self tuning purposes.

Generated Automatic Database Diagnostic Monitor (ADDM) in order to analyze data in the Automatic Workload Repository (AWR) in order to identify potential performance bottlenecks.

Environment: ORACLE, SQL*Plus,OEM/12c, Exadata V1/V2/X2-2/X2-8, PL/SQL, Oracle 11g/10g,RAC, Microsoft SQL Server 2005 & 2008,DB2, Goldengate, Shell scripting, Red Hat Linux 5,Solaris 10,Unix, VCS, Oracle Enterprise Manager, Data guard, ASM, PL/SQL, RMAN, Toad.

Client : AT&T, Richardson, TX May 2010 – Jan 2014

Role : Senior Lead Oracle DBA

Actively involved in strategic Backup, Restore and Recovery using RMAN for complete recoverability.

Performed Import and Export using Oracle Data pump utilities EXPDP and IMPDP.

Involved in Database migration from Oracle9i to Oracle 10g.

Installed and configured the Oracle Goldengate and also involved in troubleshooting Goldengate issues.

Setup goldengate uni directional and bi-directional replication between 2 data centers.

Setup monitoring for the goldengate abends, lags .

Handled database migration from Solaris to Linux.

Implemented recovery strategy by establishing recovery catalog and setup scripts for database backups using RMAN, recover and test the backups regularly.

Optimized data loading using SQL*Loader to load different types of data from flat files to the Oracle server.

Managed datawarehouse projects improvement and growths.

Performed key role in being liaison between business and technical team to conduct discussion, gathering business requirement and gap analysis.

Extensively involved in Writing PL/SQL Stored Procedures, Functions, and Packages to meet the business requirements.

Handled PL/SQL Compile-Time, Runtime Errors, and Debugging stored procedure for business logic modification.

Monitored and managed DB2 thread and locking issues.

Extensively used CA/DB2 tools to migrate database objects (CA RC/migrate), to monitor thread activity (Detector).

Setup environments for DB2 connectivity through JDBC and SQLJ drivers for JAVA based applications.

Created Unix Shell scripts to automate database operation.

OEM installation and configuration for monitoring and performance tuning.

Coordinated with .Net programmers and SQL Server developers to design the flow of operations to ensure proper synchronization between the database and the front end in both connected and disconnected modes.

Performed Database and Application Performance tuning using EXPLAIN PLAN, TKPROF, Statspack and SQL Tuning.

upgrade and character set conversion of RAC databases with the aid of Oracle's Goldengate utility.

Installation, Configure, setup of 10g RAC and add new nodes to RAC 10g Cluster to distribute the load..

Performance tuning for optimized results using tools like EXPLAIN PLAN, SQL*Trace, TKPROF, STATSPACK, AWR and ADDM reports.

Worked as part of a team and provided 24/7 support when required.

Implemented Standby Database and Database Replication to realize database high availability. Created partitions for large table to improve performance.

Administrated all database objects, including tables, clusters, indexes, views, packages and procedures..

Configured Data guard 10g R2 for physical standby database.

Created and managed both system level and object level roles and privileges for various users. Killing sessions and revoking user privileges and roles.

Environment: Oracle10g, IBM-AIX, RMAN, SQL*Plus, PL/SQL, Goldengate, DB2, Shell scripting, Microsoft SQL Server 2005, RHEL4, Unix, SQL*LOADER, Oracle OEM, Putty, Data guard, Oracle Data Integrator.

Client: Health Management System, Irving, TX Jan 2008 – Apr 2010

Role: Oracle DBA

Role & Responsibilities:

Providing 24x7 on call support for the business critical production real application cluster databases.

Managing two nodes Real Application Cluster databases on Red hat Linux advanced server 2.1.

Performed Database migration from Oracle 9.2.0. To 10.1.0.3.

Applied bug patches according to the Oracle Critical Patch alerts.

Involved in the design and implementation of the process for loading the weekly loads coming from flat files in to staging tables in the Oracle Data base using SQL* Loader and also developed a script to load the staging data into the production tables using PLSQL.

Extensively involved in Writing PL/SQL Stored Procedures, Functions, and Packages to meet the business requirements.

Developed PL/SQL Stored procedures, Triggers and Functions and embedded them in packages.

Configured the automated alerts for the production servers, which alerts DBA with the alert log errors and proactively space related errors.

Query optimization, PL/SQL Performance Tuning using Oracle Cost based Optimization techniques, Explain Plan, Trace, Hints and Tkprof. SQL, PL/SQL and UNIX shell scripting.

Cleaning the ORACLE_HOME file system by cleaning the log files, alert log file and listener.log files.

Identified and trouble shot everyday issues like locking, scripts execution, Data Audits etc.

Backup and recovery utilizing RMAN.

Installation, upgrade, Patching and management of Oracle databases on UNIX and Windows Platforms.

Created different Unix Shell scripts to help stress analysis tasks.

Working with the application support people to resolve database related issues and running the scripts for the application support people.

Performance tuning Using TKPROF, EXPLAIN PLAN, STATSPACK, AWR and ADDM reports for the Better performance.

Other duties include applying oracle database patches, creation of database users, monitoring, tuning, troubleshooting, and backup and recoveries, monitoring and optimizing database performance.

Maintaining system security, defining of roles, profiles etc.

Checking CRON jobs. Monitoring Application specific background processes.

Creating materialized views and materialized view logs to implement the table level replication for the MIS databases..

Cloned database for development needs.

Environment: SQL*Plus, Shell Scripting, SQL, PL/SQL, SQL*Plus Goldengate, Unix, Redhat Linux, HP-UX, OEM, Oracle 9i/10g

Client: Kargotec, India May 2006 – Dec 2007

Role: Jr. Oracle DBA

Role & Responsibilities:

Worked with a team of 2 DBA’s, and coordinating with UNIX system administrators for the setup, installations, upgrades of Oracle 9i and 8i databases for test, development, and QA.

Reconfigured the existing physical database layout, increasing the performance of the complete system by 20%, including better use of the hard disk space.

Installed, created and maintained new oracle 9i and 8i instances. Upgraded several Oracle 9i instances from 8i.

Connectivity with different client programs using ODBC.

Maintained backups for recovery using RMAN in tapes and disks.

Planning and implementing Backup strategy for the databases using RMAN, Scripting backups, once in two weeks on the application database.

Expertise in cloning using RMAN Duplicate DB and hot backups to create Test, QA, DEV Instances.

Periodically fine-tuned and optimized the database performance for data integrity and maintained the databases for the day-to-day DBA activities.

Redesigned the database backup/recovery scripts to log errors, and to be consistent/ robust.

Modified and maintained database structures and views for the core system.

Performed work related to importing and exporting data using IMP and EXP tools in Oracle, file structures.

Reduced DBA off-hours support needs by 60% through planning and proactive monitoring.

Implemented automated backup strategy using the UNIX shell script and CRON Utility.

Cloned database for development needs.

Worked as Production Support for Oracle based systems and Unix based Server environments.

Creating users and database links, snap shots on production and development servers.

Applied database patches using Opatch utility & building Clone instances for Development and Test teams.

Performed Backup and Recovery using RMAN

Environment: Oracle 9i/8i, SQL, RMAN, SQL* Loader, SQL* Net, SQL* Plus, Unix, Statspack, Export / Import, UNIX, AIX, Win NT Server.

References: Available on Request

Contact this candidate