Senior Software Engineer (Database) • May-2023
Description: Monitoring database performance • Check SQL Backups, SQL Services are up and running • Maintains all Databases (Production & UAT) required for development, testing, and production usage. • Manage all Database and keep them 24/7 in running state • Identification and resolution of any issue in the Database. • Deploy DB updates on Production and UAT machines. • Database health check and performance proactively to ensure high levels of Performance, availability, and security. • Create new Microsoft SQL Server instances and configure them, including AlwaysOn availability groups and failover clustering • Maintaining archived data • Enrolling users and maintaining system security including Roles and Permissions. • Responsible for creating/updating SSIS packages according to user requirements.
Data Analyst • June-2021 to April-2023
Systems Limited
Description: To make sure successfully execution of ETL (Extract, Transform, Load) process, in order to facilitate user, which help achieving organization goals. Develop new BI report and change in existing report in order to facilitate user. • Provide access power BI reports to new user and update or delete old user as per requirements. • Perform data back-up and archival on regular basis. • Developed Stores procedures and Functions Generate script and schema of database Develop scripts for data migrations from different data sources. • Responsible for all ETL jobs to be completed on time and successfully. • Responsible for creating / updating SSIS packages according to user requirements. • Worked on Alteryx ETL for data comparison • Create & rebuild index. Query Optimization for batter performance.
Database Developer • November-2018 to January-2021
Sixlogics Pakistan
Description: • Involved in designing, developing and deploying SSIS Packages in MS SQL Server environment using SSIS in Business Intelligence Development Studio (BIDT). • Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse. • Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc. • Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases. • Developed SSIS Packages for migrating data from Staging Area, XML and text files and insert into data warehouse. I have knowledge of different ETL tools like SSIS and Data stage. • SQL Server Integration services Packages design and implementation for the import files and manipulation of data.
Officer-ETL/BI Support • November-2016 to October-2018
Adamjee Insurance Company Limited
Description: To make sure successfully execution of Data Stage ETL (Extract, Transform, Load) process, in order to facilitate user, which help achieving organization goals. Key Accountabilities:- • Create new ETL packages for data sync • Responsible for ETL jobs monitoring • Responsible for documentation in existing ETL packages, mapping and workflows in production. • Create reports in Cognos BI • Design and modified databases for different applications • 7/24 on-call support for production systems