SUMMARY

• 8+years of Microsoft SQL Server Database Administration, Architect & Development experience in SQL Server 2000/ 2005/2008/2008 R2/2012/2014 systems in OLTP and OLAP environment.
• Installed SQL Server 2008/2008R2/2012/2014 on x64 - bit Operating System.
• Configured ALWAYS ON AVAILABLITY GROUPS With SQL Server 2012/2014
• Implemented side by side Migration of MS SQL Server 2000 to 2005/2008R2/2012 and applied Patches and Service packs to update different versions of MS SQL server.
• Experience in upgrading SQL server software to new versions and applying service packs and patches.
• Worked on applying SQL Server hot-fixes / Service Packs on all production and development instances on quarterly basis based on recommendations from Microsoft Tech-net.
• Installed SQL Server Client on all Client Desktops.
• Experience in working with Windows Servers 2000 / 2003 / 2008/2012 .
• Proficient with SQL Management Studio, Enterprise Manager, Query Analyzer, Business Intelligence development studio, Visual Studio, report builder 3.0, Scheduling jobs with SQL Server Agent.
• Expertise in deployments, certificate renewals, process job tickets & bugs, test verifies backups and recovery.
• Highly proficient in database Backup, Restore, Recovery, Linked servers, and Database Maintenance Plans.
• Experience on High Availability and Disaster Recovery like Replication, Log shipping, Mirroring and Clustering and database security and permissions
• Created Security by setting up groups and tan logins for each Roles or Users for Maintenance of Databases.
• Documented Disaster recovery plans and participated in disaster recovery drills.
• Successfully implemented and tested Log Shipping technique used for warm backup solution for MS SQL server 2000/ 2005/2008 databases.
• Proficient in implementing different types of Replication models like Snapshot, Transactional, Merge and Peer-Peer.
• Experience in Implementing Database Mirroring in SQL server 2005/2008/2008 R2/2012.
• Good noledge about New features in SQL server 2012 & 2014
• Involved in Installing, Configuring and Maintaining of both Active/Active & Active/Passive SQL Clusters
• Auditing database configuration and security configurations.
• Actively involved in System Performance by tuning SQL queries and stored procedures by using SQL Profiler, Database Engine Tuning Advisor, Windows performance monitor, DMVs, Resource Governor, Data collection Reports, DBCC and Custom Script, Built in performance Report and Activity Monitor.
• Experience with Database Backup and Restore.
• Experience in Scheduling and creating SQL Server jobs as well troubleshooting when jobs fail.
• Proficient in migration of Data from Excel, Flat file, Non SQL db’s Oracle/Db2/Sybase to MS SQL Server by using SSIS.
• Working noledge in SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS) to manage ETL environment.
• Knowledge in SSAS and different schemas like Star Schema and Snow Flake Schema and also Data Modeling, Cubes and MDX queries. Created different storage modes for OLAP cubes like ROLAP and MOLAP
• Extensive experience in implementing SSIS, SSRS, SSAS using Microsoft Business Intelligence development studio (MSBI) 2008R 2/2008/2005.
• Experience in working with huge databases, troubleshooting issues and documenting teh causes.
• Developed writing parameterized Queries for generating reports, formatting report layout, sub reports using global variables, expressions and functions in SSRS 2005/2008R2.
• Experience in implementation of enterprise databases on enterprise Storage Solutions using Storage area Networks (SAN) /Network Attached Storage (NAS).
• Management of schemas, Data modeling, objects & partitioning teh tables & indexes.
• Ability to meet deadlines, quickly adapt to different project environments and ability to work with different team across geographical locations.
• Experience in Data Modeling (Logical and Physical Design of Databases), Normalization and building Referential Integrity Constraints.
• Experience in providing good production support for 24x7 over weekends on rotation basis.
• Excellent organizational, interpersonal and communication skills with high level of adaptability and flexibility to adjust to changing work positions.
• Strong time Management skills and excellent team player.
• Ability to adapt quickly to changing environments.

TECHNICAL SKILLS

Languages: C, C++, SQL, T-SQL, PL/SQL

Database: MS SQL Server 2000/ 2005/2008/2008 R2,2012 MS Access

Web Servers: IIS 6.0, IIS 7.0, IIS 7.5

Operating System: Windows 2000, Windows 2003/2008/Professional

Scripting: Powershell 3.0/2.0

Disaster Recovery Tools: Log Shipping, Replication, Mirroring and Clustering Services

ETL Tools: DTS,SSIS, Informatica

Tools: SCOM, SCVMM, WireShark, NetMon, LogParser, PortQry

PROFESSIONAL EXPERIENCE

