Manager Oracle

Aswini Vudutha

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

Ph: 470-***-****

SR.ORACLE DATABASE ADMINISTRATOR

SUMMARY

* ***** ** ********** **** high-volume, high-performance database systems. Experience with Enterprise-scale data warehouse systems. Experience in the Design, maintenance, and administration of ORACLE 12c/11g/10g Experience writing, Creating, and Tuning SQL. Experience in SAS data management, and IBI monitoring and runtime optimization of applications, data jobs, replication, and cloud activities including AWS.

Proposed, designed, documented, and deployed many infrastructure projects saving the client significant money in managed cost and cost avoidance.

Solutions proposed, architected, deployed including HP-UX to Linux platform migration, advanced compression, Real Applications Clusters (RAC), Database migrations.

Extensive knowledge on database administration for ORACLE 12c/11g/10g 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 OLTP (multiple instances)/OLAP databases in production.

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

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

Development and implementation of Enterprise database services standards, guidelines, processes & procedures, and best practices.

Oracle Golden Gate installation, configuration, troubleshooting Golden Gate EXTRACT and BIDIRECTIONAL REPLICAT issues.

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

Backup, Recovery, and Cloning of databases using RMAN also profound in using the new Oracle 11g features in these utilities.

Writing scripts in the UNIX-based environments for managing the user's roles and privileges, scheduled backups (using Data Pump /cold backups), manage statistics.

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

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

Experience in writing PL/SQL Stored Procedures, Functions Packages, and Triggers, various scripting languages such as Perl, Awk, and UNIX Shell Scripting.

Extensively used BMC Remedy and Service Now Ticketing systems for monitoring.

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

Involved in designing and deploying a multitude applications utilizing almost all of the AWS stack

Migrated the current Linux environment to AWS/RHEL Linux environment and used auto scaling feature

Install and configure chef server/workstation and nodes via CLI tools to AWS nodes

Proven abilities in establishing effective task priorities, working independently, and participating as an integral part of a team in fast-paced and multitasking environment.

Technical Skills:

Operating Systems

HP-UX 10.x,11.x, Sun Solaris5.8,8,9,10, AIX 5.1,5.2, Red Hat Linux 4.x,5.x,6.x and windows 2003/2005

RDBMS

Oracle 12c/11g/10g/9i, Oracle 12c Real Application Cluster (RAC), ASM

Tools and Utilities

RMAN, OEM, GOLDEN GATE, TOAD, Export/Import, Data pump, Query builder, Net Backup, SQL Tuning/Access Advisor, SQL Performance Analyzer, Data Guard, Cloning, Migrations,

Languages

C, SQL, PL/SQL, UNIX/NT Shell Scripting, Awk Scripting, Perl.

Tuning Tools

TKPROF, EXPLAIN PLAN, ADDM, AWR, SPM, SQLT

Web Technology

Web Portals, BMC Remedy, HP Quality Center, HP Java ITO (OVO) console, AWS, Openstack

ETL TOOLS

OWB, Sap data services, IBI migrator, SQL server integrator (SSIS), HR and Oracle Time Labour(OTL)

EDUCATION:

Bachelors in Computers Science from JNTU Hyderabad

Client :LPL Financial,

Location : Charlotte NC -Mar 2016 - Present

Role: SR. Oracle DBA

LPL Financial is the largest organization of independent financial advisors in the United States. LPL Financial advisors help clients meet investment goals with a number of financial services, including equities, bonds, mutual funds, annuities, insurance, and fee-based programs. Unlike many other brokerage firms, LPL Financial does not develop its own investment products, enabling the firm’s investment professionals to offer financial advice free from broker/dealer-inspired conflicts of interest.

Responsibilities:

Installed, configured and maintained Oracle 11GR2 Real Application Cluster

(RAC) 3 node RAC.

Successfully Performed the Exadata Patching of the Data Warehouse ENVT and saved 40000$ charges for the client.

Worked on databases on EXADATA various compression methodologies including HCC EXADATA Query high and Archive high methods.

