概要

Experienced Database Developer with a strong background in designing, developing, and optimizing database systems to support complex applications. Proficient in SQL, PL/SQL, and various DBMS platforms including Oracle, PostgreSQL, and MySQL. Expertise in data modeling, ETL processes, and performance tuning. Adept at creating stored procedures, functions, and triggers to streamline data processing and improve system efficiency. Skilled in collaborating with cross-functional teams to deliver robust, scalable database solutions that meet business requirements. Committed to ensuring data integrity, security, and high availability.

项目

CRM for Complaint Management
C# Inventory Management Application
Database and ETL Devlopment at ASIACELL (IRAQ)

工作经历

公司标识
Database Administrator
SiParadigm PVT Limited
Jul 2022 - 代表 | Islamabad, Pakistan


Install, configure, and upgrade database management systems (DBMS)
Continuously monitor database performance, identifying bottlenecks, optimizing queries, and tuning the database for efficiency.
Implement and maintain backup and recovery strategies, ensuring data integrity and restoring data in case of failure or corruption.
Manage database access by setting up user roles, permissions, and profiles to ensure data security and integrity.
Assist in designing and developing databases based on application needs, ensuring proper data modeling and schema design.
Oversee data migration between different systems and ensure data transformation processes work correctly.
Perform routine maintenance tasks like indexing, partitioning, and purging to ensure databases function optimally.
Work closely with developers to optimize database queries and ensure that database changes align with application requirements.
Set up high availability solutions like clustering and replication to ensure minimal downtime, and implement disaster recovery plans.

公司标识
Data Analyst
High Tech Innovations
Apr 2021 - Jun 2022 | Rawalpindi, Pakistan



Created database objects (tables, views, triggers, stored procedures, reuseable functions) for C# applications.
Developed complex SQL queries and datasets for data visualization tools (Microsoft Power BI, Bright Gauge).
Managed backups and Always On High Availability group policies.
Controlled user profiles and access levels for data security.
Assisted with schema design, code reviews, and query optimization.
Built SSIS packages for data import from CSV files.
Developed Power BI, Bright Gauge, and Crystal reports for dashboards.
Conducted research and presented findings from multiple data sources.

公司标识
Database Officer
IBECHS Gulberg Islamabad
Nov 2019 - Feb 2022 | Islamabad, Pakistan


Designed and implemented database models, identifying and resolving issues.
Managed user profiles and access control to secure data.
Coordinated with project teams on database timelines and scope.
Administered and monitored databases, resolving issues proactively and maintaining servers.
Documented technical and functional specifications.
Installed, upgraded, and tuned databases in Windows environments.
Built database structures following CRM architecture for web applications.
Handled customer queries within SLA and evaluated database health daily.

公司标识
Network Support and Data Analytics Specialist
Aircom International Pakistan (Pvt.) Ltd.
Jan 2016 - Jun 2019 | Islamabad, Pakistan

Delivery:

Deployed OPTIMA OSS, ensuring smooth project delivery and acceptance.
Installed Oracle Databases and integrated Optima ETL with multi-vendor platforms.
Implemented KPIs, reports, and alarms; harmonized KPIs across the network.
Delivered Proof of Concept in collaboration with sales/pre-sales teams.

Support:

Provided technical support, resolving issues within SLA.
Monitored mediation, database health, and ETL processes, ensuring data quality.
Managed customer requests and delivered permanent solutions for logged issues.

学历

Air University
学士, , BEE‎
Electronics
CGPA 3.0/4
2015
Air University
学士, 商学士/理学士, ( Bsc ) Electrical Engineering‎
Electrical Engineering Electronics
CGPA 2.2/4
2015

技能

中级 Data Analytics
中级 Database Modeling
中级 Database Replication
熟练 Database Tools
中级 Mirth Connect
熟练 MS SQL Server
熟练 MySQL
中级 Oracle
中级 Oracle Database Development
中级 PL and SQL
中级 PL/SQL
中级 PostgreSQL
中级 Power BI
中级 Python Framework Command
熟练 SQL

语言

熟练 乌尔都语
中级 英语