Nazir  Ahmad, Senior Database Administrator

Nazir Ahmad

Senior Database Administrator

Afiniti

Lieu
Pakistan
Éducation
Master, Computer Science
Expérience
10 years, 11 Mois

Partager Mon CV

Empêcher usager


Expériences professionnelles

Total des années d'expérience :10 years, 11 Mois

Senior Database Administrator à Afiniti
  • Pakistan - Islamabad
  • Je travaille ici depuis mai 2021

• Provision and supporting MySQL instances, both in clustered and non-clustered configurations in production and archival system.
• upgrade, backup, recovery, migration, portioning, optimization, archiving of Databases.
• Supporting Production, Archival, Innodb Clustering and Reporting database system of different technologies.(Oracle, MySQL + Greenplum) in Linux/Window environment.
• Responsible for managing high performing databases including end user activity pertaining to the design, development, testing and implementation of database services.
• Proactive monitoring of database to establish a secure service with minimum downtime and resolution within SLAs.
• Performa database backup (both logical and physical), manual and scheduled.
• Master slave replication configuration and troubleshooting.
• Provided technical assistance on installation and maintenance of database software components and related upgrades.
• Data archiving and purging as per policy for space management.
• Managing Database related alerts and escalations.
• Perform database installation, configuration, upgrade and patching.
• Queries optimization, catching locking/blocking and fix.
• Database Performance tuning.
• Create users, roles policies and procedure and data archiving asp SOP’s to ensure effective protection and integrity.

Database & Application support/Oracle DBA à Pakistan Tobaco Comp via Emigratus
  • Pakistan - Peshawar
  • janvier 2017 à avril 2021

Database Administration
 Installation & configuration of Oracle 12c database server on Windows 2k12 OS platform.
 perform both database and operating system performance tuning and monitoring
 Manage schedule and manual backups both Hot and Cold and check its validity by restoring
Test environment.
 Implement and maintain database security (create and maintain users and roles, assign privileges)
 Patch Management and Version Control
 handle multiple databases and applications
 Monitoring the database server to identify any Performance issues or bottlenecks.
 Troubleshoot day-to-day database issues to ensure system availability.
 Databases replica creation and configuration for new location;
 Creation of user, role, privilege, profile Management as per the requirement.
 Data transfer via Replication process from master to slave and backward replication and trouble shoot in case of any errors.
 Data integration while processing replication process.

Application support
 Create, configured and maintain Web Logic server on server 2k12.
 Oracle Fusion Middleware Repository creation and configuration as per application requirements.
 Resolve IT application-related incidents, service requests and problems in a timely and efficient manner in line with Business requirements
 Employ appropriate application maintenance, support and incident management processes and procedures to support and maintain IT applications, and to investigate and resolve IT application-related incidents.
 As required, provide timely communication to users on the status of their service requests and incidents.
 As necessary, liaise with IT suppliers to ensure IT application-related incidents and problems are resolved in a timely and professional manner.
 Maintain IT application support technical documentation.
 Ensure Technical Change Controls are developed, tested & released according to an agreed schedule and ensure all high business impact changes are escalated as appropriate
 Ensure all the Incidents and Service requests are addressed within the SLA.
 Regression and Unit testing
 Creation of test case scenarios of new developments made
 Work with the Business/System Analysts to review and impact new business requirements.
 Implement, test and monitor required IT application changes in line with change implementation plans.
 Ensure IT application changes meet the agreed service acceptance criteria.
 Creation of DR server.
 Installation, Configuration of supporting software’s as a pre-requisite for oracle server Forms&Reoprts and web logic.
 Application configuration, regression and Unit testing
 Perform general technical trouble shooting and give consultation to development teams
 Patch Management and Version Control
 Leading IT team (5 members).
 Co-ordination with vendors globally.
 Deployment of each module in application and database process under SOX controls.
 Incident management using portal TechDeck online and Cherwell.
a) Ensure 100% SLA and PLA compliance
b) Responsible for driving all P1, P2, incidents, change requests and Service request
c) Mangaging Service Request, Changge Request,

IT Administrator/ERP support à Metasoft International KSA
  • Arabie Saoudite - Riyad
  • mai 2013 à octobre 2016

IT Administrator, ERP Application support/IT Analyst (CSH -Centeral Security Hospital) KSA
1. Supporting ERP(Hospital management system).
a. Application Implementation and maintenance.
b. Patches inhalation.
c. SQL server 2008 installation.
d. New user training and registration.
e. Assign role to users.
f. User and Management feedback,
g. Analyzing new requirements.
2. Co-ordination with development teams Remotely Support for all Sites.
3. Supporting Application.
a. Client Connectivity/ Installing new system.
b. New user training and registration.
c. Assign role to users.
d. User and Management feedback,
e. Analyzing new requirements.
4. Co-ordination with development teams
a. through IP VPN
b. Team Viewer.
5. 100 Users(Approximately).
6. Manage Biometric Attendance System.
a. Create New User in Basma.
b. Monthly attendance preparation.
c. Trouble shooting.
d. Manage the database and connectivity.
7. Complete IT Support including Printers, Scanners, Photocopier Machine.
a. Desktop + Laptop installation and TS.
b. Acronics Image.
c. Network printer/ Scanner installation and user access.
d. Dot-matrix printer.
e. Datacard Card printer.
8. Co-ordination with IT Vendors.
a. Co-ordination with Service provider.
b. Co-ordination with suppliers.
c. Purchasing new IT equipments.

Éducation

Master, Computer Science
  • à University of Balochistan
  • août 2007

Computer Science, Programming. Database. Networking. Development of Inventory control system

Specialties & Skills

Computer programming
Oracle Database Administration
Microsoft Servers
IT Technical Support
SQL Server
VB6. SQL Server, C,C++, HTML, Java Script, PHP, MySQL
ERP(Hospital Management System
Troubleshooting
OCP(Database) Certified, Backup, RecoveryMCSE 2015,Window Server O2012, AD, DC, DNS, DHCP, WDS, TMG,

Langues

Anglais
Expert
Arabe
Débutant
Urdu
Expert

Formation et Diplômes

MCSE 2012 (Formation)
Institut de formation:
CISCOM
Oracle Database Administration OCP (Certificat)
Date de la formation:
June 2008
Valide jusqu'à:
January 9999