About Me
Database Architect with 10+ Years of Rich Experience on ORACLE Database and 5+ years on Data migration and Conversion from oracle to PostgreSQL (Open Source, AWS, RDS), Mongo DB and Cassandra (NOSQL) databases.
... Show MoreSkills
Database
Others
Software Engineering
Web Development
Programming Language
Portfolio Projects
Company
Database Conversion and Database Migration from Oracle to Postgresql
Description
- 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.
Company
Oracle to MogoDB Migration
Role
Project Manager (Team Lead)
Description
- 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.
Show More Show Less
Skills
Oracle 11g MongoDBCompany
Database Lead Developer
Role
Project Manager (Team Lead)
Description
- 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.
Skills
Oracle 11g PostgreSQLTools
PGADMIN PLSQL DeveloperCompany
Senior Technical Lead
Description
- 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.
Show More Show LessTools
PLSQL Developer