SUMMARY

• Technically sophisticated, business - savvy professional and a team player who can undertake responsibilities beyond job titles, with 8+ years of experience as SQL DBA. Demonstrated ability in implementing technologies that decrease costs and improve performance.
• Expertise inDatabase Administration of verylarge and complex databasesinSQL Server 2014, 2012, 2008 R2, 2008andSQL Server 2005/ 2000 on 32 bit and 64 bit environments.
• Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.
• Implemented new SQL Server 2012 technique ALWAYS ON for High Availability Disaster Recovery.
• Strong understanding of RDBMS concepts as well as Data Modeling Concepts.
• Extensive experience in implementing HADR solutions like Replication, Log shipping, Clustering and mirroring on physical and virtual machines.
• Extensively worked on Active-Active and Active-Passive Clustering.
• Configured Transactional and Snapshot Replication
• Configured Synchronous and Asynchronous Mirroring for DR.
• Implemented Inplace and Side by Side Migration of MS SQL SERVER of different Versions.
• Experience with Microsoft SQL Server Integration Services
• Experience with Policy Based Management, Resource Governor, and Transparent Data Encryption (TDE).
• Good experience in Deploying SSIS packages in MS SQL Server 2008 and MS SQL Server 2012.
• Expert in Data Integrity, Performance Tuning, Query Optimization
• Expert level skills in Objects creation such as Table, Normalization, Indexes, Stored Procedures, Cursors, Triggers and other SQL joins and query writing.
• 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 Databases.
• Handling Memory configurations for SQL Server 2000 and 2005 on Windows 2003 Server.
• Experience in analyzing Locks, Dead Locks and Handling the Isolation Level and Concurrency Effects.
• Upgradation of SQL server versions and applying patches and hot fixes.
• Worked in an environment with Change management process (Service-now tool) in place for all kind of production and non-production changes.
• Responsible for day-to-day activities, such as backups to the disk and restore the databases and transaction log on production/development servers as per business / IT needs using SQL Safe.
• Troubleshooting the Disk failures in a Cluster Environment.
• Experience working in both OLTP and OLAP environments.
• Experience in transforming data from one server to other servers using tools like Bulk Copy Program (BCP) and Data Transformation Services (DTS) and SSIS.
• Used Index tuning izard and rebuilding indexes for faster Query Performance.
• Experience with The Microsoft Assessment and Planning (MAP) Toolkit
• Implemented T-SQL features like Data partitioning, Error handling and Snapshot Isolation.
• Configured the DB SMTP mail for the notification purposes.
• Experience in identifying the I/O and memory, bottle necks, blocking and deadlocks caused by complex queries using SQL Server Activity monitor/profiler, and handling them by implementing better Query Execution plans.
• Used DBCC Utilities to maintain the consistency and integrity of each database in the production server.
• Experience in Backing up, restoring the data base manually and also by scheduling the jobs and Maintenance Plans.
• Conversant with all phases of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.
• Good experience in Data modelling (Conceptual) and Meta Data services.
• Experience in configuring Registered Servers, Linked Servers, and Multi Server Administration.
• Extensively used the native tools like index tuning wizard, data base tuning advisor, profiler, performance monitor, activity monitor, Event viewer for performance analysis.
• Experience in comprising Performance Tuning, Query Optimization, Client/Server Connectivity, and Database health Check, Indexing, Updating Statistics.
• Extensively used Repositories like Team Foundation Server (TFS), Visual source safe and Clear Case for Data Archival.
• Expert in analyzing the execution plan and index management for better Query Optimization.
• Configured SMTP Server for Database Mail setup and received Alerts for the Threshold values.
• Experience in using DMV, DBCC and dynamic management functions.
• Migrated SQL Server 2000 databases into SQL Server 2005 and SQL Server 2008.
• Experience working with change control process.
• Responsible for validating and editing change control or change requests to ensure compliance including verification checks and fallback procedures.
• Having experience in monitoring server health using SCOM.
• Strong ability in Scheduling and deploying reports on Report manager
• Experience in the development of Reports using SQLServer2000/2005 Reporting Services (SSRS) and Microsoft Access and developed Custom Report and different types of Tabular Reports, Matrix Reports, and Drilldown Reports in multiple formats using multi - dimensional objects.
• Experience in building SSIS packages (.dtsx) involving ETL process, extracting data from various flat files, Excel files, legacy systems and loading into SQL server.
• Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer.
• Good understanding of different RAID levels implementation.
• 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
• Strong experience in mentoring with team members, documentation and 24/7 on call production support.

