monisahmedalvi

Monis Ahmed Alvi

Oracle Core DBA
  • monis.ahmed33@gmail.com
  • 9782707328

Objective

Oracle Certified Professional DBA with 1.2 years’ experience in Database Administration in large production environment and in Red Hat Linux. Experience in Installation, creation, configuration, backup and recovery, performance tuning, cloning, auditing, ASM, Import/Export, Expdp/Impdp (Data Pump), User, Roles & Profile Management.

Profile Summary

A position with progressive organization in which I will be able to contribute new and creative ideas that will utilize my current skills to their fullest potential while providing me with opportunities for technical, professional and personal growth.

Education

Aug 2011 - June 2015

Arya College of Engineering. & I.T
Bachelor of Technology (B.Tech)

June 2010 - July 2011

Shree Mahaveer Digamber Jain Sen. Sec. School
Higher Secondary Certificate (HSC)

June 2008 - July 2009

Shree Mahaveer Digamber Jain Sen. Sec. School
10th

Experience

May 2016 - June 2016

ERP OCEAN (B.A.V. Infotech Pvt. Ltd.)
Oracle Core DBA
    • Fresh 11g oracle DB and Grid Control Installation.
    • Oracle Server & Client Installation on Linux environments in version 11g.
    • Configuring and Managing Physical Standby Database Server, Cloning an Oracle Databases in Test environment from production database.
    • Creation of oracle users, oracle roles, granting privileges and profiles etc. Granting and revoking of privileges and roles and tablespace quotas.
    • Configure the database in not Archive log mode to Archive log mode, Added Disk and REBALANCED, Done a migration from NON-ASM to ASM.
    • Create ASM Disk & Disk groups and Maintaining Oracle ASM instance.
    • Managing redo logs, checking alert log and trace files for database performance. Check Alert Log errors and make necessary actions to rectify them.
    • Working knowledge of User Management, Table space Management & Flashback Technology, Auditing
    • Working knowledge of Control Files Management, Redo Log Files Management and Archive Log Management.
    • Perform logical backups (using Export/Import or expdp/impdp utilities).
    • Scheduled backups (like Expdp, RMAN, and Archive log).
    • Taken COLD & HOT Backup using RMAN & Manual method, Planning and Perform using online Backups (RMAN). Done a Recovery using RMAN & Manual method.
    • Routine DBA duties like analyzing schemas.
    • Working with DBCA, NETCA, NETMGR, ADRCI and Monitoring Diagnostic Report.

Oct 2015 - May 2016

Teknomics System Pvt. Ltd.
Dot Net Trainee
    • DDL : Create, Alter, Drop, Truncate, Rename
    • DML: Insert, Update, Delete
    • TCL: Commit, Rollback
    • DCL: Grant, Revoke
    • Constraints : Primary Key ,Foreign Key, Not Null, Unique, Check ,Disable & Enable, Views: Simple & Complex View (With Check Option,With Read Only), Sequences(NEXTVAL, CURRVAL), Index, Procedure , Trigger
    • Function : Single Row Function, Multiple Row Function, Joins : Equi, Natural Join, Self Join, Outer Join (Left, Right, Full)
    • ​Subquery: Single Row Subquery, Multiple Row Subquery, Pairwise Subquery, Non-Pairwise Subquery, Correlated Subquery (Update,Delete using Correlated Subquery), Scalor Subquery
    • Multitable Insert : Unconditional Insert All,Conditional Insert All,Conditional Insert First, Pivoting Insert
    • Set Operator: UNION & UNION ALL, INTERSECT, MINUS
    • Create & Managing User, Role , Privileges : SYSTEM PRIVILEGE, OBJECT PRIVILEGE, GRANT, REVOKE

Awards

2017

ORACLE CERTIFIED PROFESSIONAL
ORACLE

I Have Oracle Certified Professional in Oracle 11g .

2014

Developed Microsoft Window Store App
Microsoft

Created Microsoft Windows 8.1 Store App .

2013

Organizing Tehnika Naitus (National Level Inter College Technical Fest).
Arya College

Organizing Tehnika Naitus in College .

2013

Participated in Tehnika Naitus (National Level Inter College Technical Project Competition).
Arya College

Participated in Tehnika Naitus in College .

2012

Member of Computer Society of India.
Computer Society Of RTU

Personal Details

Skills

  • Oracle Core DBA ,
  • SQL Server 2012

Languages

  • English ,
  • Urdu ,
  • Hindi

Hobbies

  • Playing Cricket ,
  • Playing Football

Father Name

    Anees Ahmed Alvi

DOB

    05-Jul-1994

Address

    2830,Tiba Jogiyan Chowkari Ram Chander Ji , Jaipur , Rajasthan , India , 302002
Date
Signature