Brajesh Kunwar

[pic]

Voice: 501-***-****(H) 501-***-****(C)

E-mail: abmh4u@r.postjobfree.com

**** ***** ***** **., ****** Rock, AR 72211

Summary:

. Over 12 years of professional experience in IT industry in Database

Administration, System Administration, Designing Hardware, Software,

Network and Backup solutions, designing and implementing security

framework; IT controls, IT audit, and SOX (Sarbanes-Oxley); requirement

gathering, scope definition, data analysis and design, development,

testing and implementation for Data Warehouse and OLTP solutions; for

databases of size up to 90 TB on various types and sizes of servers; for

Media, Telecommunication, High tech, Retail, Healthcare and Finance

Industries.

. Extensive experience in administering RDBMS like Oracle 8i/9i/10g/10g

RAC, DB2 UDB, SQL Server 2000/2005/2008, Netezza, MySQL for various

industries' Data Warehouse and OLTP solutions including Physical and

logical designing of database, installation, up gradation, migration,

applying Security patches; System, database and query tuning; backup and

recovery solution using cold backup, export and RMAN and other third party

software like VERITAS, LEGATO; Configuration and maintenance of

distributed databases using advanced replication; writing procedures,

functions, packages, triggers using SQL, PL/SQL, PERL, Pro*C and shell

scripts to automate tasks; managing more than 100 servers and 185

production and test databases using oracle grid control; bug resolutions

with Oracle, HP, IBM, SUN, EMC, REDHAT, Netezza and UNICA

. Extensive experience in Specking out the server including no. and speed

of CPUs, Memory, Storage capacity and layout, no. of controllers; i/o

throughput and switches for a specific solution; setting various

parameters directly affecting resource allocation limit for processes, i/o

method like asynchronous or synchronous; memory segment size; testing the

server

. Successfully performed role of DBA, System Administrator, Technical Team

Lead, Solution Architect, Business Analyst, Modeler and Data

Warehouse/Data Mart Developer roles; Have excellent oral/written

communication skill and a very good team player. Have Project Management,

Estimation and Execution Experience and implemented various projects using

SDLC methodology; demonstrated ability to interface with top levels and

across organizational lines, including leading meetings and preparing

presentations to both technical and non-technical personnel by clearly

understanding business processes and customer needs. Quick learner and

easily adopt new technology.

CORE COMPETENCIES

Database Administration Data Warehouse Data Technical Mentoring,

Modeling Team Building/Leadership

Unix System Administration System Testing Programming

Specking out hardware, software, network, Problem solving skills

storage and backup solutions

Requirement Gathering Functional System Integration

documentation

Technical Skills

Hardware: DEC Alpha Server, HP ProLiants, Sun 10000, SunFire

12000, Netezza Performance Server 8000 Series, HP

9000, IBM RS 6000, IBM P650/670; Sun SPARC/Ultra

SPARC, PCs

Operating Systems: AIX 4.x/5.x, Solaris 8.x/9.x, Tru64, Linux AS/ES,

Digital Unix 5.0, Solaris8.x/9.x, AIX 4.x/5L, HP-UX,

SCO-UNIX, SMOS UNIX, DOS x, Windows 98, NT, 2000, XP,

2003 Server, X-Windows, CYGWIN

Databases and SQL ORALCE RAC/10g/9i/8.x, DB2 UDB, Netezza 8.0, MySQL,

Tools: SQL Server 2000/2005/2008, SQL*Loader, NZ Loader

&SQL, MySQL

Special SAS 8.0/9.0, TOAD, PL/Sql developer, Advanced

Software/Tools: Replication 8i, PVCS, Source Forge, VMware, IIS,

Apache, source control

Case and Data ER-Win 4.0, Business Objects 11.0

Warehouse Tools:

Programming C, SQL, PL/SQL, Perl, Pro*C, Korn/Bourne/C Shells,,

Languages: Visual Studio 2008, VB .NET, C# .NET, Java, PERL,

JavaScript, DTML, XML

Security H/W & S/W Decru, TDE (Oracle), Oracle Advanced Security,

Protegrity, Virtual Private Database, DbEncrypt

Education

Master of Computer Applications (M. C. A.), M. S. University of Baroda,

India Jun 97

Bachelor of Science degree (B. S.) in Statistics and Physics, Math Minor

Apr 94

M. S. University of Baroda, India

Training

Banking operations and management, Mbit Computer Systems and Consultants

Jun'97

Database Administration, Acxiom Corporation

Jan'00

Linux System Administration, Acxiom Corporation

May'04

Netezza Administration, Netezza

Mar'05

Oracle 10g new features, TUSC

