SUMMARY:

• 9 years of DBA experience on Data Design, Development and Administration on SQL Server 2016, 2014, 2012, SQL Server 2008 R2, 2008 and 2005 system in OLTP/OLAP environment.
• Over 8+ Years of IT experience which includes System Analysis and Design, Development, Support & MS SQL Servers 2000/2005, 2008/R2, 2012,2014,2016.
• Experience with very large SQL Server databases - 2 TB or more.
• Implemented Side-by-Side Migration of MS SQL Server 2000/2005 to 2008 and from 2008 to 2016.
• Worked extensively on Active-Active and Active-Passive Clustering.
• Experience in using the DMVS, DMFS, Information Schema, and System Views and in built Global variables for the instant analysis.
• Performed BCP, Bulk Insert, Imported and Exported data from different Data Sources.
• Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.
• Used Filtered Indexes for improving query performance, lower storage and maintenance cost.
• Extensively Worked on Transactional Replication, Snapshot Replication, Merge Replication, Log shipping for SQL Server High Availability.
• Dexterous developer in creating Constraints, Defaults, Rules, Tables, Indexes, Views, Stored Procedures, Functions, Triggers, Cursors and Dynamic sql queries.
• Extensively used the native tools like index tuning wizard, data base tuning advisor, profiler, activity monitor, Event viewer for performance analysis.
• Expert in analyzing the execution plan and index management.
• Expertise in analyzing and estimating the Execution Plan for better Query Optimization.
• Experience in Backing up, restoring the data base manually and by scheduling the jobs and Maintenance Plans.
• Implemented concepts like Data partitioning, Snap shot Isolation, Database Mirroring, Database Snapshot, DDL triggers, try-cache blocks, Online indexing, DMV’s, DMF’s, SQLCMD and dedicated admin connection.
• Experience in analyzing and resolving Locks, Dead Locks and Handling the Isolation Level and Concurrency Effects.
• Configured SMTP Server for Database Mail setup and received Alerts for the Threshold values.
• Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels.
• Experienced in OMS services like Azure Automation, Azure Backup and Azure Site Recovery.
• Configuring and implementing SCOM monitoring for Windows Azure applications/cloud services.
• Performed Database Migration from an On-Premises SQL environment to Azure Database in the cloud.
• Installed and configured MS SQL Server VM in Azure Database and worked on cloud services, storage accounts, service buses, event hubs, app service plans and Azure active directory and SQL Azure.
• Experience in Extraction Transformations and Loading (ETL) tools like SQL Server Integration Services (SSIS), Data Transformation Services (DTS), Bulk Insert, and Bulk Copy (BCP).
• Developed Custom Reports and different types of Tabular Reports, Matrix Reports, Ad-hoc Reports and distributed Reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Strong experience in mentoring with team members, documentation and 24/7 on call production support.
• Extensively used the XML, Flat File, Bulk Insert and File System control flow tasks and data flow tasks SSIS.

TECHNICAL SKILLS:

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

Databases Tools: SQL Server Management Studio, SQL Server Business Intelligence Development Studio (BIDS), Azure Portal, Operations Management Suite(OMS), System Center Operations Manager(SCOM), Database Engine Tuning Advisor, Enterprise Manager, Query Analyzer, SQL Profiler, Data Transformation Services, Upgrade Wizard, Replication, DTS xChange, Quest Spotlight, RML Utility, MS Visio, SSRS, SSIS, SSAS

Programming Languages: SQL, T-SQL, XML, PL/SQL.

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

Operating Systems: Windows 4.0, Linux, Novell Netware, MS-DOS.

PROFESSIONAL EXPERIENCE:

Senior SQL SERVER DBA (SQL Server, Azure)

Confidential, New York, NY

Responsibilities:

