MUHAMMAD ARSLAN KHALID

Database Administrator Oracle DB2(LUW) GreenPlum PostgreSQL MSSQL

516-***-**** ad1ef5@r.postjobfree.com in/arslan-khalid-5 Manhattan, New York

●I have 8 plus years of experience as DBA and managing databases providing 24/7 support of both development and production DB2(LUW), Postgre-SQL, GreenPlum, MSSQL, Oracle 19c/18c/12c/11g/10g databases on Various Platforms.

●Proficient in Database Administration activities such as Upgrades, Patches, Cloning, Backup and Recovery, Performance Tuning, capacity planning, script development, and documentation.

●Conducted interviews and made recommendations for new hires, consultants or replacement for the personnel.

●Developed and executed strategic plans and training to achieve goals, and improve SLAs.

●Built and maintained strong, long lasting customer relationships.

●Communicated, presented and influenced all levels of the organization, including executive.

●Strong at maintaining, automating and improving the processes for database administration.

●Excellent experience in Installation, Setup and configuration of Oracle 10g, 11g, 12c, 18c, 19c in HP-UX, SUN SOLARIS, IBM AIX and UNIX/LINUX EXADATA environment.

●Poses strong Administrative skills in RHEL and EXADATA, and ZDLRA.

●Provided DBA support with proactive monitoring, identifying areas that need to be improved in the application and databases using ASH, AWR, ADDM, and OEM Grid Monitoring.

●Good experience working with Cluster Server Management (Real Application Cluster) & have successfully completed projects on ASM and Oracle RAC – Install, Configure, implement, and support.

●Good experience in performance tuning of production and development databases.

●Strong experience in database backup & recovery procedures using conventional cold, hot & RMAN backups

●Experience in Installation and configuration of Oracle 10/11g/12c/18/c/19c on SUN-Solaris, HP-UX, IBM AIX, Linux, Exadata and Windows

●Experience in Installation, configuration of Oracle 11g, 12c, 19c RAC & also used Oracle features like – Memory Management, Reorganization / Rebuild Indexes, Gather statistics / Automatic Statistic Collection, SQL Baselines, SQL Profiles, invisible indexes.

●Excellent experience in using OEM, TOAD, Data Migrations using export/import

●Excellent experience in cloning of databases using RMAN duplicate database feature.

●Implemented DATA GUARD (Standby) for high availability/disaster recovery support

●Management of schemas, objects & partitioning the tables & indexes.

●Proficient in performance tuning using Explain Plan, STATSPACK, SQL_TRACE, TKPROF, ADDM

●Good experience in User and security management using Grants, roles, privileges.

●Experience in setting up DR solutions using RMAN, scripts, DataGuard

●Setup Oracle 11g, 12c, 19c GoldenGate for replication needs.

●Worked extensively with SAN admins for ASM disks and Diskgroups.

●Involved in disaster recovery planning; detailed out the processes and procedures of implementing disaster recovery; implemented database backups and disaster recovery strategies using RMAN.

●Good experience on pluggable databases and containers.

●Developed and implemented Materialized views for better performance of daily reports.

●Expertise in using Oracle Enterprise Manager (OEM) and Grid control and RAC and AWS.

●Proficient in Greenplum installation and configuration.

●Experienced in schema management within Greenplum databases.

●Skilled in user management and implementing robust security measures.

●Adept at performance tuning, both at the memory and query level.

●Well-versed in Greenplum backup and restoration procedures.

●Capable of expanding and removing segments in Greenplum databases.

●Knowledgeable in establishing high availability in Greenplum through segment mirroring and master mirroring.

●Competent in parallel data loading in Greenplum, using utilities such as 'gpfdist,' 'gpload,' and 'PXF.'

●Familiar with switchover and failover processes in Greenplum high availability setups.

●Proficient in detecting and recovering segments and master nodes.

●Experienced in performing minor version upgrades, ranging from 6.7 to 6.25.

Kyndryl (IBM Spin-off)

Sr. Product and DB Ops Lead (Full time) Aug 2022 – Aug 2023

●Created and used automation scripts and tools to streamline routine chores, increase productivity, and reduce the chance of human error.

●Maintained the performance, security, and availability of crucial databases for a start-up going through a hyper-growth period.

●Performed performance tuning and database optimization to speed up system response times, lower downtime, and boost customer satisfaction.

●Managed privileges and entry permissions to maintain the security of the data.

●Determined the best values for database parameters, deploying new releases with AWS, and satisfying maintenance obligations, maintains database efficiency.

●Provided guidance, support, and chances for knowledge-sharing to young database administrators and developers, mentoring and training them to advance their professional development.

●Showed expertise of DB2, Oracle database administration, including replication, clones, backups, and groups.

●Maintained service quality by creating and implementing organizational standards using teamwork tools like JIRA & SNOW.

●Support high availability of Oracle/DB2 services and database.

●Responsible to solve DB problems, perform query optimization, database design optimization in addition to helping/reviews/feedbacks to stakeholders in writing complex queries.

Selected Achievements:

Performed daily Backups for designated clients leading to timely recovery of the Database. Achieved Database Uptime 99% of the time.

Upgraded Application to latest build without any incidents.

Reduced data loss by 90% in the event of a system failure through improved recovery system Interviewed and brought on new resources to build DB2 DBA team from scratch.

Set up an SP that would track user privileges across all databases creating ease in comparing user privileges in future.

Advanced tech skills & tools: Oracle, MSSQL, Apache Cassandra, Linux, DBeaver

Afiniti Software Solutions

Senior Database Administrator (full-time) June 2020 - Sept 2022

