PROFESSIONAL SUMMARY:

• Over 7 years of IT Experience in SQL Server database admin, System Analysis, Design and Development and Support of Microsoft SQL Server R in Development, Test and Production Environments on various business domains like Financial, Insurance and Manufacturing.
• Expertise in core DBA tasks like Installation, Maintenance, Configuration, Backup & Restore, DR, Database Security and, Database designing.
• Extensive experience in managing MS SQL Server on Windows 2003 and 2008 Servers.
• Used DMVs, DMFs and Extended Events to monitoring and troubleshooting performance issues.
• Implemented Database Mirroring configuration with Witness server to provide automatic failover.
• Expert in designing and implementing Backup and Recovery Strategies
• Implemented different types of Replication models like Transactional and Snapshot.
• Expertise in upgrading (In - place Upgrades) and migrating databases from MS SQL Server and SQL Server R2/2012.
• Designed DR plans while satisfying SLA requirements and conducted DR tests.
• Worked in production support role to provide 24/7 on-call support.
• Implemented Database Mirroring for database high availability.
• Hands on Experience in installing and configuring Active/Passive Cluster on SQL 2005/2008 R2 / 2012.
• Worked with tools like SQL Profiler, Windows Perfmon and Performance counters for Monitoring and Tuning MS SQL Server Performance.
• Experienced in developing stored procedures, functions, triggers using T-SQL
• Very good experience in using Quest Lite Speed and Idera SQLSafe to backup and restore the SQL databases.
• Expertise in Migrating SQL Server data bases into SQL Server and also expert in migrating DTS packages to SSIS Packages.
• Experience in implementing different types DR (disaster recovery) scenarios like Replication models like Snapshot, transactional, log shipping and Configure Database Mirroring in Cluster environment.
• Setting up and Monitoredtransactional replication, Database mirroring on Production and QA servers.
• Configured the servers on 32 bit and 64 bit clustered and standalone server environments.
• Have good understanding of SQL Server Active/Passive, Active/Active Clustering.
• Experience in supporting Very Large Database (VLDB) more than 2TB and troubleshooting problems
• Expertise in Database Backup and Recovery procedures by using native and litespeed to/from Disk /Legato server (Tape).
• Extensively used tools like SQL Profiler, Index Tuning Wizard, and Windows Performance Monitor for monitoring and tuning MS SQL Server performance.
• Experience in using Performance Monitor/Profiler to resolve Dead locks/Long running queries. And also good experience in data (table) partitioning.
• Good experience with implementing reporting solutions using transactional replication.
• Experience in data modeling like physical data modeling and logical data modeling by using Erwin tool.
• Expertise in writing Stored Procedures, Functions and Triggers using T-SQL and also expert in tuning Complex Queries.
• Good experience on physical storage configuration and optimization of SAN/NAS/DASD with different RAID levels.
• Hands on experience in reviewing the work orders by check-in/check-out using Team Foundation Server.
• Flexible and enthusiastic team player with excellent communication and leadership skills.
• Experience in connecting and importing data from MySQL to SQL Server.
• Implemented proactive monitoring scripts for production databases.
• Experience with multi server administration.
• Worked on BMC Remedy and Confidential RMS ticketing system software’s to track if any problem occurs in the environment.
• Experience in configuring transactional Replication from multiple subscribers for reporting purpose.
• Implemented log shipping technology on standalone servers for getting reports on SQL Server 2005 and 2008 R2 / 2012
• Strong Technical background with excellent problem solving and communication skills. Strong time management skills and excellent team player with reputation of integrity and an ability to work on multiple technologies.
• Experienced in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using DBCC Utilities and DMV’s and DMF’s, Re-indexing, Updating Statistics and online indexing.
• Created linked servers between SQL Server R2 & Oracle 9i & 10g.
• Extensively worked on Data and Backup compression in SQL Server 2008 R2 / 2012.
• Expertise in performing data transformations between servers using BCP, DTS, SSIS and bulk insert. And also.
• 24 X 7 Production Database on Call Support.
• Strong Technical background with excellent problem solving and communication skills. Strong time management skills and excellent team player with reputation of integrity and an ability to work on multiple technologies

