Muhammad Hassan M. Email & Phone Number

Islamabad, Islāmābād, Pakistan

Collaborated with Vendors for T24 Implementation Oracle Transact Database on Exa-CC Played a key role in the implementation of T24 Core Banking System using microservices architecture, ensuring optimal integration with existing systems and enhanced service-oriented design.• Policy Development: Designed and implemented robust policies for Audit Vault and Firewall configurations to strengthen database security and compliance with industry standards.2• Proficient in managing both single-instance and multi-instance database environments with expertise in configuration, performance tuning, high availability, and disaster recovery strategies.• Multiple Time done DR activities between Single instance and Multi instance environment with Exadata and Exa-CC• Strategic Planning and Development: Led the planning, design, and implementation of database structures, driving enhancements that aligned with organizational growth strategies.• Team Leadership & Coordination: Managed a team of database professionals, providing guidance, setting priorities, and fostering a collaborative work environment to achieve operational excellence.• Performance Optimization: Proactively monitored database performance, identifying potential bottlenecks, and implemented solutions to optimize performance and minimize downtime.• Compliance and Audit Coordination: Acted as a liaison between internal/external auditors and IT teams to ensure compliance with all regulatory and security policies.• Designed and implemented a MongoDB sharded cluster architecture to handle high transaction volumes for the Infinity platform.• Set up and optimized a MySQL InnoDB Cluster for Infinity to achieve high availability and fault tolerance.• Implemented Microsoft SQL Server Always On Availability Groups to support business intelligence (BI) and reporting operations for T24 Core Banking Solutions.

Lahore, Punjab, Pakistan

Experiences in Unix-like system administration including Oracle Solaris, Oracle Linux, IBM AIX,and HP-UX.• Proficient in developing management or monitoring scripts by using Korn/Bash Shell and Perl.Can develop automatic monitor framework by using CRON jobs.• solid Oracle database administration skills and experiences in high-end telecom and financialenterprise environments (DB size from 2 TB to 60TB) across multiple industries includingdesign, development, implementation, migration, upgrading, maintenance of RAC, ASM, Data2Guard, GoldenGate and production support of complex database applications and huge datawarehouse system.• Experience with Oracle 11g/12c/19c new features: Flash-Back Recovery, Data Pump, ASM,ASH, AWR, ADDM, ASSM, ASMM, Automatic Undo Management, Grid Monitoring andRecycle Bin.• Experiences and solid hands-on experiences in installation, configuration, performance tuningand troubleshooting Oracle GoldenGate in Oracle-to-Oracle homogeneous environments andheterogeneous environments (including Oracle to Oracle and MySQL to Oracle).• Firsthand experiences in setting up Oracle Golden Gate one-way, two-way/bi-directional,active-to-active, and active-to-passive data replication with conflict detection and resolutions.Extensive skills in upgrading OGG 11gR2 to 12c, configuring OGG in RAC high availableenvironment.• Primary technical resources to upgrade Oracle GoldenGate from 11g to 12c and 19c inExadata machine environment. Design GoldenGate HA solutions by using Oracle 11.2.0.4 /19cCluster ware functionality.• Deep understanding Oracle Golden Gate internal mechanism. OGG new features such asIntegrated capture, native DDL capture, coordinate apply mode, multi-threaded replicate.Developed home-cooked OGG lag monitoring scripts and configured OGG monitoring plug-inin OEM (Oracle Enterprise Manager) 13c.

Lahore, Punjab, Pakistan

