Manager Data

Jyothi Maddula

Sr.ORACLE DATABASE ADMINISTRATOR

Ph: 404-***-**** Email: aczcn3@r.postjobfree.com

PROFESSIONAL SUMMARY

8+ years of experience with proven expertise in supporting and optimizing performance of databases, database queries, hardware and software including installation, configuration, and preventative maintenance. Experience providing High Availability solution (RAC), backup and recovery Solution (RMAN), Disaster Recovery solution (Data Guard), replication solution (Oracle Streams), Monitoring Solution (Oracle Enterprise Manager (OEM) to various IT clients. Provided service focused technical support remote and onsite to achieve effective troubleshooting, resolution of issues, and maximum customer satisfaction. Primary escalation point for all database questions, problems and policies Distribute and oversee projects and tasks issued to the DBA team.

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

Expert with planning, creation, administration and troubleshooting of ORACLE 12c/11g/10g/9i OLTP (multiple instances)/OLAP databases in production.

Handful of experience in Oracle Installations, Upgrades, Patches, Critical Patch Updates (CPU’s) in various environments.

Provided 24x7 support and on call support on rotational basis.

Installed Grid Infrastructure Software on new Linux Servers and Failover environments and Oracle Grid Control11g Installation.

Installed and maintained Oracle 12c/11g/10g RAC with ASM & OCFS2 File systems.

Installed and configured Container and Non-Container 12c databases, Installation and the concepts associated with 12C database.

Implemented and configured replication technology using Data guard& Oracle Golden Gate installation.

Experience in Oracle Golden Gate installation, configuration and troubleshooting Golden Gate issues.

Experience in Uni-directional, Bi-directional and Integrated Capture data replication using Golden Gate.

Implemented Data guard with maximum availability, protection and performance configurations and worked with Data guard Fail over and Switch over cases.

Experience in cross platform Migration from Solaris to Linux and Upgraded database from 11g to 12c using Golden Gate with Zero downtime.

Experience in migration of SQL 2005 to SQL 2008r2 and up gradation from MSSQL Server 2008 to MSSQL Server 2014.

Upgraded Grid and Oracle Infrastructure on multi-node RAC cluster from 11.2.0.3 to 11.2.0.4

Performed Migration between different datacenters, Non ASM to ASM, Single instance to RAC.

Worked on various ODI tools such as OdiSqlUnload, OdiSendMail, OdiInvokeWebService.

Expert with planning, creation, administration and troubleshooting of Oracle 11g/10g OLTP (multiple instances)/OLAP databases in production.

Creating Physical and logical database design data models using ERWIN tool.

Generation of DDL scripts using ERWIN tool.

Expertise in Oracle Installations, Upgrades, Patches, Critical Patch Updates (CPU’s) in various environments.

Installed and configured Cloud Control 12c, deploy 12c agents on the target servers and monitor databases.

Expertise in setup, installation, configuration, maintenance and troubleshooting of several Oracle tools and utilities like Oracle Grid Control, TOAD, Oracle SQL Developer in various versions. Extensive knowledge on configuring Listener and TNS services.

Worked on Linux, Sun Solaris, HP-UX, AIX and Windows environments.

Data transferring and Refreshing with export/import utilities, Data Pump (including Network links and DB links) and data loading using SQL*Loader and External tables.

Solid experience in disaster recovery, Database backup concepts and options such as user-managed backup, RMAN-managed backup with or without catalog, operating system backup, cold and hot backup, full back up, incremental, cumulative backup and implementing backup and recovery strategies.

Scheduling the databases backup using Cron tab and VERITAS net backup.

Backup, Recovery and Cloning of databases using RMAN. Table recovery using RMAN a new feature of 12c.

Proficient in setting up and troubleshooting network connections (i.e. setting up Listener and TCP/IP Connections).

Administrated database of various sizes from 500GB to 15TB.

Storage Migration involving migrating the databases from NetApp to Hitachi including block level storage.

Implemented OLTP COMPRESSION, PARTITIONING, Hybrid Columnar Compression for databases on EXADATA, and the basic, low, high compression methodologies.

Installed, configured and maintained databases on EXADATA X2-2 half rack.

Configured Database File System (DBFS) on EXADATA.

Experience in writing PL/SQL Stored Procedures, Functions Packages and Triggers, and various UNIX Shell Scripting for managing the user's roles and privileges, scheduled backups, manage statistics, Disk space management.

Worked on Oracle 12C Grid Control including monitoring/setup and performance tuning purposes. Data loading using SQL*LOADER.

Performance tuning of the database - SQL Tuning, Partitioning, parallelism, Used Tuning utilities like STATSPACK, AWR, ADDM, Database Replay and Tuning of SGA, Distribution of disk I/O, Sizing of tables and indexes.

Expertise in Using EXPLAINPLAN for query optimization and Performance diagnostic tools like SQL Trace and TKPROF.

Optimization and tuning SQL queries using TRACE FILE, TKPROF, EXPLAIN PLAN.

Proficient in RAC Performance tuning &Experience in UNIX Bash Shell Scripting.

Training the new team members on Security Baselines and Installation Qualifications.

Monitor and educate team with new processes and standards. Documented using Word, Excel and Visio.

Extensively used BMC Remedy, Service now and Triole ticketing systems for monitoring.

Backup and recovery on sql, MySQL & SQL.

Managing MySQL Databases on Windows, Linux & UNIX

Core Skills

Operating Systems

MS-DOS, MS Windows 98/2000/ME/NT/XP/Vista, RHEL 4, RHEL 5, OEL 4, WIN NT/2003/2008, Solaris 10, HP-UX Itanium, IBM AIX

Programming Languages

SQL, PL/SQL, Unix Shell Scripting.

RDBMS

Oracle 8i/9i/10g/11g/12c

Software’s, Applications and Tools

DBCA, DBUA,ADRCI, Oracle Data Guard, OEM (GC), RMAN, ASM, Cluster ware, SQL*PLUS, SQL LOADER, EXP, IMP, Data Pump (expdp, Impdp), Putty, OVD SRVCTL,TOAD, SQL TRACE, EXPLAIN PLAN, TKPROF, ERWIN tool, STATSPACK, AWR and ADDM, SQL Developer, OUD, Golden gate Replication, Inperva.

Web Related and Other Tools

HTML, XML, JSP, HTTP, TCP/IP, FTP, SFTP, SCP, EMC Storage, Metal ink.

Work Experience

Client: Nike Inc., (November 2015-Dec 2016)

Hillsboro, Oregon.

Role: Sr. Oracle DBA

Nike Inc. is an American International corporation. It is engaged with the manufacturing and sales of footwear, apparel, equipment, accessories and services. This company is headquartered near Beaverton, Oregon. Nike is one of the largest suppliers of athletic shoes, apparel and sports equipment.

Responsibilities:

Provided 24x7 support and on call support on rotational basis.

Installed Grid Infrastructure Software on new Linux Servers and Failover environments and Oracle Grid Control11g Installation.

Installed, configured and maintained Oracle Database 12c

Deploy the 12c agents on the target servers and add the target Configuration Items to monitor.

Plug-in installations on the target servers to extend the functionality of OEM

Configure Oracle Advanced Security to implement Transparent Data Encryption at table space, table and column levels. Also configured Redaction using OEM's Policy expression builder.

Involved with Installation and maintenance of ORACLE 10gRAC/ORACLE 11g RAC and standby databases (Oracle data Guard) for High availability and Disaster recovery purpose.

Migrated databases into EXADATA RAC-databases, x3-2 successfully using data pump.

Implemented DBFS on EXADATA.

Implemented PARTITIONING using EXCHANGE PARTITION method to improve the performance of the database.

Setup physical standby’s (DATA GUARD) for several Databases (via OEM as well).

Configure Data guard broker between the primary and standby databases, perform Switchover/Failover and monitor the data guard status

Upgrade existing 10g/11g databases to 12.1.0.1 on HP database machine using transportable table space method. Upgraded supported versions using DBUA (direct path upgrade).

Experience in configuring and managing 3-node RAC database and used ASMCMD command-line utility to manage ASM disk groups, administering ASM storage by adding disk to the disk groups.

Backup/Restore & Recover of the databases using RMAN and FLASHBACK database procedures.

Backup and recovery procedures using RMAN. Created scripts for RMAN incremental backups and also for full database backups using data pump.

Database Installation, Upgrades and Patching. Upgrade the binaries by applying patch set and interim patches using OPatch and OPatch Auto.

Capacity planning for the projects owned in the environment.

Resolved the issues in conflicts between the target and source database in Golden Gate.

Involved in deploying new application and setting up replication between the databases using Golden Gate.

Installation and configuration of oracle Golden gate on 12c & 11g and Configuration and troubleshooting of Golden Gate Extract, Unidirectional and Bi-directional Replicat.

User management, Table space management, file system space management, backup’s management.

Managed testing, assisted Developers, and created backups by Exporting and Importing tables when needed.

Modified configuration settings when needed due to growth, upgrades and changes to keep system resources adequate.

Proactive performance management, optimization and capacity estimation of database environments.

Physical database modifications and Attended Developer’s code review meetings and made recommendations to improve Efficiencies.

Had a good experience in resolving the issues while replication with golden gate.

Worked on database decommissions and removed databases from OVD.

Applying PSU Patches and interim patches whenever required to make the database software up to date.

Generated AWR, ASH, ADDM reports and used TkProf to analyze trace files.

Creation of new scripts to automate the procedures to generate statistics on database space management for proactive monitoring.

Configured Oracle Wallet for Transparent Data Encryption (TDE).

UNIX shell scripting as and when required based on the requirement.

Environment: Oracle 12c/11g/10gon Unix/Windows, Red Hat Linux 5.8, AIX 6, RAC, Oracle Advanced Security, Data guard including DG Broker setup, RMAN, Partitioning, Compression, Golden Gate, DBFS, Performance tuning, OPatch Auto, TOAD for oracle 12.1/11.6, Storage Migrations, OEM13c.

Client: Nuance, (January2014-October2015)

Burling ton, Boston.

Role: Sr. Oracle Database Administrator

Nuance communications is an American multinational Corporation. Its current business products focus on server and embedded speech recognition, telephone call steering systems, automated telephone directory services, optical character recognition software and desktop imaging software.

Responsibilities:

Administering and supporting Oracle database environment over 120 databases, up to 20TB, utilizing advanced concepts such as Data Guard and Oracle RAC combined on all the production, development and testing environments.

Installed, configured and maintained Oracle 2/3 Node 12c RAC

Performed various operations relinking protocol library, implemented 12c Transaction Guard while configuring services, deployed instance caging

Worked on ASMCA and used SYSASM for created disks, drop and add disks to disk groups and tuning ASM parameters according to requirement

Configured disaster recovery databases using data guard and performed DR Testing

Performed switchover and monitor using DGMGRL.

Worked on Active data guard and performed Troubleshooting data guard environment

Involved in Oracle Golden gate installation, configuration, troubleshooting Golden Gate Extract and Replicat files.

used Defgen utility to create definition files in Golden gate

Migrated databases using Golden gate with minimal downtime

Involved in up-gradation of databases from 10g to 11g and applied patch set and interim patches whenever required

Upgraded development and production databases from 10g to11g on Linux

Involved in Installation and Configuration of Management agents in 12C(Cloud Control)

Used 12C/11G grid control Maintenance, tuning and monitoring databases

Providing Application Support for performance and database related issues

Worked with teams and involved in building databases for BI (Business Intelligence) applications.

Worked on storage Indexes and tested their behavior with different query predicate conditions

Performed cross platform migration of databases on Solaris 10g to Linux 11g using Golden Gate

Documented and logged errors in GOLDENGATE environment and worked on OLTP Compression

Extensively used Log dump utility and define utility for resolving issues in Golden Gate

Extensively used data pump for migrating data between platforms

Installed and Implemented Backup & Recovery procedures. Implement Hot, Cold and Logical backup plans.

Implementation of Flashback Technology and cloned databases for development and test environments using Recovery Manager

Involved in scheduling incremental, cumulative and full backups and configured retention policy Using RMAN

Worked in Data Warehouse environment, involved in activities like partitioning tables, Creating materialized views and reorganizing index’s

Database Sizing, Table space Management and Rollback Table space Management, Transaction Management and Security Administration.

Implemented database security using Transparent Data Encryption

Encrypted sensitive information like Tables, table spaces, Encrypted columns within the database and implemented Encryption keys on relational database management systems by using TDE.

Performed Explain Plan analysis for Query Optimization and SQL tuning

Performed Database and SQL tuning by using various Tools like AWR, ADDR, ASH, TKPROF, Explain Plan, SQL Advisor and optimizer hints.

Involved in managing end-end lifecycle of user identities across the enterprise resources using Oracle IDM (Identity Management).

Effective Production Support and off hour support, support handover, off-shore co-ordination.

Environment: Oracle 11gR2/12C, Solaris/Linux, SQL, OEM12c, RAC, ASM, Data guard 10g/11g, Golden gate, putty, RMAN, Explain Plan, AWR, ADDM, ASH,, Flashback, Data pump.

Client: State of New Mexico

Department of Taxation (October2011-December2013)

Role: Oracle Database Administrator

Responsibilities:

Installed and Configured 2node RAC on Linux.

Installed and Configured and maintained oracle 10g and 11g.

Oracle Grid Control11g Installation and Configuration.

Refreshing the Database from one version to another version.

Configuration of Physical Standby database for maximum performance mode – Oracle Data Guard

Installation, Configuration and Maintenance of Oracle RDBMS and Client software in various environments.

Migration of databases from 10g to 11g using export/import and data pump export/import utilities

Performed rolling patch upgrades on RAC environment for bug fixing

Setup of Jobs using the Oracle Enterprise Manager (OEM) database control

Weekly Data Refresh from Production to Development and Test environments using data pump export/import

Daily incremental backup and weekly full backup of databases using RMAN

Involved in migration of applications of the clients.

Loading data into database tables using SQL *Loader

Implemented Materialized views, database links

Regular database management on 10g and 11g OEM

Working Knowledge of installation and configuration of GOLDENGATE in Unix environment

Done Installation and configuration of golden gate on 11g database for the replication.

Implemented Bi-Directional replication in golden gate from target to source and source to target.

Resolving the conflicts between the target and source database.

Configuring parameters for DDL support in golden gate replication

Performed day-to-day activities such as creating users, roles, schemas, tables, views, indexes and rebuilding Indexes and running scripts given by the clients.

Table space monitoring, Performance monitoring and tuning for performance improvement

Creating batch files and automating the tasks

Granting roles and privileges to end users

Managing, troubleshooting and resolving oracle database and application issues.

Daily health checkup of the database using TKPROF, AWR, ADDM.

Monitoring alert log/system log and managing Database Locks and blocking sessions

Defragmentation of tables and indexes for improved performance and efficiency.

Environment: Oracle 10g, 11g, SQL, PL/SQL, Oracle Enterprise Manager Database Control, TOAD, SQL Developer, SQL*Loader, Red Hat Enterprise Linux, OEM12c.

Client: FARMERS Insurance (March 2009-August 2011)

Wipro Technologies, Bangalore, India

Farmers Insurance Group is an American Insurer group of automobiles, homes and small business and also provides other insurance and financial services products.

Responsibilities:

Installed and configured RAC (2node) & created Databases using dbca.

Converted a single instance database to Oracle RAC 11g.

Installation, Configuration and Administration of Oracle 11g RAC.

Involved in RAC administration including 10g Database cloning, tuning, patching and monitoring concurrent manager processing etc.

Configured Oracle Data guard for Oracle Disaster recovery.

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

Applied patches on standalone servers using OPatch utility and upgraded OPatch utility from lower version to higher version.

Involved in migration of databases from standalone (ASM) to cluster Environment.

Maintained catalog server and registered databases in catalog server.

Using SQL Tuning Advisor and SQL Access Advisor to fix bad SQL.

Having Good experience in monitoring databases through grid control.

Installed and configured Oracle Enterprise Manager 11 g Grid Control.

Worked on Performance Tuning (11g &10g) on Solaris 10, AIX 5.2.

Implemented data transfer using Data Pumps and Export/Import utilities.

Involved in scheduling incremental, cumulative and full backups and configured retention policy.

Developed a bunch of Index monitoring scripts in order to sort out the unused space occupied in table spaces.

Implemented advanced features AWR, ADDM reports for monitoring database performance, Modified and updated the Performance tuning scripts.

Involved in gathering requirements from end users.

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

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

Mentoring Level-II DBA’s and involved in 24x7 Production-on calls supports for all the production databases with Oracle.

Environment: Oracle 11g/10g, Red Hat Enterprise Linux 4.x and 5.x, AIX 5.2, OEM, Oracle 10g RAC, Data guard, Sybase, STATSPACK, EXPLAINPLAN, IBM Data stage, C++, Web logic, SQL Server 2005.

Client: HDFC Bank, Bangalore (August 2008 – February 2009)

Role: Junior Oracle DBA

Responsibilities:

Involved in fine tuning stored procedures by making use of PL/SQL Collections and its BULK FETCH and BULK INSERT features.

Involved in the optimization of various SQL and PL/SQL using EXPLAIN PLAN and TKPROF.

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 writing complex SQL statements.

Installation, Maintenance and administration of Oracle 10g on Red hat Linux.

Converted physical standby databases to Snapshot standby databases.

Implemented Oracle database backup & recovery solutions using RMAN.

Involved in writing for shell scripts for taking RMAN backups.

Developed backup and recovery strategies, batch processing, performance monitoring, log maintenance and automating functions wherever possible.

Maintained database security by managing users roles, privileges.

Implemented new security rules via roles as per the company policies.

Tuned the performance of the SQL’s using TkProf and Stats pack reports.

Performed security management and accessibility control by managing OS and Password file authentication, creating profiles, privileges and roles.

Environment: PL/SQL, Oracle 10g, TOAD, SQL PLUS, PL/SQL Developer, HP-UX 11.0

EDUCATION: Bachelor’s of Sciences from Nagarjuna University.

Contact this candidate