MASROOR HUSSAIN KHAWJA

E-Mail: h4iy6x@r.postjobfree.com ~ Mobile: +91-988*******

INFORMATION TECHNOLOGY PROFESSIONAL: Business Assistance & Techno Managerial

Highly accomplished and deeply driven with a successful career of over 9 years in Oracle Database Administration, Performance Tuning, Backup and Recovery, Oracle Data Guard, DB2 administration, Solaris administration, Storage concepts, Capacity Planning, leadership, Team Building and people management qualities. Proven ability to tackle and succeed, in all endeavours from business development, team management and providing technical guidance, troubleshooting and root cause analysis.

Functional Specialization:

As a team lead to own all the DBA operations (Oracle, DB2 and SQL), provide technical guidance, client interactions, team building and people management and ensuring strong handshake between onsite – offshore teams. As a leader build and motivate the team for organisational and personal growth. Ensure 100% SLA achievement with highly satisfied customer.

Well versed with service level agreements and ITIL framework (service delivery, Incident, Change, problem, availability, capacity, security, configuration and asset management).

Ensure the compliance to customer processes like service, Incident, Change problem management etc, and initiate, drive and implement service improvements.

Playing lead technologist role in architecting highly scalable, fault-tolerant multi-tiered enterprise class database solutions.

Responsible for gathering performance requirements from DBA and OS teams and provide and build strategies and direction in getting appropriate solutions/technologies implemented. Planning capacity for Servers and Storages as per business requirements.

Assisting DBA teams in Database performance analysis, diagnosis and tuning (Sql Query Optimization, Storage and Network performance, CPU and Memory tuning, IO Load balancing etc). Participate in capacity planning, trend analysis, performance forecasting exercises and propose recommendations to meet the ongoing performance and scalability demands.

Size and forecast Database Servers (Oracle, DB2 and SQL Server) based on transaction volumes, usage, growth, the response time and Business requirements. Perform research, debugging, benchmarks, proof-of-concepts, functionality and scalability testing on various database technologies as required.

Designing and executing test plans, SIT, UAT and gap analysis to ensure that business requirements and functional specifications are tested and fulfilled.

Lead role in planning and implementing the Disaster recovery using Oracle Data Guard and other technologies. Framing strategies for Disaster Recovery, including planning and recommending servers, Storages, backup software’s for backup and recovery solutions to ensure high availability, zero data losses and business continuity.

Domain Specialisation: Banking

Strong Banking knowledge with in depth knowledge of Indian Banking Operations and Finacle software’s developed by Infosys, widely used by many of the Indian Public and Private Sector Banks like ICICI, PNB and many other national and international Banks across the globe. Hands-on experience of migrating Manual banking branches to computerized branches running on Finacle software.

TECHNOLOGY SNAPSHOT

Hardware Environment SUN, V280R, V280R, V490, V880, V890, V6800, V6900, 6320 & 6920 Storage

Operating Systems Solaris, Windows 2000/2003 Server, Windows 95/98, XP, NT,

Programming Languages FORTRAN, C, C++, Visual Basic, SQL, PL/SQL

RDBMS/DBMS ORACLE 7.x/8.x/9.x/10g/11g

Other Tools Visual Basic, SQL*Plus, SQL*Loader 6.0, TOAD, Remedy

System Administration V245, V480, V490, V880, V890, V6800, V6900 Servers 6320, 6920 Sun

Storage

TECHNICAL SKILLSET

Product Development Database and Server Architecture Capacity Planning

System Development Life Cycle (SDLC) Database Administration Data Replication

Installation & Management Backup & Recovery of Databases Disaster Recovery

Installation, configuration and creation of single instance as well as RAC databases:

- Proficient in installation, migration and upgrade of oracle database on various platforms (To various releases) such as Solaris and Windows platforms.

- Creation & administration of all database objects, including tables, indexes, views, stored Procedures, functions, sequences, packages etc.

- Application of CPU, bug fixes and other patches

Performance Tuning:

- Analyzing data base performance by studying alert log files, trace files and monitoring database processes and session activities and wait events.

- Application tuning which involves evaluating the execution path and cost of execution of SQL Statements and rebuilding the different kind of indexes, computing statistics by analyzing the data.

- Instance Tuning: Configure and manage SGA structure components size in order to minimize SGA related tuning problems and wait events.

- Physical Database Tuning: Analyze and configure physical database structure. Using AWR and ADDM to find the bottleneck and tune database in terms of Query/CPU/Memory/IO.

- Tkprof, Statspack, autotrace tools to dig out the bottlenecks in database and achieve the optimum utilization of resources

Backup and Recover:

