SUMMARY

• Around 6+ years of experience in Administering and Maintaining the MS SQL SERVER in Production, Development and Testing in Clustered and Stand Alone Server Environment.
• Experience in installing MS SQL SERVER 2008R 2/2012/2014/2016 updating with the hot fix and service packs.
• Experience in Migrating SQL SERVER 2005/2008/2012 to 2008/2008R 2/2012/2014/2016.
• Experience deploying SQL Databases in CLOUD Azure & Amazon .
• Fine - tuned queries, databases and Servers as a part of Performance Tuning.
• Active participation in Software Development Life Cycle (SDLC) specifically waterfall and Agile Scrum methodology.
• Experience in working with Active Directory.
• Experience in setting up HA solutions and DR solutions.
• Hands on experience in configuring SQL Server Mirroring and Log Shipping.
• Experience in setting up 2008R2 Active-Active, Active- Passive Clusters.
• Extensive experience in configuring Availability groups and Always-On.
• Very good experience configuring SQL Server Transactional and Snapshot Replication.
• Created Database Snapshots for Mirroring Secondary Databases.
• Extracted, transformed and loaded data from various data sources and destinations like Access, Excel, CSV, Oracle, flat files using connectors, tasks and transformations provided by SSIS.
• Extensive experience delivering OLAP solutions by developing Corporate Dashboard Reports using SQL Server Reporting Services (SSRS), Report Model and Ad Hoc Reporting using Report Builder functionality.
• Extensively used the native tools like Index Tuning Wizard, Database Tuning Advisor, Profiler, Performance Monitor, Activity Monitor, Event Viewer, extended events for performance analysis.
• Good experience in using Idera SQL Diagnostic Manager, SQL Lite, Red Gate and Lite Speed.
• Created Linked Servers between SQL SERVER’s and Oracle Databases.
• Worked on activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SQL Server SSIS.
• Strong experience in SQL Development, ETL development using Microsoft SQL Server Integration Services (SSIS), Business Intelligence delivery using Microsoft SQL Server Analysis Services (SSAS) and Reporting solutions using Microsoft SQL Server Reporting Services (SSRS).
• Hands-on in development of Drill Down Reports in SSRS and generated daily, weekly and monthly reports for the manager.
• Deployed and Debugged SSIS packages for import, export and bulk insert data with transformations from various data sources.
• Experienced in writing parameterized Queries for generating reports, formatting report, layout, sub reports using global variables, expressions and functions in SSRS.
• Extensive knowledge and Experience in dealing with Relational Database Management Systems, including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers and Cursors.
• Worked on administration tasks such as data loading, batch jobs, data unloading, backup & recovery, user and application table management, upgrades, creating databases/ file- groups/files/transaction logs.
• Hands on experience using Disk Management (adding, formatting and labelling the disks).
• Responsible for 24X7 production support on a callout rotation basis for all SQL databases.
• Excellent verbal and written communication skills combined with interpersonal and conflict resolution skills and possess strong analytical skills.
• Self-motivated and possess ability for critical thinking, analysis, good interpersonal and communication skills. Team-oriented, technically motivated and creative. User oriented with a desire to learn client's business requirements.
• Strong inclination for finishing job before project deadline. Flexible and versatile to adapt to any new environment and work on any project.
• Skilled at assessing client needs, working in a group, suggesting ideas that enhance efficiency and maximize performance and can work in demanding project schedules.

TECHNICAL SKILLS

Languages: T-SQL, My SQL, C#, ASP. NET, HTML, XML, C/C++, Java Script

Platforms: Windows Server 2003 / Server 2008 / Server 2008R2/ Server 2012, Server 2012R2, Server 2016, Server 2019, Unix, Linux, DOS.

Databases: MS-SQL Server 2000/2005/2008/2008 R2/2012/2014, MS Access

DB Utilities: SQL Server Management Utility, Query Analyzer, Profiler

ETL Tools: Data Transformation Services, SSIS

Reporting Tools: SSRS, Crystal Reports, Cognos, Tableau and Business Objects

Application Software: Visual Studio 2008/2012, Visual Source Safe, TFS, MS Office Suite

Third party Tools: Idera SQL Diagnostic Manager, Red gate, SQL Lite, LiteSpeed

PROFESSIONAL EXPERIENCE

SQL Server DBA

Confidential - Glendale, CA

Responsibilities:

