SUMMARY

• Over 8+ years of experience in MS SQL SERVER 2000/ 2005/2008/2008 R2/2012 Database Administrator (DBA) in Development, Test, Production and Cluster Server Environments.
• Conversant wif all phases of Software Development Life Cycle (SDLC) involving System Analysis, Design, Development and Implementation.
• Expert in designing VLDB using design methodologies like STAR Schema, Snowflake Schema.
• Experience in administrative tasks scheduling Backup and Recovery Strategies and Disaster Recovery Procedures.
• Expert in using different Recovery Models simple, full and bulk - logged depending on availability of database.
• Experience in implementing different types of Replication Models like Snapshot and Transactional and Merge Replication.
• Hands on experience in maintaining Clustering, Snapshot Replication, Log Shipping and Database Mirroring.
• Experience in SQL Server Performance Tuning, client/server connectivity, Query optimization and running Database Consistency Checks using DBCC Commands.
• Experience to Handle VLDB servers stored in local disk and SAN.
• Worked on administration tasks such as Data loading, batch jobs, Data unloading, backup and recovery, user and application table management, upgrades, creating Databases, file groups, files, transaction logs.
• Solid experience in Eliminating Blocking issues, performance monitoring wif Activity monitor, SQL Profiler, Performance monitor, Database Tuning Advisor, DMVs and DMFs, SQL Diagnostic Manager.
• Expert in Monitoring Disk space, Improving Efficiency in databases including Index Tuning Wizard, Query tuning, and performing other maintenance tasks as Data Partitioning, Snapshot isolation.
• Expert in using MS SQL Server tools SSIS, SSRS, and SSAS.
• Experience in building Data Integration and Workflow Solutions, Extract, Transform and Load (ETL) solutions, for data warehousing using DTS and SQL Server Integration Service (SSIS).
• Worked in an Enterprise environment supporting many SQL Server instances
• Experience in Data Migrations from SQL 2000 to SQL 2005, SQL 2005 to SQL 2008/2008R2/2012, creating, deploying and troubleshooting SSIS packages.
• Experience in working wif Reporting tools like Crystal Reports, Microsoft Reporting services SQL Server Reports, handling Sub Reports and defining query for generating Drill Down reports using SSRS 2005.
• Experience in developing PL/SQL and TSQL Packages, implementing business logic in backend using Stored Procedures, Triggers, Views, Scripts, Functions and Cursors.
• Ample of Expertise in Data Modeling tools such as ERwin, MS Visio and ER Studio.
• Used Bulk Copy Program (BCP) extensively for flat file import and export operation to/from SQL Server.
• Experienced in Reorganizing database structures, Reorganize or de-fragment database table spaces, tables, and indexes.
• Knowledge on ALWAYS ON,MULTI SUB-NET Cluster and Contained databases
• Expert in using tools like SCOM, Idera, Red gate, Lite Speed, and NetBackup.
• Responsible in providing Development and Production Support 24x7 and off hours support.
• Strong interpersonal skills, analytical ability, communication skills, writing skills, highly organized to meet the deadlines and ability to grasp and adapt to the rising technologies.

TECHNICAL SKILLS:

Databases: Microsoft SQL Server7.0/ 2000/ 2005/2008/2008 R2/2012, MS access 97 & 2000, Sybase, Oracle 9i/10g.

SQL Server: MS SQL Server Enterprise manager, Profiler, DTS, Query Analyzer, SQL Server Management Studio, SQL 2005/2008/2008 R2/2012 Integration Services (SSIS), Reporting Service (SSRS), and Analysis services (SSAS) (BIDS), SQL Profiler, SQL CMD, Database Tuning Advisor, Performance Monitor, SQL Server Activity Monitor.

Operating systems: WindowsXP/NT/98, Windows 2000/2003/2003 R2/2008/2008R2, Linux, UNIX.

Languages: C, C++,T-SQL,PL SQL, Java

Tools: SCOM 2007, NetBackup, LiteSpeed, Idera, Red Gate, ERwin, MS Visio,Golden Gate.

Data Access Technologies: ADO, RDO and ODBC

Internet: ASP.NET, ADO.NET, HTML, DHTML, Active X

PROFESSIONAL EXPERIENCE

Confidential, Virginia Beach, VA

DBA

Responsibilities:

