SUMMARY

• 8+ years of experience with the 32bit, 64 - bit Microsoft SQL SERVER in Production, Development and Testing in Clustered and Stand-alone Server Environment.
• Experience installing MS SQL SERVER 2000,2005,2008,2008 R2,2012 updating with hot fix and service packs
• Extensive experience in implementing High availability solutions like Replication (Snapshot and Transactional), Log shipping, Clustering and Mirroring on physical and virtual machines.
• Extensively worked on Active-Active and Active-Passive Clustering.
• Implemented Side by Side Migration and in-place upgrade of MS SQL SERVER 2000/2005/2008 to 2008R2.
• Worked on High Availability 2012 Solutions Always On
• Experience in Migrating DTS 2000 packages to SSIS packages in 2005 using Migration Wizard.
• Good at SQL Server 2008 new features like Policy Based Management, Data Compression, Resource Governor, Performance Data Collector and Transparent Data Encryption (TDE).
• Good Knowledge about the newly added features DATA QUALITY Services, Master Data Services in MSSQL 2012
• Experience in using the DMVS, DMFS, SP PROCS, INFORMATION SCHEMA, SYSTEM VIEWS and in-built GLOBAL VARIABLES for the instant analysis.
• Extensive experience and proficiency on the design, construction and implementation of Business Intelligence tools (Star Schema, Data-Warehouses, OLAP cubes, Partitioning and Aggregations), ETL Process (Data Extraction, Transformation layer) with DTS/SSIS, Data Cleansing and Reporting Services (SSRS)
• Dexterous developer in creating Constraints, Defaults, Tables, Indexes, Views, Stored Procedures, Functions, Triggers and Dynamic SQL queries.
• Expertise in using Temporary Tables, Table Variables, CTEs.
• Performed BCP, BULK INSERT, Imported and Exported data from different Data Sources.
• Experience in logical and physical data modeling of the database in ERWIN and MSVISIO.
• Experience in Normalization, Database design, Performance Analysis and Production Support for very large (VLDB) and Complex Databases.
• Configured the AWE and /3 GB switch for the 32 bit 2005 server
• Deployed and Debugged SSIS packages for import, export and bulk insert data with transformations from various data sources.
• Scripted VB.net in the script task for data conversions in XML file in SSIS packages.
• Extensively Worked on SSIS and SSRS.
• Extensively used the XML, FLAT FILE, BULK INSERT AND FILE SYTEM control flow tasks and data flow tasks SSIS.
• Experience in analyzing Locks, Dead Locks and Handling the Isolation Level and Concurrency Effects.
• Extensively used the native tools like index tuning wizard or database tuning advisor, profiler, performance monitor, activity monitor, Event viewer for performance analysis.
• Extensively used Repositories like Team Foundation Server (TFS), Visual source safe and Clear Case for Data Archival.
• Experience in 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 also by scheduling the jobs and Maintenance Plans.
• Expert in analyzing the execution plan and index management for better Query Optimization.
• Expertise in Identifying the bottlenecks caused by complex queries using Activity Monitor/SQL Profiler and handling them by implementing better Query Execution plans
• 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.
• Explicitly used third party tools like Lite Speed, Fog light and Red gate.
• Auditing of database for users transaction, login and database action and removing orphan users
• Worked with a team of business analysts, data architects, application developers, ETL developers and testers.
• Experience in Software Development Life Cycle (SDLC), Analyzing and Designing systems using Structured Methodologies (ERD, DFD) along with extensive knowledge of Relational Database Management Systems with in-depth of T-SQL.
• Actively involved in management of Change Control Requests.
• My objective was to deliver projects within scope, time and costs while following department standards, methodologies and guidelines.
• Strong experience in mentoring with team members, documentation and 24/7 on call production support.
• Excellent Problem Solving Skills, Communication, presentation and interpersonal skills. Strong troubleshooting and organizational skills.

TECHNICAL SKILLS

Languages: T-SQL, My SQL, C/C++.

Operating Systems: Windows 95/2000/2003/2008/ XP/VISTA/7, 8, 8.1, LINUX, VMware ESX servers

Databases: MS SQL Server 2012,2008R 2/ 2008/2005/2000 , MS Access

ETL & Reporting Tools: Data Transformation Services(DTS), SQL Server Integrated Services(SSIS), SQL Server Reporting Services(SSIS), SQL Server Analysis Services(SSAS), Statistical Analysis Software(SAS)

DB Utilities: SQL Server Management Utility, Query Analyzer

Application Software: Visual Studio 2005/2008/2010 , Visual Source Safe, Team Foundation Server, MS Office Suite

