Data Database Administrator

AHSAN AHMED KHAN

E-Mail: **********@*****.***, Mobile No 91-823*******

Oracle Database Administrator with RAC

Profile

àProfile Male, 43, Married

àDate of Birth 14 – July – 1972

àNationality Indian

àLanguage Known English, Hindi, Urdu and Arabic

àFamily details Dependants - 4 Members

àDriving License Saudi Driving License

àPassport Details Number - J9180825; Expire Date : 02-08-2021

àLast Company M/s S. S. Steel. Ahmedabad Gujarat

àLast Designation Database Administrator

àExperience As DBA 24 Months

àTotal IT Experience 16 Years

àExpected CTC: Negotiable

àExpected Location: India & GCC

àAddress Flat No. 503, C-Block M.B.Tower, Near Cama Hotel. Opp Pushpak Building, Khanpur. Ahmedabad, Gujarat, Pin 380001.

Introduction

Results Oriented, over 16 years experience in Information Systems. Broad expertise, including Data Modelling, Data Warehousing, Database Programming and Data Architecture. Special talents include development of System Implementation and Project Leadership.

Demonstrated proven ability to effectively communicate with all levels of management and lead complete project Worked on data warehousing projects from inception to implementation and delivered high quality solutions in a timely manner meeting and exceeding the business requirements. Skilled in debugging, troubleshooting, testing Web-based and client-server applications.

Deft in the management of operating system, network and applications with experience in configuring and troubleshooting various hardware and software related issues. Proven success in devising and implementing strategies aimed at, improvising network functioning and ensuring delivery of high standard of service.

Has acquired over the years a comprehensive understanding of database design and methodology from multiple perspectives. Hands-on experience in defining the information architecture and technology infrastructure along with the design of multi dimensional data models and the Business Intelligence delivery solutions.

Education Qualification

2014: Database Administrator 10g (OCP). From Oracle Corporation

1994: Diploma in Computer Application from Imarat Institute of Computer & Electronics

1995: Advance Diploma in computer Programming from Indian Computer Academy.

1996: Three years Bachelor Degree (Bachelor of Arts). From Babasaheb Bhimrao Ambedkar

Bihar University, Certificate Attested by external Affairs (New Delhi)

Software Skilled

Oracle 10g DBA, Oracle 11g RAC, Oracle PL/SQL & Oracle Developer2000.

MFG/Pro ERP Functional Consultant & Progress 4GL.

Foxpro2.6, Clipper 5.2, Dbase III Plus

Window, Linux, Unix etc

Worked Experience

1.From: 01 – January - 2014 to Till Date 24 Month (2 Years)

Company Name: M/s S.S.Steel, Ahmedabad

Job Title: Oracle Database Administrator.

Type of Job: Full Time

Present Role

Implemented 10g RAC/11g RAC R2 with ASM files system using Oracle clusterware.

Provided 24x7 supports for Production, Development, and test database.

Installation, Configuration and Administration of Oracle 11g RAC and Oracle 10g Database.

Refresh/Cloning of Database and applications for development and testing purpose.

Migration of all Oracle 9i/10g databases/clients to 11g R2

Migrated NON ASM databases to ASM databases.

Implemented backup and recovery procedures (Cold/Hot backups, RMAN Incremental backups & Import/Export)

Worked on Instance Tuning, Memory Tuning and SQL Tuning.

Written Shell scripts to Monitor activities like availability of database & listeners, space utilization, gathering statistic for the cost base optimizer, index rebuilding.

Good exposure to oracle technologies like AWR,ASM,Flashback and data pump import/export

Implemented Flashback Recovery for Oracle 10g Database which helped in recovery of data.

Partitioning of large tables for better performance and manageability.

Created users, roles and granted privileges according to the business requirements.

Expert in areas of Oracle 11g/10g SQL, SQL*Plus, SQL*Loader.

Experience with Building RAC, ASM, Flashback and RMAN.

Implemented with high availability features (RAC/ DG/ ASM/ Flashback/ RMAN)

Create and Maintain Roles and assign necessary privileges to users according to business rules in development environments.

Monitoring and Reorganizing Table Spaces / Tables / Indexes

Load data from flat files, files which come from Mainframes systems into Oracle database by using SQL*Loader

Managing table Spaces, Data files, redo logs, tables and its segments

2. From: 16 – March – 2003 to 10 – January – 2010 84 Month (7 Years)

Company Name: M/s Saudi Plastic Products Co. Ltd. (Saudi Arabia)

Job Title: MFG/PRO ERP Functional Consultant

Type of Job: Full Time

Previous Role

2.Implementation Support Responsibility for MFG/Pro ERP.

3.Responsible to define Site (1.1.13), Location (1.1.18), Product Line (1.2.1)

4.Responsible to define Inventory Account (1.2.13), Account Code (25.3.13)

