Abrar Syed

• Managed outage calls and resolved critical situations related to database availability.
• Executed Data Guard builds, cloning, patching, and upgrades for Oracle 12C on Linux servers.
• Performed RMAN active database cloning and managed RAC and ASM configurations.
• Converted physical standby databases to snapshot standby and vice versa as needed.
• Handled manual upgrades of Oracle databases from 11.2.0.4 to 12C and 19C, including quarterly patching.
• Maintained data files, control files, online redo logs, and performed tablespace defragmentation.
• Monitored database performance, generated compliance reports, and addressed parameter violations.
• Resolved daily application issues by collaborating with development teams during SIT, UAT, and production environments.

Administered DB2 UDB 10.1 and 11.1, ensuring optimal performance and reliability.

Executed fix pack upgrades to maintain system integrity.

Monitored databases using db2top, snapshots, and event monitors to prevent deadlocks.

Utilized db2look tool for extracting DDL of database objects efficiently.

Bound DB2 packages with DB2 bind tool to enhance application performance.

• Managed user privileges to ensure secure access to databases.
• Provided on-call maintenance support for production databases, ensuring minimal downtime.
• Resolved daily user queries and maintained SLA compliance through effective troubleshooting.

Oracle Database Support:

• Good knowledge of Oracle Databases 11g, 12c.
• Responding to daily user queries.
• Troubleshooting using snapshot and event monitoring tools.
• Handling problem tickets and meeting the SLA, S (Service Level Agreement).
• Involved in 24/7 customer support (on-call support).

• Utilized Oracle Databases 11g to manage and optimize system performance.
• Responded to daily user queries, ensuring timely resolutions.
• Employed snapshot and event monitoring tools for effective troubleshooting.
• Handled problem tickets, consistently meeting service level agreements.
• Provided 24/7 on-call customer support, addressing urgent technical issues.

• Processed U.S.-based insurance policies efficiently and accurately.
• Cross-verified personal policy documents, including loans and mortgages, for compliance.
• Ensured accuracy of individual insurance policies through meticulous verification.
• Identified additional documentation requirements for successful policy processing.