- Configuration of RMAN backup and taking disk and tape backup using RMAN

- Recovery and restoration of databases using RMAN and non-RMAN methodologies.

- Taking IMP and EXP backups

- Taking Hot and Cold Backups

- Recovering database from Cold and Hot backups using archival logs

Oracle RAC design and implementation and testing with load balancing

Data Guard for setting up Standby databases

Data Pump, for taking EXP and IMP backup

Data mining Using LOG MINER

Oracle 10g Flash Back recovery and Recycle bin Options.

Installation and configuration of Oracle Enterprise manager for centralized monitoring

Upgradation and Migration of Databases, oracle 8i, 9i and 10g.

Capacity Planning as per business requirements

DB2 UNIX Administration

Installation and configuration of DB2 Software and creation of DB2 databases

Creation of tablespaces and all other database objects as per business requirements or database design

Monitoring, Administration and troubleshooting

Database upgradation

Backup and recovery

System Administration

Installation and configuration of Solaris and SCO-UNIX. User management on SCO-UNIX and Solaris

Taking regular backup of server / database information and plan efficient storage. Ensuring maximum server uptime.

Creation of Volumes on SUN Storages and defining RAID levels. Configuration of database client at Legato and Veritas Level.

Mapping Storages Volume to Servers and creating file systems. Monitoring and maintenance of file systems. Capacity planning for Servers and Storages as per business requirements

Framing strategies for Disaster Recovery Management, including planning and designing servers for back up and recovery of database information.

KEY CAREER CONTRIBUTION with PROJECT DETAILS

Nov’07 – Till Date Wipro Technical Consultant

Oct’08 – Sep’10 Wipro Profile: Database Lead

Deputation: Standard Bank of South Africa, Johannesburg

HARDWARE: Fujitsu Siemens F1500, SUN m5000 and EMC Storage

OS: Solaris 10, Windows, AIX

DATABASE: Oracle 10g, DB2 V8&9, SQL Server 2000 and 2005

As a database lead own all the database services and act as a single point of contact for all the domains and ensure that 100% SLA customer process adherence is achieved.

Handle all new projects and new implementations and review Database domain SOPs.

Review and approve major database changes with action and rollback plans.

Take active part in Capacity planning, Trend analysis, Backup Strategy and DR Drills.

Handle database performance issues and troubleshot major/complex/recurring problems.

Initiate service improvements as automations, solving major problems, recurring issues, migrations to latest database versions and maximum adherence to customer processes and bring in best practices.

Handle all the Escalations and drive them till closure with customer signed-off root-cause-analysis.

Publication of weekly, monthly and Quarterly reports to customer and chair monthly Database review meetings with Customer and prepare and track the MOMs.

As a database lead act as people manager as well and ensure perfect handshake between customer, onsite and offshore teams, arrange trainings and help them in achieving their professional goals.

Project: Implementation of SFRAC with two node cluster

________________________________________

May’10 – July’10

Hardware: Fujitsu Siemens F1500, SUN m5000

Storage: EMC Storage

Os: Solaris 10

Database: Oracle 10g - 10.2.0.4

Role: Project Lead

Team size: 6

Covered all aspect of the project covering:

o Coordination among various teams for complete activity

o Drafting an action Plan for the complete activity and negating all the dependencies and distributing work to different teams and ensuring well coordination and timely delivery.

o Ensuring Installation and configuration of:

LAN cards, HBA cards, Storage disks and IP addresses

Solaris 10, Veritas Software and Veritas Cluster

Installation of Oracle Cluster (10.2.0.2)

Installation of Oracle binaries (10.2.0.2)

Application of 10.2.0.4 patch set

o Creating a test database to verify the setup.

o Configuration of listener and tnsnames in RAC environment.

o Migration of databases from single instance to RAC instance.

o Running various test cases in coordination with OS and Storage admin teams.

o Ensuring successful testing of all the databases and sign off from Customer.

Other Projects at Standard Bank of South Africa

________________________________________

Nov’09 – Mar’10 Team Size: 4 Databases: Oracle, SQL and DB2 UDB

Implementation of backup strategy with Disk backups using Data Domain from EMC for Oracle, DB2 and SQL servers across all Test and Development environments. Verification of database recoverability for all the database domains

________________________________________

July’09 – Sep’09 Team Size: 3 Database Versions: 10.2.0.4

Installation and configuration of Oracle Enterprise manager for centralized monitoring of all oracle databases. Addition and configuration of all databases to OEM. Defining policies and thresholds for monitoring and alerting purposes

________________________________________

March’09 – May’09 Team Size: 3 Database Versions: 10.2.0.4

