SUMMARY

• Over 7 years of experience in design, development, administration and support of 32 - bit, 64-bit MS SQL Servers 2012, 2008r2, 2008, 2005, 2000 on various business domains like Financial, Sales, and Pharmacy.
• Experienced in installing MS SQL Servers 2012, 2008r2, 2008, 2005, 2000 and updating them with hot fix and Service Packs on both Cluster and Stand-alone Environment.
• Expertise experience on Installing and configuring Active/Passive clusters on SQL Server versions.
• Experienced in implementing In-place and Side by Side Migration of MS SQL SERVER 2000/2005 to 2008.
• Proficiency in Database administration activities for Database Security like creating logins, users, roles, and giving permission to them.
• Proficiency and expertise in SQL Server Replication, Backup/Recovery by making use of SQL Profiler.
• Expert in SQL Server database Performance Tuning, Query Optimization, Client/Server connectivity, DB consistency checks using DBCC.
• Expert in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services ( SSIS ), Log Shipping, DTS, Bulk Insert and BCP.
• Experienced in writing and debugging Stored procedures, triggers and Functions.
• Experienced in administering 100+ servers with zero downtime and supporting Very Large Databases (VLDB) nearly 1.5 TB Database.
• Experienced in writing and executing upgrade scripts for making change in production server.
• Expertise in applying the indexes such as Clustered, Non-clustered and covering index on data structure to enhance data retrieval.
• Experienced in Data Modeling using Erwin, Rational Rose (UML) and MS-Visio to create logical and physical data models; use case diagrams and data flow diagrams respectively.
• Expertise in creating OLAP cubes using SSAS for data mining and created reports from the OLAP cubes using SSRS.
• Proficient in developing SQL Server Reports, taking care of sub-reports and writing queries to do operations like roll-up and drill down in SSRS.
• Experienced in creating interactive reports using Crystal Reports and SQL Server Reporting Services (SSRS).
• Excellent knowledge of DDL and DML in T-SQL.
• Worked with a team of Business Analysts, Project Managers, Data Architects, Application Developers, ETL Developers and Testing Team.
• Can Provide 24x7 Mail and On Call support to clients in DEV, QA and PROD Environments.

TECHNICAL SKILLS

Programming Languages: T-SQL, PL/SQL, C, C++, Java, ASP .NET, VB .NET.

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

SQL Server Tools: SSMS, Profiler, DTS (Import & Export), Query Analyzer, ETL, SSIS.

DML Tools: Erwin, MS visio, Rational Rose.

Operating System: Windows 98/2000/2003/ XP/Professional/NT/Vista, Linux.

IDE & BI Tools: SQL Server BI Development Studio (BIDS), MS Visual Studio 2008/2005.

Web Technologies: XML, HTML.

PROFESSIONAL EXPERIENCE

Confidential, San Antonio, TX

Sr SQL Server DBA

Responsibilities:

• As a Production support DBA responsible for managing production, development and QA environments.
• Managed Production environments and participated in on call 24/7 support
• Installed SQL Server 2008 R2/2008 and SQL Server 2005 on windows 2008 and 2003servers, applied service packs and security fix for all servers.
• Involved in Database security including creation of roles/login/user accounts and having good Knowledge of authentication modes, types of roles, how to manage security accounts, grant /revoke permission to access data.
• Implemented SQL Failover clustering for ACTIVE/ACTIVE and Active/Passive SQL Server 64 bit/32 bits environment and SQL Server 2005/2008
• Implemented Database Mirroring on SQL Server 2008 environments and experience in configured and maintained Log shipping on primary and secondary server with or without witness server on MS SQL 2005/2008.
• Extensively used SQL PROFILER and QUERY TUNING Wizard to troubleshoot problems and queries
• Involved in tuning SQL Server databases using available tuning methods like index tuning wizards, profiler and execution plans.
• Worked in troubleshooting production servers and fixed the user and application issues.

Environment: MS SQL Server 2008 R 2/2008/2005/2000 , Windows Server 2008 R2/2003/2000, Virtualization, SSIS, SSRS, SSAS, Clustering, Mirroring, Log Shipping, Replication.