Worked on The performance tuning of databases and the Query’s on the Exadata quarter rack by using the Smart Scan technology of the Exadata.

Migrated the Database to Supercluster Environment from single instance

Performed the OEM upgrade to 13c from 12c.

Managed the databases on Oracle 12c-Super Cluster Environment

Installed and Performing the Administration of the 12c Databases.

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

Performed the 12c Upgrade of RAC Clusterware from 11g.

Duplicated issues and tested solutions to make sure problems were resolved properly

Assisted Developers, and created backups by Exporting and Importing tables when needed

Established performance tuning best practices used by the DBA and Development teams

Used the UNIX shell scripting to automate the database Maintenance Jobs.

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

Investigation and validation of New database services technology

Configured web servers (IIS, Nginx) to enable caching, CDN application servers, and load balancers.

Attended Developer’s code review

Deployed and supported Memcache-AWS ElasticCache.

ew meetings and made recommendations to improve Efficiencies

Streamlined and improved job efficiency by creating scripts for common maintenance tasks

Kept team members and management updated on major issues so they have a clear picture of the situation

Evaluate all Performance tuning tools used by the team including Toad, SQL Developer, and OEM.

Performed quality control Audits

Worked on SRDF (EMC STORAGE) Technology for the replication of the data from source to target.

Supported development teams by providing SQL statement Tuning and removing load and query performance bottlenecks by using tools like Baselines, AWR, TKPROF, and SQLT.

Create repeatable consistent processes used by Developers and DBA’s to ensure a quality and efficient product that enables productivity from non-experts on day one.

Tune Oracle databases and application code using various techniques geared for their unique purposes:

Installation and maintenance of Oracle 12c Data Guard.

Worked extensively on Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Statistics.

Installed STANDALONE servers on ASM, Red Hat LINUX.

Provided a positive impression of support center by documenting, tracking, and following up on all solutions making sure end-user problems were resolved to their satisfaction

Extensively used the Database Resource Manager on the Exadata Server’s

Backup and recovery using RMAN.

Providing the Technical support to Application Support team for performance and database related issues.

Worked on ServiceNow Ticketing system to resolve the incidents based on Severity.

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

Oracle Golden Gate installation, configuration, troubleshooting Golden Gate EXTRACT and REPLICAT issues.

Worked on SOX compliance establish internal controls and procedures for financial reporting to reduce the possibility of corporate fraud.

Provided appropriate security for users of databases, applications, servers, and systems, by setting and managing accounts, keeping sensitive data secure

Provided on-call support 24x7 for any issues with system by receiving text messages when an issue arose and logging in remotely to resolve those issues

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

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

Worked with Oracle Support on more complex and unresolved issues

Environment: Oracle12c/11g/10g/9i, Oracle EXADATA X2-2 HALF RACK, Sun Solaris, Red Hat Linux, RMAN, SQL/PLSQL, AWS server, Data Guard, Golden Gate, OEM, AWR.SQL query tuning, Performance tuning, OEM, O patch auto, TOAD, Storage migrations.

Client : Boston Scientific corp,

Location :Spencers,Indiana, AUG 2015 - Mar 2016

Role : SR.Oracle DBA

The Boston Scientific Corporation (abbreviated BSC) is a worldwide developer, manufacturer, and marketer of medical devices whose products are used in a range of interventional medical specialties

Responsibilities:

Performed Upgrades, Bugfixes, Enhancements, and regular maintenance to the system by researching, planning, as well as applying patches to databases and E-Business suite to keep them up-to-date.

Provided Technical support and issue resolution to Enterprise applications, hardware, networks, and databases by root cause analysis, assessment, development, and implementation of solutions that meet the needs of users and kept them productive with minimal disruption

Kept databases, applications, and operating systems up-to-date through assessing, planning, and implementing upgrades and patches

Improved the database integrity and increased data accuracy for end-users and management by proficiently using SQL language to troubleshoot, query, insert, update, and delete table data

