Gurvinder Singh

E- Mail : wr8zh9@r.postjobfree.com

Mobile: +919*********

Qualifications Profile

======================

A Database Administrator with 12+ years of good experience in designing,

programming, and administering SQL Server database applications through

all project life cycle phases.

- Expertise in data backup and restoration, application configuration,

performance tuning, and user access control.

- Ability to determine and meet database requirements and create modules,

data flow diagrams, tables, and queries.

- Recognized as a creative and effective planner, troubleshooter, and

problem solver of database and data model issues.

- Good communication, presentation, and documentation skills training and

supporting technical teams and end users.

- Resourceful organizer and leader in fast- paced, time- critical database

environments.

Core Competencies:

==================

- Database Administration

- Data Backup & Disaster Recovery

- DB Design and Optimization

- Database Testing

- User Training & Support

- Capacity Planning

- Change Management

Technical Skills

================

Software Tools: CASE Tools, Microsoft Visio, Migration, Replication

(Snapshot/Transactional/Peer- to- Peer/Merge), DTS,

BULK INSERT, BCP, Log Shipping, SQL Server Profiler,

Database Tuning Advisor, Notification Services, Indexing,

Full Text Search, SSMS

Languages: SQL, Microsoft T- SQL

Platforms: Microsoft Windows XP/2000/2003 Server/NT Server/9x

Databases: Microsoft SQL Server 2000/2005/2008

Professional Experience

=======================

Visionaire Technologies (I) Pvt. ltd

October 2006 to present

Sr. Database administrator

- Design and document database architecture. Data Modeling.

- Build database scheme, tables and permissions.

- Analyze and sustain capacity and performance requirements.

- Analyze, consolidate and tune database for optimal efficiency.

- Oversee backup, mirroring, replication and failover.

- Provide 24/7 support for critical situations.

- Monitoring performance and managing parameters to provide fast query

responses to front- end users.

- Refining the physical design to meet system storage requirements.

- Installing and testing new versions of the database management system

(DBMS).

- Writing database documentation, including data standards, procedures and

definitions for the data dictionary (metadata).

- Establish and maintain policies, standard Operating procedures, and

associated documentation for user interaction with the database

environment.

- Controlling access permissions and privileges.

- Developing, managing and testing back- up and recovery plans.

- Ensuring that storage, archiving, back- up and recovery procedures are

functioning correctly.

- Capacity planning.

- Working closely with IT project managers, database programmers and web

developers.

- Communicating regularly with technical, applications and operational staff

to ensure database integrity and security.

- Configured Replication servers and Transactional Replication between

production and standby server for high availability/disaster recovery.

- Created SSIS packages to clean and load data.

- Created SSIS packages to automate maintenance, database backup, update

statistics, re- build indexes, create error log for event during data load.

- Schedule packages and different maintenance tasks using SQL Server Jobs.

- Created Alerts, Notifications, and Emails for system errors.

- Creation and Maintenance of Indexes using Index Tuning Advisor, Query

Optimizer to select best indexing plan to be deployed.

- Configure SQL Server Log Shipping between primary and secondary servers.

- Manage hierarchical security (access control, permissions, encryption keys

and certificates) for databases and ensure data integrity.

Authorgen Technologies Pvt. Ltd, Chandigarh, India

May 2002 to 20 Sept. 2006

Database Administrator

- Served as DBA for numerous projects.

- Customize and update databases.

- Administer and maintain user access.

- Troubleshoot and resolve production and operation problems.

- Create Alerts, Notifications and e- mails for system errors.

- Tune database and query performance. Performance optimization of Database

Instances and Applications.

- Administration of multiple SQL Server databases for both real- time and

batch applications.

- Performing physical database design at the object level, create DDL

scripts, define database snapshots, table partitions, and backup/recovery

strategy.

- Database tuning and administration including security management, instance

performance monitoring, table space utilization, schema object management,

database capacity planning, bottlenecks and offensive SQL activity

monitoring and resolution.

- Assist developers with application design and performance tuning.

- Monitoring database activities, checking for tablespace availability,

checking Alert log file for errors and monitoring hit ratios.

- Tuning for I/O contention, memory contention, row migration, block

contention etc.

- Created SSIS packages to clean and load data.

- Created SSIS packages to automate maintenance, database backup, update

statistics, re- build indexes, create error log for event during data load.

- Schedule packages and different maintenance tasks using SQL Server Jobs.

