12C,10g & 9i certified professional (OCP).MongoDB Certified DBA Associate.AWS Certified Solution Architect.MySQL DBA OCP.Managing SQL & NoSQL databases & architecting solutions for 18 years in cloud and on premise. Expertise in Oracle 9i-19c RAC, ASM, DATA GUARD, GOLDEN GATE (Classic & Micro service), RMAN and PERFORMANCE TUNING.Zero downtime migration from Oracle (10+TB) to Aurora Postgres using tool like Oracle Golden Gate, Ora2pg & DMS (AWS).Zero downtime migration from MySQL (DC) to AWS RDS MySQL.Zero downtime migration from Mongo DB to AWS Document DB.Zero downtime database upgrade, Database migration & data center migration.Performance tuning of memory components, physical/logical database components, database objects and PLSQL & SQL statements.Designing High availability solutions using various tools & technologies.Oracle RMAN (Hot & cold) backup, Physical Standby, Oracle Golden Gate (classic & micro service architecture (MSA)) uni & bi-directional replication setup & management.Managing various AWS relational & non-relational databases offering.Database & User security Auditing and Data Encryption (TDE).MongoDB replica set & shard setup (HA setup) setup, rolling upgrade, backup & recovery & performance tuning (OS & Mongo configuration parameters).Logical & physical data model (ER diagram) for SQL & NOSQL databases.Build, implement and maintain data modeling patterns and schema design for SQL & NOSQL databases for optimal DB performance.Automating day to day task like backup, alerts notifications, DB patching, logfiles cleanup.Collaborating with product teams on design review, data modeling & related tasks.Collaborating with SRE,Data engineering, Data warehouse team on various tasks like data fetch, ingestion, data cleanup, performance.Working knowledge of Data Engineering & Big Data technologies & tools like Elastic Search, Logstash,Kibana,Zookeeper,Apache spark,Airflow & Kafka, S3 & Redshift.Good understanding of Docker, Kubernetes,AWS CloudFormation.Good understanding of AWS Data Analytics services offering.Working with external, internal auditors & security teams.SOP documentation, run book, design documentation.Managing project delivery timelines.Team building & mentoring.Experience with scripting (Python,Shell) languages.
Listed skills include Oracle Rac, Performance Tuning, Oracle, Pl/Sql, and 46 others.