[pic] [pic]

Mob: - +** - 956*******

E-mail: - ab035e@r.postjobfree.com

Rajni Kant Ranjan

Objective:

o To obtain a position where my technical and organizational skills may

be linked to enhance the vision and objectives of an organization.

o To obtain a challenging position that will allow me to expand upon my

education and continue to accumulate knowledge.

Total IT Work Experience: 7+ years

Relevant Experience as SQL DBA: 7+ years

Specialization:

Administration and Maintenance of Database Server using MS SQL Server

2000/2005/2008. Experience to a wide environment of SQL Server Databases

whose size varies from 2GB to 1.5 TB. Experience includes technical support

on disaster recovery planning & implementation, replication, logshipping,

Clustering (Active/ Passive and Active / Active), capacity planning,

Database Server consolidation, SQL Server migration and automating the

daily tasks and documentation.

AREA OF EXPERTISE:

* Backup/restoration

* Replication

* Log shipping

* Clustering (Active/Active, Active / Passive)

* Mirroring

* Database consolidation

Technical Skills:

Operating System : Windows 95, 98, NT, 2000,

2003, 2008 Server.

Language known : J2SE, J2EE, C++,XML, Visual

Studio .Net, VB Script

RDBMS : SQL Server 2000, 2005 & 2008

Others : Internet, Ms Office

Professional Qualification:

GNIIT 3 Years diploma in Computer Science from NIIT Ltd.

Completed MCP for SQL Server 2000 database administration

Completed MCTS and MCITP: DBA Certification for SQL Server 2005,

2008.

Academic Qualification:

Completed Graduation (B. SC (Chemistry)) in the year 2004 from Magadh

University, Bodhgaya

Completed PGDCA (through distance learning) from Punjab Technical

University, Jalandhar

Summary of my career as Database administrator:

Total Work Experience: 7+ years

SOPRA India Pvt. Ltd.

Aug 2011 - till now

Projects Profile

Project Easyjet

Role Lead Database Administrator

Organization Sopra India Pvt. Ltd.

Duration August 2011 - Till Now

Team Size 10

Environment Windows server 2000, 2003, 2008 clustered and

stand alone / SQL Server 2000, 2005, 2008 and

2008R2 instances.

Here I am handling team of 4 DBA's team members and also responsible

for installation of SQL Server instance in clustered and stand alone mode,

Maintenance of databases, SQL Server Version Upgrade, replication,

mirroring, log shipping and cluster configuration, Database Migration, On

call support, Performance Tuning, capacity planning and applying Microsoft

best practice on the database servers and troubleshooting the problem and

providing RCA for Severity 1 problems and applying solution to stop getting

repeated in future. I got onsite opportunity in this project and travelled

at client head office in London for 8 months.

Project descriptions

EasyJet Airline Company Limited is a British airline headquartered

at London Luton Airport. It is the largest and fastest growing airline of

the United Kingdom, measured by number of passengers carried, operating

domestic and international scheduled services on over 600 routes across

more than 30 countries.

Key Responsibilities

Administrating more than 80 + Database servers.

Installation configuration and SQL Server up gradation between

different versions of SQL Server.

Upgrading SQL Server7.0 / 2000 to SQL 2005 / 2008

Maintaining Production Database (up to 600 GB)

Using performance counter to monitor and troubleshoot server performance.

? Using SQL server profiler & SQL query analyser for troubleshooting of

performance related issues

Applying the latest patches on stand alone or cluster instance.

Backup and Restoration of Database

Disaster recovery Management

Configuring and Troubleshooting of Snapshot, Transactional and Merge

replication

Configuring and Troubleshooting of Log shipping / Database Mirroring

Working closely with project team/Client team to analyze & resolve issues.

Providing 24*7 support ( On call Support on rotation basis)

Assist in resolving all problems with development and Production SQL Server

databases. Troubleshooting the problem and providing the root cause

analysis for the same

SQL MAIL (SQL Server 2005 / 2008) Configuration and Management

Database Object related minimal to higher level Security configuration,

security audit and maintenance.

. Working with Microsoft technical team to resolve the issue if any.

