Associate Manager Databases
Allied Bank
Total years of experience :6 years, 0 Months
• Database Administration, Implementation, Performance monitor and Tuning of more than 30 critical production databases with Oracle Database 11g/10g/9i, MS SQL Server 2005/2008/2012, MySQL running on LINUX, Windows platforms having databases of different sizes ranging up to 7+ TB
• Administration of Production databases for application like Temenos T24 Core Banking Application, ATM Application, Internet Banking Application, Oracle Financial Services, Anti Money Laundering AML, Oracle BI Discoverer, Oracle Enterprise Performance Management 11.1.2.0 (Hyperion Application), HR Application, Personal Loan Application and others.
• Administration, Management and Performing Backup and recovery of databases via RMAN
• Export and Import the Production databases schemas on different Test databases with Oracle Data pump.
• Up-gradation of Oracle database from older version (10.2.0.4, 11.2.0.1) to updated version (11.2.0.4)
• Management of Linked servers & DB-Link to SQL Servers and other databases such as Oracle
• Management of Oracle Enterprise Manager 12C for centralized monitoring of hosts, databases
• Linux shell scripting and windows Batch File Scripting for database and OS routine tasks
I have worked with Teach Access Pakistan which is a vendor company so my work is not limited to any Oracle product.
Oracle Database Administration
Logical Backup - Datapump
Backup and Recovery with RMAN
Physical Data-guard
Oracle Golden Gate
Oracle Golden Gate Veridata
Oracle ASM
Oracle Real Application Cluster
Oracle OEM 12c
Oracle RUEI
24/7 Operational support and proactively resolving system issues
support business to maintain their KPI’s. Gathering regular feedback and monitoring customer satisfaction.
Handling Daily end to end operations both at system-level and Application-level.
Handling Day-to day ICDB, CCDB, SEGDB maintenance, user operational and system operational tasks (segmentation, Data purging,
monitoring system parameters i.e. table spaces, schedulers etc.) in an efficient way.
Design and develop contact center operational document as Employee
Orientation Document, checklist/Steps for handling Operational issues more precisely and effectively i.e.
IC-Chain Restart, segmentation process, single pager media gateway cards info, single pager complete system-level info etc. to reduce time for issue resolution.
Managing Applications/Databases/ System state offsite and regular backups in efficient manner. Includes CMS, ACM, AES, ACR Postgres, VPMS, and ACME. Handling and create policies and media-groups for offsite backups, handling MSL operations though GUI and through scripting.
Monitoring VDN's, AIC & ACM Alarms, Call recordings, Citrix, contact center hardware infrastructure health check.
CITRIX Environment management with proactive support to maintain its 100% availability.
Systems and Automated Scripts Alerts Monitoring for instant troubleshooting where required.
Systems Reports Development, Automation and Scheduling. Systems Processes Automation including Documentation (automated processes technical detail and related SOPs).
Maintenance Procedures, SSIS and Scripts Development for Applications Optimization without Impact on Availability.
Scripts Development and SMTP configurations of AVAYA Systems to Monitor Systems Proactively.
Recording system calls restoration procedures administration to ensure system performance and sufficient disc spaces for upcoming calls
24/7 Oracle FLEXCUBE Technical Support to FLEXCUBE Core Team
Communication with Oracle Financial Services Software Global Support
Performance Tuning of oracle databases & Applications.
Import & Export of oracle databases
Completely automated the migration procedures
Write PL/SQL and UNIX shell scripts to automate database functions
Experience of Managing Oracle ASM on SAN Storage Devices
Monitoring and supporting day to day activities of the production and development databases
Plans and implements backup and recovery of the Oracle database
Create or clone the Oracle Instance and Databases on ASM. Perform database cloning and re-location activities
Excellent skills in troubleshooting Oracle Database and query issues
Refresh and Clone Databases as per customer requirements
Database backup/recovery using RMAN
Systems and Automated Scripts Alerts Monitoring for instant troubleshooting where required
Managing table spaces, data files, redo logs, tables and its segments
Managing Users, Privileges and Roles.
Creating and Assigning Role and Privileges to New Users according to
Install Oracle software and patches
Write script to monitor the database with shell and PL/SQL code
Physical Database Backup and recovery (Hot and Cold Backups) and logical Backup
Technical Support in End-of-Day
Checking of alter/log files for RAC instances and Database
Configure Enterprise Manager on database server.
Documented the process for implementation in production and staging environments