• Migration of SQL Server 2008 to 2014/2016, SQL Server 2005 to 2008 in clustered and non-clustered environment.
• Administering and Maintaining SQL Server 2016, 2014, 2008, 2005on Development, QA and Production environments.
• Experience working with 24 x 7 on call environments.
• Installed, Configured and Maintained Active/Passive and Active/Active clusters to provide High Availability for SQL Server 2016\2014\2008.
• Migrated databases to cloud environment on Microsoft Azure
• Installed and Configured Transactional and Snapshot replication to replicate data to OLTP and Data Warehousing.
• Hands on experience in applying security patches, hot fixes and service packs on Database Servers which are 8 Node, 4 Node and 2 Node Clustered.
• Creating, Maintaining Database Maintenance Plans and experience performing load and stress testing for large databases.
• Configured Database Mirroring to maintain High Availability at database level.
• Involved in Creating tables, indexes and designing constraints.
• Experience scripting Disaster Recovery Plan, testing, analyzing and continuously updating it with documentation.
• Migrated on premises SQL databases to Azure SQL Cloud.
• Worked on scheduling data loading and transformations using SQL Server Integration Services (SSIS) between different maintenance systems.
• Worked closely with DBA's deploying packages for staging/production server with shell scripts.
• Created packages in SSIS with error handling as well as created complex SSIS packages using various data transformations like conditional split, lookups, aggregations, expressions, fuzzy look up, for each loop, multi cast, column conversion, fuzzy grouping, script components
• Used OMS Assessment solutions like SQL Health check, Active Directory, Change Tracking, Service Map, Security and Audit for Ad-hoc tasks.
• Used OMS Dashboards for Azure services, along with application-specific metrics.
• Implementing Azure Backup and Site recovery services.
• Creating azure resources like cloud services, Application Insights, storage accounts, service buses, event hubs, app service plans.
• Creating logins, groups, and users, roles, checking for database consistency, monitoring error logs, database space allocations and transaction log space allocations.
• Expert in implementing business logic and procedure in the backend using complex stored procedures and functions.
• Installed SQL Server hot fixes and patches

Environment: Microsoft Windows Server 2012/2008/2003 32/64 bit, Microsoft SQL Server, Azure Portal, Operations Management Suite(OMS), System Center Operations Manager(SCOM), 2014/2012/2008/2005 and Visual Studio 2008/2005, Reporting Services, Integration Services

Confidential, Chicago, IL

SQL Server DBA /SSRS Report developer

Responsibilities:

• Installed SQL SERVER 2008/2008r2/2012 FAILOVER Cluster and standalone 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 2008 r2 64 bit.
• Practiced the DR (disaster recovery exercise) at SunGard for SQL Server 2008/200r82/2012.
• Setup the Transactional Replication for the reporting purpose
• Set up the active-active clusters.
• Implemented Transactional Log shipping and mirroring for database high availability.
• Regularly installed service packs and hot fixes for both clustered and standalone environment.
• 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, PREFMONCE 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 package in Sql Server 2012 to build the content data for the application.
• Created and maintained SSIS packages to pull data from CDC tables and dumping into audit database server.
• Scheduled agent jobs for database backup and windows task to clean up the file system using VB Script
• 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.
• Assisted in production of OLAP cubes, wrote queries to produce reports using SQL Server 2008/2012 Analysis Services (SSAS) and Reporting service (SSRS).
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security in SQL Server and SSRS.
• Used SQL Server Reporting Service (SSRS) to publish data to the end user via HTML, PDF, Excel, and CSV formats.
• Generated reports like Drill-Through, Linked and Sub-Reports that could be used to send Business information to higher Management using 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)
• Administered the SQL Server 2008 r2 for the Microsoft Dynamics GP 2010(Great Plains Software)
• Identify, troubleshoot and fix "long running jobs" using monitoring tool Solarwinds (DPA) tool
• Used the TFS and Rational Clear case for change management in the SDLC cycle
• Provided 24X7 support and team player during production outage.

Environment: TSQL, MS SQL SERVER 2000/2005/2008/2012, SSRS,SSAS QUERY ANALYSER, VISUAL STUDIO 2005, VB.NET, C#, WINOWS SERVER 2008, IIS, Orion, solarwinds

