Mubeen Butt Email & Phone Number

Karachi Division, Sindh, Pakistan

PERFORMANCE TUNINGORACLE EXADATAORACLE RACRAC DATAGUARD RAC PATCHINGSQL SERVERMSSQL ALWAYS ON AVAILABILITY GROUPMSSQL FAILOVER CLUSTER INSTANCEPOSTGRESQL STREAMING REPLICATION

Karachi Division, Sindh, Pakistan

DBA (ORACLE/SQL SERVER)➢ Install, configure, and manage Oracle Database on Linux and Windows Environment.➢ Implemented a Physical Standby Database (ACTIVE DATAGUARD) in onpremises Oracle 19c, enabling seamless disaster recovery from OCIhosted primary database.➢ Successfully conducted the end-to-end upgrade process, flawlessly transitioning a standalone multi-terabyte Oracle 11g database to Oracle 19c.➢ Developed and implemented email alert system for monitoring tablespace, RMAN/Data pump Backups Logs, DB growth, and mount points across multiple Oracle databases using Bash scripting on Linux PowerShell Scripting for Windows.➢ Proficient in Oracle performance tuning techniques, utilizing Advanced Workload Repository (AWR) and Automatic Session History (ASH) analyses to identify and troubleshoot performance issues➢ Recommend and implement solutions based on performance analysis, ensuring optimal database performance and responsiveness.➢ Collaborate with cross-functional teams to proactively address potential performance challenges and enhance system efficiency.➢ Ensured rigorous data normalization through table creation and maintenance.➢ SQL Server Database Upgradation from 2012 to 2016 ➢ Proficient in SQL Server backup configuration, restoration, and scheduling, with expertise in implementing email alert systems for various SQL Server alerts across diverse environments.➢ Installation and configuration of Oracle Apex and ORDS and Oracle WebLogic server on Linux.➢ Oracle 19c installation on Oracle Cloud Infrastructure (OCI) with the latest patches, including the implementation of Transparent Data Encryption (TDE).➢ Power BI Reporting server configuration.

Karāchi, Sindh, Pakistan

DBA (SQL SERVER/ORACLE)➢ Installed and configured SQL Server on Windows environments.➢ Hands-on experience in SQL Server synchronization (Mirroring) and Configuring Certificate based Mirroring.➢ Maintain daily scheduled backups and ensure future storage requirements for the system.➢ SQL Server Encryption TDE Implementation.➢ Hands-on experience in SQL server database backups and restoration in different environments.➢ Hands-on experience on Oracle and SQL Server database patching.➢ Oracle Encryption TDE Implementation.➢ ORACLE Enterprise Manager (OEM) 13.5c Installation and Configuration.➢ Oracle Dataguard Broker Configuration.

Karāchi, Sindh, Pakistan

DBA (ORACLE)➢ Install, configure, and manage Oracle Database on Windows and Linux.➢ Installation and Configuration of Oracle Restart Grid Infrastructure with ASM disks on Oracle Linux.➢ Monitor scheduled backups and implement database backup and recovery methods through RMAN and Datapump.➢ Manage Production to DR synchronization and have hands-on experience in DR Configuration.➢ Enroll users, maintain system security, and create/manage tablespaces.➢ Conduct quarterly DR drills for assessing database switchover.➢ Provide 24/7 on-call and on-site support to end-users.➢ Automate database server for generating alerts and reports via email through Shell Scripting.➢ Maintain database inventory with machine specifications.➢ Troubleshoot and resolve database connectivity issues and space management.DBA (SYBASE)➢ Troubleshoot and monitor high query levels for stable performance of the core banking system.➢ Allocate and monitor devices, log segment storage, and plan future storage requirements.➢ Provide 24x7 support as part of a team in the production environment.➢ Verify, maintain, and troubleshoot database backups and recovery.➢ Deploy patches and change requests in the live production database.➢ Manage users and assign specific roles.➢ Monitor databases using Solar Wind and NMON tools and resolve database-level issues.➢ Optimize complex queries while troubleshooting their built-in indexes. SQL Developer➢ Utilized Joins and sub-queries to simplify complex queries involving multiple tables while optimizing➢ Procedures and Triggers in production.➢ Advance T-SQL and PL/SQL Query Writing for Ad-Hoc Data Extraction.➢ Test the Scripts on UAT servers before implement on LIVE environment.➢ Report Designing through Power builder.

Karāchi, Sindh, Pakistan

Karāchi, Sindh, Pakistan

Master Of Science - Ms, Data Science

Bachelor'S Degree, Information Technology

Intermediate, Pre-Engineering