To enhance and explore my abilities of working in an IT industry by having a position
where I can learn some new technologies and make a better career and become a valuable
asset for my company.
EDUCATION
Master in Software Engineering 2013
PAF-Karachi Institute of Economics Technology.
Software Engineering (B.S.S.E.) 2012
University Of Karachi.
Higher School Certificate (H.S.C.) 2006
Govt. College For men.
Karachi, Pakistan.
Senior Secondary Certificate (S.S.C.) 2004
Crown Public School.
Karachi, Pakistan.
CERTIFICATIONS
Microsoft SQL Server 2008 R2
Microsoft SQL Server 2008, Implementation and Maintenance. (70-432)
Microsoft SQL Server 2008 R2
Microsoft SQL Server 2008, Database Development. (70-433)
CERTIFICATIONS (Preparing for Exams)
Oracle 9i (Database)
Introduction to Oracle9i SQL
Oracle 10g (Database)
Administration - I
Current Job
Associate DBA developer (March2012 Present)
Omex Systems
Core Responsibilities
Maintaining SQL Server Database.
High Availability of database for all 24/7.
Providing assistance to heads regarding the execution of Volumes, Transaction
There Rates.
Providing them all required supports.
Creating different logics with help of BIDS with respect conditions.
Working on the optimization of SQL Server database using different tools.
Creating SPs and Function on requirement.
Using and having complete knowledge of SSRS, SSAS, SSMO.
Keeping myself updated for the new and latest technology provided by Microsoft.
Creating SSRS and reporting server for all the production and testing database and improvising the performance of servers.
Maintaining traces and evaluating the issues.
License and upgrading of Microsoft SQL Server.
Timely database refactoring.
Major Achievements Omex Systems
As a team we have achieved many great goals with a very short period. As follows
Optimized our database to make the execution faster and make retrieval of data easy for user so no execution can get miss.
Migrated database from Microsoft 2005 to Microsoft 2008 R2.
Replication made for load balancing.
Maintenance plans, Disaster Recovery plans and Reporting maintained on daily, monthly and quarterly basis.
Created memchached servers for improvising data retrieval.
Migrated from Microsoft SQL Server 2005 to SQL Server 2012.
System Support and Database Administrator. (Jan 2011-Nov2011)
United Mobile Pvt. (Ltd), Karachi.
Core Responsibilities
Maintaining and synchronization of information in all across the service center of
United Mobile.
Creating all the maintenance plan of the 30 servers of United Mobile.
Resorting databases from every state.
Scheduling DTS and manually executing them daily and on required time.
Supporting and assisting WIMS and other application running at United Mobile.
Keeping myself alert for all the future updates going around regarding application development.
Providing the user all the facility what they required and can give them ease in the execution of WIMS.
Making myself available for 24/7.
Always ensure on the high availability of the database and synchronization around the centers and the head office.
Ensuring to make such policy where the officials dont suffer from the unavailability of the records on time.
Migrating SQL Server 2000 database to SQL Server 2008 R2.
Troubleshooting regarding the errors and the bugs.
DATABASE ADMINISTRATOR SKILLS
Installation of Oracle 9i, 10g on Windows XP, Windows Vista.
Creating database by Oracle Enterprise manager, MS-SQL Server.
Creating and managing table spaces by Enterprise manager and by query.
Managing SQL Server and Oracle instance in all 4 modes of instance.
User accounts and authentications.
Granting revoking privileges to users.
Grip on DML DDL commands.
Oracle and SQL Server database security.
Listener testing, connectivity, SQL Server Services naming methods.
Management and maintain database.
Optimizing and rebuilding of indexes when for making execution faster.
Recovery and Restoring database from database and log files.
Generating script, Import/Export Scheduling and Data Transformation Service.
Operating Services of SQL Server 2000/2005/2008.
Creating Data transformation services and packages from any format of file to SQL Server format through BIDS.
Data Transformation from any extension in to SQL and requested form.
PERSONAL PROFILE
Present location Karachi
Date of Birth 15 Aug 1988
Marital Status Single
Nationality Pakistani
Working as a Database Consultant for Cayenta ERP a subdivision of Harris Computers Canada.Core Responsibilities:▪ Managing Oracle, MSSQL, and Microsoft Azure Databases for the clients.▪ MSSQL clustering setup and troubleshooting.▪ Database Licensing.▪ Implementation of SpiceWorks on client distributed system.▪ Automating DB process using PowerShell/ bash/TSQL and PLSQL.