Sirisha Bachina

Around 10 years of experience in the Information Technology of various fields like healthcare, utility, and Telecom as an DBA(Oracle/PostgreSQL/Cassandra/Cosmos DB /Couchbase) on large scale databases supporting high volume transactions. Over 5 years of experience as Goldengate DBA. Over 4 years of experience as a cloud DBA supporting PostgreSQL, Cassandra, Cosmos DB, Couchbase on Azure Cloud. Migrated oracle Databases to Oracle/Azure Cloud using export and import data process. Migrated lot of on-prem oracle databases to PostgreSQL on Azure Cloud. Migrated oracle database from Solaris to Linux using expdp/impdp and Goldengate replication with zero downtime. Setup monitoring and backup configuration for PostgreSQL database on Azure cloud. Monitoring Cassandra database using Grafana Dashboards. Automated Goldengate monitoring setup using bash scripts. Configured and supported Unidirectional Oracle Golden Gate Replication between oracle databases. Good knowledge on implementing Oracle Golden Gate and Oracle Data guard. Installing & Configuring Oracle Golden Gate 12c using Integrated Extracts & Replicats. Troubleshooting issue with Replication across sites and Performance Tuning on Oracle Golden Gate. Created Cosmos databases and containers and supported various deployments on Azure Cloud. Created and Administered 12C/18C Container with pluggable database. Performing Backups, Cloning using RMAN for Oracle Databases. Adding additional instances on RAC databases without downtime. Expertise in Logical and Physical Backup schedules using Import/Export, Data Pump and RMAN. Experience in Oracle database Performance Tuning using AWR, ADDM, Explain Plan, SQL TRACE, TKPROF, SQLTXPLAIN and different OEM utilities. Good Knowledge in creating PL/SQL Procedures, Functions, Packages, Views, Materialized Views and Triggers. Worked with developers to troubleshoot performance issue (SQL Queries) using AWR, ADDM, ASH and SQL Tuning Advisor. Responsible working with user groups, analyzing reported problems, performing root cause analysis and presenting alternatives to correct the problem. Created Cursors, Collections and database triggers for maintaining integrity constraints and implementing the business rules. Involved in scheduling batch jobs using Unix/DBMS scheduler. Performed code deployment activities and sanity check across DEV, UAT, ST & PROD environments. Good knowledge in writing shell scripts for monitoring database and perform backups. Coordinate with application team and stake holders to gather requirements, design, data conversions, programming, System/integration/user acceptance testing, documentation, production support in PostgreSQL/Cassandra/Cosmos DB /Couchbase migrations.

Oracle certified Associate