TECHNICAL SKILLS:

RDBMS: MS SQL Server 2008R 2/2005/2000/7.0 , Oracle 10g/9i, Sybase 12.0, MySQL 4.1, And MS Access 2010/2007/2003.

Languages: T-SQL, C, SQL, PL/SQLWeb Technologies: ASP.Net, VB.Net, CSS, XML, HTML.

GUI & Tools: VB 6.0.

Web servers: IIS, BEA WebLogic and IBM WebSphere.

Operating systems: Windows Server 2012/2008 R2/2005, Windows Server 2003 EE, Windows 2000 Server/Advanced Server and Windows Vista/XP/NT/2000

Data modeling tools: Erwin, MS Visio.

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

Version control: MS Team Foundation Server (TFS), VSS, CVS, PVCS, ClearCase

Reporting tools: Business Objects/Crystal Reports, SSRS (Report Builder)

Data migration: DTS, SSIS, BCP, SQL Loader, Import/Export Wizard.

PROFESSIONAL EXPERIENCE:

Confidential, Houston, TX

Sr. SQL Server DBA

Responsibilities:

• Installing and maintaining SQL Server database systems. Maintaining the database systems includes but is not limited to ensuring successful backups, resolving system issues, opening cases with technical support to resolve issues, monitoring success and failure of automated jobs, monitor system availability, updating system documentation, system and database recovery, etc.
• Coordinating with the Systems Administration team, install and maintain Boardwalk approved application software and systems that integrate with Boardwalk’s database systems.
• Updating database systems by reviewing, planning, testing and installing database security patches and service packs.
• Design, document, and promote security "best practices", policies, standards and protocols.
• Migrating application code and objects from development/test environments to production.
• Working with development and systems teams to perform application and database tuning.
• In conjunction with development teams, define and maintain database and code standards and naming conventions for the organization to ensure consistency in database and code development.
• Migrating Databases from SQL Server 2005 to SQL Server 2008 R2/2012
• Setup and maintenance of appropriate database and application monitoring.
• Setup, test and maintain business continuity/disaster recovery infrastructure database and applications.
• Providing highly available database and application infrastructure according to Business Continuity requirements using SQL clustering, load-balancing, etc.
• Evaluating data modeling, database administration, and database backup and recovery tools and make recommendations.
• Setting up and Monitoredtransactional replication, Database mirroring on Production and QA servers.
• Responsible to Monitor and troubleshooting Log Shipping.
• Review of physical and logical database design; Promote the reliability of database design by ensuring appropriate referential data integrity is implemented and appropriate data types are used.
• Create processes and procedures for application code and database object migrations to support an efficient and reliable system development lifecycle.
• Created new database objects like Tables, Procedures, Functions, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2012.
• Worked in Active Active, Active Passive Cluster environment as a High availability solution.
• Failover cluster testing and resolution on Confidential servers as well as monitoring and backup reporting setup with Microsoft Operations Manager and backup teams.
• Tuning queries which are running slow using Profiler and Statistics Io by using different Methods in terms of evaluating joins, indexes, updating Statistics and code modifications.
• Created complex stored Procedures, Triggers, Cursors, Tables and other SQL Joins and Statements for Applications by using T-SQL.
• Checking Database Health by using DBCC Commands and DMVS
• Monitored and modified Performance using execution plans and Index tuning.
• Prepared Documentation for the Disaster Recovery plan
• Daily routine DBA tasks like handling user’s permissions and space issues on Production and Semi-Production Servers and handling maintenance Jobs.
• Handled monthly Database Refresh in QA-Test environment for testing of new Deployments and Build.
• Responsible routine DBA jobs like Backups and Restores.
• Good experience in data modeling and metadata services.

