KRISHNA KANT NIRALA *D Viva Residence Avenue Lokonga Kinshasa, Gombe, RD Congo, Africa

Passport No: L5655886 ac0euk@r.postjobfree.com

Cell No. 243-*********

Objective: Seeking a position where my experience and capabilities can be used to contribute to a company's objectives.

Experience Summary:

Professional with 14 years of Development, Production environment, Database Administration in Banking and Telecom Domain.

Well verse with SLA management, Incidence, problem management, and Change management.

Designed and executed short and long term strategic plans to assure infrastructure capacity attains current and future needs.

Managing Primary Data Center, Disaster Recovery Center, and Operations on 24 x 7 as per ISO standards.

Coordinated implementation of company-wide IT controls, including policies and procedures, risk assessments.

Developed and Implemented Service Catalogue and Service Level Agreement.

Created service reports of all services for the high level management Committee.

Developed and implemented disaster recovery plan.

Follow proper ISO procedures regarding releasing all technical changes into production.

Designed and configured Backup of all databases on tapes (DP LTO 6) and Cloud storage environment.

Maintain IBM Blade Server P7 and HP G9 Servers.

Implemented virtual infrastructure using VMware ESX Server.

Configure all IT assets with CMDB which compliance with ISO standard.

Ensure security levels on network, infrastructure and servers are maintained.

Maintain SLA of vendors and contractors for infrastructure-specific products and services secure

Implementation and Administration of Oracle Data Guard.

Migration data from INFORMIX to Oracle databases using SQL LOADER.

Configured and Scheduled RMAN Backups.

Certification:

ITIL V3 Foundation Certified Professional (EXIN, Nether land)

Oracle 10g Database Administrator (OCA)

Teradata Certified Administrator (V2R5)

Rewards:

Outstanding performance award for Year 2012-2013 by HP

Awarded for successful Project Delivery 2009-2010 by Amdocs

IT Skill Summary:

Infrastructure Monitoring Tool

Idera-Uptime Infrastructure Monitoring,

Databases

Oracle 12c, 11g, Informix 11,Teradata 12, V2R6,V2R5,

Tools/Utility

RMAN,Oracle Grid Control, Oracle Enterprise Manager, Toad, spotlight

Data base Design Tool

Erwin, Sybase

Incident tools and others

SysAid, Remedy, HP OpenView, AT&T WR, Toad 9.5, SQLDeveloper, TD Manager, TD Admin,

Load Utility

SQL Loader, Data Pump,MLOAD, Fast Load, Bteq

Operating Systems

Linux 6, AIX 6.1L (64-bit),Windows 2008, 2012 Server,

Backup Tool

Data Protector 11, TSM Tivoli

Languages/API

SQL, PLSQL,Java,Jsp, Servlet

Deployment and Development Environment

WebLogic 11g,Tomcat 8

Products

Clarity, Amdocs - Enabler, Billing Management, Balance Manager.(CRM, OMS, ABP)

Employment History:

ORGANIZATION

DESIGNATION

From - To

RawBank, DR Congo, Africa

Infrastructure Manager

Dec 2013 - Till Date

Mphasis as HP

Sr. Principal Infrastructure Engineer ( DBA Lead)

April 2012- August 2013

Amdocs Development Center India Ltd. Pune

Sr. Oracle DBA

Aug 2009 – Feb2012

Teradata India Pvt. Ltd.

Technical Consultant (Teradata DBA)

Nov 2007 - July 2009

CapGemini Consulting India Pvt. Ltd

Consultants(Oracle DBA)

Nov 2005 - Nov 2007

BioStar Nutriceuticals India, Mumbai

Oracle DBA

July 2003 - August 2005

Education:

Master of Computer Applications (MCA) from Government Engineering

College Jabalpur (M.P.) India

Bachelor of Science (B.Sc.) from Govt. Science College Jabalpur (M.P.), India

Professional Experience

Organization : RawBank S.A

Industry : Bank

Project : Data Center - Infrastructure

Role : Infrastructure Manager

Responsibilities:

Manage the Operations of the IT Infrastructure encompassing Data Centers, Data and Communications Networks, Servers, Desktops and Applications.

Maintain Backup jobs and policy of all critical applications

Create physical and Virtual servers as per business requirement

Capacity planning of all servers

Maintain SLA of all business unites and stakeholders

Monitor resource of all servers and network band width

Access control to Data Centers and maintain access log

Prepare service report s of all services listed in Service Catalogue

Coordination with Business Unites for new projects

Maintain 32 Virtual servers on VMWARE environment

Implemented Oracle database backup on Oracle Cloud environment

Configured SLA with SysAid ticketing tool

Effectively communicate IT recommendations and KPIs to domain leads

Configured all IT assets in Configuration Management Database

Maintain IBM blade Server PS700,HS23,Storwize V5000

Design and configure Backup of all databases on tapes (DP LTO 6) and Cloud storage environment

Maintain Linux 6, AIX 6 on 2xp260 Nodes- Cluster Power HA)

Installation VMWARE ESXi 5.1 Hypervisior on 3x HS23

Organization

:Mphasis an HP

Project

:Kraft and Foods

Client

:Kraft and Foods - USA

Industry

:Retailer

Project Type

:Production

Software