Successfully Administered the Sybase databases for the reporting purposes,

Installation, configuration, and maintenance of Oracle 10g and 11g database on OEL.

Supported more than 130 production and development databases

Upgraded the Oracle 10g database to 11g version and also applied patch set and interim patches whenever required to make the database software up to date.

Monitoring Day-to-Day Backups, Log’s & recovering them as per the requirement.

Successfully implemented Backup & Recovery using RMAN, Hot and Cold backups.

Taking the RMAN incremental and cumulative backups.

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

Extensive experience in RMAN recovery in RAC and standalone database.

Implemented Data Guard with maximum availability, protection and performance configurations and worked with Data Guard Failover and Switch over cases at the times of up gradation and migration.

Managed and monitored the Oracle Real Application Cluster (2 node RAC) running on VERITAS Storage.

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

Implemented DRP (Disaster recovery plan) for critical databases using Streams.

Provided Instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical I/O and Memory Usage.

Always monitoring the Oracle Instances, Users, Tables, Tablespaces, Memory structures, and Rollback segments, Redo logs, Archived Redo logs, and Alerts.

Created, monitoring database objects like Tables, Indexes, Views, Users, and DB Links etc.

Responsible for capacity planning, recovery planning and installing patches.

Assisted users with performing their job functions more efficiently by installing, configuring, problem-solving, maintaining and uninstalling software on servers and laptops

Environment: Oracle 9i, 10g, 11g, SQL, PL/SQL, Oracle Grid Control, Oracle Enterprise Manager Database Control, TOAD, SQL Developer, SQL*Loader, NT, Red Hat Enterprise Linux, ASM.

Client: Kaiser Permanente - July 2014 - Aug 2015

Location: Oakland, CA

Role: Oracle DBA

Kaiser Permanente is an American managed care consortium corporation. Headquartered in Oakland California, Minneapolis suburb. It operates in the United States, Mexico, and Canada

Land,

Responsibilities:

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

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

Installed and upgraded Oracle10.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 tablespaces.

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.

Tested database performance issues (monitoring and tuning) to ensure database optimization.

Managed and monitored the Oracle Real Application Cluster (2 node RAC) running on VERITAS Storage.

Created custom services for RAC database for distribution of load across the nodes.

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.

Working Experience with the latest TOAD having new features PLSQL & SQL Script Debugger, Database Health Checkup, ASM Manager, Diagnose Extents, Segment Advisor, SGA Trace, Query Builder.

Tuning SQL statements using Explain Plan and STATSPACK.

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

Installed & managed 10gOEMgrid monitoring solution and deployed agents.

Performed a Logical backup using and full/partial export/Import and Data Pump.

Responsible for configuring and backing up the database using RMAN, Hot backups, Cold backups and Logical backups.

Performed Schema as well as Table level Replication using Oracle Golden Gate and also did set up Disaster Recovery solution using Golden Gate.

Created bit-map Indexes for data warehouse databases.

Involved in the error checking and testing of the ETL procedures and programs Informatica session log.

Worked with ETL group for understating mappings for dimensions and facts.

Configured Physical and Logical Standby database for reporting environment.

Implemented database refresh with the hot backup using full export. Used EXPORT/IMPORT to do table level and full database defragmentation.

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

Proactively managed the databases; set up notifications, alarms using shell scripts for managing any exceptions in the day to day management of the databases.

Environment: Oracle 11g/10g, Solaris, VERITAS, OEM, EXPLAINPLAN, TKPROF, AIX, Oracle 12c RAC, TOAD, Dataguard, GOLDEN GATE, PERFORMANCE TUNING, SQL /PLSQL

Client: AVIVA Investors,

Location: Iowa - Feb2013-July2014

Role: Oracle DBA

Aviva Investors is an asset management company and is part of the Aviva group. It has global assets under management of over £269 billion, including equities, fixed income, property investments and cash.

Responsibilities:

Installed and Configured Oracle 10g databases on Linux and also Upgraded Oracle databases from 9i to the 10g version using Opatch.