Mar'06

Oracle 10g RAC, Burleson

April'06

Certification

Oracle8i DBA

Sun Certified System Administrator (8.0)

Work Experience Summary

May'06 - Current Internext Database Administrator

Corporation

Mar'00 - May'06 Acxiom Database Administrator

Corporation

June'99 - Dec'00 Global Database Programmer Analyst/ Database

Mgmt Admin

Awards and Achievements

. Acxiom Excellence Award 2002

. Delivering Operational excellence award for Rodale, Reiman; 2002 and

2006

. Scored highest in school in Secondary and Higher Secondary classes;

1989, 1991

Work Experience

Database Administrator @ Internext Corporation, AR

May'06 - till date

Oct'08 - Client: Xerox Corporation Database Administrator

Current

Xerox is leader in document imaging products and IT solutions. Xerox Global

Services provides document imaging solutions to its clients ranging from

healthcare industry to rental car companies and many more. The solutions

includes providing industrial grade data capturing equipments like

scanners, cutters, bar code readers etc. Complex software solutions to

provide meta-data/image access, image flow with very tight SLAs.

Responsibilities Includes:

> Complete analysis and recommendations for database and server

environment.

> Analysis included data architecture and server architecture, database

performance, storage solutions

> Capacity planning

> Analyze server side stored procedures for routine image flow tasks,

reports and recommended changes in code for better performance and meeting

the SLAs

> Providing database support for 150+ SQL Server production, test and

development databases.

> Performance monitoring and tuning of database, server and storage devices

by capturing various dynamic statistics.

Environment: Windows 2003 Server, VMWare, Windows Cluster, SQL Server

