SUMMARY

• 7+ years of experience in Administering and maintaining the 32bit, 64 - bit MS SQL SERVER in Production, Development and Testing in Clustered, Stand alone, VM-WARE, Hyper-V.
• Experience in installing MS SQL SERVER 2014/2012/2008 r 2/2008/2005/2000 updating with the hot fix and service packs.
• Implemented Side by Side Migration of SQL SERVER 2000/ /2008r 2/2012/2014.
• Setup and Configured Always ON (HADR) on SQL Server 2014 Enterprise Environment.
• Experience in implementing DIASTER RECOVERY AND HIGH AVAILABLITY concepts like Native Log Shipping, Mirroring and Replication (Snap Shot and Transactional).
• Good at SQL Server 2014 new features like Contained Databases, In-Memory OLTP/OLAP and Column Store Indexes.
• Implemented the new SQL Server 2005 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 working and configuring with Windows server 2012/2008r2.
• Experience in analyzing and resolving Locks, Dead Locks and Handling the Isolation Level
• Good working knowledge of Always On, Database Engine and T- SQL Enhancements of 2014 features.
• Extensively used the native tools like index tuning wizard, data base tuning advisor, profiler, performance, activity monitor, Event viewer for performance analysis.
• Experience in administrative activates comprising Performance Tuning, Query Optimization, Client/Server Connectivity, and Database health Check, Indexing, Updating Statistics.
• Experience in Backing up, restoring the data base manually and by scheduling the jobs and Maintenance Plans.
• Configured Security at ACTIVE DIRECTORY and SQL SERVER LEVEL by Creating Principals (logins) and Mapping users to roles. (Securable and Permissions).
• Experience in using the DMVS, DMFS, SP PROCS, INFORMATION SCHEMA, and SYSTEM VIEWS AND in built GLOBAL VARIABLES for the instant analysis.
• Dexterous developer in creating Constraints, Defaults, Rules, Tables, Indexes, Views, Stored Procedures, Functions, Triggers, Cursors and Dynamic Sql queries.
• Performed BCP, BULK INSERT, Imported and Exported data from different Data Sources.
• Experience in logical and physical data modeling of the database in MSVISIO.
• Experience in Normalization, Database design, Performance Analysis and Production Support for very large (VLDB) and Complex Databases.
• Expertise in analyzing and estimating the Execution Plan for better Query Optimization.
• Configured SMTP Server for Database Mail setup and received Alerts for the Threshold values.
• Extensively used Repositories like Team Foundation Server (TFS), Visual source safe and Clear Case for Data Archival.
• Experience in using the Orion and MS System Center Operations Manager (SCOM)monitoring tool at OS level.
• Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels
• Deployed and Debugged SSIS packages for import, export and bulk insert data with transformations from various data sources.
• Experience in generating Reports (SSRS) in Business Intelligence Development Studio (BIDS).
• Explicitly used third party tools like IDERA, Lite speed, Fog light, and Spotlight and Red gate.
• Worked with a team of business analysts, data architects, application developers, developers and testers, My objective was to deliver projects within scope, time and costs while following department standards, methodologies and guidelines
• Involved in all phases of the SDLC (software development life cycle).
• Strong experience in mentoring with team members, documentation and 24/7 on call production support.
• Good at SQL Server 2008 features like SQL Audit 2008, Data Compression, Resource Governor, Performance Data Collector and Transparent Data Encryption (TDE).

TECHNICAL SKILLS

Project Domain: Application Development, Systems Integration and DatabaseAdministration of MS SQL Server 2014/2012/2008 r 2/2008/2005/2000 , Oracle.

Languages: Visual Basic 6, VB Script, JavaScript, VB.NET, C#, C, XML, HTML, XSLT, Web Services.

Database: MS SQL Server 2008/2005/2000/7.0 , Oracle 9i/10g, MYSQL, Access.

Web Server: IIS

Technologies: Microsoft SharePoint 2007, .NET FRAMEWORK, ASP.NET

Tools: Active X, IIS, SSIS, DTS, MTS, Lite speed, Spotlight, Fog light, Visual Studio 2003/2005, VSS, Visio 2003, Office Visio 2007, SQL Nexus and PSSdiag.SharePoint Designer 2007, ER Studio Data Architect 9.0.

ETL Tools: SSIS.

Business Intelligence: Crystal Reports XI/10/9, Business Objects XI/6.5.1.

Operating System: Windows 2000 Advanced Server, Windows NT, Windows Server 2003/2008/2008 R2/HYPERV-V, UNIX, Windows 9x.

PROFESSIONAL EXPERIENCE

Confidential, Boston, MA

Sr. SQL Server DBA/ Developer /Data Modeler

Responsibilities:

• Installed SQL SERVER 2008/2008r2/2012/2014 FAILOVER Cluster and standalone installation on Windows Server 2008 r2 64 bit system and VM-WARE, Hyper - V in PROD/TEST/DEV.
• Regularly installed service packs and hot fixes for both clustered and standalone environment.
• Setup and Configured Always ON (HADR) on SQL Server 2012 Enterprise Environment.
• Implemented Transactional Log shipping and mirroring for database Disaster Recovery.
• Designed, Setup and Documented the Transactional Replication on multi TB database for the reporting purpose.
• Extensive experience in developing Stored Procedures, Views, Cursors, Triggers, Scripts and Complex Queries in MS SQL Server.
• Designed models of Database Objects using the ER Studio Data Architect 9.0 version.
• Expert in using BI tools like Integration service, Reporting Services and Analysis services in MS SQL server 2008/2012/2014.
• Developed SSIS packages to load content data from Business.
• Installed and administrated SSRS 2008/2008r2/2012/2014 on Windows Server 2008 r2 64 bit.
• Developed SSRS reports to collect the performance metrics and monitoring user activity.
• Fine-tuned long running queries and resolved the performance issues in production.
• Practiced the DR (disaster recovery exercise) at SunGard for SQL Server 2008/200r82/2012.
• Resolved bottlenecks and provided Root Cause Analysis for DB related issues.
• Met SLA’s fine tuning the SSRS and long running ETL queries.
• Used SQL Nexus and PSS diagram for Analysis and problem solving I/O issues.
• Implemented Data Compression at page level based on percentage metrics.
• Supported Windows Team SAN Migration by moving the User Databases.
• Configured the alerts and jobs for the regular monitoring of the database Server.
• Monitored the servers using Orion monitoring tool at OS level.
• Used tools DATABASE TUNING ADVISOR, PROFILER, PERFMONCE and ACTIVITY MONITOR.
• Setup and Configured alerts using the IDERA SQL Diagnostic Manager and Defragmenter.
• Regularly deployed reports and configured subscriptions for email delivery of the reports.
• Designed Backup and Restore strategy for OLTP/OLAP system and Setup Backups for point in time recovery.
• Configured the DB SMTP mail for the notification purposes.
• Scheduled automated Scripts for database backup and windows task to clean up the file system using VB Script.
• Configured Linked Servers between different servers
• Experienced Data WarehouseAnalyst who is well-versed in several database platforms and tools.
• Used the DMVs and DMFs for the performance data collection and monitoring.
• Implemented T-SQL features like Data partitioning, Error handling and Snapshot Isolation.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security in SQL Server and SSRS.
• Implemented SQL Audit 2008 and Server Side trace for auditing at server and database level on SQL Server 2008.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization.
• Administered the SQL Server 2008 r2 for the Microsoft Dynamics GP 2010.
• Used BCP and BULK INSERT to import /export data.
• Developed stored procedures, functions, triggers in T-SQL batch scripts.
• Used Tortoise SVN for change management in the SDLC cycle.
• Provided 24X7 support and team player during production outage.

Environment: TSQL, MS SQL SERVER 2000/20 /2014 , SSRS, QUERY ANALYSER, VISUAL STUDIO 2005, VB.NET,C#,WINOWS SERVER 2008,IIS,Orion,Hyper-v.

Confidential, Montvale, NJ

Sr. SQL Server Developer/DBA

Responsibilities:

• Installed SQL SERVER 2008/2008r2 FAILOVER Cluster and standalone installation on Windows Server 2008 r2 64 bit system in PROD/TEST/DEV on Hyper - V.
• Implemented Transactional Replication for SSRS reports.
• Designed and Automated the SSRS report deployment using Microsoft Utilities.
• Designed tables for the application Users, Roles and Groups, Application Audit and Triggers.
• Setup Change Data Capture, Designed tables to generate data snapshots from the PAST.
• Installed, Administered SSRS and setup data driven subscriptions.
• Setup the DB Mail and Alerts on PROD database servers to send out the Notifications.
• Used Team City for code deployment Automation and JIRA for source control.
• Implemented Transactional Log shipping and mirroring for database high availability.
• Regularly installed service packs and hot fixes for both clustered and standalone environment.
• Used MS System Center Operations Manager (SCOM)SQL MANAGEMENT PACK 2012 to setup the server and database Alerts.
• Fine tune long running SQL Queries from Application and SSRS.
• Developed T-SQL Scripts to scrub PROD data for TEST Environments.
• Experienced at writing automated scripts using PowerShell and Unix
• Experience in handling Sybase Sql server to analyze information in RDBMS.
• Updated and Maintained Passwords for the SQL Server Service Accounts and Application Accounts before Expiration.
• Developed SSRS Reports to pull the application/user data for the security team.
• Regularly deployed the reports and configured the subscriptions for automated email delivery of the reports.
• Backed up and restored the SQL Server databases using LiteSpeed and T-SQL Scripts.
• Used the DMVs and DMFs for the performance data collection and monitoring.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization.
• Developed stored procedures, functions, triggers in T-SQL and batch scripts.
• Used Red Gate SQL Compare, Visual Studio 2012 for database object and schema compare.
• Used TFS version control retrieving code for Database Deployments.
• Provided 24X7 support and team player during production outage.

