SUMMARY:

• Over 5+ years of experience in the Analysis, Design, Development, Implementation and Testing of applications using Microsoft SQL Server (2008, 2008R2, 2012, 2014) and couple of years of experience in Business Intelligence Suite(SSIS, SSAS and SSRS) across various SDLC environments (AGILE Methodology).
• Experienced in developing technical documentation in various stages of Software Development Life Cycle(SDLC).
• Strong experience in using all types of SQL Server Constraints, SQL Server Database design, Database maintenance, developing Transact - SQL queries, Merge using SQL Servers to facilitate efficient data manipulation and data consistency.
• Hands on experience in creating Maintenance plans, scheduling SQL Server Jobs, Automatic administrative task and Configuring Database Mail.
• Expertise in Performance tuning Optimization, Database Consistency Checks, Indexes and Statistics by using DMVs/DMFs and native tools like Database Tuning Advisor (DAT),SQL Server Profiler, activity monitor, Event viewer for performance analysis.
• Extensive experience in controlling the user privileges, Monitoring the Security and Audit issues as per Standards.
• Experience using SQL Server 2012 new features like Policy Based Management Data Compression, Resource Governor, Performance Data Collector and Transparent Data Encryption (TDE).
• Strong experience in providing 24x7Production support and on-call rotation
• Experience in Database Migration. Migrated SQL Server 2005 to SQL 2008 SQL Server 2008R2 to 2012 and 2014.
• Flexible, enthusiastic and project oriented team player with solid communication and leadership skills to develop creative solution for challenging client needs.
• Extensive experience in creation and maintenance of Stored Procedures, Triggers, Views, Functions.
• Experience in installing Service Packs and updates for SQL Server instances
• Expert in providing HA solutions support for SQL Server Failover clustered instances mirroring log shipping replication and Always on Availability groups.
• Experienced in Database Backup, Restore and Disaster Recovery procedures.
• Experienced in MS SQL Server planning, installation and configuration of SQL Server (2012, 2008 R2,2008 and 2005)on Windows Server 2012,2008 both on physical and virtual environments.

TECHNICAL SKILLS:

Languages: T-SQL, HTML, DHTML, XML, JavaScript, ASP.net ETL Tools: SSIS/DTS, BCP, OSQL, ISQL

RDBMS : SQL Server 2016/2014/2012/2008 R2/2008/2005, MS Access 2007 & 2003

Tools: /Utilities: Toad Data Modeler and IDERA

Version Control: Clear case, SVN, RTC

Operating Systems: Windows Server 2012R2/2012/2008R2/2008, Windows XP/NT4.0

Networking: Directory, TCP/IP, DHCP/DNS, LAN

PROFESSIONAL EXPERIENCE:

Confidential

Sr. SQL SERVER DBA

Responsibilities:

• Gathering the requirements, Creation/review of Business, Functional requirement Documents for business systems, experience in database design process and data modeling process.
• Developed and created new database objects including tables, views, indexes, triggers, stored procedures and functions.
• Implemented backup and recovery strategies based on RPO and RTO
• Configured Job, maintenance plans, database Mail and operators Create and modify of the database objects according to the requirement. Database migrations from SQL 2005, 2008 R2 to 2012
• Evaluated data storage considerations to store databases and transaction logs. Created databases using SQL Server Management Studio, Database Wizard and Transact SQL Statements.
• Implemented table and index partitioning. Maintained user Permissions and login, assigned the least required Permission Monitoring Event Viewers, SQL Error logs Monitoring servers through spotlight alerts.
• Installed and configured different versions of SQL Server in clustered and standalone servers.
• Optimized SQL queries for improved Performance and availability
• Working with development teams o resolve ETL package errors and deployments.
• Monitoring and Troubleshooting SQL server Performance using SQL Server Profiler, system Monitor, Database Engine Tuning Advisor, Dynamic Management Views and Functions and Resolving Blocking and Deadlocking Issues.
• Created Databases, tables and provide constraints and user defined rules and defaults.
• Performed operations like Data reconciliation, validation and error handling after Extracting data into SQL Server
• Configured monitored and troubleshoot HA/DR Log Shipping, Clustering, AlwaysOn Availablity Group and Replication Transactional and Merge.
• Working on production Break fix issue which include performance, blocking and space related issues.
• Scheduling and implementing patching activities i.e.Service packs and cumulative upgrades as per baseline standards.

Environment: SQL Server 2008R2/2012, SQL BI Suite (SQL Server Integration Services, SQL Server Reporting Services), TFS, SharePoint, MS Access 2007, Excel 2007, XML, .NET Framework 2.0 & 3.0, Rational Rose, VSS, SVN, SQL Server 2005, XML, Python, WPF, Agile Development, . .NET Framework 2.0 & 3.0, ADO.NET, Extreme Programming, C, C++, VC++, C#, Purify, NUnit, CPPUnit, SQL 2000

Confidential

SQL DBA

Responsibilities:

• Used SQL Server in constructing Tables, Normalization techniques on database Tables.
• Creating Tables, Stored Procedures, Views, Indexes, Cursors, Triggers, User Defined Functions, Relational Database Models, and Data Integrity in observing business rules.
• Designed the product after analyzing the requirements.
• Created Filtered reports using report parameters, stored procedures & cascading parameters.
• Developed test plans and participated in code testing to ensure workability, completeness and quality
• Created database objects in Management Studio and Imported Access data into SQL databases
• Wrote Queries and Stored Procedures in SQL 2000, involved in code review, did unit testing and system testing and participated in CMMI related activities.
• Involved in resolving dead lock issues and performance issue. Restore Development and staging database from production backups as per the requirement.
• Created User Defined Functions, Triggers to store data into appropriate tables. Conducted performance tuning by using SQL Profiler and index tuning wizard
• Created and scheduled jobs to setup log shipping between production servers. Implemented Database Mirroring on the SQL server 2008/2012 production databases.
• Job Monitoring and making sure all jobs run successfully every night. Created functions to provide custom functionality as per the requirements.
• Designed and implemented database in SQL(2005,2008,2012)/Oracle9g/11g and wrote complex queries, stored procedures, Triggers etc. worked extensively on SQL Server Reporting Service to generate reports.
• Created linked servers between servers Used Index tuning wizard and rebuilding index for faster Query performance.

Environment: SQL Server 2008, SQL BI Suite 2008 (SQL Server Integration Services, SQL Server Reporting Services), Windows Server, C, C++, VC++, C#, XML, Rational Rose, Clearcase, Purify,XML, .NET Framework 1.1, 2.0, NUnit, CPPUnit, SQL 2000.