SUMMARY

• 10 years of experience in analysis, design, development and administration of MS SQL Server and MySql objects
• Extensive experience in troubleshooting SQL issues, finding performance bottlenecks and fine tuning the database objects.
• Expert in debugging an application using the debugging tools provided by Visual Studio .Net IDE.
• Expert in TSQL DDL/DML, perform most of the SQL Server Enterprise Manager/ Management Studio/SQL Server Data Tools.
• Experience in Creating Tables, Views, Triggers, Stored Procedures, User Defined Functions and other T SQL statements for various applications.
• Expert in designing complex reports like reports using Cascading parameters, Drill - Through and Drill down Reports, Parameterized Reports and Report Models and Adhoc reports using SQL Server Reporting Services (SSRS) based on client requirement.
• Expert in Database design, modelling, installing, upgrading SQL server and Server Configuration, Extensively worked on Database Backup, Recovery & Replication
• Strong experience in production database maintaince activities.
• Knowledge of Agile/Scrum working methodology.
• Expert level skills on T-SQL and query optimization, developing ETL strategies using SSIS, Database designing using SQL Server 2005/2008/2012.
• Expertise in all stages of Software Development Life Cycle (SDLC) including Requirements, Analysis, Design, implementation, integration, testing, deployment and post deployment activities.
• Good experience and understanding of database design, relational integrity constraints, OLAP, OLTP and normalizations.
• Sound Knowledge in Search techniques, Partition tables, and Query optimization, Profiler, Backup & Restore, Data Migration, Replication and Mirroring.
• Experience in creating Jobs, Alerts, SQL Mail Agent
• Strong analytical, problem troubleshooting/solving skills.
• Familiar with Complex Reporting Requirements - Complex Drill-Through, charts, Discontinuous Cross Tabs and Summary Reports. Experience in dimensional modeling using Star Schema and Snow-Flake Schema, Data Analysis providing Business Intelligence solutions.
• Very good working knowledge of MS SQL Server Query Engine, Execution Plan, Indexing and other performance tuning techniques.
• Self-learner, adaptable and team player with excellent communication, interpersonal, presentation and technical writing skills with an ability to work under stress.
• Expertise in writing T-SQL Queries using Joins, Sub queries, Cursors, stored procedures, functions, triggers and building packages and Performance tuning on Complex queries, stored procedures, function, SSIS packages, SSRS Reports, and Cube.
• Transfer databases, data base objects, jobs, logins, messages, and master stored procedures objects between servers using SSIS packages
• Hands on experienced in Deploying, Build.
• Good exposure on Agile/Scrum methodologies and Responsible to possess the ownership of the tasks from all aspects.
• Good working experience on other data bases like MYSQL.
• Good knowledge in Toll/Transport domain.
• Strong learning and problem solving skills, excellent communication skills both written and verbal
• Strong knowledge in SQL Server Database objects design, developing T-SQL queries, Stored Procedures, User Defined Functions, and Views

TECHNICAL SKILLS

Operating Systems: Windows Server 2003, 2008 & XP Professional

GUI Tools: DTS Import/Export,SQL Server Integration Services.

Database Application Software: SQL Server 2005 through 2012.

DB Utilities: SQL Server Management Utilities, Query Analyzer.

Languages: T-SQL, PL/SQL, C, C++

Change Management Tool: Tortoise SVN.

Deployment Tools: Team City,Kudos.

Monitoring Tolls: SQL Profiler,SpotLight,Ignite.

VPN: Cisco VPN

Web Severs: IIS

Reports Design Tools: MS Access, Excel, SSRS.

PROFESSIONAL EXPERIENCE

Confidential, Chandler, AZ

Sr. SQL Server DBA

Responsibilities:

• Installing and Configuring SQL Server on Windows systems.
• Capacity Planning for new databases and setting up environments.
• SQL Server installation, configurations, backup/restore, Maintenance Plans and handled databases Monitoring SQL Server agent jobs and troubleshooting the failed job
• Involved in development of automated daily, weekly and monthly system maintenance tasks such as database backup, integrity verification, replication verification, and indexing updates.
• Involved in designing and creating Databases, Tables, Views, Stored Procedures and Triggers.
• Identified, tested and resolved database performance issues to ensure data optimization.
• Worked in a Control Environment and familiar with change management process.
• Implementation of system wide security policies and trouble shooting.
• Managed Logins and Users like adding logins, roles, groups to the Windows Server and MS SQL Server and maintaining proper security procedures.
• Placed the huge table/non-clustered index on the separate file group to improve the performance.
• Helping application teams in query analyzing and its optimization. Coordinating with users for downtime and maintain the system 24X7 running.
• Assisted on the Adhoc -Query Requests based on the requirement by using Joins, Sub Queries