Data Modeling Tools: SQL DB Access, Performance Monitor, Backup Utility, Idera, SQL LiteSpeed, Visio 2000, RedGate, FogLite

PROFESSIONAL EXPERIENCE

Confidential

MS SQL DBA

Environment: MS SQL Server 2005, 2008 R2, 2012, Windows 2003 Server, Windows 2008 R2, Windows 2012 Server, MS Visual Studio 2010, SSIS Packages, Excel, HTML, NetBackup tool, Guardium tool, Nimsoft Tool.

Responsibilities:

• Our inventory consisted of more than 2500 MS SQL servers globally
• Installed, managed and administrated the MS SQL Server 2014/12/08/05 Production and Non Production Servers.
• Handled up to 2.5 TB size database in Active Passive clustered Environment.
• Worked in huge Replication Environment.
• Used Netbackup Tool for backups and maintenance jobs which includes updating statistics, database integrity checks
• Day-to-day activities like taking backup (or schedule the backups daily for database and transaction log) on disk and restore the databases.
• Created Logins for the users and manage their permissions.
• Used SQL Profiler to monitor the server performance, debug T-SQL and slow running queries.
• Used Bulk insert to load huge tables.
• Worked in setting up the SQL Server configuration settings to resolve various resource allocation & memory issues for SQL Server databases and to setup ideal memory, min/max server options
• Developed and created the new database objects including tables, views, index, stored procedures, functions, triggers, advanced queries and also updated statistics
• Implemented partitioning on large table to get the performance.
• On-call Support 24x7 for DBA support
• Used table hints in the queries to avoid locks in the server.
• Created missing indexes on the tables by running Data Base Engine Tuning Adviser.
• Finding and solving locks and Deadlocks by using DMV’s and DBCC commands.
• Guardium Tool for Auditing and security Purpose across the servers in the inventory.
• Configured Transactional Log Shipping between Primary and Secondary Servers depending on the business requirements.
• Configured Bi - directional transactional replication and have resolved many of the issues related to replication
• Created Numerous known error records to problem tickets
• Managing the clustering environment
• Created Linked Server between SQL Servers
• Nimsoft tool used to alert as a ticket for all the parameters set to look after the MSSQL server in organized way
• Faster Delivery rate of the resolution and critical thinking was also as a part of Experience as part of the project.

Confidential

MS SQL DBA

Environment: MS SQL Server 2005, 2008 R2, 2012, Windows 2003 Server, Windows 2008 R2 Server, ERWIN, MS Visual Studio 2010, SSIS Packages, Excel, HTML, Idera, RedGate.

Responsibilities:

• Installed, managed and administrated the MS SQL Server 2012/08/05 Production and Non Production Servers.
• Setup development, testing and production environment with SQL Server 2012 and 2008 R2 Enterprise edition.
• Performed installation of SQL Enterprise 2005 64bit version on Windows 2003, 2008 servers and VM ware servers on Enterprise systems of Clustered and standalone servers in enterprise datacenters. Patch applications.
• Handled up to 1.8 TB size database in Active Passive clustered Environment.
• Involved Upgrade and Migration of SQL Server 2005/2008 in placed, side by side to MS SQL Server 2012.
• Worked in huge Replication Environment.
• Configured and worked on Database Mirrored Environments.
• Performed Failover drill tests to check the High Availability during disasters
• Worked on High Availability 2012 Solutions Always On
• Used Red Gate for backups and maintenance jobs which includes updating statistics, database integrity checks
• Day-to-day activities like taking backup (or schedule the backups daily for database and transaction log) on disk and restore the databases.
• Created Logins for the users and manage their permissions.
• Used SQL Profiler to monitor the server performance, debug T-SQL and slow running queries.
• Used Bulk insert to load huge tables.
• Worked in setting up the SQL Server configuration settings to resolve various resource allocation & memory issues for SQL Server databases and to setup ideal memory, min/max server options
• Developed and created the new database objects including tables, views, index, stored procedures, functions, triggers, advanced queries and also updated statistics
• Modified Stored Procedures and complex T-SQL queries to improve query execution process
• Created Logins, Roles and Proxy accounts with appropriate permissions and maintaining Database Maintenance Plans
• Configured DB mail by creating accounts and profiles.
• Monitored alerts using FogLight and Spotlight and also looked into Event Viewer, SQL Error logs and Log File Viewer for software and hardware related errors.
• Provided On call Production support.
• Implemented partitioning on large table to get the performance.
• Tuned stored procedures by using execution plans.
• Continuous monitoring server health with Idera
• Worked extensively on third-party tools like RedGate for backup and restore.
• Used table hints in the queries to avoid locks in the server.
• Created missing indexes on the tables by running Data Base Engine Tuning Adviser.
• Finding and solving locks and Deadlocks by using DMV’s and DBCC commands.

