NAME:VODETI NAGARAJU

EMAIL:ad2hmz@r.postjobfree.com

PHONE:334-***-****

ORACLE DATABASE ADMINISTRATOR

* ***** ** ** ********** years of experience as a Database Administrator having hands on experience in database administration and performed different tasks like installation, configuration, upgrades, patches, performance tuning, backup and recovery, production support, cloning, space management, database security. Experience in the design, maintenance, and administration of ORACLE 19c/18c/12c/11g/10g/9i

Professional Summary

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

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

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

Extensive experience in migrating oracle database on premises to AWS Ec2 instance

Worked on AWS environment oracle databases for 8 months.

Automated routine tasks using PowerShell or Azure Automation. Implemented security measures to protect Azure SQL databases, including firewall rules, encryption, and authentication.

Azure DevOps Services: Azure DevOps provides tools and services for software development, including source code management, continuous integration/continuous delivery (CI/CD), issue tracking, and project management.

UNIX Shell Scripting:Ability to write shell scripts (e.g., Bash, Korn shell) for automating tasks related to Oracle database management on UNIX.

Application Performance Monitoring (APM):Expertise in using AppDynamics for monitoring and analyzing application performance.

Service Design:Designing Oracle solutions that meet business requirements and align with ITIL principles.

Ensuring scalability, availability, and performance of Oracle systems.

Service Transition:Planning and executing the transition of Oracle services into production

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 19c/12c/11g/10g/9i, Oracle 11g Real Application Cluster (RAC), ASM, Exadata X3-2, X4-2 Half Rack and Full Rack Clusters

Tools and Utilities

RMAN, OEM, TOAD, SQL*Loader, 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, STATSPACK, ADDM, AWR.

Web Technology

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

Cognizant Hyderabad india, Jan2020-Dec2022

Oracle DBA

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.

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 is 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.

Job Scheduling:Proficiency in defining and scheduling batch jobs related to Oracle using Autosys.

Automation of routine tasks, such as database backups, data loading, and report generation.

Dependency Management:Utilizing Autosys to manage dependencies between Oracle jobs to ensure proper execution orde

Maintained multiple terabyte databases on Oracle.

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

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

On-Call 24x7 DBA support for production databases.

Extensively used SQL Queries (Sub queries, correlated sub queries 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 trouble shooting activities, created new users and assigned privileges and roles to users.

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 is 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 diagnostic summary, host CPU utilization, finding wait events, alert Log errors etc.

On-Call 24x7 DBA support for production databases.

Extensively used SQL Queries (Sub queries, correlated sub queries 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 trouble shooting activities, created new users and assigned privileges and roles to users.

SQLandPL/SQL:Proficiency in writing complex SQL queries and PL/SQL proceduresforOracledatabases.

Data Warehousing:Experience in Oracle data warehousing solutions, such as Oracle Data Warehouse and Oracle Exadata

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