2000/2005, SSRS, SSIS, .NET 2005/2008 (C#, C++, VB)

Mar'08 - Client: US Script, Fresno, CA Database Administrator

Oct'08

US Script manages pharmacy benefits for thousands of clients that include

health maintenance organizations, health insurers, third-party

administrators, employers, State-funded Medicaid plans, and union-sponsored

benefit plans.

Responsibilities Includes:

> Complete analysis and recommendations for database and server

environment. Analysis included data architecture and server architecture,

database performance, backup and restore policy, documentation and routine

MIS reports and cleanup.

> Providing database support for multiple Oracle (8i & 10g) production,

test and development databases.

> Maintaining standby databases at multiple locations.

> Performance monitoring and tuning of database, server and storage devices

by capturing various dynamic statistics.

> Maintaining Oracle discoverer.

Environment: Sun Fire 480R, Solaris 5.9, Oracle discoverer, Oracle 8i,

Oracle 10g

Nov'07 - Client: Cognitive Data, Little Rock, AR Database Administrator

Oct'08

Data Source Handling (Internext

Corporation)

Cognitive Data is rapidly growing fortune 100 company provides data

warehousing solutions, process/provide customer address/email lists. This

project involved designing data source and administration of multi TB

various SQL Server 2000/2005 databases.

Responsibilities Includes:

> Designed and developed automation of data source handling. Flat files

come from various customer sources in various formats and it has to be

automatically loaded and cleansed and processed for final customer output.

It includes format verification, QC check on data, transformation of data

to be loaded in database.

> Created database and optimized for performance improvent.

> Wrote script to take database backup and cleaning of work tables.

> Designed layout for storage solutions.

Environment: Windows 2003 Server, VMWare, Windows Cluster, SQL Server

2000/2005, SSRS, SSIS, .NET 2005/2008 (C#, C++, VB)

Jun'06- Client: Alltel Wireless Little Rock, AR Security Architect/

Nov'07 Database Administrator

Security Framework Design & SOX

implementation (Internext Corporation)

This project involved designing security framework for the existing

database & application servers.

Responsibilities Includes:

> As a part of SOX implementation Involved in evaluating security products

like Oracle Transparent Data Encryption (TDE), Protegrity, Decru on

various criteria like performance impact, ease of use, space needed for

security, implementation complexity and project cost, complexity for

warehouse environments with Multiple data feeds or three-tier systems;

integration with Oracle Data Vault and Audit features; integration with

Veritas Cluster; Backup ease and recovery.

> Implemented auditing and listener security on production databases

> Created Oracle10gR2, 10g RAC database for RBT (Ring Back Tone) feature.

> For RBT project implemented Testing environment using OS based cluster.

Environment: Fijitsu PP450, Solaris 5.9, Veritas Cluster, Oracle 10.x.x.x,

SAS 9.0, TDE, Database Vault, Oracle Advanced Security, Protegrity, Decru

Database Administrator-III @ Acxiom Corporation, AR

Mar'00 - May'06

> Creation and maintenance of databases of size 1600 GB (Data warehouse),

400 GB and 300 GB (data mart) and 200 GB of Test database

> Defined and implemented the physical and logical layout of database on

file system and raw devices

> Defined users and roles for user access

> Coordinated and communicated with the development team and remote client

for performance, space, and modification issues

> Tuned queries using explain plan, hints, sql trace and tkproff and

parallel query options for Data Mart Data Extraction

> Written many shell scripts and added to cronjob to coalesce the

tablespaces, take snapshots of database to generate various reports,

exports, inform the database status like base is down or some trace file

is generated etc. and taking backup of database controlfile and crontab

file

> Defined, tested and implemented the backup and recovery policy

> Written script for creating and loading of test database objects

> Performance monitoring using TOAD, OEM, statspack and various customized

scripts

> Upgradation of database from 8.0.5 to 8.1.7 and adding patch 8.1.7.1

> During on-call rotation in the weekend handles more than 185 databases

Jan'06- Client: Banking Industry (Bank of Solution Architect/

May'06 America) Database Administrator

Data Warehouse update system, Acxiom

Corporation, Conway, AR

This project involved designing dedicated data warehouse system for 90 TB

database for one of premier financial client Bank of America

Responsibilities Includes:

> Involved in system design like creating the LPAR and specking out the

size for memory, CPU and no. of controller, types of switch

> Involved in Storage capacity and layout like type of RAID and no. of

disks should be used in each RAID set for best possible i/o throughput

> Physical and logical design of database for best possible performance;

installation and creation of database, applying patches, resolving bugs in

co-ordination with oracle support; tuning queries using various tools like

tkproff, statspack, OEM, rewriting the queries; creating various database

objects, roles, profiles, audit rules

> Backup and recovery solutions with retention period and type of library

> Wrote data warehouse and data extraction codes using sql, pl/sql, perl

and shell scripts

> As data architect, responsible for creating master data model in Erwin.

Day-to-day responsibilities include analysis of data requirements and

translation of these requirements into dimensional data models. Other

responsibilities include developing modeling and naming standards, writing

modeling guidelines

> Implemented 10g grid control to monitor node, database, listener, various

daily or weekly jobs and resource utilization

Environment: IBM P650, AIX 5L 5.3 Oracle 10.2.0.1, SAS 9.0, Business

Objects 11.0, Pro*C, Sql*Loader, ERWIN3.5, Power Designer, Pl/Sql, Perl

July'05 - Client: Media Industry (Rodale, Reiman, DBA/

Dec'05 Discovery, CondeNast), Solution

Data Warehouse update System Architect

Acxiom Corporation, Conway, AR

This project involved designing daily update system for marketing database

for media industry of the size 1 TB to 25 TB; redesigning the solution to

improve the performance using new features of databases and better hardware

performance and improved process design

Responsibilities Includes:

> Involved in system design like speed and no. of CPUs, memory size, no. of

controllers

> Involved in Storage layout like type of RAID and no. of disks should be

used in each RAID set for best possible i/o throughput

> Specking out server like no. of CPUs and speed, Memory size, storage

capacity and layout

> Created test database as well as various shell and sql scripts to create

a sample test database from production system

> Wrote various scripts to perform daily activity like take backup of

control file, init.ora, tnsnames.ora, sqnet.ora files; generating various

reporting database growth and overall database health for users

> As data architect, responsible for creating master data model in Power

designer

> Wrote data warehouse ETL codes and data mart code using sql, pl/sql,

perl, Pro*C

> Utilization of Oracle Warehouse Builder to define mapping, input/output

schemes, defining expressions for to support business rules, and to

transform data from one source to another destination applying business

rules.

> Generated capacity reports including memory, CPU, tablespace and disk

utilization and growth with hot spots; so user can reschedule the

processes for better performance and space utilization

> Monitoring database using oracle Enterprise Manager for different alerts

and warnings like database, listener, node is down or certain mount point/

tablespace is full.

Environment: IBM P650/670, AIX 5L 5.3, 4.x,, IBM RS 6000, Oracle 9i, SAS

9.0, Business Objects 11.0, Pro*C, Sql*Loader, ERWIN3.5, Power Designer,

Pl/Sql, Perl

Jan'05-Jun Client: Healthcare Industry (American Medical Oracle DBA/

e'05 Association ) Update System Solution

Acxiom Corporation, Conway, AR Architect

This project involved redesigning the existing solution from hardware

layout to physical and logical design of database, rewriting the code for

13 production, qa and test databases of size up to 3 TB

Responsibilities Includes:

> Involved in upgrading the OS to new release so new security patch could

applied to oracle database

> Redesigned the physical and logical database structure to get best io

throughput

> Relocated data files to different mount point, so few big mount points

could be created

> Involved in rewriting the codes using new features of oracle 9i using

sql, pl/sql, perl and Pro*C

> Supported and maintained production database running in archive log mode

and backed up using RMAN

Environment: GS140, Sun E6000, Solaris 8.0, Tru64 4.1, Oracle 9i, SAS 9.0,

SQL, PL/Sql, Perl

Jan'04-Sep Client: IBM, North America Analytical Data Mart

'04 Database Developer

Acxiom Corporation, Conway, AR

This project involved creating the analytical database of size 4 TB for IBM

for it's North Americans customers

Responsibilities Includes:

> As data architect, responsible for creating master data model in Erwin

for data mart

> Wrote various scripts using ANSI SQL, shell scripts for DB2 database

> Used PVCS to maintain the integrity and version control of code

> Helped Data Warehousing team to write codes to cleanse the incoming file

and wrote various cron jobs to perform routine task like taking the back

up of scripts, database structures, table data

> Wrote various excel macros to generate the data mart scripts from excel

based warehouse data model

Environment: IBM P650 LPAR (production and test); DB2 UDB 8.0, Quest

Central, ERWIN

May'03-Jan Client: Retail (Lancecrafters) Oracle DBA/

'04 Data Warehouse Update System Developer

Acxiom Corporation, Conway, AR

This project involved migrating existing solution to new Linux based

machine on new version of oracle 9i with improved system and database

design; and modified better performing codes

Responsibilities Includes:

> Involved in system design to give feed back from dba point of view like

size of databases, no. of users, max processes running at time

> Redesigned the physical and logical database structure to get best io

throughput

> Involved in rewriting the codes using new features of oracle 9i using

sql, pl/sql, perl and Pro*C

> Supported and maintained production database running in archive log mode

and backed up using RMAN

> Performed io benchmarking using dd command and other GUI based XVIE tool

to monitor system performance

Environment: Linux AS, Oracle 9i/8i, SQL, PL/Sql, Perl

Database Administrator @ Ceridian Small Business Solution, NJ

Dec'99 - Mar'00

Project : Implementing advanced replication

Environment : Oracle 8.1.5, Solaris 2.6, Win NT 4.0

> Set up the advanced replication on Oracle 8i database between Atlanta

database (Primary database) and Las Vegas database (Fail over database)

> Creation of Replication Admin, Propagator, Receiver, Master Site

Definition, Master Site, Master Groups and written many conflict

resolution routines

> Installation and configuration of two QA and one Development Oracle 8i

database

> Maintenance and Restructuring of the existing database of size over 20 GB

in view of space and performance for www.powerpay.com

> Rewritten the Load procedure, which loads data coming from Informix

database in flat file, to temporary tables of Oracle Database and then to

original tables

> Maintenance, performance monitoring of Production, Development and QA

databases

> Written many shell scripts, database triggers and performance monitoring

scripts

Database Administrator @ Avid Networks, NY

Aug'99 - Dec'99

Environment : Oracle 8.1.5, Solaris 2.6, Win NT 4.0

> Installation, configuration and maintenance of development distributed

Oracle 8i database of size over 40 GB and 65 users and Production Oracle

8i database

> Physical and logical designing of the Database, creation of users and

defined roles, profiles for different group of users

> Helped in deploying application on web server for web sites:

> www.avidboating.com www.powerboating.com www.avidsailing.com

> Performance monitoring and tuning - sql tuning, SGA component tuning and

load balancing using partitioning of tables and creating datafiles on

different mount point

> Implemented backup & recovery procedure using hot and cold backup,

Export/Import

> Written many shell scripts and added it to cron jobs to automate the

tasks

Application Developer/DBA @ TCS (Mbit Computer Systems & Consultants)

Jun'97 - Jul'99

Project : Integrated Standard Banking System (ISBS)

Environment : Oracle 7.x, D2K, Visual Basic 5.0, Window NT 4.0, HP-UX

10.0, DG/UX

> Application installation and configuration of oracle Applications at 6

nationalized bank branches

> Created roles, profiles, and assigned it to the users and other

roles

> Tuning of SQL statements

> Testing of the application

> Written many shell scripts for various daily activities

> Coding in D2K for current, saving and cash credit module of Integrated

Standard banking System (ISBS). Grievance Redressal system in Visual

Basic 5.0

. Project Trainee @ GACL, Baroda

Aug'96 - May'97

. Programmer @ Sahara India Financial Corp., Baroda

Aug'94 - Mar'95

Contact this candidate