SUMMARY

• 7 years of experience in SQL Server with strong expertise in SQL Server development, designing Stored Procedures/Transact - SQL coding, SSIS/SSRS/SSAS, OLTP, and OLAP.
• Involved in Migrating from SQL Server 2000 to SQL Server 2005 and SQL Server and SQL Server 2008 to SQL Server 2012
• Worked with the new 2016 features such as Dynamic Data Masking, JSON Support, Multiple TempDB Database files, PolyBase, Query Store, Stretch Database, Temporal Table etc.
• Experience in deploying of a windows application, web services, and window services in Microsoft Visual Studio.Net IDE using C#.Net 1.1, C#.Net 2.0 VB.Net ASP.Net, ADO.Net andSQLServer.
• Extensively worked in Data Migration between Homogeneous & Heterogeneous Systems using various tools (SQL Server Upgrade Advisor, DTS Package Migration Wizard, Import Export Data, DTS Packages, Bulk Insert, BCP, and SSIS).
• Configured\Monitored\Supported and Troubleshooting of Database Mirroring and Log Shipping for multiple databases on Geographically separated cluster environments to provide High Availability and Disaster Recovery. Support and troubleshooting for Transactional replication and Merge.
• Configured SMTP Server for Database Mail setup and received Alerts for the Threshold values.
• Good Experience with Performance tuning, DMV'S, DMF'S, analyzing Locks, Dead Locks and Handling the Isolation Level and Concurrency Effects
• Experience in high availability SQL Server solutions with SQL Server 2012 Always ON availability groups, Replication, Database Snapshot, Log shipping, and Database Mirroring.
• Experience in automating the system by using Notification service and creating alerts, jobs and maintenance plans.
• Hands on Experience in Installing, Configuring, Managing, Monitoring, Migrating and Troubleshooting SQL Server versions.
• Proficient with SQL Server tools, including Enterprise Manager, Management Studio, Query Analyzer, SQL Server Profiler, SQL Server Agent, DTA and Business Intelligent Studio.
• Hands on experience on high availability SQL Server solutions, including SQL Server Log shipping, SQL Server clustering and mirroring using Different modes.
• Planning and assistance for creating Maintenance plans, Auditing plans and Backup/recovery plans.
• Hands-on working experience with Analyzing query plans, using extended Stored Procedures, managing indexes, and locks, troubleshooting deadlocks.
• Experience in implementing High availability SQL Server solutions, including Replication Models (Snapshot/ Transactional) and Implementing SQL Server clustering (Active-Active, Active-Passive), (Multi-Node Cluster).
• Experience in maintenance jobs to perform Full, Differential and Transaction Log backups using Simple, Bulk-logged and Full Recovery Model experienced with Database Backup, Recovery solutions.
• Expert in analysis and resolution of performance bottlenecks involving CPU, I/O and memory usage.
• Expert level skills in creating objects like Tables, Views, Normalization, Indexes, Stored Procedures, Cursors, Triggers and other SQL joins and query writing using T- SQL statements.
• Expertise in Identifying the bottlenecks caused by complex queries using Activity Monitor/SQL Profiler and handling them by implementing better Query Execution plans.
• Skilled at meeting deadlines, easily adaptive to various project environments, flexible to work with different teams across geographical locations.
• Extensively used the XML, FLAT FILE, BULK INSERT AND FILE SYSTEM control flow tasks and data flow tasks SSIS.

TECHNICAL SKILLS

Programming Languages: T-SQL. PL/SQL, C#, ASP.Net

RDBMS: MSSQL Server, MYSQL

Web Tools: Internet Information Server (IIS), FTP, TCP/IP, SMTP, LAN, MS-Outlook Express

Database Tools: SSMS, BIDS, DTA,SQLProfiler, DTS, DTSRUN, MS Visio, Import & Export (DTS), DTSX Change, SSRS, SSAS, SSIS, Erwin, Lite Speed, Crystal Reports 10.0, Share Point,SQLCMD

PROFESSIONAL EXPERIENCE

Senior SQL Server Developer/DBA

Confidential - Mount Laurel, NJ

Responsibilities:

• Working on SQL SERVER 2016/ 2014/2012/2008 R2. Managing and Administrating highly transitive Production and Active/Passive Environment.
• Implementing new SQL Server 2016/2014 concepts like database mirroring, database snapshot, DMV's, DMF's, Jobs, and Alerts.
• Providing SQL Logins, Roles and Authentication Modes as a part of Security Policies as per requirement.
• Scheduling Daily Routine Developer/DBA jobs like Backing up the system, Backups, and Restores.
• Hands-on experience in troubleshooting database issues.
• Creating Data model as per Developer/user requirement and maintain Metadata services.
• Disaster Recovery Planning, Testing, and Analyzing are implemented for continuous update of documentation.
• Update statistics for index optimization, Database integrity check, and Backup operations.
• Checking Database Health by using DBCC Commands and DMVS/DMFS.
• Managing schema objects and creating Tables, Views, Indexes and referential integrity depending on user requirements and converting them into technical specifications.
• Database space issues are resolved by sizing Tablespaces, data files, and log files.
• Monitoring SQL server performance using a Profiler to find performance, Deadlocks, Blockings and Capture long-running SQL queries for fine-tuning SQL statements that better result in efficient SQL statements processing.
• Created logical and physical database design, data structures, and implemented databases using Erwin.
• Analyzed business recovery requirements and maintained strategies and plans for critical databases.
• Developed, designed and documented tables, view, stored procedures, advanced queries, triggers, indexes, and functions.
• Experience in designing Database activities including Data Files and Filegroup organization,
• Capacity Planning, Data Partitioning and Data Normalization.
• Create joins involving multiple tables and sub-queries for complex queries.
• Use DDL and DML for writing triggers, stored procedures, and data manipulation.
• Worked extensively in T-SQL for various needs of the transformations while loading the data, CTE's and functions.
• Created Store Procedures to validate the data and transform the Data using Views, Functions.
• Performed performance Tuning by analyzing indexes, queries, and table size etc. Database
• Analyzing Engine tuning advisor and query Execution plan tools.
• Extensive work experience in system analysis, design, development, testing and implementation of projects with full SDLC (Software Development Life Cycle).
• Experience in providing 24X7 on-call support on a weekly rotation.

Environment: MS SQL Server 2014/2012/2008 R2/2005, SSRS, SSIS, SSAS, VB 6, Erwin, SQL Server Profiler, SQL Loader, Database engine tuning Advisor, BPA, Upgrade Advisor.

SQL Server DBA

Confidential, Pennsylvania, PA

Responsibilities:

• Installation and Maintenance of SQL Server 2014/2012/2008 R2 on Test, Development and Production Environments, Active Directory Administration and MongoDB.
• Worked with SQL Server 2012 in place and side by side upgrade from SQL server 2005.
• Strong experience in maintaining Very Large Databases (VLDB) over 2 TB for OLTP.
• Database Mirroring and Transactional Replication implemented as a part of DR plan.
• Worked with upgrading, cloning and migrating SQL databases in SQL Server 2012/2008R 2/2008/2005.
• Implemented the new SQL Server 2012 concepts like HADR Always ON, Availability Groups.
• Export or Import data from other data sources like flat files using Import/Export through DTS, SSIS.
• Expertise in SQL Server Reporting Services (SSRS) to design and develop different reports of performance metrics.
• Experience in troubleshooting database issues. Update statistics, database integrity check and Backup operations.
• Performed Database Integrity Checks, updated Database Statistics, and performed Re-indexing.
• Created and managed schema objects such as tables, views, clusters, indexes, procedures, and triggers and maintained Referential Integrity.
• Generated Script files of the databases whenever changes are made to stored procedures or views and worked on Performance Tuning of the Stored Procedures.
• Implementation of SQL Logins, Roles and Authentication Modes as a part Security Policies.
• Analyzing capacity planning for different users and successfully implementing the Capacity planning.
• Creating Logins and Roles with appropriate permissions.
• Creating and Maintaining Database Maintenance Plans. Optimized working process.
• Modify Stored Procedures and complex T-SQL Queries to improve query execution process.
• Experience in using ERWIN tool for Entity Relationship diagrams.
• Write T-SQL Scripts for database backup jobs and daily/weekly jobs.
• Performed data partitioning for efficient management of database tables and indexes.
• Maintaining the database consistency with DBCC at regular intervals.
• Monitoring SQL server performance using Profiler to find performance and deadlocks.
• Managed Disk space, memory and User connections.
• Rebuilding the indexes at regular intervals for better performance.
• Monitored and modified Performance using execution plans and Index tuning.
• Working on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.
• Performance testing on stored procedures, indexes, and triggers.
• Creating Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Experience in applying Service Packs at database and OS Level.
• Technical Analysis, Code Review, Implementation, 24 x 7 production support.