TECHNICAL SKILLS

Operating System: Windows 2000/2005/2008 Server, Windows 95/98/XP/NT, Linux, Solaris, Unix

Databases: MS SQL Server 2014,2012,2008 R2,2008, 2005,2000, Oracle 8i,9i, Sybase

SQL Server Tools: Management Studio, Business Intelligence Development Studio, Visual Studio 2005, Enterprise Manager, Query Analyzer, Profiler, Performance Monitor, Log Shipping, SSIS, SSRS, SSAS, Microsoft Clustering Services (MSCS), PowerShell

Programming: T-SQL,PL-SQL,HTML,HTML5,XML,CSS,C,C++DBA: Database administration of MS SQL Server 2014, 2102, 2008 R2,2008, 2005,2000

Data Migration: SSIS, BCP, Data Migration, Import/Export Wizard

Backup Utility: Quest Lite speed, SQL Safe, RedGate, Tivoli, Idera

Build Tools Analytical Tools: Free NAS, OWNCLOUD, Virtual Box, NODE-XL, MS Project and Visio

Monitoring Tools: BMC Patrol, SQL Server Profiler and Performance Monitoring

PROFESSIONAL EXPERIENCE

Confidential, West Des Moines, IA

Database Analyst

Responsibilities:

• Always-On High availability environment with three clusters of two nodes, with two clustered nodes in one domain and rest in another domain.
• The packages created included a variety of transformations, for exampleSlowly Changing Dimensions,Look up, Aggregate, Derived Column, Conditional Split, Fuzzy Lookup, Multicast and Data Conversion.
• Attending On-Call support calls regularly.
• Used Red Gate for backups and maintenance jobs which includes updating statistics, database integrity checks.
• Installed patching and administered 2-Node cluster Active/Passive on Microsoft Windows Server 2008 R2 Enterprise Edition on SAN environment.
• Patch Dev/SIT/Production databases by applying PSUs and one-off patches provided by Microsoft.
• Replication is massive in this environment, as there are many servers that are connected with the databases that are linked by replication. As the data needs to be same across the testing servers and application.
• Performance tuning for Optimized results using Explain-Plan.
• Involved in Performance tuning of ETL transformations, data validations and stored procedures.
• Employed SSIS Data Profiler Task to profile Target Source Systems and build ETL Solutions, which was helpful in designing the table structures and cleaning data for data consistency.
• Extracted data from various sources like SQL Server 2008/2012/2014 , Oracle, .CSV, Excel and Text file from Client servers and through FTP.
• Expert in working with Third party backup tool likeSQL Lite Speed,Idera SQL Safeto improve performance of backup and recovery.
• Worked on active directory modules able to operate the ad directory objects using special command lines to get information about users and their property
• Extensively worked on DMVs, Performance dashboard, Mirroring, database snapshots and tracking Performance Counters.
• T SQL writing complex stored procedures and CLRS, indexed partitioned views, Functions, Partitioned Tables, Complex SQL Queries, Performance tuning for these.
• Power shell scripting for jobs and batches for T-SQL daily runs in UAT and production environment.
• Checking available physical Disk space, Log Space, jobs for failed completion, backups and log sizes, Monitoring performance with PERFMON COUNTERS.
• Built a daily reporting structure for all failed jobs in production worked with development teams to identify fixes for SSIS packages and make sure they are implemented.
• Handle database environments on daily basis observing the performance of the production database and constantly active regarding performance and space management issues.
• Continuously monitoring and updating Backup and Recovery strategy to recover data using RPO and RTO solutions based on requirements.
• Create Users, Groups, Roles, Profiles and assigning users to groups and granting object level permissions to appropriate groups.
• Plan for storage space requirements and placing them for optimum I/O performance.
• Create and scheduling jobs using Ola Hallengren scripts.
• Performed Mirroring between Production and BCP when required.
• Strong experience in mentoring with team members, documentation and 24/7 on call production support.
• Involved to planning and designing SSAS 2012 Cubes and building attribute relationships for optimal MDX query performance of Hierarchies and Fact Dimensions.
• Level II experience of Oracle administration to assign security permissions, RMAN backups, OEM (Oracle enterprise Manager) and AWR reports for the query execution on the server.
• Experience in RDBMS database design, performance tuning, optimization, backup and recovery in SQL Server 2005/2008/2012.
• Implemented best partitioning practices for tables in very large databases
• Maintaining stable environment for 65000 users.