Confidential

MS SQL DBA

Environment: SQL Server 2000/2005/2008 Enterprise, Windows Enterprise Server 2003,IIS 6.0, T-SQL, Microsoft Reporting Service, VMware, SQL Server Reporting Services and SQL Server Integration Services.

Responsibilities:

• Worked extensively on installation and configuration of MS SQL Server 2005 /2008 /2008 R2 on standalone and clustered Environments
• Involved in migration of MS SQL Server 2005/2008 to MS SQL Server 2008 R2.
• Handled clustering between two Production Servers and performed daily backups and developed recovery procedures.
• 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.
• Migrated DTS packages to SSIS 2005 packages.
• Administered the MS SQL Server by creating User Logins with appropriate Roles, dropping and locking the logins, monitoring the User Accounts, granting and privileges to users.
• Scheduled the Backups for Databases and performed Restoration operations.
• Created, built and deployed successfully SSIS packages by using BIDS.
• Created SSIS packages to validate, extract, transform and load data from Oracle into SQL Server database.
• Implemented and Maintaining Replication.
• Generate every day morning Replication reports from branch SQL Servers and Resolve Issues.
• Created jobs and scheduled jobs according to Requirements.
• Assisted in Deploying 2 NODE failover clustering.
• Implemented Transactional Replication between Primary and Secondary Servers.
• Created Databases, Tables, Indexes and Views.
• Created Linked Server between SQL Servers.
• Implemented SQL Server Clustering on VM Ware.
• Configured Mirroring and Transactional Log Shipping between Primary and Secondary Servers depending on the business requirements.
• Worked with SQL Server Profiler to Generate Traces.
• Developed documentation that sufficiently describes technical deliverable as required for internal controls so that the maintenance responsibility can be passed on to production support team.
• Continuous monitoring server health with Idera
• Managed VERITAS net backups and LiteSpeed backups, Used SQL Profiler to capture the activities of the database and used the trace file as workload file to the Database Tuning Advisor for index recommendation.

Confidential

SQL Server DBA/Developers

Environment: SQL Server 2000/2005/2008 Enterprise, Windows Enterprise Server 2003,IIS 6.0, T- SQL, Microsoft Reporting Service, VMware, SQL Server Reporting Services and SQL Server Integration Services.

Responsibilities:

• Installation & configuration 2005 enterprise Edition.
• Expertise and Interest include Administration, Database Design, Performance Analysis, and Production Support for Large (VLDB) and Complex Databases up to 2 Terabytes.
• Converting DTS packages to SSIS packages.
• Designed the reporting databases by using Erwin.
• Transformation of data (Millions of records) to SQL server by SSIS, DTS, BCP.
• Played a key role in business requirements analysis, architecture designs, physical and logical Data modeling, application development by using Erwin.
• Rebuilding the indexes at regular intervals for better performance.
• Created stored procedures for maintaining SQL Server, Written Stored Procedures for Application Developers.
• Migrate databases easily from SQL Server 2000 to SQL Server 2005 by using RedGate.
• ETL experience with SSAS and SSIS.
• Install and upgrade packaged databases remotely by using red gate.
• Managing the clustering environment.
• Using log shipping for synchronization of database.
• Hands on experience and outstanding knowledge of high availability SQL Server solutions, including replication and SQL Server clustering
• Suggest replication techniques to meet business needs.
• Maintain transactional replication on production SQL Servers.
• Set up transactional, snapshot replication and maintain the active replication(s).
• Maintaining the database consistency with DBCC at regular intervals. Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Complete documentation about the database. To analyze long running slow queries and tune the same to optimize application and system performance.
• To set up SQL Server configuration settings.
• Performed daily backup and created named backup devices to backup the servers regularly.
• Generated Script files of the databases whenever changes are made to stored procedures or views.
• Created and managed schema objects such as tables, views, clusters, indexes, procedures, and triggers and maintained Referential Integrity.
• Performance tuning and optimization of Query of SQL server.
• Supporting programmers for moving objects to different environments.
• Creating and maintaining user’s logins and Roles.
• Tuned the database to perform efficiently by managing databases using the options to grow or shrink database files and monitored the size of the transaction log. Managed databases on multiple disks using Disk Mirroring and RAID technology.
• Estimated space requirements for a database.
• Converted and imported data from an Oracle Database to a SQL Server Database.
• Worked in tune with strategic planning for improving the mapping and data migration.