Environment: TSQL, MS SQL SERVER 2000/20 /2014 , SSRS, QUERY ANALYSER, VISUAL STUDIO 2005, VB.NET,C#,WINOWS SERVER 2008,IIS,Orion,Hyper-v.

Confidential

Sr.SQL Server Developer/DBA

Responsibilities:

• Installation of SQL Server 2005/2012, service packs, hot fixes, security patches, Lite speed
• Implemented and maintained Database mirroring as a Disaster Recovery Solution
• Worked on the migration of SQL Server 2000 to SQL Server 2005
• Used Data Partitioning, Snapshot Isolation in SQL Server 2005
• Update statistics, database integrity check and Backup operations
• Generated reports from Jobs, Alerts, SQL Mail Agent and scheduling DTS and SSIS, SSRS Packages
• Designed and implemented comprehensive Backup plan and disaster recovery model
• Worked extensively in Query Analyzer and Profiler for tuning queries using variable for characteristics and query costs
• Created and modified Stored Procedures and Functions to generate reports
• Used log shipping for synchronization of database
• Implemented AWE /PAE switches for SQL Server to grab more than 4 GB RAM
• Configuring Perfmon, blocking analysis, enabling of AWE and PAE, Max degree Parallelism
• Practical experience in managing the internal and external MS SQL database security.
• Maintained databases with DBCC (Rebuilding Indexes, Integrity Checks)
• Responsible for creating user groups and assigning permissions.
• Optimized stored procedures and indexed query using Index Tuning Wizard.
• Worked on database Design and Architecture based on business user requirements and performed Normalization (Third Normal Form) and De-Normalization.
• Provided analysis and recommendations for setting up a comprehensive Backup and Recovery Strategy for SQL Servers.
• Setup and maintained Linked Servers.
• Expert in data transformation services like SSIS, DTS, BCP and Bulk Insert.
• Familiar with taking backup of Regex with Akeeba Backup Tool.
• Involved in validating credit card number using regular expressions.
• Performed backup strategies for OLTP/OLAP systems.
• Provided back-end support for functional testing and performance testing.
• ITIL expert in handling different stages of a project lifecycle.

Environment: TSQL, MS SQL SERVER 2000/20, SSRS, QUERY ANALYSER, VISUAL STUDIO 2005, VB.NET,C#,WINOWS SERVER 2008,IIS,Orion,Hyper-v.

Confidential

SQL SERVER DEVELOPER/DBA

Responsibilities:

• Implemented SIDE BY SIDE Migration of MS SQL SERVER /2008 on Windows
• Migrated DTS 2000 PACAKGES to SSIS packages and maintained the archival data using Control flow task.
• Configured the AWE and /3 GB switch for the 32 bit 2005 server.
• SQL Server bit Failover Cluster Installation on Windows Server bit.
• Experience with Cluster Configuration in SAN environment.
• Applied Patches and Service packs to update different versions of MS SQL SERVER.
• Fixed the failed PRINCIPALS (logins), user permissions and security in ACTIVE DIRECTORY and SQL SERVER LEVEL.
• Implemented native log shipping on MS SQL SERVER 2005.
• Scheduled regular BACKUP JOBS and kept track of DATABASE by receiving the emails on Alerts.
• Implemented the new SQL Server 2005 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 2005
• Moved files between the File Groups and partitioned the tables to improve the performance.
• Extensively used lite speed backup with MS SQL SERVER 2005.
• Used Spot Light from quest to perform data base health checks.
• Utilized the new features of 2008 like TCE, EKM, MERGE STATEMENT and Compressed Backups.
• Documented and performed the data base health checks regularly.
• Experienced in generating web analytic reports using Omniture Web Analytics.
• Created new tables, stored procedures and triggers IN T-SQL.
• Refactored and fine-tuned the queries and stored procedures in T-Sql.
• 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 performance considering threshold values of the counters.
• Rebuilding indexes with different fill factors and update statistics manually.
• Implemented native log shipping for HIGH AVALIBLITY of the Production Server DATA BASE.
• Generated reports in SSRS using BIDS (Business Intelligence Development Studio).
• 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 , SSRS, QUERY ANALYSER, VISUAL STUDIO 2005, VB.NET, C#, WINOWS SERVER 2008, IIS, spot light.