Environment: Environment: MS SQL Server 2000/2005/ 2008/2012/2014 , Windows 2003/2008,SSIS, SSAS, PL/SQL, MS Access, Perl script, Red Gate, companion, Idera, TSM/TDP

Confidential, Mooresville, NC

Sr. SQL Server DBA

Responsibilities:

• Install, Manage and administer SQL server 2005\2008R2\2012\2014 SQL servers.
• Migrations of SQL server from one version of SQL server to another.
• Implemented side by side and Inplace Migration of MS SQL server /2008R2 and applied Patches and Service packs to update different versions of MS SQL server.
• Implemented new SQL Server 2012 technique ALWAYS-ON High Availability groups.
• Building SQL 2008R2 cluster environments on VMware/ Physical environments.
• Applying patches and hot fixes.
• Adding nodes to already existing clustered servers as a part of data load\High availability.
• Configured Transactional Replication and Log Shipping.
• Fix the Cluster and Replication issues on SQL 2005/2008R2/2012 servers with in very strong SLA’s.
• Usage of new compression Techniques in SQL Server 2008(R2) for backup and restore jobs.
• Implementation of SQL server logins, Roles and Authentication modes as a part of security policies.
• Creating and scheduling maintenance plans for updating statistics, checking fragmentation, checking database integrity and backup plans.
• Performed Administrative tasks in SQL Server using PowerShell.
• Configured Database mail, linked servers, Transparent Data Encryption (TDE) and Auditing
• Performance tuning of databases by windows performance monitor and SQL Profiler
• Used Index tuning wizard to redesign and created the indexes for better performance.
• Fine-tuned Stored Procedures using Execution Plan in T-SQL for better performance.
• Documenting the standard procedures on regular basis.
• Experience working with change control process.
• Conducted various meetings and conferences with application teams to meet corporate milestones for database consolidation and data migration
• Resource planning and coordination for application migrations with project managers, application and web app teams.
• Handled numerous Change Management requests on production servers.
• Reorganizing or Rebuilding Indexes based on the Index fragmentation.
• Worked Extensively on Remedy application Database server tuning.
• Configured Transactional replication on migrated server.
• Extensively used Red Gate SQL Compare and Data Compare tools to compare and synchronize SQL Database Schemas.
• Involved in Data Compression, Hot add CPU, Fact Table size reduction and improved performance using SQL Server 2008.
• Experience in transforming data from one server to other servers using tools like Bulk Copy Program (BCP) and Data Transformation Services (DTS) and SSIS.
• Experience in SQL Server Reporting Services (SSRS).
• Involved in capacity planning, sizing and database growth projects.
• 24*7 On Call production support.

Environment: MS SQL Server 2005/2008R2/2012/2014, Windows 2003/2008/2012 , SSRS, SSIS, SSAS, PL/SQL, MS Access, Perl script, Erwin, companion, MS SCCOM, Tivoli TSM

Confidential, BELOIT, WI

SQL Server DBA

Responsibilities:

• Installed and configured SQL Server 2005/2008 R2 on Prod and Non-Prod environments.
• Configured HADR techniques like replication (snapshot and transactional), Mirroring, log shipping and clustering on virtual and Physical environments.
• Worked on side-by-side migrations of SQL server.
• Applied service packs as a part of standardization project.
• Implemented SQL Server Auditing to collect data for Quarterly audits.
• Troubleshoot Performance issues on production environments using Performance counters, extended events/Profiler and DMV’s to find the resource bottlenecks.
• Resolve locking and blocking issues.
• Experience in Creating, managing SQL Server AZURE Databases and setting up Connection Strings and connecting SQL Server AZURE Databases from locally Installed SQL Server Management Studio (SSMS) for Developers.
• Refresh non-prod environments with production data on regular basis.
• Implemented data availability solutions like online restore, online index, database snapshot and fast recovery.
• Provided RAID level suggestion for data files, log files and tempdb drives
• Used Index tuning wizard for optimal query performance.
• Monitoring SQL Server LOGS, Application logs and analyzing the logs.
• Reorganizing or Rebuilding Indexes based on the Index fragmentation
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Creating Backup strategies and scheduling them as a part of database maintenance plans.
• Providing 24*7 support

