SUMMARY

• 8+ Years of experience shipping highly available and scalable applications using Microsoft technologies
• Expert in the database modeling, design, development, maintenance and administration
• Primary database technologies: Microsoft SQL Server
• Experience includes System analysis and design, development, support on systems built on MS SQL Servers 2000/2005 and 2008 R2
• Extensively used tools like SQL Profiler, Index Tuning Wizard, and Windows Performance Monitor for monitoring and tuning MS SQL Server performance.
• Excellent skills in database Backup, Restoration, Recovery, Replication, Mirroring, Linked Servers, Database Maintenance Planning.
• Excellent SQL Server administration skills including user authorizations, Database creation, Tables, indexes creation.
• Strong T - SQL Developer skills including stored procedures, Indexed views, User Defined Functions (UDL), Triggers, and Distributed Queries and Common Table Expressions.
• Experience migrating data from one server to another server by In-place upgrade process and as well as side-by-side upgrade process.
• Extensively Worked on Transactional Replication, Snapshot Replication, Merge Replication, and Log shipping for SQL Server High Availability
• Dexterous developer in creating Constraints, Defaults, Rules, Tables, Indexes, Views, Stored Procedures, Functions, Triggers, Cursors and Dynamic sql queries
• Implemented the SQL Server concepts like Data partitioning, Snap shot Isolation, Database Mirroring, Database Snapshot, DDL triggers, try-cache blocks, Online indexing, DMV's, DMF's, SQLCMD and dedicated admin connection.
• Experienced in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using DBCC Utilities and DMVs and DMFs.
• Good at SQL Server 2008 new features like Policy Based Management, Data Compression, Resource Governor, Performance Data Collector and Transparent Data Encryption (TDE).
• Proficiency in implementing different types of disaster recovery scenarios like Replication models like Snapshot, transactional, log shipping and Configure Database Mirroring in Cluster Environment.
• Proficient in high level design of ETL, DTS and SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, etc.)
• Created Linked Servers between SQL Server 2000 & Oracle 9i and 10g. Also created DTS package for data transfer between the two environments.
• Closely worked with development team to assist them in various problems solving and troubleshooting Web-based applications, which calls various Database objects like stored procedures, functions, and triggers.

TECHNICAL SKILLS

Databases: MS SQL Server 7.0/ 2000/2005/2008 /2008 R2/2012, Access.

Database tools: Management Studio, Enterprise Manager, Query Analyzer, SQL Profiler, Data Transformation Services, Upgrade Wizard, Replication.

Programming languages: SQL, TSQL, XML, C.

Tools: SQL DB Access, Performance Monitor, Backup Utility, Net Backup, Data Stage 5.0.

Operating Systems: Windows 95/98/Me/XP/NT/2000, Windows Server 2003 /2008/2012.

PROFESSIONAL EXPERIENCE

Sr. SQL DBA

Confidential, Charlestown, MA

Environment: SQL Server 2012/2014, SSIS, Data warehouse, 64 bit, Perfmon, SQL Profiler, DTA, DMVs.

Responsibilities:

• Applied Normalization and denormalization rules for database design.
• Captured perfmon metrics to baseline and benchmarking system performance.
• Analyzed perfmon metrics to find Memory, I/O and CPU Bottlenecks.
• Worked with environment with heavy loads (50 Million records per DB) and reads.
• Gathered long running queries and wait stats information to tune queries.
• Dropped unnecessary Indexes and created new and covering Indexes and consolidated Indexes.
• Expert in choosing partition column, Clustered Index and Non-clustered Index based on the work load.
• Implemented table partitioning and file groups to distribute the 2.5 TB space from single file to Multiple Files and File Groups.
• Created Indexed views to improve performance of the reporting queries.
• Worked closely with all the teams to gather bad performing queries and rewrite the queries.
• Recommended change of schema design and data type changes to improve performance and to save disk space.

Sr. Database Administrator

Confidential, Boston, MA

Environment: SQL Server 2000/2005/2008 /2008 R2/2012, replication, Always On, windows 2000/2003/2008 R2/2012, 64 bit, SQL profiler, performance monitor, SSIS, Data stage 5.0 11.0, Access 2007/2010.

Responsibilities:

• Managing and administering SQL Server 2000/2005/2008 R2/2012 production and non-production servers.
• Working closely with different teams to gather and understand the database requirement, setting up of new databases in both development and production environments and coordinating with the clients for enhancements.
• Migrating SQL 2008 R2 to SQL 2012, SQL 2005 to SQL 2008 R2, SQL Server 2000 to SQL Server 2005.
• Involved in Capacity management and Analysis at hardware of the SQL Server including CPU, Memory and Storage.
• Implemented high availability strategies like Always ON, Database Mirroring, Replication and Log shipping.
• Configured Security at AD group and SQL Server level by creating Principals (logins) and mapping Users to Roles. (Securables and Permissions).
• Backup and restoring databases from Production to Development for testing.
• Created jobs for capturing daily operational metrics like backup failures, SQL Job failures, and error log activity.
• Involved in performance tuning with stored procedure and T-SQL having high response time.
• Implemented Transparent Database Encryption (TDE) on Sensitive databases.
• Good experience with Backups and restores of TDE enabled databases.
• Designed SQL Jobs to capture index usage, duplicate indexes, overlapping indexes, fragmentation etc. to periodically monitor the performance of the application databases.
• Used DMVs in SQL Server for troubleshooting indexes, performance tuning and instance health check activities.
• Troubleshooting Blockings & Deadlock issues in SQL Server.
• Responsible for query optimization using SQL tools such as SSMS, SQL Profiler and Index tuning wizard.
• Created and Modified complex stored procedures.
• Good experience in running jobs and fixing errors in Data Stage 5.0 and 11.0.
• Data stage jobs scheduling and troubleshooting.
• Worked with developers providing best practices, tuning queries & deploying SSIS packages.
• Experience in creating Maintenance plans, Backup, Restore, Table level Compression, Partition and Data Archiving.
• Has the ability to work in a fast paced environment, good team player and can work independently.
• SSIS packages created to load warehouse databases from production databases.
• Access databases created to generate reports according to needs of analysts.
• Working with business unit closely and solve the issues immediately.
• Configured lock pages in memory for servers with memory problems.
• Did troubleshooting, performance tuning and query optimization using DMVs, profiler and performance monitor.
• Configured and troubleshooting Merge replication, transactional and snapshot replication.
• Creating Linked servers for distributed queries.
• Worked with developers and application teams to assign permissions and fixing security problems.

Sr. Database Administrator

Confidential, Denver, CO

Environment: SQL server 2005/2008/2008 R2 with clustering, replication, Windows 2003, 64 bit, SQL profiler, SSIS administration and SSRS.

Responsibilities:

• Managing and administering SQL server 2005/2008 production and non-production servers.
• Creating and maintaining databases. Applied normalization and de-normalization rules.
• Expert in taking backups and point-in-time recover of database.
• Involved in disaster recovery planning
• Intensively worked and managed SQL server high availability like clustering, database mirroring, and replication.
• Good knowledge on sqlcmd and dedicated administrator connection to recover master database from disaster.
• Side by side migration of databases from SQL server 2005 to 2008.
• Installed, configuring and maintenance of SQL server 2008.
• Creating linked servers and modifying linked servers.
• Did trouble shooting and performance tuning, query optimization in case of slow running queries.
• Index creation and updating statistics.
• Good knowledge of bulk copying and bulk inserting statements.
• Extensively used tools like SQL server management studio, SQL profiler and database engine tuning advisor.
• Good knowledge of DMVs and DMFs and DBCC commands.
• For improving performance of queries applied database partitioning.
• Effectively worked on security like fixing failed principals and user permissions. applied object level security.
• Involved in sql jobs creation and maintenance. Created and managed credentials.
• Administering and managing SSIS packages.
• Expert in creating reports using SSRS and SSRS administration.
• Provided daily on call 24X7 support for Production.

Sr. Database Administrator

Confidential, San Francisco, CA

Environment: SQL Server 2000/2005/2008 with clustering, Replication, T-SQL, Windows 2003 64-bit, DTS, Profiler, XML, Web Services.

Responsibilities:

• SQL SERVER 2005/2000 Production Environment.
• Fixed the failed PRINCIPALS (logins), user permissions and security in ACTIVE DIRECTORY and at the SQL SERVER LEVEL.
• Implemented SIDE BY SIDE Migration of databases from SQL Server 2000 to SQL Server 2005
• Involved in Normalization, Database design, Performance Analysis and Production Support for very large (VLDB) and Complex Databases.
• Used native tools like DATA BASE TUNING ADVISOR, PROFILER and ACTIVITY MONITOR for performance analysis.
• Worked with SQL Server 2008 new MERGE statement.
• Handling Memory configurations for SQL Server 2000 and SQL Server 2005/2008 on Windows 2003
• Implemented the new SQL Server 2005 concepts like Data partitioning, Snap shot isolation, database mirroring, database snapshot, DDL triggers, try-cache blocks, online indexing, DMV's, DMF's, Mail Setup, Jobs, and Alerts, DTA,SQLCMD and dedicated admin connection and Compressed Backups.
• Created Documentation for steps need to be taken while upgrading the SQL server 2000 to SQL server 2005.
• Work based on Business Intelligence (BI) and Data Warehousing in SQL Server 2005
• Implemented new T-SQL features added in SQL Server 2005 that are Data partitioning, Error handling through TRY-CATCH statement, Common Table Expression (CTE).
• Configured more than 2 GB ram on 32 bit Environment
• Migrated DTS packages to SSIS packages and maintained the archival data
• Checking Database Health by using DBCC Commands and DMVS
• Monitored and modified Performance using execution plans and Index tuning
• Recovered the System and User databases from suspect mode, Expert in sizing Temp database.
• Prepared Documentation for the Disaster Recovery plan, Worked in Active passive cluster environment
• Implemented new topics like CLR integration on Development Server
• Wrote and debugged Stored Procedures and (DDL /DML)Triggers, Functions as per client requirements
• Extensively worked on trouble shooting and fine-tuning of databases for its performance, Rebuilding indexes with different fill factors and update statistics manually
• Designed and implemented comprehensive Backup plan and disaster recovery
• Worked extensively in Query analyzer and profiler for tuning queries using variable for characteristics and query costs.
• Daily routine Developer/DBA tasks like handling user's permissions and space issues on Production and handling maintenance Jobs including backups and restores.
• Did Performance Tuning of the Stored Procedures.
• Hands on experience in trouble shooting database issues. Update statistics, database integrity check and Backup operations
• Extensively used lite speed backup with MS SQL SERVER 2005/2008.
• Expertise in SQL server Reporting Services(SSRS) and SharePoint
• Monitoring SQL server performance using profiler to find the performance and dead locks.
• Worked on call 24/7 Support on weekly basis