Environment: SQL Server 2014/2012/2008 R2/08/05, Windows 2003, 2008, 2008 R2, 2012 Servers, ADO.NET, Red gate, MS Visio, Microsoft SQL server Visual Studio 2005/2008, MS Business Intelligence Development Studio 2008, Fog Lite.

SQL Server DBA

Confidential, Virginia

Responsibilities:

• Worked on SQL SERVER 2014/2012/2008 R2/08/05, Upgraded most of SQL Server 2012 to SQL Server 2014
• Involved with upgrade of databases from in a Clustered environment.
• Hands-on experience on SQL Server 2014 with latest Service Packs.
• Make me Involved in Performance Tuning on Production, QA and Staging servers of the current project.
• Monitoring Performance of different production servers.
• Implemented Database mirroring for disaster recovery. • Maintained various databases for Production and Testing using SQL Server 2012.
• Analyzing and Planning the location of data, index, and Transaction log files on the disk.
• Implemented Performance tuning, and optimization of procedures and queries.
• Worked with SQL Server Profiler.
• Created the backup and restore strategy for production and development environment.
• Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Populate data from various data sources, creating packages for different data loading operations for the application using SQL Server Integration Services (SSIS).
• Experience in creating and executing SQL Server Integration Services (SSIS) packages.
• Managing schema objects such as tables, views, clusters, indexes, procedures, triggers & maintaining Referential Integrity depending on user requirements and converting them into technical specifications.
• Administering the MS SQL Server by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.
• Database and Transaction log backups & restoration, backup strategies, scheduling the backups. Backing up system & user databases and restoring them.
• Performing fine Tuning of Database Application. Cleansing and solving Database critical issues.
• Used BCP and Bulk Insert utilities and Worked with SQL Server Reporting Services (SSRS).

Environment: MS SQL Server 2014/2012/2008 R2/2008, Windows Server 2003/2000, VMware, RedGate, SSIS, SSRS, Clustering, Mirroring, Log Shipping, Replication

Senior SQL DBA

Confidential - Duluth, GA

Responsibilities:

• Verifying and maintaining database backups, integrity checks, and scheduled jobs.
• Applied Normalization rules in designing the database.
• Involved in performance tuning and query optimization.
• Support team in resolving in DTS and T-SQL related issues.
• Created Database tables with constraints and relationships between multiple tables.
• Rebuilding the indexes at regular intervals better performance.
• Transformation of data (Millions of records) to SQL server by SSIS, DTS, BCP.
• Extensively worked on Dynamic Management Views (DMV's) and Dynamic Management Functions (DMF's).
• Created and managed schema objects such as tables, views, clusters, indexes, procedures, and triggers and maintained Referential Integrity.
• Complete documentation about the database. To analyze long running slow queries and tune the same to optimize application and system performance.
• Rebuilding the indexes at regular intervals for better performance.
• Created stored procedures for maintaining SQL Server, Written Stored Procedures for Application Developers.
• Played a key role in business requirements analysis, architecture designs, physical and logical Data modeling, application development by using Erwin.
• Migrating databases and database objects between multiple servers across production and development platforms.
• Experience in the field of Unit Testing, have tested codes of T-SQL and SSIS packages in the testing environment.
• Configured DB mail for sending automatic mails to respective people when SSIS process fails.
• Created stored procedures for backup and restore of system and user databases from Disaster Recovery;
• Managing day-to-day SQL Server operations in SQL Servers 2005/2008/2008 R2.
• Designing and implementing Disaster Recovery Procedures like Log Shipping, Replication.
• Created and implemented DTS/SSIS Packages for importing and exporting data to other data storage.
• Conducting Root Cause Analysis of application availability related to coding practices, database bottlenecks, or network latency
• Deploying IDERA Diagnostic Manager for monitoring SQL Server
• Creating Linked Servers to move data from Oracle Server to other production servers.
• Documenting all the databases, database objects, jobs and the changes made to the database.
• Troubleshooting, monitoring, and tuning SQL server and databases performance using SQL Profiler, System Monitor.
• Resolving issues related to Query Optimization and Index Tuning.
• Checking the Configuration and performance of the existing databases including data file allocation, index, fill factor, fragmentation.
• Analyzing potential problems, e.g., Response Delay, Locking, server down time, for Optimization of performance.
• Resolved Locking and Blocking issues during peak period of website highest hits.

