Roshan Nair

Leading the Service Delivery for Managed Services Customers
Measuring the quality of service and presenting Service Reviews (Monthly and Quarterly)
Aligning delivery with management goals and expectations
Planning, Designing and Monitoring the program progress
Managing risks, issues and changes across the program efficiently
Achieving the service level agreement set by the business
Defining Governance around the program
Focusing on definition and management of strategic benefits
Resource Management - Onboarding, Allocating and Back-filling - based on project skill requirement
Maintaining relationship with the stakeholders both internal and external to the program
Clientele - Federal Ministry Project, Dubai Parks and Resorts, Prime Minister’s Office, Oman Insurance Company, Commercial Bank International, etc

• IT Infrastructure Management
• IT Project Management
• IT Service Desk Management
• IT Strategic Planning
• IT Financial Management
• IT Budget Development & Analysis
• IT Service Based Costing
• Training and Staff Development

Lead Production DBA handling financial databases & ERP systems for Dell

Technical consultant handling production issues for North American prospective customers for Oracle thereby reinstating their faith with Oracle Support

Installation, maintenance and upgrades of Oracle RDBMS.
Design, implementation and support of backup and recovery procedures.
Support of multiple production, development and test environments.
Security, audits and change-control practice, procedures and implementation. Performance tuning and maintenance.
Creating and maintaining concurrent managers
Defining, scheduling and maintaining concurrent processing.
Database administration, backup and recovery and performance tuning.
Designing and planning of database, which involves deciding about logical storage structures and forecasting future expansions.
Creating and managing Schema Objects/Security of Database.
Security Administration by creating Users with appropriate ROLES and PRIVILEGES. Creating Stored Procedures, Functions and Database Triggers.
De-fragmentation of database.
Optimizing the SGA and Shared Pool Size.
Optimized INIT.ORA parameters to best utilize the new enhanced features
As a DBA in Wipro Infotech Ltd. handled big clients like UTI, UBI, J.P. Morgan, Bank of
Maharashtra, BSNL, Municipal Corporation (KDMC), YES Bank on RAC projects, migration
projects, and up gradation projects.

Technical Support for in-house developed product “SIS”.
SIS, which is the abbreviation for Student Information System was developed to ease the
paper work done and make time more manageable.
Handling database activities also like importing and exporting the database to and from
the client place and providing online help to the issues faced by the clients.
Programming a procedure using PL/SQL for updating and displaying faculty details.
Tuning the database to meet the demands of the ever-growing expectations of the
clients.
Giving on-site assistance to the technical issues faced by client in terms of performance,
backing up of their sensitive database.
Providing training to the end users about the usage and functionality of our product SIS.
Good exposure of usage of TOAD and JRUN version 4.0
Setting up FTP Servers at client places to make the transfer of files manageable from
client place.
Designed an installation package using Microsoft Visual Basic 6.0 for auto-configuration
of the modules of our SIS product.

Production database administration :
Performance tuning.
Designing Backup & Recovery plans for point in time recovery.
Installation & Configuration of Oracle 9i Enterprise Edition.
Carrying out recovery operations including backups and data Restoration.
Configuration of database security plan.
Daily application updates and periodic database modifications.
Creation, Designing & Deploying databases for various front-end applications.
Creation of Logins, Roles and granting rights.
Space management.
Executing Database Consistency Checks on routine basis.
Troubleshooting site issues.

Cobol Programming to simulate Live systems
Phase-Wise study of the simulated client system with the phase wise development
presentations.
Trained on CICS front-end which provides a lucrative user-friendly application to be created
Have knowledge about the Job Control Language.