Role: Senior Oracle Database AWS/OCI/Cloud DBA
VISA: USC
LOOKING REMOTE OR ONSITE AT GA LOCATION ONLY
PROFESSIONAL SUMMARY:
- About 13 years of experience in Oracle Database Administration version 19c/12c,11G/10G.
- Worked on variety of UNIX (Solaris, HP-UX, AIX), Windows NT 4.0/2000/2003 with Oracle ( 11g,19c,12c), RAC, streams, standby, replication, installation, configuration, migration, sizing and space management.
- Installed Oracle 19c,12c,11g,10g RAC software with ASM & OCFS2 File systems.
- Installation, maintenance and tuning of RAC Applications. Used rapid install and other Oracle Application maintenance utilities like OEM.
- Upgraded to 19C 18C 12c Grid Infrastructure from 12c.
- Upgraded database from 12c to 19c.
- Upgraded databases from 11g to 19c.
- Created development, testing, staging, production, RAC and standby databases for OLTP, DSS and Data Warehousing using customized shell scripts and stepwise.
- 24*7 production database support with Support to developers & end-users.
- Have implemented ORACLE STREAMS, and two type of standby databases supported by DATAGUARD, logical standby and physical standby databases.
- Hands on experience in Dataguard, Grid control, streams, replication.
- Have worked on large-scale databases with size of more than 1TB to 18 TB in large system environments.
- Implemented and delivered core edge technologies of Oracle 12c &19c (Streams, EM Grid Control, and RAC).
- Configured an AWS Virtual Private Cloud (VPC) and Data Base subnet group for isolation of resources within AWS RDS.
- Implemented RMAN backup (Full, incremental and cumulative) and recovery, Incomplete recovery and disaster recovery using Standby database or Data Guard.
- Implemented automated backup strategy using the UNIX shell script CRON UTILITY.
- Expertise in PL/SQL, SQL and UNIX Scripting (Used to write UNIX Scripts & implemented by Using CRONJOB for Day – to – Day activities.)
- Implemented automation for infrastructure using Ansible & devops tools.
- Working with GitHub private repositories and Created object store backups using versioning enable.
- Experience in working on source controller tools like Subversion (SVN), CVS, and GIT
- Performance tuning of the database - SQL Tuning, Used Tuning utilities like STATSPACK, TKPROF, EXPLAIN PLAN, AWR, ADDM and Tuning of SGA, Distribution of disk I/O, Sizing of tables and indexes.
- Performance Tuning i.e. tuning applications, shared pool, I/O distribution, rollback segments, buffer cache, redo mechanisms
- Installation and Configuration of Oracle Grid Control.
- Data loading using SQL*LOADER, Logical backups using full export and DATAPUMP.
- Database replication using snapshots, materialized views and advanced replication methods.
- Worked on different types of storage structures (SAN/NAS).
- Extensive knowledge in reporting tools like Business Objects and crystal reports
- Good co-ordination and communication with system administrators, business data analysts and development teams.
- Skilled in performance tuning of the database.
- Versatile team player with excellent analytical, communication and inter personal skills.
- Work closely with multiple stake holders Functional/Business Analysts, Application Development, QA team, Enterprise Architect team, Release managers and operations for multiple project deliveries.
- Extensively working with cloud based database environments preferably AWS cloud.
- Assisted in management and database administration of Oracle database applications on Exadata (X4, X5, X6, X7) platforms.
- Performed cloning for Pluggable database 12c while managing People Soft & ERP application.
- Provided technical assistance for designing, installation and upgrading of existing Oracle databases.
- Lead the Design & implementation for RAC and migrated the Oracle environment to new VM’s
- Performed database management functions such as maintenance, access issues and security.
- Conducted designing, assembly and tuning of databases in coordination with development teams.
- Evaluated database performance for investigation of issues and further resolution for efficiency.
- Implemented procedures for automation of database management through tables and indexes.
- Executed processes for evaluation of system space, database allocation and storage metrics.
- Maintained all existing databases and new installations at current and stable production levels.
- Installing OEM agents and managing databases using GRID Control 11.1 , 12c ,19c EM
- Extensive knowledge and experience on Amazon Web Services(AWS) Technologies like: EC2, RDS, Route53, ELB, CloudWatch, AMI (Amazon Machine Images), IAM, VPC, Subnets.
- Primary technical resources to upgrade Oracle Golden Gate from 12c to 19c in Exadata machine environment. Design Golden Gate HA solutions by using Oracle 11g & 12c Cluster ware functionality.
- Golden replication from Oracle Private Cloud to OCI.
- Experienced to support Oracle Super Cluster T5 and S7 Mini Cluster series machines using ZFS Shared Storage Subsystem