Apply Now
Contract Type: C2C
Posted: 4 days ago
Closed Date: 03/06/2026
Skills: PL/SQL, SQL and UNIX Scripting
Visa Type: USC


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