Job Description :
Management Qualities: Should be able to effectively communicate with customer and cognizant folks, mainly higher mgt, QA/Dev/SE/SA/Network leads Co-ordinate preparation of Weekly and Monthly reports Keep track of SLA's and KPI's Technical Skills: DBA with following skills : Knowledge of RAC, ASM, GoldenGate, DG, ADG, RMAN. Installation of database, configuration of databases, tuning sql, performance tuning of Databases, setup clustering, troubleshooting database issues. GoldenGate Replication. Setting database backups. Troubleshooting database and application performance issues. Restoring database backups. Setting up clusters, setting up database failover and DR. Support multiple environments like dev, qa, stage, beta, prod, archive, DR, HA. Setting up monitoring. Support DR Drill. Provide on call support as per rotation cycle. Review database scripts (ddl, dml, dcl & database code Write shell/aw scripts. Write DB scripts. Refresh data in lower environments on need basis. Setup database encryption, masking on need basis. Provide support for incidents and create RCA GCP Skills: Analyze Data Types between source and chosen target Recommend storage type from : local ssd, persistent ssd, Std persistent disks, Cloud storage buckets, ssd Recommend bucket storage classes from regional, multi regional, nearline & coldline Exporting data, backing up data Setup database, instance, schema objects in GCP DB Comparing schema between source and target Import/Load data in GCP DB Comparing Data between source and target Troubleshoot data migration issues SQL and performance tuning on GCP databases Setup DB maintenance jobs on GCP databases Setup HA on GCP databases Setup monitoring on GCP databases Setup encryption on GCP databases if needed Setup database security on GCP databases