Installation and configuration of connection managers in a load balancing fashion and its rollout across all oracle based applications. Coordination with Business for getting the downtime.

Since Nov’07 – Sep’08 Wipro Profile: Manager Operations

Deputation: Gurgaon, Max New York Life Insurance

HARDWARE: SUN 6800 IN cluster, V890, V880, V480R, V240R, 6140 and 6130 Storage

OS: Solaris 10, Solaris 9, Solaris 8

DATABASE: Oracle 10g, Oracle 9i, Oracle 8i, SQL Server 2000 and 2005

Backup Tool: Veritas Netbackup

As operations manager performed below activities:

o Own all the database services, OS and Storage services and backup services.

o Ensure 100% adherence to signed SLA with Ticket analysis for P1 and major P2 tickets and ensure root-cause-analysis is done for all P1 tickets and signed-off with customer.

o Handle all customer escalations and ensure proper oral/written communication.

o Review and approve all major changes to Servers/Storage/databases with Action and Rollback plans. Ensure to raise and take sign-off for any foreseen risks.

o Ensure to have service improvements in all the domains and bring in Industry best practices.

o Identify new business opportunities and update the program manager/practice team and facilitate and help in obtaining the necessary information and signing the deal.

o Ensure the Publication of different customer reports in agreed format and frequency.

o Attend Monthly Customer review meeting and document, track and close the action items.

o As a people manager ensure to have a highly motivated and committed team and arrange team building activities on regular basis with reward and recognition to star performers.

o To ensure Succession plan is in place for all the team members from all the domains.

o Identify and arrange/nominate various trainings for all the team members.

o Perform timely appraisal for all the team members and help them in their career growth.

As Oracle L3 resource performed below activities:

o Performance Tuning and root-cause-analysis for all the major problems/downtimes.

o Physical Database Design and Logical Database Design/ Modelling

o Database advance setting maintenance like RAC and DataGuard Database Replication design

o Database security design and Perform Database Audits

o Capacity planning / Trend analysis and Recommendation

o Backup Strategy, DR testing implementation, DR Drills and Business continuity.

o Review of Database domain SOPS.

Project: Upgradation and Migration of Solaris, Oracle, COBOL and CICS. Movement of databases from low end to mid range SUN servers and Storage.

________________________________________

Jan’08 – Sep’08

Hardware: From SUN E2900 and V880 to E6900

Storage: SUN 6130 to 6140

Os: Solaris 9, Solaris 8 to Solaris 10

Database: Oracle 9i to Oracle 10g

Compiler: COBOL 2.5 to COBOL 5.0

Middle Tier: CICS 5.X to CICS 6.X

Role: Project Lead

Team size: 12

Covered all aspect of the project covering:

o Project Manager and Coordinator for complete activity

o Testing of Various software’s and databases in Testing Environment

o Drafting an action Plan for the complete activity and negating all the dependencies and distributing work to different teams and ensuring well coordination and timely delivery.

o Ensuring Installation and configuration of:

Various SUN E6900 machines by Vendor

Veritas Net Backup by Vendor

Network devices, SUN and Cisco

o Framing the layout of 6140 Storage and deciding on the RAID level

o Movement of databases and application from E2900 and V880 to E8900.

o Migration of :

Solaris 8 and 9 to Solaris 10

Cobol 2.5 to COBOL 5.0

CICS 5.X to CICS 6.X

Oracle 9i to 10g

o Ensuring the Network link is up and running;

o Ensuring successful testing of all the databases and applications and sign off from Customer.

Oct’02 – Nov’07 Jammu & Kashmir Bank Ltd., Data Center, Gurgaon

Team Leader for Server Team: Manage the Team of Oracle and Solaris Administrators and solve the problems of high complexity at Oracle and Solaris level (Oct’06 – Oct’07)

Hardware SUN 6800 in cluster, V890, V880, V480R, V240R

OS Solaris 9, Solaris 8

Database Oracle 9i, Oracle 8i

Backup Tool: Legato

Installation and configuration various oracle database and client software versions.

Physical design of the databases and create databases as per application requirements.

Managing database objects – Tables, indexes, Views, Sequences, Semaphores, Procedures, Functions, Triggers, Business Schemas and Users etc.

Database security, access and password policy implementation

Database Backup and Recovery and database cloning/refresh. Cold/Hot/RMAN/Export backups.

Ensured high availability and minimum downtime of the production servers.

Database administration and troubleshooting and adherence to incident and change management process.

Database performance tuning at OS, Memory and application level.

Capacity planning from Storage space, Storage IO, Memory and CPU perspective.

Creation of SOPs for various database activities with snapshots.