As a database administrator, I provided 24/7 support for various local and international telecom and health insurance companies using multiple database systems, including Postgres, GreenPlum, and MySQL. My responsibilities included:

●Led a team of 10 peoples and successfully migrated data from MySQL to Greenplum on 21 accounts

●Oversaw all aspects of database administration, including installation, configuration, upgrades, patching, migration, capacity planning, performance tuning, backup and recovery.

●Ensured the smooth operations of the database administration support for production, development, and test environments through daily monitoring and maintenance.

●Implemented and configured new and existing PostgreSQL databases on virtual machines and containers, and conducted regular testing, monitoring, upgrading, and tuning activities.

●Implemented effective backup and recovery strategies (logical and online) to ensure the availability of critical data.

●Migrated data from MySQL to GreenPlum using PXF for improved efficiency and scalability.

●Conducted scheduled maintenance activities, including vacuum and analyze, to improve query response time.

●Monitored bloat reports and performing regular maintenance to prevent data degradation.

●Implemented encryption using Vormetric Transparent Encryption (VTE) to secure sensitive data.

●Create stored procedures and scripts to facilitate data manipulation and analysis. This helps in identifying and solving data-oriented problems.

●Collected and documented client specific requirements for integration with Afiniti architecture. Participate in the Scoping, Design and Production phases of various clients on a project and operational levels. Held responsible for pushing Sprints of future deployments to their Deployment stage.

●Performed troubleshooting to identify the source of various known and unknown incidents. Documented extensive Root-Cause Analysis reports detailing the cause, the effect and the solution of all incidents. Managing and creating tickets for incidents using Incident Management Systems like JIRA. Ensure that the clients receive resolution to incidents within a committed Service Level Agreement (SLA).

Selected Achievements:

Reduced client issues by 15%

Migrated Afiniti Appliances from MySQL to GreenPlum

Created various dashboards regarding tickets of each individual employee for upper management to increase efficiency by 40% Improved ticket quality and incident tracking average by around 80%

Automated various manual database related data-fetching tasks which increased productivity by 40%

Advanced tech skills & tools: Greenplum, MySQL, JIRA, Windows, Linux, VMWare, PuTTY, Confluence

Jazz Telecom

Expert Database Administrator (Full-time) April 2018 – June 2020

●Oversaw the management and upkeep of databases, assuring high performance and availability for crucial business operations.

●Created and put into place disaster recovery procedures, which cut downtime in the case of a system failure by 50%.

●Designed and implemented policies and practices for database security, making sure they adhere to rules and laws.

●Created backup and recovery procedures and regularly performed database backups to lower the risk of data loss in the case of a system crash or security breach.

●Collaborated with cross-functional teams to design & execute data integration initiatives, streamlining business processes enhancing data precision.

●Experienced in securing databases, such as implementing appropriate access controls for DB users and encrypting data.

●Maintained quality of service by establishing and enforcing organization standards through collaborative tools like JIRA

●Recommended solutions and follows standards on database physical structure, functional capabilities, security & backups.

●Maintaining data standards, including adherence to the Data Protection Act.

●Controlling access permissions, privileges to ensure data security and company compliance.

●Maintain database disaster recovery procedures to ensure continuous availability and speedy recovery.

●Deployed Oracle products on different platforms, including Grid Infrastructure, Oracle Real Application Cluster, Single Instance database, Data Guard, Golden Gate, and Cloud Control.

●Upgraded and migrated Oracle databases on various platforms and database versions.

●Implemented regular patching to fix bugs as recommended.

●Conducted proof of concept (POC) activities for different database features and options based on customer requests.

●Collaborated with Oracle Global Support for technical support and critical error resolution on SRV-1 & 2.

●Coordinated with various application vendors, operating system teams, storage teams, backup teams, and security teams.

Selected Achievements:

Managed 120 instances of Oracle, 250 instances of MSSQL and 7 instances of Cassandra with a team of 4 persons. Performed daily Backups for designated clients leading to timely recovery of the Database.

Achieved Client Database Uptime 99% of the time.

50% increase in system response time and a 60% reduction in database-related issues achieved through database monitoring and tuning program.

Mentored and developed team to improve their productivity and skills by an average of 25% over 2 years.

Set up an SP that would track user privileges across all databases creating ease in comparing user privileges in future.

Advanced tech skills & tools: Oracle, Cassandra, MySQL, MSSQL, Linux, PuTTY, PXF, Workbench, Toad, DBEaver, OEM

TechAccess

Technical Analyst (Full-time) December 2016 – March 2018

Al-Moeed Technologies

Technical Consultant (Full-time) March 2015 – December 2016

University of Engineering and Technology, Lahore, Pakistan 2011 - 2015

Degree: Bachelor of Science, Computer Science. GPA 3.28/4.0

Oracle: Oracle 11g Certified Associate, OCP 12c Upgrade

Cassandra: Apache Cassandra Certified Administrator

AWS: AWS Certified Solutions Architect – Associate Microsoft: Microsoft Azure Data Fundamentals

Database Administration: Oracle 11g / 12c /18c /19c, DB2 11.5, GreenPlum, Cassandra, Postgres, MySQL

Disaster Recovery: Oracle Data Guard, Oracle Golden Gate

Database Migration: RMAN, Dataguard, Datapump, db2 Export, Import, pg_dump

High Availability: Oracle RAC, Active-Passive OS-Cluster

Operating System: Sun Solaris, Red Hat Linux, Oracle Linux, Windows, IBM-AIX, HP-UX

Database Security: Standard auditing: DDL, DML, Privileges and SIEM integration

Exa-Data DB Administration: Exadata Quarter, Half, Full Rack

Functional Skills: Leadership, Data Analysis, Problem Solving, Project Management, Team Management.

Contact this candidate