SUMMARY

• 7 plus years of IT experience in Microsoft Database Technologies with various Industries like Financing, Manufacturing and Hospitality as a SQL Server DBA in MS SQL SERVER 2008R 2/ 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.
• 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 databases.
• Experience in configuring and managing different types of replication models; Snapshot, and Transactional replication.
• Experience in upgrading (migration) MS SQL Server 2000 to MS SQL Server 2005/2008, SQL 2005 to SQL 2008/2008R2.
• 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, 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 Program and 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 Lite speed, Redgate SQL Compare, Spotlight, Frontrange
• Knowledge of new features in SQL server 2012.
• Experience in providing 24 x 7 production support.

TECHNICAL SKILLS

Operating Systems: Windows Server 2008/2008R2, Windows Server 2003

Languages: C, C++, T-SQL

RDBMS: MS SQL Server 2008R2/2008, 2005, 2000, MS Access 2000, 2003

SQL Server Tools: SSMS, SQL Server Profiler, SSIS, Query analyzer, Activity monitor

Third party Tools: Idera’s SQL Diagnostic Manager, SQL Lite Speed, SQL Delta compare, Beyond comparator, Fog light

PROFESSIONAL EXPERIENCE

Confidential, Elmwood Park, NJ

MS SQL Server DBA

Responsibilities:

• Experience in managing/troubleshooting/installing multiple two node failover cluster, Active/Passive for SQL server 2005/2008/2008 R2.
• Implemented mirroring as a DR solution.
• Configured/managed transactional replication (configure central publisher/distributor, configure/manage publications, configure/manage subscribers)
• 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.
• Support DBA for tier 1 mission critical application - building new servers, loads testing, performance tuning and optimization, troubleshooting.
• Actively worked as application DBA provide training, evaluating, and working on day to day basis for SQL related issues.
• Designed and implemented appropriate backup/restore strategy.
• Identified locking, blocking and dead locking issues and resolved them.
• Worked on third party tool like SQL delta 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 etc.
• Implemented policy based management and applied policies.
• Resolved issues related to query optimization, database optimization and index tuning.
• Monitored the database and alerts from Fog light tool.
• 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.
• Provided 24x7 production supports.

Environment: SQL Server 2008R 2/ 2008/2005/2000 , fog light, Remedy ticketing system, Windows Server 2008/2008R2, Windows Server 2003, Profiler, Activity monitor.

Confidential, New Albany, OH

MS SQL Server DBA

Responsibilities:

• Upgrading/Migrating the 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).
• Promoting 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.
• Providing 24 X 7 Support for production environment.

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

Confidential, New York, NY

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

Confidential, Englewood, Colorado

MS SQL Server DBA

Responsibilities:

• Installation and Configuration of SQL Server 2005 and 2008.
• Review / test / apply all database changes to all environments including QA, Development and Production Servers. Monitor SQL Error Logs, Schedule Tasks, database activity, eliminate Blocking & deadlocks, user counts and connections/locks etc.
• Created and managed Users/Logins.
• Worked with SQL server Profiler to generate traces.
• Actively participated in Logical design phase of new database. Worked on MS Visual Studio to draw data model.
• Solved issues related to server performance and disk space.
• Resolved issues related to query optimization, database optimization and index tuning.
• Monitored the database and alerts from Foglight application
• Creating and managing schema objects such as tables, views, clusters, indexes, procedures, triggers & maintaining Referential Integrity.
• Server & Application fine-tuning & trouble shooting. Monitoring MS SQL Server performance and network issues.
• Administering the MS SQL Server by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.
• Configured Log shipping from one production server to the reporting server.
• Implemented built in log shipping with SQL Server 2000 for disaster recovery server.
• Creating the Packages for running the jobs automatically
• Good in Implementing SQL Server security and process control
• Implemented and documented proactive monitoring scripts for production databases.
• Develop the reports for business users using Crystal Reports.

Environment: MS SQL Server 2000, MS SQL 2005, Visual studio.net, Windows 2000 server, HP net server LP1000r servers, Crystal Report 8.0.

Confidential

SQL Server DBA/Developer

Responsibilities:

• Administered Backup and Recovery.
• Monitor production Server activity.
• Develop MS SQL Server Log Shipping plans Disaster recovery plans and apply on production servers.
• Installing SQL Server service packs based on the errors and flaws that are found in the application.
• Resolving locking and blocking issues.
• Implemented change control.
• Enhanced performance by reviewing disk configuration and storage allocation.
• Reviewed third party tool (idera) so as to help automate routine tasks such as monitoring, blocking and consolidate status of scheduled jobs.
• Administering the MS SQL Server by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.
• Monitored SQL Server logs, Application logs and analyzed the logs.
• Documented disaster recovery plans and participated disaster recovery drills.
• Conducting the root cause analysis of application availability and narrow down to issues related to coding practices, database bottlenecks, or network latency.
• Wrote, Tested and Documented Program code and implemented program.
• Implemented OLAP cubes with MS Analysis Services

Environment: MS SQL Server 2000 & 2005, Windows 2003 advance server, Dell power edge 6650 database server.

Confidential

SQL Server DBA/Developer

Responsibilities:

• Administered the SQL Servers and the databases.
• Created the MS DTS Packages for executing the required tasks. Created jobs and scheduled for daily running.
• Implemented and maintaineddatabase security.
• Administrator tasks likemanaging users, roles, and profiles.
• Performed Database backups (operating system, flat file backups & export/import).
• UsedSnapshot replicationfor creating multiple instances of a database for distributing the workload.
• Tuned SQL statements and SQL Procedures.
• Combined a few simple, unrelated Database Accesses to improve performance.
• UsedQuery Analyzertooptimize SQL Queries.
• Maintained the physical Databases bymonitoring Performance, Space utilization and Physical integrity.
• Coded Procedures & User defined Functions in TSQL.
• Established and documented a completeDisaster Recovery Planfor the Database servers.
• Daily monitoring of thedatabase performanceand network issues.
• Rebuilding indexeson various tables on regular basis.

Environment: MS SQL Server 2000, Visual Basic.net, Windows 2000 advance server