SUMMARY:

• Over (6+) Six Plus years of hands - on experience as an SQL Server DBA (2008R2, 2008, 2005,2000) in Production, Development and Staging Environments.
• Experience with Installation and Configuration of MS SQL Server 2008R2/2008/2005/2000.
• Experience in planning and implementation of MSSQL Server Security and Database permissions.
• Experience with Database Backup, Recovery and Disaster Recovery Procedures.
• Solid experience and outstanding knowledge of high availability SQL Server solutions including Mirroring, Log shipping, Replication.
• Knowledge of Relational Database Management Systems and Database Design.
• Experience in implementing different types of Replication Models such as Transactional, Snapshot and Merge in SQL Server 2008/2005 in OLTP environments.
• Experience in Migration from SQL Server 2000 to SQL Server 2005 and from SQL Server 2005 to 2008.
• Migrated data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) and SQL Server Integration Services (SSIS).
• Experience with Database Performance Tuning, Query Optimization, Client / Server Connectivity / Network Issues, Named Pipes, TCP/IP Protocols, Troubleshooting, Database consistency checks using DBCC Utilities.
• Experience in Tuning T-SQL queries & improving the performance of the Database
• Experience in writing and debugging Stored Procedures, Functions and Triggers.
• Good Experience in Database/schema design and efficiently used DDL and DML structures to manipulate tables of databases.
• Good knowledge of RAID systems.
• Experience in using Performance Monitor, SQL Profiler and Database Tuning Advisor to solve Dead Locks / long running queries.
• Experience in investigating and applying necessary SQL Server database patches and installing service packs.
• Well experienced in scheduling SQL Server Jobs, Maintenance plans and executing them.
• Experience in using tools like Idera for monitoring performance.
• Good understanding of Normalization /De-normalization and the database design methodology.
• Experience in configuration and management of Linked Servers for data transfer between SQL Server and other heterogeneous relational databases such as Oracle, MySQL and DB2.
• Knowledge on SAN (EMC, IBM and HP Arrays) for SQL Server Databases and good understanding in capacity planning.
• Knowledge in monitoring tools like SCOM.
• Extensive experience with Table Design, Index Design and SQL 2005 Online Indexing.
• Experience in Development, Analysis, Requirement Analysis, Scope definition & controlling, Experience in debugging and optimizing Triggers, Views, Functions, T-SQL queries and Stored procedures.
• Experience in maintaining and resolving issues in SQL Server Clustering and worked on Active-Active Clustering.
• Extensive experience in creating multiple reports (SSRS) in Drill mode using tables, financial tables, crosses tabs and charts.
• Good team player, strong interpersonal and communication skills combined with self-motivation, initiative and the ability to think outside the box.

TECHNICALS SKILLS:

Operating Systems: Windows 2000/XP/2000/2003/2008

Databases: MS SQL Server 2008/2005/2000, MS Access 2007

Database Tools: SSMS (SQL Server Management Studio), SQL Server Enterprise Manager, SQL Profiler, Query Analyzer, Index Analyzer, SQL Agents, SQL Alerts, SQL Jobs, SQL Mail, SQL Client Configuration utility, Backup and Restore, Replication, Log Shipping, SSAS

ETL Tools: DTS (Data transformation services), SSIS (SQL Server Integration Services)

Development skills: SQL, Transact SQL (T-SQL)

Languages: C, C++, HTML, VBScript

Reporting Tools: Crystal Reports 11.0, SSRS (SQL Server Reporting Services)

Application Packages: Microsoft Office Suite 2007, VMware

PROFESSIONAL EXPERIENCE

Confidential, Jersey City, NJ

SQL Server DBA

Responsibilities:

• Responsible for the Installation, Daily monitoring, Maintenance of SQL Server 2008R2/2008/2005 installations in both the Production and Development Environments and also upgrades to SQL server 2005.
• Involved in the configuration of new SQL Server Instances on Windows servers with appropriate parameters.
• Participated in the Migration of the databases and managed the location of database files, log files and their sizes.
• Migrated and validated users and logins in the new environment.
• Installed and Configure SQL 2008, SQL 2008 Active-Active Cluster on Windows 2008 production servers.
• Granted roles and permissions to SQL server users.
• Developed, implemented, and maintained policies and procedures for ensuring the security and integrity of SQL Server 2008/2005 and the corresponding databases
• Created Maintenance plans, Scheduled Jobs and SSIS packages.
• Monitored and tuned databases to meet the performance and availability requirements of on-line systems and multiple applications.
• Created tables, views, indexes, functions and advanced queries for databases by using SSMS.
• Generated database SQL scripts and deployed databases including installation and configuration.
• Automated and enhanced daily administrative tasks including space management, database backup and recovery.
• Involved in setting up SQL Server Agent Jobs for periodic Backups with backup devices, Database maintenance Plans and recovery.
• Resolved database performance issues (IO saturation, disk bottleneck, network bottleneck, etc…), database capacity issues, replication, and other distributed data issues.
• Configured and maintained Transactional, Snapshot and Merge Replications.
• Performed Log shipping to a standby server to safeguard valuable data.
• Used Database Mirroring for increasing database availability.
• Modified and optimized complex queries for data retrieval and modification.
• Managed the production and development databases for performance tuning, capacity planning and SQL Server clustering and database security configuration.
• Scheduled and monitored all maintenance activities of SQL Server 2008/2005 including database consistency check, and index defragmentation.
• Monitored database status including CPU, memory, I/O, space, and deadlocks using SQL Server utilities.
• Performed Root cause analysis to track down problems and used SQL profiler for troubleshooting.
• Created custom Reports using SSRS.
• Created alerts, notifications, and emails for system errors, insufficient resources, fatal database errors, hardware errors, and security breaches.

