Shafi Ahmad Syed
Herriman,UT
Summary
Database Administrator with over 8 years of relevant experience in software installations, upgrading, production support, backup recovery methodologies, Security, User Management, High Availability features, and maintaining Oracle databases in large-scale Unix/Linux and Windows environment. Good experience in managing MySQL and MongoDB databases. A highly qualified, goal-oriented IT professional with extensive experience in 24x7 environment.
Overview
13
13
years of professional experience
1
1
Certification
Work History
Database Administrator
Lenovo PCCW Solutions
Kuala Lumpur, Malaysia
07.2022 - 12.2023
- Installed, configured, and maintained Oracle 12c and 19c pluggable (PDB, CDB) databases on Linux servers.
- Managed multiple databases running on different platforms including Windows, Linux and UNIX systems.
- Provided technical support for developers by creating views and indexes as per their requirements.
- Developed scripts for automating routine maintenance tasks such as index rebuilds and statistics updates.
- Performed regular health checks on all databases to ensure optimal performance levels are maintained.
- Collaborate with other teams such as network administrators and system admins for resolving complex issues.
- Assisted in disaster recovery planning by testing various backup strategies and scenarios.
- Deployed patches and upgrades on a timely basis to keep up-to-date with latest software releases.
- Participated in capacity planning initiatives to forecast future resource needs based on current trends.
- Communicate with software vendors to analyze and resolve software installation and ongoing support issues.
- Analyzed system logs regularly to identify any potential problems or suspicious activities.
- Collaborated with stakeholders to gather business requirements for enhancements and change requests.
- Upgraded Oracle container database system from 12.1 to 19.0 for EBS applications.
- Performed Oracle container database 19c clones from production to UAT for EBS applications.
- Resolved customer queries related to database issues promptly and accurately.
- Coordinated security compliance and audit preparation with cyber security team.
- Managed daily backups of the databases using RMAN utility.
- Provided support for complex issues related to software tools, applications and databases.
Database Administrator
Manpower
Kula Lumpur, Malaysia
05.2020 - 07.2022
- Installed, configured, and maintained Oracle 11g,12c and 19c databases on Linux servers.
- Maintained, and performed backups and recoveries of the databases using RMAN utility and Export/Import.
- Configured and managed user accounts, privileges, roles, profiles. in database servers.
- Designed, implemented, and maintained relational databases for data storage and retrieval.
- Collaborated with developers to ensure data integrity across multiple applications.
- Created stored procedures, triggers, functions, views, indexes, and constraints on databases.
- Resolved complex technical issues related to database systems performance tuning.
- Performed tables and Indexes Reorg and Export/Import to reduce I/O and reclaim space.
- Implemented database security measures like password policies to ensure data protection.
- Monitored performance of queries and tuned them as needed using Explain Plan, AWR, ADDM, TKProf tools.
- Implemented data replication between two different databases using Data Guard, M View features.
- Upgraded existing databases from 10g, 11g to 12c, and 19c with minimal downtime.
- Deployed database patches on a timely basis to keep up-to-date with latest software releases.
- Resolved customer queries related to database issues promptly and accurately.
- Analyzed system logs regularly to identify any potential problems or suspicious activities.
- Managed multiple databases running on different platforms including Windows, Linux and UNIX systems.
- Documented all changes made to the database structure during maintenance activities.
- Provided technical support for developers by creating views and indexes as per their requirements.
- Executed tests on newly developed databases prior to release into a production environment.
- Managed performance monitoring and tuning while identifying and repairing issues within database realm.
- Plan and Implemented MySQL 8.0 database with Active-Active data replication; Installed and
configured Enterprise Monitoring. - Prepared and Implemented shell scripts in CRON for MySQL DB dumps, Enterprise backups, & file system housekeeping, and performed database hardening as per CIS benchmark.
- Managed MongoDB with two replica sets, performed fixes for replication lags, node rebuild,database service accounts and end user management, etc.
- Provided 24x7 on call support, responding to and resolving production database incidents in time.
- Worked with software vendors to analyze and resolve software installation and ongoing support issues.
Staff Engineer
Seagate Global Business Services
Penang, Malaysia
12.2010 - 04.2020
- Installed and Maintained Oracle 10g,11g, and 12c databases using Standalone, RAC and Active Data Guard.
- Managed multiple databases running on different platforms including Windows, Linux and UNIX systems.
- Monitored production environment closely for any changes that might affect system stability or performance.
- Provided technical support during user acceptance testing phases prior to product release.
- Handled DBA assignments like address incident tickets, change requests, error checks, database health monitoring of physical resources like disc space, memory, CPU etc.
- Optimized queries for maximum efficiency and scalability in a production environment.
- Created stored procedures, triggers, functions, views, indexes, and constraints on databases.
- Manage database security by creating, assigning appropriate roles and privileges to users, data masking, TDE encryption, Materialized Views.
- Created new table spaces, add/resize data files, for applications to store their data in the database.
- Configured user accounts, privileges, roles, profiles. in the database server.
- Tested application code changes before deploying them into production environment.
- Migrated existing databases from one platform to another with minimal downtime.
- Resolved customer queries related to database issues promptly and accurately.
- Troubleshot existing database systems for errors or inconsistencies in data output.
- Assisted other teams with troubleshooting complex SQL queries or stored procedures.
- Analyzed system logs regularly to identify any potential problems or suspicious activities.
- Developed scripts for automating routine maintenance tasks such as index rebuilds and statistics updates.
- Performed regular health checks on all databases to ensure optimal performance levels are maintained.
- Assisted in disaster recovery planning by testing various backup strategies and scenarios.
- Collaborated with other teams such as network administrators and system admins, development & application support teams for resolving complex issues.
- Deployed patches and upgrades on a timely basis to keep up-to-date with latest software releases.
- Conducted training sessions for junior DBAs to close knowledge gap.
- Developed scripts to automate routine tasks such as backups, indexing, and query optimization.
- Provided support for complex issues related to software tools, applications and databases.
- Worked with software vendors to analyze and resolve software installation and ongoing support issues.
- Participated in evaluation, design and implementation of new and major enhancements of business applications.
- Collaborated with stakeholders to gather business requirements for enhancements and change requests.
- Installed, Configured and Maintained Automic Application Manager (UC4 AppWorx) environment with 6 Admin and 200 remote agent servers, executing business critical sales, supply chain, database and other application jobs on scheduled basis on Linux/Unix and Windows environments.
- Managed WebLogic, Apache, JBoss application servers, including application deployments, data source configurations, user management, handling daily incidents, War/Jar files deployments using version control.
- Provided On-call support, responding to and resolving database, web application servers, and UC4 AppWorx related incidents in a timely manner.
Education
Master of Computer Applications - Database Management
University of Madras
Chennai05-2005
Skills
- Oracle 10g/11g/12c/19c, MySQL 7/8, MongoDB 34/42
- SQL*Plus, SQL*Loader, Export/Import, OEM
- RMAN, Export/Import, SQL*Loader
- RAC, ASM, Data Guard, Golden Gate
- Performance Tuning & Capacity Monitoring
- Root Cause Analysis, problem solving
- Database Upgrade, Patch Management
- Document Management
- Technical Support
- Database Design
- Process Automation
- Unix, Linux, Windows Operating System
- Requirements Gathering
- Indexing, partitioning, normalization
- TDE, Data Masking, Oracle Vault
- Oracle Enterprise Manager 12c/13c
- Oracle WebLogic, JBoss administration
Certification
- ITIL V3 foundation - May 2014
- UC4 Certified Professional - January 2013
- MySQL Database Administration - July 2017
- Oracle Certified Associate - May 2015
Languages
Telugu
First Language
English
Proficient (C2)
C2
Hindi
Proficient (C2)
C2
Timeline
Database Administrator
Lenovo PCCW Solutions
07.2022 - 12.2023
Database Administrator
Manpower
05.2020 - 07.2022
Staff Engineer
Seagate Global Business Services
12.2010 - 04.2020
Master of Computer Applications - Database Management
University of Madras
Similar Profiles
Mohanram SubramaniyanMohanram Subramaniyan
Cloud Solution Architect at Lenovo PCCW Solutions Pvt LtdCloud Solution Architect at Lenovo PCCW Solutions Pvt Ltd
RAJASEKAR RAJANRAJASEKAR RAJAN
IT Security Officer at Lenovo PCCW SolutionsIT Security Officer at Lenovo PCCW Solutions
Rajan SoniRajan Soni
IT Security Officer at Lenovo PCCW Solutions Pte Ltd.IT Security Officer at Lenovo PCCW Solutions Pte Ltd.