OBJECTIVE

An effective communicator with exceptional relationship management skills and the ability to relate to people at any level of business/management , along with significant experience working with steering committees. A team leader with abilities in performance evaluations, team building, mentoring, hiring resources, performance, security and implementation with high demand forecasting.

SQL Server Versions:

SQL 2000

SQL 2005

SQL 2008

SQL 2008 R2 Ent

SQL 2012 Ent

SQL Server ADD-INS:

SQL Server SSRS setup ,configuration and tshooting

SQL Server SSIS basic

SQL Server SSAS basic

Tools:

Red Gate

Lite Speed

Quest Tools

Toad

Profiler

Trace

Spotlight

PROFESSIONAL EXPERIENCE

Confidential

Sr SQL Server DBA

• Expertise in MSSQL SERVER Database Administration.

• Set up and Manage Log Shipping,Mirroring, Replication.
• Created, administered and maintained SQL Server Databases Prod, Dev, UA Test and Staging Env.
• Suggested, developed and implemented Scaling out solution with Data partitioning.
• Managed security by defining roles and rights for Users, Applications, Groups and Reporting.
• Handled Fine Tuning of Operating Systems setting and configuration.
• Monitored the database server performance.
• Upgrade of Database from SQL Server 2000 to 2008 and 2005 to 2008 R2 Ent.
• Installed and configured database software, associated database tools and performance monitoring software such as Toad, Litespeed, etc.
• Monitored data activities i.e. database status, logs, space utilization,locks and long transactions .
• Suggested Application level tuning changes for code, queries, SQL objects, which may not be performing up to the optimum database performance standards.
• Adhered to Change Control Procedures in Agile and or Corp Database Policy.
• Developed and executed scripts and change requests in accordance with change control procedures.
• Provided overall configuration and change control management for data base components.
• Escalated database issues to appropriate Application Team Management, such as sql code in triggers, functions, stored procedures, views that perform below standards, database structure and design, and permissions.
• Performed database/infrastructure physical design, database upgrades and applied software patches to databases as per application/client requirements.
• Performed acceptance testing to verify that database changes perform without adverse consequences.
• Managed and Maintained disk storage requirements for database software, database files and database administration needs.
• Provided optimal database file layout for utilization of storage and performance for stabilization and performance.
• Participated in meetings impacting database physical design and performance .
• Developed and maintained scripts, utility jobs, or implemented needed software for database maintenance.
• Implemented and managed database clustering, failover and load balance technologies as per client / application requirements.
• Developed, tested and implemented a robust database backup and recovery strategy per SOP's.
• Performed Database refreshes and pre or post DB install activities e.g. data loads .
• Database recoveries as per SOP's.
• Conducted root cause and analysis for database incidents and problems.
• Participated in designing, testing and implementing an enterprise Disaster Recovery Plan.
• Conducted research and collaborated with vendor if necessary for additional patches.
• Provided stopgap solutions if possible and acceptable by business and application team owners.
• Researched, reviewed and recommended measures for preventive maintenance.
• Set up security and access profiles and procedures for database system administrators.
• Complied with standard security-related procedures that are based on established best practices and conformity to company policy and adjusted to accommodate Client Security Policy based on mutual agreement.
• Interfaced with database vendors and client technical support teams to isolate and resolve database related problems.
• Implemented MS SQL Cluster Active/Passive and Active/Active , Multi Node Cluster, up to 8 Node.
• Handled Logical Data and Index partitioning for large tables in SQL Server 2005 and 2008.
• Provided and managed support in SQL Environment of more than 60 Instances and 200 DB's .
• Proven ability to handle Large Databases of more than up to 1 TB in Size

Confidential

SQL Data Analyst Sr SQL DBA

• Expertise in MSSQL SERVER Database Administration.
• Set up Log Shipping, MSSQL Mail, SMTP

• Created, administered and maintained SQL Server Databases Production, Development, Test and Staging Env. for various groups such as Developer, QA, DA, Users, etc, and ensured the Availability of the Database Server in a 24X7 Environment.
• Scanned the data pages, Indexes and checked the storage space used by each table.
• Suggested, developed and implemented Scaling out solutions with Data partitioning.
• Managed security by defining roles and rights.
• Handled Fine Tuning the Operating System in-coordination with the Server and Network Administrator to utilize the maximum resources for Database and Applications.
• Monitored the database server performance and, if required, perform tuning of the TSQL queries, Stored procedures etc.
• Up gradation of Database from SQL Server 2000 to 2005 and 2008.
• Performed root cause and analysis for database incidents and problems.
• Participated in designing, testing and implementing an enterprise Disaster Recovery Plan.
• Conducted research and collaborated with vendor for additional patches when necessary.
• Provided stopgap solutions if possible and acceptable by business and application team owners.
• Interfaced with database vendors and client technical support teams to isolate and resolve database related problems.
• Implemented MS SQL Cluster Active/Passive and Active/Active , Multi Node Cluster up to 8 Node.

Confidential

SQL Server DBA Contract

• Managed 24 Physical and 29 Virtual VM Cluster Sql Servers
• 10 Reporting Services
• Created, administered and maintained SQL Server Databases Production, Development, Test and Staging Env. for various groups such as Developers, QA's, DA's, Users, etc, and ensured the Availability of the Database Server in a 24X7 Environment.

