A B D U L H A M E E D K.

A B D U L H A M E E D K.

Technology Specialist

Chennai , India

Experience: 17 Years

A B D U L H A M E E D

Chennai , India

Technology Specialist

38400 USD / Year

  • Immediate: Available

17 Years

Now you can Instantly Chat with A B D U L H A M E E D!

About Me

As an Oracle developer, gained 10+ Years of Rich Experience on ORACLE Database and 4+ years conversion from oracle to PostgreSQL. Creating Data migration project plans from Oracle to PostgreSQL db. Hands on experience on Oracle to SQL Server and Post...

Show More

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.

Show More Show Less

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.

Show More Show Less

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.

Show More Show Less

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