Experienced Data consultant with a demonstrated history of working in the information technology and services industry. Strong information technology professional skilled in Oracle Database Administration, MYSQL, MSSQL, Data Migration, Oracle Golden Gate ,SqlServer, Oracle EBS, Software Development Life Cycle (SDLC) and Amazon cloud . Handson experience with building database changes code pipeline with Jenkins , GitHub and Liquibase . Self learner and easy to cross skill for picking up new technologies .
-Successfully tested and deployed CICD pipeline which involved leveraging tools such as Jenkins,GitHub and Liquibase.
The solution was made Highly available and Highly resilient using ECS and autoscaling .
- Identifying and migrating application data from on-prem NDC to Aurora cloud using tools such as DMS, GoldenGate and SCT .
- Addressing application queries related to performance on cloud as well as on-prem .
- Successfully upgraded Oracle databases to latest version supported which involved resolving data dependencies and optimizing application response time.
- Successfully upgraded Oracle ERP application to latest supported version.
- Instrumental in complex analyses of Oracle cloud migration project which involved extracting critical system information across board , transforming into tables , views and finally loading the information into reports which could be presented to leadership for decision making process .
- Instrumental in managing and developing critical system information which acted as an observability tool . This was achieved by collecting data from SNOW , OEM , home-grown scripts etc merged into common platform of Apex tool for easy visibility and one stop solution for monitoring.
- Deep dive into cloud watch logs for Aurora and DMS for formulating logic for critical SNS alerts .
- R53 endpoint updating automation for Aurora DR strategy .This was achieved using lambda function.
- Complex query tuning by analyzing execution plans and implementing those to gain faster application results.
Aurora RDS