SUMMARY

• Around 5+ Years of experience in Database Administration and 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.
• Administering SQL Server High Availability and Disaster Recovery strategies.
• Experience in data transformation services like SSIS, DTS, BCP and Bulk Insert.
• Experience in using DMV and dynamic management functions for finding out long running queries.
• Experience in MS SQL Replication, Log Shipping and knowledge of clustering techniques and Database Mirroring.
• Experience in client/server connectivity, Query Optimization, Performance Tuning and Database Consistency Checks using DBCC commands.
• Experience with migration from SQL server 2008/SQL server 2012.
• Worked on configuring SQL Server with minimum privileged access
• Implemented the new SQL Server 2012 mechanisms like data compressions, online indexing
• Experience in Batch processes, Import, Export, Backup, Database Monitoring tools and Application support.
• Created DTS package for data transfer between the two environments.
• Experience in Creating Databases based on Functional Requirements and System Design.
• Experience in implementing different types of Replication models like Snapshot and Transactional
• Working knowledge in Analysis Services(SSAS), Reporting Services(SSRS).
• Good team player, strong interpersonal and communication skills combined with self - motivation, initiative and the ability to think outside the box.
• 24 X 7 Production Database on Call Support.

TECHNICAL SKILLS

Languages: T-SQL, Visual Basic 5,Visual Basic6, C.

SQL Server Tools: Backup Utility, SQL LiteSpeed, Visio

Data Bases: MS-SQL Server /2005,2008,2008R2,2012.

Operating Systems: Windows Server 2003,2008 Advanced Server, Windows 9X, NT, Linux.

Network Topologies: TCP/IP,DNS, DHCP,FTP,SMTP

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

SQL Server DBA

Responsibilities:

• Designed, implemented, and administrated databases in SQL Server 2008R2.
• Heavily used Transactional Replication based systems to update databases in different physical locations.
• Backup and recovery strategies in a test environment before and then moved it to the production environment and restoration procedures.
• Performance Tuning and troubleshooting with various Databases.
• Used logshipping to create a warm standby server to improve high availability.
• Implemented automated backup and database maintenance/cleanup jobs.
• Wrote T-SQL queries and procedures for retrieval of data
• Participated in routine and weekend database maintenances.
• Resolved the ticket issues.Sending reports.
• Exported and Imported data from text file and excel to SQL Server Database using Bulk copy insert and BCP utility.
• Tested backup and recovery strategies in a test environment before and then moved it to the production environment.
• Created and Managed Logins, Users, Roles and User permissions as and when required with specific roles on production server.
• Scheduled and monitored all maintenance activities including database consistency check, index defragmentation using the DBCC commands.
• Troubleshooting client issues ranging from improper configuration settings or data corruption to issues in underlying code, working with product management to provide enhancement or other resolution.

Environment: SQL Server 2008R2, Windows 2003/2003R2/2008 Servers, Excel, DTS, T-SQL, ERWIN, SSIS, SSAS, BCP.

Confidential, Southborough, MA

SQL Server DBA

Responsibilities:

• Involved in migration from Sql server .
• Designed, implemented, and administrated databases in SQL Server 2008.
• Migrated SSIS packages from SQL Server 2005 to SSIS 2008
• Created and Managed Logins, Users, Roles and User permissions as and when required with specific roles on production server.
• Developed stored procedures, advanced queries, trigger, views, and indexes by using T- SQL.
• Responsible for tuning data, indexes, and queries.
• Automated and enhanced daily administrative tasks, including space management, backup & Recovery and performance monitoring.
• Tested backup and recovery strategies in a test environment before and then moved it to the production environment.
• Created alerts and notifications for system errors, insufficient resources, and fatal database errors.
• Scheduled and monitored all maintenance activities including database consistency check, index defragmentation using the DBCC commands.
• Heavily used Transactional Replication based systems to update databases in different physical locations.
• Used logshipping to create a warm standby server to improve high availability.
• Used SQL Profiler for troubleshooting, monitoring, tuning of SQL Server and SQL code.
• Performed ETL operations to support the data loads and transformations using SSIS and used SSRS for generating reports to end-users.
• Created data mart using analysis services for finance, inventory and sales department to review the data from production databases.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity
• Involved in performance tuning using indexing (Cluster Index, Non Cluster index) tables.
• Was providing support 24/7.

