Yogendrasinh Surma

SQL Server DBA

*** ****** **., *** # *,

Naugatuck,CT,06770

(P): 516-***-****

Email:kulzws@r.postjobfree.com

SUMMARY:

Microsoft Certified Technology Specialist with 2+ years of IT experience in SQL Server database administration .

TECHNICAL SUMMARY:

• Extensive experience with SQL Server and Transact-SQL (T-SQL) in constructing stored procedures, user-defined functions(UDFs), triggers, indexes, relational database models, data dictionaries, and data integrity.

• Extensive domain knowledge of online marketing website and e-commerce websites.

• Hands on experience in analyzing, designing, tuning, and developing Client/Server, Business Intelligence (BI) database applications and various segments of SDLC, using MS SQL Server 2008/2005 DTS/SSIS Services.

• Hands on Experience in installing, configuring, managing, monitoring and troubleshooting SQL 2005,SQL2008

• Successfully handled web servers to support various websites for key clients.

• Experienced in the installation and configuration of SQL Server 2005 ,SQL Server 2008

• Expertise in performing administrative tasks: database files management, backup/restore, security management, data integration and synchronization.

• Solid experience and outstanding knowledge of high availability SQL Server solutions, including Database Mirroring, Log shipping, Clustering and Replication.

• Backup and Recovery strategy development and implementation.

• Experienced in upgrading old SQL server instance to SQL server 2005 instance and SQL server 2008 instances.

• Data migration from one system to a new one and reconstruction of the data.

• Hands on Experience in Extracting and transforming Data with SQL Server 2008 using SSIS,

• Extensive experience with SQL scripts, stored procedures, triggers, functions, SQL Performance tuning and transactions analysis, thorough understanding of indices and statistics.

• Solid experience in data-flow and SSIS/DTS package design and construction.

• Experience in performance monitoring and performance tuning by implementing efficient schemas, optimizing queries, Tuning indexes using Index Tuning Wizard and Database Consistency Checks using DBCC utilities along with Windows Administration.

• Extensive experience in project management and execution involving multiple concurrent development projects with a proven successful track record.

• Ability to prioritize and meet operational deadlines in a fast paced environment.

• Motivated Team Player who works well independently and in a team environment.

• Proven Multi-Tasking ability in a deadline-oriented atmosphere.

• Self-motivated and detail oriented.

Technical Expertise:-

Operating Systems Windows 2000 Server, Windows 2000 Advanced server, Windows 2003 Server,SP3, Windows NT 4.0, Windows XP.Linux/AIX

Hardware IBM Compatibles, HP, Compaq,Dell

Languages SQL,T-SQL, C, C++

RDBMS SQL Server 2005,SQL Server 2008

OLAP Analysis Services

Database Query Tools SS Management Studio , SQL Developer

Web-Applications IIS Administration

PROFESSIONAL EXPERIENCE:

Lupin Laboratories, New Delhi, India Jan 07- Dec 08

Role: SQL Server DBA

Lupin Laboratories Limited is India’s one of the largest pharmaceutical Company, manufacturing and marketing world class generics, branded generic pharmaceuticals and active pharmaceutical ingredients. The project involved Database Administration Support (Development & Production), Software Installation, Database Performance Tuning & Maintenance, Database Back up and Recovery, Export/Import of Data, Replication, Creating and Implementing of various Installs and Database Auditing Analyzing.

Responsibilities:

• Responsible for upgrading and migrating of various applications in Access to SQL 2005

• SQL Server Administration involving planning and implementing Back up and Recovery Strategies

• Analysis of SQL queries and optimizing performance through modifying table design and application code

• Configuring the standby servers and setting guidelines to automate recovery scenarios

Implementation of data transfer through DTS

• Setting up and configuring transaction and merge replication of databases

• Monitoring and fine tuning of SQL Server performance and ensuring integrity

• Developing triggers and stored procedures to enforce business rules

• Releasing scripts on the production servers

• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2005

• Wrote complex stored procedures and user defined functions

• Creating stored procedures, triggers, cursors, Views etc.

• Backups and recoveries: backup standards and schedules, recovery procedures.

• Exporting/importing data using DTS and SSIS.

• Supported developer to write and debug SSIS packages.

Environment: SQL server 2005, SSMS, SCM, BI

Lupin Laboratories, Ankaleshwar, India

Role: as an intern SQL Server DBA

Feb 06 - Jan 07

Lupin Laboratories Limited is India’s one of the largest pharmaceutical Company, manufacturing and marketing world class generics, branded generic pharmaceuticals and active pharmaceutical ingredients. The project involved Database Administration Support (Development & Production), Software Installation, Database Performance Tuning & Maintenance, Database Back up and Recovery, Export/Import of Data, Replication, Creating and Implementing of various Installs and Database Auditing Analyzing.

• Responsible for upgrading and migrating of various applications in Access to SQL 2005

• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2000

• Creating stored procedures, triggers, cursors, Views etc.

• Verify, maintain & troubleshoot database backups, integrity checks and scheduled jobs.

• Monitor daily backup of databases on production servers.

• Used DBCC commands for maintaining Database consistency

Environment: SQL server 2005, SSMS, SCM, BI

Education Qualification:-

Master of Science in Computer Engineering G.P.A. 3.33

¬University of Bridgeport, CT,USA-06604.

¬Bachelor of Engineering in Electronics and communication Engineering. G.P.A. 3.57

C.K.Pithawala College of Engineering, Surat, Gujarat, India.

Relevant Coursework

Graduate: Object Oriented Programming Using C++, Data and Computer Communication, SQL, LAN, Network Administration, Computer Networks, Digital Design-I and II, Computer Architecture, Digital Signal Processing, UNIX, Introduction to VLSI.

¬

¬Undergraduate: Analog Electronics, Computer Architecture ,C ,C++, SQL , Microprocessor 1 &2 , Microcontroller, Digital Signal Design, Computer Networks, Communication-I & II, Mobile Communication, Microwave Communication, VLSI .

Contact this candidate