- Configured Replication servers and Transactional Replication between

production and standby server for high availability/disaster recovery.

Key Achievement:

----------------

- Established standards for Database Environments.

- Establish and maintain policies, standard Operating procedures, and

associated documentation for user interaction with the database

environment.

- Redesigned a thorough backup and recovery strategy for all production

systems.

- Developed and Implemented Standard Test Plan Layouts for all projects

developed through all project Lifecycle phases within the company.

Atec Software, Chandigarh, India

December 1998 – November 2001

Software Engineer/Database Administrator

- Wrote performance tuning guidelines to enhance the quality of the product

for all current and future code development.

- Established standards for Database Environments.

- Redesigned a thorough backup and recovery strategy for all production

systems.

- Developed and Implemented Standard Test Plan Layouts for all projects

developed through all project Lifecycle phases within the company.

- Designed and developed databases and applications to meet project

requirements.

- Monitored and optimized database performance.

- Provided data backup and restoration.

- Controlled user access and enrollment to ensure system security.

- Managed I/O issues to improve performance.

- Diagnosed and solved problems. Developed and delivered production- quality

reports.

- Monitoring database activities, checking for tablespace availability,

checking - Alert log file for errors and monitoring hit ratios.

- Application Query Tuning for I/O contention, memory contention, row

migration, block contention etc.

- Analyzing access paths for indexing, data integrity, consistency etc.

- SQL Server 2000 Index and Lock management, Primary & Foreign Key

monitoring & verification, Data Security and patch verification. Evaluate

query execution plan, use DBCC OPENTRAN to locate long- running

transactions, use SQL Profiler to monitor table and index scans.

Key Achievements:

-----------------

- Traveled to USA (H1B Visa) as a Consultant for the Surface Mining

Information System (SMIS) Project for the State of Kentucky.

- Redesigned State of Kentucky’s mainframe COBOL system in Oracle.

- Enabled enforcement tracking and exploration notices.

- Assisted developers to design 40 new forms, triggers, and stored/packaged

procedures.

- Wrote and established standards for database environments.

- Formulated backup policies, SQL Tuning, Monitored Performance Issues, set

up coding standards.

- Worked with Quantum Corporation Milpitas, California, USA to make the

existing system for supply chain planning.

- Deployed Plan and Demand Forecasting.

- Developed PL/SQL for Deploy Plan and forms related to master creation and

modified shell scripts for loader and batch processing.

- Assisted developers to write new and modified existing stored procedures,

database packages. Modified shell scripts also.

- Formulated backup policies and coding standards.

- Produced plan for smooth life cycle development progress from initiation

to implementation.

- Established test and production upgrade implementation.

Cepham Milk Specialists, Derabassi, India

May 1996 – October 1998

Oracle Database Administrator/Instrumentation Engineer

- Installed Oracle and created databases and primary storage objects. Tuned

database performance and controlled user access. Backed up and recovered

data. Framed and documented backup and recovery strategies. Developed

stored procedures, packaged, triggers, and queries. Trained and led 15

instrumentation employees.

Key Achievements:

-----------------

- Designed and implemented inventory system for instrumentation and accounts

department.

- Programmed MC6800 for PLCs for expansion of evaporator and lactose plant

sections.

- Increased main application performance speed by five times and enabled

24x7 operations.

Texla Electronics, Ludhiana, India

January 1995 – March 1996

Production Manager

- Trained and supervised 150 workers in production engineering. Mentored 10

new employees.

Key Achievement:

----------------

- Increased product turnover 20% and guided five new employees to

promotions.

Kamrite Electronics, Mohali, India

June 1993 – December 1994

Production & Quality Control Engineer

- Provided production and quality control engineering functions for

television department.

Key Achievement:

----------------

- Increased product turnover 10% and earned ISO 9000 certification for

company.

Formal Education

================

Bachelor of Engineering, Electronics (1992)

Osmanabad College of Engineering Affiliated to Marathawada University,

Aurangabad, Maharashtra, India

Certification

=============

- Oracle Database Administration & Development Using Developer 2000

- Oracle Certified Professional (OCP), Oracle 8, 8i.

- Design of Switched Mode Power Supplies

- PC Repair, Servicing, & Maintenance.

Personal Information

====================

Marital Status : Married

Father’s Name : Mr. Bahadur Singh

Permanent Address : House No. 3010, Phase 07, Mohali (Punjab)

Contact this candidate