AugmntX

AugmntX is the world’s largest network of pre-vetted talent.

Contact Info

305, IRIS Corporate Centre,
Hiranandani Meadows, 400610.
hello@augmntx.com
+919820045154

Follow Us

Home / Developers / AXF20717
profile image
Raza A AXF20717 Active
SQL Server DBA in Lahore Pakistan
I have 7 years experience of my work in MS SQL Database Developer/ Administrator, ETL /SSIS/SSRS developer and Support. Working as an individual as well as in teams enhanced my skill set. My job experience has helped me to groom my Team Management, Time Management, Problem Solving, Reporting, and Communications skills. The combination of my solid educational background and practical work experience makes me a superior candidate for this position.
Industries : Automation, Software and Platforms
Share
Hire Raza A
Download PDF
Availability
Full-time
Total experience
7 years
Technical skills
SQL MySQL
7 Years
Database development
7 Years
SQL
7 Years
SQL Server
7 Years
SQL Server Analysis Services
6 Years
SQL,Maps, SQL,Power BI
Projects
Qatar Drainage System
May-2023 to
Description
Monitoring database performance Check SQL Backups SQL Services are up and running
Roles and Responsibilities
Responsible for creating/updating SSIS packages according to user requirements.
Technologies: SQL,Maps
Industry: Automation
Point of Sale
January-2021 to April-2023
Description
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.
Roles and Responsibilities
Create new Microsoft SQL Server instances and configure them, including AlwaysOn availability groups and failover clustering
Technologies: SQL,Power BI
Industry: Software and Platforms
Work history
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
Soft skills
Communication
Problem-solving
Teamwork
Time management
Education
Bachelors degree in Database
The University of Lahore
2011 to 2015
Language
English - Intermediate