Confidential, Atlanta, GA

SQL Server DBA/SSRS Reporting

Responsibilities:

• Extensively worked on Administration, Database Design, and Performance Analysis on very large and highly transactional production databases.
• Installed and Configure SQL Server 2008 on Cluster Environment.
• Trouble Shooting and Solving the Production issues.
• Implemented, monitored and troubleshot Transactional replication.
• Used Performance Monitor/SQL Profiler to analyze Long/Slow running queries and tune the same to optimize Application and system performance.
• Involved in Database Migration from SQL Server 2000/2005 to SQL Server 2008/R2.
• Implemented new features in SQL 2008 like Policy based Management, Table Compression & backup compression, SQL Server Auditing, Resource Governor, Power shell and MERGE statement in T-SQL.
• Created Linked Servers between SQL Server 2000/2005 and Oracle Servers in the environment.
• Supporting Development/Testing/Data warehousing/Sys Admin Teams.
• Supported Very Large Databases VLDB.
• Review T-SQL code to verify and meets standards for both performance and error handling according to DBA standards.
• Experience in building ad-hoc reports, parameterized reports, toggle reports, reports with sub reports using SSRS.
• Developed complex Stored Procedures to generate various Drill-through reports, Parameterized reports, Tabular reports, Matrix reports and linked reports using SSRS.
• Used BMC Patrol and Remedy to reduces complexity and makes customer support, change management, asset management integrated and efficient.
• Reviewing Multi-Server System Info and utilizing the hardware at its best.
• Used Data Pump for Moving Data between different Databases.
• Developed ETL packages using multiple data sources (SQL Server, Flat Files, Excel source files, XML files etc) and then loaded the data into destination tables by performing different kinds of transformations using SSIS transformations.
• Optimized the existing SSIS packages to fix various issues and improve performance.
• Built SSIS Packages for processing fact and dimension tables with complex transforms.
• Designed new SSIS packages to extract data from newer OLAP and OLTP sources and transferred the data to SQL Server using BIDS
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities
• Supporting 24/7 Production Environment.

ENVIRONMENT: MS SQL Server 2005/2008R2, Windows 2000/2003/2008 Server, T-SQL, SQLProfiler, Performance Monitor, SSIS, SSRS, Oracle Grid, Red Gate, MOM, Tivoli, VMware, Clustered Environment, SharePoint, Remedy.

Confidential

SQL Database Administrator (Principal Infra Eng.)

Environment: Database: SQL Server 2005, 2008 UAT, Prod Servers and Dev Servers, SAN backup environment, VERITAS Clusters, Database sizes app. 300-900 GB, OS - Windows Server 2003-2008-2012

Roles:

• Supported around 600+ Servers.
• Work in multiple project (Nice, UCCE).
• Provide 24 x 7 support for any Emergency Calls. (On call)
• Worked on Ticketing tool (Remedy) for Incidents, Tasks and user requests.
• Help the development team in query development and fine tuning them in case they find difficulty in fixing it
• Worked on Symantec VERITAS Clusters.
• SQL Server installation, configuration, upgrading, troubleshooting, backup and recovery.
• Incident handling, Change request implementation.
• Addressed issues related to high Memory utilization, blocking, long running queries.
• Refreshing TEST/DEV environment from production when needed by the client.
• Perform DBA duties like backups, maintenance, user access and security, ensure that all the maintenance tasks and backup jobs are successfully executed as per schedule and if any job fails identify the reasons and fix them.
• Install security patches and hot fixes on all the servers as applicable.
• Use HP Service manager tool for patching.
• Working experience in ITIL Process.

Confidential

Database Administrator

• SQL Server Database Administrator, Install SQL Server instances and service packs, Monitor performance problems, Install scripts from development, Create baselines of performance metrics, Configure the SQL Server optimally, Configure/implement high availability plans, Create\implement disaster recovery and scalability plans, Ensure that backups have been run, Performance-tune queries and stored procedures, Create data migration plans and scripts, Create\consult around ETL using Integration Services.