Summary:

• Over 7 years of experience in IT and 6 plus years in Database Administration and Developer for very large and complex databases in SQL Server 2012, 2008 R2, 2008, 2005 and 2000.
• Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.
• Worked on SQL Server 2012 Migration from SQL Server 2008R2/2005 / 2000.
• Administering SQL Server High Availability and Disaster Recovery strategies.
• Strong technical background along with the ability to perform business analysis and write effective documentation and specifications.
• Implemented the new SQL Server 2012 mechanisms like data compressions, online indexing, Contained Databases, security principals and AAG.
• Proficiency and expertise in SQL Server Replication, Backup/Recovery, Disaster recovery and planning.
• Worked extensively on Clustering and server consolidation. Troubleshooting production issues and raising high availability.
• Having hands on experience in DR processes including Log shipping and Database Mirroring.
• Troubleshoot performance problems, fine-tuning of databases and index Analysis.
• Experience in using DMV and dynamic management functions for finding out long running queries.
• Worked on configuring SQL Server with minimum privileged access.
• Handled multiple SQL Instances on Cluster environments for Server Consolidation projects built on SAN using RAID levels.
• Experience on 64 bit SQL Server 2012 / SQL Server 2008 R2 systems and MSCS Configurations.
• Maintained individual service accounts for SQL Server services on cluster with different Security groups to raise security mark.
• Having Experience on Data center servers and handling 1.4 TB databases.
• Experience in using tools like SQL Profiler, Red Gate, Windows Performance monitor and performance counters for Monitoring and Tuning MS SQL Server Performance.
• Working knowledge in data transformation services like SSIS, DTS, BCP and Bulk Insert and experience with SQL Server connection protocols including Kerberos and NLTM.
• Experience in Batch processes, Import, Export, Backup, Database Monitoring tools and Application support.
• Created Linked Servers between SQL Server 2008 R2 Oracle 9i and 10g. Also created DTS package for data transfer between the two environments.
• Working knowledge in Analysis Services SSAS and Reporting Services SSRS .
• Implemented different types of Replication models like Transactional and Snapshot.
• Excellent backend skills in creating SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers, Rules, Defaults, user defined data types, Cursors and functions.
• 24 X 7 Production Database on Call Support
• Worked on importing data from MySQL to SQL Server.
• Strong experience in mentoring team members and writing documentation.
• Worked on logical and physical data base modeling with UML and ERWIN tools
• Worked on Jira, BMC, RFC, Virtual Ticket Service Now ticketing system software's.

Technical Expertise:

Professional Experience:

Confidential

SQL Server DBA

Responsibilities:

• Installed, Configured and Administered SQL Server 2012/2008R2/2008/2005 Servers in Production, QA and UAT Environments.
• Migrated SQL Server 2005 to 2008R2 in Microsoft Windows Server 2008 R2 Enterprise Edition.
• Worked closely with application team, manager and other DBA's for planning and implementation of the migration.
• Successfully implemented Database Mirroring in SQL Server 2005 and 2008 for High Availability.
• Performed Backups and restores on regular basis for Migration and other purposes.
• Migrated SSIS packages from SQL Server 2005 to SSIS 2008 and documented them.
• Worked with tickets like RFC's for prod/UAT changes and VT's for QA/DEV servers.
• Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions.
• Involved in using SQL Profiler to identify slow running queries and stored procedures, least and mostly used stored procedures.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Designed and implemented comprehensive Backup plan using SQL LiteSpeed.
• Used SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor DTA .
• Configure and manage database maintenance plans for update statistics, database integrity check, backup operations, indexing updates and Documented.
• Worked in Microsoft Cluster Services MSCS , including Active/Passive, Active/Active, and Network Load Balancing clusters.
• Database refreshes from prod to stage, test and development environments.
• Provided 24/7 on-call support on rotation basis for production database.
• Creating Logins and Roles with appropriate permissions.
• Tested and Implemented procedures to detect poor database performance, collecting required information and root cause analysis.
• Solved issues related to server performance and disk space.
• Rebuilding the indexes at regular intervals for better performance.

Environment: MS SQL Server 2012/2008R2/2008/2005/2000, Visual Studio 2010/2005, SQL Lite Speed, Microsoft Visio 2003, SFTP and Windows Server 2003/2000.

Confidential

SQL Server DBA

Responsibilities:

• Performed migration of servers from SQL Server 2005 to 2008.
• Monitored replication and configured servers for Publishers, Subscribers, and Distributor for Marge and transactional replication.
• Participated in Scrum meetings.
• Worked on importing data from MySQL to SQL Server
• Tuned T-SQL code using optimization techniques to improve query response time.
• Rebuilt indexes at regular intervals for better performance and documented them.
• Involved in designing the databases using Erwin.
• Detached database from Sql server 2005 and attached to Sql Server 2008 using SSMS.
• Setting up a QA Environment with SQL Server 2005/2008 Database Server for the complete application testing.
• Involved in configuring Microsoft Cluster Service MSCS , and review network, security, and considerations for other software that will run on the failover cluster.
• Created complex stored procedures and functions to support efficient data storage and manipulation.
• Involved in implementing Marge and Transactional Replication.
• Defined constraints Primary Keys, Foreign Keys, Defaults, Check, Unique etc , rules and defaults.
• Data migration from Text to SQL Server using BCP command line utility and Bulk insert.
• Reduced the T-SQL overhead successfully by avoiding unnecessary use of The UNION, , statement using the TOP operator to limit the Select Statement in certain Queries.
• Regularly monitored the system for bottlenecks CPU, RAM, Disk IO and Networking .
• Participated in testing and debugging of SQL queries.
• Created Service Broker Programs to continuously load data from the mirror database to the report database.
• Monitor and tune SQL scripts. Creating upgrade scripts for production database and supporting it.
• Implementation of fail over clustering on warm stand by servers and raid 1 5 technologies.
• Created SSIS packages to pull data from Oracle to Flat Files and Excel.
• Generated different reports using MS SQL Reporting Services.
• Analyzed the requirements and selected the appropriate Fact tables/created Fact tables and Dimension tables.

