PROFESSIONAL SUMMARY:

• 7 years of IT experience and expertise in MS - SQL server 2012, 2008 r2, 2008, 2005 and 2000 development and administration including design and implementation of distributed/ replicated databases, planning/implementing backup/recovery strategies and performance tuning
• Installed and Configured SQL Server 2012/2008 R bit versions on Windows 2008/2003 R2 64/32 bit servers on Enterprise systems comprising of clustered and standalone enterprise Data Centers.
• Experience in writing Dynamic SQL, SQL Stored Procedures, Functions, Packages, Cursors, Views, Database Triggers, Temporary tables, Roles and User defined data types.
• Worked with Disaster Recovery Planning, Security Management, Replication and Log shipping under Server High Availability plans.
• Designed and implemented a standard weekly database maintenance job to all databases using maintenance plan which involves DBCC Checkdb, Rebuild\Reorganize indexes based on index fragmentation.
• Involved in Day to day administration activities like Security, DB objects creation, Change Control Promotion across environments, Troubleshooting developer issues, Backups & scheduled jobs monitoring.
• Good SQL Server Administration skills including Backup/recovery, Database maintenance, User authorizations, database creation, tables, indexes.
• Knowledge in Analysis Services(SSAS), Reporting Services(SSRS) & Crystal Reports
• Identifying and resolving issues related to Query blocks, Deadlocks, timeout, finding long running queries using various SQL in built tools.
• Performed daily task monitoring including backup and extensive usage of SQL Server 2005 tools and 3rd party tools like Litespeed, Veritas NetBackup.
• Designed different database backup strategies for effective use of space and minimum time to recover when needed.
• Query level Performance analysis and tuning with the help of DMV’s, Query plans, Database tuning advisor and SQL Server Profiler.
• Experience in creating Jobs, Alerts, SQL Mail, DB Mail, schedule DTS Packages and SSIS Packages
• Experience in Database Backup, Recovery and Disaster Recovery procedures.
• Experience in writing, debugging, and tuning Stored Procedures and Triggers.
• Implemented Database Mirroring for critical application databases for high availability.
• Wrote shell scripts for DBA’s regarding the status, disk usage and performance of the database.
• Responsible for monitoring and making recommendations for performance improvement in databases by proactively involving in index (Defrag, Rebuild, Alter), DBCC maintenance jobs, file group modifications.
• Created clustered and non-clustered indexes for increasing the performance, also monitored the indexes by
• Troubleshooting any corrupt indexes by removing fragmentation from indexes.
• Knowledge in Third party tools like TOAD, Lite Speed, Auto Sys and Fog light.
• Good Team Player, Strong Interpersonal, Analytical and Communication Skills combined with self-motivation.
• Self-motivated, creative team player with effective communication and Leadership qualities.

TECHNICAL SKILLS:

Databases: MS-SQL Server 2012/ 2008/2005/2000 , MS Access

ETL Tools: SSIS (SQL Server Integration Services), DTS (Data Transformation Services )

Database Utilities: MS DTS, MS Enterprise Manager, SQL Profiler, SQL Query Analyzer, Index Analyzer, DTS Backup Server, SQL Agents, SQL Alerts, SQL Jobs, SQL Mail, Replication Tools.

Data Modeling: Erwin Data Modeler 4.5/4.0 Versions

Languages: Confidential -SQL,PL/SQL, C/ C++, Visual Basic 6.0,C#, HTML, XML, XPath, XQuery, XSLT, JavaScript, and VBScript

.Net Technologies: .Net Framework 1.x/2.0/3.0/3.5, C#.Net, ASP.Net, ADO.Net, Web Services, Win Forms.

IDE: Visual Studio 6, Visual Studio 2003, Visual Studio 2005, Visual Studio 2008

Reporting Tools: SQL Server Reporting Services, Excel Spread Sheets, Crystal Reporting

Operating Systems: Windows XP/2000/NT, Linux, UNIX, Windows Server 2003, Windows Server 2008.

Internet: Internet Information Server (IIS), MS-Front Page, TCP/IP, LAN.

PROFESSIONAL EXPERIENCE:

Confidential, Manhattan, New York

Sr.Database Administrator/Developer

Responsibilities:

• Daily routine DBA tasks like handling user’s permissions and space issues on Production and Semi-Production Servers and handling maintenance Jobs.
• Scheduled and monitored all maintenance activities of SQL Server 2008 including rebuild indexes, update statistic and check integrity
• Experience in upgrading SQL 2008 r2 to SQL 2012.
• Implemented always on feature in SQL server 2012.
• Created maintenance plans for database Full, Differential and Transactional backup. Performed restore operation and Point in Time recovery for Production databases.
• Used DBCC commands, SQL Profiler, Trace Analysis and Execution plans as part of trouble shooting and performance tuning.
• Developed Confidential -SQL Stored Procedures and Triggers and Functions to enforce the business rules.
• Monitoring of database size, disk space in the SQL Server.
• Backup and recovery of Master, MSDB and Model databases
• Tuned the performance by making use of clustered and non-clustered indexes.
• Configured database mail profiles for sending automatic mails to respective users upon the success or failure of a database task.
• Performing query plans and making sure each and every query is using appropriate useful indexes.
• Worked in Active/Passive Clustered Environment.
• Applied service packs and also upgraded SQL Server 2008 to SQL Server 2008 R2
• Developed Confidential -SQL Stored Procedures and Triggers and Functions to enforce the business rules.
• Worked on improving the stored procedures and triggers performance.
• Identified key columns of the tables. Created Table, Clustered, Non-Clustered Indexes and constraints to the frequently used tables in application.

