SUMMARY

• Over 8 years of MS SQL Server DBA, Database Design, Development & Support of MS SQL Server 2000/2005/2008/2008 R2/2012 in Production, QA, Development Environments
• Expertise in Installation and troubleshooting of SQL Server on standalone as well as cluster environment and recommending pre - requisites for the configurations of installation setups.
• Experience in creating Users, Logins, Server Roles and assigning Permissions on Databases.
• Good Exposure in Handling In-Place and Side-By-Side Upgrades.
• Experience in applying patches and service packs to keep the database at current patch level.
• Extensive experience on maintaining High Availability by using the Failover Clustering, DB Mirroring and Log Shipping capabilities of MS SQL Server 2005/2008.
• Good Exposure in installing and troubleshooting SQL Server client tools.
• Experience in Normalization and Data Modeling including Logical and Physical Design of Databases.
• Upgraded SQL Server 2005 to SQL Server 2008 and SQL Server 2008 to SQL Server 2012.
• Hands on experience in creating and managing database objects.
• Expertise in troubleshooting issues with SQL Server Agent and scheduled maintenance tasks.
• Experience in creating Jobs, Alerts, SQL Mail and schedule DTS,SSIS Packages
• Having hands on experience in Database mail setup & Linked server issues.
• Expertise in troubleshooting import/export wizard issues and Migration advisor issues.
• Experience in Database Backup, Restoration and Disaster Recovery procedures.
• Experience in performing integrity checks using DBCC commands.
• Experience in troubleshooting SQL issues by using SQL Tools, SQL Profiler, and Performance Monitor, execution plan, statistics, index tuning wizard and Database tuning Advisor.
• Having good experience on handling Performance issues like handling 100% CPU issues, handling slow running queries, finding the bottleneck and recommending for better performance.
• Good experience in planning, implementing and maintaining replications.
• Handling issues with security and connectivity
• Having experience on setup and maintaining Mirroring and full-text search
• Strong Object Oriented Analysis, Design and Programming technical skills, ability to learn new emerging technologies and adapt quickly.
• Excellent communication, presentation, analytical and interpersonal skills.

TECHNICAL SKILLS

Database: MS SQL Server 2012/2008R 2/2008/2005/2000/7.0, Sybase, Oracle 10g

SQL Server Tools: SQL Server Management Studio, MS Visual Studio 2005/2008, SQL Server Profiler, System Performance Monitor, Enterprise Manager, Query Analyzer, DB Maintenance Plan Wizard, SQL Server Replication, DB Mirroring, Log Shipping, Bulk Insert, BCP, SSAS, Upgrade Advisor 2005.

Operating Systems: Windows 2008, 2003, 2000 Server, Windows 95/98/XP/Vista/7, DOS, UNIX, IIS

ETL Tools: SSIS, DTS, DTS Designer.

Reporting Tools: SSRS, Crystal Reports, MS Access

Languages: T-SQL, PL/SQL, VB.NET, ASP.NET,C#.NET, ADO.NET

Networking: TCP/IP, WAN, LAN, DNS, FTP

Script Languages: VB Script, JavaScript

Hardware: HP ProLiant DL580 G4, DELL, IBM Netfinity Servers, Intel x86, NT Servers

Other Tools: ERWIN 4.0, MS Office, SQL LiteSpeed, Performance Analysis, Spotlight, Outlook 2003/ 2007, Lotus Notes, Active Directory, WSRM

PROFESSIONAL EXPERIENCE

Confidential, Con Edison, NY

Sr. SQL Server DBA

Responsibilities:

• Installed/configured SQL server 2008/2012 on standalone and cluster environments.
• Migrated existing environments into SQL server 2008/2012.
• Worked on Performance tuning of the databases using PerfMon.
• Automated Database Administration tasks and systems health checks.
• Implemented Backup, Restore and Disaster Recovery procedures.
• Installing latest patches and brings the SQL Server to supportable build.
• Extensive experience working with backup/restore tools like SQL Litespeed, SQL safe.
• Experience in working with monitoring tools like SQL Profiler, System Monitor.
• Monitored and scheduled existing/new jobs on production environment.
• Implemented Replication and worked on troubleshooting Replication issues.
• Implemented and maintained LogShipping on critical production databases.
• Worked on virtualizing environments using tools like VMware.
• Implemented and proposed Security related configuration and best practices for SQL Server.
• Worked on Capacity planning of an OLTP and OLAP based environments.
• Worked on Linked Servers, and other Database objects.
• Responsible for change managements.
• Created documentation for SQL server & service packs installations.
• Used DBCC commands to check physical and logical consistency of the databases and Rebuild indexes.
• Experience in working with offshore teams.
• Provided 24/7 & weekend support being an on call DBA.

Environment: Windows 2008, Windows 2003, Windows 2000, Windows XP, SQL Server 2000, SQL Server 2005, SQL Server 2008, WSRM, Quest Litespeed, Spotlight, Performance Analysis, Clear Trace.

Confidential, Jacksonville, FL

Sr. SQL Server DBA

Responsibilities:

• All the responsibilities are related to SQL Server 2000, SQL Server 2005 of all versions and editions.
• Active telephonic support to the customers who have issues with SQL server database and other services related to SQL Server Engine.
• Installation/Un-installation issues of SQL Cluster and also configuration issues with the Cluster failover.
• Managing SQL Server tools like Enterprise Manager, Query Analyzer, Management Studio, SQL Profiler, SQL Browser, Import/Export Wizard, Upgrade Advisor, SQL Agent and Maintenance plans.
• Recommending issues of SQL Server configurations, administration, memory, and space management.
• Incorporated Security to the Database using the Encryption/Decryption, Certificates.
• Implemented Backup, Restore and Disaster Recovery procedures.
• Created DTS/SSIS Packages to pull data from Oracle, Sybase, MS Access and Flat files.
• Dealt with data corruption issues including Very Large User databases and System databases.
• Dealt with Server failures (crash dumps and server down) issues by analyzing the dumps and bringing back the servers online as soon as possible.
• Handling SQL Server performance issues like slow running queries, 100% CPU issues using several tools like SQL Profiler, Performance monitor and System Monitor.
• Dealt with issues like agent failures and performance with replication configuration & reconfiguration.
• Dealt issues like agent failures and synchronization issues with Log shipping configuration.
• Installation and configuration issues of SQL Server Reporting Services.
• Troubleshooting connectivity issues, security issues, recommending permissions, service account policy settings and Kerberos issues.

Environment: Windows 2003, Windows 2000, Windows XP, SQL Server 2000, SSRS, SSAS, SQL Server 2005, WSRM, Quest Litespeed, Spotlight, Performance Analysis, Clear Trace.

Confidential, PA

SQL Server DBA

Responsibilities:

• Worked on Migration of SQL Server 2000 instances to SQL Server 2005
• Maintained and created transactional replication.
• Created scripts to monitor the daily jobs like backup, maintenance plans and the maintenance of space for their respective servers
• Involved in Creating SSIS packages to integrate the data coming from various data sources.
• Generated the SSRS reports to analyze the disk usage and database size growth
• Involved in the Processing the SSAS Cubes, as per the requests
• Responsible for stored procedures optimization, performance tuning and index tuning
• Worked on deadlocks issues and minimizing the occurrence of these situations
• Worked on verifying proper transactional error handling on existing stored procedures
• Maintaining security permissions for the internal/external users of the respective databases & servers.
• Worked on various issues of performance and involved in mirroring architecture.
• Provided 24/7 & weekend support being an on call DBA.
• Installing latest patches and brings the SQL Server to supportable build.

Environment: MS SQL Server 2000, MS SQL Server 2005, Windows 2003 Server, SSRS, SSIS, DTS, SSAS, MS Visual studio 2005, T-SQL.

Confidential, PA

SQL Server DBA

Responsibilities:

• Installing all software upgrades for SQL Server.
• Identified and resolved the query performance using SQL Profiler and Index tuning wizard.
• Used Data Transformation Services (DTS) to populate data from various data sources.
• Research on upgrading the SQL Server from
• Research on database issues (specifically performance issues).
• Worked on Migration of SQL Server 2000 instances to SQL Server 2005.
• Involved in Creating SSIS packages to integrate the data coming from various data sources.
• Monitoring of database size, disk space in all (Production, Model & Development) the environments.
• Configured log shipping to create a stand by server for production server.
• Creating and monitoring all maintenance jobs (backups, integrity, optimization, etc.) on all databases.
• Creating, modifying and monitoring replication on all databases.
• Worked on upgrading DTS packages to SSIS packages.
• Maintaining security permissions for the internal/external users of the respective databases & servers.
• Worked on 24/7 shifts to monitor the servers and to assist the users.
• Management of SQL Servers, databases, storage management for databases sizing from 25GB to 40GB

Environment: MS SQL Server 2000, MS SQL Server 2005,SSAS, T-SQL, DTS, SSIS, SQL profiler, Windows 2000, Windows 2003 Server, Upgrade Advisor

Confidential, Memphis, TN

SQL Server DBA

Responsibilities:

• Responsible for 24/7 critical production supports.
• Responsible for General Database Administration and Performance
• Involved in migration from Oracle to SQL Server 2000
• Trouble shooting Problems by using SQL server profiler.
• Updating with latest service packs and security patches.
• Created views to facilitate easy user interface implementation, and triggers to enforce Data and referential integrity.
• Created indexed views in T-SQL to increase the query performance.
• Develop Backup & Restore scripts for SQL Server as needed.
• Created logical and physical data modeling for development database using ERWIN tool.
• Checking Space monitoring, Index Defrag, and Update Statistics
• Created Log Shipping between Primary production servers and Standby.
• Responsible for Design, Implementation and Performance Tuning of the databases.
• Creating Stored Procedures, Triggers, Functions, and Jobs for All Databases.
• Implementation and Administration of Data Replication and Disaster Recovery management Process
• Monitoring of user accounts, user permissions, table partitions and backup
• Creating, Upgrading of scripts for production Database and supporting it
• Data migration (import & export, DTS) from Text to SQL Server
• Scheduled Jobs, batch, alert and E-mail notification settings
• Used DBCC commands to check physical and logical consistency of the databases and Rebuild indexes.

Environment: Windows 2000, Windows 2003, SQL Server 2000, T-SQL, NT 4, ASP.NET, C#, UNIX, EXCEL, WORD, Active/Passive, NT Clustered Servers, DTS, SQL Profiler, ERWIN

Confidential, Baltimore, MD

SQL Server DBA

Responsibilities:

• Created and maintained various databases for development and testing environment using SQL server 2000.
• Installed, configured and maintained 2 fail over clusters in production environment.
• Performed daily backups and developed recovery procedures.
• Worked with developers to tune the queries, run scripts and move the database production to development servers.
• Created logical and physical data modeling for development database using ERWIN tool.
• Creation of schema objects, rules and granting of roles to the users.
• Worked and coordinated with developers in writing and tuning new stored procedures.
• Worked on DTS packages to import the data from Oracle, Access and text files.
• Responsible for stored procedures optimization, performance tuning and index tuning.
• Scheduling transfer of backups and log files to different servers.
• Provided a support for data issues and given appropriate solutions.
• Responsible for change managements, created the documentation for SQL server and service packs installations.

Environment: MS SQL Server 2000, Windows 2000 Advance Server, ASP 3.0, Visual Basic 6.0, XML, VFP 7.0, XML.

Confidential

SQL DBA/ Developer

Responsibilities:

• Installation, configuration the MS SQL Server 6.5 and maintenance of servers in various environments.
• Data Transfers between various servers using BCP and Managing Disk space on NT systems
• Scripting the Database Consistency Checks (DBCC), scheduling the scripts to run daily and weekly basis.
• Complete automating on NT so that the tasks are run without user monitoring.
• Develop and maintain in-house utilities to automate problem determination, change implementation and monitoring activities.
• Administrative and Production support for various applications in all environments.
• Database Backup Procedures, Restoration Procedures, Disaster Recovery procedures and Contingency plans. Testing and implementing these procedures.

Environment: SQL Server 2000, Query Analyzer, SQL Profiler, Windows 2000 Server, Import & Export Data.