Now you can Instantly Chat with Abdul hameed!
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
Positions
Portfolio Projects
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.
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.
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.
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 Less