Index - IT jobs in Dubai
|
| Next topic | Previous topic |
|
| AJMAL SUFIYAN
Mobile: +91-9902055844 E-mail: aszilli@yahoo.com
Working as Sr. Specialist (Oracle Database) at Wipro Technologies, Bangalore, India since July’ 2007.
Around 9 years of total IT experience including 8.0+ years as Oracle DBA on various UNIX platforms such as Solaris, AIX, SCO and Digital. One year of experience in Production Application Support.
Summary of Experience:
Ø DBA support on large production system in 24*7 support setup
Ø Experience of Oracle database versions 7.x/ 8i/ 9i and 10gR2
Ø Specialization in Oracle Database up-gradation and Patching
Ø Specialization in Data Guard Setup & Maintenance
Ø Database Capacity Planning
Ø Release Management
Ø Leading of DBA team in 24*7 support
Ø Proficient in IT Data Centre Practices
Ø Certified ITIL V3 Foundation Training module
Ø Excellent Communication & Interpersonal skills
Qualification (Professional):
Ø Master of Computer Science & Applications (MCA) from Aligarh Muslim University, Aligarh, India in 1998 with 74.6% of marks.
Ø Pursuing Post Graduate Diploma in Business Administration (PGDBA) from Symbiosis Centre for Distance Learning, Pune, India.
IT Certification & Trainings:
Ø Completed OCA (Oracle 9i DBA) Certification from Oracle Corporation.
Ø Completed 5 days training on Oracle 10gR2 (RAC) Training from Oracle India Ltd, Mumbai in June’ 2007.
Ø Completed 5 days training on Oracle 10g New Features from Wipro Technologies in September’ 2007.
Ø Completed 3 days ITIL V3 Foundation Training Program
Technical Skills:
Operating Systems : Sun Fire Solaris, IBM AIX, Digital 4.0B,Windows
Language : PL/SQL, SQL, HTML
Tools Used : TOAD 9.0, OEM 9.2.0.1.0, Veritas Volume Manager
RDBMS : Oracle 7.x, 8i, 9i & 10gR2
H/W Platforms : Sun Fire Series, DEC Alpha 2100, IBM-AIX
Directory Server : LDAP 4.12
Application Server : Tuxedo 6.5
WebServer : IPlanet 4.1
Storage Device : Sun StorEdge T300
Scripts : Shell scripting, AWK
Projects Undertaken:
# 01
Title : BP Global Internet Platform
Role : Sr. Specialist (Database)
Client : British Petroleum
Duration : July ’ 2007 to till date
Database : Oracle 9iR2/ Oracle 10gR2
Hardware : Sun Fire 240R
Operating System : Sun Solaris 8
Description : Wipro Technologies, Bangalore, India is managing computerized infrastructure of British Petroleum, UK. BP is having 5 different oracle 10gR2 databases running on Solaris 8 platform. Production database is running on cluster fail-over mechanism under active-passive mode using veritas volume manager. A data guard (physical standby) setup is also configured between Production and DR sites. Recently upgraded the oracle database from Oracle 9iR2 to Oracle 10gR2 with the latest interim & CPU (Critical Patch Upgrade) Oracle Patches.
Responsibilities:
Ø Planning of schedules & methodologies for Oracle Upgrade from development to production.
Ø Installation of Oracle 10gR2 software on Solaris.
Ø Up-gradation of Oracle database from 9i to 10gR2.
Ø Installation of Oracle Interim & CPU Patches.
Ø Performance of Application on 10g database.
Ø Implementation of 10g New Features.
Ø Preparation of technical Oracle upgrade document & run book.
Ø Presentation to Client with methodologies of upgrade process.
Ø New Data Guard Setup on Oracle 10gR2 environment.
Ø Provide availability of database as per SLA.
# 02
Title : UTI Investor Call Centre
Role : Database Architect
Client : UTI Mutual Fund, Mumbai
Duration : April ’ 2007 to June’ 2007
Database : Oracle 10gR2 (RAC)
Hardware : AIX
Operating System : IBM-AIX
Description : UTI Mutual Fund (UTIMF), India was having 4 registrars who were providing investor services for UTIMF schemes. UTIMF had decided to setup a call center for providing services to their customer over phone through a centralized database system. The System had multi-tier architecture with the front end in Java and Oracle 10gR2 RAC with two nodes as backend.
Responsibilities:
Ø Database Architecture study for all four Registrars.
Ø Designing of De-Dup Logic for consolidating the investor’s profile.
Ø Co-ordination with other departments for understanding their requirements.
Ø Co-ordination with Developers for better designing.
Ø DB related support to developers, testers etc.
# 03
Title : Generic Software
Role : Oracle DBA
Client : UTI-TSL, Central Data Centre, Belapur, Navi Mumbai
Duration : October ’ 2003 to April’ 2007
Database : ORACLE 8i
Hardware : Sun Fire 6800 Server
Operating System : Sun Solaris 8
Description : Unit Trust of India (UTI) was in need of a centralized Investor Management System to take care of its day-to-day operations. Generic Software (GS) has been developed by TCS to meet this requirement based on joint study conducted by Mc Kinsey & Co. and TCS. This system was designed to take care of sales and after sales services of UTI. The system had multi-tier architecture with the front end in Java and Oracle 8i as the backend on Solaris 8. Tuxedo 6.5 along with JOLT 1.2 is to serve as the middle ware. UTI Generic System was one of the largest applications in the country with database size of more than 1.0 Terra Byte. This system was implemented to provide centralized service for all kind of schemes. This system used to provide service for 50 different schemes through one application.
Responsibilities:
Ø Capacity Planning
Ø Release Management
Ø Incident Management
Ø Disaster Recovery Database Management
Ø Resource Management
Ø Backup Management
Ø Mentoring to junior team members
Ø Technical Presentation & Documentation
# 04
Title : Generic Software
Role : Production Application Support
Client : Unit Trust of India
Duration : Jan’ 2003 to September’ 2003
Database : ORACLE 8i
Operating System : Sun Solaris 8
Description : UTI had migrated data from decentralized system to centralized system. Since these were the financial data and there was need to make the data consistent and error free in all respect.
Responsibilities:
Ø To provide technical database support to end users
Ø Analysis & purification of data through SQL scripts
Ø Managed proper system reconciliation
Ø Provided MIS reports to the higher management
# 05
Title : Technology Upgrade Project (TUP)
Role : Oracle DBA & Unix System administrator
Duration : Dec’ 1998 to Dec’ 2002
Site : Unit Trust of India, Chandigarh Branch Office
RDBMS : ORACLE 7.2.3
Operating System : Digital Unix 4.0 B
Description :The TUP project was implemented at each of the 55 branches of Unit Trust of India across India for servicing investors. All branches are interconnected through WAN for inter branch transactions. This is de-centralized database, designed for managing two schemes of Unit Trust of India and Size of Database was 30 GB.
Responsibilities:
Ø Management of Unix users, Disk Space, file systems
Ø Planning, Scheduling for logical & Physical Database Backup
Ø Provided MIS reports to Management
Ø Monitoring database growth
Ø Performed data loading using SQL*Loader
Ø Daily incremental backup & weekly cold backup
Ø Manual changes in database through release process
Ø Weekly reconciliation of Unit Capital
Achievements & Awards:
Ø Nominated for award under “Best Individual Contributor” category by Wipro Technologies in January’ 2008.
Ø Awarded Best BP Operate in December 2007 by Wipro Technologies.
Academic Qualification:
B.Sc (Physics Hons) AMU, Aligarh 1994 74.05% Ist Div.
Intermediate (XIIth) U.P.Board 1990 68.40% Ist Div.
High School (Xth) U.P.Board 1988 61.84% Ist Div.
Personal Information:
Father’ Name : Sh. Abu Sufiyan
Date of Birth : 15th August 1973
Passport : B 3850439 (valid upto 04.10.2011)
Nationality : Indian
Marital Status : Married
Strength : Positive attitude |
|
|