OBJECTIVE

• Aspire to work in an organization where there is scope of taking up challenges and opportunities, learning different aspects, understanding and appreciating others views and grow into higher roles by contributing to its development.

SUMMARY

• 4+ years of experience in IT having experience Database Design for very large and complex databases in SQL Server 2014, 2012, 2008 R2.
• Competence in DDL, DML, DCL (TSQL) queries and in design and normalization of the database tables.
• Expertise in writing T - SQL stored procedures, triggers and functions.
• Establishing Referential Integrity by using data constraints (primary key, foreign key) and Entity and Domain Integrity through (unique, check, default, identity)
• Expertise in writing complex SQL queries involving multiple Tables (Inner and Outer Joins) and developed set based programming using CTE, Cross Apply and Functions
• Proficient in query tuning and performance tuning to improve database performance and availability.
• Skilled in creating and updating clustered and non-clustered indexes to improve SQL Server performance.
• Experience in using DMV and dynamic management functions for finding out long running queries.
• Extensive Knowledge of advance query concepts (e.g. group by, having clause, union so on)
• Implemented the new SQL Server 2014 mechanisms like in-memory OLTP applications and 2012 mechanisms like data compression, online indexing, Contained Databases, security principals.
• Worked on logical and physical data base modeling with UML and ERWIN tools.
• Experience in Disaster Recovery Planning and Security Management operations.
• Proficiency and expertise in SQL Server Replication, Backup/Recovery, Disaster recovery and planning.
• Excellent in creating in multiple Data transformations provided by SSIS
• Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels.
• Troubleshoot performance problems, fine-tuning of databases and index Analysis.
• Excellent communication, Interpersonal and analytical skills.
• Ability to cope with pressure and stress and Strong inclination to meet the dead lines.
• Flexible to adapt to any new environment and work on any project. Desire to learn client Business Requirements assessing client needs to maximize performance.
• Experience of working throughout the SDLC of a project.
• Ability to design reports using SQL Server Reporting Services (SSRS) based on client requirements.
• Responsible for 24X7 production support on a call out rotation basis for all SQL Server databases

TECHNICAL SKILLS

Databases: MS SQL Server 2014, 2012, 2008, MS SQL Server 2005

Programming: Visual Basic 6, Visual Basic 5, C, C++, TSQL, PLSQL, Matlab

DBA Related: Database administration of MS SQL Server 2014, 2012,2008, 2005

Operating System: Windows 2008/2003 Advanced Server, NT & Windows 7x, Linux

Tools: Windows Active Directory, Backup Utility, SQL Lite Speed, Visio, Toad, Notepad++, Red Gate Products

Network Topologies: TCP/IP, DNS, WINS, DHCP, FTP, SNMP, SMTP

Simulation: AVR studio, VSG, VSA

PROFESSIONAL EXPERIENCE

Confidential, Jackson, MI

SQL Server Database Developer

Responsibilities:

• Interacted with Team and Analysis, Design and Develop database using ER Diagram, Normalization and relational database concept.
• Involved in Design, Development and testing of the system
• DevelopedSQL Server Stored Procedures, Tuned SQL Queries( using Indexes and Execution Plan)
• DevelopedUser Defined Functions and created Views
• Created Triggers to maintain the Referential Integrity.
• Gathered requirements from business analyst.
• Prepare detailed statistical reports inMS Accessand MS Excel to track progress of weekly, monthly and quarterly customers and sales growth.
• Reviewed existing business procedures and recommended and implemented changes.
• Trouble shoot problems with the various teams including network related issues
• Creating and automating the regular Jobs
• Tuned and Optimized SQL Queries using Execution Plan and Profiler
• Rebuilding Indexes and Tables as part of Performance Tuning Exercise
• Involved in performing database Backup and Recovery
• Worked on Documentation using MS word
• Reviewed existing business procedures and recommended and implemented changes.

Confidential, Tampa, FL

Associate SQL Server Administrator

Responsibilities:

• Developed physical data models and created DDL scripts to create database schema and database objects
• Designed data models using Erwin.
• Wrote user requirement documents based on functional specification.
• Created new tables, written stored procedures, triggers for Application Developers and some user defined functions. Created SQL scripts for tuning and scheduling.
• Involved in performing data conversions from flat files into a normalized database structure.
• Developed functions, views and triggers for automation.
• Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables and also optimized the procedures and triggers to be used in production.
• Provideddisaster recoveryprocedures and policies forbackup and recoveryof Databases.
• Performance Tuningin SQL Server 2008 usingSQL ProfilerandData Loading.
• Installing SQL Server Client side utilities and tools for all the front-end developers/programmers.
• Created DTS package to schedule the jobs for batch processing.
• Involved in performance tuning to optimize SQL queries using query analyzer.
• Created indexes, Constraints and rules on database objects for optimization.
• Creation/ Maintenance of Indexes for various fast and efficient reporting processes
• Monitored the Database Growth and Space Requirement. Handling Users/Logins/User Rights.
• Managing historical data from various heterogeneous data sources (i.e. Excel, Access).
• Used linked tables, pass through queries and many other access features also wrote code in Visual Basic to perform some complex reporting tasks.

Confidential

SQL Server Database Developer

Responsibilities:

• Actively participated in gathering of Requirement and System Specification.
• Worked on complex T-SQLstatements, and implemented various codes and functions.
• Involved in creating Stored Procedures, views, tables, constrains.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent Data entry into the database.
• Wrote complex stored procedures to process employee's requirement and generating.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization.
• Created Database Maintenance Plans for the Performance ofSQLServer, which covers Database Integrity.
• Debugged the T-SQLqueries for performance tuning.
• Checked & updated Database Statistics and Re-indexing.
• Created Users and Roles, and managed security and permission of database.
• Writing the stored procedures, checking the code for efficiency. Routine backups and restoration.
• Develop and maintain in-house utilities to automate problem determination, change implementation and monitoring activities.
• Administrative and Production support for various applications in all environments.
• Database Backup Procedures, Restoration Procedures, Disaster Recovery procedures and Contingency plans. Testing and implementing these procedures.

Confidential

SQL Server Database Developer

Responsibilities:

• Using SQL Server Setup Program we installed SQL Server Enterprise manger tools which helped in various analysis
• Configured and monitored database application.
• Developed functions, views and triggers for automation.
• Created tables, indexes and constraints according to the database.
• Achieved module integrity by developing stored procedures .
• Provideddisaster recoveryprocedures and policies forbackup and recoveryof Databases.
• Data security is achieved by creating logins, defining user roles and views
• Wrote database triggers in T-SQL to check the referential integrity of the database.
• Used Data Transformation Services (DTS) an Extract Transform Loading (ETL) tool of SQL Server to populate data from various data sources, creating packages for different data loading operations for application.
• Managed the use of disk space, memory and connections.
• Designed VB forms using the forms and crystal reports were made for business reporting purpose.
• Developed Reports to generate daily, weekly, monthly, quarterly, yearly Reports using Crystal Reports.
• Prepared of project documentation.