Basic Info

Mohammad Shahid Ahmed

12 years

NEW DELHI, India

Master's Degree

Experienced

Work Experience

Oracle DBA Programmar at Al-Sadhan Trading Co

Experience Details

Oracle DBA Programmar

IT/Software Development

Experienced (Non-Manager)

RESPONSIBILITIES – as a DBA
 Prepare DB server and Making strategy for backup and recovery as per the database level.
 Experience to Renovates/Upgrade old DB server.
 Experience to reorganized and sized DB objects to meet standards and improve performace.
 Experience of database restore from old server to new server.
 Directly Involved in Making disaster recovery plan.
 Troubleshooting problem regarding the database, applications and development tools.
 Able to Create/Configure/Convert or Migrate ASM instance as per the requirement.
 Experience to apply Database different Patches.
 Managing DB Tablespace/Datafiles in order to maintain normal operational work.
 Monitoring Database Health Daily or Monthly basis and performing SQL tuning in order to provide smooth running of DB for end user.
 Good working Experience on Toad, OEM and Other Backup reporting tools.
 Able to handle different ORA-Errors as per the instance requirement.
 Using Cloning or Duplicate database concept for testing the backup regularly.
 Identifying specific user activities by maintaining proper DB security concept.
 Performing upgrades of the database and software to new release levels
 Involved in performance monitoring and tuning of the database.
 Configuraing or Managing RMAN backup and making automated scripts for backup.
 Expertise in collecting and diagnosing the STATSPACK, AWR and ADDM reports.
 Rebuilding of Indexes, if bulk load of data is inserted.
 Enhancing end users understanding of database systems by conducting pre-implementation workshops, delivering group and individual training sessions and creating user-friendly training materials.
RSPONSIBILITIES – as a Developer
 Maintaining Payroll Software (Times HRMS) implemented in Oracle and Developer 2000.
 Preparing Bank File for Monthly and Partial Payment of Employees.
 Maintaining Finance Management Software implemented in Oracle and Developer 6i
 Control migration of programs, database changes, reference database changes and menu changes through the development life cycle.
 Customizing or adding new oracle forms and Reports as per the department needs.
 User Accounts Management: Creating User Accounts, Providing proper rights to the users
 Directly Involved in modifying oracle financial software to automate the account work in order to minimize the paper work.
 Directly involved to modify Payroll software to pay salary through Bank Accounts/payroll card.
 Developed many crystal reports using T-SQL, JDE Report Design.


Company Details

Al-Sadhan Trading Co

Riyadh, Saudi Arabia

501-1000 employees

Retail

http://www.al-sadhan.com/

Jun 2011 to Feb 2016 (4 years 8 months)
Oracle DBA at Mayor international Limited

Experience Details

Oracle DBA

IT/Software Development

Experienced (Non-Manager)

RESPONSIBILITIES:
 Installing Oracle software or Creating and Administrating database objects.
 Installing Operating system (Windows, Linux, Sun Solaris).
 Performing Daily/Weekly check list to know the health or status of DB.
 Regularly viewing the Alert log file to analyze the ORA errors.
 Used Export or Data pump utilities for the purpose of logical backup.
 Taking RMAN Backup Daily, weekly or Monthly basis.
 Using Statspack and AWR tools to gather statistics or report.
 Good knowledge of Data dictionary or Views to check different aspect of database.
 Maintaining Tablespace/Datafiles size to accommodate normal DB operation.
 Providing support for the smooth functioning of database to the developer


Company Details

Mayor international Limited (multinational)

delhi ncr, India

101-500 employees

Business Supplies and Equipment

http://in.kompass.com/c/mayor-international-private-limited/in717422/

Mar 2009 to Jun 2011 (2 years 3 months)
Software Executive at Planman Technologies

Experience Details

Software Executive

Business Development, IT/Software Development

Entry Level

RESPONSIBILITIES:
 Installing Oracle binaries or oracle database on Linux as well as Windows 2003 env.
 Creating new oracle forms/Reports as per the project requirements.
 Constructing or Modifying triggers, functions, stored procedures as per the requirement.
 Responsible for the dealing with the problems, bug fixing and troubleshooting.
 Taking end user system backup to secure their daily job work done.
 Installing required software for end user and troubleshooting their system issues.
 Security Features using Menu Roles and limiting the access of the end users
 All features of Reports Generation


Company Details

Planman Technologies

NEW DELHI, India

101-500 employees

Business Services - Other

http://www.contentratechnologies.com/

Jun 2006 to Feb 2009 (2 years 8 months)
Project Executive at Angels Solution Pvt. Ltd

Experience Details

Project Executive

Business Development, IT/Software Development

Entry Level

 Maintaining Web server and Managing Network connection.
 Preparing Metadata and uploading on to the Portal.
 Maintenance of F. T. P server and transferring the data received.
 Maintaining Daily Backup of site work.
 Creating and Managing User ID and providing proper rights to the users.


Company Details

Angels Solution Pvt. Ltd

NEW DELHI, India

11-50 employees

Business Services - Other

N/A

Oct 2003 to Feb 2006 (2 years 4 months)

Education

MCA in Computer

Education Details

MCA

Computer

IGNOU, India

B / Very Good / 75 - 85%

Master in Computer Application (MCA) includes Data Structure and Object Oriented Programming Computer Application System Programming Artificial Intelligence

N/A

IGNOU
2006 - 2008
BCA in Computer

Education Details

BCA

Computer

IGNOU, India

B / Very Good / 75 - 85%

N/A

N/A

IGNOU
2003 - 2006
College Diploma in Computer Science

Education Details

College Diploma

Computer Science

Gulbarga university, India

B / Very Good / 75 - 85%