Maintenance of around 200 databases combined on all the production, development and testing environments on various databases (DB2, SQL servers 2005).

Converted a single instance database to Oracle RAC 10g.

Installation, Configuration and Administration of Oracle 10g RAC.

Worked as Developer/DBA on the Projects to develop the application to store encrypted Passwords in the database by using the PL/SQL procedures and functions.

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

Created pl/SQL Procedures and function’s to automate the database maintenance tasks such as database statistics gathering and reporting the RMAN backup information from the RMAN catalog.

Configured Oracle Data Guard for Oracle Disaster recovery.

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

Restoration and Recovery of databases at the times of occurrence of critical failures.

Responsible for installing, upgrading and configuring the Oracle environment by creating databases, storage structures and objects, monitoring and optimizing database performance.

Implemented Oracle database backup & recovery solutions using RMAN.

Extensive use of Oracle Data Pump utility for moving data among the servers.

Created User Accounts, Roles and granting required access permissions and privileges to the database based on the applications they are accessing.

Configured and implemented Oracle Streams (Advanced Replication) for high availability.

Responsible for configuring and backing up the database using RMAN, Hot backups, Cold backups and Logical backups.

Performed automated backups and scheduling using scripting.

Written Stored Procedures and Triggers for database maintenance and management using PL/SQL

UNIX Shell Scripts for backups.

Managed and monitored the Oracle Real Application Cluster (4 node RAC) running on ASM storage.

Supported more than 300 production and development databases

Experienced in performing Point in time recovery using RMAN.

Used Oracle configuration assistants like DBCA (Database Configuration Assistant) for Creating databases, DBUA (Database Upgrade Assistant) for Upgrading databases and NECA (Network Configuration Assistant) for creating a Client-Server environment using Listener, TNS names etc.

Management of schemas, objects partitioning the tables & indexes.

Automation of data load and data parsing using Pl/SQL procedures, Korn shell scripting, and Sql*loader.

Tested database performance issues (monitoring and tuning) to ensure database optimization.

Involved in gathering requirements from end users.

Continuous monitoring of database performance during peak and non-peak loads using STATSPACK.

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

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

Client : IDEA MOBILE,

Location : Mumbai, INDIA - Oct2010-Dec2013

Oracle DBA/Developer

Responsibilities:

Database monitoring and performance tuning using OEM (Oracle Enterprise Manager) and Statspack.

Installation, Maintenance, and Administration of Oracle 10g on Red Hat Linux.

Implemented Data Guard and administered the production database.

Installed Oracle 10g RAC database on RHEL and applied all current patches.

Database Restore using RMAN, Cold Backup, and Export/Import.

Responsible for planning, testing and implementing different backup and recovery strategies.

Used Flashback table to restore tables which are a new feature of Oracle 10g.

Performance tuning i.e. Tuning RAC, tuning applications, shared pool, I/O distribution, rollback segments, buffer cache, redo mechanisms.

Extensive application tuning through STATSPACK, explain plan, SQL*Trace.

Implemented scripts to capture high resource utilization queries.

Implemented Oracle Advanced Security Options.

Maintained multiple terabyte databases on Oracle.

Cloned the production database periodically to the testing databases through RMAN.

Used Enterprise Manager on Oracle10g for the diagnostic summary, host CPU utilization, finding wait events, alert Log errors etc.

On-Call 24x7 DBA support for production databases.

Extensively used SQL Queries (Subqueries, correlated subqueries and Join conditions) to handle data mapping.

Tuned the SGA. Monitored the Shared Pool, Database buffer cache and Redo log buffers. Monitored Tablespaces and Segment fragmentation. Performed troubleshooting activities, created new users and assigned privileges and roles to users.

Environment: IBM AIX 5.3, RHEL, Oracle 9i/10g PL/SQL, SQL*PLUS, Exceed 6.2, Oracle Enterprise Manager 9.2.0/10g, Quest Software (5.0), VERITAS Cluster, RMAN.

Contact this candidate