Sql Server Database

Mayur Gajjar

**/*-*, ********* **. Strathfield, NSW - 2135, Australia

Mobile : 0061- 431 559 747

Email: ************@*******.***

Visa Status : Australian Citizen

SKILLS SUMMARY

Microsoft SQL2005 Certify DBA with strong experience as a database

administrator/developer. Strong background in SQL Server

2000/2005/2008, MS-Access, TSQL, Visual Basic 6.0, Visual

Studio.Net, ASP.Net, User training and support documentation.

COMPUTER SKILLS

Programming Languages

VISUAL BASIC 6.0, VB/C#.Net, ASP.Net.

Database:

Microsoft SQL 2000/2005/2008, MS Access 2003

WEB Programming:

VB/Java Script, Active Directory, XML, HTML 4.0, Front Page,

DreamweaverMX.

Operating Systems

Windows 2000/2003/XP, UNIX, Linux.

Tools:

UML 2.1/2.2, Microsoft Visio 2003/2007,Crystal Report 8.0/9.0,

SSIS, SSRS, Microsoft Visual Source Safe (VSS)

Networking:

LAN, WAN, Wireless Security, Active Directory, IIS 6.0

Technical Strength

SQL Server 2000/2005/2008, TSQL, MS-Access 2003, VB.Net, ASP.Net

EDUCATION

Bachelor of Information Technology

Ballarat University at Sydney Campus

Year of Passing: August 2006

Under Graduate Information Technology

GLSIIT (Gujarat Law Society Institute of Information Technology)

Year of Passing: November 2001

Diploma Electronics & Communication Engineering.

Govt. Polytechnic, India

Year of Passing: March 2000

Microsoft Certify Professional Database Administrator (MCDBA

SQL2005)

Year Of Passing: Dec 2007

EXPERIENCE

Global Carbon Systems Technology Pty Ltd

Start Date Feb 2010

End Date Current

Position/Title Snr. Database Administrator/Developer

Responsibility

Platform - Windows 2003/2008 Server, SharePoint/Exchange Server

2007

Tools Used - Microsoft SQL Server 2005/2008, SSIS

Description - As Database Administrator/Developer primary

responsibilities include design, tuning, support and develop of

SQL database server.

Ensure optimal performance, reliability, security and availability

of database environment

Used advanced SQL query, store procedure, function, trigger and

cursor to design and development of database Server.

Performed database maintenance and performance tuning for the

database server.

Managing, monitoring and optimizing database server.

Performed database Backups and Recovery both locally and remotely.

Design and develop ETL process using SSIS.

Managing and optimize database objects and batch job scheduling.

Navigate and troubleshoot SQL Server issues.

Managing and maintain high availability for the database server

(Database Replication).

Manage and maintain SharePoint and Microsoft Exchange Server 2007

Global Red Australia Pty Ltd.

Start Date June 2009

End Date December 2009

Position/Title Database Administrator/Developer

Responsibility

Platform - Windows 2003 Server

Tools Used - Microsoft SQL Server 2005, SSIS, SSRS

Description - As Database Administrator/Developer primary

responsibilities include design, database tuning, support and

develop of SQL database server.

Used advanced SQL query, store procedure, function, trigger and

cursor to design and development of database Server.

Performed database maintenance and performance tuning for the

database server.

Managing, monitoring and optimizing database security for business

user and clients.

Performed database Backups and Recovery both locally and remotely.

Managing and optimize database objects and batch job scheduling.

Design and develop ETL process using SSIS.

Rectify and troubleshooting database and SSIS related issues in

large OLTP and OLAP environment.

Managing and maintain high availability for the database server

(Database mirroring)..

Chubb IT, UTC Fire and Electronic Security

Start Date September 2008

End Date March 2009

Position/Title Database Administrator

Responsibility

Platform - Windows 2003 Server

Tools Used - Microsoft SQL Server 2000/2005/2008, VMWare Server

Description - as Database Administrator primary responsibilities

includes all technical tasks from db configuration, design, tuning

of database server.

Ensure optimal performance, reliability, security and availability

of database environment.

Deliver proactive support and maintenance for assigned database to

optimize ongoing performance and total cost of ownership.

Performed database Backups and Recovery both locally and remotely,

Develop advanced SQL query, store procedure, function, trigger and

cursor for large database environment.

Design, managing and monitoring reporting server using SSRS.

Troubleshooting and resolve database and SSIS related issues in

production environment.

Managing and maintain high availability for the database such as

Data mirroring and SQL cluster.

GFK Australia

Start Date September 2006

End Date August 2008

Position/Title Database Administrator / Developer

Responsibility

Platform - Windows 2003 Server, Microsoft CRM, UNIX

Tools Used - Microsoft SQL Server 2000/2005/2008, MS-Access,

VB.Net

Description - as Database Administrator/Developer primary

responsibilities includes install, upgrade, design and configuring

of database server.

Develop advanced SQL query, store procedure, function, trigger and

cursor for large database environment.

Create, design and maintain database using data modeling tools.

Develop and maintain SSIS and DTS scripts for the deployment of

database server.

Design and develop report using reporting services (SSRS) and

Crystal report.

Performed database maintenance and performance tuning for the SQL

Server.

Managing, monitoring and optimizing database server to provide

security for business user and clients in multi database

environment.

Implementing, configuring, consolidating and managing database and

windows server.

Performed database Backups and Recovery both locally and remotely.

Managing and maintain high availability for the database such as

Log Shipping, and replication.

Troubleshooting and resolve database and network related issues in

production environment

ICICI Bank Ltd, India

Start Date April 2002

End Date March 2004

Position/Title Database Administrator

Responsibility

Platform - Windows 2003 Server, UNIX

Tools Used - Microsoft SQL Server 2000, MS-Access, VB.Net

Description - as Database Administrator primary responsibilities

includes install, upgrade, design and configuring of database

server.

Provide technical support for database maintenance and disaster

recovery.

Performed system maintenance and analysis database and index

tuning for the query.

Performed database Backups and Recovery locally and remotely.

Create document and design for the database standards using data

modeling tools

Develop and maintain DTS scripts for the deployment of database

server.

Managing, monitoring and optimizing database to provide security

for business user and clients in multi database environment.

Used advanced SQL query, store procedure, function, trigger to

design and development of database Server.

Ensure optimal performance, reliability, security and availability

of database environment.

Managing and maintain disaster recovery for the database.

Align InfoTech Pvt. Ltd. India

Start Date January 2001

End Date April 2002

Position/Title Database support admin

Responsibility

Platform - Windows 2003 Server

Tools Used - Microsoft SQL Server 2000, Oracle 8i/9i, VB 6.0

Description - As a Database support admin primary responsibilities

include installing, design and configuring of database server both

SQL and Oracle.

Used advanced SQL query, store procedure, function, trigger to

design and development of database Server.

Performed system maintenance and analysis database and index

tuning for the query.

Managing, monitoring and optimizing database to provide security

for business user and clients.

Enrolling user and manage internal and external database security.

Performed database Backups and Recovery both locally and remotely.

Create and update report using Crystal Report.

Managing primary objects such as table, views, indexes.

Troubleshooting issues for database server in production

environment.

Deliver proactive support and maintenance for assigned databases

to optimize database performance.

Non Technical Skills

Excellent work ethic and common sense approach to work challenges.

Ability to build strong customer relationship and quality

customer's service.

Good communication skills, both verbal and written.

Strong analytical capabilities and management skills.

Positive personality and a strong work ethic.

Ability and allocating a time to-do multi task within a time

limit.

Ability to get high quality result

Ability to work independently and within a team.

Aptitude to work unsupervised and under pressure.

Willingness to adapt and learn new technologies.

Willingness to work outside normal shift hours.

Reference:

Available as per request.

Contact this candidate