Working as DBA Consultant and responsible for:- Database Object Administration- Space Management- Access Management- Incident and Alert Monitoring- Performance Tuning
Data Extraction through ETL tool (Talend Studio).
Data Transition between internal products and external clients of MTBC.
Debugging of data issues after data transition at database level.
Develop scripts to perform various database related tasks (Temp tables, Cursors,Functions,Procedures,Views).
Data processing and data validation of delimited files using SSIS & Talend tool.
Data Modification and integration.
Data Import/Export through scripts.
Efficient in Oracle SQL (queries, Joins)
Data Loading through SQL loader wizard.
Working on SQL.
Efficient in writting scripts,stored procedures as per the requirment of application team.
Assisting other Departments Development Team's.
Configuration and generating script for IRIS application and database.
Installation & Configuration of Oracle 11g & 12c (Linux and windows).
Resolution of taxpayer issues.
Configuration of RIMS (Restaurant Invoice Monitoring system) in many restaurants of Islamabad, Lahore and Faisalabad.
Knowledge of backup through RMAN.
Work closely with several resources (internal) to troubleshoot live application issues in the timely fashion.
Work collaboratively with Development, Application Support and Quality Assurance teams.
Providing support to PRA (Punjab Revenue Authority) on RIMS project.
Conversant in DB design, Create Tables, Views, and Triggers.
Experience working with development tools like TOAD/SQL Developer.
Highly motivated, excellent team player, enthusiastic, strong initiative and quick learner of new technologies.
Creativity with an eye to developing new and innovative solutions.
Excellent analytical and logical skills, including the proven ability to adapt to a dynamic project environment.