Naresh Thaneeru

470-***-****

add4q6@r.postjobfree.com

SUMMARY:

Having 12 years of experience as an Oracle Database Administrator which includes hands on experience in database design, administration, production support, installation, configuration, upgrades, performance tuning, backup and recovery, cloning, capacity planning, troubleshooting, monitoring, coding and documentation.

Excellent working exposure on Oracle 9i, 10g, 11g, 12c in VLDB environment (100+ TB) in Exadata (x4,x5,x6,x7) and HP-UNIX, Linux, AIX, Solaris and Windows environments.

Experience with Exadata Full - rack 8 node RAC with ASM on Linux/Solaris/AIX.

Hands on experience on AWS services like – EC2, S3, IAM, VPC, DMS, SCT, RDS.

Migrating on-premise Oracle 11.2.0.4 database to AWS RDS Oracle.

Hands on experience in upgrading from Oracle database from 10g to 11gR2, 11gR2 to 12c.

Installed, Configured and troubleshoot Oracle Golden Gate 10g, 11g,12c (Table& Schema).

Data Guard configuration in Oracle 10g, 11g including Active Data Guard & Snapshot Standby, Data Guard Broker.

Extensively worked on performance issues and resolved complex SQL queries in timely manner in Exadata and non-Exadata environments.

Worked on Exadata X4/X5 frames and extensive working knowledge on Exadata specified features such as Smart Scan, Cell offloading, Hybrid Columnar Compression (HCC), write-back Flash Cache.

Implemented Data archiving, in-place HCC compression as per business needs.

Implemented Encryption and Enabled VPD Policies for sensitive financial data.

Cross Platform migration using transportable tablespace and RMAN for conversion.

Supporting weekly Deployments and resolving the performance issues.

Proactively identifying the performance issues through SQL Monitoring, SQL Performance Analyzer (SPA) and providing the recommendations to optimize.

Experience in Hot/Cold Backup, Recovery and Cloning of the databases using RMAN with Veritas Net Backup.

Apply patches like Critical Patch Updates (CPU), Patch Set Updates (PSU), and One-Off Patches, Interim patches, and Patch sets in Oracle 10g, 11g versions.

Working closely with application developers and testers to build the database including objects creation required for new application and existing app.

Delivering Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, AWR, SQL TRACE, ADDM& SQL Tuning advisors.

Extensively worked on creation, designing of new oracle Databases (10g, 11g& 12c) with ASM filesystem.

Writing sql/pl-sql coding to create db-views, procedures, functions, packages on ad hock requirements.

Proficient in Disk management and problem resolving techniques with a good understanding of Capacity planning and efficient usage of the disk space.

Implemented the Database Health checkup in house scripts for mission critical databases.

Good experience in SQL, PL/SQL, Shell Scripting, Partitioning, Physical Database Design, Backup and Recovery strategies.

Hands on experience in ticketing tools (BMC Remedy, Jira & ServiceNow).

Technical Skills:

Hardware

Exadata x4-2 half rack, x5-2 full rack

Operating System

HP-UX, Sun Solaris, AIX, RHEL and windows 95/98/NT/2000/XP

RDBMS

Oracle 9i, 10g, 11g, 12c

Tools/Utilities

RMAN, OEM, Export/Import, Golden Gate, TOAD, Data pump, Data Guard, ASMCMD, DBCA

Programming Languages

SQL, PL/SQL, C, C++, HTML, UNIX Shell Scripting

Tuning Tools

TKPROF, EXPLAIN PLAN, AWR, ASH, ADDR, SQLT

Certifications:

Oracle Database 11g R2 Administrator Certified Professional (OCP)

AWS Certified Solutions Architect - Associate

Educational Qualification:

Master of Computer Applications (MCA) from Kakatiya University, India - 2008.

Professional Experience:

Project: Texas Health and Human Services Commission – Austin, TX Jan 2020 – Till Date

Role: Lead Oracle DBA

Responsibilities:

Responsible for overall database performance using such tools as AWR, ASH, ADDM to determine bottleneck and suggest for improvements.

Designing the OLTP, DW environments for optimal performance, BI reporting purpose.

Implemented encryption (TDE) and enabled VPD Policies for sensitive financial data and enabled the data/row level security.

Configuring the Active Standby for DR solution in Oracle 11.2.0.4 and implementing the monitoring.

Upgrading Oracle databases from 11.2.0.3 to 11.2.0.4 version.

Effectively optimizing the ETL jobs for meeting the SLA’s.

Creating informatica Mappings, Workflow, Sessions to load the data into DW system.

Developing procedures, triggers, views, packages for data load and data transmissions.

Working as a logical database modeler to design the flawless application flow in relational databases.

Collaborating the with Dev, Testing/QA teams to validate the database changes.

Assisting the other ETL developers in solving complex scenarios and coordinated with source systems owners with day-to-day ETL progress monitoring.

Writing sql/pl-sql coding to create db-views, procedures, functions, packages on ad hock requirements.

Extensively worked on RMAN (Backup, Recovery), Logical backup (Export, Import) for data refresh tasks for monthly/quarterly refresh tasks.

