SUMMARY

• Over 8+ Years of SQL Server DBA experience in Database Administration, System Analysis, Design, Development, Security and Support of MS SQL Server 2012, 2008, 2008R2, 2005, 2000 in Production (24x7), Testing, Development, Replication & Cluster Server Environments.
• Supports day to day operational duties for the database platform such as service requests and tickets, backups, monitoring, performance tuning, system troubleshooting.
• Experience in Database Backup, Recovery and Disaster Recovery Procedures.
• Experience in implementing of Replication Models like Snapshot, Merge and Transactional on basis of business specification.
• Excellent T - SQL Programming skills, Execution Plan, query optimization & performance tuning. Used SQL Profiler, Performance Monitor and DBCC Commands.
• Hands on Experience in Writing & Debugging Stored Procedures and Triggers, Troubleshooting Database issues.
• Experience in Query Optimization, Re-Indexing, Updating Statistics, tuning Stored Procedures and performing Maintenance Tasks.
• Created maintenance plans to perform index defragmentation, re-indexing and update the index statistics.
• Experience working with DTS Packages, migrating DTS packages.
• Proficient with SQL Enterprise Manager, SQL Query Analyzer, scheduling jobs with SQL Server Agent, SQL Profiler, restoring full, differential, and log backups.
• Experience in Using Performance Monitor/Profiler to resolve Dead Locks/Long Running Queries and to resolve System Hardware bottlenecks.
• Expert in Database migration from MS SQL Server 2000 to SQL Server 2005, SQL Server 2005 to SQL Server 2008, and SQL Server 2008 to SQL Server 2012.
• Experience with Reporting Services SSRS and Analysis Services SSAS.
• Worked extensively in OLTP & OLAP environments that included Production (24x7), QA and database development in SQL Server.
• Good operating knowledge in third party tools such TOAD, VERITAS Netbackup, LiteSpeed Pervasive ETL, SQL Assistant, ArcSDE, ERWIN, Visio 2007, Red-Gate and Spotlight.
• Good experience with the entire phases of Software Development Life Cycle (SDLC)
• Worked closely with development and Technical Support team to resolve quality issues.
• Very good interpersonal skills, commitment, result oriented, hard working with a quest and zeal to learn new technologies.
• Troubleshoot performance problems, fine-tuning of databases and index Analysis.
• 24x7 Production Database on Call Support.

TECHNICAL SKILLS

Relational Databases: SQL Server 2012/2008/2008 R 2/2005/2000/7.0 , MS-Access 2000/2003/2007 , My SQL4/5, Oracle 9i/10g

Operating Systems: Windows NT/ Windows 2000 Advanced Server / Enterprise Server 2003 / Windows XP / Standard, Windows 98, Windows Vista, Windows 7, and Windows 8.

Database Tools: SQL Server Enterprise Manager, Query Analyzer, SQL Profiler, SSIS, SSAS, SSRS, DTS, BCP, ODBC, SQL OLEDB, DBCC, ADO, ADO.NET, Business Intelligence Studio, Crystal Reports.

Languages: C#, XML, SQL, T-SQL

Operating Systems: Windows 2003, Windows 2000 server, Win ME/NT/XP, UNIX.

Web Servers: IIS 5.0/6.0/7.0, Apache, Tomcat, Amazon web services, Service Center, Virtual Private Cloud (VPC).

Architecture: Relational DBMS, Client-Server Architecture, Clustering, Replication, OLAP, OLTP.

ETL: SSIS, SSRS, DTS, Informatica, Data Stage.

Other Tools: Erwin 4.0/3.5, Microsoft Visual Studio 2003/2005/2008 , MS Visual SourceSafe, Source Control, MS Visio, Windows System Monitor, Redgate, sqlcompare, Dell litespeed.

PROFESSIONAL EXPERIENCE

Confidential, Charlotte NC

MS SQL SERVER DBA & CONSOLIDATION ANALYST

Responsibilities:

• Analyzed SQL server over 50+ with 700+ databases from 2000, 2005, 2008 & 2008R2.
• Worked from 35 Physical servers, 15 Virtual machines, about Production server 45, development server 02 and Quality Assurance server 03.
• Consolidation of SQL server and databases based on physical memory, server memory, I/O waits, linked servers, active servers, offline database.
• Maintain Operators, Categories, Alerts, Notifications, Jobs, Job Steps and Schedules.
• Monitor connections, locks and performance of SQL server.
• Set up SQL Mail and Created Jobs to Automate & Scheduled many tasks.
• Creating new procedures using Dynamic SQL and Table Variables.
• Create and Modify procedures, Triggers and functions.
• Monitoring the databases on a daily basis and checking the Event logs and Error logs.
• Experience in database redundancy strategies, and disaster recovery (Data Mirroring, Replication, Log Shipping, and Clustering).
• Setting up logical/physical backups for the databases.
• Responsible for creating tables, triggers, stored procedures, indexes.
• Managing Logins, Users, Roles and User permissions.
• Involved in daily loads (Full & Incremental) into Staging and ODS areas, troubleshooting process, issues and errors using SQL Server Integration Services (SSIS) 2008.
• Involved in Performance tuning and Query Optimization.

Confidential, Wilmington DE

MS SQL SERVER DBA

Responsibilities:

• Migrated SQL Server database from 2005 to SQL 2008, SQL 2008 to SQL 2012 including consolidating. Experience working with production (24 x 7) and development.
• Supports day to day operational duties for the database platform such as service requests and tickets, backups, monitoring, performance tuning, system troubleshooting, and other tasks as assigned or expected from DBAs.
• Responsible for all major database components of SQL Server and has strong knowledge of the various interrelationships between major system components including networking, storage, server, operating system, cluster, authentication, application code, and disaster recovery technology.
• Involved in Data modeling, designing and building relational databases using Erwin tool.
• Running DBCC consistency checks, and fixing data corruption in user databases.
• Creating and managing schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements and converting them into technical specifications.
• Creating databases and logins with permissions in SQL server 2008 as per the developer’s request.
• Creating batch scripts for providing smooth solution to the ETL process.
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
• Maintain Operators, Categories, Alerts, Notifications, Jobs, Job Steps and Schedules. Monitor connections, locks and performance of SQL server.
• Extensive knowledge of performance optimization for both SQL Server configuration and SQL code tuning using OS performance monitors, wait and queue.

Confidential, Hartford CT

MS SQL Server DBA

Responsibilities:

• Involved in installation of SQL Server 2000, 2005, and 2008R2, Configuration and Maintenance.
• Experience in migrating web applications from IIS 5.0 to IIS 6.0, and maintained multiple Internal/External websites on IIS 6.0 on multiple server environments.
• Verify, maintain & troubleshoot database backups, integrity checks and scheduled jobs.
• Wrote triggers, Stored Procedure, scripts, cursors for the bulk application, tested them on the test servers and moved them to the production.
• Creating and managing schema objects such as tables, views, index, and procedures.
• Involved in side by side migration from .
• Installation of Replication Server, Configuration and Monitoring the replication, implemented Transactional Replication, Merge and Snapshot, writing scripts for automation, for creating publications, articles and running the snapshot agent job, so that the same scripts can be used from system test to production.
• Upgraded DTS packages to SQL Server 2005 Integration Services (SSIS) packages.
• Supported Development Team in deploying and testing the application, which uses SQL Server backend.
• Monitor backup jobs daily and run the jobs manually in case of failure depending upon the necessity.
• Expertise in Security Issue such as creation and granting permissions on various Objects.
• Provided 24x7 dedicated support to all Production and development servers.

Confidential, Mt Laurel NJ

SQL Server DBA / DEVELOPER

Responsibilities:

• Performed SQL server database upgrades from version and applied patches to 2005 database server instance.
• Maintaining jobs for data massaging from production server to Business Objects server for generating daily reports for financial and marketing team.
• Managed and coordinate with remote user for change request and optimization of application.
• Management and maintenance of data, including backups, data fixes, replication, restoration and high availability of operational systems.
• Configuration and management of security of company SQL servers, including troubleshooting.
• Responsible for planning, executing, and maintaining data integration projects and database upgrades.
• Experience in database redundancy strategies, and disaster recovery (Data Mirroring, Replication, Log Shipping, Clustering).
• Responsible for fine tuning of the database, trouble shooting, user administration, memory management, and running DBCC.
• Involved in Performance tuning and Query Optimization.
• Used multitask data pump in DTS/ETL.
• Responsible for creating tables, triggers, stored procedures, indexes.