Environment: MS SQL Server 2008/2005/2000, Windows 2003/2000/NT, SQL Profiler, SQL Server Management Studio SSIS, SSRS, Database Tuning Advisor, Service Broker, Raid, Oracle 9i,BCP Utility, Excel and .NET.

Confidential

SQL Server DBA

Responsibilities:

• Replicated SQL servers handling thousands of transactions per day with 24/7 uptime to service clients.
• Actively involved in Creation of database, modified tables, triggers, and store procedures to clean and validate the data to meet the company specifications.
• Independently upgraded all the servers from MS SQL Server 2000 to MS SQL Server 2005.
• Implemented and Scheduled Replication process for updating our parallel servers.
• Automated messaging services on server failures, for task completion and success.
• Used BCP utility to publish table output to text files.
• Worked on importing data from MySQL to SQL Server
• Implemented Constraints on tables for maintaining Data Integrity.
• Tuned Stored Procedures, DTS packages for accuracy of Servers.
• Extracted data from SQL Server for report, backup, testing purpose by using SSIS.
• Regularly monitored the system for bottlenecks CPU, RAM, Disk IO and Networking .
• Participated in testing and debugging of SQL queries.
• Created distributed partitioned tables, partitioned views, debugging / troubleshooting stored procedures, upgrading existing ones.
• Implemented day-to-day operations such as database creation, monitoring disk space, monitoring performance using Profiler, implementation, testing, maintenance, and troubleshooting of software applications.
• Used ER/Studio to reverse engineer legacy database from Sybase to SQL Server.
• Configured two Active/Passive Clustering setups for failover on production servers. This included installing windows cluster service and SQL 2000 on windows 2003 enterprise edition.
• Installed, authored, and managed reports using SQL Server 2005 Reporting Services.

Environment: T-SQL, MS SQL Server 2005/2000/7.0, BCP utility, DTS, Windows 2003/2000/NT, Sybase, ERStudio.

Confidential

SQL Server DBA

Responsibilities:

• Installed SQL Server 2005 and apply service packs, hot fix and clustering installation.
• Database Administrator, Database Programming.
• Installed and managed multiple 2 node failover cluster set up in active/passive environment as a High Availability mechanism.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Configured transactional Replication from multiple subscribers for reporting purpose.
• Responsible for writing Editing Stored Procedures, Triggers, Views, Tables T-SQL Scripts.
• Deploying new code base release to UAT and Production Environments.
• Working with customers on Application rollouts and server migrations.
• Worked on importing data from MySQL to SQL Server
• Extensively worked on DBCC commands and Dynamic Management Objects.
• Worked with change management and change control procedure.
• Converting DTS packages into SQL Server 2005 Integration Services
• Solved issues related to server performance and disk space.
• To analyze long running slow queries and tune the same to optimize application and system performance.
• Managed the multiple databases DB under EMC drives clustered active/active, active/passive and also involved in Capacity Planning.
• Support Development team in deploying and testing the application and also on Sharepoint.
• Conducted root cause analysis of application availability and narrow down to issues related to coding practices, database bottlenecks or network latency.

Environment: Microsoft Windows Server 2000/2003 32/64bit, Microsoft SQL Server 2000, Microsoft SQL Server 2005, Microsoft Visual Studio 2005.

Confidential

SQL Server DBA/Developer

Responsibilities:

• Perform business analysis, technical analysis, systems design, application software programming.
• Involved in Optimization and Performance Tuning of SQL Server using SQL Profiler and Performance monitor.
• Create Database Objects like Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions.
• Managing the use of disk space, memory and connections. Running DBCC consistency checks, and fixing data corruption in application databases .
• Rebuilding the indexes at regular intervals for better performance.
• Manage replication and database modifications for replicated objects.
• Transferring the data ETL to Data warehouse Informatica by SSIS.
• Monitoring SQL server performance using SQL Profiler to find performance and dead locks.
• Design, document and implement SSIS packages and stored procedures.
• Extensively worked on Data Partitioning and Snapshot Isolation in SQL Server 2005.
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Support and troubleshoot as required, optimize performance and resolve production problems.
• Worked on SQL Server tools Like Enterprise Manager and SQL Query Analyzer.
• Export or Import data from other data sources like flat files using Import/Export through DTS, SSIS.

Environment: Windows 2003 Server, SQL server 2005/2000, Event Viewer, SQL Profiler, T-SQL.