Monitoring the health of a database and ensuring that it performs optimally is an importanttask for a database administrator with OEM (Oracle Enterprise Manager) 11g/12c/19c. DellEMC, Spotlight. Tivoli and Zabbix.• solid hands-on experience and outstanding troubleshooting skills to setup, configure,monitor, maintain Oracle 11g/12c/19c RAC/ASM/Data Guard environments.• Highly skilled in SQL and PL/SQL Tuning, TKProf, Explain Plan. Expertise in monitoring andperformance tuning of Oracle database through tuning application, memory and disk by usingStatspack/AWR/ADDM/SQL Advisor.• Hands-on experience with Oracle Zero Downtime Migration (ZDM)• Familiarity with cloud computing concepts and Oracle Cloud Infrastructure (OCI) platform• Ability to troubleshoot issues during database migrations and resolve them quickly.• Excellent communication skills and ability to work effectively with cross-functional teams.• Capacity to manage multiple projects simultaneously.• Proven ability to work well under pressure.• Hybrid data Guard in oracle cloud infrastructure.• Experience migrating workloads to OCI• Experience provisioning and supporting OCI components (VCNs, Compute and Databasefamilies, FastConnect, PaaS Services)• Familiarity with Applications (E-Business Suite R12 on prem - on cloud) technology stacks aredesirable.• Installed and Configured SQL Server 2005/2008 R2/2012/2019 Servers in Development,Staging, and Production Environments.• Created databases, logins, roles, and granted appropriate permissions.• Created schedule jobs, alerts, activity logs, error logs to capture any possible errors.• Evaluated database performance and performed maintenance duties such as tuning, backup,restoration, and disaster recovery.• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policiesfor various categories of users.• Supported 247 production support and solved all kinds of critical problems.

Islamabad, Islāmābād, Pakistan

• Setting up different MySQL installations configuration, upgrade, and migration on Linux• Implementation of MySQL master salve, Cluster management and configurations andadministration, backing Up, Copying, and Recovering MySQL Databases• Oracle, MS SQL, MySQL Monitoring agent.• Exadata performance related issues and Exadata performance tuning• WebLogic domain configuration (creation, extending and removing)• Managed server configuration (creation, cloning and deletion)• WebLogic clustered configuration• WebLogic domain migration• Oracle HTTP server (11g, 12c) installation (Collected/Managed) and its integration withWebLogic• Coordinate with Oracle Support for issue resolving of FLEXCUBE facing in day routine and issuesof EOD• Supporting Oracle applications R12.1 and R12.9 (Installation, patching, cloning, upgrade,sysadmin tasks).• Experience in managing Oracle databases 19c on Oracle Exadata.• Oracle OEM Upgrade 13.4 to 13.5 and Database upgrade 12.2 to 19c• ODM database Administration and performance tuning.• Oracle cloud infrastructure database administration and implementation

Lahore, Punjab, Pakistan

• Oracle Database Security Assessment Tool (DBSAT)• Online Table redefinition for Purging of unusable spacesAvailability of database servers cross 24*7 for operations.• Data protection by ensuring backup and restoration policy• Managing critical Temenos (Core Banking Application) Database• Provide support in COB process running• Managing storage for archive logs and database• Managing IRIS system• Availability of Oracle Banking Digital Experience Capabilities (OBDX)• Managing Oracle Backups of more Than 30 Systems for daily, weekly, and monthly• Managing SQL server Backups of more than 25 servers for daily, weekly, and monthly• Provide support in critical data purging activities• Keep track of database growth on daily basis and make reports monthly• Tables with huge data converted to partitioned tables to maintain data• Managing user rights to avoid any compliance observation• Conduct database audit with the audit department• Restore RMAN backups of encrypted database• Provide support to application teams in on-going projects• Provide limited and secure data for UAT environments using export utility• Ensuring PCI-DSS compliance levels standards• Experience in managing databases on Oracle Exadata.• Experience in managing Oracle RAC databases on Exadata.• Experience in managing very high-volume/high-transaction databases on Exadata.• Oracle Audit Vault and Database Firewall with LINUX / Windows (MSSQL Server)• Oracle Database Security Assessment Tool.• Oracle Database Vault. (Realm creation, managing DB owner and Account Manager)• Oracle Key Vault. (Deployment of Key vault and integrated oracle database)• Oracle Software and Database Management should be able to operate on several UNIX/Linux.• Familiarity with Oracle database 11g/12c/19c.• Tuning of performance, power planning, and optimization of systems• Skills in database cloning, including Rapid clone.• Oracle Data Guard (Fail Over, Switch Over, Snapshot and FFO (Fast Fail Over))

Lahore, Punjab, Pakistan

