Venkata Saripella
PROFESSIONAL SUMMARYIT professional with over 8 years of experience as an Oracle Database Administrator and Experienced in administration, installations, all phases of SDLC, migrations, upgradations, patches, performance tuning, backup and recovery, space management, database security.
· Extensive experience in installing, configuring, monitoring and maintaining Oracle Software 11g/10g/9i/8i on Sun Solaris, Red Hat Linux, HP-UX, AIX, and Windows Platform.
· Strong background knowledge installing and configuring Oracle 12c / 11g R2 RAC (Real Applications Clusters) with ASM and maintaining other Oracle database products on Red Hat Linux, Sun Solaris, IBM-AIX, Windows environments.
· Experience in fulfilling DBA daily activities, including schema management, user management (creating users, synonyms, privileges, roles, quotas, tables, indexes, sequence), space management (tablespace, rollback segment), monitoring (alert log, memory, disk I/O, CPU, database connectivity), scheduling jobs, UNIX Shell Scripting.
· Perform database migration from AIX and Linux to Exadata platform with zero downtime/
· Solid experience on Oracle Enterprise Manager 12c / 13c (OEM), Grid Control, TOAD, RMAN.
· Installed, Configured and maintained 2 Node 11gR2 RAC with ASM production databases. Installed and Configured Oracle 11g RAC / 12c (3 node cluster), CRS using ASM.
· Installing ASM environment and migrating database from NON-ASM to ASM.
· Upgrading databases to higher versions, applying patches and patchsets (rolling patch with no downtime).
· Administration experience in Very Large Multi Terabyte Databases (VLDB) environments.
· Extensive experience in Configuration of RMAN, Planning and scheduling Backups using RMAN, Hot Backups and Logical Backups, Oracle utilities and tools like OEM, Import-Export, Data Pump, and DBCA Installation, maintenance and tuning of RAC applications.
· Experience in implementing, configuring and managing Data Guard with Physical Standby Databases for High availability configuration.
· Experience in Real Application Cluster (RAC) environment with Auto Storage Management (ASM) on Oracle 10g and 11gR1.
· Delivering SQL and Database performance tuning services via V$/GV$ views, Explain Plan, AWR (statspack) reports, ADDM, SQL Tuning Advisor, Oracle Enterprise Manager (OEM), Grid control.
· Expertise in creating Oracle Tables, Table Partitions, Views, and Materialized Views.
· Experience with SQL, PL/SQL coding, stored procedures, triggers, cursors, functions, packages, UNIX Shell Scripting, Indexes, Logical and Physical database design to implement the business logic.
· Experienced in Oracle Support (raising SR) processes for technical requests through Metalink.
· Experience in Managing oracle databases, dimensional modeling, data warehousing.
· Extensive experience in solving database related design issues and also experienced in re-designing existing databases to the required needs.
· Excellent verbal and written communication skills. Willingness to learn new technologies, openness to new ideas and ability to learn very quickly.
· Participation in on-call (off hours) schedule in providing technical support.
EDUCATION:
Bachelor of Technology in Computer Science, Hyderabad, India
TECHNICAL SKILLSOperating Systems / HP-UX 11.x, Sun Solaris 9/10, IBM-AIX, RHEL 3.x/4.x/5.x, Windows 200x/Vista/XP/Prof.
RDBMS / Oracle 12c/11g/10g/9i/8i.
Languages / SQL, PL/SQL, C, C++, JAVA, UNIX Shell Scripting.
Tools / RMAN, Oracle Enterprise Manager (OEM), Grid Control, SQL*Loader, Export/Import, Data pump export/import, TOAD, iSQL*PLUS.
Tuning Tools / TKPROF, EXPLAIN PLAN, STATSPACK.
WORK EXPERIENCE
Client/Project : Client: TIAA-CREF, Iselin, New Jersey
Designation : Senior Oracle DBA.
Platform : RHEL, IBM-AIX, Exadata,Oracle 12c/11g/10g, RAC, ASM, RMAN, PL/SQL, UNIX scripting.
Duration : JULY 2014 – TILL DATE
Description: TIAA, formerlyTIAA—CREF(Teachers Insurance and Annuity Association—College Retirement Equities Fund), is aFortune 100 financial servicesorganization that is the leading retirement provider of financial services for the academic, research, medical, cultural and governmental industries. TIAA serves over 5 million active and retired employees participating at more than 15,000 institutions.
RESPONSIBILITIES:
· 24X7 production support.
· Database admin support on Oracle 11g / 12c databases which includes upgrades / installations / migrations / patching (rolling / non-rolling) for RAC cluster / RAC One Node and single instance databases on Exadata / Linux / Aix platforms.
· Database Admin Support for 11g / 12c databases running in Non-Prod and Prod/DR environments running on Exadata / Exalytics / AIX / Linux and C3 environments.
· DBA support for people soft environments and support people soft refreshes.
· Good Exposure to Cloudera installation and Hadoop cluster build and support.
· Database support for OBIEE / Financial Data Foundation applications.
· Expertise knowledge on Transportable Tablespaces and also Exadata compression and performance tuning.
· Perform RAT testing on the RAC databases for new project builds to eliminating associated risks before going to production.
· Experience in end-end configuration setup of Oracle FUSION version 8 across the life cycle i.e. Dev to Production successfully and provide support for P4FA patching and P2T activities for the FUSION product.
· Install and configure ODI configuration for fusion / Exalytics.
· Installed Quarterly critical patches on multiple platforms and also worked on automation process for patching process in SDLC environments
· Install DDBoost configuration and Setup SQL and Oracle database backups using DDBoost process.
· Experience in Delphix clones and managing Admin work for Delphix Engines.
· Experience in Setup DB targets in OEM 12c and enable DB monitoring and make sure of OEM tool to build DB's and also setup compliance rules.
· Working on Performance tuning which includes partitioning 2 TB tables and also implement Oracle Hybrid Partitioning methodology and 12c In-memory functionality.
· Prepared automation scripts to refresh Production databases to P-Fix based on Business and APP Team requests.
· Replicated DB from Prod to lower environment using Data pump and RMAN / Golden-Gate.
· Working on ASM management which includes swapping of ASM LUNs / Create Diskgroups / Drop Disk groups.
· Performing day-to-day database administration tasks like Table space usage, checking alert log, trace files, monitoring disk usage, Table/index analyze jobs, database backup logs etc.
Client/Project : Client: JPMorgan Chase, Wilmington, Delaware
Designation : Oracle DBA.
Platform : RHEL, IBM-AIX, Oracle 11g/10g, RAC, ASM, RMAN, PL/SQL, UNIX scripting.
Duration : Nov 2012 – JULY 2014
Description: JPMorgan Chase is one of the oldest financial services firm in the world. It is a leader in financial services with largest market capitalization. The JP Morgan brand is used by the Investment Bank as well as the Asset management, Private Banking, Private Wealth Management, and Treasury & Securities Services divisions. The current application is a part of the Mortgage Banking.
RESPONSIBILITIES:
· Responsible for administration and supporting Oracle 11g, 10g RAC databases in DEV, QA, UAT and Prod Environments
· Installed and created 11g databases on both standalone servers and Real Application cluster (RAC) servers.
· Installation and Maintenance of Oracle 10g, 11gR2 RAC on IBM-AIX, LINUX, Solaris.
· Installed Oracle binaries for 10g / 11g databases and also installed required rpm’s for installations.
· Installed, Configured and maintained 2 Node 11g RAC with ASM production databases. Installed and Configured Oracle 10g RAC (3 node cluster), CRS using ASM.
· Installed and configured Golden Gate on RAC clusters.
· Perform RAT testing for databases as part of migration testing and storage migration testing.
· Created Unix Shell Scripts for validating database parameters and tracking the build process.
· 24X7 production support.
· Setup of Disaster Recovery databases (Data Guard).
· Refresh schema-using Export/Import. Creating the database, table spaces, tables, indexes, setting privileges and user logins.
· Installing and Configuring Recovery Manager (RMAN) for recovery and backup strategies.
· Created & Managed Jobs using AutoSys Job Scheduler.
· Utilized Oracle Enterprise Manager (OEM) to manage users, privileges, profiles, schemas
· Monitored OEM tickets and resolving them based on the priority.
· Support Database migration from AIX to Linux and from SQL to Linux and cross platform.
· Worked on Automatic Storage Management (ASM) for managing data in SAN
· Monitoring and resolving tickets in different environments based on the SLA’s.
· Created cron jobs to for Linux / AIX file system cleanup for database maintenance directories.
· Applied PSU patches to Oracle Databases and Oracle Applications.
· Manager Huge page allocation to databases and manage the server memory accordingly.
· Handling large database environments (Data warehouse) using Oracle Enterprise Manager (OEM) on daily basis observing the performance of the production database and constantly active regarding performance and space management issues and accordingly providing on-fly solutions to make database healthy and running.
· Supported development effort by providing SQL statement tuning and optimizing ETL procedures and removing load and query performance bottlenecks by using tools EXPLAIN PLAN, SQL Trace, TKPROF, TOAD and Oracle Enterprise Manager
· Export and Import of database objects to copy from one database to another database between different environments
· Planning Backup/Restoration Strategy, Scheduling Backups, Schema backups, taking Logical Backups (with Export/Import Data Pump utilities)
· Created Users, Groups, Roles, Profiles and assigned users to groups and granted privileges and permissions to appropriate groups
· Performing day-to-day database administration tasks like Table space usage, checking alert log, trace files, monitoring disk usage, Table/index analyze jobs, database backup logs etc
Client/Project : Samsung Telecommunications America (STA), Bellevue, WA
Designation : Oracle Database Administrator.
Platform : RHEL, IBM-AIX, Oracle 11g/10g, RAC, ASM, RMAN, PL/SQL, UNIX scripting.
Duration : May 2012 – Dec 2012.
Description: Samsung is a market leader in Consumer Electronics and Cell Phones. For more than 70 years, Samsung has been at the forefront of innovation. The largest technology company in the world (based on annual sales), Samsung is guided by a simple philosophy, strong values and high ethical standards that influence our work.
RESPONSIBILITIES:
· Installation, Configuration, Designing and Maintaining of Oracle 11g/10g on RHEL and AIX platforms.
· Administering Oracle 11g/10g production, test, development environment on RHEL, IBM-AIX.
· 24X7 production support.
· RAC troubleshooting.
· Maintaining schemas and partitioning tables.
· Implemented the security using ORACLE Database Vault.
· Developed RMAN scripts for database backup and recovery including hot and cold backup options for both RAC and stand alone instance.
· Installing ASM environment and migrating database from NON-ASM to ASM.
· Creating table spaces, tables and users for custom applications.
· Implemented ASM on RAC and stand-alone databases. Managing disks and disk groups with ASM.
· Hands On Experience in installing, configuring and managing Oracle 11g RAC with ASM.
· Delivering Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE, ORADEBUG, 10gOEM Grid Monitoring custom scripts troubleshooting oracle databases using SQL trace utilities.
· Experience in regular Database Administration activities such as Upgrades, Migration, Patches, TAR support, Cloning, Backups and Recovery Manager, Performance Tuning, capacity planning, script development, and documentation.
· Experience in using 10g features Flash-Back Recovery, Data Pump, AWR, ASM, ADDM, ASH, Recycle Bin, 10g Grid Monitoring.
· Skilled in setting up/Installation and configuration of release 10g RAC R2 with ASM and Raw Devices and 10g CRS.
· Upgraded Production, Development databases from 10.2.0.2 to 11.1.0.2.
· Applied patches, patch sets and Critical Patch Update using OPatch and OUI.
· Excellent experience with OEM Grid control, TOAD which acts as a great platform where Database Quality, Performance and Availability functions for administration and development are considered.
· Worked on SQL, PL/SQL coding including creation of stored procedures, functions, packages, triggers.
· Tuning SQLs usingExplain Plan, SQL Trace, TKPROF reports and SQL Tuning Advisor.
· Performance monitoring, Database tuning and Application tuning, Cluster Interconnect tuning using Dictionary views, OEM Tuning Pack, Diagnostic Pack, AWR (Statspack) reports.
· Proactive monitoring, identifying areas that need to be improved in the application and database using AWR (statspack) reports, ASH, ADDM and OEM (Oracle Enterprise Manager) and Grid Control.
· Export/Import, Datapump to migrate database objects from one database to another.
· Daily DBA activities: managing datafiles, redo log files, control files, alert log files, trace files, tablespaces, segments, extents, data blocks & physical storage, database network connectivity, database security, database links, database users, granting/revokingsystem/object privileges, roles & resources, querying data dictionary tables for metadata, setting init.ora parameters.
· Experience with data modeling, physical and logical database design.
· Experience with materialized views 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.
· Partitioning of large tables, indexes & rebuilding Indexes to improve the performance.
· Experience in monitoring and tuning system resources associated with the database performance hit ratios, I/O, lock and latch contention.
· Assisting developers with tuning of SQL, PL/SQL scripts to enhance the database performance.
· Find solution and resolve critical issues with Oracle Support.
Client/Project : Compass Group, Charlotte, NC
Designation : Oracle Database Administrator.
Platform : IBM-AIX, Sun Solaris, Oracle 10g, 9i, RMAN, ASM, SQL, PL/SQL, UNIX Shell scripting.
Duration : Aug 2011 to May 2012
Description: Compass Group PLC is a holding company and operates in four geographical area: North America, Continental Europe, UK & Ireland, and Rest of the World. The activities of the Company are the provision of contract foodservice and support services to clients. It delivers across Business & Industry, Education, Healthcare & Seniors, Sports & Leisure and Defence, Offshore & Remote. It delivers foodservice and support services to people at work. Its customer first hospitality is its Compass Service Framework to manage and deliver multiple services.
RESPONSIBILITIES:
· Worked as a team member for 24x7 support inboth production and development environments.
· Installation and creation of 9i and 10g databases for Testing, Development and Production on IBM-AIX and Sun Solaris environment.
· Worked extensively on forward and reverse engineering processes. Created DDL scripts for implementing Data Modeling changes.
· Implemented the standard naming conventions for the fact and dimension entities and attributes of logical and physical model.
· Participated in JAD session with business users and sponsors to understand and document the business requirements in alignment to the financial goals of the company.