SUMMARY

• 7+ years of Database Administration and Development experience on MS SQL Server 2012/2008 R 2/2008/2005/2000 in 24 * 7 environment and Large Data bases in size.
• Hands on experience and outstanding knowledge of high availability SQL Server solutions, including replication and SQL Server clustering, log shipping, Replication and Mirroring.
• Implemented Transactional Replication as a part of high availability solution.
• Proficient with SQL Enterprise Manager, Query Analyzer, Management Studio, Business Intelligence development studio, rescheduling jobs with SQL Server Agent, SQL Profiler, restoring database using full, differential, and log backups. OLAP, OLTP, data warehouse design, trouble shooting.
• Experience with 2012 always on availability.
• Experience with 2012 MDS (Master Data Services).
• Experience in MS SQL Server database development and administration in enterprise production environment including server installation, configuration, upgrade, maintenance, performance tuning, query optimization, backup/restore, recovery, migration, monitoring, security planning and trouble - shooting.
• Extensive experience in using SQL Server Profiler to monitor the SQL server for deadlocks, long running queries and tunes the same to improve performance.
• Experience in Batch processes, Import, Export, Database Monitoring tools and Application support. Extensive usage of Proactive Monitoring tools of SQL Server.
• Extensive experience with Storage Capacity Planning, including system storage allocation, on-going capacity analysis and planning future storage requirements
• Worked closely with developers and testers, my objective was to deliver projects within scope, time and costs while following department standards, methodologies and guidelines.
• Worked in production environment providing Production Support, Production database server implementation, Database Migration.
• Extensive Experience with different phases of project life cycle (Analysis, Design, Implementation, Testing, and debugging new and existing client-server based applications)
• In-depth knowledge of T-SQL and having experience in creating indexed views, complex stored procedures, effective triggers, and useful functions to facilitate efficient data manipulation and consistent data storage.
• Installed and configured SQL server 2005/2008/2012 along with Analysis services (SSAS), Integration Services (SSIS) and Reporting Services (SSRS).
• Expert in data extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), Data Transformation Services (DTS), creating Dynamic packages for Incremental loads and data cleansing in Data Ware House in SSIS.
• Proficient in SQL server and T-SQL (DDL and DML) in constructing tables, Normalization techniques on database tables, Data Warehousing and Technical Management.
• Experience in implementing & monitoring of Replication Models Snapshot, Merge and Transactional.
• Experience of server-client computing and good understanding of relational database environments.
• Provide capacity planning analysis for database resource requirements. Assigning of database change control tasks (CCT/tickets) using CA tool. Support and trouble-shoot jobs and other system control processes.
• Set up Mount Drives and Disk Management.
• Experience in creating Jobs, Alerts, Database / SQL Mail Agent.
• Hands on experience with share point databases.
• Experience in migration of database to VM and setting up DR.
• An excellent team member with an ability to perform individually, good interpersonal relations, strong communication skills, hardworking and high level of motivation. A quick learner with an aptitude for taking responsibilities

TECHNICAL SKILLS

RDBMS/ DBMS: MS-SQL Server 2012, 2008, 2005, 2000, MYSQL, Oracle, MS Access

Language/Tools: T-SQL, REDGATE, LITESPEED, SSIS, SSRS ETL, SCOM, IDERA SQL Diagnostic Manager, ORACLE.

Programming Languages: T-SQL, MSSQL

Operating Systems: Win 2k8/2k3/Win 7/XP, Win NT 4.0, Win server 2003/2008/ 2008 R2

PROFESSIONAL EXPERIENCE

Confidential, Charleston WV

Responsibilities:

• Worked on 2000, 2005, 2008 and 2012 versions of SQL.
• Experience working in cluster environment.
• Worked on Performance analysis, administration Monitoring SQL jobs, Performance bottlenecks, configuring databases, backup/restore DB.
• Worked on Configuring data files, log files and tempdb as per RAID features.
• Created and modified Stored Procedures and Functions to generate reports.
• Work on 32 bit, x64 bit and i64 clustered and standalone environments.
• Extensively used SSIS, Import/Export wizard, for performing the ETL operations.
• Worked on share point databases. Trouble shooting database issues. Migrating Share point from .
• Created backup jobs in Express Edition using cmd.
• Installed SQL 2008/2012 on VM machines and scheduled maintenance. Configured Disaster recovery.
• Created maintenance plans using Quest Lite speed for index defrag, update statistics and maintenance.
• Worked on Auditing the logins and users in multiple servers.
• Daily Tickets and other Deployment/New Application Rollout’s and Change Requests.
• Monitoring the CPU usage, IO statistics, Memory Usage to identify any OS level performance killers, enabling database level trace for performance test.
• Database space management/OS level space management.
• Disk Management and Mount Drives setup.
• Query tuning and performance optimization for the database.
• Creating mail profile and Setting up Alerts using SQL Mail.
• Worked in resolving deadlock and blocking issues for concurrent users.
• Experience working on Microsoft CRM databases.
• Worked on Microsoft Visio in creating different SQL environment.
• Data migration between different environments and third party Databases.
• Experience with converting Microsoft Excel, Microsoft Access, text files and other formats into a SQL Server database.
• Created SSIS packages for Incremental loads and data cleansing.
• Created SSRS reports to meet business requirement.
• Applying SQL server patches and Migration to different versions of SQL.
• Working in cluster environment on 2012 server with SQL 2012.
• Policy-based management for ensuring consistent configuration.
• Experienced in REDGATE SQL Compare/SQL Data Compare, QUEST Lite Speed, Avamar Backup/recovery tool, IDERA SQL Diagnostic Manager and SCOM for monitoring SQL environment closely.
• DHHR- Department of Human and Health Resource.
• BON- Board of Registered Nurses Licensing
• Surplus Inventory
• Workforce, On base and labor information
• DOT (Highways) and DOT(DMV)
• DNR-Division of Natural Resource, Juvenile Service, Regional Jail.
• PEIA, Face2Face, Water Board etc.
• Windows 2012 Server, Windows 2008/2003 Server, Windows XP
• Windows 7, Microsoft Office 2010
• Red Gate, Quest Lite Speed, Avamar
• SCOM, Idera SQL Diagnostic Manager, SQL Profiler, SSIS, SSRS.
• Microsoft Visio, Access database, Excel, PowerPoint and word.
• HEAT ticketing system software
• Virtual Machines

Confidential, Marshfield, WI

SQL Server DBA

Responsibilities:

• Highly worked on Administration, Database Design, and Performance Analysis on very large and highly transactional production databases.
• Installed and configured SQL Server 2005/2008 (R2) on new servers with service packs.
• Support and troubleshoot very large databases (VLDB).
• Extensively work on Snapshot and Transactional Replication.
• Work on 32 bit, x64 bit and i64 clustered and standalone environments.
• Configured data files; log files and tempdb as per RAID features.
• Reconfigure the default locations of the data files, log files and error log files onto the SAN environment for all the servers.
• Work with tools like SQL Server Dashboard, SQL Profiler and Activity Monitor for event monitoring and performance monitoring, and make recommendations based on the results.
• Experience in migration of database to VM .
• Involved in ETL process under development, testing and production support environments.
• Performance in creating ETL Packages in SSIS with error handling and conducted data migration process In SQL server environment using SQL SSIS
• Worked in maintaining Batch Logging, Error Logging with event Handlers and Configuring Connection Managers using SSIS.
• Worked on system analysis, design, development, testing and implementation of projects software Development Life Cycle (SDLC)
• Provide flexibility and performance to simplify the creation and maintenance of partitioned tables in SQL Server 2005.
• Worked on stored procedures, Created user defined functions and debug them.
• Converted Microsoft Excel, Microsoft Access, text files into a SQL Server database using SSIS.
• Extensively work on database partitioning for better performance in SQL Server 2005.
• Fix data issues and write various SQL scripts and procedures for migration process.
• Involved in Data Compression, Hot add CPU, Fact Table size reduction and improved performance using SQL Server 2008.
• Expert in using and implementing DMV’s, DMF’s, data partitioning, DDL triggers, Mirroring and Online indexing.
• Worked with building the complex standard Reports using SSRS and worked with tuning the large complex reports on SQL Server Database.
• Develop all the required stored procedures, user defined functions, and triggers using T-SQL.
• Implement data availability solutions like Replication, Log shipping Database Snapshot, and Fast Recovery.
• Optimize the performance of queries with modifications in T-SQL queries, remove unnecessary columns, eliminate redundant and inconsistent data, and normalize tables.
• Create and modify Stored Procedures and Functions to generate reports.
• Monitor and modify performance using execution plans and Index tuning.
• Migrated SQL Server, SQL Server R2
• Designed a report on the monitoring of SQL Server Performance. This report gives a detail report to the management on the Performance of the server. Installed couple of SQL Server 2005/2008 on cluster environment.
• Implement and manage the clustering environment like Active/Passive and Active / Active
• Use log shipping for synchronization of database.
• Responsible for day-to-day activities, such as backups to the disk and restore the databases and transaction log on production/development servers as per business / IT needs using SQL Safe.
• Troubleshoot and fine-tune databases for performance and concurrency.
• Provide 24x7 Production Database on-call support.

