Umer Hamid Email & Phone Number

Giza, Giza, Eg

Expert in analyzing, designing, developing, installing, configuring and deploying MS SQL suit of products with Business Intelligence in SQL Server Integration Service.Automate the build and deploying process of SSIS and Database Projects through powershell script, and maintain CI/CD pipeline on gitlab.Expertise in writing T-SQL queries, Dynamic queries, sub queries and complex joins for generating complex stored Procedures, Triggers, User defined functions, Views and Cursors.Proficient in assessing data situations and collaborating with cross-functional teams to design a data warehousing system to meet business needs.Expertise in using global variables, parameters and expressions for the project with immense experience in handling packages in SSIS.Wrote and coded logical and physical database descriptions and specified identifiers of database to management systems.

Somerset, Nj, Us

Working as a senior Postgres DBA and handling various duties of the administration and Engineering 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 upgrade, application patches, and DR activities.Maintaining documentation on ongoing tasks of integration, installation, and configuration of the database with other third-party sources, mentioning each and every step, and preparing reports which define rich details of new source integration.Upgrading and migrating various versions of Postgres databases on different platforms. Managing the monitoring tools for better performance like KIBANA, GRIFANA, and New Relic for tracing the system logs, database logs, and database alert files to detect and troubleshoot runtime problems.Ensure night cron jobs for backup, re-indexing, vacuuming, Archiving and materializing views are executed properly on 24/7 high-availability Postgres production and development databases.Migrating and Archiving data from various sources through DMS, Rivery, and manual data staging in Snowflake, S3, and other target sources.Building Data warehouse and data mart in Snowflake and allowing data access for analysis and reporting as per client request.

Karachi, Sindh, Pk

Joined as an Internee with a strong knowledge and practice of Big Data and Hadoop technologies through hands-on classroom activities and case studies.Got a task to prepare large sets of data for further processing using the following technologies, Java, JDBC, Hadoop, Map Reduce, Sqoop and Hive.Acquired experience with Project Management (Agile, Scrum) and Software development life cycle.Projects and Achievements1. Got an opportunity to be a part of Data Analysis Project in Hilal Foods pvt. Ltd. Where goal is to provide insights of 20-year raw financial data. Learned large data sets batch processing with Spark and Druid where normal data tool could not stand.2. Assigned a project of Database Migration from Oracle to PostgreSQL in NCCPL, where we provided 80% to 90% accuracy of data and database objects. Learned lot of tools and methods during this project. Acquire a title of PostgreSQL DBA after successfully completed the project.3. Had a chance to work with Web development team, Learn Python, JavaScript, jQuery and REST API’s while working on Django backend and DOM manipulation, provided full support in the development of Hydd Project, created back office, and Web front end while manage other project of 3D object manipulation of Lindaal Corp. Got an appreciation to complete two web application from scratch and secured a title of Django/Python Developer.

Bachelor Of Science - Bs, Computer Science

Hsc, Pre-Engineering