• Involved in migration from MS SQL Server 2000 and SQL Server 2005 to MS SQL Server 2008/2008R2/2012.
• Install/upgrade of SQL servers on Standalone and Clusters 32/64 bit, SQL Server 2005/2008/2008 R2 installed on Clusters 32/64bit 2 node clusters. Applied SQL Server Service packs, Hot fixes (Cumulative updates) on production/DR/QA servers
• Upgraded SQL Server 2000 to SQL Server 2005/2008 and SQL server 2005 to SQL Server 2008/2008R2/2012 on Production/DR/QA Servers.
• Responsible for MS SQL Server 2005/2008/2008 R2/2012, configuration, tuning and provide 24X7 dedicated support to all Production, development and clustered servers.
• Configured MS SQL Server to use TCP/IP wif default settings and ensured port 1433 is open in firewall.
• Involved in documentation and implemented a disaster recovery system.
• Performed all aspects of database administration, including data modeling, backups andrecovery.
• Experience in Security Issues such as creation and granting permissions on various Objects. Assign permission to user(s), role(s), and object.
• Analyzed long running slow queries and tuned the same to optimize applications and system performance and Performed DBCC Checks.
• Diagnosed and tuned the server optimal performance using SQL Server Dynamic Management Views (DMV), Profiler and Index Tuning Wizards.
• Rebuild Indexes and Tables as part of performance tuning exercise
• Successfully migrated data to new location using Snapshot Replication, and implemented Merge Replication to support up to date record of Inventory Information.
• Overall database design, such as creating normalized databases, authentication, query tuning, assigning proper indexes, creating stored procedures, functions, triggers and data types using T-Sql Statements.
• Hands on experience wif Bulk Insert, BCP and Database consistency check using DBCC commands.
• Configured Transactional replication between Primary Server and three Read - Only servers, wif separate Distributor server and experience in troubleshooting replication problems.
• Worked closely wif audit team to implement SOX-Audit on all SQL servers.
• Developed ETL packages wif different data sources (SQL Server, Flat Files, Excel source files, XML files etc) and loaded the data into target tables by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Data migration using DTS services across different databases like Oracle, MS access & flat files.
• Monitored and report generation for the database infrastructure and these reports are submitted to management on regular basis.

Environment: SQL Server 2000/ 2005/2008/2008 R2/2012, MS Access, Windows 2003/2008/2008 R2, ASP.Net, Java, C#.Net, ADO.Net, VB Script, IIS 6, SSRS, SSAS, SSIS, NetBackup, ER Studio, SharePoint 2007 and 2010.

Confidential, Minneapolis, MN

DBA

Responsibilities:

• Installed SQL Server 2005/2008 on Windows 2003/2008 advanced servers, applied services packs and security fixes.
• Migrated 10 servers from SQL Server 2000 to SQL Server 2008 wifout any issues.
• Extensively used VB Script and T-SQL to create databases and objects through batch files.
• Extensively worked on SharePoint projects and applications having Terra bytes of databases
• Primary DBA for Client Critical business applications.
• Implemented Log shipping, Mirroring and Replication and supported them.
• Extensively worked on SQL and Windows Clustering.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Involved in Disaster Recovery procedures to test recovery process of the servers and databases.
• Played an active role in projects for requirements Gathering, Blueprint, Design, Configuration, Project reviews wif users and sign offs.
• Designed Logical and Physical Data Models using ER Studio and successfully transformed them into Physical Database
• Actively participated in project meetings and gave valuable suggestions for implementing VLDB's and Highly Chatty DB's
• Monitored and modified Performance using Execution plans and Index tuning.
• Rebuilding the Indexes at regular intervals for better performance
• Extensive administration of Clustered SQL servers in 24 x 7 Windows data center environment
• Worked on performance issues on both SQL and Windows and gathered performance counters to solve problems about performance.
• Complete Documentation about the database for DR and for future support.
• Designed and created databases, Tables, Views, Store Procedures.
• Wrote optimized T-SQL Stored Procedure to improve performance, preserve referential integrity and provide application functionality.
• Created Groups, Roles, Users and assigned access privileges to users.
• Worked on Active directory issues.
• Involved in installing of SAN and Coordinating wif System Administration.
• Exported and imported data from text files and Excel T-SQL Server database using Bulk Copy Insert and BCP utility.
• Day to day activates include creating databases, monitoring servers, taking performance counters, Performance tuning, checking status of scheduled jobs and solving user problems wif login and performance.
• Tuned the performance of SQL queries and Stored procedures using SQL Profiler and Index Tuning Wizard.
• Backups, backing up master & system databases and restoring them when necessary.

Environment: SQL Server 2000/2005/2008 , MS Access, Windows 2003/2008, ASP.Net, Java, C#.Net, ADO.Net, VB Script, SharePoint MOSS 2007, IIS 6, SSRS, SSAS, MOM, SCOM, SCCM, TDP, TSM, HP Service Desk, HP Service Manager, ER Studio, Lotus Notes, Active Directory.

