• 7 plus years of IT experience in Microsoft Database Technologies with various Industries like Financing, Manufacturing, Media and Hospitality as a SQL Server DBA in MS SQL SERVER 2012/2008R2/2008/2005/2000 Database Administration DBA in Windows environment.
• Extensive knowledge of Relational Database Management Systems RDBMS and Installation, management and administration of SQL server.
• Experience with installation and configuration of clustered servers in Active/Active and Active/Passive environments as a high availability solution.
• Expertise in configuring and managing different topologies of replication models Snapshot, Transactional replication, Merge and Peer-To-Peer replication.
• Experience and knowledge in configuring and managing Database Mirroring.
• Successfully tested and implemented Log Shipping Technique used for warm solution for MS SQL Server 2000/2005/2008/2012 databases.
• Experience in upgrading migration MS SQL Server 2000 to MS SQL Server 2005/2008, SQL 2005to SQL 2008/2008R2, SQL 2008R2 to SQL 2012.
• Expertise in deciding backup strategies for new applications.
• Experience in database administration activities like Installation, Configuration, Database design, Performance tuning and Query Optimization, Data Transformation Services, and Database Security.
• Experience in using SQL server native tools like SQL Profiler, Server side Traces, Windows Performance Monitor counters and Activity monitor for monitoring and tuning purposes.
• Experienced in creating Indexes, managing and monitoring indexes, fragmentation, re-indexing and tuning indexes.
• Creating Jobs, alerts and schedules with the use of SQL Server agent and notification using Database Mail.
• Extensive experience in Capacity planning for new applications.
• Implemented policy based management to apply polices.
• Creation and maintenance of databases, creating roles and managing users.
• Experience in implementing database consistency checks using DBCC utilities and worked with DMV's.
• Experience in identifying locking, blocking and dead lock issues and resolving them.
• Experience in working high transacted OLTP systems.
• Experience in creating and optimizing Stored Procedures, T-SQL queries.
• Experience in creating DTS packages, jobs, sending alerts using SQL mail and customized extended procedures.
• Experience in migration of Data from Excel, Flat file, Oracle to MS SQL Server by using Bulk Copy Programand SSIS.
• Experience in generating reports using Business Objects and SQL Server Reporting Services SSRS .
• Worked with third party monitoring tools like Idera's Diagnostic Manager, SQL Litespeed, RedgateSQL Compare/Data Compare, SQL Multiscript,Spotlight, Frontrange, Foglight, EM7, Opsware, ServiceNow and JIRA.
• Worked on Always ON features of SQL server 2012.
• Experience in providing 24 x 7 production support.

Confidential

MS SQL Server DBA

Responsibilities:

• Experience in managing/troubleshooting/installing multiple two node failover cluster, Active/Passive for SQL server 2005/2008/2008R2.
• Configuring/managing merge, transaction, snapshot and peer-to-peer replication configure central publisher/distributor, configure/manage publications, configure/manage subscribers, resolving conflicts and other complex replication issues
• Implemented mirroring as a DR solution in some of the legacy servers.
• Troubleshooting day to day production issues, performance tuning and optimization. Managing assigned servers monitoring infrastructure jobs - backup, integrity check, and optimization.
• Managing request queue, Interacting with application teams and working through the issues faced by users.
• Managing weekly project release in different environments.
• Support DBA for tier 1 mission critical application - building new servers, loads testing, performance tuning and optimization, troubleshooting.
• Troubleshoot production server issues priority 3 and priority 4 on day to day basis.
• Actively working as application DBA and provides training, evaluating, and working on day to day basis for SQL related issues.
• Designing and implemented appropriate backup/restore strategy.
• Working with locking, blocking and dead locking issues on daily bases and resolving them.
• Working on third party tool like SQL compare to compare data between tables from different environments.
• Created Jobs, alerts and schedules with the use of SQL Server agent and notification using Database Mail.
• Actively involved in development of automated daily, weekly and monthly maintenance tasks such as backups, verifying database integrity and re-build/re-org indexes etc.
• Review and implementing scripts changes to pre-production servers and production servers.
• Implemented policy based management and applied policies.
• Resolving issues related to query optimization, database optimization and index tuning by checking most expensive queries and TempDB configuration.
• Monitoring database performance by setting up alerts from SpotLightand EM7 tools.
• Created and Scheduled SSIS Packages for importing and exporting data to data warehouse.
• Conducting the root cause analysis of application availability and narrow down to issues related to coding practices, database bottlenecks, or network latency.
• Providing 24x7 production supports.

