Database Administrator

Mobile No: +971********* Living in Abu Dhabi

Skype id: Muhammad.attiq7

Email: adj3io@r.postjobfree.com

Working experience 8 Years & 02 Months:

Current working as a Database Administrator at Abu Dhabi Digital Authority in Abu Dhabi.

• Deep dive experience in Installation, configuration, maintenance, monitoring and troubleshooting Microsoft SQL Server, Maria DB, Oracle, MySQL DB.

• 24x7 Production database and applications support.

• Installed, configured, and maintained Oracle 11gR2,12c,18c and 19c

• Upgraded databases from Oracle 10g, 11g to 12c, 18c.

• Installation and maintenance of ORACLE 11g RAC/ORACLE 12c,18c,19c RAC and Standby Databases (Oracle Data Guard) for High Availability and Disaster Recovery purpose.

• Restoration and Recovery of databases at the times of occurrence of critical failures.

• Responsible for installing, upgrading and configuring the Oracle environment by creating databases, storage structures and objects, database backup and recovery, monitoring and optimizing database performance.

• Implemented Oracle database backup & recovery solutions using RMAN and manual methods.

• Installed and configured a SQL 2008/2012/2014/2016 clustered environment with availability groups.

• Performed block recovery using RMAN.

• Moving data between databases using Data Pump.

• Created User accounts, Roles and granting required access permissions and privileges to the database based on the applications they are accessing.

• Partitioned large tables for better performance and manageability.

• Installed and configured Golden Gate for replication.

• Responsible in configuring and backing up database using RMAN, Hot backups, Cold backups and Logical backups.

• Responsible for installing, upgrading, patching and configuring the Oracle environment.

• Microsoft SQL Server upgradation from 2008 R2 to 2012/2016 R2.

• Provide DBA support and technical expertise for multiple applications in development, test, QA and production - SQL Server 2012, 2014, and 2016 environments.

• Installed and configured a SQL 2016 clustered test environment.

• Configured and supported replication and log shipping in both SQL 2012 and 2014.

• Documented processes for installations, clustering, availability group setup, and patching.

• Performed day-to-day DBA activities such as monitoring SQL Server health, job status, addressing user requirements.

• Took responsibility of maintaining the SQL Server instances to ensure software is properly installed, security patches were applied and upgrades were done.

• Monitor and optimize system performance using SQL Profiler and Database Engine Tuning Advisor.

• Involved in ensuring data recovery, maintenance, and data integrity and space requirements for physical database. Creating and Modifying Tables, Stored Procedures, Views, Indexes, User-defined Functions and Triggers etc as requirement on SQL Server Environments. Muhammad Attiq

Career Objectives

Seeking challenging and responsible position where my knowledge, abilities and potential can be fully and efficiently utilized, which offers opportunities for growth to acquire more knowledge and skills & above all, I can serve the humanity.

• Created logical volumes and increased the file system in Linux servers.

• Experienced in managing disk quotas and applying RHEL Hardening Standards.

• Configured new and existing servers to adhere to predetermined standards and installed several operating systems.

• Maintenance, performance management and fine-tuning; security, capacity, availability, and continuity management for the systems environment including relevant analyses.

• Extensively worked on SQL Server Job troubleshooting...

• Oracle RAC (Physical) migration & Upgradation to Virtual servers.

• Install and manage security-reporting tools used to monitor changes to the active Directory.

• Maintaining user accounts, System Security, backup/recovery, Performance tuning, troubleshooting at various levels.

• Management of Users accounts, System security, kernel performance monitoring and tuning.

• Well versed in implementing System Management and Monitoring procedures.

• Well versed with User Management, Performance Tuning, and Concurrent Processing Settings

• Oracle RAC (Physical) migration & Upgradation to Virtual servers.

• Extensively worked on SQL Server Job Troubleshooting.

• Strong Experience in Support and Development Projects.

• Direct interaction with Clients to gather requirements.

• Effectively sharing the work across Team members. Taking responsibility of allotting work and making sure of all the SR's in the queues were addressed.

• Involved in all kinds of DB activities. Refreshes, Patching, DB Performance issues etc.

• Communicating with the Team members very frequently, effectively involving in the work and making sure to complete within the requested time.