Environment: Oracle 10g,11g,12c PL/SQL, ASM, RMAN, OEM, RAC, SQL Developer, Toad, Data guard, Export/Import, UNIX, SOLORIS, AWR, ASH, SQL Tuning Advisor, SQL Plan Baselines(SPM), Crontab, MS-SQL 2014, MS-SQL 2016 AIX, Linux, RHEL, Windows.

Project: State Street Corporation – Austin, TX Jun 2016 – JAN 2020

Role: Lead Oracle DBA

Responsibilities:

Extensively worked on performance issues on Exadata X4, X5 frames and tuned complex SQL queries, PL/SQL procedures, Functions, Packages in timely manner and establishing the guide lines for better optimization techniques.

Migrating Oracle 11.2.0.4 Databases from AIX to Exadata X4 Exadata Machines with minimal downtime.

Migrating on-premise Oracle 11.2.0.4 database to AWS RDS Oracle.

Implemented Data archiving, purging, in-place compression (HCC) as per business needs to save multi terabytes on monthly wise.

Writing sql/pl-sql coding to create db-views, procedures, functions, packages on ad hock requirements.

Proactively monitoring AWR, ASH and ADDM reports to provide recommendations to implementation teams.

Configured Data Guard in Oracle 10g, 11g including Active & Snapshot Standby, Data Guard Broker.

Administering Oracle 10g, 11g RAC environment databases using SRVCTL, CRSCTL and load balancing RAC environment using RAC services for different needs.

Automated the several database monitoring alerts by implementing custom built Oracle packages – procedures/functions, triggers.

Automated the file system housekeeping tasks using shell scripting through cron jobs.

Automating the monitoring jobs for easy tracking & quantifying efforts with customized PL/SQL procedures, packages, functions.

Configuring the Golden Gate table level replication in 10g, 11g, 12c environment.

Worked with Agile teams to implement the changes & coordinated for continuous integration.

Performance tuning for overall database performance, using such tools as AWR, ADDM, TKProf, Traces to determine bottlenecks and improve performance.

GG performance tuning like split replicates using Range, use batch sql, server load & underlying object partitions.

Extensively worked on RMAN (Backup, Recovery), Logical backup (Export, Import) for data refresh tasks for monthly/quarterly refresh tasks.

Designed with tablespace, schemas, tables for elastic growth and optimal performance in 11g,12c.

Implemented encryption and enabled VPD Policies for sensitive financial data and enabled the data/row level security.

Environment: Exadata (x4,x5,x6,x7),AWS-RDS, DMS,SCT, Oracle 10g,11g,12c Exadata Frames (X4, X5),PL/SQL,ASM, RMAN, OEM, RAC, SQL Developer, Toad, Data guard, Export/Import, UNIX, SOLORIS, AWR, ASH, SQL Tuning Advisor, SQL Plan Baselines(SPM), Crontab, MS-SQL 2014, MS-SQL 2016 AIX, Linux, Windows.

Project: 3M- Austin, TX Feb 2016–May-2016

Role: Sr Oracle DBA

Responsibilities:

Extensively worked on Performance issues in Exadata & Non-Exadata version & provided the scalable recommendations to improve the performance.

Extensively performed Full database, schema, Table refresh using expdp/impdp.

Creating the database users and setting the default tablespaces and temporary tablespaces, Assigning quotas, roles, privileges and profiles.

Extensively worked on RMAN (Backup, Recovery), Logical backup (Export, Import) for data refresh tasks for monthly/quarterly refresh tasks.

Tuning the SQL queries include pl/sql blocks such as procedures, functions, packages.

Automated the file system housekeeping tasks using shell scripting through cron jobs.

Automating the monitoring jobs for easy tracking & quantifying efforts with customized PL/SQL blocks.

Working with Dev teams to validate the changes & integration into the existing code.

Designed with tablespace, schemas, tables for elastic growth and optimal performance in 11g,12c.

Configuring the Golden Gate table level replication in 10g, 11g, 12c environment.

Upgraded the Oracle Databases from 11g R2 to 12c R1.

Proactively identifying the performance issues through SQL Monitoring, SQL performance Analyzer (SPA) and providing the recommendations to optimize.

Environment: Exadata (x4,x5), Oracle 10g,11g,12c Exadata Frames (X4, X5),ASM, PL/SQL,RMAN, OEM, RAC, SQL Developer, Toad, Data guard, Export/Import, UNIX, SOLORIS, AWR, ASH, SQL Tuning Advisor, SQL Plan Baselines(SPM), Crontab, AIX, Linux, Windows.

Project: Columbia Broadcasting System(CBS) - Atlanta, GA Apr 2014 –Jan 2016

Role: Sr Oracle DBA

Responsibilities:

Managing & Supporting 200+ databases which includes 9i, 10g, 11g and multiple databases in Exadata environment.

Migrating the legacy oracle databases (11g) to Exadata(X3,X4) frames with minimal downtime.

Working as Team lead for coordinating offshore and onshore team.

Worked closely with Customer and Application development team to provide database support.

Extensively worked on RMAN (Backup, Recovery), Logical backup (Export, Import) for data refresh tasks for monthly/quarterly refresh tasks.

