Summary
Overview
Work History
Education
Skills
Certification
Languages
Timeline
Generic

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
2022.07 - 2023.12
  • 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
2020.05 - 2022.07
  • 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
2010.12 - 2020.04
  • 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
Chennai
2005-05

Skills

  • Oracle 10g/11g/12c/19c, MySQL 7/8, MongoDB 3.4/4.2
  • 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
2022.07 - 2023.12

Database Administrator

Manpower
2020.05 - 2022.07

Staff Engineer

Seagate Global Business Services
2010.12 - 2020.04

Master of Computer Applications - Database Management

University of Madras
  • ITIL V3 foundation - May 2014
  • UC4 Certified Professional - January 2013
  • MySQL Database Administration - July 2017
  • Oracle Certified Associate - May 2015

Similar Profiles

  • Johnson Karthik Subramaiam

    Johnson Karthik SubramaiamJohnson Karthik Subramaiam

    Service Delivery Manager/Technical Project manager at LPS Tech (Lenovo PCCW Solutions)Service Delivery Manager/Technical Project manager at LPS Tech (Lenovo PCCW Solutions)

    View Profile
  • SRUTHI S THAMPY

    SRUTHI S THAMPYSRUTHI S THAMPY

    Systems Engineer at Lenovo - PCCW SolutionsSystems Engineer at Lenovo - PCCW Solutions

    View Profile
  • Jyoti Chauhan

    Jyoti ChauhanJyoti Chauhan

    Asset Manager & IT Admin at Lenovo PCCW SolutionsAsset Manager & IT Admin at Lenovo PCCW Solutions

    View Profile
Shafi Ahmad Syed