MOHAMMAD SALMAN
Flat No.A ***, Haroon Royal City, Block No. 16, Gulistan-e-Jauhar, Karachi.
Email address: ***************@*****.***
Cell# 034*-*******, 033********
OBJECTIVE
To obtain long term employment with a well-established organization where I may fully utilize my skills and abilities.
Technical Skills
Database Administration:
ORACLE 10g,11g /12c
RDBMS:
Oracle
High Availability:
Active Data guard Operation work, 11g & 12c Weblogic Forms & reports
Languages:
SQL, PL/SQL
Operating Systems:
Linux (Red Hat), Windows server 2003/2008/2012
Database Tools:
EM 10g//11g Grid control, SQL / PLSQL DEVELOPER, RMAN, ASM
Academic Qualification:
Mcs progress in Preston University first semester 2020
Graduation B.A from Sindh University in 2014
Graduation B.Com from Karachi University in 1997
Intermediate in Science from Board of Intermediate in 1994.
Matriculation in Science from Board of Secondary Education 1990.
Professional Experience
Architect Database Administrator 01/02/2020 to Till
ABIC System (Mudita Partners) Full-time Sister Company of TCC Wireless (US). TCC Wireless (T-Mobile Retailer).
Responsible for management of data structure at the design phase of database management. Database user creation with required privileges.
Build Deployment on Azure live server. Perform Insert, Update and Delete queries on Azure live server.
Involved of managing operation of the database to make sure it meets applicable business requirements. Responsible to make sure database is available and protected for business continuity purposes.
Responsible to continuously monitor database performance and make necessary changes to meet requirements identified in the design phase.
Installing, configuring & designing SQL Server & Oracle databases. Making ERD,s for ERP Applications.
Performing general database administration for Oracle and SQL server databases.
Deputy Manager I. T 09/10/2017 to 31/01/2020
BOLAN CASTINGS LIMITED, Sister Company of Millat Tractor Group of Companies, Main RCD Highway, Hub Chowki, District Lasbela, Baluchistan.
As Database Administrator Responsibilities
Set and maintain database standards. Oracle database backup and recovery.
Performance tuning of database systems.
Manage database access, Check the SQL query consuming lot of resources.
Database user creation with required privileges, Check the tables having no Indexes. Prepare the Backup strategy and test all the recovery scenario.
Check the table space for respective Tables & Indexes.
Install, upgrade, and manage database applications.
Manage database access, Diagnose and troubleshoot database errors.
Create and manage database reports, visualizations, and dashboards.
Preparing and troubleshooting of Oracle Forms, reports of Oracle systems, Modules likes Accounting system, Inventory Control system, Pay Roll system, Costing system, Sales system, Maintenance system, Quality Management, Production system and Modules.
Successfully completed training in IFS (Industrial and Financial Systems) ERP software from SRILANKA 501 Galle Road Colombo 06 Sri Lanka.
Oracle DBA and Software Engineer 05/01/2010 to 04/10/2017
IQRA UNIVERSITY (Main campus)
Oracle11g Database Web logic Sever Oracle_forms11g, Oracle_Reports11g, Oracle forms Builder6i Reports Builder6i Worked Accounting System,Trust Endowment, Trust Gold medal Fund, Scholarship Fund, Trust Sports Fund, Inventory Control System.
As Database Administrator Responsibilities
Software installation and Maintenance. A DBA often collaborates on the initial installation and configuration of a new Oracle, SQL Server etc database.
Data Extraction, Transformation, and Loading.
Specialized Data Handling.
Database Backup and Recovery.
Security, Authentication, Capacity Planning, Performance Monitoring
As a Developer Responsibilities:
Designing, develop programs and Modules.
Procurement & Inventory control, Degree,Student Caution Money
Student Fee collection, Designing an MIS Reports for Accounts and Management. Authorized in SQL Applies different Queries to solve multiple problems, Alter Tables & writing reports in SQL* Report builder on requirement of Finance Department and others Department.
Oracle Developer 01/11/2007 to 04/01/2010
QUALITY TRAVELS (PVT). LTD (PSA) for PAKISTAN INTERNATIONAL AIR LINES. Franchise of Carlson wagonlit.
Worked Oracle 9i RDBMS Developer from Builder 6i and Reports Builder 6i on Accounting system, Sales System & Ticket Sales System.
Responsibilities:
Designing an MIS Reports, Designing different type of Report for management
Data Migration from FoxPro to Oracle 9i, Authorized in SQL Applies different Queries to solve multiple problems, Alter Tables & writing reports in SQL* Report builder.
Managing Daily and weekly Backup of Data base Accounting System, Sales System.
Computer programmer 01/08/2006 to 31/10/2007
FERGUSON ASSOCIATE (PVT) LTD Worked Shares Management system.
As a Developer Responsibilities:
Develop different types of reports for shares Holders.
Authorized in SQL Applies different Queries to solve multiple problems, Alter Tables & writing reports in SQL* Report builder on requirement of Finance Department and others Department.
Computer programmer 01/11/1996 to 31/07/2006
AERO ASIA INTERNATIONAL AIR LINE (Tabani Aviation)
Unix 3.2, Unix 5.04 SCO Open server and Oracle 7 RDBMS.
Responsibilities:
Authorized in SQL Applies different Queries to solve multiple problems, Alter Tables & Forms, writing reports in SQL* Report Writer on requirement of Finance Department.
Troubleshooting of UNIX system, Unix and Oracle installation.
Managing Daily and weekly Backup of Data base U,V file system and Root file system.
Maintenance and Enhancement of Inventory control system, accounting system, flight Log System, Revenue system, Ticketing System, Document System.
Technical Qualification
Certificates from (TECHNO -ED (ORACLE AUTHORIZED PARTNER).
Oracle Database 10g Administrator 1
Oracle Database 11g Administrator 2
Diploma in Oracle7 RDBMS from (ORATEC(ORACLE AUTHORIZED PARTNER).
Two year Diploma in Computer Science from “Academy of Business Computer Institute” in Software.
Unix 5 (SCO Open Server),Unix 3.2 from “ORACLE EDUACATION CENTER” in the year 1997. Oracle 6 & 7 & 9i from “ORACLE EDUCATION CENTER” in the year 1997.
SQL Plus.SQL Plus Report,SQL forms,SQL Report writer. Forms 4.5& 6i, Reports 2.5 &6i
Personal Information
Religion Islam
Nationality Pakistani
N.I.C. No 42101-3492062-7
Domicile Karachi -Sindh.
Marital Status Married
Date of Birth 11-11-1972