Environment: MS SQL Server 2008/2008R2, Windows 2003/2007, MS Access, SSIS, SSRS.

Confidential, Round rock, Texas

SQL Server DBA/Developer

Responsibilities:

• Monitoring SQL jobs, Performance bottlenecks, configuring databases, backup/restore DBs.
• Implemented different types of Replication Models like Snapshot, Merge and Transactional using SQL SERVER 2008.
• Extensively used SSIS Import/Export wizard, for performing the ETL operations.
• Using performance tools like Index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.
• Added error handling techniques like TRY-CATCH in the process.
• Created SSIS Packages to migrate slowly changing dimensions.
• Raidster internal tool used to track the bugs and to get the consolidated bug reports.
• Involved in the Design of Database and creation of tables, stored procedures, User Defined Functions, DTS packages using SQL Server 2005, 2000.
• Experience in planning and implementing MS SQL Server Security and database permissions.
• Daily Tickets and other Deployment/New Application Rollout’s and Change Requests.
• Implemented SQL security for application users using Active Directory
• Monitoring the CPU usage, IO statistics, Memory Usage to identify any OS level performance killers, enabling database level trace for performance test.
• Migrating entire database environment from SQL 2005 to SQL 2008.
• Query tuning and performance optimization for the database and highly transactional 100% Uptime applications.
• Database space management/OS level space management.
• Query tuning and performance optimization for the database.
• Setting up Alerts using SQL Mail.
• Involved in all new projects/application development based on SQL Server, Client/Server Environment.

Environment: SQL Server 2005/2008, Windows 2003/2007, T-SQL, Profiler.

Confidential, Seattle, WA

SQL SERVER DBA

\Responsibilities:

• Actively involved as part of a team in gathering and analyzing the needs of End User Requirements and Online System Application.
• Modified existing database by adding tables, adding columns to existing tables and relationships to support online system.
• Created Check Constraints to apply business rules for data consistency and Integrity
• Created Views, Indexed Views, and Partitioned Views as required by front end developer for easier implementation on web pages, and wrote instead of triggers on those views to provide efficient data manipulation.
• Configured packages event logs and created ETL SSIS packages both design and code to process data to target databases.
• Worked on DTS and BCP to transfer data from legacy Server to SQL Server, to load Flat files to SQL Server, database backup and restoration of backup.
• Involved in Troubleshooting existing and new DTS packages.
• Configured SQL mail agent for sending automatic emails when a DTS process is failed or succeed.
• Optimized the performance of Queries and Store Procedures with modification in T-SQL statements, by removing unnecessary columns, by eliminating redundant and inconsistent data, by renormalizing tables, and created indexes wherever necessary.
• Created Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Planned the Complete Backing up of Database and Restored the Database from Disaster Recovery.

Environment: SQL Server 2008/2005, Windows 2003 Server, T-SQL

Confidential

Database Engineer / System Engineer

Responsibilities:

• Administered and maintained production/Development servers with complex structures. Performance metrics reports daily, weekly and monthly.
• Preparing database schema, data insertions and retrievals, procedures, triggers, scripts and queries with abilities to prioritize and operate proactively.
• Expertise in setting up and troubleshooting SQL SERVER, Optimized working process.
• 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
• Creation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of user.
• Created Database Maintenance Plans for the Performance of SQL Server which covers Database Integrity Checks.
• Created various jobs to check health of the server and to troubleshoot.
• Tuned servers to the peak for maximum performance by configuring memory and various server level parameters.

Environment: SQL Server 2000/2005, Windows 2003/2000, Visio, T-SQL