• Managed and Administered 2014/2012/2008 R2 production and non-production servers.
• Migrated the SQL Server 2008R2 to SQL Server 2014 and prepare documentation.
• Real time troubleshooting production issues during on call schedule with minimum timelines in resolving issues.
• Configured Always ON availability groups on SQL Server 2014.
• Configured high availability Clustering, Database Mirroring and Transactional Replication on SQL Server 2014.
• Worked on setting up Active-Active and Active-Passive Clusters.
• Good Knowledge in implementing SQL database in SQL Azure cloud computing platform.
• Working on tickets/incidents within the SLA’s, as a part of operations support DBA.
• Perform database refresh from higher to lower environments.
• Worked with application developers to design databases and tables to support development activities and achieve optimal efficiency.
• Migrated data To and From SQL server using Bulk Copy Command (bcp).
• Also, used SQL Server Imports and Exports for transferring the data.
• Creating and modifying Tables, Stored Procedures, Views, Indexes, User Defined Functions and Triggers as required.
• Analyze SQL servers and Databases and came up with a plan for consolidation based on usage, performance and compatibility.
• Schedule jobs, created maintenance plans and check servers for optimizations and implement them.
• Performed daily tasks including backup and restore by using SQL Server tools like SSMS, SQL Server Agent, SQL Server Profiler and Database Engine Tuning Advisor.
• Developed and Automated backup jobs and DBCC scripts for databases and transaction logs.
• Monitored all databases status including CPU, Memory, I/O, Space Management, Backup and Recovery.
• Administering SQL Server security by enforcing security policy and promoting best practices.
• Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server and Flat files.
• Configured and Deployed SSIS packages from Test to Production environments.
• Involved in ETL architecture enhancements to increase the performance using query optimizer.
• Created SSIS packages for Data Conversion using data conversion transformation.

Environment: SQL Server 2016/ 2014/2012/2008 R2/2008 Enterprise Edition, T-SQL, OLTP, OLAP, SQL Server Business Intelligence Development Studio (SSAS, SSIS, SSRS), Idera SQL Diagnostic Manager, Service Now, Windows 7 professional, MS Excel 2012.

SQL Server DBA

Confidential - NYC, NY

Responsibilities:

• Installation of MSSQL Server 2014, 2012, 2008R2 on Production, UAT and Development environments.
• Maintained the database consistency with DBCC at regular intervals, Managed Disk space and memory and User connections and Monitored SQL server performance using profiler to find performance and deadlocks.
• Provided expertise in Data warehouse and Data Marts methodologies as well as extensive knowledge of OLTP/OLAP technologies.
• Strong knowledge in working on Very Large databases (OLTP) and involved in troubleshooting the problems and dealing with complex databases.
• Implemented & managed database clustering, failover as per client requirement Active/Passive & executed of any upgrade such as Service Pack, Hot fixes in Active/Passive clustering.
• Mirroring experience with both synchronous and Asynchronous and applying service packs.
• Handful of experience in configuring Log shipping and troubleshooting the related issues.
• Extensively used Repositories like Team Foundation Server (TFS) and Visual Source Safe.
• Performed Database Integrity Checks, Database Maintenance plans, updated Database Statistics and performed Re-indexing, Rebuilding the indexes, online indexing at regular intervals for better performance.
• Assigned for Database Optimization that involved re-engineering the databases, data and index organizing, performance tuning and query tuning.
• As a part of the team, configured Transactional Replication with multiple publishers and centralized subscriber for real time reporting.
• Also implemented Mirroring for DR Plan.
• Created numerous reports using reporting services SSRS and deploying them on SharePoint.
• Created/altered/modified and tuned T-SQL Stored Procedures, Complex Queries, views, tables, and functions on OLTP and OLAP environments.
• Monitoring Event Viewer, SQL Error logs and Log File Viewer for Software and hardware related errors.
• Handful of experience in PowerShell Scripting.
• Creating Logins and Roles with appropriate permissions. Implementation of SQL server logins, Roles and Authentication modes as a part of security policies.
• Resolving blocking and deadlocks using DMVs, Profiler and killing respective SPIDs and also optimizing the queries, which are involved in blocking and deadlock issues.
• Good knowledge and handful of experience on implementing Always On High availability starting from SQL 2012.
• Scheduled SQL Server Agent Jobs for updating statistics, checking fragmentation, checking database integrity and backup plans.
• Created and managed schema objects such as tables, views, constraints, indexes, functions, procedures, and triggers and maintained Referential Integrity.
• Optimize the performance of queries with modifications in T-SQL queries, remove unnecessary columns, eliminate redundant and inconsistent data, and normalize tables.
• Applied patches, hot fixes, cleared .NET framework corruption errors.
• Extensively worked on Active-Active and Active-Passive Clustering.
• As a part of the team, was always involved in production deployment or production release.
• Technical Analysis, Code Review, Implementation, 24 x 7 production support.