• A keen planner, strategist & leader with expertise in handling issues occurred in production.

• Excellent communication skills with ability to interact at all levels with the Customer.

Database Administrator at BITECH International LLC (April 2017- Sept 2019).

• Oracle ERP installation, configuration and administration.

• Expertise in Installation of Oracle Databases on ASM/Non-ASM file systems.

• Familiar with Discoverer, Workflow configurations, Forms and Reports. Troubleshooting Concurrent manager, Apache and Discoverer issues.

• Effectively managing the Standard process flow and maintaining Customer satisfaction.

• Involved in Configuring OEM. Monitoring the Databases. Automated the Daily Health check report. Configured SQL Plan Management.

• Hands on working experience on 12.2 environments.

• Managing in creating the SR's and efficiently involved in transferring the SR's across other teams and getting the work done.

• Oracle ERP Cloning and Patch management for Bug fixes and DB version upgrades.

• Building and maintaining all Corporate Production, Test, and Development database environments

• Ensuring databases High availability through RAC, HA, SAN Based Replication and Data Guard.

• Working in Oracle 11g/10g/9i database administration on Linux, Sun Solaris (M6-32) and Windows platforms in high availability production environment.

• Installation, Configuration, Deployment, Ongoing Administration and Performance Tuning of Oracle databases 11g/10g/9i.

• Up gradation of Oracle 11g R2 (11.2.0.3) to 11gR2 (11.2.0.4) RAC database and single database on Solaris, Linux.

• Experience in Oracle 11g R2 RAC Installation, Configuration, administration, maintenance and performance Tuning.

• Performed user and security administration activities, such as enrolling Users, granting privileges to users, and maintaining system security.

• Installed and configured MySQL on Linux and Windows environments.

• Supporting management with different database related decisions.

Warid Telecom Pakistan (Abu Dhabi Group of company) Worked as a Executive Database Administrator (July 2014 to Dec 2016)

• Performs the capacity planning required to create and maintain the databases. The DBA works closely with system administration staff

• Working with Oracle Technical consultant for any problem regarding oracle databases

• Assists with impact analysis of any changes made to the database objects.

• Managed and resolved architecture issues during development

• Documentation of oracle databases.

• Having sound knowledge of setting security parameters.

• Perform database recovery,

• Perform backup, recovery using RMAN, Data Pump.

• Daily Tasks/Assignment related to Oracle Database.

• Worked in SQL.

• Worked in Solaris, Linux, IBM-AIX, and Windows.

• Preparing Test System.

• Installation and configuration of MS SQL Server.

• Strong knowledge of backup and recovery of the database.

• Strong knowledge of Database mirroring.

• Implements and enforces security for all of the MS SQL Server.

• Experience in MS SQL Server Installation, Configuration, administration, maintenance and performance Tuning.

• Performed user and security administration activities, such as enrolling Users, granting privileges to users, and maintaining system security.

• Installation and Configuration of Redhat Servers 5/6/7.

• Configuration of Network resources, adding & configuring Virtual NIC.

• Installation, configuration and maintenance of LVM on RHEL.

Assistant Database Administrator at Ora-tech System Islamabad Pakistan. Jan 2013 to Jun 2014.

• Provided all kinds of DBA support to development teams as well as production support to various Clients.

• Working as part of a team and providing 24x7 supports Clients.

• Database Security. Implementation of database auditing OS /Database level.

• Export/Import, Expdp/Impdp, RMAN, Grid Control,

• TOAD for Oracle, Oracle Developer software,

• Oracle Enterprise Manager (OEM), STATS Pack, AWR.

• Implemented database refresh with the hot backup using RMAN.

• Moved database schema changes to stage and production.

• Managed and resolved design issues during development.

• Upgrade and tune Oracle databases.

• Create and maintain Standard Operating Procedures (SOPs)

• Day to day management and issue resolution of Oracle databases, data replication, and data load processes.

• Patch Management and Version Control

• Developed or modified Oracle backup and recovery scripts.

• Used Oracle backup utility RMAN to implement Oracle backup and performed a number of times of disaster recovery.

