خلاصہ

An experienced IT professional with database & RED-HAT Linux skills across both Oracle and MS SQL SERVER. Having the ability to take the technical lead in projects and supporting technical implementation whilst working on multiple products.Currently working in a demanding production support environment managing large volumes of business critical data. A committed team player, self motivated with the ability to communicate at all levels.Presently looking for a suitable database administrator position with a responsible company.

پراجیکٹس

Demen care

تجربہ

کمپنی کا لوگو
Senior Database Engineer
Calrom Pakistan (Private) Limited
فروری ۲۰۲۰ - موجودہ | Lahore, Pakistan

Database engineer

کمپنی کا لوگو
Database Administrator
Ascertia (Pvt) Ltd.
مارچ ۲۰۱۹ - فروری ۲۰۲۰ | Lahore, Pakistan

Installation, configuration and upgrading of Microsoft SQL Server.Establish and maintain sound backup and recovery policies and procedures.Take care of the Database design and implementation.Implement and maintain database security (create and maintain users and roles, assign privileges).Database tuning and performance monitoring.Application tuning and performance monitoring.Setup and maintain documentation and standards.Plan growth and changes (capacity planning).Work as part of a team and provide 7×24 supports when required.Do general technical troubleshooting and give consultation to development team.Developed complex T-SQL code such as Stored Procedures, functions, Indexes and views for the application.Responsible for optimizing SQL queries, stored procedures to improve the performance time.Coordinated with the management to discuss business needs and designed database solutions accordingly.Running synchronization process between production, staging, testing and development environment using Red Gate.Reviewed, optimized, and tuned existing procedures and functions, ensured better performance; monitored server processes, backed up and restored database.Created and maintained hundreds of stored procedures to implement complex business logic.Excellent ability to develop and implement data and reporting solutions.Maintained SQL scripts indexes and complex queries for analysis and extraction.Ensured best practice application to maintain security and integrity of data.Administering data from multiple SQL Server databases.Able to work closely with application and web developers.Create Tables, Table Partitions, and Indexes.Organize and improve functionality of data.Experience writing complex SQL Queries and Procedures.Managed SQL Server Agent Jobs.Writing, updating and supporting reports using TSQL.

کمپنی کا لوگو
Database Administrator
Ascertia (Pvt) Ltd.
مارچ ۲۰۱۹ - فروری ۲۰۲۰ | Lahore, Pakistan

nstallation, configuration and upgrading of Oracle server software and related products
Evaluate Oracle features and Oracle related products
Establish and maintain sound backup and recovery policies and procedures
Take care of the Database design and implementation
Implement and maintain database security (create and maintain users and roles, assign privileges)
Perform database tuning and performance monitoring
Perform application tuning and performance monitoring
Setup and maintain documentation and standards
Plan growth and changes (capacity planning)
Perform general technical trouble shooting and give consultation to development teams
Interface with Oracle Corporation for technical support.
Patch Management and Version Control.

کمپنی کا لوگو
Database Administrator and Developer
Raaziq international Pvt Ltd.
دسمبر ۲۰۱٦ - مارچ ۲۰۱۹ | Lahore, Pakistan

Installation, configuration and upgrading of Microsoft SQL Server.
Establish and maintain sound backup and recovery policies and procedures.
Take care of the Database design and implementation.
Implement and maintain database security (create and maintain users and roles, assign privileges).
Database tuning and performance monitoring.
Application tuning and performance monitoring.
Setup and maintain documentation and standards.
Plan growth and changes (capacity planning).
Work as part of a team and provide 7×24 supports when required.
Do general technical troubleshooting and give consultation to development team.
Developed complex T-SQL code such as Stored Procedures, functions, Indexes and views for the application.
Responsible for optimizing SQL queries, stored procedures to improve the performance time.
Coordinated with the management to discuss business needs and designed database solutions accordingly.
Running synchronization process between production, staging, testing and development environment using Red Gate.
Reviewed, optimized, and tuned existing procedures and functions, ensured better performance; monitored server processes, backed up and restored database.
Created and maintained hundreds of stored procedures to implement complex business logic in the ERP system modules, such as Human Resource Management, Customer Relationship Management, Operation etc.
Excellent ability to develop and implement data and reporting solutions.
Maintained SQL scripts indexes and complex queries for analysis and extraction.
Ensured best practice application to maintain security and integrity of data.
Administering data from multiple SQL Server databases.
Able to work closely with application and web developers.
Create Tables, Table Partitions, and Indexes.
Organize and improve functionality of data.
Experience writing complex SQL Queries and Procedures.
Managed SQL Server Agent Jobs.
Writing, updating and supporting reports using TSQL.

