SRINIVAS JONNALAGADA

Phone: 848-***-****

Email: acyyh4@r.postjobfree.com

SUMMARY

15+ years of experience as Oracle Database Administrator supporting 24/7 OLTP and Data warehouse systems on 8i, 9i, 10g, 11g and 12c on operating systems like Solaris, HP-UX, AIX, Linux, and Windows

In-depth understanding of security and backup procedures to ensure database integrity.

Build-Installation, upgrading and migration across platforms of Oracle (9i, 10g,11g & 12c RAC - DATAGUARD) were installed patch fixes bugs and security patches are installed

Hands-on experience in planning & designing Oracle Backups and Recovery strategies like RMAN, export/import, Data pump

Experience with Database Security Products such as Database and Audit Vault, Data Masking and Transparent Data Encryption.

Proven expertise in optimization of Oracle SQL Queries.

Hands on experience in database security, backup, recovery, and archival concepts and procedures and tuning experience with SQL

Migration and Upgradation of Databases from Oracle 9i to Oracle 10g & Oracle 10g to Oracle 11g and Patch set administration for Oracle

Experience in providing technical support to cross-functional teams for multiple applications in development, QA and production environments and trouble shooting database related problems.

Excellent Leadership, Communication and Inter-personal skills.

Used Remedy, Pac2000 as change management tools to promote changes through various environments.

TECHNICAL SKILLS

Databases : ORACLE 12c/11g/10g /9i /8i, SQL Server 2000, MS Access,

RDBMS Tools : Developer2000 (Forms 5.0/4.5), Reports (3.0/2.5)

Operating System : Windows 2000/2003 Enterprise servers, Sun Solaris 8,9,10 AIX, Linux

Languages : C++, SQL, PL/SQL

Database Tools : RMAN, SQL*Loader, Import/Export, OEM Grid, Erwin, Database Vault,

VPD (Virtual Private Database), expdp/impdp

High Availability : Oracle RAC, Physical /Logical Data Guard, Advanced Replication

SHAREPLEX, Oracle Golden Gate

Third Party Tools : Toad.

CERTIFICATIONS

Oracle 10g Certified Database Administrator Professional

Oracle 9i Certified Database Administrator Professional

PROFESSIONAL EXPERIENCE

Bank of the West, San Ramon CA July 2015 – Till Date

Sr. Oracle DBA

Responsibilities:

Implementing user level security, object level security, data encryption, data masking and Fine Grained auditing using DBMS_FGA package.

Installed and Configured Delphix Data Masking and Virtualization tool which is an enterprise-wide solution for the protection of sensitive information in non-production environments.

Upgraded Database from 11.2.0.3 to 12.1.0.2

Installed and Configured Golden Gate Bi-directional on RAC environment.

Had scripts and monitoring setup done on OEM to monitor log lag.

Worked on the entire life cycle of all projects with Data Architect and the Data Modelling team and provided necessary solutions and ideas at the Database level.

Implementation of Database Vault and Data Masking for BIDM Databases to protect HR, Federal and Finance Data. Installed Database Vault software, created realms around sensitive objects, defined rules and policies around database access and created secure application roles.

Involved in setting up / managing standby databases using Data Guard

Tuned SQLs which were badly performing both from Business and ETL jobs, either by modifying the Sqls or using Hints or by creating Profiles with the SQL Ids.

Perform Masking for HR schema after cloning production database

Handled 2 Databases which were close to 100TB each.

Participate in researching new technologies, tools and methodologies as they emerge that may be applicable to the Data ware house architecture

Implement Database Partitioning Strategies/Compressions

Involved in setting up Resource Manager.

Cloning of production databases for test and development purpose on project basics.

Worked with a team of technical and business users in a dynamic fashion to meet project milestones and objectives.

Environment: Oracle RAC 11g/ 12c, Linux 3.8.13, Data Guard, Golden Gate, Rman, Expdp

NetApp, Sunnyvale CA July 2011 – July 2015

Sr. eDW Performance Engr

Responsibilities:

Monitor and tune Oracle Database for Optimum performance

Identify application bottlenecks and provide required solutions.

Worked on Oracle Golden Gate Replication and setup GG on multiple projects with different groups to EBI.

Provide performance solutions for queries generated by OBIEE application & ETL. Used various tuning options such as parallelism, indexing, materialized views and statistics with/without histograms to tune about 200+ queries and reduce the response time from minutes to seconds.

Worked on Database Vault and Data Masking for EBI Databases to protect HR, Finance and Federal Data. Installed Database Vault software, created realms around sensitive objects, defined rules and policies around database access and created secure application roles.

