SUMMARY:

• 7 Plus years of experience in Database Administration, System Analysis, and Development & Support of MS SQL Servers 2000/ 2005/2008/2012 in Production, Development, Testing and Data warehouse Environment.
• Experience in working with Windows 2012/2008/2003/2000
• Experience in supporting Very Large Databases(VLDB)
• Experience in Creating Databases based on Functional Requirement and System Design.
• Experience in Performance Monitoring and Tuning, Query Optimization, Client/Server Connectivity, resolving Blocking /long running queries/ Dead Locks, Database consistency checks using DBCC Utilities.
• Expert in Implementing high availability features of SQL Server solutions, including Log shipping, Replication, Mirroring and Cluster Environment
• Experience in Database Backup, Recovery and Disaster Recovery procedures in SQLSERVER and Design Tested and Implemented various Failure Strategies base on business requirements
• Experience in implementing Table Partitioning, CDS and Encryption features
• Experience in Supporting Development/Testing/Datawarehouse/SysAdmin Teams
• Maintain Database Authentication mode, creation of users, configuring permissions and assigning roles and Profiles
• Experience in optimizing code and improving efficiency in databases including re - indexing, updating statistics, reviewing and recompiling stored procedures, Triggers, Data Consistency checks
• Experience in implementing business logic by using TSQL, Stored procedures, triggers
• Experience with other 2005 new concepts like DMV’S, DMF’S, and performance dash board
• Experience working in SAN network and RAID configure Environment
• Optimum Utilization of Operating System Resource to Sql Server
• Experience in Automation of Schedule Maintenance jobs and defining Alerts
• Experience in Logical and Physical Database Design and Capacity Planning
• Experience in providing Production Support for 24x7 Environments
• Documenting all the Standard Procedures

TECHNICAL SKILLS:

Operating System: Windows Server 2000/2003/2008/2012

Databases: SQL Server 2000/ 2005/2008/2012, Microsoft Access, MySql, Informix

Languages: T- SQL, SQL Plus, Pl/Sql

Database Tools: Management Studio, Enterprise Manager\Grid Control, Query Analyzer, DTS, BCP, RMAN, Data Pump, Erwin, Visual Source Safe(VSS),WinScp, Putty, Sql Sentry Sql Profiler, Toad,Sql Developer, Perfmon

Monitoring \ Backup Tools: Control-M, SCOM,MOM, Embarcadero, Idera Diagnostic Manager, LiteSpeed, Spotlight, Remedy Service Center Desk, SharePoint Server, BMC Patrol, Red gate Backup Tools, IBM Tivoli, Active Directory, Wintel, Legato Tape Backups

PROFESSIONAL EXPERIENCE:

Confidential, Troy. MI

SQL Server (DBA)

Responsibilities:

• Installing and Configuring Microsoft SQL Server enterprise edition on development, pre-production and production servers.
• Monitoring and Performance Tuning of SQL Server, Operating System.
• Implementing Backup and Recovery Strategies based on Business requirements.
• Implementing High Availability feature like Log Shipping, Mirroring for Disaster Recovery.
• Using Performance Monitor/SQL Profiler to analyze long running/slow queries and tune the same to optimize Application and system performance.
• Administering MS SQL Servers by creating User logins and assigning them proper permissions, observing all process running on the server making sure server will run at its best.
• Supporting Very Large Databases VLDB.
• Reviewing T-SQL code to verify and meets standards for both performance and error handling according to DBA standards.
• Working Extensively on Disk Space Utilization and Capacity Planning.
• Creating and Managing Custom Application Jobs according to Application requirements.
• Supporting 24/7 Production Environment
• Documenting the Standard Procedures.
• Actively Participating in meetings, recommending the necessary changes required in present database.

ENVIRONMENT: MS SQL Server 2005/2008/2012, T-SQL,SQL Profiler, Performance Monitor, Red Gate, Embarcadero, Tivoli, SCOM VMware, Clustered Environment, My Services, HP Service Manager

Confidential, New York, NY

SQL Server (DBA)

Responsibilities:

• Installed and Configure Microsoft SQL Server enterprise edition on development, pre-production and production servers. Experience working in clustered environment and upgraded SQL 2000/2005 to SQL 2008/2012 in both non-clustered and clustered environments. Closely work with application teams to resolve the issues that are outcome of major SQL upgrade.
• Trouble Shooting and Solving the Production issue’s
• Monitoring and Performance Tuning of Sql Server, Operating System.
• Implemented Backup and Recovery Strategies base on Business requirements
• Implemented High Availability feature like Log Shipping, Mirroring for Disaster Recovery
• Used Performance Monitor/Sql Profiler to analyze long running/slow queries and tune the same to optimize Application and system performance
• Created and maintained Automation of Database Maintenance Plans for the Performance of servers which covers Database Integrity Checks, Update Database Statistics and Reindexing
• Administered MS SQL Servers by creating User logins and assigned them proper permissions, observing all process running on the server making sure server will run at its best.
• Supporting Development/Testing/Datawarehousing/SysAdmin Teams
• Experience Working in SharePoint
• Supported Very Large Databases VLDB (Max Size-1.2TB)
• Worked extensive with database design team and development team for database design and implementation, used Erwin for database design and SQL 2008 for development.
• Review T-SQL code to verify and meets standards for both performance and error handling according to DBA standards
• Capacity Planning and Optimizing the sizes of Databases
• Reviewing Multi-Server System Info and utilizing the hardware at its best
• Worked Extensively on Disk Space Utilization and Capacity Planning
• Created and Manage Custom Application Jobs according to Application requirements
• Supporting 24/7 Production Environment
• Documenting the Standard Procedures
• Actively Participated in meetings, recommended the necessary changes required in present database or business systems

ENVIRONMENT: MS SQL Server 2005/2008/2012, Windows 2000/2003/2008 Server, T-SQL,SQL Profiler, Performance Monitor, Red Gate, HP Services

Confidential, MN

SQL Server (DBA)

Responsibilities:

• Expertise and Interest include Administration, Performance Monitoring and Tuning.
• Implemented Backup and Recovery Strategies based on Business requirements
• Trouble Shooting and Solving the Production issue’s
• Monitoring and Performance Tuning of Sql Server and Databases
• Implemented High Availability feature like Log Shipping, Mirroring for Disaster Recovery
• Used Performance Monitor/Sql Profiler to analyze long running/slow queries and tune the same to optimize Application and system performance
• Created and maintained Automation of Database Maintenance Plans for the Performance of servers which covers Database Integrity Checks, Update Database Statistics and Reindexing
• Administered MS SQL Servers by creating User logins and assigned them proper permissions, observing all process running on the server making sure server will run at its best.
• Supporting Development/Testing/Datawarehousing/SysAdmin Teams
• Experience Working in SharePoint
• Reviewing Store Procedure Code before deploying from Performance Point
• Supported Very Large Databases VLDB (Max Size-1.2TB)
• Worked extensive with database design team and development team for database design and implementation, used Erwin for database design and SQL 2008 for development.
• Review T-SQL code to verify and meets standards for both performance and error handling according to DBA standards
• Reviewing Multi-Server System Info and utilizing the hardware at its best
• Worked Extensively on Disk Space Utilization and Capacity Planning
• Created and Manage Custom Application Jobs according to Application requirements
• Supporting 24/7 Production Environment
• Documenting the Standard Procedures
• Actively Participated in meetings, recommended the necessary changes required in present database or business systems

ENVIRONMENT: MS SQL Server 2005/2008R2, Windows 2000/2003/2008 Server, T-SQL,SQL Profiler, Performance Monitor, RedGate, MOM, Tivoli, SCOM VMware, Clustered Environment, SharePoint.

Confidential, New York, NY

SQL SERVER (DBA)

Responsibilities:

• Expertise and Interest include Administration, Performance Analysis, and Production
• Published the databases from old servers to new servers using replication based on the business requirements.
• Implemented the disaster recovery processes.
• Trouble shooting and resolving day - day issue’s
• Migrated Sql Server between different versions
• Used the SQL Server Profiler tool to monitor the performance of SQL Server - particularly to analyze the performance of the stored procedures.
• Involved in creating normalized Databases, creating objects, sizing temp databases.
• Involved in Extracting, Transforming and Loading(ETL) data in to target Data warehouse
• Monitored and modified Performance using execution plans and Index tuning.
• Using log shipping for synchronization of database
• Manage and Implemented Replication Technology
• Supporting on-call (off hours) schedule in providing technical support.
• Implemented the Data Partitioning for large table in SQL Server 2005
• Support Very Large(VLDB) and Complex Databases
• Generated reports and export data into PDF and Excel formats.
• Installed SQL SERVER on Microsoft Cluster (Active/Passive)
• Used Visual Source Safe to maintain version control mechanisms.
• Was involved in logical designing and physical designing the databases using ERWIN
• Rebuilding the online indexes at regular intervals for better performance
• Created and modified Stored Procedures and Functions to generate reports.
• Deployed Reports on Report Server.
• Created Automation of Jobs and scheduled for daily running.
• Extracted data from Oracle and load into SQL Server 2005 using link Server and validated according to business rules.
• Involved in creating Technical Specification Documentation(TSD) for the project and for the individual Reports, Stored Procedures and functions

Environment: MS SQL Server 2000/2005/2008, Windows 2000/2003 Server, T-SQL,SQL Profiler, Performance Monitor, Lite Speed, Spotlight, HP Service Manager, Erwin, Visual Studio Source, VMware, Clustered Environment, SharePoint Server