• 10+ Years of Rich Experience on ORACLE Database and 6+ years on Data migration / Conversion from oracle to PostgreSQL (Open Source, AWS), Mongo DB and Cassandra (NOSQL) databases.
• Administering on-prem and AWS PostgreSQL RDS databases.
• Migrating Data from Oracle to PostgreSQL using Ora2PG and AWS SCT & DMS.
• Creating Data migration project plans from Oracle to open source, NO SQL databases.
• Hands on experience on Oracle to SQL Server, Postgressql, Mongo DB and Cassandra conversion.
• Hands on experience on converting products from costly relational databases to open source and NOSQL databases.
• Hands on experience on installing Oracle, Sybase, SQL Server, Postgresql, Mongo DB and Cassandra on Linux/Windows Environments.
• Having strong programming skills writing stored procedures, functions, triggers and packages in Oracle (PL-SQL) and PostgreSQL. Hands on experience on writing complex views and Materialized views.
• Maintaining DB scripts for releases.
• Handling L3 production support issues. Troubleshooting and fixing L3 production support issues.
• Hands on Data uploading using SQL Loader, Pg_Dumps.
• Hands on experiences on tuning the long running SQLs and bottleneck queries to gain effective performance under critical situations by well-known tactics.
• Know-how to construct the SQLs to work effectively on huge databases that contains as large as TB of data.
• Leading / mentoring team of senior software engineers in ODC and interacting with US client operations.
• Upgrading databases.
• Writing scripts to resolve client reported issues.
• Providing support to client production databases around 24X7.
• Hands on experience on developing forms and reports
• Visiting Onsite to train the customer, UAT support and Project Go-Live.

• Part of Database Development team as Lead.
• Requirement Gathering, writing Technical Design Documents, taking customer calls for clarifications/design changes.
• Interacting with Onsite development team.
• Complete ownership of the project delivery.
• Handling reported L3 Production support issues.
• Trouble shooting Production support issues and fixing.
• Database design, provide solutions to application developers
• Writing SQLs, PL-SQL (triggers, stored procedures, packages, functions) for the product.
• Complete ownership of Scripts.
• Converting Oracle code objects to Postgres after every product main release.
• Update data model and generate HTML reports up-to-date.

• Part of product development database team as Lead.
• Update, maintain data model.
• Database design, provide solutions to application developers
• Write database tools and data modeling.
• Writing SQLs, PL-SQL (triggers, stored procedures, packages, functions) for the product.
• Trouble shooting client reported issues and fixing them.
• Complete ownership of Scripts.
• Upgrading client databases.
• Converting Oracle code objects to Postgres after every product main release.
• Update data model and generate HTML reports up-to-date.

• Leading/Mentoring PL-SQL team.
• Writing SQLs, PL-SQL (triggers, stored procedures, packages, functions) for the product.
• Involved in complete SDLC of product development.
• Troubleshooting Client reported defects.
• Complete owner for Database upgrade scripts of maintenance releases and letter releases.
• Tuning SQLs in application / Crystal reports for better performance.
• Resolving performance issues arising due to substantial growth of customer’s table’s size.
• Providing support to Client Operations on interface developments.
• Involved in Oracle to SQL Server conversion and converted Oracle packages, procedures, functions and SQLs to SQL Server (T-SQL).

Certified ISO auditor and internal auditor.