Vaishali Patil

SENIOR SYSTEM ENGINEER

NATWEST•  November 2022 - Present•  PUNE, INDIA

Analyzing the objects and data from source on-prem database. Creating and managing the database schemas, table spaces and objects for AWS RDS cloud database. Migrate the data from on-prem Oracle database to cloud AWS Oracle RDS database using the AWS DMS Service. Performing the unit testing to ensure migrated data and SQL objects are similar as the source. Load the data from on-prem database to cloud AWS RDS DB using Informatica and scheduling the jobs through Autosys. Working with Oracle SQL Developer tool, to create and manage the objects and schemas in AWS RDS cloud DB. Worked on the JIL script used to schedule the Infra job on the Autosys. Understood the requirements and met deadlines without compromising quality & adhering to SLA.

SYSTEM ENGINEER

PMX- CLOSE BROTHERS GROUP•  November 2021 - October 2022

Worked as a PL-SQL Developer and her role is to create and execute stored procedures to achieve the solution. Understands the business requirement and develop the solution accordingly. Managing the database like creating and altering tables, applying constraints and indexes, etc. Working with Oracle SQL Developer tool, to develop stored procedures for inserting, updating or retrieving and managing data. Implemented error handling and managed exceptions during development. Working with JIRA Tool for tracking JIRA ticket. Performing unit testing to ensure the quality delivery. Creating / Building packages using TeamCity and deployed it on Octopus Deploy Tool. Resolve all incidents, service requests, within SLA targets.