Confidential

SQL Server DBA

Environment: Microsoft Windows 2008 Server, Microsoft SQL Server 2012, 2008 (R2), Microsoft SQL Server 2005, Windows 2003/2008 Server, IIS Server 7, MS Visual Source Safe, IIS 6.0, XML.

Responsibilities:

• Installation and Maintenance of SQL Server 2005/2008(R2)/2012/2014 on Test, Development and Production Environments.
• Create and manage databases across Development and Production instances using SQL Server Management Studio.
• Usage of new compression Techniques in SQL Server 2005/2008(R2) for backup and restore jobs.
• Experience working with TSM Backups and Restore.
• Disaster Recovery Planning, Testing and Analyzing and continuous update of documentation.
• Implemented Database Mirroring and Transactional Replication as a part of DR plan.
• Creating Logins and Roles with appropriate permissions.
• Creating and Maintaining Database Maintenance Plans.
• Configured Database Mail for failure Job notifications
• Modify Stored Procedures and complex T-SQL Queries to improve query execution process.
• Enabling and Disabling Change Data Capture (CDC).
• Write T-SQL Scripts for database backup jobs and daily/weekly jobs.
• Tune slow running queries using SQL Server Profiler
• Worked with database tuning advisor, SQL server profiler, Performance monitor and activity monitor for Performance tuning
• Experience working with IDERA in Server Monitoring for Performance Monitoring, Dead Lock, Blocking.
• Import data across multiple instances using BULK INSERT and BCP Utility.
• Extract, Transform, and Load data from heterogeneous data sources to SQL Server using SQL Server Integration Services (SSIS) Packages.
• Plan, analyze and develop Ad-hoc Reports using SQL Server Reporting Services (SSRS) and Report Manager to support various user requirements.
• Worked with DTS Packages to load teh massaged data into Data Warehousing System.
• Create and manage database objects dat include Tables, Views, User-defined Functions, Stored Procedures, Constraints and Triggers to implement Business Logic.
• Create Clustered and Non-Clustered Indexes to improve teh performance of database access.
• Extensively worked on performance issues like Update statistics and Autostats
• Involved in Capacity Planning, Database Normalization and De-normalization process.
• Optimized teh database server usingDMV’s and DMF’sand performed acode reviewandtuningfor teh best performance of teh application.
• Involved in Logical and Physical Data Modeling process using MS Visio.
• Use MS Visual Source Safe as a Version Control System.
• Involved in Change Data Capture process.
• Monitoring Event Viewer, SQL Error logs and Log File Viewer for Software and hardware related errors.
• Avoiding
• Mentored team members to optimize SQL Queries.

Confidential, Roanoke, Virginia

SQL DBA / Developer

Environment: SQL Server 2000/2005 with clustering, Replication, T-SQL, Windows 2003 64-bit, SQL/PL SQL, DTS, SSIS, Profiler.

Responsibilities:

• Database Administrator/Database Programming/Product specialist.
• Implementation of SQL Logins, Roles and Autantication Modes as a part of Security Policies for various categories of User Support.
• Extensively working on IMS performance issues like update statistics, rebuilding teh indexes at regular intervals for better performance.
• Extensively worked on compliance issues.
• To analyze long running slow queries and tune teh same to optimize application and system performance.
• Worked on key performance indicators for customizable metrics.
• To set up SQL Server configuration settings.
• Monitoring SQL server performance using profiler to find performance and dead locks.
• Managed Disk space, memory and User connections.
• Rebuilding teh indexes at regular intervals for better performance.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Monitored and modified Performance using execution plans and Index tuning.
• Rebuilding teh indexes at regular intervals for better performance.
• Managing teh clustering environment.
• Using log shipping for synchronization of database.
• To setup, implement, and maintain industry standards in database management.
• Monitoring SQL server performance using profiler to find performance and dead locks.
• Monitoring teh servers using spot light third party Quest software.
• Maintaining teh database consistency with DBCC at regular intervals.
• Implemented teh online indexing on 24X7 environments.
• Created teh documentation for issue diagnostics reports.
• Migrated data to new location using Snapshot Replication, and implemented Transactional Replication to support up to date record of Inventory Information.
• Used SQL Profiler and Query Analyzer to optimize DTS package queries and Stored Procedure.
• Involved in DATA Analysis like Analyzing and Accessing collection of Data.
• To analyze long running slow queries and tune teh same to optimize application and system performance.
• To set up SQL Server configuration settings to resolve various resource allocation & memory issues for SQL Server databases and to setup ideal memory, min/max server options.
• To implement all database development enhancements to multiple SQL Server databases to ensure a flawless functioning of production environment.
• To perform installations & performance tuning, manage capacity planning & user accounts, and implement database security for multiple instances of development, certification, QA, and production SQL Servers databases.

