SUMMARY

• Total 8+ (Eight Plus) Years of IT experience as MS SQL Server DBA.
• Experience in the complete life cycle of databases which includes designing a database, populating lookup data, creating Stored Procedures as per front end developer’s requirement and commercial transitions, writing Triggers, creating user defined functions, Indexes and created views to simplify the complexity of the data structure.
• Experience on T - SQL, Distributed Queries, and Correlated Sub Queries and used most of the systems function.
• Extensive experience with SQL Performance tuning and transactions analysis, thorough understanding of indexes and statistics.
• Expertise in planning and implementing MS SQL server security and database permissions like Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Solid experience and outstanding knowledge of high availability SQL Server solutions, including Log shipping, Database Mirroring, Replication and SQL Server clustering.
• Expertise in performing administrative tasks: database files management, backup/restore, security management, data integration and synchronization.
• Expert in extracting and transforming data using DTS Import Export Data, DTS Packages, SSIS and Experience in using BCP for Bulk copy operation and Bulk Insert.
• Proficient in MS SQL Server suite of products like SSRS and SSIS of MS SQL Server 2008.
• Experienced in defining Query for generating drill down reports in SSRS 2005.
• Experience in SQL Server Analysis Services Snow Flakes Schema and Star Schema.
• Grant privileges to users to access systems and databases.
• Managing Files and File Groups in Production Databases.
• Hands on experience in Installing, Configuring, Managing, Monitoring and Troubleshooting SQL Server 2000/2005/2008.
• Migrated data from SQL and solved related issues
• Monitoring and tuning SQL Server performance with multiple tools including Performance Monitor, SQL Profiler, Event Viewer, and Index Tuning.
• Experience in SQL Server CLUSTERING.
• Experience in creating Packages, Jobs and Sending Alerts using SQL Mail.
• Experience in database Backup, Recovery and Disaster Recovery procedures.
• Excellent communication, presentation, interpersonal skills, strong troubleshooting and organizational skill

TECHNICAL SKILLS

Databases: SQL Server 2005/2008/2012 , Oracle11g/10g/9i, MS Access, MY SQL

Languages: C, C++, T-SQL, JAVA, HTML

Operating Systems: Windows server 2008, Windows server 2003, Windows 2000 advanced server, Windows NT/95/XP, MS DOS

GUI Tools: Forms 5.0/6i/9i, Reports 3.0/6i/9i

Networking: TCP/IP, DNS, WINS, DHCP.

Web design tools: Dream Weaver CS3, FrontPage 2002, Outlook Express

PROFESSIONAL EXPERIENCE

Confidential, New Jersey

Sql Server DBA

Responsibilities:

• Installing, configuring and creating SQL server 2008,2008 R2 servers with Latest service packs.
• Performing Database maintenance activities like Backups, Restoring, and indexing.
• Migrated DTS 2000 packages to SQL Server Integration Services (SSIS) and modified the packages accordingly using the advanced features of SQL Server Integration Service.
• Created and executed SQL Server Integration Service packages to populate data from the various data sources, created packages for different data loading operations for many applications.
• Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source, Excel Spreadsheet to SQL Server 2005.
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XMLs etc) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Monitoring the Disk spaces on all the servers.
• Checking the general Health of the servers for identifying Bottlenecks.
• Created new database objects like procedures, functions, packages, triggers, indexes and views using T-SQL in development and production environment for SQL server 2008.
• Created stored procedures to transform the data and worked extensively in T-SQL for various needs of the transformations while loading the data.
• Ensuring high availability of the database exploiting the concepts of mirroring, replication, Log shipping etc.
• Performing Database maintenance activities like Backups, Restoring, and indexing etc.
• Support duties, which include monitoring servers, hosting SQL Server and work with network operations resolving any production problems.
• Grant privileges to users to access systems and databases.
• Recovery of the database during crash or data Loss.
• Monitoring SQL server performance using profiler to find performance and dead locks.
• Managed the production and development databases including extensive performance tuning, capacity planning, database security configuration and database continuity.
• Created SSIS Package to transfer data from various locations using the FTP task. Then loaded the flat file data into the database.
• Create, modify, test, and troubleshoot SQL Server Reporting Services (SSRS) reports.
• Created reports by extracting data from cube.
• Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and Parameterized and Linked reports.

Environment: SQL Server 2012/2008/2008 R2, Windows 2008 server, Windows Server 2003(x64), Windows Cluster Server, Windows Server 2000, BIDS 2005/2008, SQL Server Management Studio, Query Analyzer, SQL Profiler, Performance Monitor, SSIS, SSRS, Team Track, SQL Safe.