Environment: MS SQL Server 2008R2/2008/ 2005 Enterprise Edition, SQL Server Management Studio, SQL Profiler, SSIS, SSAS, T-SQL, MS Office 2003, Crystal reports 11.0, Windows Server 2003

Confidential, Philadelphia, PA

SQL Server DBA

Responsibilities:

• Installed, configured and administered SQL Server 2008/2005.
• Gathered client’s requirements and came up with database design and application architecture
• Created new databases, tables, views, indexes etc.
• Supported the company’s SQL Server Databases by performing troubleshooting, performance tuning, security planning, index tuning, monitoring critical events, database migrations and creating documentation for production systems.
• Running various DBCC commands for administration of database objects and system performance.
• Performed Database backups- Full, Differential and Transaction log
• Performed Database Mirroring in SQL Server 2008
• Implemented Log Shipping to protect and safeguard sensitive data
• Administered database (Transactional, Merge, Snapshot) between SQL Server databases
• Implemented Transactional Replication for real time reports on the Report Server(Database Server as Publisher & Distributor and Reporting Server as a Subscriber)
• Performed Troubleshooting and performance tuning
• Involved in using DB Tools like Idera.
• Perform Backup and Restore operations using Idera SQL Safe during off-hours for the Development team.
• Migrated data from legacy systems to SQL Server 2008/2005 using SSIS, DTS Packages and Bulk Inserts and also defined and scheduled several DTS packages to move data between servers
• Strategically set up nightly backup Maintenance jobs.
• Extensively used SQL profiler for troubleshooting actions
• Maintenance of SQL Server for obtaining maximum performance
• Generated reports using SQL Server Reporting Services
• Was the member of a team formed to provide 24X7 support

Environment: MS SQL Server 2008R2/2008/ 2005, SQL Server Management Studio, SSIS, SSRS, T-SQL, CA Erwin data modeler r7.0, MS Visio 11.0, Windows Server 2008/2003/XP.

Confidential, Cleveland, OH

SQL Server DBA/ Developer

Responsibilities:

• Installed and configured multiple SQL Server Instances of 2005.
• Performed regular Backups and Restores.
• Monitored the growth of the database objects for capacity planning.
• Performed Log Shipping to a standby server.
• Scheduled various jobs and created new alerts for reporting errors.
• Performed Data Migration using DTS and BCP from flat files to SQL Server 2005.
• Created complex stored procedures and functions to support efficient data storage and manipulation.
• Implemented Triggers and Stored Procedures to capture updated and deleted data from OLTP systems.
• Defined constraints, rules and defaults.
• Created DTS packages to pull data from Oracle and Flat Files.
• Worked on DTS Package, DTS Import/Export for transferring data from Database.
• Created and implemented views to assist the front-end developer in the easier implementation on the web pages, and triggers on those views to provide efficient data manipulation.
• Optimized the performance of queries by undertaking certain modifications in the index system
• Regularly monitored the system for bottlenecks (CPU, RAM, Disk IO and Networking).
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Participated in testing and debugging for the system.
• Documented all processes involved in maintaining the database for future reference.

Environment: MS SQL Server 2005/2000 Enterprise Edition, Enterprise Manager, Query Analyzer, DTS, Adobe Dreamweaver 7.0, IIS 6.0, Windows Server 2003/2000.

Confidential

Jr.SQL DBA

Responsibilities:

• Performed Installations and configuration of SQL server 2005/2000 and upgraded SQL server installations wherever necessary.
• Created new tables, indexes, triggers, static/dynamic stored procedures, and some user defined functions.
• Involved in the gathering and analysis of the end user requirements.
• Worked on DTS Packages, and used DTS Import/Export to transfer data between various SQL Server instances.
• Performed Backup and Restore operations.
• Carried out Performance tuning and troubleshooting of SQL queries and stored procedures using SQL Profiler, Query Plan (Graphical and Textual) and Statistics I/O
• Transferred data from various heterogeneous data sources like Excel, Fixed Width Flat Files, and MS Access to SQL Server 2000
• Involved in generating reports using crystal reports.

Environment: MS SQL Server 2005/2000 Enterprise Edition, Enterprise manager, Query analyzer, VB script, DTS, Crystal reports, Windows server 2003/2000.