:Oracle 11g,10g,9i/Linux,AIX,HP-UX

Role

:Sr. Principal Infrastructure Engineer ( DBA Lead)

Responsibilities:

Supporting around 600 plus database servers under defined SLA (L3).

Setup ASM installation and migrate non ASM database to ASM database

Implementation OS cluster database to HA

Monitor incidents which are close to first alert stage.

Proactively monitoring system comprises monitoring of production database as well as production databases servers, monitoring includes monitoring of database resources, expensive process/queries, ad-hoc process/ queries/reports, tuning of expensive queries. Check routine Job(s) includes the backup’s status, disk space, indexes, validity of database objects, tablespace’s size, and database alert log.

Up gradation from Oracle 9i to Oracle10g and Oracle 11g

Rebuild Indexes using parallel processes.

Backup and restore as per requirements

Manage partition table and indexes.

Moving data files, indexes, Redo log files.

Manage materialized view using complete and fast refresh

Setup and automated Data Pump utility for Backup

Writing UNIX Shell Scripts for collect statistics and rebuild Indexes.

Performing general technical troubleshooting.

Enrolling users and maintaining system security.

Controlling and monitoring user access to the database

Organization : Amdocs Development Center Pvt. Ltd

Project : Rogers Communication, AT&T

Client : Rogers Communication Inc. (Brampton, CANADA)

Industry : Telecom Domain

Project Type : Production

Role : Team Lead- Sr. Oracle DBA

Responsibilities:

Implemented 2 Nodes RAC database servers at client site

Setup and configuration automated online RMAN backup to all Amdocs core database systems.

Setup and automated Data Pump utility

Bulk data loading using SQL Loader.

Used AWR/ADDM report to analysis of Database performance.

Organization : Teradata India Pvt. Ltd.

Project : Rogers Communication Inc. (Brampton, CANADA), ALCATLE LUCENT (ALU)

Industry : Telecom Domain

Project Name : Rogers Communication

Role : Teradata Production DBA

Primary Responsibilities:

Creating user/database in Production and QA environment

Create/modify Profiles and Roles.

Granting privileges to roles, users and database.

Allocation or moving perm space and temp space.

Collect statistics on business tables.

Setup Alert policies from TD Manager

Managed Backup Operations by taking periodic backups of databases through net vault

Creating scripting for archive, restore/copy.

Checking highly skewed tables.

Involved in providing better performance approaches considering structural changes like PI consideration based on data demographics, collect statistics etc.

Creating, modify, Scheduling and Monitoring job in TARA.

System maintenance Purging of Resource Usage/DBQL logs.

Runs Loading and purging job as per retention periods.

Used TD utilities defragmentation, scandisk, check table and rebuild table.

Using PMON, TD Manager, TD Administrator.

Interacting with the client during any issue generated during the process.

Coordination with development team members in resolving technical difficulties.

Start and stop data loading job using MLOAD utility and move data from stage to production database.

Start and stop data purge job based on retention policies.

Troubleshooting in case job is failed (Release lock and checkpoint from MLOAD load utility).

Involved in providing better performance approaches considering structural changes like Primary Index consideration based on data demographics.

Organization : Cap Gemini Consulting India Pvt. Ltd.

Project : Clarity, CPL (Central Process Loan Management) Europe

Client : NIKU (Sweden), Rabo Bank – Europe

Location : Mumbai, India

Database : Oracle 10g/9i/UNIX-HP – OS Cluster

Role : Oracle Production DBA

Oracle setup on the IBM p570 in Utrecht running AIX.

Machine environment:

Hardware:

IBM p570 (9117-570) with 32 processors and 32 Gigabytes of real storage

SAN:

Oracle data is stored on /oradata (200 Gigabytes)

LPAR settings:

1 LPAR with 2 processors and 8 Gigabytes of real storage is assigned to Oracle

System software:

AIX 5.3L (64-bit)

Oracle 10g

Responsibilities:

Prepared all databases to fulfilled audit Requirements( audit by third party Computer Associates CA)

Prepared database health report in every month end

Database monitoring includes monitoring of database resources, expensive process/queries, ad-hoc process/ queries/reports, tuning of expensive process/queries/reports. Routine Job(s)/Database Health Check includes the backup’s status, disk space, indexes (unusual), validity of database objects, tablespace’s size, database alert log .

Rebuilding Indexes, Reorganization of tablespaces and tables.

Moving data files, indexes, Redo log files.

Creating Tablespace and schema as per requirement.

Configuration of Oracle grid control for multiple database servers

Performing general technical troubleshooting.

Enrolling users and maintaining system security.

Controlling and monitoring user access to the database.

Configuration of stats pack on production for tuning purpose.

Organization : BioStar Nutriceuticals India.

Project : Nutrient Network Application, GCI-USA

Location : Mumbai, India

Database : Oracle 9i

Role : Oracle DBA

Responsibilities :

Installation and configuration of Oracle9i on Linux environment.

Cold and logical backup and restore in different environments

Managed tablespace, Schema, Test data

Managing- redo logs, Archiving, Log miner, Undo segments, tables, indexes

Languages:

Hindi – native language

English – fluent

French – basic skills

PLACE: Kinshasa Krishna Kant Nirala

DATE:

Contact this candidate