Database Architect

Managing Database access Security Checks Assessment create and maintain users' login and roles assign privileges Password Management etc

Managing Database backups and restores including restores from Snapshots.

Database Build Installation configuration OEM Service now tickets Idera New Relic Sumo

Logic Emails

Starting and stopping database services.

Managing database related storage issues space management.

Creation of Database Configuration Items in Service now and maintaining inventory

Central Inventory Management

CPU Utilization, Long running query, Apply latest patches to database servers

Ensure best practice security standards are applied to database servers

Database Refresh restores and cloning from Prod to nonprod

Database performance tuning

Follow best practice methods to commission and decommission database server

Ensure database changes are applied with best practices and tested in lower environments

prior to prod deployment, Script execution deployment

Basic HADRRAC Cluster Data guard Replication Administration

Manage RDS Instances across different environments including rightsizing

Monitoring Tool User Setup

Leverage Terraform State management capabilities to track changes and maintain the

desired state for RDS sources

Monitor Terraform execution logs and plan outputs to troubleshoot provisioning issues and

ensure RDS instances are provisioned as expected

Snowflake Troubleshooting Table locking issue

Snowflake SSL certificate deployment

PostgreSQL Kerberos user Management, PostgreSQL Database Vacuum

MySQL Objects partition LOB, Materialized view log maintenance

MongoDB SSRS Key storage locations, MongoDB Transparent Data Encryption TDE

MongoDB Row Level Encryption, MongoDB Logs compression

MSSQL SSIS Package deployment Migration

MSSQL SSRS Migration Update data source Migrate deploy reports etc

MSSQL IP Whitelisting on MSSQL RDS instances

Oracle OEM configuration Maintenance and enable Monitoring

Oracle OMS version Migration and Upgradation

Oracle Data guard Setup and DGMGRL configuration

Oracle Installing Oracle server and client software

Oracle Terraform Version and AWS version updates on all git hub repository

Oracle Refresh RDS instance Point Intime using Snapshots

Oracle RAC Build activities Grid Oracle Installation and cluster database creation

Oracle Option Group Management on AWS Cloud

Oracle Time zone Upgrade activities via OG in Terraform

Mandatory Skills :

Mongo DBA, MySQL DBA, Redis DBA, Sybase DBA, Azure Database Service, AWS Database Service, GoldenGate-DB Administration, PostgreSQL-DB Administration, Cassandra DBA, Oracle DB Administration, MS SQL DB Administration, GCP Database Services, Couch DBA, DB2-LUW DB Administration, MariaDB, Maria DBA