WIPRO Infotech

JAN 2010 - July 2011

Projects Profile

Project Genpact

Role Senior Engineer Database Administrator

Organization Wipro Infotech

Duration January 2010 - Till Now

Team Size 8

Environment Windows server 2000, 2003, 2008 clustered and

stand alone / SQL Server 2000, 2005 / 2008

instances.

Project description:

Here I was handling team of 4 Junior DBA's and also responsible for

installation of SQL Server instance in clustered and stand alone mode,

Maintenance of databases, SQL Server Version Upgrade, replication,

mirroring, log shipping and cluster configuration, Database Migration,

Performance Tuning of the database server and troubleshooting the problem

and providing RCA for Severity 1 problems and support the all related

activities of SQL server databases.

Key Responsibilities

Administrating more than 200 + Database servers across all regions.

Installation and Configuration of SQL Server 2000/2005/2008.

Upgrading SQL Server7.0 / 2000 to SQL 2005 / 2008

Maintaining Production Database (up to 800 GB)

Using performance counter to monitor Disk I/O, processor, Memory, Network,

and user connection.

? Using SQL server profiler & SQL query analyser for performance related

issues in

MS SQL database / MS SQL based applications

Space Management in all the servers

Applying the latest patches on stand alone or cluster instance.

Backup and Restoration of Database

Disaster recovery Management

Configuring and Troubleshooting of Snapshot, Transactional and Merge

replication

Configuring and Troubleshooting of Log shipping / Database Mirroring

Wworking closely with project team/Client team to analyze & resolve issues.

Mphasis An EDS Company

August 2008 - December 2009

Professional experience 1.4 years

1) Projects Profile

1 DBA Technical Associate

Project Medpro, Francklin Covey, California State

Automobile Association (CSAA), Technology

Support Service (TSS) internal(EDS) project, Palm

Inc. and Symantec Inc.

Role Database Administrator

Organization Mphasis An EDS Company, Noida

Duration August 2008 - December 2009

Team Size 8

Environment Windows 2000, 2003 clustered and normal server /

SQL Server 2000, 2005 clustered and normal

instances and Instanced.

Project description:

Here I was responsible for installation of SQL instance in clustered

and stand alone mode, Maintenance of databases, SQL Version Upgrade,

replication, Database Migration, On call support, Performance Tuning of

the database server and support the all related activities of SQL server

databases.

Key Responsibilities

Administrated more than 400 + Database servers across all regions.

Installation and Configuration of SQL Server 2000/2005/2008.

Upgrading SQL Server 2000 to SQL 2005

Maintaining Production Database (up to 1 TB)

? Using SQL server profiler & SQL query analyser for performance related

issues

Applying the latest patches for the SQL Server.

Backup and Restoration of Database

Disaster recovery Management using log shipping

Configuring and Troubleshooting of Snapshot, Transactional and Merge

replication

Configuring and Troubleshooting of Log shipping

Change Management Process involvement

Working closely with project team/Client team to analyze & resolve issues.

Providing 24*7 support ( On call Support on rotation basis)

Troubleshooting the problem and providing the root cause analysis for the

same

SQL Server Reference engine installation and configuration

AXA Technologies Services India Pvt Ltd

October 2007 - 27 July 2008

Professional experience 10 month

1) Projects Profile (AXA Tech)

1 Database Administration

Project AGS,ABS and All Asia pacific AXA Group partners

Role Database Administrator

Organization AXA Technology Services India Pvt Ltd.

(Bangalore)

Duration October 2007 - July 2008

Team Size 10

Environment Windows 2000, 2003 Server / SQL Server 2000, 2005

Project description (AXA Tech):

AXA Technology Services India Pvt. Ltd. is a part of AXA group and

it's providing the infrastructure and all technical support, helpdesk

support, Database servers support for Oracle, SQL and DB2 for all branches

of ASIA pacific. Datacenter is located in Melbourne, Australia and we are

providing the all database related support from India.

Key Responsibilities

Administrating more than 80+ Database servers across all the Asia

pacific regions.