Confidential

SQL Server DBA/Developer

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

Responsibilities:

• Worked on Client/Server tools like SQL Server Management studio (2005), SQL Server Enterprise Manager (2000) and Query Analyzer to Administer SQL Server
• Migrated SQL server 2000 databases into SQL server 2005 databases by In-place upgrade process and also used upgrade advisor tool in up-gradation
• Setting up and Monitored transactional replication, Database mirroring on Production, QA and Development servers
• Migrated DTS packages into SSIS packages
• Handled up to 2 TB Size databases with clustered and stand alone environment
• Configured Transactional replication on migrated server
• Wrote the packages using SSIS in SQL2005
• Extensively worked on Dynamic Management Views (DMV’s) and Dynamic Management Functions (DMF’s)
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Integrated SQL traces with Perfmon log to have better graphical analysis to find system bottlenecks
• Implementation of SQL Principle, Securable, Permission, Roles and Authentication Modes as a part of Security Policies for various categories of users
• Maintaining SQL Script for creation of Database Objects using VSS (Visual Source Safe)
• Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks
• Planned the Complete Backing up of Database and Restoring the Database from Disaster Recovery
• Used DTS packages to move logins and jobs from one server to another server
• Used log shipping for synchronization of database
• Good experience in data modeling and metadata services
• Monitoring SQL server performance using profiler to find performance and deadlocks
• Created Stored Procedures, Triggers, Views and Functions for the Application
• Extensive testing on the Performance of the Stored Procedures

Confidential, NJ

MS SQL DBA

Environment: MS SQL-Server 2000, DTS, SQL Diagrams, Erwin, Windows 2000 Server, MS Access, MS Excel, MS Analysis Services, MS Reporting Services, HTML 4.0.

Responsibilities:

• Managed and Administrated the SQL Server 2008/2005/2000 production and Non-production servers.
• Tuned aggressively stored procedures in order to increase the performance with no cost effective.
• Worked as a team following Agile/SCRUM methodology for iterative and incremental development.
• Administered and maintained production/Development servers with more than 2 TB of database size with complex structures.
• Performance metrics reports daily, weekly and monthly.
• Designed a report on the monitoring of SQL Server Performance. This report gives a detail report to the management on the Performance of the server.
• Worked with SQL Server 2005 side by side upgrade from SQL server 2000.
• Installed couple of SQL Server 2005/2008 on cluster environment.
• Integrated SQL server profiler traces with Performance monitor to have better graphical analysis to find system bottlenecks.
• Created Documentation for steps need to be taken while upgrading the SQL server 2000 to SQL server 2005.
• Expertise in setting up and troubleshooting Database mirroring.
• Optimized working process.
• 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, Mail Setup, Jobs, and Alerts, DTA,SQLCMD and dedicated admin connection.
• Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Rebuilding the indexes at regular intervals for better performance based on level of fragmentation.
• Extensively working on performance issues like update statistics, Auto Stats.
• Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks.
• Configured up to 32 GB of memory.
• 24/7 on call support, created various jobs to check health of the server and to troubleshoot.
• Huge data of Insurance policies and customer information in XML, Flat file data transforming using SSIS Packages.
• Developed SSIS packages, stored procedures, functions, triggers.
• Tuned servers to the peak for maximum performance by configuring memory and various server level parameters.
• Hands of experience in writing batch files.
• Extensively worked on extraction, transformation and loading of data from various data sources to SQL Server.

Confidential

SQL Database Developer

Environment: s: SQL SERVER 2000, DTS packages, Crystal Reports 6.0, Microsoft Visual Basic 6.0 and windows 2000.

Responsibilities:

• Applied Normalization rules in designing the database.
• Created Entity relationship diagrams ER-Diagrams, function relationship diagram, Dataflow Diagrams and enforced all referential integrity constraints.
• Developed database objects like tables, views, stored procedures, indexes etc.
• Tuned SQL statements using views and stored procedures.
• Rebuilding the indexes at regular intervals better performance.
• Wrote various stored procedures for the purpose of application development.
• Design and implemented data access stored procedures and triggers for automating tasks.
• Extensively used joins and sub-queries to simplify complex queries involving multiple tables.
• Responsible for creating DTS packages and scheduling packages
• Managing of users including creation/alteration, grant of system/db roles and permission on various database objects
• Performed various data transforms between various servers using BCP and DTS.
• Worked on crystal reports with many complex stored procedures.
• Created multi-format reports using Crystal report.