Confidential, PA

Sr.SQL Server DBA

Responsibilities:

• Installation and configuration of SQL Server 2000/2005, and Windows 2003 fail over cluster for SQL .
• Administration of Clustered SQL servers in 24x7 Windows data center environment.
• Designing, testing and managing disk\tape Backups and Recovery strategies.
• Managing Log Shipping for hot standby computers.
• Managing Replication of Data (Snapshot, Transactional, Merge method used).
• Managing SQL databases, Security, fine tuning of SQL queries, troubleshooting.
• Designing and managing SQL DTS packages.
• Involved in Cluster implementation and Migrated SQL .
• Developing SQL stored procedures, views and triggers.
• Verifying the new database code meets company standards for readability, reliability, and performance.
• Monitoring the databases on a daily basis and checking the Event logs and Error logs.
• Responsible to releases from development to test to production environments.
• Provide 24x7 dedicated support to all Production, QA & Development MS SQL Server Environments.
• Designed various approaches like CDC (Change data capture), Auditing control, Recovery strategy, Scheduling jobs etc.

Confidential, Madison NJ

SQL Server DBA /Developer

Responsibilities:

• Monitored and maintained over 6 SQL Servers in Production, QA, Test and Development Environments.
• Set up SQL Mail and Created Jobs to Automate & Scheduled many tasks.
• Implementing Automated Backup and Database Maintenance / Cleanup jobs.
• Imported Data from Text files and Excel Spread sheet into SQL Server 2000 database using DTS package.
• Creating and maintaining documentation including data dictionary. Installation and maintenance of DBMS software and connectivity to client tool.
• Implementing Automated Backup and Database Maintenance / Cleanup jobs.
• Change management ensuring all changes are tested, communicated, approved, and documented.
• Setting up logical/physical backups for the databases.
• Create packages, procedures, functions, triggers, and handle database performance with tuning.
• Implemented replication model like Merge, Transactional and Snapshot.
• Demonstrating Communication skills and leadership ability. Previous marketing and/or CRM expertise a plus. Demonstrating project management skills.
• Backed up system and user databases related to Merge, Transactional and Snapshot Replication.
• Creating DTS Packages migration of data across different servers and Other Databases such as Oracle and DB2.
• Participating in 24x7 on-call rotation. Good analytical and troubleshooting skills required. Been a good team player with good communication skills and a can do attitude.
• Managing Logins, Users, Roles and User permissions.
• Application installation for database-centric applications like SAP and Siebel.
• Assist Developers in writing and tuning new procedures.
• Creating new procedures using Dynamic SQL and Table Variables.
• Create and Modify procedures, Triggers and functions.

Confidential

Principle SQL DBA 24x7 Production support

Responsibilities:

• Responsible for Logical & Physical Database Design.
• Responsible for creating Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints Views, Stored Procedures, Triggers, Rules and Defaults.
• Creation of New NT Logins and granting privileges to users/Groups and objects.
• Used DBCC commands to check physical and logical consistency of the databases and Rebuild indexes.
• Backup and recovery of Master, MSDB and Application databases.
• Monitor NT Event log for system, application errors, available disk space, Backup registry, keep emergency repair disk as current.
• Implemented log shipping and performed changing roles when production data base goes down.
• Worked extensively on DTS Package designs for Import/Export from various Data Source Flat file, Excel, MS Access to MS SQL Server and schedule the jobs in SQL Server.
• Provide 24x7 dedicated support to all Production, QA & Development MS SQL Server Environments.
• Related issues /performance related issues with Minimal Downtime & Maximum Reliability.
• Responsible for deployment from development to test, UAT and production environments.
• Review / test / apply all database changes to all environments including QA, Development and Production Servers. Monitor SQL Error Logs /Schedule.