Crop Picture
NOTE: Do not upload any image that violates our Picture Policy. Doing so will result in the removal of the concerned image without prior notification.
概要
PROFESSIONAL SUMMARY:
Over 13 Years of Strong Experience in Database Administration on (Oracle Database, MS SQL, MySQL Oracle Exadata Database Machine, Oracle RAC, Oracle Golden Gate, Oracle EBS, IBM DB2, Oracle Cloud, Microsoft SQL Server) with System Administration(RedHat Linux, Oracle Linux, Windows).
Specialties/Capabilities:
•Database Development
•Database Optimization.
• Database Administration
•SQL Scripting
•Development in Oracle forms & reports 11g/10g
• Oracle Application Server 10g Installation and Configuration.
•SQL
•T-SQL
• PL/SQL
•MS Access
• SQL Server
•Understanding of Logical Data Model/Physical Data Mode
•Normalization and De-normalization of data using Oracle 11g,12c,19c,SQL Server 2008,2012,2018
•Data Analysis using MS Excel/Power BI,Tableau etc,UNIX shell scripting and Python
•ETL/BI tools such as Informatica, Data Stage, Business Objects, SAS,and Micro Strategy, Tableau, Power BI
•SQL Server Management Studio 2000/2008/2014/2019,Writing SQL SPs
•SQL Server Maintainance,Security,Performance Tuning, SSIS, SSRS
•Weekly maintenance of servers using scripts and execute those scripts via SQL job
•Ongoing review and completion of trouble tickets related to the database systems Creating and •monitoring Table spaces, Data files, Redo logs, objects, Database, Table space, Indexes, Synonym, •Views, directories, Sequences, Creation and Management.
•Performed installation, configuration, performance tuning, optimization, backup and disaster
•Creating Tables, Stored Procedures, Views, Indexes, Cursors, Triggers, User Profiles, User Defined
•Implemented database Replications in SQL Server 2008, 2014 for High Availability
项目
工作经历
DBA ORACLE/MS SQL
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.
TECHNICAL SUPPORT OFFICER DATABASE
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.
NON COMMISSIONED OFFICER
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.