Computer Organization RDBMS Datastructure & C Programming System Programming Electronics Digital and Devices

N/A

Gulbarga university
1996 - 1999
High School - Other

High School Details

Other

Abeeda high School

India

1997

B / Very Good / 75 - 85%

N/A

Abeeda high School
1997

Certifications

OCA
Jul 2010

Certificate details

OCA

Jul 2010

94 out of 100

https://education.oracle.com/pls/eval-eddap-dcd/ocp_interface.ocp_candidate_login?p_include=Y&p_org_id=1001&p_lang=US

OC0879054

Oracle

Oracle Certified Associate

OCP
Aug 2010

Certificate details

OCP

Aug 2010

93 out of 100

https://education.oracle.com/pls/eval-eddap-dcd/ocp_interface.ocp_candidate_login?p_include=Y&p_org_id=1001&p_lang=US

OC0879054

Oracle

N/A

SQL Expert
Aug 2010

Certificate details

SQL Expert

Aug 2010

93 out of 100

https://education.oracle.com/pls/eval-eddap-dcd/ocp_interface.ocp_candidate_login?p_include=Y&p_org_id=1001&p_lang=US

OC0879054

Oracle

Oracle 10g SQL Expert

Training and Courses

Training/Course Details

E-Business Computing

Aug 2010

C-DAC (Ministry of Electronics & Information Technology Govt. of India).

C Programming & Data structure Database technologies foundation of Web Technologies VB.Net and front End Project work

Training/Course Details

Oracle 10g Database

Jun 2009

DUCAT, New Delhi

Instruction led training for Oracle 11g/10g DBA Database over all Maintenance work Backup and Recovery using RMAN Tablespace and Datafile Management Monitoring DB Health and Users Activity Datapump and import/Export utility use Introduction to ASM and RAC

Training/Course Details

Hardware & Networking

Nov 2001

Jamia Community Polytechnic, New Delhi

Installaling OS & Different Applications, Trouble shooting & Managing Network System, Configuring Network Devices.

Training/Course Details

Computer Appplication & Programming

Jun 2000

NICE, New Delhi

MS-Office, Account (Tally), Photoshop, Page Maker, Corel Draw, C/C++ Basic, HTML

Training/Course Details

Diploma in Web Programming

Jan 2000

Krishna Computer Center, Gulbarga

C++, JAVA, FRONT PAGE, HTML, DHTML

Training/Course Details

Oracle Project Training

Nov 1997

Oratech Software Solution, Gulbarga

Inventory Management Order Processing System implemented in Oracle 7.1 and Developer 2000

Training/Course Details

Oracle Pl/SQL Developer 2000

Jun 2002

Intelligent Institution Technology, New Delhi

Writing and Executing SQL Queries Creating function, Procedure, Packages Creating or Modifying Forms Creating or Modifying Reports

This profile is not updated!
Last update more than 3 months ago.

Jobseeker photo

Profile Skills and Keywords

AnalyticalArabicBackup And RecoveryBusinessBusiness Services - OtherBusiness Supplies And EquipmentC#.NetComputerComputer Appplication & ProgrammingComputer ScienceDataguardDiploma In Web ProgrammingE-Business ComputingEnglishHTMLHandles StressHard WorkerHardware & NetworkingITLinuxMayor International LimitedMonitoring DB HealthOCAOCPOracle 10g DatabaseOracle DBAOracle DBA ProgrammarOracle DeveloperOracle Forms/ Reports ExperienceOracle Pl/SQL Developer 2000Oracle Project TrainingProblem SolverProject ExecutiveRACRMANRetailSQL ExpertSoftware DevelopmentSoftware ExecutiveTeam PlayerToadUpgration/MigrationUrduWeb DevelopmentWindows Server 2003/2008

Self-assesed Skills

Languages

English

English

: Fluent

: Intermediate

: Advanced

: Fluent

Arabic

Arabic

: Intermediate

: Beginner

: Intermediate

: Beginner

Urdu

Urdu

: Advanced

: Fluent

: Fluent

: Advanced

Tools and Technologies

Oracle DBA

Oracle DBA

: Expert

: Extreme - I love it!

:

5-7 years

RMAN

RMAN

: Expert

: High

:

5-7 years

Oracle developer

Oracle developer

: Advanced

: High

:

3-5 years

Toad

Toad

: Advanced

: High

:

5-7 years

Windows Server 2003/2008

Windows Server 2003/2008

: Advanced

: High

:

5-7 years

HTML

HTML

: Intermediate

: High

:

1-3 years

C#.Net

C#.Net

: Intermediate

: Medium

:

1-3 years

Linux

Linux

: Intermediate

: High

:

1-3 years

Web Development

Web Development

: Intermediate

: Medium

:

1-3 years

Fields of Expertise

Backup and Recovery

Backup and Recovery

: Expert

: Extreme - I love it!

:

5-7 years

Oracle Forms/ Reports Experience

Oracle Forms/ Reports Experience

: Advanced

: Extreme - I love it!

:

3-5 years

Upgration/Migration

Upgration/Migration

: Intermediate

: Medium

:

3-5 years

Monitoring DB Health

Monitoring DB Health

: Intermediate

: High

:

3-5 years

Dataguard

Dataguard

: Intermediate

: High

:

3-5 years

RAC

RAC

: Beginner

: Medium

:

Less than 1 year

Key Skills

Analytical, Hard worker, Problem Solver, Handles Stress, Team Player

Online Presence

http://shahiddba.blogspot.in/

Mohammad Shahid is looking for new exciting career opportunities… Please share…

Get Your own Wuzzuf Profile Now !

Employer? If you're representing an organization or an enterprise, Signup here for FREE to see Mohammad Shahid's full profile and find more great talent and professionals to join your team.