Confidential, NY

MS SQL Server DBA

Responsibilities:

• Built & Administrated SQL Server 2005/2008Active Active clustered environment.
• Configured & Managed Mirroring, Log Shipping & Replication in Production & Stage Environment.
• Worked With 2008R2 Parallel Data warehouse Edition in handling extremely large amount of data. This is used to spread large tables into over multiple nodes.
• Experience with 2012 features like Always on Availability Groups, Windows Server Core Support &User-Defined Server Roles.
• Expert In 2008R2 Power pivot an end user tool that works in conjunction with share point, Sql Server 2008R2, and Excel 2010 to process large amount of data within Seconds.
• Expert in sizing and utilizing the Temp database in an efficient way.
• Daily routine Developer/DBA tasks like handling user’s permissions and space issues on Production and Staging Servers and handling Maintenance Jobs.
• Expertise in Table Portioning & Data Compression.
• Experience in using Data driven Subscription to prevent unforeseen circumstances.
• Monitoring SQL server performance using profiler to find the performance and dead locks.
• Worked On Call 24/7 Support on weekly basis.

Environment: MS SQL SERVER 2000/2005/2008/2008 R2/2012,SSIS,SSRS, VISUAL STUDIO 2008, VB.NET,C#,WINOWS SERVER 2008,IIS,TFS.

Confidential, San Francisco, CA

MS SQL Server DBA

Responsibilities:

• Implemented SIDE BY SIDE Migration of MS SQL SERVER 2000 to 2008/2008 R2 on Windows
• Applied Patches and Service packs to update different versions of MS SQL SERVER.
• Fixed the failed PRINCIPALS (logins),user permissions and security in ACTIVE DIRECTORY and SQL SERVER LEVEL.
• Implemented native log shipping on MS SQL SERVER 2005
• Scheduled regular BACKUP JOBS and kept track of DATABASE by receiving the emails on Alerts.
• Implemented DATABASE MIRRORING ON MS SQL SERVER 2005/2008
• Moved files between the File Groups and partitioned the tables to improve the performance.
• Refactored and fine tuned the queries and stored procedures in Tsql.
• Implemented log shipping for Production server data base as part of the Disaster Recovery.
• Rebuilding indexes with different fill factors and update statistics manually.
• Implemented Database Mirroring for HIGH AVALIBLITY of the Production Server.
• Developed & Deployed reports in SSRS using BIDS (Business Intelligence Development Studio).

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

Confidential, New York, NY

Database Administrator

Responsibilities:

• Installation, configuration and upgrading of MS SQL server 2000/ 2005.
• Plan, Configure and maintain, DTS/SSIS, Transactional Replication and Log Shipping.
• Configure database maintenance plans for backup and database optimization.
• Establish and maintain various backup and recovery policies and procedures.
• Implement and maintain database security (create and maintain users and roles, assign privileges).
• Perform database tuning and performance monitoring.
• Incorporate performance measurement by using tools like SQL Analyzer along with T- SQL and NT Performance Monitor.
• Development of T- SQL objects and writing Stored Procedures, Triggers, Views, Functions, Indexes, Constraints, Queries, Distributed Queries.
• Windows system administration on 1st level win2k3 server, user objects in Active directory and terminal services.
• Deploying Clustering in Microsoft cluster server 2003
• Worked with Oracle RAC team to understand cross platform complexities to migrate data for a new application using SQL server 2005 clustered servers.

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

Confidential

Jr.SQL Server DBA

Responsibilities:

• Created new tables, written stored procedures for Application Developers and some user defined functions.
• Created SQL scripts for tuning and scheduling.
• Performed data conversions from flat files into a normalized database structure.
• Created and managed users, roles and groups and handled database security.
• Created Triggers to enforce data and referential integrity.
• Performed development support, document reviews, test plan, integration of the system.
• Creation/ Maintenance of Indexes for fast and efficient reporting process.
• Analyzing the Database Growth and Space Requirement. Handling Users/Logins/User Rights
• Creation/Deletion of Linked Servers.

Environment: Windows 98,2000, server2003, SQL server, T-SQL, Query Analyzer, Data Transformation Service.