Confidential, Saint Louis, MO

DBA

Responsibilities:

• Maintain Reporting services on MSSQL 2000/2005 platform.
• Installed SQL Server 2000/2005 on windows 2003 advanced servers, applied services packs and security fixes.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Played an active role in requirements Gathering, Blueprint, Design, Configuration, Project reviews wif users and sign offs.
• Expertise in designing databases and capacity planning.
• Rebuild the Indexes at regular intervals for better performance
• Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.
• Worked extensively in Query analyzer and Profiler for tuning queries using variable for characteristics and query costs.
• Monitored and modified Performance using Execution plans and Index tuning.
• Administration of Clustered SQL servers in 24 x 7 Windows data center environment
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency
• Complete Documentation about the database
• Designed and created databases, Tables, Views, Store Procedures and Triggers.
• Designed and developed file loading process by creating complex stored procedures, functions and bind them wif DTS package and SSIS package for logical execution.
• Created DTS and SSIS packages for migration of data from SQL Server to MS Access or Oracle Databases.
• Wrote optimized T-SQL Stored Procedure to improve performance, preserve referential integrity and provide application functionality.
• Created Groups, Roles, Users and assigned access privileges to users.
• Exported and imported data from text files and Excel T-SQL Server database using Bulk Copy Insert and BCP utility.
• Tuned the performance of SQL queries and Stored procedures using SQL Profiler and Index Tuning Wizard.
• Scheduled jobs and alerts using SQL Server Agent.
• Used system stored procedures and DBCC commands.
• Involved in database and log backups & restoration, backup strategies, scheduling.
• Backups, backing up master & system databases and restoring them when necessary.
• Created many periodic and on-demand management reports using Crystal Reports.
• Installed Analysis services and developed cubes.
• Installed Reporting Services.

Environment: SQL Server 2000/2005, MS Access, Windows 2000/2003, UNIX, ASP.Net, C#.Net, ADO.Net, XML, XSL, XML Web services, JavaScript, CSS, IIS 6, SQL Reporting Services.

Confidential, New Britian, CT

DBA

Responsibilities:

• Worked on Complete Backing up of Database and Restored the Database from Disaster Recovery.
• Used DBCC commands to check physical and logical consistency of the databases and to rebuild indexes.
• Responsible for Query Optimization, Performance Tuning, System Monitoring.
• Secured the SQL Server by creating User Logins wif appropriate roles, dropping and locking the logins, Creation of Groups, granting the privileges to users and Groups.
• Implemented Transactional Replication model and involved in maintenance of the replication.
• Established Joins and Created Indexes to assimilate client information from multiple tables.
• Managed and Scheduled Daily Jobs relating to data transfers, Backup and Recovery, transaction log dumps.
• Developed DTS Packages to transfer the data between SQL server database and files.
• Written Stored Procedures, Triggers, user defined Functions UDF for Application Developers.
• Monitor SQL Error Logs, Schedule tasks, database activity.
• Involved in Configuring the Log shipping to create the Standby server.
• Modified stored procedures to implement the complex business needs for generating new customer number, updating user profiles, transaction processing, generating messages wif code encryption.
• Documentation of the systems Tables, Views, Stored Procedures, Jobs.

Environment: SQL Server 2000/2005, T-SQL, VB, Access, Excel, Crystal reports, Asp, Windows 2000 Advanced Server, Unix, Oracle and Windows NT

Confidential

SQL Developer / DBA

Responsibilities:

• Installed and configured SQL Server 2000/2005.
• Involved in Database designing, Logical and Physical Data modeling using Erwin. Transformed logical model into Physical SQL Server Database.
• Created SQL tables using scripts and Erwin Forward Engineering Utility.
• Worked as a developer in creating complex Stored Procedures, Functions, Triggers, and views.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent Data entry into the database.
• Performed query tuning and reduced response time by 60%
• Managed Disk space, memory and User connections.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization.
• Performed backups, DBCC utilities, updated index statistics, monitored database and disk space.
• Monitored SQL server performance using profiler to find performance, dead locks, blockings and Capturing long running SQL queries for fine-tuning SQL statements that better result in efficient SQL statements processing.
• Designed DTS packages to refresh data on Development and QA/Staging.
• Experience on Import / Export using DTS and BCP utility.

Environment: MS SQL server 2000, Windows Server 2000, VB .Net, Enterprise manager, Query Analyzer, SQL profiler.