Data Oracle
Resume:
Aqib Oracle DBA
Ph: 713-***-****
Email: ************@*****.***
PROFESSIONAL SUMMARY:
Over 8+ years of experience as an Oracle DBA on 19c,18c,12c,11g and 10g
Upgraded database from 10g to 11g to 18c RDBMS and 19c Grid Infrastructure.
Migrated database to AWS cloud.
Data Guard (Standby Databases)
Real Application Cluster (RAC)
Automatic Storage Management (ASM)
Exadata x7
Golden Gate Replication
MS SQL Server
Backup and restore/recovery using RMAN
Administration of Oracle 10g, 11g, 12c to18c to 19c RDBMS
Cloning / Refreshing database objects using Data Pump and RMAN
OEM / SQL Developer / TOAD
Patching, PSU, RU, One-off patches, CRU Bundle patches
Performance Tuning / ASH / AWR / ADDM / SGA / Tracing / Wait events
Database Migration
Database Upgrades
Shell Scripts
Automating jobs
Cloud AWS (Amazon Web Services) / EC2 instances
Experience in Infrastructure Development and Operations involving AWS Cloud
Build RAC from scratch on Linux.
Proficient in maintaining 10g, 11g, 12c,18c and 19c databases.
Proficient in oracle dictionary and oracle dynamic views.
Managed and administered databases from command line and 12c/13c OEM.
Expertise in Installation, Configuration, Patching, Migration, Trouble shooting and Performance.
Tuning of oracle databases on UNIX, LINUX and Windows environments.
Upgraded databases to 11g and 12c, 12c to 18c to 19c.
Established security policies in the AWS cloud
Experience in Data Center Migration.
Involved in 24x7 support for production RAC databases with on-call pager
Administered databases on Exadata
Applied patches on computer nodes, Exadata home and storage cells.
Migrated standalone databases to Exadata
Implement disaster recovery with use of Exadata Setup and managed replication using Oracle Golden Gate
Worked on Data Migration project.
Migrated databases from Windows platform to Linux
Experience in setting up Oracle Data Guard and Grid Control.
Experience in setting up GoldenGate uni and bi-directional replication.
Worked with many following 11g,12c,18c and 19c new features
SQL Access Advisor, SQL Performance Analyzer and SQL Plan Manager
Build Standby database and used Active Data Guard
Upgraded from 11g to 12c R to 18c to 19c
Experience in setting up AWR Baseline Enhancements
Worked on SQL Advisor and Automatic SQL Tuning.
Worked on Tablespace/Extent/Segment Management
Worked on Backup and recoveries using user managed and RMAN.
Setup Oracle Enterprise Manager on grid control.
Extensive experience in managing databases via 13c Cloud Grid Control
Used RMAN extensively to backup, restore and recover databases.
Managed Databases on Exadata Machines.
Applied CPU, PSU, SPU and bundle patches.
Proficient in using tools such as celcli and dcli in Exadata.
Build and managed RAC databases on Exadata
Performed silent installation of databases on Exadata
Work with databases ranging from a few GB to up to 25 TB.
Hardworking, result oriented, enthusiastic, good interpersonal and communication skills
Build Database homes and databases using Cloud Plane.
Worked on Oracle Materialize Views, Oracle Golden Gate and Oracle Active Data Guard.
Setup and manage Oracle Golden Gate Replication
Worked extensive with developers and application team.
Used Data Pump and exp/imp tools to refreshes tables, schemas and databases.
Managed databases using 12c/13c cloud control and TOAD
Build scripts to automate tasks.
Migrated standalone databases to RAC on Exadata
Cloned database using RMAN Duplicate
Managed databases on Exadata x5 and x7
Migrated databases to OVM on Exadata X7
Working on building environments on Exadata X-5 and X-7
Performed Silent installation on Exadata.
Applied patches on computer nodes, Exadata home and storage cells.
Migrated standalone databases to Exadata
Implement disaster recovery with use of Exadata
Good Understanding of Exadata Architecture.
Managed databases on AWS cloud
Extensive use of Data Pump to refresh database objects.
Provide installation, configuration, maintenance and troubleshooting support for database application software both on premises and in the Cloud
Contribute to Cloud strategy discussions and decisions on overall Cloud design and best approach for implementing Cloud solutions.
Define best practices around migrating applications and required Databases to AWS and other Cloud providers.
Develop standards and procedures for all aspects of Database/Warehouses in the Cloud.
Design, test and support solutions for Disaster Recovery on premises and in the Cloud
Diagram and document database Cloud implementations.
Administered and Managed SQL Server Databases.
TECHNICAL SKILLS:
Database Installation
Oracle DBA
RDBMS
Performance tuning,
RMAN restore and recovery,
Export Import via Data Pump,
Shell scripting,
Excellent troubleshooting
Root cause analysis.
Linux / Windows/ AIX /Solaris
Shell Scripting
RAC
ASM
AWS
EC2
TOAD
Patches
SQL Advisor,
Upgrade,
Migration,
silent install
SQL Server
MySQL
SQL
PLSQL
13c OEM
Data Guard
ASH
AWR
ADDM
Exadata
Golden Gate
AWS
PROFESSIONAL EXPERIENCE:
Virtusa Corporation, Indianapolis, IN
Feb 2019 – Present
Oracle DBA
Duties:
Planning, Implementing and Validating various versions of Oracle Databases to 19c,18c, 12c and 11g
Latest migration project I have worked on is moving databases from standalone to Exadata X7.
Moved databases from AIX to Linux
Used cross-platform migration using xtts method of v4
Install and upgrade on all the environments (in a procedural approach Dev, Test, Stage and Production)
Planning of back out procedures like downgrades/building parallel environments and also working on proof of concept for Oracle 11gR2,12c, 18c and 19c upgrades.
Checking Backup and Restore validity periodically on databases about 12TB in size, and Data refreshes from Production to Non-Production environment, Creation Duplicate Databases using RMAN Backups
Provided day to day operational support
Migrated databases to OVM on Exadata X7
Working on building environments on Exadata X-5 and X-7
Performed Silent installation on Exadata.
Applied patches on computer nodes, Exadata home and storage cells.
Migrated standalone databases to Exadata
Implement disaster recovery with use of Exadata
Worked on data center migration in which moved databases using Oracle Data Guard.
o4-node RAC cluster to 2-RAC Cluster
oStandalone to Standalone.
Completed Migration from AIX to Linux.
Responsible for installing, supporting the oracle stand alone, RAC(2node) and RAC(2node) with Data Guard databases of the version 11g, 10g and 9i on Sun Solaris 10, and Windows 2008.
Installed Oracle 12c database with a single instance on a Linux in a test environment.
Demonstrated experience in managing Oracle 10g/11g/12c/18c RAC environments using the Grid Control tools.
Worked on database refreshes
Performed schema and table level export imports using Data Pump
Performed RMAN cloning.
Migrated databases from 10g,11g,12c,18c to 19c.
Responsible for installing, supporting the oracle stand alone, RAC(2node) and RAC(2node) with Data Guard databases of the version 11g, 10g and 9i on Sun Solaris 10, and Windows 2008.
Installed Oracle 12c database with a single instance on a Linux in a test environment.
Demonstrated experience in managing Oracle 10g/11g/12c/18c RAC environments using the Grid Control tools.
Worked on Oracle Materialize Views, Oracle Golden Gate and Oracle Active Data Guard.
Designed, configured, and maintained backup and recovery policies using RMAN
Migrated databases to AWS
Worked on project to migrate databases to AWS instance
Set up oracle instances on AWS cloud
Hardworking, result oriented, enthusiastic, good interpersonal and communication skills.
Build Database homes and databases using Cloud Plane.
Worked on Oracle Materialize Views, Oracle Golden Gate and Oracle Active Data Guard.
Provide technical and functional support to project teams.
Organize trainings for business units as needed.
Provided 24/7 on-call support.
Worked with offshore team members.
Oracle Database Migration from Windows to Linux.
Performed SQL and PL/SQL tuning and Application tuning using various tools like TKPROF and AUTOTRACE.
Install and Upgrade Oracle 10g,11g,12c,18c,19c databases
Extensive experience in managing databases via 12c/13c Cloud Control.
Applied PSU and cluster bundle patches.
Managed standby Data Guard databases.
Worked on databases using GoldenGate replication.
Performance Tuning of databases.
Build and managed RAC databases on Exadata
Migrated databases on Exadata
Performed silent installation of databases on Exadata
Patched grid home, RDBMS home on cells.
Supported Dev/App team in troubleshooting network and performance issues.
A-1 Tax Service, Inc, Vero Beach, FL
Oct 2014 -Feb 2019
Oracle DBA
Duties:
Installed databases on Linux platform
Build and managed 10g,11g,12c cluster
Provide 24x7x365 administrative support staff.
Migrated databases to AWS.
Setup security policies on AWS cloud platform.
Configure Data Guard to provide high availability using Physical stand by database.
Use RMAN duplicate database feature to move/clone databases on Linux, AIX and Solaris.
Cluster Installation and Configuration, Administering databases in RAC for high availability.
Install, configure and setup of 11g,12c RAC on Linux.
Add new nodes to RAC 12c Cluster to distribute the load.
Install and implement 10g RAC with 4 nodes with ASM.
Upgrade Databases from 11g to 12c
Applied PSU patches.
Migrated database to new datacenter.
Setup uni-directional GoldenGate setup.
Responsible for installing and configuring Golden Gate on Oracle Servers.
Database migration from standalone to RAC
Design, configure and maintain backup and recovery policies including RMAN backups.
SQL, PL/SQL Tuning and Monitoring.
Compared multiple snapshots using AWR.
Responsible for setting up Oracle Golden Gate to propagate information between databases.
Recover databases and clone applications using RMAN.
Use AWR, ADDM, TKPROF, and SQL Trace for database performance statistics.
OEM Grid Control installation and configuration for monitoring and performance tuning.
Proactive performance monitoring & capacity planning for future database & server growth.
Perform Range Partitioning to improve the performance of the database.
Perform Cross platform migration using transportable tablespaces and RMAN.
Perform Import and Export using Oracle Data pump utilities.
Administer and maintain database security policies and procedures.
Experience with administration of high-performance and large-scale multi-terabytes DBs.
Use external tables and SQL*Loader to import data from flat files.
Monitor database space requirements and adjust for future needs.
Perform version upgrades and patch installs.
Applied latest patches as per evaluation requirement.
Performing tuning of application with Trace, tkprof, Explain plan, statspack, AWR and ADDM
Implemented Oracle database backup & recovery solutions using RMAN.
Extensive use of Oracle Data pump, Exports/Imports utility for moving data
Performed large batch jobs and tuning of SQL queries and database systems.
Applied CPU and PSU patches.
Provided 24/7 on-call support
Worked with offshore team members.
HP, Chicago, IL
March 2012– Sep 2014
Oracle DBA
Duties:
Performed Oracle DBA duties involving development and production support: installations, configurations, backup/restore & recovery, database monitoring & operating system configurations, database performance tuning, assisting in the logical/physical database design, applications profiling, tuning queries and providing support to developers.
Complete Build of 4-node 10g RAC Cluster on RHEL 4 from scratch.
Assisted in management and database administration of Oracle database applications on Exadata platforms
Worked on Hybrid Columnar Compression (HCC) that provides dramatic reductions in storage for large databases
Participated in analysis and designing of Oracle Exadata Server for infrastructure and related projects.
Assisted in integration of Exadata applications into current IT actionable events and solutions.
Migrating databases to Oracle Exadata Database Machine for different clients
Migrated 10g database to 11g R2.
Skilled with statspack, AWR, ADDM, ADDM to check health of database & hardware.
Used Performance tuning tools such as tkprof, explain plans, oradebug and SQL Trace.
Performed database cloning to setup test and development database.
Migrated databases to different data datacenter.
Experienced with SRVCTL, OCR and Voting Disk of 10g RAC
Handled RAC Node hangs and node eviction issues.
Maintaining schemas and partitioning tables.
Experienced with all kinds (Status, Performance, and Trend Analysis) of DB Monitoring.
Index management for better performance, maintenance of Oracle Database
Responsible for administration and supporting oracle 11g, 10g and 9i databases
Created, upgraded, and cloned Oracle databases for Development and testing databases.
Worked in Tuning OS, Shared Pool, Buffer Cache, and Redo Log Buffer.
Performed Hot/Cold backups of the database through RMAN or User Managed method.
Reviewed alert logs and dump files to check for any problems related to the database.
Created and maintained users, roles and privileges.
Performed Space Management & Troubleshooting the database issues.
Created materialized views to refresh data at regular intervals.
Used materialized view logs to reduce the replication time costs for fast refreshes.
Upgraded/Migrated databases from 10g to 11g to 12c
Strict adherence to policies and procedures - specifically change management.
Perform database administration tasks as part of a scheduled change management task.
Work effectively with multiple teams at once.
Provide end-users with updates on their problems. Install server software.
EDUCATION:
Bachelor in Applied Science University of Cumberland
Contact this candidate