SQL Server DBA

Confidential, Charlotte, NC

Environment: Windows 2003 server, MS SQL Server 2005/2005, T-SQL, MS Access, MS Excel, Oracle.

Responsibilities:

• Managed and Administrated the SQL Server 2008/2005/2000 production and Non-production servers. prepared maintained and modified SQL server installation and configuration documents
• Involved in the migration of SQL Server 2000 databases to SQL Server 2005.
• Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.
• Evaluated data storage considerations to store databases and transaction logs. Created databases using Transact SQL Statements, SQL Server Management Studio and Database Wizard.
• Implemented new T-SQL features added in SQL Server 2005 that are Data partitioning, Error handling through TRY-CATCH statement, Common Table Expression (CTE), Data Partitioning, Snapshot Isolation
• Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• Created Database Maintenance Plans for the performance of SQL Server which covers Database Integrity checks, update database Statistics and Re-indexing.
• Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions.
• Identified, tested and resolved database performance issues (monitoring and tuning) to ensure data optimization.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Managed trouble shooting of Client connections, viewing error log and applications.
• Developed automated backup and DBCC scripts for databases and transaction logs.
• Maintaining the database consistency with DBCC utility at regular intervals.
• Worked on log shipping for synchronization of database.
• Worked in Cluster Environment.
• Authenticated logins and validated permissions. Created SQL Server Database users and Roles.
• Writing stored procedures, triggers, and functions and maintained coding standards.
• Involved in database Normalization, logical and physical data modeling using ERWIN.
• Created and supported complex database schemas.
• Used SQL Profiler to capture the activities of the databases and used the trace file as workload file to the Database Tuning Advisor for index recommendations.
• Installed SQL Server 2005 and created Development Database for testing, upgrades and development.
• Monitored servers using Spotlight third party software.
• Transferred data (ETL) to Data warehouse Environment using SSIS.
• Involved in Source Data Analysis, analysis and designing mappings for data extraction also responsible for Design and Development of SSIS Packages to load the Data from various Databases and Files.
• Worked on DTS, Import and Export utility, for transferring data.
• Installed, authored, and managed reports using SQL Server 2005 Reporting Services
• Configured IIS, Report manager, Report server and implemented role based security to end users and developed report models for creating Ad-hoc reports using SSRS.
• Worked with Application Developers to design databases and tables to support Development activities and achieve optimal efficiency.
• Suggested better way to recover databases from disaster i.e disaster recovery.
• Configured SQL Server settings using configuration manager.
• Extensively used Red Gate SQL Compare and Data Compare tools to compare and synchronize SQL Database Schemas
• Involved with development team and developed functions, procedures and packages performed Logical Backups by Export and Import utilities.
• Handled numerous change management requests on production servers

SQL DBA

Confidential

Environment: SQL Server 2000, Microsoft Visual Basic 6.0 and Windows 2000.

Responsibilities:

• Applied Normalization rules in designing the database.
• Created Entity relationship diagrams, Function relationship diagrams, data flow diagrams and enforced all referential integrity constraints.
• Developed database objects like Tables, views, stored procedures, indexes etc.
• Tuned SQL statements using views and Stored Procedures.
• Designed Database objects including tables, procedures, views and database triggers on SQL Server Database.
• Rebuilding the indexes at regular intervals for better performance.
• Wrote various stored procedures for the purpose of application development.
• Wrote SQL Scripts to select the data from the source.
• Designed and implemented data access stored procedures and triggers for automating tasks.
• Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables.
• Created many complex Stored Procedures and used them in Crystal Reports.
• Created multi-format reports using Crystal Reports.