Mohammad N. Email & Phone Number

Toronto, Canada Area

Toronto-North York

• Administrated and Provided database support for Oracle 11g/12c RAC/ASM and NON RAC databases• Administrated and Provided database support for Microsoft SQL Server 2008, 2012 database• Migrated databases from 11g to 12c using RMAN,EXPDP and IMPDP utilities• Oracle Enterprise manager cloud control 12c and 13c for monitoring and performance tuning on all the production ,Development and QA database server• Configured and maintained RMAN backups through Tivoli Storage Manager(TSM) tapes for all the production databases• Trouble shooting the daily productions problems.• Applied Oracle patch Set Updates quarterly for Oracle databases • Monitoring DB growth and provided DB capacity planning and data retention policy for applications' expansion. • Database refreshes from Production to UAT, DEV environments using expdp, impdp and rman utilities.• Developed and implemented RMAN scripts and regular testing of RMAN and EXPDP backups but restoring it on the test server.• Creating databases, schemas, Managed tablespaces, database objects (tables, views, indexes etc),user security, roles and privileges• Installed ,configured and Administration of IBM Cognos BI 10.2.2 and TM1 Production and development environments• Developed Unix shell scripts to schedule all the database jobs such as RMAN, expdp and impdp • Utilized EM, SQLT,Automatic Database Diagnostic Monitor (ADDM) analyses data in the Automatic Workload Repository (AWR) to identify potential performance bottlenecks• Created a physical standby database from Oracle 2 Node RAC to non RAC • Assisted developers in tuning sql queries • Closely work with other team members to manage existing database instances and work with systems architects and Development team to design, Create database objects, deploy into production environment

Toronto, Canada Area

• Provided database support, performance tuning, and technology upgrades on Oracle 11g R2 Enterprise Edition 64 bit database for CAMH’s mission critical LAWSON ERP system• Provided support, process documentation and testing of database backup procedures and recovery. Ensuring appropriate backup and recovery procedures are in place and properly executed• Provided database support, performance tuning and technology upgrades on MS SQL server 2005/2008 standard and enterprise editions for corporate and web applications• Automated and performed Oracle database backups and databases refreshes (imp, exp, impdp, expdp, cold, hot and RMAN) using Unix Shell scripting and windows scripting• Monitored table space usage and pro-actively identify potential issues which can impact the database availability, performance, and data integrity• Utilized appropriate tools and procedures to optimize and monitor database performance• Tested, certified and installed release upgrades and revision-level updates to database software Troubleshoot/investigate any production database issues and provide migration steps/approach Develop, recommend, implement and maintain policies and best practices related to the databases, include integrity and recovery of the data• Created databases for corporate and web based applications in accordance with vendor recommendations and tools

Kuwait

• Provided maintenance and 24x7 Support of databases (Oracle 9i,10g,11g) in production, testing and development environments hosted on Unix servers (Solaris10,11) and Windows servers• Installed and configured Oracle Application server 10g and Oracle Fusion Middleware software on Solaris and Windows Platform.• Handled 60 Production Database and approximate data size was around 2 Tera • Installed Sql Server 2008 on Windows 2008R@ and configured full backups of the database • Configured physical standby databases to ensure business continuity• Monitored database performance via Automatic Workload Repository(AWR),ADDM, Quest Tools and Sql Tuning Advisor• Performed day to day operations of the Oracle DB’s like creating/managing user privileges, maintaining backups via the VERITAS backup solution on SL48 tape Library• Created database objects (Tables, Indexes, Sequences, Views, Triggers, Stored Procedures, Functions, Packages and Materialized views) in production Environment after extensive testing on backup environments • Worked closely with cross functional team members to identify their needs based on project and business goals, work with systems architects and Development team to design, Create database objects and their subsequent deployment into production environment.• Wrote, tested, implemented and maintained Custom procedures, stored procedures• Performed database refreshes and cloning of databases per customer requirements using RMAN, Data Pump and hot backup scripts.• Troubleshoot and resolve database and/or application problems encountered by end users.• Installed, upgraded and patching of databases from Oracle 9i,10g and Oracle 11g.• Supported databases on SUN clustered environment on M4000 sun servers• Provide on-call support in adherence to specific business and customer Service Level Agreements

Naperville,Usa

clients: National city , Sprint/Nextel, AG Edwards

Master'S Degree, Computer Science

Bachelor'S Degree, Computer Science