• Scanned the data pages, Indexes and checked the storage space used by each table.
• Suggested, developed and implemented Scaling out solutions with Data partitioning.
• Managed security by defining roles and rights.
• Handled Fine Tuning Operating System in-coordination with Server and Network Administrator to utilize the maximum resources for Database and Applications.
• Monitored the database server performance and, if required, performed tuning of the TSQL queries, Stored procedures etc.
• Up gradation of Database from SQL Server 2000 to 2005 and 2008.
• Installed and configured database software, associated database tools and performance monitoring software.
• Monitored data activities i.e. database status, logs, space utilization, extents, Checkpoints, locks and long transactions .
• Suggested Application level tuning changes for code, queries, SQL objects which may not be performing up to the optimum database performance standards.
• Adhered to Change Control Procedures.
• Developed and executed scripted changes requests in accordance with change control procedures.
• Provided overall configuration and change control management for data base components.
• Developed, tested and implemented a robust database backup and recovery strategy per SOP's.
• Performed Database refreshes pre or post DB install activities e.g. data loads .
• Database recoveries as per SOP's.
• Conducted root cause and analysis for database incidents and problems.
• Participated in designing, testing and implementing an enterprise Disaster Recovery Plan

Confidential

Sr. SQL Server DBA

• Involved in performance tuning, code optimization, development using BIDS.

• Conducted System Analysis, Design, Development and Implementation of various Applications and the subsequent transition to ERP and Web Enabled Application.
• Experience of Application Code Review.
• Performed all the Database related activities such as Database Backup, Restore Operations, Troubleshooting Issues, Performance Tuning, monitoring error logs, jobs etc.
• Involved in Logical Data and Index Partitioning using SQL Server 2005.
• Designed, implemented and maintained DTS Packages
• Handled data Migration from legacy systems as well other RDBMS such as Sybase and FoxPro.
• Involved in Fine Tuning the Procedures After studying the Processing time through SQL Trace.
• Modified and created Indexes, Optimizing Indexes.
• Migrated data from various sources such as MS Access, flat files etc.
• Configured Internet Information Services.
• Created, administered and maintained SQL Server Databases Production, Development, Test and Staging Env. for various groups such as Developer, QA, DA, User etc and ensured the Availability of the Database Server in a 24X7 Environment.

Confidential

Sr. SQL Server DBA

• Environment: Windows Server 2000/2003, SQL Server 2000/2005, .NET, Quest LiteSpeed 4.7, Idera SQLsafe, IBM, HP ProLiant, SAN, DMZ.
• Install and configure server software and hardware for SQL Server development and production environments.
• Create and manage database maintenance plans and design and implement backup and disaster recovery plans.
• Define and enforce database standards, policies, security and documentation.
• Prepare current database structure and configuration for high-performance through analysis and optimization.
• Diagnose problems using tools such as SQL Profiler and System Monitor, work with vendors and developers as needed to resolve issues. Monitor database systems performance, capacity and availability.
• Deploy, configure and monitor complex ETL/SSIS processes.
• Work on data mapping and conversion, manage disk space, change control and bug fixes. Environment: Windows Server 2000/2003, SQL Server 2000/2005, Red Gate for SQL Server, Hybrid SQL SPY, Idera SQL Diagnostic Manager, Idera SQLCheck.
• Manage over 80 SQL Server instances for a Fortune 500 corporate Customer Support, Sales Support and VP environment.
• Monitoring of databases, working to maximize availability and tune data performance as needed. Ensure that adequate backup procedures exist for all critical SQL Server instances.
• Apply latest OS and SQL Server service packs and hot-fixes to ensure maximum security. Worked on building the first data warehousing system utilizing SQL Server 2005.
• Designed and configured a SQL Server 2005 cluster system to be used by an internal trouble ticket tracking application HEAT by more than 300 users.
• Upgraded number of production servers from SQL Server 2000 to SQL Server 2005.
• Developed and implemented Disaster Recovery DR on production SQL Server 2000 clusters.

Confidential

Project Manager/ Database Manager

• Responsible for overall production of the IT department. Performed ad-hoc queries for VP of Sales and Marketing, providing him with industry information.

• Installed and configured a SQL Server environment for migration from MS Access.
• Scheduled maintenance tasks to monitor overall database performance, as well as designed stored procedures and views that generate report files to be distributed on a daily basis to clients.
• Redesigned entire IT infrastructure, streamlining business processes.
• Produced dynamic reports of Project Server data and created reports based on specific filter criteria using SSRS's Strong technical documentation skills.
• Demonstrated a clear understanding of the logical and physical database design / models for both transactional and data warehouse .
• Extensive hands on experience with MS SQL Server 2000/2005 / Transact-SQL and SQL Server DTS Packages.
• Extensive experience designing ETL processes MS SQL Server 2005 SSIS / Reporting Services / Notification Services / Analysis Services Develop complex SQL queries, stored procedures, and DTS/SSIS package
• Managed report access via Project Web Access and Analysis Services Project Web Access.
• Server Back-End Administration
• SharePoint Development and Administration Project Management terminology and methodologies out assistance to insure timely completion of tasks Project experience in SharePoint Integration, Dev, Implementation
• A solid understanding of Object Oriented development

Confidential

• Performed on-site technical support including: system delivery, integration, testing, and troubleshooting system consultation of the DOD Logistics database.

• High Availability system and on a pure NT/2000 system, using DB2, MS-SQL or Oracle as database back-ends.
• Responsible for system and database testing of in house support systems, including kernel modifications, disk management, user administration, writing of shell scripts, installation and maintenance of third party software, back-ups and recoveries and other duties as required per the SOP's SQL Server Analyst