5.Responsible to define Entity Code (25.3.1), Customer (2.1.1), Supplier (2.3.1)

6.Responsible to define Company Address (2.12), Salesperson (2.5.1)

7.Responsible to define System/ Account control File (36.1), Bank (26.13)

8.Responsible to define currency maintenance (26.1) & Exchange Rate (26.4)

9.Responsible to define Menu Password (36.3.1), User (36.3.18)

10.Responsible to define Cost Set (30.1) Item Site Cost (1.4.18)

11.Define Manufacturing Products Lots/Serial by Item.

12.Define Security group and User access Right.

13.Define Sharing Printer and user Access Right.

14.Responsible to train SAPPCO DAMMAM End User to usage MFG/Pro ERP Module

15.Responsible to Maintain Site Security, Entity Security & GL Account Code Security.

16.Responsible to Maintain Analysis Coding System in MFG/Pro.

17.Responsible to Preparation cs file to Progress cim file.

18.Create Progress Database / Tables & Index by using data Administrative tools.

19.Create various types of Sales Reports by using Progress Procedure editor.

20.Create various type of Report with MFG/Pro Report Writer.

21.Assign User Access right and Permission with respective ERP Module.

22.Assign General Ledger Accounting with Respective Product Line & Cost Center.

3. From: 25 - August - 1998 to 15 - March - 2003 60 Month (5 Years)

Company Name: M/s Saudi Plastic Products Co. Ltd. (Saudi Arabia)

Job Title: Programmer

Type of Job: Full Time

Previous Role

Perform day to day Backup and recovery as well as user troubleshooting.

Performing Upgrades and testing for system hardware and Software tools.

Frequently updates Antivirus McAfee Enterprise.

Frequently updates Window patch file as well as Window Service pack.

Assist new user and existing user on system usage.

Maintain IT Department, Department Request as well as Management Request.

Maintain Window 2003 Server / Active Directory & User Profile.

Maintain User Security & User Connectivity.

Maintain User Interface network TCP/IP Address.

Maintain all kind of Computer hardware, Printer, Modem, Scanner, Laptop etc

Maintain SAPPCO Dammam Web Pages. (www.sappco-dammam.com).

Configuring Exchange e-mail Box with respective User Access right.

Configuring internet POP3 e-mail box with respective User Access right.

Configuring Internet access right with respective user Machine.

Configuring various type of ADSL Modem for Internet Access.

Configure IBM compatible desktop with domain Access right.

Providing network access and permissions to files resources.

Installation and configure client with Domain interface.

Completed Payroll Project under Clipper environments for M/s Saudi Plastic Product Co. Ltd. Kingdom of Saudi Arabia.

4. From: 25 – August - 1996 to 25 – August – 1998 24 Month (2 Years)

Company Name: M/s Al-Fahad Investment Pvt.Ltd (New Delhi)

Job Title: Programmer

Type of Job: Full Time

Previous Role

Developed Investment Scheme Application for daily and Monthly Investment.

Create various type of Monthly Investment Report.

Create Investment application form and Report.

Create Investment Dividend Report Monthly & Yearly.

Assign User Access right and Permission with respective Program files

Installation and configure client with Domain interface.

Maintain all kind of Computer hardware and Software.

Maintain Window-NT Server / Active Directory & User Profile.

Maintain Management Request and IT Department.

Reference

Mr. Kaushal Halani

Oracle Database Administrator

Tata Consultancy Services (TCS).

Ahmedabad, Gujarat.

Mobile No : +91-972*******

Key Areas Covers

àApplication Architect: Managing the dynamics of the functionalities the composite architecture. Articulating the architectural vision, conceptualizing and experimenting with architectural approaches, creating models and component and interface specification documents, and validating software application against requirements and assumptions

àData Architect: Designing database infrastructure for analyzing state government budgeting process. Defining database requirements and designing data model. Re-engineering business process and conducting data integration between Solaris systems.

àDatabase Developer: Leading project for budget analysis and reporting systems development life-cycle. Planning project, analyzing client requirements, and documenting technical specifications. Using case tools to build the data model. Developing Oracle database stored procedures, packages, and triggers to process business rules and data logic.

àBusiness Analyst: Conducting gap analysis and providing consulting solutions to various clients in database design, database server configuration, data warehouse implementation, server performance tuning, and application tuning. Undertaking fault database management and trend analysis, conducting drive test & organizing testing of various call scenarios, feature codes & announcements.

àInfrastructure Support Installing, maintaining, troubleshooting network and data communication and software. Setting up & managing Local Area Network / Wide Area Network to maintain maximum network uptime. Configuring, upgrading, troubleshooting Servers, Desktops, Printers and Wireless Networking devices. Providing technical support to every department, conducting meetings with management & users to discuss the status of systems. Addressing queries regarding the Information System / software & extending onsite support to the users.

Contact this candidate