Experience                                                                                                12/2009-TO DATE
DBA, Pakistan Revenue Automation (Pvt) Limited (PRAL), FBR House Islamabad Pakistan
• Installation of Oracle Database/MS SQL Database on Linux, Windows
• Creating users, Roles, profiles and assigning the necessary privileges, roles, profiles to the users.
 • Installation of SQL Server Software and Related Products.
• Designing of database.
• Writing of stored procedures, functions, triggers and views using T-SQL.
• Performance optimization for fast data retrieval.
• Configuration of high availability features.
• Configuration and monitor clustering.
• Configuration of SSRS and SSAS.
• ETL design using integration services.
• Backup configurations and Monitoring.
• Data integrity and security of a databases.
•Implement Database / Table space backups and recovery using RMAN (including incremental backups) •SQL query writing in Oracle / SQL Servers
•Worked across multiple functional projects to understand data usage and implications for data migration
•Worked on designing, planning and managing the data migration process
•Working with Federal and Provincial Tax/Revenue Authorities on Tax and Revenue Collection Database •Applications/systems to resolve IRIS DB related queries of taxpayers.
•Set and maintain database standards. Performance tuning of database systems.
•Install, upgrade, and manage database applications.
•Diagnose and troubleshoot database errors.
•Recommend and implement emerging database technologies.
•Create and manage database reports, visualizations, and dashboards.
•Create automation for repeating database tasks.

12/2009 -  TO Date
Responsibilities:
Performed Duties as Technical support Officers for helping programmers to integrate POS in their POS software in any Language like ASP.Net,VB.NET,VB ,Oracle
To provide assistances technical on Cloud Base POS software of retailers integration with FBR POS.
Performed duties as Focal person for FBR POS
Worked on POS database as DBA,Performed result oriented Queries to c heck integration details
Provide full programming help to POS programmers of Retailers
To check and correct POS integrated issues.
Installation and configuration of Oracle 11g,12c on REDHAT,LINUX,MS Windows
Creating and monitoring Tablespaces,Datafiles,Redologs
Working with database objects: Database, Table space, Indexes, Synonym, Views, Directories, Sequences, Creation and Management.Perform logical backup through export/import utilities on database.
Service naming configuration and monitoring with NETCA and NETMGR
Performing user management Backup and Recovery(Consistent and Inconsistent)
Performing RMAN Managed Backup and Recovery
Discovery sessions to identify, troubleshoot, document, and resolve database performance issues.
Perform Query Optimization Tasks.
Develop Complex SQL Scripts and Perform database archiving based on certain parameters.
Develop stored procedures, views, custom functions, triggers, and cursors.
Oracle to SQL transitions and vice versa
Perform Database Schema comparisons – reference vs actual.
Index utilization reporting
Collaborate with Development Team, Application Support and QA teams to resolve database
issues affecting application modules.
Troubleshoot DB response times and tune queries accordingly
Communicate effectively with management.
Develop good working relationships with internal teams.

Nov 1998-June 2006
Non Commissioned Officer(Rertired)
Pakistan Army Medical Corps
Performed technical and professional duties in the field of Radiation/Medical imaging Departments in Combined Military Hospital,Field Military hospitals,also performed admin and supervisory duties as Non Commissioned Officer and got Medals and Certificates from Army Medical Corps.