Database Design & Implementation

 Primarily accountable for identifying the appropriate database architecture based on business requirements

 Partnered with teams to develop methods of synchronizing data flow from multiple up streams and down streams

 Ensured effective optimization of the Database usage

 Coordinated with Engineers and Business Analysts for understanding the requirement and recommended solutions accordingly

 Oracle Database upgrade from 11g to 12c

 Conducted feasibility study for migrating from SQL to No-SQL Database solutions

 Evaluated system performance and validated NoSQL solutions

 Optimized the existing jobs, and archival strategies to optimize the performance

 Concept to implementation of Business logic using SQL, PL/SQL for Oracle 12c, 11g

 Achieved Time, and memory Optimization of SQL PL/SQL tuning, addressing the SQL performance issues on the key business tasks and transactions

 Evaluated, monitored, troubleshot, and implemented tuning strategies, methodologies, and techniques to improve and maintained the production databases