Confidential, Dallas,TX

SQL Server DBA

Responsibilities:

• Installing, Configuring and Administering SQL server 2005/2008/R2/2012.
• Performing Database maintenance activities like Backups, Restoring, and indexing etc.
• Created tables, views, indexes, stored procedures, triggers and provide constraints and user defined rules and defaults
• Created system procedures for database maintenance and monitoring them.
• Testing the application for deployment, Function and behavior testing.
• Backup and Recovery: Designing Backup/Restore Strategy. Setup backup and recovery scripts. Setup exports
• Database performance tuning for optimal results.
• Developed Backup strategies for Database Recovery.
• Ensuring High Availability using Technologies like Database mirroring, Log shipping.
• Configuring Replication between servers.
• Extensively used Extract Transform Loading (ETL) tool of SQL Server to populate data from various data sources.
• Developed, monitored and deployed SSIS packages.
• Experienced in defining Query for generating drill down reports in SSRS 2005.
• Migrated data from SAS environment to SQL Server 2005 via SQL Server Integrated Services (SSIS).
• Responsible for transferring the data using SSIS packages and DTS Import and Export wizard.
• Coordinated with users for downtime and maintain the system 24X7 running.

Environment: MS SQL Server 2005 Enterprise Edition, MS Integrated Services 2005, MS Analysis Services 2005, MS Access, Import & Export Data, Windows XP

Confidential, New York

Sql Server DBA

Responsibilities:

• Managing Files and File Groups in Production Databases.
• Implemented different types of constraints on tables.
• Creating and Deploying SSIS packages and have experience generating reports using SSRS.
• Ensuring data consistency in the database through DBCC commands.
• Experience in Database Backup, Recovery and Disaster Recovery procedures.
• Responsible for scheduling the subscription reports with the subscription report wizard.
• Configuring and maintaining of different types of Replication models like Snapshot and transactional.
• Hands on experience with performance tuning, query optimization and indexes.
• Knowledge of 2 node (active\passive) Clustering in SQL Server 2008.
• Specific hands on experience include Administering large and complex Databases, Log shipping, database mirroring and Security Management.
• Rebuilding all databases including user and system databases at the time of server crash and bringing back the server to online state.
• Experience on optimization of the stored procedures, Creating indexes on the required Tables, Performance Tuning and Query optimization.
• Excellent communication and interpersonal skills. Highly motivated with strong commitment to quality and customer service.

Environment: MS SQL Server 2000 Enterprise Edition, MS Integrated Services 2000, MS SQL Server Reporting Services 2000, Windows Server 2003.

Confidential, Memphis, TN

SQL Server DBA

Responsibilities:

• Managing schema objects such as Tables, Views, Indexes, procedures, triggers.
• Installed MS SQL Servers on test and development boxes.
• Extensively created and used Stored Procedures and tuned them for good performance.
• Performed tuning of SQL queries using Show Plans and Execution Plans.
• Performed data transfer using ETL tools like SSIS.
• Backing up, restoring system & other databases as per requirements, and also scheduled those backups.
• Experience in creating Packages, Jobs and Sending Alerts using SQL Mail.
• Performance Tuning: Analyze, tuning and optimizing for SQL Server code by using performance tuning wizard and SQL Profiler.
• Suggested different plans for Replication and Implemented Transactional and Merge replication
• Verify backups and error logs on the servers and troubleshoot any failures or alerts.
• Using Database Maintenance Plan Wizards for SQL Server 2005.
• Monitoring, Configuring and maintaining the log shipping.
• Configuring and maintaining the Database Mirroring.
• Grant privileges to users to access systems and databases.
• Recovery of the database during crash or data Loss.

Environment: Windows 2000 Advanced Server, MS SQL Server 2000, T-SQL.

Confidential

SQL Server DBA

Responsibilities:

• Created and managed Schema object such as tables, views, indexes, procedures and triggers through Query Analyzer
• Created complex Stored Procedures, Functions and other T-SQL code and SQL joins for applications.
• Implemented different types of constraints on tables.
• To ensure trouble free access to SQL Server databases .
• Timely completion of activities for database backup, restoration and health check of databases.
• Monitoring Log shipping/Replication and trouble shooting of errors.
• Security issues related to logins, database users, and application roles and linked Servers.
• Performance Tuning of SQL 2000 Servers.

Environment: SQL Server 2000/7.0, Windows 2003/2000 Server and SQL Lite Speed