Perform Masking of HR schema after cloning production database on to our Non Prod Dbs.

Provide L4 support and technical guidance to production support team.

Designing Materialized views to enhance performances

Implement Database Partitioning Strategies/Compressions

Worked with support team to define methods for implementing solutions for performance measurement and monitoring.

Provide guidance to delivery team on DB deployment, security and performance requirements

Provide to management team the status updates, recommendations and strategy planning support

Database upgrade from oracle 10g R2 to Oracle 11g R2

Evaluating Oracle patches,testing and providing game plans to operation DBA’s

Implemented NetApp Snap Mirror strategies for various activities like DB backup, Cloning & Standby Database

Designed and Developed Flexplore database environment to off load PROD database for ADHOC reporting.

Develop POC on new technologies & work with other Architect teams to implement solutions.

Install, Patch and Configure Oracle Enterprise Manager Grid Control 10.2.0.5. Deploy agents on target servers and setup target databases for OEM Monitoring.

Environment: Oracle 11g/ 10g/ AIX 6.1, Red Hat Linux 5.6, OBIEE, Golden Gate

Wells Fargo, San Francisco CA September 2010 – May 2011

Sr. Oracle DBA (WMG Group)

Responsibilities:

Involved in Application support besides regular Production support.

Upgraded databases from 10g to 11R2.

Refreshing Non Production Schemas from Production Data on Users request.

Taking care of assigned CR/Problem Tickets/JIRA.

Implementing backup using Recovery Manager (RMAN) & datapump.

Granting the necessary system, user, and object privileges to respective users and also creating required roles.

Controlling and monitoring user access to the databases.

Create database schemas, tables, indexes, tablespaces, data objects, packages, procedures and functions

Environment: Oracle 11g/ 10g, Solaris 9/10, AIX 6.1, Red Hat Linux 5.6, Rman

CALTRANS, Sacramento CA March 2010 – September 2010

Sr. Oracle DBA

Responsibilities:

Install, upgrade and configure Oracle RDBMS Software (10g& 11g) and applying CPU patches from Oracle.

Involved in Installation of 11g RAC on Oracle Clusterware.

Migrated data from non RAC to RAC Production.

Taking care of frequent users request of refreshing there non production Databases.

Cloning of production databases for test and development purpose.

Building and implementing backup and recovery using Recovery Manager (RMAN) and export/import.

Creating Users, Roles and object privileges to respective users.

Performing daily and weekly monitoring of database

Providing assistance to the other members of development team with application tuning

Environment : Oracle 11.1.0.7, Solaris 9/10, Red Hat Linux 5.6, Rman

Wells Fargo, San Francisco CA Aug 2008 – Feb 2010

Sr. Oracle DBA (EDBS Group)

Responsibilities:

Install, upgrade and configure Oracle RDBMS Software (9i, 10g& 11g) and applying CPU patches from Oracle.

Oracle Enterprise Manager (OEM) 10g Grid Control for various database activities like monitoring Target databases & servers, scheduling jobs, monitoring performance issues & implementing suggestions, setting up alerts, patch implementation, Data Guard management.

Provide recommendations and solutions for business needs regarding capacity planning, data archiving, flash back technology, database and data migrations, active Dataguard and partitioning.

Supporting/monitoring 6-node Oracle 10g RAC on Oracle Clusterware(Solaris, Linux) platforms on 24 x 7 high availability environment and writing shell scripting for various database maintenance and alerting activities.

Involved in complete install of 10g/11g RAC including CRS, ASM, Primary and standby database using Dataguard.

Upgraded as well as migrated Oracle Databases across different platforms. Worked on conversion from NON-RAC to RAC

Experience with different tools monitoring software and worked on Enterprise ticketing systems like remedy change and user tickets frequently communicate effectively with technical and non-technical costumers

Created partitions for tables in production for a 1 TB database to improve performance.

Building and implementing backup and recovery using Recovery Manager (RMAN), RMAN scripts and customized shell scripts on Oracle 10g data pump (export/import) for data transfers between various Oracle environments. Configured and maintained disaster recovery site database using standby database

Helped reduce the amount of work involved in BCP simulation exercise by using flashback technology for standby thereby avoiding rebuild.

Sound troubleshooting, root cause analysis and performance tuning skills at database and OS levels with database backup & recovery skills including hot/cold/storage backups, complete/point in time recoveries

Designed and implemented batch jobs for data loading, purging, archival and statistics collection using UNIX Crontab/DBMS_SCHEDULER and OEM tools