Environment: SQL Server 2012, Business Intelligence Development Studio,SQL Profiler,QueryAnalyzer, Kudos,Tortoise,TeamCity.

Confidential

SQL Server DBA

Responsibilities:

• Installing and Configuring MS SQL Server 2008 R2, and responsible for configuration, tuning and provide support to all Production and development servers.
• Monitoring prod database SQL instances, and optimizing database performance based on the analysis, and consideration of various options including indexing, partitioning, T-SQL enhancements, etc.
• Analyzing business requirements and build logical data models that describe all the data and relationships between the data.
• Responsible for defining Check constraints, Business Rules, tuning data, indexes, and queries.
• Capacity Planning for new databases and setting up environments.
• Developing SQL scripts for maintaining administration tasks.
• Managing Security of SQL Server Databases by creating Database Users, Roles and assigning proper permissions according to the business requirements.
• Prepared the reports for the day-to- day as well as weekly/monthly purposes.
• Applying Performance Tuning Techniques to ensure data optimization.
• Implementation of system wide security policies and trouble shooting.
• Created Maintenance Plans to checking database integrity, rebuilding indexes and updating statistics.
• Performed all aspects of database administration, including data modeling, backups and recovery.

Environment: MS SQL Server 2008,Business Intelligence Development Studio, Microsoft Office Excel, SSIS, SSRS, Ignite Monitoring Tool,Cisco VPN,Tortoise SVN.

Confidential, Miami, FL

Senior SQL Server Developer & DBA

Responsibilities:

• Installing and Configuring Sql Server on Linux systems.
• I’ve been involved in performance tuning code, and tweaked server side settings that helped speed up the performance.
• I’ve been managing Primary roles, and responsibilities, along with being Secondary for different
• Creation of logins, users, granting database level access, and managing logins across the prod environments.
• Providing 24/7 support as, and when needed, and follow an on-call rotation policy as defined by the company.
• Created Maintenance Plans to checking database integrity, rebuilding indexes and updating statistics
• Creation of Stored Procedures required by the various reports to retrieve data from the database.
• Supported Load Testing activity by setting up and scheduling Performance Monitor (Data Collector Sets) and SQL Server Profiler Trace and monitoring them during the activity.
• Extensively worked on Database/schema design and Database modelling
• Monitoring and troubleshooting of SQL performance issues, such as SQL timeouts.
• Building relationships with client, and customer, and providing exceptional service, along with being a team player, and coordinating within the team, and managing various responsibilities.
• Worked on the Adhoc -Query Requests based on the requirement by using Joins, Sub Queries
• Deployed SQL jobs using customized deployment scripts across different environments

Environment: Percona MySQL,MYSQL Work Bench,SQL Yog,Linux,WINSCP,Putty,SpotLight.

Confidential, Tampa, FL

Senior SQL Server Developer & DBA

Responsibilities:

• Created customized scripts for index maintenance by defragging based on no. of pages that has been fragmented, and the fragmentation level, and deployed jobs to handle one database at a time to avoid possible schedule conflicts, blocking, and deadlocks.
• Code review, and code changes through proper change management process across different environments.
• Created T-SQL scripts such as stored procedures, user defined functions, and views for reporting.
• Developed database objects like tables, stored procedures, views, triggers etc.
• Extensively worked on Database/schema design and Database modelling
• Creating databases and logins and users with permissions.
• Worked extensively on Database space management, performance monitoring and alert management.
• On Call DBA support
• Worked on the Adhoc -Query Requests based on the requirement by using Joins, Sub Queries
• Troubleshooting slow running queries, or cpu spike issues by pulling the plan for the particular piece of code in cache, and doing plan analysis.
• Created, and deployed various SQL jobs, and configured them to run as per the schedule determined by the application team
• Expert in Monitoring Disk space, Improving Efficiency in databases including Index Tuning Wizard, Query tuning, and performing other maintenance tasks.

