SUMMARY

• Over 10 years of in - depth experience in database architecture, design, development, administration, and maintenance of SQL Server 2012, 2008R / 2000 large scale databases
• Involved in all the phases of software development life cycle SDLC process (Design, Development and Unit Testing, System Integration Testing and Functional Testing)
• Experience in database server performance tuning and optimization of Complex SQL queries
• Experience with SQL Server and T-SQL in constructing triggers, tables, user defined functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity
• Experience in Upgrade/Migration of MS SQL Server 2008 databases to MS SQL Server 2012
• Experience in distributed systems and high availability data server, data modeling, SQL and stored procedure development· DTS (2000), SSIS replication design & implementation, build and support
• Experience in deploying High Availability solutions in SQL 2012
• Experience and outstanding knowledge of high availability SQL Server solutions, including Log shipping, Replication and SQL Server clustering
• Knowledge of Normalization and Relational Database Management Systems
• Experience with Monitoring, tuning and analyzing DB performance and allocating server resources to achieve optimum DB performance
• Excellent Interpersonal, Management and Communication skills with ability to deliver quality results with minimum supervision

TECHNICAL SKILLS

Databases: MS SQL Server 2000/2005/2008/2008 R2/2012

Database Utilities: SQL Profiler, SQL Query Analyzer, Index Analyzer, SQL Agent, SQL Alerts, SQL Jobs, Replication Tools

Computer Languages: T-SQL, C, C++, Java, Visual Basic, .NET

Web Technologies: HTML, XML, VBScript, IIS (7.0)

Operating Systems: Windows (XP, NT, Vista, 7), LINUX

Project Utilities: MS Project, MS Office, Visio, Crystal Reports

PROFESSIONAL EXPERIENCE

Confidential, Montvale, NJ

SQL Server DBA

Environment: Windows Server 2008 R2, SQL Server 2008 R2, SQL Server 2012

Responsibilities:

• Involved in design and architecture of Database server hardware.
• Involved in installation and configuration of SQL Server 2008 R2 and SQL Server 2012 servers.
• Configured SQL Server Mirroring for High Availability across all production servers in SQL Server 2008 R2.
• Configured Log shipping from production servers to DR servers.
• Involved in migration of databases from SQL Server 2008 R2 to SQL Server 2012.
• Implemented High Availability in SQL 2012 by configuring AlwaysOn Availability groups across Windows Server Failover Clusters using Failover Cluster Instances.
• Configured transactional replication to publish data to multiple subscribers.
• Implemented Management Data Warehouse (MDW) by configuring Data Collectors across several instances.
• Used MDW extensively to check server activity, query statistics, blocking statistics.
• Used DMV’s to diagnose problems and monitor health of server instance.
• Used SQL server Profiler to identify and analyze deadlocks.
• Worked extensively in performance tuning of databases including query tuning, server tuning.
• Created and scheduled maintenance plans for Database backups, log backups and cleanup.

Confidential, Pittsburgh, PA

SQL Server DBA

Environment: Windows Server 2003, 2008, 2008 R2; SQL Server 2005, 2008 R2

Responsibilities:

• Experience in installing and configuring Windows and SQL clusters including 3 node clusters, 4 node clusters, and adding a node to an existing cluster.
• Involved in the migration of databases from SQL server 2005 to SQL server 2008 R2.
• Implemented and configured Central Management Servers to centralize and manage about 30 instances of SQL Server 2008 R2 and SQL 2005.
• Implemented Data Collector and Data Management Warehouse to collect performance data of all the SQL instances.
• Configured Policy Based Management for a number of business scenarios.
• Enabled Transparent Data Encryption on critical databases.
• Identified, tested and resolved database performance issues (monitoring and tuning) to ensure database optimization.
• Developed, modified, and optimized complex stored procedures, triggers to handle complex business rules, history data and audit analysis.
• Designed and developed tables, and stored procedures and performed data imports and restores for successful migration.
• Configured Transactional Replication and Log Shipping with SQL Server Management Studio as well as basic account management and troubleshooting with connectivity, security and firewall issues.
• Configured SSRS using configuration manager, created and maintained security roles and created new reports.
• Deployed SSAS cubes to the server and created security roles.
• Created and scheduled maintenance plans (database and log backups and cleanups).
• Used server scoped DMV’s and database scoped DMV’s to trouble shoot issues.
• Identified and analyzed deadlocks in databases using SQL Server Profiler.
• Designed SQL SSIS Packages in Business Intelligence Development Studio (BIDS.
• Created monitoring scripts to alert for production issues.

Confidential, Crown Point, IN

SQL Server DBA

Environment: Windows Server 2003, SQL Server 2005/2008

Responsibilities:

• Involved in the upgrade of databases from SQL server 2000 to SQL server 2005.
• Involved in capacity planning, sizing and database growth projections.
• Responsible for performance tuning, optimizing the queries, removing redundant and inconsistent data, joins from the database tables and normalizing them
• Used Data Transformation Services (DTS)/SQL Server Integration Services (SSIS) and Extract Transform Loading (ETL) tool of SQL Server to populate data from various data sources, creating packages for different data loading operations for application.
• Created and monitored of all SQL tasks (SSIS Packages) and scheduled daily jobs using Agent Scheduler through SQL Server Management Studio. Includes implementation of necessary batch processes for periodic updates.
• Implemented Active/Passive clustering as part of High Availability strategy.
• Actively involved in the user requirements analysis
• Scheduled full and transactional log database backups in the production environment using the database maintenance plan wizard.
• Setup backup and restoration jobs for development and QA environments.
• Created transactional replication for the reporting applications.
• Setup database maintenance plans to reorganize indexes, re-indexing and update the index statistics on the production databases.
• Used system monitor to find the bottlenecks in CPU, disk I/O and memory devices and improved the database server performance.
• Used SQL Server Profiler to monitor and record database activities of particular users and applications.
• Used DBCC commands to troubleshoot issues related to database consistency.
• Used index tuning wizard to redesign and created the indexes for better performance.
• Fine tuned stored procedures using Execution plan in T-SQL for better performance.
• Worked on upgrading DTS packages to SSIS packages.
• Implemented trigger and stored procedures and enforced business rules via checks and constraints.
• Involved in documentation for the project

Confidential, Streetsboro, OH

SQL Server DBA

Environment: Windows Server 2003, SQL Server 2005, SQL Server 2000, T-SQL, Reporting Services

Responsibilities:

• Developed and modified database objects in accordance with gathered requirements.
• Troubleshoot problems by using SQL Server profiler.
• 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.
• Developed backup and restore scripts for SQL server as needed.
• Created Sales, Inventory, orders and other reports using SQL Server Reporting services.
• Performed regular DBCC checks to ensure the physical consistency of the database and objects.
• Performed regular backup and maintenance of the databases.
• Enhanced the features of the project based on client requirements.
• Provided guidelines and mentoring to other development staff on best practices.
• Updated SQL Server 2000 with latest service packs and security patches.

Confidential, Iselin, NJ

SQL Server Developer/DBA

Environment: Windows Server 2003, SQL Server 2000, T-SQL

Responsibilities:

• Involved as part of a team in designing the logical and physical database model
• Worked with BCP and DTS to load the data into the database
• Written stored procedures for Automatic Scripting to backup transaction logs, flush/grow/shrink log files, maintain archive of objects and so on
• Responsible for performance tuning, optimizing the queries (TSQL statements), removing redundant and inconsistent data, joins from the database tables and normalizing them
• Rewrote TSQL queries, removed unwanted columns, established joins and created indexes wherever necessary
• Prepared documentation/scripts for tables, stored procedures, DTS tasks and comprehensive commenting of all codes. Maintained technical documentation for operational support