概要


SQL Server:



  • Experience in SQL Database Administration, System Analysis, Design, Development & Support of MS SQL Servers development environments.

  • Implementing SQL server security and object permissions like maintaining database authentication modes, Users creation, configuring permissions, and assigning roles.

  • Optimization of SQL Server, Stored Procedures, and SQL Scripts.

  • Develop procedures and scripts for continuous improvement, repeatable processes, and database maintenance.

  • Creating indexes on tables to improve the performance by eliminating the full table scans and views for hiding the actual tables and to eliminate the complexity of the large queries.

  • Coordinating with the front-end design team to provide them with the necessary stored procedures and SQL Scripts and the necessary insight into the data.

  • High Availability (HA) and Disaster Recovery (DR) options for SQL Server (Database Replication, Database Mirroring, Log Shipping)

  • Microsoft SQL Server Integration Services (SSIS)

  • SQL Server Reporting Services (SSRS)

  • Crystal Reporting.


MySQL:


Design and build new database structures, objects like Stored Procedures, Functions, Triggers, Scripts. Ability to perform backup and recovery. Database migration from MySQL to SQL Server and vice versa.


Oracle- PL/SQL



  • Create technical design for the backend PL/SQL based on business requirement documents and the funcitonal system design.

  • Create database objects like tables, views, stored procedures, and packages using Oracle tools like PL/SQL developer.

  • Create/Update procedures, functions, triggers, and packages based on the change request.

  • Use SQL Loader to load data from various sources into an Oracle database.

  • Write PL/SQL programs to retrieve data from data repository using cursors.


项目

SeekTuts
RESULT AUTOMATION SYSTEM

工作经历

公司标识
Operations Officer
National Institutional Facilitation Technologies (Pvt.) Ltd
Jan 2018 - 代表 | Lahore, Pakistan

Projects: Clearing and SNGPL

Install, upgrade and maintain the performance of the database servers
Allocating system storage and planning storage requirements for the database system and manage database access.
Designing and coding database tables to store the application data
Write queries and stored procedures as required by the developers.
Write triggers for task\'s auto completion.
Database security and login management.
Maintaining database backups, syncing, and database replication.
Support to Operational Computers

Supervisor-NIFT(June 2014 - Dec 2017)
Project: Result Automation System

Support in the database (SQL Server 2005)
Writing queries and database scripts and maintain the database and Backup.
Provide technical support to operational computers.
Supervise staff undertaking data entry, scanning, and other project activities.

公司标识
Teacher
Pride Public High School and Girls College
Mar 2010 - Mar 2013 | Lahore, Pakistan


学历

Virtual University of Pakistan
硕士, 科学硕士学位, Masters in Information Technology‎
Computer Software
CGPA 3.3/4
2017
University of Central Punjab (UCP)
硕士, 工商管理硕士学位, ‎
Accounting & Finance
2008
The Islamia university of bahawalpur
学士, BSc, ‎
Computer Science, Mathematic
2005
Board of Intermediate and Secondary Education Bahawalpur
中级/A级, , ‎
Computer, Mathematics, Physics
2003
Board of Intermediate and Secondary Education Bahawalpur
大学入学/0级, , ‎
Biology, Chemistry, Mathematics, Physics
2000

技能

熟练 .NET (C#, Entity Framework, ADO.Net )
中级 Bootstrap
熟练 CVs Screening
中级 HTML5, CSS3, Bootstrap4, JavaScript
熟练 Microsoft Excel
熟练 Microsoft SQL
熟练 MS SQL
熟练 MS SQL Server
熟练 MySQL
初学者 Oracle
中级 Oracle PL SQL Development
熟练 SQL Server(2000,2005,2008,2014,2016)
初学者 SSIS

语言

熟练 乌尔都语
中级 英语