Environment: MS SQL Server 2012/2008R2/2005/2000,T-SQL,SSIS,SSRS,ReportBuilder,Lite Speed, BCP, SQL Profiler, Replication, Log shipping, Mirroring, Clustering, Windows Server 2003/2008/2012.

Confidential, Tampa, FL

Sr.SQL Server DBA

Responsibilities:

• Upgraded SQL 2005 Server to SQL 2008R2/2012 (In place and Side-by-Side) server for high volume processing databases.
• Worked closely with application team, manager and other DBA’s for planning and implementation of the migration.
• Design and Implemented Disaster Recovery Procedures.
• Implemented High Performance Database mirroring on medium scale SQL2008R2/2005 database servers.
• Performance Tuning and optimizing the code
• Configured Database Mail to send out notifications
• Installed and Configured 2- node High availability SQL Active/Passive clusters.
• Designed the best back up strategy on the mission critical running application on databases considering our business requirements
• Used Idera SQL Safe tool for compressing the backups in order to perform efficiently and reduce the space.
• Reviewing the Design Document provided by the onshore/offshore development teams for future enhancements upon the requirements.
• Performing Performance tuning using Data Tuning Advisor, SQL profiler and Windows Performance monitor.
• Maintain database including consistency checks, and index defragmentation using DBCC and DMV s respectively
• Configured Log Shipping for high availability on SQL 2005/2008 R2
• Responsible for applying service packs and hotfixes
• Deploying and promoting SSIS packages from TEST to Prod environment.
• Database refreshes from prod to test, stage and dev environments.
• Active involvement in installing and managing multiple 2 node failover cluster set up in active/passive environment as a High Availability mechanism.
• Successfully implemented database mirroring with high availability mode in SQL Server 2005/2008 R2.
• Implemented log shipping in SQL Server 2005/2008 R2 from primary server to standby server to support DR solution.
• Configured transactional Replication from multiple subscribers for reporting purpose.
• Involved in performance tuning, optimization of stored procedures and queries.
• Expert in working with change management and change control procedure.
• Create and maintain various databases for Production, Development and Testing using SQL Server 2005/2008 R2. Planning the location of data, index, and Transaction log files on the disk.
• Solved issues related to server performance and disk space
• Monitoring and troubleshooting performance during peak periods with concurrent connections.
• Support Development team in deploying and testing the application.
• Experience in contacting Microsoft and other vendors for product and technical support.
• Providing 24*7 supports to SQL application developers in implementing the applications on production server.
• Conducted root cause analysis of application availability and narrow down to issues related to coding practices, database bottlenecks, or network latency.
• Creating users and assigning permissions.
• Used SQL Litespeed on Production servers to increase space and time efficiency.
• Used Idera SQLSafe tool for performance monitoring, backup and recovery, security, auditing and PowerShell scripting
• Created Linked Servers to move data from one server to another
• Proactive monitoring for 24*7 servers.
• Worked on ETL using SQL Server Integration Services (SSIS) to send different kind of packages.

Environment: MS SQL Server 2008 R2/ 2005, ANSI SQL, SSAS, SSIS, BO XI, Informatica, MS SQL Server Reporting Services 2008/2005 (SSRS), COGNOS, DDL, Erwin, SharePoint Moss Server, ASP.Net, ETL, Erwin, C#.Net, SAP, CSS, Java Script, XML, HTML.

Confidential, Tampa, FL

SQL Server DBA

Responsibilities:

