ANSAR AHMAD

C-***/*, Third Floor, Thokar No-*, Abul Fazal Enclave-II, New Delhi-25

Contact:+91-989*******, E-mail:ac19lu@r.postjobfree.com

Professional summary

Over 8+ years as a Oracle Application developer and 5+ years of experience as an Oracle Database Administrator having hands on experience in database administration, production support, installation, configuration, upgrades, patches, performance tuning, backup and recovery, cloning, space management, database security, migration and documentation.

Experience

Begapt Tech Solution Pvt. Ltd., New Delhi

Oracle DBA

03/2013 – Present

Environment: Oracle 11g, Windows, Red hat Linux 6.4, TOAD 11.6, MS Office, Import/Export, Data pump, RMAN, Oracle Enterprise Manager (GC), DataGuard, Golden Gate, ASM, AWR, ADDM, SQL* Plus, PL/SQL, SQL* Loader

Key Responsibilities:

Installation, configuration, maintenance and tuning of Oracle 11g and 10g on Red hat 6.4.

Successfully upgraded Oracle 10g (10.2) to Oracle 11g (11.2).

Involved in migration of Oracle 10g & 11g NON ASM TO ASM.

Monitoring System Resources, understanding and troubleshooting Database issues in Production Environment.

24x7 remote support and on call Database support for Database developers & end-users.

Experienced in implementing Oracle Database advanced security practices.

Created Users, Groups, Roles, Profiles and assigned users to groups and granted privileges and permissions to appropriate groups.

Manage users, privileges, profiles, schemas using Grid Control of Oracle Enterprise Manager (OEM)

Carrying out EXPORT and IMPORT operations on Oracle Database using the DATAPUMP utility.

Planning Backup/Restoration Strategy, Planning and scheduling Backups, taking Logical Backups (with Export/Import Data pump utilities).

Hands on Experience in Goldengate.

Database Sizing, Tablespace Management and UNDO Tablespace Management, Transaction Management and Security Administration.

Auditing Database.

Experience in cloning databases using RMAN tool.

Expertise in recovering the database. Performed complete recovery, data file recovery, incomplete recovery.

Automated the nightly RMAN backups for the Production and Test Databases in Crontab.

Experience in diagnosis and repair of failures with Data Recovery Advisors.

Experience in Configuration of Catalog database.

Diagnosis and repair of Physical and Logical Block Corruptions.

Hands on experience on Flashback Database.

Experienced in Design, implementation and generating documentation of Oracle 11g Data Guard on both physical/logical standby databases in high availability mode.

Configured Physical Standby database for 2 different Server using Data Guard.

Gap Resolution in Dataguard environment.

SQL tuning and Database performance tuning has been done based on reports generated by SQL Trace, AWR, ADDM and monitor the database performance on daily basis.

Assisted SQL developers to optimize the SQL queries and stored procedures.

Successfully Migrated Non RAC single instance to Real Application Cluster (RAC) database instances.

Adding & Deleting Nodes in RAC Environment.

Administration of Cluster using crsctl

Administration of RAC using srvctl

Troubleshooting NODE eviction issues.

Service Management & TAF in RAC.

Knowledge on Cluster Architecture, Cache fusion, Cache coherence, GRD and PI(Past Image).

Troubleshooting issues on ASM

Technocrats Eduserve Pvt. Ltd., Okhla village, New Delhi

Oracle DBA & Linux Faculty

04/2010 – 03/2013

Key Responsibilities:

Served as an Oracle Trainer and trained more than 100+ students who are pursuing Engineering in IT or pursuing M.C.A Or B.C.A

Also trained those working professional who want to make career in either Oracle developer or DBA

Also taken various corporate classes who want to upgrade their employee skills on different environment

Has developed and delivered oracle courses material based on Oracle University books for corporate classes.

Also trained Redhat Linux server for those students who are interested in Linux Environment.

Taking classes for Oracle 10g Forms & Reports, SQL, PL/SQL, DBA, Redhat Linux.

Enhanced end users’ understanding of database systems by conducting pre-implementation workshops, delivering group and individual training sessions and creating user-friendly training materials.

Upgraded study material in oracle 12c.

Given training in Oracle Database 12c Feature: Multitenant Database.

Cemex-Topmix, Dubai, U.A.E

Oracle Developer

03/2007 – 8/2009

Participation in a medium-size Oracle ERP application implementation through the full project lifecycle. Responsible for the design, construction, unit test, code review and bug fix of allocated modules to agreed time, quality and cost.

Duties:

Involved in the support, maintenance and development of critical systems.

Carrying out design, construction, review and defect analysis activities.

Responsible for database design and development and Application Tuning.

Defining and generating screen formats and report designs.

Providing suitably tested fixes to defects within the sanctioned delivery process.

Producing and updating relevant documentation.

Developing in accordance with policies regarding secure coding & standards.

Meeting clients face to face and on site to ascertain requirements.

Develop software in accordance with agreed design with consideration for usability, software quality and future maintenance.

Key Responsibilities:

Developed approximately 25 custom financial and auditing reports using Crystal Reports with T-SQL, GINCO, MS Excel and Access.

Experience of Oracle application interfaces including Oracle D2k, SQL Developer, SQL Loader.

Creation & Administration of all database objects, including tables, indexes, views, sequences, triggers, packages and procedures.

Developing application in Oracle for automating the process as well as improving upon productivity including development of script using SQL queries, PL/SQL Codes, Subprograms, Packages, Procedure, Function as well as Triggers.

Handling PL/SQL compile-time, Runtime errors, Debugging stored procedure for business logic modification. Database, PL / SQL tuning, performance monitoring and troubleshooting.

Software Design, Development & Implementation with Proficiency in Oracle 9i/10g, SQL, PL/SQL that includes Complete System Development Life Cycle from Analysis and Design to Implementation. Expertise in writing Packages, Stored Procedures, Functions, Views/ Materialized views and Database Triggers using SQL and PL/SQL in Oracle.

Hands on experience in Design, Development of End user screens & reports using Oracle Developer /2000 (Forms, Reports) and other Front-End software like VB.NET & ASP.NET.

Communicating to end-users and give solutions for Database problems.

Creation and Maintenance of User Roles and Privileges, thereby ensuring user level security for the database.

Documenting, writing and testing scripts.

Knowledge of object orientated analysis and design techniques.

Bee Enterprises, South Ex-II, New Delhi

IT Internship

06/2005 – 10/2006

Selected for competitive internship with software consulting firm. Learn to develop software through UML.

Key projects:

Developed several desktop application using VB.NET & Oracle database.

Developed intranet based application using Oracle Forms & Reports.

BVG Industries Ltd, OIA-II, New Delhi

Junior Accountant

01/2001 – 10/2006

BVG Industries is a laminated Wooden firm where worked as a Junior Accountant. Having proficiency in Tally ERP, Excel & Word.

Key Responsibilities:

Daily wise stock maintenance in Tally

Patty cash entry in Tally.

Daily wise reporting stock transaction on Excel sheet.

Documentation if any.

Education & Training

Sikkim Manipal University, New Delhi

P.G.D.C.A, Major in Computer Science

B.N. Mandal University, Madhepura

B.Com(H), Major in Accounts

5/2012

5/2001

TRAINING

Oracle Database Administrator (DBA), SQL Star International, New Delhi.

Oracle Real Application Cluster (RAC), SunMarss, Hyderabad

OCA & OCP certification From Oracle India

Two Year Diploma in Computer Application (DNIIT) from NIIT, South Ex-II, New Delhi

.Net technologies from SSI, Lajpat Nagar-II, New Delhi

MCP From IACL, South Ex-I, New Delhi

Technical skills

Operating System

Linux (RHEL 5.0,6.0), Oracle Enterprise Linux 6.5, Centos, Sun Solaris 9/10, Win 2000/XP/2003/2008 Server, MS-DOS

Database

Oracle 9i/10g/11g,12c, Oracle Apex 3.1, 4.2,MS SQL Server 2000, mysql

Languages

Visual Studio 2010, Oracle Forms & Reports 6i and 9i, Unix Shell Scripting

Others (Familiar)

Sun Cluster 3.0, Oracle Clusterware, VMware, wamp server, Nagios, OTRS, zimbra mail server

personal details

Father’s Name : Late Moti-Ur-Rahman

Date of Birth : 2nd January 1980

Nationality : Indian

Marital Status : Single

Passport No : L4625975

References: Available on request

Contact this candidate