Six Weeks internship experience an ”NTC(National Telecommunication Corporation HQ Islamabad” Responsibilities: November 2012 to December 2012.

• Demonstrated experience in working with enterprise systems supporting large base community.

• Configuring simple Database as well as ASM Grid infrastructure in Linux and Unix OS.

• Installs, configures and maintains database instances, creates various database objects, creates users with appropriate roles and levels of security on multiple platforms.

• Daily monitoring and analysis of systems to ensure 24x7 stable operations.

• Troubleshoot day-to-day database issues to ensure system stability and throughput.

• Ensure database backups are working as per backup & recovery policy, frequently verifying recovery process.

• Implementing Database security policy and ensure that database access is protected.

• Provides Oracle DBA support and technical support for multiple applications in development, test, staging and production environments.

Certifications & Technical Skills

OCIOA (Oracle Cloud Infrastructure cloud Operations Associate) OCIAA(Oracle Cloud Infrastructure Architect Associate) Oracle Autonomous Database Cloud 2019 Certificate Specialist. OCE (Oracle Certified Expert) : Oracle Real Application Clusters 11g and Grid Infrastructure Administrator OCP (Oracle Certification Professional) : Oracle University Testing ID (OCI228647) OCA(Oracle Database Assistant ) : Oracle University Testing ID (OC1228647) MCSE/MCSA 2016 : Microsoft

Oracle Apps DBA : Oranet Training & Solution center Islamabad, Pakistan Microsoft SQL Server 2012 (DBA) : Oranet Training & Solution center Islamabad, Pakistan Oracle DBA11g : Oranet Training & Solution center Islamabad, Pakistan RHCSA (Red hat Certified System Administrator 7) : Red hat Operating System : Linux, Unix(Solaris 9,10,11), Windows, CentOS. ITILv4 – Foundation : Certificate Number: GR671108728MA, Candidate Number 9980055933936812 Professional/Technical skills

Current working in DBA (Database Administration) in Oracle 11g/12c/18c/19c, MS SQL server in windows, Linux and UNIX operating system, Data Guard and RAC with 11g/12c/18c/19c DBA (Both are OCM level Courses).

Proficient by using Linux and Unix Operating system (Red Hat Enterprise Linux 6/7/8).

Oracle ERP installation, configuration, administration and upgrades.

Oracle ERP Cloning and Patch management for Bug fixes and version upgrades.

Oracle ERP Business continuity for DR site.

Complete knowledge and implementation in Oracle 11g, 12c, 18c and 19c, MSSQL Server Database Administration by using Linux, Unix OS as well as windows.

Complete knowledge and implementation of ASM Grid infrastructure in Oracle11g/12c/18c/19c Database Administration by using Linux, Unix OS.

Excellent hands on experience in SQL Server cluster installation and troubleshooting

Full command on creating simple Database as well as ASM Grid infrastructure in Linux and Unix OS.

Ability to handle multiple tasks; proven self-initiative and problem solving abilities

Complete knowledge about LAN (Local Area Network) configuration.

Full command on MS Office 2003, 2007, 2010 (MS Word, PowerPoint, Excel etc).

VMware.

RHEL 5, 6, 7 & 8.

Training & Seminars

Oracle 10g Developer Training from Era Soft Problem solution, Peshawar, Pakistan

Microsoft SQL Server 2012 Administration Training from Ora-net Training Center, Islamabad, Pakistan.

DBA Oracle 11g Training from Ora-net Training center, Islamabad, Pakistan.

Oracle 11g Data Guard Workshop at Ora-net Training center,Islamabad,Pakistan Education Background

BCS (4 Years) from IBMS Agricultural university

Peshawar, Pakistan

2.95 / 4.00

(CGPA)

2008–2011

Intermediate (Pre-Engineering) from BISE Kohat, Pakistan 1st Division 2005–2007 Matriculation (Science) from BISE Kohat, Pakistan 1st Division 2004–2005 Personal Information

Name: Muhammad Attiq Gender: Male

Date of Birth: 14th April 1987 Marital Status: Married Permanent & Postal Address: Abu Dhabi System Information Center Al-Karma street Abu Dhabi Present address Abu Dhabi System Information Center Al-Karma street Abu Dhabi Languages: Can fluently speak read & Write English, Urdu & Pashto https://www.linkedin.com/in/muhammad-attiq-98a09466/ References

Reference will be given on demands

Contact this candidate