• Support 40 Production cluster/standalone server‘s across the PWC Tacoma and Envoy apps.
• Set up Backup Strategy for SQL Databases across Multiple Servers using Tivoli and SQL Native.
• Restored Databases when needed in DR, QA and Test environments and mask the sensitive data.
• Responsible for setting up Test, Dev and QA database environment.
• Involved in Capacity Planning for existing and new database servers.
• Responsible for installation of standalone/clustered SQL Server 2008R2 and configure it on 64-bit servers.
• Analyzed systems requirement and accordingly designed and implemented database systems.
• Involved in migration of SQL Server 2000/2005 databases to SQL Server 2008.
• Worked extensively on writing SQL Queries to retrieve and massage data for business rules implementation.
• Performance and Tuning on MS SQL Server. (Optimization of Queries and Server itself)
• Created tables, stored procedures, triggers, user defined functions, format files and other database objects.
• Created cubes and developed dynamic reports using SSAS and SSRS for higher management.
• Experience in configuration of report server and report manager scheduling, give permissions to different level of users in SQL Server Reporting Services (SSRS).
• Experience in generating on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services (SSRS).
• Worked with MSSCOM team to setup alerts for SQL Server Services.
• Written SSIS packages for business rules implementations and data transformation.
• Worked on troubleshooting some of the slow running queries using SQL Server Wait Types, DMVs and SQL Profiler.
• Set up Partitioned Tables and Indexes for Parallel Processing of queries using SQL Server 2008 Partition functions and schemes.
• Involved in defining staging area Metadata, Data Mart, defining & populating the Enterprise Model warehouse, Incremental Data loading.
• Set up monitoring scripts for SQL Server jobs and resources.
• Used configuration files in SSIS to ease the process of moving the packages across servers (development to production).
• Designed and developed tabular reports with drill down, drill through and drop down menu option using SSRS.
• Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories and regions based on business needs using SQL Server Reporting services (SSRS).
• Tested applications for performance, data integrity, validation issues, job scheduling and alerts.
• Experience in working with SSAS in creating cubes, data source views, named queries, dimensions and deploying of analysis services projects
• Implemented Change Controls in Production Environment using VSS.
• Set up Transactional Replication for few of the objects in Production environment.

Environment: MS SQL Server 2005/2008, T-SQL, SSIS,SSAS, SSRS, Business Intelligence Development studio, Erwin, Windows 2003, Visual Studio

Confidential, Chicago, IL

MS SQL Server DBA/ Developer

Responsibilities:

• Responsible for SQL Server 2005 database support, troubleshooting, planning and migration.
• Responsible for installation, configuration and troubleshooting the active batch jobs on windows environment.
• Responsible for review, test and apply all database changes to all environments including QA, Development and Production Servers.
• Monitor SQL Error Logs, Schedule Tasks, database activity, eliminate Blocking & deadlocks, user counts and connections/locks etc.
• Worked with SQL server Profiler to generate traces.
• Monitored the database and alerts from fog light application and also performance monitor for the performance.
• Migrated DTS packages from SQL Server 2000 to SQL Server 2005 as SSIS packages.
• Creating and managing schema objects such as tables, views, clusters, indexes, procedures, triggers & maintaining Referential Integrity..
• Monitoring MS SQL Server performance and network issues.
• Responsible for 24x7 dedicated support including production, test and development servers.

Environment: Windows NT, Windows 2003, SQL Server 2005, DTS, SSIS, T-SQL, XML, MS SQL Reporting Services.

Confidential

SQL Server Developer

Responsibilities:

• Installation, Configuration and Maintenance of MS SQL Server 2000.
• Gathered functional requirements and written the technical specifications.
• Designed logical / physical data models and defined primary key, foreign key using Erwin tool.
• Wrote T-SQL statements using DML and DDL for retrieval of the data.
• Created complex stored procedures, triggers and cursors in SQL Server.
• Extensively Involved in Designing (Logical and Physical) of Databases.
• Created and modified stored-procedures, triggers, cursors.
• Created DTS package to export and import data from SQL Server to Access, text and EXCEL files.
• Checked Performance Tuning, Indexing, Query Optimization.
• Used database consistency checks (DBCC Utilities).
• Created Databases, Tables, Views and Indexes.
• Good exposure in running jobs in Enterprise Manager using job-scheduling tool.
• Performed Database Backup and recovery strategies.

Environment: MS SQL Server 2000, MS Access, Erwin 4.1, DTS, SQL Profiler, Query Analyzer, MS SQL Server 7.0/6.5, T-SQL, windows 2000