Managing standby databases using Data Guard and performing failover and switchover.

Environment: Oracle 11g/ 10g/9i, Solaris 8/9, AIX 5.1/5.2, HP-UX 11.11, Red Hat Linux 4/5, Windows NT, Data Guard, Rman

EDS Allentown, PA March 2008 – July 2008

Oracle DBA

Responsibilities:

Check daily backup reports and re-run backups manually on failed database(RMAN was used for backups)

Cloning of production databases for test and development purpose.

Refreshed schemas on development/testing from production using export/import.

Scheduled backups using RMAN and crontab.

Worked on Dataguard environments.

Created Oracle Databases on 9i,10g and 11g and Setup and configure RMAN

Taking care of assigned CR

Creating of table-spaces, extents and indexes

UNIX shell Scripting, UNIX CRON jobs.

Install, upgrade, patches and configuration of Oracle (8i, 9i, 10g).

Involved in Weekly Production Support (24x7)

Create database schemas, tables, indexes, tablespaces, data objects, packages, procedures and functions

Environment: Oracle 9i/10g, Solaris 8/9, AIX 5.1/5.2,Windows NT, Rman

Wells Fargo, San Francisco CA Nov 2006 – Jan 2008

Oracle DBA (Wholesale Group)

Responsibilities

Involved in Planning, Architecting and Migrating databases from one data center to another, administered from remote servers

Involved in installing, configuring, managing, patching Oracle 9/10g, Oracle ASM, Data Guard, RMAN and Flashback on Sun Solaris

Configured OEM Grid as a Centralized Monitoring tool

Involved in creating, administering and managing Oracle 10g database using ASM with Data Guard and RMAN to provide maximum availability.

Migrated autosys jobs (1500) from UNIX to new GUI (4.5.1 V). Upgrade as well as Migrate Oracle Databases from Windows to Unix

Performing daily and weekly monitoring of database, Creating of table-spaces, extents and indexes

Setup and configure RMAN for 9i and 10g. Involved in setting up backup and recovery strategy using RMAN

Involved in managing standby databases using Data Guard and performing failover and switchover.

Involved in monitoring and tuning servers and databases using OS utilities and Oracle Enterprise Manager Grid Control.

Involved in migrating non-ASM databases to ASM databases.

Involved in production and non-production deployment and production support 24x7.

Environment: Oracle 8i/9i/10g, Solaris 8/9/10, HP-UX 11.11, AIX 5.1/5.2,Windows NT, Red Hat Linux 4/5, Data Guard

Fisher Scientific, Pittsburgh Aug 2006 – Nov 2006

Oracle DBA

Responsibilities

Designed & Developed Oracle database Creation of users and setting up user-privileges. General troubleshooting and tuning SQL queries

Refresh of Test and Development database for testing from Production database.

Creating of table-spaces, extents and indexes

Performing daily and weekly monitoring of database, this includes: space usage, Oracle server performance, Oracle alert logs, object growth and tables stored within the database.

Involved in managing standby databases using Data Guard and Shareplex.

Involved in database failover and failback using Oracle Data Guard

Involved in Weekly Production Support (24x7)

Monitoring Rollback Segments involving creation, acquisition and status change and assigning large rollback segments for long transactions

Environment: Oracle 8i/9i, Solaris 2.8/2.9, Windows NT/2000, Data Guard

Capgemini, NY May 2006 – July 2006

Oracle DBA

Responsibilities

Developed technical specifications from business requirement analysis and design sessions. Designed Databases to operate 24x7 on clustered environments.

Data Modeling, Database Analysis & Design to propose the Data Architecture

Document the Configuration and Maintenance database protocols.

Performing daily and weekly monitoring of database, this includes: space usage, Oracle server performance, Oracle alert logs, object growth, indexes and tables stored within the database.

Provided assistance to the other members of development team with application tuning and identifying inefficient SQL statements written by the developers using Explain Plan, SQL trace and TKPROF and assisted the team in using Optimizer hints in the SQL statements to improve performance.

Backend Application analysis. Creating/Altering/Modifying database objects like database triggers and indexes.

Designed Shell scripts and PL/SQL’s.

Created partitions and procedure and supported the development team in tuning the SQL statements.

Overseeing requirement analysis, design and unit testing of reports module.

Security strategy maintenance granting the necessary system, user, and object privileges to respective users and roles.

Environment: Oracle 8i/9i, 10g R2, Solaris 2.8/2.9, AIX 4.x, Windows 2000 and 2003 servers

Contact this candidate