Umer Hamid Email and Phone Number

Motivated fast learner and seeker with good analytical and technical skills along with coordination, team planning, and leadership.Expertise in writing T-SQL, PL/pgsql queries, SnowSQL, Dynamic queries, sub-queries, and complex joins for generating complex stored Procedures, Triggers, User-defined functions, Views, and Cursors.Expertise in using global variables, parameters, and expressions for the project with immense experience in handling packages in SSIS.Expertise in creating PowerShell and bash scripts for building automation tasks such as Project build and deployment, revert/restore, and auto-pull changes from GitLab.Worked as a senior Postgres DBA and handled various duties of the administration part of the remote service group, providing support to consulting clients for various projects for ongoing issues in development, testing, and staging environment including database upgrades, application patches, and DR activities.Expertise in building ETL pipelines and data archiving through Rivery, DMS, and manual staging in Snowflake, S3, and other targets.Familiar with Linux, Unix, and Windows environments, can easily handle applications and tools via cmd/terminal or other CLI, always prefer CLI over UI. Done some web projects including 3D object manipulating, labeling, and showcasing for a manufacturing company where the whole project is based on the THREE.js library while the other one is a car rental application. Done a project of Database Migration Oracle to Postgres, which included backup strategy, HA, logs auditing, integrating with system application, and building a connection between two databases through FDW.Experience with Data warehousing, Data Mart, and analytical concepts and techniques, provided solutions with the BIG Data technology tools such as Hadoop, Druid and MR3, Apache Superset, and Click.