Experience in Migration databases on Oracle Exadata from Exadata or VMs.• Experience in upgrading Banking databases IRIS and T24 (Temenos) on Oracle Exadata.• Experience in managing databases on Oracle Exadata.• Experience in managing Oracle RAC databases on Exadata.• Experience in managing very high-volume/high-transaction databases on Exadata.• Strong Linux skills and ability to write Shell or python or pearl scripts to perform different taskson Exadata.• Good experience in installing, configuring & managing RAC (19c, 12C & 11g) with ASM.• Involved in Planning, Configuration, patching and implementation of Engineering systems likeEXADATA and Oracle Database Appliances (ODA) and managing oracle databases on them.• Experience in Operating Systems like Linux (OEL, RHEL)4• Setup and configure databases using the practices described in Oracle Available Architecturefor High Availability• Oracle Audit Vault and Database Firewall (implementation and configuration of Oracle and SQLserver audits trails with audit vaults)• Oracle Database Vault (creation of realm, auth user and object with rules).• Oracle Key Vault. (Wallet Keys for oracle database)• Migration of Database 12c to 19c using dump utilities• Oracle Software and Database Management should be able to operate on several UNIX/Linuxflavors.• Installation, repair, patching, performance tuning of Oracle Applications R12.2.• Cloning databases for Oracle e-business Suite, Patching databases for EBS and Oracle.• Familiarity with Oracle database 11g/12c/19c.• Tuning of performance, power planning, and optimization of systems• Control of databases, troubleshooting, administration, backup and recovery, maintenance ofspace in a 24×7 development environment.• Skills in database cloning, including Rapid clone, manages oacores• Oracle Data Guard (Fail Over, Switch Over, Snapshot)• Transparent Data Encryption (TDE)

Karachi Division, Sindh, Pakistan

• Expertise in RDBMS S/W installation, database server builds, applying patches, upgrading,configuring, trouble shooting of SQL SERVER 2008R2/2012/2014/2016.• Expertise in Disaster Recovery plans by configuring Always On, Clustering, Log-shipping,Mirroring and Replication (Snapshot and Transactional).• Implementing High Availability in SQL 2012/2016 by configuring Always on Availability groupsacross Windows Server Failover Clustering.• Expertise knowledge in database encryption• Expertise in database Back Up, Restore, Recovery, updating statistics, Rebuildingand Reorganizing indexes, Defrag Tables, Replication, Linked Servers, and DatabaseMaintenance Plan.• Monitoring Instances, Configuring and Enabling alerts using Quest Foglight/App Dynamics orany other 3rd part tool.• Experience in query optimization and performance tuning. Experience in using SQL Profiler,Execution Plan, Performance Monitor and DBCC Commands.• Experience in PowerShell or SSIS to automate the day-to-day activities andtroubleshoot/enhance the existing scripts.• Monitoring/Troubleshooting Log shipping /DB Replication/Always ON.• Respond and Troubleshoot database related problems reported by customers.• Automate the routine tasks.• Preparing Knowledge articles and sharing with the team on day-to-day activities.

Multan, Punjab, Pakistan

• Implementation of database using Oracle EBS installation single or multi node installation• Full Architecture knowledge of Oracle Database including 19c• Maintaining and Supporting Oracle applications R12.1 and R12.2 (Installation, patching, cloning,upgrade, sysadmin tasks, workflow administration).• Maintaining and Supporting Oracle Database including version 19c (Installation &Configuration, upgrades, Security administration, Storage management, Patch management,backup & Recovery).• Planning and implementation of Disaster recovery solutions• Experience with Trouble shooting, Monitoring, Performance tuning of E-Business Applicationand database.• Experience with Oracle and with Unix scripting, crontab, managing Oracle Apps and database inUnix environment.• Experience with Oracle Grid Control, Oracle Enterprise manager 12c, 13c• Experience in DR setup and maintaining along with Oracle Data guard• Coordinate and collaborate with cross functional teams.• Coordinate and collaborate with 3rd party Service provider and Software Vendors.• Provide Project support to Development team.• Preferable but not mandatory to have experience with SQL Server database administration.• Ability to independently handling of database tasks and projects.• Database related new software evaluation, Upgrade evaluation and recommendation• Experience with automating DBA tasks