Installation and Configuration of SQL Server 2000/2005.

Up gradation from SQL Server 2000 to SQL 2005

Maintaining Production Database (100 GB) of their clients (AXA

Business Services and AGS)

Database Tuning

? Space Management in all the servers

Assist in resolving all problems with production, test and development SQL

Server databases.

G-C-I Technologies Asia Pvt Ltd,Bangalore

February 2007 - September 2007

Professional experience 8 Month

1) Projects Profile (AVIVA Life Insurance)

1 Database Administration

Project AVIVA Life Insurance

Role Database Administrator

Organization IBM India Pvt Ltd

Duration February 2007 - August 2007

Team Size 4

Environment Windows 2000, 2003 Server / SQL Server 2000

/2005

Project description:

G-C-I Technology is a diversified global technology company that provides

products and services for a wide range of industries, commercial markets

and end-users, including consumers. It's mainly known for providing

consultancy support to IBM, Citi group, etc.

Roles & Responsibility at AVIVA Life Insurance:

Administrating more than 50+ Database servers across all Asia pacific

regions.

Installation and Configuration of SQL Server 2000/2005

Maintaining Production Database (80 GB) of their client (24*7

support)

0Tuning of Database

Troubleshooting performance issues, detecting worst performing queries

Expertise in Backup and Restoration of Database

Disaster recovery Management

Managing Database Users and Security

Configuring and Troubleshooting Replication

Assist in resolving all problems with production, test and development SQL

Server databases

HCL Info systems Ltd,Noida October 2005 -

January 2007

Professional experience 1.3 Years

1) Projects Profile (Easybill Ltd)

1 Database Administration

Project Easybill Ltd, a venture of Hero Group

Role Database Administrator

Organization HCL Infosystems Ltd

Duration October 2005 - January 2007

Team Size 6

Environment Windows NT4.0, 2000, 2003 Server / SQL Server

7.0, 2000

Project description (Easybill Ltd):

Easy Bill, India's first chain of one stop Financial Transaction centers is

yet another initiative in adding value to the life of the common man.

Through its vast network of Retail Partners, it offers the consumer never-

before convenience in various kinds of transactions.

The company Easy Bill Limited is a venture of the Hero Group. Hero, a name

synonymous with two wheelers in India is a multi-unit, multi-product,

geographically diversified group of companies. The world's largest two

wheeler manufacturer has been acclaimed as the most trusted automobile

brand in India and has earned the recognition of one of the top ten

business houses on economic value in India.

Contribution

As DBA, I was responsible for

Administrating 30 Database servers across all the India regions.

Installation and Configuration of SQL Server 7/2000

Maintaining Production Database (50 GB) of their client (24*7

support)

Tuning of Database

Query optimization

Backup and Restoration of Database

Managing Database Users and Security

Assist in resolving all problems with production, test and development SQL

Server databases.

Solving day to day problems, Trouble shooting

Experience as a DBA:

Administration of SQL Server 2000/2005,

Windows NT in an enterprise scale network that includes: Architect,

support, enhance and extend all aspects of existing SQL Server

implementation including database security, performance monitoring, tuning

and optimization, and data replication, backup and recovery. Design,

schedule and administer all automated database maintenance scripts. Assist

in resolving all problems with production, test and development SQL Server

databases. Track SQL Server problems with internal IT staff and external

interfaces and vendors.

Capabilities:

Experienced DBA with an ability to communicate effectively on a

technical or personal level.

Proficient Database Administrator

Proficient knowledge of technologies in the area of Network and

software

Configured Security features for Database & Server users for SQL

Server and Windows Operating System respectively.

PERSONAL DETAILS:

Name Rajni Kant Ranjan

Email Id ab035e@r.postjobfree.com

Date of Birth 18-05-1983

Location New Delhi

Contact numbers Mob: +91-956*******

Personality Notes:

Confident, Deadline and detail oriented. Self-starter. Ability to work

independently & amongst team. Good people and client management skills.

Ready to travel & relocate.

The particulars provided here in this Resume are true in all respect.

Dated:

(Rajni Kant Ranjan)

Contact this candidate