Environment: SQL Server 2012,2008,2005, Windows 2003/2003R2/2008 Servers, Excel, DTS, T-SQL, ERWIN, SSIS, SSAS, BCP, LiteSpeed, Spot Light.

Confidential, Englewood, CO

SQL DBA

Responsibilities:

• Created groups, roles, users and assigning access privileges to users.
• Created user defined data types and added them to model database for future purpose.
• Creating stored procedures, implemented referential integrity by using triggers.
• Involved in migration from sql server 2000 to sql server 2005.
• Logical and physical database design using Erwin Data Modeling Tool.
• Scheduled the backups for Databases and Transaction log. Performed restoration operations Suggested backup strategies.
• Implemented automated backup and database maintenance/cleanup jobs.
• Performed ETL to support data loads and transformations using DTS Packages and SSIS.
• Exported and imported data from text files and Excel to SQL Server database using bulk copy insert and BCP utility.
• Checked Performance Tuning, Indexing, Query Optimization.
• Implemented, deployed and maintained Log Shipping.
• Performed DBCC utilities and fixed data corruption in application databases
• Provided on - call 24/7 support.
• Provided support for in-house and offshore Development Team.

Environment: SQL Server 2005, SQL Server 2008R2, 2008SQL Server R2, DTS, T-SQL, ERWIN, SSIS, Windows Server 2008,2003, MS Access, Excel, HTML, JavaScript, BCP, Spot Light.

Confidential, Denver, CO

SQL Server DBA

Responsibilities:

• Installed SQL server 2005 on windows 2003/2005 advanced servers, applied service packs and security fixes.
• Created logical and physical data modeling for development database using Erwin Tool.
• Configured the database maintenance plans for database optimization.
• Experienced in performance tuning using windows performance monitor and SQL profiler.
• Created tables, views and indexes.
• Used system stored procedures and DBCC commands.
• Creating the users, user groups and maintained access permissions.
• Configured and maintained transactional and merge replication for 2 environments.
• Worked with developers to tune the queries, run scripts and move the database from development to production servers.
• Setting up database back up and recovery procedures for production, testing and development servers.
• Wrote complex T-SQL queries and procedures for retrieval of data.
• Troubleshooting client issues ranging from improper configuration settings or data corruption to issues in underlying code, working with product management to provide enhancement or other resolution.
• Supporting Customer Service department requests by writing queries to document current issues and resolve outstanding tickets.
• Participated in project team activities prior to release and contributes to documentation requirements consistent with methodology

Environment: Windows 2003/2003R2, 2008Advanced Server, MS SQL Server 2005,2008,2008R2, VB Script, T-SQL, Enterprise Manager, Query Analyzer, SQL Profiler.

Confidential

SQL Developer/Administrator

Responsibilities:

• Installed and configured SQL server 2005 and set-up Various Databases.
• Created all administration tasks of SQL Server and designed database
• Worked with development team in relation to application tuning.
• Created tables, views and indexes.
• Developed various stored procedures, cursors, functions and triggers.
• Created tables and provided constraints and user defined rules and defaults.
• Used system stored procedures and DBCC commands.
• Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Designed a report on the monitoring of SQL Server Performance, which gave a detail report to the management on the Performance of the server.
• Scheduled backups and performed restore operations for system test data depends on testers requirement.
• Created logins and maintained user permissions appropriately.
• Wrote complex T-SQL queries and procedures for retrieval of data.
• Created DTS packages for migration of data from SQL Server to MS Access or Oracle databases.
• Performed daily backups and developed recovery procedures.
• Managed Disk space, memory and User connections.
• Performed DBCC checks and fixing data corruption in Application databases.

Environment: SQL Server 2005/2000, Windows 2000/2003 server, DBCC, SQL Profiler, Enterprise Manager, Query Analyzer.