SUMMARY

• Over 7+ Years of Experience in SQL SERVER data base administrationand Developer for very large and complex databases in SQL Server 2012, SQL 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.
• Used BMC PATROL for MS SQL Server for remote monitoring of SQL Servers.
• Experience with Policy Based Management, Resource Governor, and Transparent Data Encryption (TDE).
• Experience in logical and physical data modelling of database in ERWIN and MSVISIO.
• Experience in installing, configuring, managing, monitoring and troubleshooting SQL Server. Transactional Replication of Sql servers.
• Experience in SQL Server Backup/Restore, Migration, and having noledge in upgrading of SQL servers.
• Experience in Log Shipping, data base mirroring and clustering environments.
• Experienced in Configuration of SQL 2000/2005/2008 Clustered Servers in Active/Passive and Active/Active mode.
• Expert in installing Slipstreams, rolling patches, rolling upgrades in Clustered Environment.
• Experience in Net Backup client for scheduling Backup and Recovery.
• Administering SQL Server High Availability and Disaster Recovery strategies.
• Using SQL Server Profiler and other tools for trace analysis.
• Experience in working with both high transacted OLTP systems and OLAP database systems.
• 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 and troubleshooting using DBCC Utilities.
• Experience in monitoring, tuning, and analyse data base performance and allocates resources to achieve optimum data base performance.
• Implemented T-SQL features like Data partitioning, Error handling and Snapshot Isolation.
• Experience in identifying the me/O and memory, bottle necks, blocking and deadlocks caused by complex queries using SQL Server Activity monitor, SQL profiler, Extended events and Handling them by implementing better Query Execution plans.
• Worked on SQL Server 2012 migration from SQL Server .
• Having noledge in developing and monitoring SSIS, and SSRS Packages. Importing and exporting Data.
• Managing Logins, Users, Roles and User Permissions.
• Experience in applying service packs and hot fixes.
• Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database health Check, Indexing, Updating Statistics.
• Worked with a team of business analysts, data architects, application developers, ETL Developers and testers.
• My objective was to deliver projects within scope, time and costs while following department standards, methodologies and guidelines.
• 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 2012/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.
• Providing Security support for Community Report.
• Maintenance, Release Management, Incident Management, change Management.
• Leading Problem Management, Root cause analysis
• Capacity planning and developing different projects for the support activities.
• Creating the reports to analyze the data in different metrics.
• To set up SQL Server configuration settings to resolve various resource allocation & memory issues for SQL Server databases and to setup ideal memory, min/max server options.
• 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, Dallas,TX

SQL Server DBA

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.
• Used BMC PATROL for MS SQL Server for remote monitoring of SQL Servers.
• Creating and Maintaining Database Maintenance Plans.
• For High Availability using Replication and Active /Passive cluster.
• Build two-node/Multi- node cluster on physical/Virtual environments.
• Refresh non-prod environments with production.
• Added SQL Clustered Node to Existing Cluster for SQL Server 2008R2.
• Extensively used Red Gate SQL Compare and Data Compare tools to compare and Synchronize SQL Database Schemas.
• 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. Fix the Cluster and Replication issues on sql 2005/2008R2/2012 servers with in very strong SLA’s.
• Monitoring the databases as per the daily schedule tasks to check the Health of Databases using DBCC Commands.
• Played a key role in business requirements analysis, architecture design, physical and logical Data modelling, application development, testing, training, production support and Project review with client.
• Configured Email notifications thru SMTP to get Alerts and diagnose the performance counters.
• Monitoring performance of the database through Sql server performance alert.
• Reorganization of data and index pages and Fragmentation of index using Sql.
• Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, Agent, and Database Engine Tuning Advisor.
• Extensively worked on performance issues like update statistics, Auto Stats.
• Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks.
• Memory Configuration for SQL server on 32-bit boxes.
• Created various jobs to check health of the server and to troubleshoot
• Implemented the new SQL Server 2005 concepts like Data partitioning, Snap shot isolation, Database mirroring, database snapshot, DDL triggers, try-cache blocks, online indexingDMV’s, DMF’s, Mail Setup, Jobs, and alerts, DTA, SQLCMD and dedicated admin Connection.

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

SQL DBA

Responsibilities:

• Created and managed complex batch jobs.
• Created complex queries for database auditing purposes.
• Performed database Tuning, monitoring, and Scalability Testing
• Evolved in the creation and maintenance of index using Index Tuning Advisor wizard,
• Query optimizer, and selected the best indexing plan to be deployed.
• Thorough analysis and testing of database objects &T-SQLstatements before deployment to the production server.
• Implemented custom Maintenance jobs schedule to run daily and on weekends (tasks like rebuilding. Indexes, defragmenting Databases, Shrink Database, and Database complete backup).
• Migrated SQL Server 2000 to SQL Server 2005, SQL Server 2008 and SQL Server 2008 R2.
• Created/developed Stored Procedures Triggers to handle complex business rules, history data and audit analysis.
• Responsible for installing SQL Server on the new build Standalone and Clustered servers.
• Maintained databases, performed software installations and upgrades, monitored database performance, performed capacity planning and SQL Server clustering, and managed database Quality Assurance including database consistency check.
• Created complexETLStrategies to populate the Data warehouse/Data-mart facts and dimensions.
• Created a report model onSSAScubes.
• Created Drill down Reports, Ad-hoc Reports and Drill through reports using the ROLAP as a source.
• Assisted in the scheduling and the deployment of the reports and assisted in uploading files to a report server catalogue from the report manger.

Environment: SQL Server2005/2008, ERWIN Data Modeller, Windows 2000, Windows 2003 Advanced Server, Windows NT,DTS,SSAS, SSRS, SSIS, Crystal Reports.

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 and managed SQL Server login, database users and Roles.
• Scheduled jobs for backup, and created alerts for error reporting.
• 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.
• Actively participated in gathering of Requirement and System Specification

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