J & S Management Consultancy Services Pvt Ltd jobs - Cloud DBA

1) Design & Deployment of Database:- ( ask what categories as below candidate worked)

There are three categories of database deployments in OCI:

·       Autonomous database: Shared/Serverless or Dedicated

·       User-Managed (PaaS: DBCS/ DBaaS): VM DB, BM DB, Exadata on Cloud, Exadata Cloud at Customer

·       Database on Compute (IaaS: Unmanaged)

·       High Availability (HA) & Disaster Recovery (DR) like RAC & Data Guard

2) Provision Database On Cloud

Once you have done the designing part then next will come is Provisioning of Database.In order to provision the database, you should have the knowledge of the pre-requisites depending upon whether you are setting up an Autonomous Database, User-Managed Database or you are simply deploying a Database on Compute.You should be familiar with Pre-requisites like Network Setup connectivity (VCN, Subent, Security rules)

3) Connectivity to Cloud

The third thing you should know about is how to connect to database.

·       There are three ways to connect from the On-premise to the Oracle Cloud, a) using Public IP (for testing only not a recommended approach) b) IPSec VPN connect c) Fast connect.Oracle Cloud: Security Rules To allow/block incoming & outgoing connections, A security list provides a virtual firewall for an instance, with ingress and egress rules that specify the types of traffic allowed in and out. To know more about Security Rules

4) Administration

Then the other responsibilities of DBAs are Administration. It is the main functionality, so you will be looking for things like:

·       Performance Tuning (Using the Performance Hub or Service Console for Autonomous DB), to know more Performance Tuning click here https://k21academy.com/tuning13

·       Scaling up & Scaling down of the services (CPU, disk space or memory)

·       Cloning

·       Access controls, and resetting the passwords.

Other tasks are maybe adding the SSH keys or terminating the Database, start and stop the databases.

5) Patching In Cloud

The 6 things you should know about Patching.

·       Database Patching

·       Grid Infrastructure patching

·       Cloud tooling patching

·       Operating systems patches

·       Rollback a patch

You have to apply patches to the User-Managed Databases i.e VM DB, BM DB, and Exadata Cloud Service.

6) Backup & Restore

The Sixth task will be Backup & Restore.

Oracle provides you all the necessary tools to back up the databases on the cloud but you have to configure the backup scenarios. Backup methods like schedules backup or on time backup will be configured you still have to do the Back-up and Recovery using new tools. To take database backup we use a different type of Cloud Tools which includes  OCI Console, APIs, RMAN, dbcli, bkup_api.

7) Security

In my view, Security is the most important thing apart from Lift & Shift

All the cloud vendors work on a shared security model in which some of the responsibility lies to the Cloud vendor and some to the customer.

8) Migration (Lift & Shift) 

Once the security is done then you will be doing migration Lift & shift

In this task, you will be migrating your databases from on-premise to the cloud. Oracle provides you a lot of migration options like ZDM( Zero Downtime),MV2ADB (move to ADB),SQL Developer, Data-Pump, RMAN, Plug-Unplug, etc.