کمپنی کا لوگو
Database Developer and Administrator
Raaziq Int. Pvt. Ltd
دسمبر ۲۰۱٦ - مارچ ۲۰۱۹ | Lahore, Pakistan

Analyze end user database needs and provide efficient solutions.
Designing and creating SQL Server tables.
Expertise in Transact-SQL (DDL, DML, DCL)and in Design and Normalization of the database tables.
Extensive Knowledge of advanced query concepts (e.g. group by, having clause, union so on).
Experienced hands inQuery tuning and performance tuning.
Experience in monitoringSQL Server Performance using SQL Profiler, Index Tuning Wizard and Windows Performance Monitor.
Experience in Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server Performance.
Good knowledge in Normalization and Denormalization the tables and maintaining Referential Integrity by using Primary and Foreign Keys.
Excellent analytical, communication and interpersonal skills. Proficient in technical writing and presentations and a good team player.
Rebuilding Indexes and Tables as part of Performance Tuning Exercise.
Worked on Documentation using MS word.
Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables and also optimized the procedures and triggers to be used in production.
Provided disaster recovery procedures and policies for backup and recovery of Databases.
Performance Tuning in SQL Server 2000 using SQL Profiler and Data Loading.

کمپنی کا لوگو
System Admin Tasks
Terminus Technologies Pvt Limited
اگست ۲۰۱٦ - نومبر ۲۰۱٦ | Lahore, Pakistan

Linux OS (RHEL, Ubuntu), Download & Install Software packages.
CLI than in GUI.
Managing users, local groups. (add, update)
File sharing. (rsync, secp,)
SSH Login and remotely access machines.
Basic commands (listing, cat, removing files/dir, vi editor, more, tail etc )
User Authentication (user add, remove, lock, unlock, home dir, ssh access)
Group Administration (group add, remove, )
Scripting (very basic)
Must be aware from all system configuration file and keep backup of it.

کمپنی کا لوگو
Database Administrator
Terminus Technologies Pvt Limited
اگست ۲۰۱٦ - نومبر ۲۰۱٦ | Lahore, Pakistan

Installation, configuration and upgrading of Oracle server software and related products
Evaluate Oracle features and Oracle related products
Establish and maintain sound backup and recovery policies and procedures
Take care of the Database design and implementation
Implement and maintain database security (create and maintain users and roles, assign privileges)
Perform database tuning and performance monitoring
Perform application tuning and performance monitoring
Setup and maintain documentation and standards
Plan growth and changes (capacity planning)
Perform general technical trouble shooting and give consultation to development teams
Interface with Oracle Corporation for technical support.
Patch Management and Version Control

کمپنی کا لوگو
MS SQL SERVER DBA
Terminus Technologies Pvt Limited
اگست ۲۰۱٦ - نومبر ۲۰۱٦ | Lahore, Pakistan

Installation, configuration and upgrading of Microsoft SQL Server.
Establish and maintain sound backup and recovery policies and procedures.
Take care of the Database design and implementation.
Implement and maintain database security (create and maintain users and roles, assign privileges).
Database tuning and performance monitoring.
Application tuning and performance monitoring.
Setup and maintain documentation and standards.
Plan growth and changes (capacity planning).
Work as part of a team and provide 7×24 supports when required.
Do general technical trouble shooting and give consultation to development team.

تعلیم

Lahore Leads University
بی سی ایس / بی ایس, Bachelors of Science in Computer Science‎
Computer Science, Computer Sciences and Information Technology, Database System
CGPA 2.9/4
2016
Crescent Group of Science Colleges.
انٹرمیڈیٹ / اے لیول, انٹرمیڈیٹ ان کمپیوٹر سائنس, ICS‎
Computer, Physics, Mathematics
فی صد 60%
2012
Allama Iqbal High School
میٹرک / او لیول, سائنس, ‎
Physics, Chemistry, Biology
فی صد 60%
2010

پیشہ ورانہ مہارتیں

متوسط Clustering
متوسط Concept Based Teaching
ماہر Database
متوسط Database Clustering
ماہر Database Design
متوسط Linux System
ماہر Microsoft SQL
ماہر MS SQL Server
ماہر My SQL
متوسط Official Assignments
متوسط OOP
متوسط Oracle
متوسط Oracle Database Administration
ماہر Query Language
متوسط Redhat Linux
متوسط REPLICATION
ابتدائی SSAS 2008
ابتدائی SSIS
ابتدائی SSRS
متوسط System Administration

زبانیں

ماہر انگریزی
ماہر پنجابی
ماہر اردو

آپ کن کمپنیز کی پیروی کر رہے ہیں

مزید دیکھیے