Oracle Database Administrator

ORACLE DATABASE ADMINISTRATOR

* ***** ** ********** ** Database administrator with expertise in performance tuning, crisis management, and high availability to increase reliability, maximizes productivity, and introduce system efficiencies. Proficient in an assortment of technologies for monitoring, ensuring data security, organizing data and continually optimizing user accessibility. Have strong interpersonal, analytical, & problem-solving skills with customer service oriented attitude. A very good team player, self-motivated, dedicated in any work environment.

DBA Skills Include:

Oracle Database Administration

High Availability and Replication

Performance Tuning & Capacity Monitoring

Oracle Forms and Reports Development

Data Security, Backup & Recovery

Disaster recovery planning

Standby/Failover Administration

Data Security

SQL Tuning in an Oracle Environment

Technical Skills:

Operating Systems: UNIX - Solaris, HP UX, AIX, Red Hat 4 Linux 2.6.9, and Windows Nt/ 2000

RDBMS: Oracle V9i, 10g, 11g RAC,11g SAP BASIS,12C

Tools: SQL*Plus, OEM, Grid Control, SQL*Loader, GoldenGate, Dataguard, RMAN, Tracing, Stats Pack, Explain-Plan, AWR, Scheduler, Data Pump, Shell Scripting, ASH

PROFESSIONAL EXPERIENCE

GE Digital, India 05/2017-12/2017

Oracle Database Administrator, SAP Basis Administrator

Responsible for Installation, implementation of Oracle Real Application & configuration of Brtools for Sap BASIS on 10g and 11g for highly available transactional systems.

Upgraded oracle 11.2.0 databases to 12.2.0.1.0 version.

Configured Goldengate Downstream Mining and integrated components for Active-Passive and Active-Active Replication.

Configured Goldengate High availability using Oracle DBFS and Active Dataguard.

Installed, configured, supported Grid Infrastructure(Clusterware, ASM, Disk Groups), Private Network for Interconnect, Public Network (VIP, SCAN),OCR and Voting Disk of 4-node 11g RAC on Linux using ASM/ OCFS2.

Refreshed databases using RMAN active database duplication and data pump

Applied Oracle-supplied patches to the databases of each OS. Keep all databases with up to date version and patch level.

Supporting and documenting the implementation of approved changes to system configurations, software, and infrastructure within the approved testing schedule.

Enhanced database performance tuning services such as, SQL tuning services with using STATSPACK, EXPLAIN PLAN, TKPROF AWR, and ADDM which is used to collect and maintain performance statistics and improves the database performance.

Developed and tested storage strategies and disaster-recovery plan for critical production database, delivering solution that guaranteed recovery performance and high availability using RMAN methodologies.

Deployed OEM 12C to fully automate database and system monitoring, created OEM reports on daily scheduled tasks, health checks of the databases.

On call 24x7 support for Oracle Production Database Administration for Oracle & SAP basis DB.

GE Industrial Solutions Ptc Windchill, India 09/2015-05/2017

Oracle Database Administrator, AWS RDS Administrator

24x7 Project DBA for Production database administrations, support and monitoring to ensure a proactive problem recognition and resolution of database issues

Responsible for managing Oracle 11g RAC with Oracle supplied utilities, CLUVFY, CRSCTL and SRVCTL& Administering ASM diskgroups, Disk addition, Storage allocation.

Responsible for implementing infrastructure & database refresh on new AWS systems and migration of existing Linux and Windows based systems to AWS, Designing roles and groups using AWS Identity and Access Management (IAM).

Responsible in migrating and managing multiple applications from on premises to cloud using AWS services like S3, EC2, RDS, Cloud formation.

Unix Shell scripting in ksh for automating daily scheduled stats job, startup/shutdown, backup and recovery, Import and export procedure of databases, getting system alerts.

Created and maintained different database throughout the infrastructure Landscape including performance and tuning analysis using AWR & ADDM, Database Control, and Quest Tools, capacity planning, systems support & optimization.

Responsible for refreshing and cloning of databases per customer requirements using RMAN, Data Pump, and hot backup scripts.

Patching and Upgrading the databases with the current available and released oracle versions

Jefferies LLC, Genpact-India 11/2013-09/2015

Oracle Database Administrator

Performed database system management functions (e.g., software installs, version upgrades and configuration management) for Oracle 11g databases.

Performed database functions with tools Toad, pl/sql developer for SQL, PL/SQL coding, stored procedures, triggers, functions, packages, UNIX Shell Scripting, Partitioning, Indexes, Logical and Physical database design.

Performed Database Administration, User Management, Table space and Data file administration, monitoring trace files and log files for troubleshooting.

Implemented RMAN backup & recovery procedures and disaster recovery procedures for Development and staging databases.

Configured OEM for monitoring and managing multiple instances for database performance analysis and optimization, defining bottlenecks and manage testing and production implementation.

Implementation and documentation of disaster recovery and data load procedures.

Analyze and Manage workloads & CPU Utilization using OSWATCHER/AWR reports for Oracle.

Providing ongoing progress to leadership, system owners, and peers regarding health of the environment and status of testing.

EDUCATION

Bachelor of Technology, Computer Engineering, GMRIT, JNTUK University, INDIA 2013

Contact this candidate