Environment: MS SQL Server 2005, 2008R2, 2012, 2014, 2016 TSQL, OLTP, OLAP, Windows 2008, Spotlight, Lite Speed, Fog light, SSIS, SSRS, SSAS, Visio 2007.

SQL Server DBA

Confidential - Omaha, NE

Responsibilities:

• Implemented SIDE BY SIDE Migration of MS SQL SERVER 2005 to 2008R2 on Windows.
• Migrated DTS 2000 PACAKGES to SSIS packages and maintained the archival data using Control flow task.
• Created Reporting documentation by analyzing Report data and used as reference to develop reports from Data Mart.
• Experience with Cluster Configuration in SAN environment.
• Implemented native log shipping on MS SQL SERVER 2008R2.
• Applied Patches and Service packs to update different versions of MS SQL SERVER.
• Scheduled regular BACKUP JOBS and kept track of database by receiving the emails on Alerts.
• Implemented the new concepts like Data partitioning, Snap shot Isolation, Database Snapshot, DDL triggers, Try-Cache blocks, Online Indexing, DMV’s, DMF’s, DTA, SQLCMD and dedicated admin connection, Common table Expression(CTE).
• Implemented DATABASE MIRRORING ON MS SQL SERVER 2008R2.
• Moved files between the File Groups and partitioned the tables to improve the performance.
• Extensively used LiteSpeed backup with MS SQL SERVER 2008R2.
• Documented and performed the data base health checks regularly.
• Used native tools like DATA BASE TUNING ADVISOR, PROFILER and ACTIVITY MONITOR for performance analysis.
• Implemented log shipping for production server data base as part of the disaster recovery.
• Created baseline and sampling intervals in the perfmon considering threshold values of the counters.
• Rendered DRILL DOWN, STATIC reports in MATRIX form in SSRS.
• Used SSIS packages to move data from dev to QA and QA to Production.
• Deployed maintenance plans for regular DBA activities in SSIS.
• Scheduled night jobs for importing large amount of data using SSIS Packages.
• Deployed SSIS package for bulk insert and maintained archival data with file system task.
• Handled monthly Database Refresh in QA-Test environment for testing of new Deployments and Build.

Environment: TSQL, MS SQL Server 2000/2005/2008/2008 R2, SSRS, QUERY ANALYSER, VISUAL STUDIO 2005, VB.NET, C#, WINOWS Server 2008, IIS.

SQL Server DBA

Confidential - Branchville, NJ

Responsibilities:

• Installed SQL Server 2008/2008R2/2012 Failover Cluster and Stand Alone installation on Windows Server 2008 r2 64-bit system in PROD/TEST/DEV from scratch.
• Installed and administrated SSRS 2008/2008r2/2012 on Windows Server 2008R2 64 bit.
• Practiced the DR (disaster recovery exercise) at SunGard for SQL Server 2008/2008R2/2012.
• Setup the Transactional Replication for the reporting purpose.
• Implemented Transactional Log shipping and mirroring for database high availability.
• Regularly installed service packs and hot fixes for both clustered and standalone environments.
• Configured the alerts and jobs for the regular monitoring of the database Server.
• Extensively used the Orion monitoring tool at OS level.
• Used native tools Database Tuning Advisor, Profiler, Performance and Activity Monitor.
• Regularly deployed the reports and configured the subscriptions for automated email delivery of the reports.
• Configured the DB SMTP mail for the notification purposes.
• Developed SSIS packages in SQL Server 2012 to build the content data for the application.
• Scheduled Agent jobs for database backup and windows task to clean up the file system using VB Script.
• Configured Linked Servers between different servers.
• Used the DMV and DMF for the performance data collection and monitoring.
• Implemented T-SQL features like Data partitioning, Error handling, Common Table Expression (CTE) and Snapshot Isolation.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security in SQL Server and SSRS.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization.
• Used the cots products like Titanium with ESIR (enterprise System Image Retrieval).
• Used BULK INSERT to import the data from flat files.
• Developed stored procedures, functions, triggers in T-SQL and batch scripts.
• Used the TFS and Rational Clear case for change management in the SDLC cycle.
• Provided 24X7 support and team player during production outage.

Environment: MS SQL Server 2005, 2008R2, 2012, 2014, 2016 TSQL, VB Script, OLTP, OLAP, Windows 2008, Spotlight, LiteSpeed, fog light, SSIS, SSRS, SSAS, Visio 2007.