Manager Oracle

Jyothi Maddula

Sr.ORACLE DATABASE ADMINISTRATOR

Ph: 404-***-**** Email: **********@*****.***

Employer details

*****@************.***

ph:678-***-****

PROFESSIONAL SUMMARY

8+ years of experience in Information Technology in various roles, my experience has scaled in providing client support, analysis, designing, development, testing, installation, migration, maintenance and administration for oracle databases, which included understanding the requirements, upgrades, performance tuning, backup & recovery, cloning, and space management using ORACLE 12c/11g/10g, performing the role of Oracle Database Administrator according to the set standards and timelines.

Extensive knowledge on database administration for Oracle 12c/11g/10g with experience in very large scale database environments and mission critical systems.

Experience in Installation, Configuration and Monitoring of Oracle Server on UNIX, Linux, AIX and Windows 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.

Experience in Installation of Oracle Real Time Application Cluster (RAC) with ASM, and manage RAC instances using CRSCTL and SRVCTL utilities.

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 on 10g/11g/12c versions.

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.

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.

Converting single Instance databases to RAC databases using RCONFIG, DBCA and manually.

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 backups using Cron tab.

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.

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.

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.

Excellent interpersonal and strong analytical, problem-solving skills combined with customer service attitude.

Manage, tune and troubleshoot database issues both on UNIX command line, SQL Plus, OEM client, Oracle 10g database control, oracle 10g Grid Control as well as other third party tools TOAD, SQLDeveloper.

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-Till date)

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.

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

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

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.

User management, Table space management, file system space management, backups management

Execute changes to database based on preapproved change requests.

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

Worked on database decommissions and removed databases from OVD.

Environment: Oracle 12c/11g/10gon Unix/Windows, Red Hat Linux 5.8, AIX 6, OEM 12c, 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.

Client: Nuance, (January2014-October2015)

Burlington,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:

Installed and configured Oracle 11g on windows.

Provided 24x7 support and On-Call rotation when needed for very large databases.

Performed migration of database from 10g to 11g in development, testing, and in production environment.

Configured 2 node RAC in System Test and Production.

Created ASM, ACFS and OCFS file systems.

Done migration from non ASM to ASM environment.

Managed daily online backups (Level-0 and Level-1) and Archive Backups using RMAN.

Involved in migration of databases from 10g to 11g using export/import and data pump export/import utilities.

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

Performed database refresh activities for business requirement and tuning purposes.

Had a good experience in migrating data using Exp, Imp, Expdp, and Impdp.

Successfully configured Oracle Golden Gate for synchronizing databases.

Configured parameters for DDL and non DDL support for data replication.

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

Implemented Data Guard physical standby database in 11g for disaster recovery.

Suggested storage requirements for all the environments.

Performed RMAN Incremental and Cumulative backups and also developed backup strategies.

Performed logical backups using both classic and Data Pump methods.

Expertise in data transfer using Export/Import using command-line as well as in interactive mode and through Data pump.

Performed Patching on Oracle databases using Opatch utility.

Performed daily monitoring of Oracle databases from Oracle Enterprise Manager and alert log files.

Performed performance tuning of database by using AWR, SQLT, and EXPLAINPLAN.

Maintained database security using security compliance auditing and profile management, password complexity in order to control access to database.

Environment: Oracle 10g, 11g, RAC, Golden gate, Data Guard, TOAD, ASM, Resource Manager, Oracle Cloud Control.

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 Stream, Golden Gate for Active-Active replication between the datacenter for high availability.

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

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

Client: FARMERS Insurance (March2009-August2011)

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:

Managed and monitored the Oracle Real Application Cluster (2 node RAC)

Supporting more than 80 production and development databases 10.2.0.4.

Created and maintained failover logical standby database.

Implemented High availability using Golden Gate replication. Implemented bi-directional replication using Golden Gate.

Migrated databases from 9i to 10g using transportable table space and data pump.

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

Installed and configured Oracle Enterprise Manager 10g Grid Control.

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

Installed and upgraded Oracle 10.2.0.1 database to 10.2.0.4.

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

Implemented advanced features of Oracle 10g such as Automatic Database Diagnostic Monitor (ADDM), Automatic Workload Repository (AWR) for monitoring database performance. Modified and updated the Performance tuning scripts.

Performed Tuning, coding and Monitoring for Oracle Real Application clusters (RAC) nodes, Production Standalone Servers via Toad.

Creation of materialized views and fine-tuned them for better performance.

Tuning SQL statements using Explain Plan and STATSPACK.

Modified SQL*Loader control scripts for example to eliminate spaces generally used for data loading.

Configured Physical and Logical Standby database for reporting environment.

Performed administrative maintenance, monitoring on Oracle database systems in a global 24x7 operational environment.

Environment: Oracle 11g/10g RAC on Solaris/Linux, RMAN, Data Guard, UNIX Shell Scripting, Quest Performance Analysis, Quest Space Management tool, DB Artisan, Toad, PL/SQL Developer, OEM, Windows NT/XP.

Client: HDFC Bank

Bangalore, India (August 2008 – February 2009)

Role: Junior Oracle DBA

HDFC Bank is an Indian banking and financial services company headquartered in Mumbai. HDFC bank is the second largest private bank in India. It provides a number of products and services which includes banking, loans and credit cards.

Responsibilities:

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

Involved in optimizing SQL statements using Indexes and Hints.

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

Involved in writing complex SQL statements.

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 degree from Nagarjuna University, India.

Contact this candidate