Environment: Oracle MySQL, Linux, Tortoise SVN,MYSQL Work Bench,SQL Yog,WIN SCP,Putty, SpotLight.

Confidential

Senior SQL Server Developer

Responsibilities:

• Analysis of the specifications
• Designing the database objects according to the business rules
• Developing the database objects to fulfil the user needs and application requirements.
• Involved in performance tuning the store procedures.
• Designed, Managed and Published various reports using SQL Server Reporting Services 2008
• Created different type of reports including: Tabular forms, Matrix (cross Tab report) form, Conditional, List items, Charts and Sub reports
• Accessing & managing Reporting Services in .Net using Reporting Viewer control and RSS URL dynamically.
• Unit Testing on Reports, Packages and deploying reports and SSIS packages into testing and production boxes.

Environment: MS SQL Server 2008, SSIS,SSRS, Tortoise SVN,CISCO VPN.

Confidential

Senior SQL Developer

Responsibilities:

• Worked on SSIS packages for moving data from source system to current system.
• Worked on SSIS packages for Jobs.
• Worked on Reports with SSRS
• Worked on Development of Stored Procedures, Functions, Triggers, and Indexes.
• Development of Complex Queries using Sub Queries, Joins, Set Operators.
• Provided technical leadership and contributed as the lead developer in building a solution for to meet the customer requirements
• Collaborate with the team on application architecture design and decision-making Involvement, as well as work estimation and resource planning
• Involved in DB design, Query optimization, Stored Procedures, Backup & Restore.
• Involved in Partitioning, Load bulk data, truncate partition and Search techniques.
• Involved in integrating SSRS (Sql Server Reporting Services) Reports in dot net and generating reports for Confidential .

Environment: Microsoft Office Excel, MYSQL 5.1.,Mysql Workbench,Mysql Yog.

Confidential

Senior SQL Developer

Responsibilities:

• Involved in Database design.
• Data migration between different environments and Third Party Databases.
• Monitored Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Deployed SQL jobs using customized deployment scripts across different environments
• Involved in Search techniques, Query optimization, Profiler, SQL Jobs, Backup & Restore and Data Migration (With Quires only).
• Monitored the Performance of the SQL Server by using Performance Monitor, SQL Profiler, Performance Analysis and Spotlight.
• Managing Security of SQL Server Databases by creating Server Logins, Database Users, Roles and assigning permissions in compliance with standards and resolving Account Locking issues by coordinating with Active directory Group.
• Responsible for database backups & restoration and scheduling backup strategies.
• Involved in jobs with SSIS packages.
• Involved in integrating SSRS (Sql Server Reporting Services) Reports in dot net and generating reports.
• Responsible to bring the awareness of the importance and techniques involved in DB tuning and Performance, to the developers.
• Involved in optimizing code and improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks.
• Experience in working with 24/7 production Environment with thorough understanding of Standard Operation Procedures (SOP) and Service Level Agreements (SLA).
• Troubleshooting issues related to the SQL Production with quick and high quality.

Environment: MS SQL Server 2008,Microsoft Office Excel, Erwin, SSIS, VSS, Ignite,SQL Profiler,QueryAnalyzer.

Confidential

SQL Developer

Responsibilities:

• Requirement Analysis, Design and Development
• Performed code reviews, unit testing and escalate to respective developers.
• Involved in Database design, store procedures
• Support production deployment and maintenance of applications
• Data stored In MySQL Database and retrieve using ADO.NET
• Writing SQL Quires while creating stored procedure.
• Worked on Reports with SSRS

Environment: MySQL 5.1,My Sql Yog.

Confidential

.Net / SQL Developer

Responsibilities:

• Analyzed changes needed as per the requirements
• Installed and maintained the build test environment
• Generated documents using Crystal Reports from .Net Framework
• Interact with customer for requirements gathering.
• Involved in Preparing wireframes
• Designed presentation layer web pages using Asp.Net
• Involved in Reports of Admin module.
• Developed Business objects using C#
• Data stored In My Sql Database and retrieve using ADO.NET
• Writing Sql Quires while creating stored procedure.

Environment: ASP.NET, C#, Ms Visual studio 2008 and MySQL 5.1