Oracle Database Disaster Recovery
Resume:
Gaurav
Seth
Cloud Engineer II
Contact
Address
Bangalore 560100
Phone
adxxyc@r.postjobfree.com
https://www.linkedin.com/in
/gaurav-seth-b48a7424/
Skills
Total 12 Years of experience
on Oracle Databases as
DBA
Advanced
Experience of MSSQLSERVER
databases
Intermediate
Experience of Postgresql
databases
Intermediate
Oracle Database Administrator and Engineer with experience of installing, maintaining, and upgrading various databases, creating backups and logs, simplifying administration process, implementing security checks, and generating reports. Providing support to oracle databases hosted on AWS cloud infrastructure. Working in 24x7 environment and troubleshooting the various database and application issues over the call and fixing them. Working on creating the ansible playbooks for building the automation to reduce human manual efforts. Also have the knowledge on MSsqlserver and Postgresql databases
Work History
2023-01 -
Current
Cloud Engineer II, Database Engineering
& Devops
Ellucian, Bangalore (India)
• Creating ansible playbooks using shell, Python
and Git
• Working on creating the CI/CD pipelines for the
ansible automation
• Working on NFS migration to EFS on AWS
• Working on Oracle database upgrades from 12c
to 19c using Jenkins CI/CD pipeline
• Working on the creation ECS cluster in AWS
• Working on migrating the apps from tomcat
container running on EC2 to ECS container
• Working on creating ECR images for the
applications to be deployed on ECS cluster
• Created an automation to provision and migrate
the data from old volume to the new volume and
integrated the results with Slack
• Created an automation to update the SMTP
information on Oracle databases & Applications
across all 140 customers using Slack
• Created an automation to apply the Quarterly
PSU patch on Oracle databases using slack.
2019-01 -
2023-01
Senior Cloud Application Administrator
Ellucian, Bangalore (India)
• Tuning the database & working on optimization
• Performing the environment cloning of Database
and APPS
• Performing the Oracle Database Upgrade to 12c,
18c and 19c
Experience on different
operating systems windows
and Linux
Advanced
Experience on AWS Cloud
and services such as EC2, S3,
CloudWatch, Load
Balancers (ELB & ALB), SG,
AWS Lambda, AWS RDS,
Route 53, Dynamo DB and
supported Oracle
databases on AWS.
Upper intermediate
Experience on CI/CD
pipelines and devops tools
such as Ansible, Jenkins,
Terraform, Shell scripting,
Python and Docker
containers on ECS cluster.
Upper intermediate
Experience on ERP Ellucian
Banner, WebLogic, and
tomcat. Handling all types of
issues at the application
layer
Upper intermediate
• Performing the disaster recovery in a case of
dataguard setup
• Doing the role-switchover between the primary
and standby databases including RAC and Non-
RAC databases
• Performing the new Dataguard setup
• Providing the APPS support for the front end
applications which are connected to the
database
• Like Middleware, Weblogic and Tomcat
applications
• Performing the quarterly PSU patching on Oracle
database as well as patching the WebLogic
Home middleware
• Performing Tomcat versions upgrade on app
server and fixing the issues related to tomcat
errors
• Also working on Java related issues identified in application logs
• Working on EC2 instances from AWS and have a
knowledge on AWS
• Taking snapshots of the database and server on
AWS console
• Working knowledge on load balancer
functionality in AWS console etc
• knowledge on Datadog and currently working on
performing the setup and doing the Synthetic
Test
• Have worked on shell scripting for the automation of some of the manual process
• Examples: Scan the logs for apps/database and
send notification, Mount point alert system
monitoring, Database availability, Monitor
blocking sessions etc
• Restore the databases from the SNPASHOT
backups
• Performed the clone of databases from available
SNAPSHOTS in AWS
• Working On Oracle 19c upgrade using the
Devops Pipeline
• Working on the Devops tools Ansible, Jenkins,
Terraform and Git
• Working on project of moving the tomcat
applications to docker on ECS cluster
2016-06 -
2019-01
Senior Software Engineer
Centurylink, Bangalore (India)
• Installation of Oracle Database on various
platforms Linux, UNIX, Solaris and Azure
• Cloning/Refreshing the databases (RMAN &
Manual Method)
• Databases backups and recovery using RMAN
and Export-IMPORT
• Performing the disaster recovery in a case of
dataguard setup
• Doing the role-switchover between the primary
and standby databases including RAC and Non-
RAC databases
• Tuning the database & Optimization
• Performance tuning of SQL Queries
• Performing the refresh of databases using rman
duplicate
• Analysis and recommendations on databases
health
• Performing migration and upgradation of the
databases
• Installation of Postgresql database
• Handling issues for Oracle Goldengate
• Working on SSL listeners configuration and Oracle Wallet
• Managing Oracle SAP databases using BRTOOLS.
2015-05 -
2015-10
Senior Systems Engineer
CGI Information Systems & Management
Consultants Pvt Ltd, Markham (Ontario) Canada
• During this timeframe I worked for Bell Media
• Below are the responsibilities1) Installation of Oracle Database on various platforms Linux, UNIX
and Solaris
• Installation of Grid agents and troubleshooting
and managing database through GRID
• Implementing database administration using
various tools like DBCA, EM, SQL
• PLUS
• Creating and managing tablespaces – grouping
tablespaces across disk for optimal I/O, resizing
tablespaces/datafiles, multiplexing of control files and redo log files to security
• Managing PFILE/SPFILE
• Configuring and managing different states and
modes of database like Archivelog & no
archivelog mode
• Managing and controlling user's accounts,
limiting privileges/access to database, granting
roles, profiles, monitoring user's activity, allocating users to resource consumer group
• Configuration of services, listener, naming
methods, dedicated and shared server mode
• Cloning/Refreshing the databases (RMAN &
Manual Method)
• Databases backups and recovery using RMAN
and Export-IMPORT
• Tuning the database for optimum performance
using AWR, dynamic performance views and
auto-diagnostic utility runs
• Tuning the database & Optimization
• Analysis and recommendations on databases
health
• Managing and rebuilding the Dataguards using
RMAN
• Configuration of RAC environment, adding new
node to RAC or Removing of node from RAC
environment
• Managing ASM, RAC databases including SAN
migration in RAC environment
• Performing the disaster recovery in a case of
dataguard setup
• Doing the role-switchover between the primary
and standby databases including RAC and Non-
RAC databases
• Performance tuning of SQL Queries
• Troubleshooting through hotline calls, 24/7
production support
• Having the knowledge of Oracle 12c (PDB and
CDB)
• Performing the refresh of databases using rman
duplicate.
2010-11 -
2016-06
Senior Systems Engineer
CGI Information Systems & Management
Consultants Pvt Ltd, Bangalore (India)
• Installation of Oracle Database on various
platforms Linux, UNIX and Solaris
• Installation of Grid agents and troubleshooting
and managing database through GRID
• Implementing database administration using
various tools like DBCA, EM, SQL
• PLUS
• Creating and managing tablespaces – grouping
tablespaces across disk for optimal I/O, resizing
tablespaces/datafiles, multiplexing of control files and redo log files to security
• Managing PFILE/SPFILE
• Configuring and managing different states and
modes of database like Archivelog & no
archivelog mode
• Managing and controlling user's accounts,
limiting privileges/access to database, granting
roles, profiles, monitoring user's activity, allocating users to resource consumer group
• Configuration of services, listener, naming
methods, dedicated and shared server mode
• Cloning/Refreshing the databases (RMAN &
Manual Method)
• Databases backups and recovery using RMAN
and Export-IMPORT
• Tuning the database for optimum performance
using AWR, dynamic performance views and
auto-diagnostic utility runs
• Tuning the database & Optimization
• Analysis and recommendations on databases
health
• Managing and rebuilding the Dataguards using
RMAN
• Configuration of RAC environment, adding new
node to RAC or Removing of node from RAC
environment
• Managing ASM, RAC databases including SAN
migration in RAC environment
• Performing the disaster recovery in a case of
dataguard setup
• Doing the role-switchover between the primary
and standby databases including RAC and Non-
RAC databases
• Performance tuning of SQL Queries
• Troubleshooting through hotline calls, 24/7
production support
• Having the knowledge of Oracle 12c (PDB and
CDB)
• Performing the refresh of databases using rman
duplicate.
Education
2006-05 -
2010-05
Computer Science Engineering
Punjab Technical University - Jalandhar
Accomplishments
APPLAUD- Celebrating CGI's Values 2015
Partnership and Quality
Centurylink Spot Award 2017
Received Spot Award from Centurylink for
changing the cloning method of the databases.
Which has reduced the overall time of cloning from 36 hours to 8 hours
Ellucian Rewards 2021
Received $100 amazon gift voucher from Cloud VP
on successful completion of Oracle 19c upgrade
using CI/CD pipeline for our first 2 customers and doing the code enhancement to fix the identified
bugs.
Certifications
2023-03 • AWS certified Solutions Architect Professional 2020-02 • AWS Certified Solutions Architect – Associate 2010-05 • Oracle Certified Professional 9i DBA
Canada Express Entry Profile Details
Express Entry Profile: E003305963
Created on: February 16, 2023
.
Contact this candidate