SUMMARY

• Around 5 years of experience in Database Administration, Development and Design Extensive experience wif SQL Server 2016/2014/ 2012/2008/2008 r 2/2005/2000.
• Experience in managing Windows 2000/2003/2008 servers in a clustered environment.
• 5+ Years’ experience in upgrading and Migration to SQL Server 2012/2014.
• 5+ Years’ experience in Clustering (Active/Active, Active/Passive)
• 4+ Years’ experience in Setting up Always ON availability groups
• 5+ Years’ experience in Mirroring, Log Shipping and Replication
• Handled multiple SQL Instances on Cluster environment and worked on configuring logical disks and RAID levels.
• Experience in Replication - Snapshot and Transactional and extensive knowledge in Merge replication.
• Extensively worked on 32 bit, 64 bit and i64 clustered and standalone server environments.
• Experience in Filtered Indexes and Data Compressions for Performance and Optimum space utilization in SQL Server 2008 R2
• Identifying teh bottle necks using SQL Server Profiler and Perfmon.
• Experience in performing Online Indexing. Experience wif monitoring, troubleshooting related issues.
• Experience in migrating sysbase, oracle and salesforce databases to SQL server Databases.
• Experience in Backup tools like SQL Safe and LITE SPEED for fast and efficient database backups.
• Expertise in SQL Server 2005 Reporting Services (SSRS) and SQL Server 2005 Integration Services (SSIS) in Business Intelligence.
• Proficient wif SQL Server Analysis Services. (SSAS)
• Extensively worked on RDBMS concepts to design Relational Database model
• Extensively worked on VMware and Implemented SQL Server 2005/2008/2008 R2.
• Rebuilding teh indexes at regular intervals for better performance.
• Truncated teh tables of size 3TB for teh replication purpose.
• Involved in Monitoring and troubleshooting replication issues.
• Configured Server Memory for maximum Performance and effective utilization.

TECHNICAL SKILLS

RDMS: MS SQL Server 2014/2008/2005 , Oracle 10g & 11g, IBM DB2, MS Access

SQL Server Tools: SQL Server Management Studio, Business Intelligence Developer Studio, Profiler, Query Analyzer, Export & Import, SSIS, SSRS, SSAS

Languages: SQL, T-SQL, PL/SQL, .NET, C#

Data Access Technologies: ODBC, JDBS, JSP

Operating Sys/tem: Windows Server 2000/2003/2012 , Windows NT 4.0 Windows XP/98/95, Windows Vista Business/Ultimate, Windows 7 Ultimate, Linux.

Office Tools: MS Office 2000/XP

Data Modeling Tools: Erwin, Enterprise Architect

Version Controls: TFS 2008, PVCS

PROFESSIONAL EXPERIENCE

Confidential, CA

MS SQL Developer/DBA

Responsibilities:

• Installed and Configured SQL Server 2014, 2012 and 2008r2 in enterprise cluster and standalone environments.
• Maintained High Availability by designing proper backup strategy.
• Prepare systems for disaster recovery and high availability using log shipping and SQL clustering
• Improve database performance by examining long running SQL queries and creating appropriate indexes on teh tables.
• Implemented regular patch management on various production, development and test SQL 2008/2008 R2 servers along wif applying teh latest service packs in both stand alone and clustered environment.
• Migrating legacy database systems from SQL 2000, 2005, 2008 version to higher versions of SQL server which include SQL 2008R2, 2012 and 2014.
• Understanding AD groups in teh new server, creating new logins wif proper privileges.
• Checking error logs, SQL logs and fixing teh issues to validate and to let them go live.
• Refreshing databases of 300 GB - 1.5 TB size and configuring replication, creating local publications and subscriptions to replicate data between prod and DR server for few applications.
• Partitioning large tables wif over billion rows to effectively archive teh aged data in different environments including replication environments.
• Create a disaster recovery strategy for teh mission critical databases using SQL Log shipping to a different data centre in other states and perform a yearly disaster recovery test
• Installed SQL 2012 AlwaysOn Availability groups in production server systems for DR and High availability
• Improve database performance by examining long running SQL queries and creating appropriate indexes on teh tables
• Use extended events functionality to monitor dead lock events.
• Tuning Queries and Database performance using tools SQL Server Tuning Advisor, SQL Server Profiler.
• Design and implement Backups and Restore database policies.
• Experience wif Point-in-Time Recovery of backups (Full, differential and Logs).
• Managing security roles in SQL Suite.
• Scheduling and Maintaining FULL, DIFF, and LOG database backups as per teh company strategy to meet teh recovery point objectives

Environment: Windows 2003/2008/2008 R2/2012, MS SQL Server 2008/2008 R2/2012/2014, Microsoft.NET, SSRS, SSAS, SSIS, MS Visual Studio 6.0, VSS, TFS.

Confidential, SanMacros, CA

SQL Server DBA

Responsibilities:

• Installed and worked on installing SQL 2012\2014 SQL servers.
• Experience in implementing High availability solutions like different Replication models (Snapshot and Transactional), Log shipping, clustering and mirroring on physical and virtual machines
• Performed teh database full and differential backup’ for database size more TEMPthan 7TB.
• Migrated teh SQL jobs, SQL logins using teh SQL server data tools and SSIS packages.
• Manually configured teh 3 PAR SAN, Power Vault (MD3220), Local disks for teh cluster servers.
• Configured teh Mirroring between teh required databases wif and wifout witness server.
• Configured teh required end points for teh mirroring.
• Configured teh log shipping between teh databases.
• Creating SQL Server Logins and assigning Roles and Autantication Modes as a part of Security Policies for various categories of User Support.
• Developed ETL Packages and deployed them
• Configured Database Mail for SQL Servers for teh Positive Mail Notification.
• Created Maintenance Plans dat halped in effective disk utilization and index maintenance.
• Worked extensively on SQL Server Transactional Replication wif sync type as automatic and none.
• Extensively worked on snapshot replication. Used to create teh tables manually and tan use teh snapshot replication for dumping teh data.
• Configured Server Memory for maximum Performance and effective utilization.
• Involved in adding teh subscribers to teh exiting live publishers and running teh snapshots.
• Dropped all teh publishers and subscribers on teh retired servers.
• Created Maintenance Plans for scheduling teh full, diff and T-Log Backup’s.
• Effectively managed disk space using LITE SPEED for Data Base Backups
• Extensively worked on 24 X 7 Production Database on Call Support and involved in troubleshooting SQL Server issues in various levels

Environment: Windows 2003/2008/2008 R2/2012, MS SQL Server 2008/2008 R2/2012/2014, Microsoft.NET, SSRS, SSAS, SSIS, MS Visual Studio 6.0, VSS, TFS.

Confidential, Racine, WI

Lead SQL DBA

Responsibilities:

• Manage teh SQL Server data systems architecture, including production OLTP/OLAP systems, reporting servers and data warehouses.
• Automation and standardization of SQL Server environment to operationalize repetitive tasks.
• Install and configured SQL Server 2008 R2/2012on Windows Server 2008 R2 enterprise server in standalone, and extended 5 node Active/Active/Active/Active/Passive cluster environment.
• Implement SQL Transactional and Snapshot replication for teh client databases every quarter and provide support for issues dat arise wif transactional and snapshot replication.
• Assist teh team of developers wif best development practices in Development, Test and production environments.
• Analyze and tune SQL Server for various workloads including tuning Transact-SQL code, creating Indexes, SQL Server configurations changes, and operating systems for optimal performance.
• Apply Windows WSUS and SQL server patches every quarter wif suitable planning and documentation.
• Install and configured third party tools like Disk keeper, Idera SQL Diagnostic manager, and Red gate tools to monitor teh SQL server regularly.
• Monitor teh SQL servers for space regularly and perform capacity planning every quarter for new client databases.

Environment: MS SQL Server 2000/ 2005/2008/2008 R2/2012 Windows 2000/2003/2008 , IIS 6.0, Backup, T-SQL, VB.NET, Lite speed, and SQL Job Manager.

Confidential, Deerfield, IL

Jr SQL DBA

Responsibilities:

• Installed and configured SQL Server 2008/2008 R2 Enterprise 64 Bit on Windows Server 2008 enterprise server in Active/Passive cluster environment.
• Design fast, reliable, replication solutions like Peer-to-Peer and transactional replication in a 3-node topology for Test and Production Environment.
• Prepare systems for disaster recovery and high availability using log shipping and Microsoft and SQL clustering.
• Improve database performance by examining long running SQL queries and creating appropriate indexes on teh tables.
• Implemented regular patch management on various production, development and test SQL 2008/2008 R2 servers along wif applying teh latest service packs in both stand alone and clustered environment.
• Has done teh capacity planning and provided teh Database disk space requirement and lay out to teh Engineers to build teh servers.
• Responsible for database design, creation of database device, databases, logical and physical design of teh database.
• Done range data partitioning for large tables to improve teh performance. Designed teh database wif multiple file groups and files laid out across multiple drives.
• Monitor replication tuned teh performance of replication if their were issues wif latency and created alerting mechanism for any failures.
• Monitor log shipping and fix teh issue wif performance and log restores.
• Monitor teh IO activity on all teh databases and re-architect them on different RAID’s based on teh performance metric data.
• Involved in backup and restoration, performance and tuning at teh architecture level, query level.
• Export and import data from text files and Excel to SQL Server database using bulk insert and BCP utility.
• Created and managed user security and logins and granting rights and revoking privileges.
• Responsible for tuning Views, Stored Procedures and queries written by teh Application Consultants. Assisted them in writing teh proper code for better performance from teh application.
• Automated and enhanced daily administrative tasks, including space management and backups using Tivoli storage manager and red gate back up tools.
• Created Reports using teh SSRS and involved in Authoring, Managing Reporting services.
• Provide monthly rotational on call support to address production issues during off hours

Environment: MS SQL Server 2000/2005/2008/ , Windows 2000/2003/2008 , IIS 6.0, Backup, TSQL,VB.NET, Lite speed, and SQL Job Manager, TFS, SSIS, SSRS & SSAS