Environment: SQL Server 2008R 2/2008/2005/2000 , Windows 2008/2003/2000 Server, SQL Lite speed 4.5, MSE, ME Change Request, Visio Enterprise Manager, IDERA, SQL Query Analyzer, and SQL Profiler.

SQL Server DBA

Confidential - Branchville, NJ

Responsibilities:

• Installing, Configuring and Maintaining SQL Server 2008R2/20 bit) on Active/Active Cluster with latest Service Packs, Hot Fixes.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Resolving performance issues using DMVs (Dynamic Management Views).
• Used native tools like Database Tuning Advisor, SQL Server Profiler, Performance Monitor and Activity Monitor for performance tuning.
• Designed and developed SSIS packages using different control flow tasks, data flow task and data transformations
• Performed ETL tasks from flat files to the servers and from SQL server to the flat files, csv files
• Involved in Analysis, Development and Maintenance of Backup Plan, Disaster Recovery Plan, Procedures and Strategies using Maintenance Plans.
• Implemented and Maintained routine DBA tasks like scheduling jobs, creating maintenance plans. Checked servers for optimizations and implemented them.
• Troubleshooting blocking issues, deadlocks using blocker scripts, trace flags and activity monitor.
• Designed the Database Recovery plan and implemented the Database Mirroring in SQL Server 2008/2005 and participated in Disaster Recovery Drill processes.
• Extensively worked on Log shipping for synchronization of databases for SQL Server High Availability.
• Experience in managing Alerts, Operators, Proxies and Jobs through SQL Server Agent and Monitoring Event Viewer, SQL Error logs and Log File Viewer for Software and hardware related errors.
• Ability to detect and troubleshoot SQL Server related CPU, memory bottlenecks, I/O, disk space and other resource contention.
• Proficient Development skills (SQL, TSQL, Stored Procedures, and Triggers) for providing development support and application tuning.
• Designed and created SQL Database, tables, indexes, and views. Created User Defined Functions, Stored Procedures, and Triggers.
• Responsible for tuning complex SQL queries and Stored Procedures to increase performance.
• Worked extensively in Query analyzer and profiler for tuning queries using variable for characteristics and query costs.

Environment: SQL Server 2008R2, Subversion, Microsoft One Note, SQL Server Profiler, Visio 2007.

SQL Server Developer/DBA

Confidential

Responsibilities:

• Create databases and database objects tables, stored procedures, views, triggers, rules, defaults, user defined data types and functions in SQL Server 2008R2/ 2008.
• Implementation of SQL Logins Roles and, Authentication Modes as a part of Security Policies for various categories of users.
• Checking of logs, windows system monitor alerts.
• Creating users and assigning the respective privileges.
• Query Optimization of long running queries.
• Rebuilding the indexes at regular intervals for better performance.
• Automation of maintenance jobs.
• Optimized data retrieval and data modification queries that deal with Tables containing huge amount of data and created indexes to improve the query performance.
• Monitor the automated process for the activities such as database backup processes and SSIS Packages run sequentially using SQL Server Agent job.
• Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.
• Configured Database Mirroring Successfully.
• Providing application support to the customers by resolving both server side and database issues.
• Acting as a bridge in between customers and Engineering team for code related issues.
• Understand the process within the project and resolving the issue with the SLA.
• Coordinate all internal and external communications, notifications, and Bug tracking for outages and upgrades.
• Participate in weekly sync up calls with the service engineers and discussing on ongoing issues.