SUMMARY

• Over 5+ Years of Experience in SQL SERVER database administrationand Developer for very large and complex databases in SQL Server 2012, SQL Server 2008 R2, 2008 and 2005.
• Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.
• Expertise in T - SQL writing stored procedures, triggers and functions.
• Provide 24*7 Production support as well on call support for SQL Server Databases.
• Experience in Database Administration, Management using RDBMS such as SQL Server under WINDOWS environment.
• Experience in installing, configuring, managing, monitoring and troubleshooting SQL Server 2000/2005. Transactional Replication of Sql servers.
• Experience in SQL Server Backup/Restore, Migration, and having knowledge in upgrading of SQL servers.
• Experience in Log Shipping, data base mirroring and clustering environments.
• Experience in Net Backup client for scheduling Backup and Recovery.
• Managing Logins, Users, Roles and User Permissions.
• Administering SQL Server High Availability and Disaster Recovery strategies.
• Using SQL Server Profiler and other tools for trace analysis.
• SQL Server Database Monitoring with DDL Triggers | SQL Server Profiler | Event Notifications.
• Experience in using DMV and dynamic management functions for finding out long running queries.
• Experience in monitoring, tuning, and analyse data base performance and allocates resources to achieve optimum data base performance.
• Worked on SQL Server 2012 migration from SQL Server .
• Having knowledge in developing and monitoring SSIS, and SSRS Packages. Importing and exporting Data.
• Excellent communication, presentation and interpersonal skills.
• Strong troubleshooting and organizational skills

TECHNICAL SKILLS

Databases: MS SQL Server 2012, 2008, MS SQL Server 2005

Programming: C, C++ & SQL

DBA: database administration of MS SQL Server 2012,2008, 2005

Operating System: Windows 2008/2003 Advanced Server, NT & Windows 9x, Linux

Tools: Backup Utility, SQL LiteSpeed, Visio

PROFESSIONAL EXPERIENCE

Confidential, Jacksonville, FL

Database Administrator

Responsibilities:

• Installation and administration of SQL server 2008/2008R2.
• Implemented procedure documents in place to ensure smooth day to day administration of databases.
• User management and database security imposition by creation and granting of roles and privileges.
• Create Logins and Granting privileges as per requirement.
• Implement DBA maintenance tasks for increase the Database performance with the help of Re-indexing, Re-organize index, and Update Statistics.
• SQL Server jobs scheduling and creating alerts and operators and Trouble shoot the Job failures.
• Created and managedstored procedures, indexed views, user defined functions, triggers, database constraints to meet business requirements and policies.
• Addressing user Requests which comes in the form of e-mails(tickets)
• Implemented Log-Shipping as high availability solution
• Implementation of backup strategy
• Creating and Maintaining Database Maintenance Plans.
• Monitoring Cluster drives and records the drive space.
• As a part of a DBA Team Providing 24/7 support to servers and the databases.

Environment: SQLServer 2012, MS Access, SSIS, SSRS, TSQL, MS Visual Studio 2010,SQL Server Data Tools/BI (SSDT), Remote Desktop Connection (RDC), SharePoint, Secure Access SSL VPN, TFS, Windows Server 2008 R2, and Windows 7 Enterprise.

Confidential

Database Developer

Responsibilities:

• As a part of a DBA Team Providing 24/7 support to servers and the databases
• Addressing user Requests which comes in the form of e-mails(tickets)
• Checking of logs, windows system monitor alerts.
• Implementation of backup strategy
• Creating and Maintaining Database Maintenance Plans.
• For High Availability using Replication and Active /Passive cluster.
• Monitoring performance of the database through Sql server performance alert.
• SQL server daily health check and Monitoring the automation and Maintenance Plan.
• Verify backups and error logs on the servers and troubleshoot on any failures or alerts.
• Providing resolution to assigned tickets as per the defined priority, to maintain the SLA.
• Monitoring the databases as per the daily schedule tasks to check the Health of Databases using DBCC Commands.
• Reorganization of data and index pages and Fragmentation of index using Sql Page 2 of 5.

Environment: SQLServer 2012, SSRS, SSAS, MDX, TSQL, MS Visual Studio 2010,SQLServer Data Tools/BI (SSDT), SharePoint Server 2010, TFS, Remote Desktop Connection (RDC), Windows Server 2008 R2, and Windows 7

Confidential

Jr.DBA

Responsibilities:

• Modified current database by adding tables and relationships to support online system.
• Defined Constraints, Rules and Defaults.
• Created Views as required by front end developer for easier implementation on web pages, and triggers on those views to provide efficient data manipulation.
• Created complex T - SQL Queries, Stored Procedures and Functions to support efficient data storage and manipulation.
• Created SSIS packages to capture the Incremental changes for the Data ware house.
• Built SSIS packages to process Cubes, Dimensions and partitions.
• Have a very Good Experience with all the Control Flow and Data Flow tasks in SSIS.
• Created and managed SQL Server login, database users and Roles.
• Assisted in designing and creating website for the system using ASP, HTML, and CSS.
• Data migration (import & export - BCP) from Text to SQL Server.
• Performance tuning of queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Participated in different testing and debugging for the system.
• Documented all processes involved in maintaining the database for future reference.
• Develop various reports using Reporting Service (SSRS) as required.
• Developed Charts and Tabular reports in Excel and Web format using SSRS.

Environment: Windows 2000, MS SQL Server 2005, 2000. SQL, T-SQL, SQL Query Analyser, Profiler.

Confidential

JR.DBA

Responsibilities:

• Involved in creating Stored Procedures, views, tables, constrains.
• Created stored procedures and triggers for Data consistency.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent Data entry into the database.
• Rebuilding the indexes at regular intervals for better performance.
• Using log shipping for synchronization of database
• Performed BCP, BULK INSERT, Imported and Exported data from different Data Sources.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.
• Moved files between the File Groups and partitioned the tables to improve the performance.
• Monitoring SQL server performance using profiler to find performance.
• Wrote complex stored procedures to process employee’s requirement and generating.
• Worked on complex T-SQL statements, and implemented various codes and functions.
• Write T-SQL Scripts for database backup jobs and daily/weekly jobs.
• Backing up, restoring the data base manually and also by scheduling the jobs and Maintenance Plans.
• Experience in implementing High availability solutions like different Replication models (Snapshot and Transactional), Log shipping, Clustering and Mirroring on physical and virtual machines

Environment: SQL Server2000, ERWIN Data Modeler, Windows 2000, Windows 2003 Advanced Server, Windows NT,DTS,SSAS, SSRS, SSIS, Crystal Reports.