Description

 

                                                       

Mohd Sajjad Ali.

Ph:00974-Show number77181466

Email:[email protected]

 

Meticulous, highly accomplished professional with 4 Years 6 months extended experience as Oracle DBA and expertise over Oracle Database/Applications Administration, handled various projects with Oracle 10g/11g on various platforms. Experienced over troubleshooting issues in database tier, and working knowledge of Linux and good exposure to network concepts. Result oriented decisive leader to maintain high quality standards to meet challenges of this fast-paced, high-turn industry. Ability to work in both independent and collaborative work milieu. Looking for an growth oriented opportunity in any reputed IT Industry at a level of Rac DBA and to be proven as asset of the organization with the possessed capabilities & abilities.

 

Professional Experience

 

Vess Technologies & Solutions Pvt. Ltd.                                                                              September 2010 – Jan 2015

Designation :   Oracle Core Dba

 

 

1. 1.   Project Details:

 

 

 

Project                :Support & Maintenance

Client                  : IICT (Indian Institute of Chemical Technology)

Designation       : Core Dba on OEL Linux and Red Hat Linux

 

Key Highlights

 

• Configured Datagaurd with DGMGRL utility mode is maximum performence
• Done switchover for couple of times for reporting purpose.
  • Exporting and Importing database backups using Exp&Imp and EXPDP/IMPDP utilities.
  • Creating and monitoring the tablespaces, allocating tablespaces for users.
  • Creating users with restricted access with required privileges.
  • Creating profiles and attaching them with users and monitoring the users.
  • Experience in Configuring and managing backup through RMAN utility.
  • Experience in cloning the databases through Hot/Cold and RMAN utility.
  • Experience in RMAN configuration using recovery catalog.
  • Experience in Hot/Cold Backup and Recover the Database when required.
  • Experience in configuring ASM Disks &ASM database creation.

• Creating and managing database objects like tables, views, and indexes.

• Knowledge on Oracle Database performance-tuning services with EXPLAIN PLAN, TKPROF, AUTO TRACE, AWR& ADDM.
• Experience on DATAGUARD and Create and maintaining Physical standby database.
• Troubleshoot the issue as and when required.

• Analytical and able to adapt to new environments and learn new technologies quickly.

 

 

Roles and Responsibilities:

 

• Created new databases and users: set up backups, export, and other monitoring scripts using RMAN and for recovery strategy.
• Creating, granting and monitoring user access rights and privileges and roles.
• Maintain user access, space management, and database security.
• Checking of Alert log and Trace files to monitor the database on a daily basis.
• Created and maintained database entities included tablespaces, data files, redo log files, rollback segments and renaming/relocating of data files on servers.
• Provide technical support for database maintenance.

 

1. 2.   Project          :        Production Support

Client                  :        SKS Microfinance

Designation       :       Oracle Core Dba, Red Hat Linux

_____________________________________________________________________________________

­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­Description:

 

SKS uses the group lending model where poor women guarantee each other’s loans. Borrowers undergo financial literacy training and must pass a test before they are allowed to take out loans. Weekly meetings with borrowers follow a highly disciplined approach. Re-payment rates on our collateral-free loans are more than 99% because of this systematic process. SKS also offers micro-insurance to the poor as well as financing for other goods and services that can help them combat poverty.

 

 

 

 

Roles and Responsibilities:

 

• Configured OEM on 10g and 11g databases.
• Created users with OEM and with SQL
• Assigning appropriate privileges with Developers.
• Change the DB name with NID Utility.
• Checking the alert logfile continuously for any database related issues or warnings.
• Configure Datagaurd with Maximum Performance Mode.
• Granting roles and privileges with users.
• Dropped database for couple of times.
• Created different DB block size according the client requirement.
• Configure non ASM to ASM database on Test ,Dev and Production database.
• Gathering statistics of Dictionary level and Database level.
• Generated Awr Report to know hit and Miss ratio of the BD buffer cache.

 

 

 

Key Highlights

 

 

• Installed oracle server 10g on Windows 2003, Linux 4.0 & 11g on OEL 5.
• Database migrations across platforms.
• Applied Database Patch sets [Ex: 10.2.0.1,10.2.0.4 , 11.2.0.1]
• Applied patches using Opatch utility.
• Installed Database CPU Patches..
• Upgraded Database from 10g to 11g.
• Scheduled RMAN backups.
• Cloning of Oracle databases including oracle home.
• Schema refreshes across instances,
• Scheduled Daily/weekly backups.
• Monitoring/Resolving Database alert log based on mail alert.

 

1. 3.   Project                  :        Implemenation

Client                            :        Unity Bank Plc, Nigeria

Designation                 :        Oracle DBA, UNIX

­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­Description:

 

Unity Bank is Nigeria's leading retail bank. Unity Bank has 216 business offices spread across the country and is Nigeria's 7th largest bank by business locations. Unity Bank has subsidiaries covering Insurance, Pensions Fund Management, Share Registration and Stock broking. Unity Bank is strategically positioned to provide efficient, customer-oriented financial services and products for the retail end of the Nigerian/Regional market. These includes: Consumer, Retail  & e-banking, Commercial Banking, Corporate Banking, Operations & Services, Public Sector financial services, Investment and International Banking, Structured Trade Finance with active involvement in the Shipping, Telecommunications and Oil and Gas Sectors.

 

Roles and Responsibilities:

• Creating and monitoring the tablespaces, allocating tablespaces for users.
• Creating users with restricted access with required privileges.
• Creating profiles and attaching them with users and monitoring the users
  • Experience in Configuring and managing backup through RMAN utility.
  • Experience in cloning the databases through Hot/Cold and RMAN utility.
  • Experience in RMAN configuration using recovery catalog.
  • Experience in Hot/Cold Backup and Recover the Database when required

• Creating and managing database objects like tables, views, and indexes.

 

 

Computer Proficiency

 

Languages                          :       SQL

RDBMS                              :       Oracle 10g and 11g

Oracle Tools and Utilities       :       Telnet, Putty &VNC Server

Operating System                :       Red Hat Linux A.S 3.0 and A.S 4.0, Windows

XP, Windows server 2003

 

Academic Qualification

 

 

Bachelors                           :         B. com Jagruthi Degree college.

 

Senior Secondary                        :         LFJC 2004.

 

10th Standard                      :       Dynamic Model High School.

 

 

Personal Details

 

 

Date of Birth                               :       5th May 1988.

Languages Known                        :       English, Hindi, Urdu.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

DATE:                                                                       (MOHD SAJJAD ALI)                                   

 

Information