As a team lead; manage the Team of Oracle Database/Solaris/backup Administrators.

As additional responsibility as system/storage/backup admin also handled the:

o System Administration of various SUN machines like V490, V880, V890, 6800, 6900.

o Administration of 6320 & 6920 storage; creation of volumes and mapping them to servers.

o Legato software and ensure routine backups / restorations as required.

Project: Implementation of Disaster Recovery Site for Bank

________________________________________

May’07 – Sep’07

Hardware: SUN 6800 IN cluster, V890, V880, V480R, V280R

OS: Solaris 9, Solaris 8

Database: Oracle 9i, Oracle 8i

Covered all aspect of the project covering:

o Project Coordinator for implementing Bank’s Disaster Recovery Site.

o Ensuring Installation and configuration of:

Various SUN machines by Vendor

Legato software by Vendor

Network devices, SUN and Cisco

o Creation of volumes at 6920 Storage Level at the different Volumes to different servers

o Movement of Cold backup of Production Databases to DR site;

o Configuring of Oracle Data Guard at Production and DR site:

Creating Standby Control file and log files

Configuration of listener and tnsnames files

Configuration of init.ora file for Data Guard implementation

Mounting standby physical Databases at DR site

Ensuring Media Recovery of Standby database at DR site

Ensured the Network link is up and running; Starting the replication of various databases

Project: Finacle Application Version Migration 6 to 7

________________________________________

Jan’07 – Apr’07

Hardware: SUN 6800, V890 and V880 servers

Database: Oracle 8i to Oracle 9i

Application: Finacle 6 to Finacle 7

Web Server: Apache and Resin

Role: Module Lead

Team size: 12

Covered all aspect of the project covering:

o Database migration from Oracle 8i to Oracle 9i.

o Ensuring migration and configuration of Finacle Application

o Ensuring testing of the database and application

EDP Cell Baramulla

Profile: In Charge District EDP Cell (Sep’04 – Oct’06)

Role: Oracle Database Administration and UNIX Administration as well as Application level debugging

EDP Cell: Implementing Core Banking solution (Data Center) Bank used to have Total Branch Automation as a solution for IT operations. EDP Cells were formed across the District and Zone levels through out the Country to look after and cater the technical requirements of the branches and Bank.

Hardware: Acer-350, Acer-550 and Wipnet and Xeon (Wipro) servers

O/S: SCO-UNIX 5.5 and 5.6

Database: Oracle 7.3.4

Application: BANCS 2000 (Infosys designed application for Total Branch Automation)

Remote Access: Through VSAT and Radio link connectivity

Played a key role in managing the team of Oracle / UNIX Administrators and solve the problems of high complexity at Oracle and UNIX level

Assured high availability and minimum downtime of the production servers in every branch of the district and maintenance jobs run fine for every branch.

Entrusted with additional responsibility of:

o Perform Database tuning at OS, Memory and application level for all branches remotely

o Routine backups (Export, Import, Cold and Hot) and restores of the databases in production for all branches remotely.

o Database administration of the various databases and servers across the district remotely.

o Installation and configuration of new databases and applications.

Effectively handled the System Administration of various machines provided by Acer, Zenith and Wipro for all branches remotely

Recovered Databases using Clod Backups and Archival Logs, Removing Data Block Corruptions and making user required changes at Oracle and UNIX level.

Corporate Head Quarter, Srinagar (Oct’02 – Sep’04)

Computer Engineer / Member of Branch migration and new branch implementation Team

Role: Oracle Database Administration and UNIX Administration as well as Application level debugging

Single headedly managed the migration of Manual branches to computerized branches /opening of new branches by:

o Installation and Configuration of:

SCO-UNIX on Acer, Zenith or Wipro provided Servers

Oracle 7.x

Creation of Database

BANCS 2000 (Infosys Developed) Application.

Printers and creation of users at UNIX level

o Creation of users at Oracle and application level

o Ensuring Data feeding operations are correct and consistent with manual records

Actively involved in imparting Training to Branch staff for using the BANCS 2000 (now Finacle) application.

Played a key role in rectification of application errors at database and operating system level

Steered functions in managing the Oracle and UNIX Administration of specified branches.

ACADEMIC

B.E in Computer Engineering with from Government College of Engineering and Technology, Jammu (J & K), India in 2000.

ITIL V3 Certified.

PERSONAL PARTICULARS

Date of Birth: 10th April 1976

Passport No: E9056832 // Valid up to 2nd June 2014

Address: #14, 2nd Main, 1st Cross, Maruthi Layout, BTM 1st Stage, Bangalore, 560029

Contact this candidate