Senior Cloud & Oracle DBA with DevOps Experience
Resume:
Gaurav Seth
Senior Cloud
Engineer
Contact
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
Address
Bangalore 560100
Phone
***********@*****.***
https://www.linkedin.com/in
/gaurav-seth-b48a7424/
Skills
Total 13 Years of experience on
Oracle Databases as DBA
Advanced
Experience of MSSQLSERVER
databases
Intermediate
Experience of Postgresql
databases
Intermediate
2023-01 -
Current
2019-01 -
2023-01
Senior Cloud Engineer, 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.
• Created an automation pipeline to migrate the
applications running on Tomcat containers from RHEL6 Ec2 to RHEL8 Ec2 servers.
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 & 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
2015-05 -
2015-10
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.
Senior Systems Engineer
CGI Information Systems & Management Consultants Pvt
• 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
2010-11 -
2016-06
• 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.
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
.
Contact this candidate