Environment: - MS SQL Server 2008/2008 R2/2012, (Business Intelligence Development Studio), Windows Server 2003, Confidential -SQL, SSIS, SSRS, Confidential -SQL, SQL Profiler.

Confidential, Manhattan, New York

Sr.Database Administrator

Responsibilities:

• Created logical and physical database design, data structures and maintained it.
• Wrote Confidential -SQL statements using DML and DDL for retrieval of data.
• Developed administrative tasks of SQL Server of performing daily Backups and Recovery procedures.
• Administered SQL Server by creation of user logins, groups with appropriate roles, monitored the user accounts, and granted the privileges to users and groups.
• Used performance monitor and SQL profiler to improve performance.
• Created the maintenance plan for SQL Server database optimization and integrity checks for production servers.
• Involved in requirements gathering and responsible for analyzing the new requirements for developing the code for business needs.
• Dropped and recreated the indexes on tables for performance improvements. Used Index tuning wizard for Tuning of indexes. Created Clustered and Non Clustered indexes on tables.
• Used Temp Tables to reduce the number of rows for joins, to aggregate data from different sources for different reports.
• Wrote Confidential -SQL code for creating cursor and handling the data validations.
• Performed DBCC utilities and fixed data corruption in application databases.
• Configured SQL Servers with appropriate settings to resolve various resource allocation & memory issues.
• Automated messaging services on server failures, for task completion and success
• Involved in replication setup, configuration and maintenance in Transactional Replication.

Environment: MS SQL Server 2005, 2008, 2008 r2/2012, Business Intelligence Development Studio, Windows Server 2003, Confidential -SQL, SQL Profiler, and MS Visio.

Confidential, Winston-Salem, NC

SQL Database Administrator/Developer

Responsibilities:

• Installed and configured MSSQL 2005/2008.
• Tuned quires, Confidential -SQL stored procedures to enhance the performance of applications.
• Implemented stand by servers using log shipping for high availability and improved performance.
• Managed the production and development databases for performance tuning, capacity planning and SQL Server clustering and database security configuration
• Created backup strategy for production and development environments. Responsible for database backup and restore, monitor production servers activity, problem solving, scheduled jobs, SQL Server Error Logs and Space Usage.
• Performed performance tuning on the slow running queries and optimizing the databases.
• Performed database mirroring.
• Managed the Security creating Users, Groups and Roles in SQL Server.
• Developed Logical, Physical Database Design and maintained Data models using Erwin.
• Managing the Clustering failover environment.
• Generated SQL scripts to create and drop database objects including: tables, views, primary keys, indexes, constraints, packages, sequences and synonyms.
• Performance Tuning of SQL queries and stored procedures using SQL Profiler
• Using log shipping for synchronization of database.
• Responsible for creating the tables, views, stored procedures, triggers, Constraints.

Environment: SQL Server 2008/2005/2000 , Business Intelligence Development Studio (BIDS), SQL Server Management Studio, SIS, Confidential -SQL, SQL Profiler.

Confidential

SQL Administrator

Responsibilities:

• Successfully migrated from SQL Server 2005 to SQL Server 2008 on development and testing environment..
• Responsible for resolving blocking and locking issues.
• Used clustering for the high availability environment.
• Archived and backed up data on daily and weekly basis
• Implemented and managed alerts, SQL verification and permissions/restrictions
• Maintained secure database with custom login page and individual login details with different authentication levels.
• Experience in maintaining Database Authentication Modes, Creation of Users, Configuring Permissions and Assignment of user roles
• Experience in writing and debugging Stored Procedures, Functions and Triggers.
• Experience in database backup, recovery, disaster recovery procedures and troubleshooting.

Environment: SQL Server 2005/2000, Business Intelligence Development Studio (BIDS), SQL Server Management Studio, SIS, Confidential -SQL, SQL Profiler.

Confidential

SQL Developer

Responsibilities:

• Involved in managing security for users by creating logins.
• Created database objects like tables, views, indexes etc.
• Created and modified stored-procedures, triggers, cursors, and views.
• Installed and configured SQL server 2000 and development software.
• Created non-clustered indexes on columns having high selectivity, and low density to speed up the execution of data retrieval queries and stored procedures.
• Maintained and monitored SQL Server 2000 regularly to ensure uninterrupted operations
• Managed logins and users, including permissions and restrictions, for MS SQL Server
• Evaluated database performance and performed maintenance duties such as tuning, backup, restoration and disaster recovery
• Used Performance Monitor and SQL Profiler to enhance database performance
• Successfully implemented database mirroring between primary server and mirror server.

Environment: SQL Server 2005/2000, Business Intelligence Development Studio (BIDS), SQL Server Management Studio, SIS, Confidential -SQL, SQL Profiler.