Configured the Standby Database (Physical 11g) for Disaster Recovery and reporting purpose.

Extensively worked on creation of new oracle Databases (10g, 11g) with ASM filesystem.

Implemented encryption and enabled VPD Policies for sensitive financial data and enabled the data/row level security.

Capacity planning for Future growth of the Production & Non-Production databases.

Creating the database users and setting the default tablespaces and temporary tablespaces, Assigning quotas, roles, privileges and profiles.

Extensively performed Full database, schema, Table refresh using exp/imp &expdp/impdp.

Upgraded the production and development databases from 10gR2 to 11gR2.

Creating and managing database objects such as, schemas, tablespaces, tables, indexes, views, synonyms, sequences, database links, constraints etc.

Tuning the SQL queries include pl/sql blocks such as procedures, functions, packages.

Checked I/O, CPU or memory bottlenecks and suggest appropriate measures.

Database refresh from Prod to Non-Prod (RMAN) for month end activities and testing

Monitoring the regular database alerts like File System alerts, table space usage alerts, Alert log and fixing those errors accordingly.

Weekly Support Project review meeting and reviewing the DBA services performance.

Environment: Exadata (x4,x5), Oracle 9i,10g,11g, ASM, RMAN, RAC, GoldenGate, PL/SQL, TOAD,SQL Developer, OEM, Data guard, Flashback, Export/Import, AWR, ASH, SQL Tuning Advisor, SQL Plan Baselines(SPM), Crontab, UNIX SOLORIS, AIX, Linux, Windows.

Project: IngramMicro - Santa Ana, CA Nov 2010 – Mar 2014

Role: Oracle DBA

Responsibilities:

Database Installations, configuration of oracle 10g & 11g with ASM storage.

Oracle Database upgrade from 10.2.0.3 to 11.2.0.3.

Worked on weekly two Node Prod RAC Database reboot (10.2.0.4).

Administering the RAC Environment through SRVCTL and CRSCTL.

Adding new tables to Golden Gate Replication whenever require.

Extensively worked on RMAN (Backup, Recovery), Logical backup (Export, Import) for data refresh tasks for monthly/quarterly refresh tasks.

Performance tuning for overall database performance, using such tools as AWR, ADDM, TKProf, Traces to determine bottlenecks and improve performance.

Hands on experience on the advisors tools such as SQL Tuning Advisor, SQL Access Advisor, SQL Performance Analyzer, SQL Tuning Set and Advisors to Administering the Databases on Automatic Storage Management (ASM)

Implemented encryption and enabled VPD Policies for sensitive financial data and enabled the data/row level security.

Creating the database users and setting the default tablespaces and temporary tablespaces, Assigning quotas, roles, privileges and profiles.

Taking the backup of production database using RMAN and Scheduling it from cron.

Adding new disk in to a diskgroup whenever required in ASM.

Following the Alert Management, incident management and change management processes.

Documented policies and procedures for each project including recovery in case of disaster using procedures, Mentored the users on applications and interfaces.

Tuning the SQL queries include pl/sql blocks such as procedures, functions, packages.

Schema Refresh from Production to Dev, UAT, Test using logical Backups.

Monitoring the blocking sessions & clearing those to avoid the performance

Environment: Oracle 9i 10g, RMAN, ASM, SQL*Plus, PL/SQL stored procedures, PL/SQL,OEM, Data guard, Flashback, SQL*Loader, Export/Import, AWR, ADDM, ASH, Explain Plans, TKProof, SQL* Trace, TOAD, Cronjob (unix), UNIX, SOLORIS, AIX, RH-LINUX and Windows.

Project: Rinker Materials - Bangalore, India Sep 2008 – Oct 2010

Role: Oracle DBA

Responsibilities:

Creating primary database objects (tables, views, indexes) once application developers confirmed.

Performed Database monitoring for deadlocked process and maintained logs/backups

Created users, tables, database links, Performing Exports/Imports

Tuning the SQL queries include pl/sql blocks such as procedures, functions, packages.

Taking Online and Cold Backups, Exports etc

Coordinated with UNIX administrators for space management

Refresh schema-using Export/Import. Creating the database, table spaces, tables, indexes, setting privileges and user logins

Production Backup monitoring.

Configuring the RMAN persistent parameters.

Implemented encryption and enabled VPD Policies for sensitive financial data and enabled the data/row level security.

Extensively worked on RMAN (Backup, Recovery), Logical backup (Export, Import) for data refresh tasks for monthly/quarterly refresh tasks.

Taking care of the client’s SLA and follows client process for any changes in the database.

Working on Tablespace usage alerts and various OEM alerts.

Scheduled Automated scripts in cron for monitoring databases.

Performing all the Database Administration activity like space management in database, User and Roles administration, Schema management.

Environment: Oracle 9i 10g, RMAN, ASM, SQL*Plus, PL/SQL stored procedures, PL/SQL, OEM, Export/Import, AWR, ADDM, ASH, Explain Plans, TKProof, SQL* Trace, TOAD, Cronjob (unix), UNIX, SOLORIS, AIX, RH-LINUX and Windows.

Contact this candidate