Confidential, Irvine, TX

SQL Server DBA

Responsibilities:

• Involved in designing of Conceptual Logical Model and Physical Model
• Design/Build Extract Transform Load procedures in SQL Server 2000 using DTS packages to import/export data feeds to/from data warehouse and claim systems
• Maintain Operators, Categories, Alerts, Notifications, Jobs, Job Steps and Schedules. Monitor connections, locks and performance of SQL server.
• Created SSIS packages to export data from Oracle to SQL Server Database.
• Performance: Analyzed database performance with SQL Profiler and Optimized indexes to significantly improve queries.
• Supported clustering and replication for servers.
• Generated database SQL scripts and deployed databases including installation and configuration
• Responsible for tier 2 support for more than 10 SQL Servers in a 24x7 mission-critical/production environment.
• Worked on CDC(Change Data Capture)
• Maintained cluster servers to provide high availability.
• Design/Build Extract Transform Load procedures in SQL Server 2000 using DTS packages to import/export data feeds to/from data warehouse and claim systems
• Used ER/Studio to reverse engineer legacy database from Sybase to SQL Server.
• Created and tuned stored procedures, triggers and tables.
• Created several materialized views and UDF’s to be accessed by teh new front end applications.
• Managed Materialized and Partitioned views for better performance.
• Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance teh performance of databases
• Used SQL Profiler for troubleshooting, monitoring, optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA
• Provide 24 X 7 supports to all production, development, staging and clustered servers.
• Configured two Active/Passive Clustering setups for failover on production servers. dis included installing windows cluster service and SQL 2000 on windows 2003 enterprise edition.

Environment: SQL Server 2000/2005, T-SQL, CVS, Windows NT/2000/XP/2003, VMWARE

Confidential

SQL Server DEVELOPER /DBA

Environment: SQL Server 2005/2008, T-SQL, Windows 2003/2008, IIS 6.0/7.0,HYPER-V, SCVMM

Responsibilities:

• Installed SQL server 2005 on windows 2008 Enterprise Edition advanced servers, applied service packs and security fixes.
• Migrating from SQL server 2005 to SQL server 2008 and redirecting users to migrated server.
• Changes in schema and stored procedures according to changes made in application.
• Maintain Operators, Categories, Alerts, Notifications, Jobs, Job Steps and Schedules. Monitor connections, locks and performance of SQL server.
• Responsible for creating Virtual machines by using HYPER-V Manager and SCVMM tools
• Worked with SCOM team to implement monitoring criteria for IIS and SQL servers
• Responsible for Hosting WCF web services on IIS and good experience configuring IIS security for both web applications and web services.
• Responsible for Application pools creations according application security and performance needs.
• Responsible for Query optimization and Performance tuning, tuned SQL queries using Show Plans and Execution Plans.
• Created checklists to install SQL Server installation, service packs, security fix and MS SQL cluster installation.
• Implemented and Scheduled different Database Backup strategies like Full, Differential and Transactional log backup
• Implemented SQL Server high availability solutions including clustering, replication and log shipping.
• Has good experience in installing and configuring SSL certification for security reasons.
• Writing scripts to automate SQL tasks using power shell.
• Worked with Application Developers to design databases and tables to support Development activities and achieve optimal efficiency.
• Creating and Modifying Tables, Stored Procedures, Views, Indexes, User-defined Functions, and Triggers etc as required.
• Tuning Queries and Database performance using tools SQL Server Tuning Advisor, SQL Server Profiler.
• Design and implement Backups and Restore database policies.
• Preparing teh golden bits and scripts for smooth deployments to production using applications like Octopus and Sequence manager.
• Install, configure and maintain systems running Windows server 2003/2008 & IIS 6.0/7.0 and participate in server upgrade and planning.
• Good experience in generating reports using SSRS services.
• Involved in deploying and managing websites on IIS servers in both Preview and Production environments.
• Capacity Planning, Storage Planning, Hardware Upgrade’s and Preparing Estimates for Database, table size growth.
• Preparing RCA’s/Postmortem for high Severity tickets/issues.
• Performance monitoring, remote administration, Web application management, automation for Internet facing applications.
• Work on monitoring solutions using Microsoft System Center Operations Manager SCOM and Site Scope.
• Install security patches, IPAK’s, perform Service account password reset, SSL Certificate renewal and other regular maintenance work. Build operations documentation and update out of date or incorrect information.
• Provided 24/7 supports to all production, development, staging and clustered servers.