Environment:

1. SQL Server 2012/2008R2/2008/2005/2000,SpotLight, ServiceNow and JIRA ticketing system, Windows server 2012, Windows Server 2008/2008R2, Windows Server 2003, Profiler, and Activity monitor, EM7, SQL Multiscript, Opsware.

Confidential

MS SQL Server DBA

Responsibilities:

• Upgraded/Migrated databases from SQL 2000 to SQL 2005/2008 and SQL 2005 to SQL 2008/2008R2.
• Active involvement in installing and managing multiple 2 node failover cluster set up in active passive environment as a 'High Availability' mechanism to avoid downtime because of unintentional/ intentional/ shutdown of primary server.
• Implemented Log shipping as a DR solution.
• Project DBA for two projects related to Tier 2 application. Activities Installing/configuring SQL server, patching, performance tuning, and support.
• One of the important task was to review and make sure database security is intact and within the policies of the organization.
• Primary DBA for various assigned servers in development/test/pre-production/production environments. Activities - Keep a check on daily infrastructure jobs, troubleshooting failed infrastructure jobs, intermittent and periodic maintenance tasks, prepare daily/weekly/monthly checklist.
• Optimization and Performance tuning using Idera's SQL Diagnostic Manager, SQL Profiler, Performance Monitor. Also involves stored proc optimization, query optimization, index optimization.
• Support and set up environment with transactional replication configuring central publisher/distributor, managing publication, managing subscription, implementing changes and troubleshooting .
• Promoted new databases from one environment to another and make sure that requirements and policies of team are met by application team using Regate SQL compare and SQL Server Management Studio.
• Actively involved in capacity planning/requirement analysis.
• Troubleshoot production server issues priority 3 and priority 4 on day to day basis.
• Review and implement changes to Pre-Production servers and Production servers.
• Provided 24 X 7 Support for production environment.

Environment:

1. MS SQL Server 2008/2005/2000, MS Windows server 2003/2008/2008R2, Idera's SQL Diagnostic Manager, SQL Safe, SQL Litespeed, SQL Nexus.

Confidential

MS SQL Server DBA

Responsibilities:

• Involved in upgrading the instance of SQL Server 2000 to SQL Server 2005.
• Reviewed security consideration for SQL Server 2005 installation.
• Implemented Database Mirroring for maintain a 'Hot Standby' for a critical operational database and also used the same as a mechanism for fault tolerance.
• Prepared documentation on Capacity planning of all servers and made recommendations.
• Used SQL Server Management Studio SSMS for monitoring, troubleshooting and addressing database related issues.
• Used Idera's Diagnostic Manager and Performance monitor for monitoring SQL Server.
• Solved issues related to server performance and disk space.
• Resolved issues related to query optimization, database optimization and index tuning.
• Resolved Deadlocking, Blocking and locking issues by creating a trace using SQL Profiler and also by using Idera's Diagnostic Manager. Arrived at a conclusion and provided detailed information and analysis to the application members. Provided feedbacks and recommendations of how they can prevent the same in future.
• Resolved issues related to long running queries.
• Test and implement backup strategies. Good knowledge in SQL Litespeed a backup solution for MS SQL Server.
• Backup and Restore databases in SQL 2005 for maintaining stand by server.
• Migrated DTS packages to SSIS packages using ETL tool Business Intelligence Development Studio
• Extensively documented all the databases, database objects, jobs and the changes made to the database.
• Documentation and Automation of various database related procedures.
• Created Linked Servers to move data from one server to another.
• Generated Simple Reports, Parameterized Reports using SSRS Reporting Services .

Environment:

• Windows 2003 Advanced Server, Windows Server 2008 EE, MS SQL Server 2008/2005/2000, SQL Litespeed, Idera's SQL Diagnostic Manager