Raheem Ullah Email & Phone Number

Pakkistan

Managing 24×7 production support and ensuring to meet high availability of databases and data protection for business continuity, database high availability within and across the data-centers• Automated scripts using Python migration of data from mysql and IBM informix.• Installation, configuration and upgrades the database servers (Oracle,Informix,MySql, PostgreSQL)• Apply database patches and upgrades the database versions.• Database Backups Automation, Management, Scheduling and recovery of databases instances from backups• Managing database users, Creating and Assigning Roles to database users• Implementing different backup strategies(online backup with ONBAR/ONTAPE backup for IDS Informix databases,RMAN for Oracle databases, MySQL Enterprise backup for Mysql databases) • Configured HDR and RSS for IDS Informix database servers ,Standby using Data Guard for oracle database servers, and Master slave replication for MySql database servers.• Testing of new database versions, releases and patches• Database Federation, Clustering, Replication and disaster recovery management• Designing, testing and implementation of alert based monitoring system• Development and implementation of shell scripts for management of tablespaces• Designing & development of automation project for new client's database instance setup using shell scripting• Responsible to avoid performance regression by implementing indexes, table partitioning and index partitioning.• Database performance Tuning and SQL Query Optimization.• Database security, auditing, log miner, IP based connection restriction to Database, etc.• Providing and implementing solutions for database archiving & purging• Contacting database vendor for technical support

Lahore, Punjab, Pakistan

• Install, Configuration, Administration and Management of Oracle 10g Databases for number of clients.• Deployment of Oracle Forms and Reports applications on the Application Server 10g.• DR Solutions: • Oracle Expdp & Impdp, Hot & Cold Backup• DevelopedAutomation scrips for routine backup, logfiles backup and Database Monitoring.• Responsible for Oracle Database Real Time performance monitoring, database troubleshooting & tuning, database emergency response/DR, and performed on call and support rotation responsi-bilities.• Implants techniques of database security including slandered auditing, database auditing andfine grained auditing (FGA).• Writing functions,procedures and triggers using PL/SQL• Oracle stack like Forms Oracle 6i/10g/11g and Reports Oracle 6i/10g/11g. Proficient in SQL, PL/SQL, Stored Procedures, Functions, Triggers,Views, and Exceptional Handling.• Partition of oracle database tables, Storage Management of oracle data files and tablespaces. • Writing Database Triggers, Packages & Procedures to implement standards & business logic.• Customization's in Standard Modules of WIZ-ERP.• Development of WIZ-ERP Reports standards