Environment: SQL Server 2008 R2/2005/2000,Windows 2003/ 2008 Server, C#.net, VB and ASP.NET, Lite Speed, MS Visio, Microsoft SQL server Visual Studio 2005/2008 R2

Confidential, Olympia, WA

SQL Server DBA

Responsibilities:

• Manage 210+ Database Servers between the Development, Quality Assurance, User Acceptance and Disaster Recovery Environments
• Migrated and Troubleshooting of Upgrades issues like SQL Server in Microsoft Windows Server 2003 R2 Enterprise Edition.
• Built Disaster recovery environment as replica to the Production servers and Created Custom Log-Shipping to manage and Support Disaster Recovery and Production Support restores
• Administration and Troubleshooting of Log Shipping
• Written stored procedures, cursors, user defined functions and tuning and optimizing Queries in SQL Server
• Extensive testing on the performance of the Stored Procedures.
• Enhanced the coding guidelines document for SQL developers
• Involved in Creating SSIS packages to integrate the data coming from various data sources.
• Monitored the SQL Server Jobs, database size, disk space in SQL Server.
• Developing Backup & Disaster Recovery strategies and implementing on all production servers.
• Running DBCC consistency checks and fixing data corruption in application databases.
• Monitor all DDL changes in production environment
• Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels
• Configured Email notifications thru SMTP to get Alerts and diagnose the performance counters.
• Used Dynamic Management Views (DMV) and Functions for monitoring the performance of the server
• Performed Database Integrity Checks, updated Database Statistics and performed Re-indexing through Maintenance Planner
• Experience in ETL process by extracting the data from XML, Flat Files and loading to the Reporting DB based on the Business requirements
• Controlled and Coordinated the installations ( Security Patches, Service packs ) and evaluated the performance before Pre-deployment
• Migrated DTS packages to SSIS Packages using DTSX change tool
• Performed SQL Server 2008 Compression Backup and Data Compression
• Perform the Node Injection to upgrade the Hardware on Cluster Servers.
• Used Visual Source Safe and Team foundation servers to maintain version control Mechanisms.
• Configured SQL Servers with appropriate settings to resolve various resource allocation & memory issues
• Perform capacity planning and offer both long and short term solutions to controlling and managing database growth and space management
• Develop and implement backup and recovery strategies using both native SQL and third party technologies like Lite Speed 4.8 and 5.0.
• Rebuilding the online indexes at regular intervals for better performance

Environment: T-SQL, MS SQL SERVER 2005/2008R2/2012, IIS Server 5.0, Windows Server NT/2003/2008R2/2012, SSIS, SSRS, SSAS.

Confidential, Plano, TX

SQL Server DBA

Responsibilities:

• Configure Transactional and Snapshot replication on SQL 2008R2 Servers
• Install SQL server 2008R2 servers on Physical/virtual servers and apply Service packs where needed.
• Used SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.
• Responsible for creating the reports basing on the requirements using SSRS 2005.
• Used ETL tools to maintain the quality of data and also to improve the metadata capabilities.
• Created various Database Objects - Tables, Indexes, Views, and Roles.
• Performed Full and Differential backup with bulk-logged recovery models.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Database Tuning Wizard (DTA)
• Used Joins, correlated and correlated sub-queries for complex business queries involving multiple tables from different databases.
• Implemented Functions, views, trigger and stored procedures and enforced business rules via checks and constraints.
• Created indexes on selective columns to speed up queries and analyses in SQL Server Management Studio.
• Use the SQL Analyzer and Profiler for studying the SQL statements and procedures.
• Used T-SQL for programming for stored procedures and queries.
• Developed SSIS Templates which can be used to develop SSIS Packages such a way that they can be dynamically deployed into Development, Test and Production Environments.

Environment: T-SQL, MS SQL SERVER 2005/2008R2, Windows Server NT/2003/2008R2/2012, SSIS, SSRS, SSAS.

Confidential

SQL Server Developer/DBA

Responsibilities:

• Managed and Administrated the SQL Server 2008/2005/2000 production and Non-production servers.
• 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.
• 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.
• Extensively worked on performance issues like update statistics, Auto Stats.
• Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks.
• Memory Configuration for SQL server on 32-bit boxes.
• Created various jobs to check health of the server and to troubleshoot.
• Developed SSIS packages, stored procedures, functions, triggers.

Environment: T-SQL, MS SQL SERVER 2000/2005/2008 R2, Windows Server NT/2003/2008R2, SSIS.