Sql Server Engineer

JAGANNATH Email: -************@*****.***

Phone: 224-***-****

Summary

7+ years of Database Administration and Development experience on MS SQL Server 2008 R2/2008/2005/2000/7.0 in 24 * 7 environment and Large Data bases in size.

Implemented Transactional Replication as a part of high availability solution.

Hands on experience and outstanding knowledge of high availability SQL Server solutions, including replication and SQL Server clustering, log shipping and Mirroring.

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 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, Backup, 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.

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.

Experience in planning and implementing MS SQL Server Security and database permissions.

Experience in creating Jobs, Alerts, Database / SQL Mail Agent.

An excellent team member with an ability to perform individually, good interpersonal relations, strong communication skills, hard working and high level of motivation. A quick learner with an aptitude for taking responsibilities

SKILLS PROFILE:

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

• Language/Tools: • T-SQL,REDGATE,LITESPEED,ORACLE

• Programming Languages: • C, C++, Java (core),T-SQL,MSSQL

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

PROFESSIONAL EXPERIENCE

SECURITY HEALTH PLAN OF WISCONSIN ,WI July 10 – Till Date

SQL Server DBA

Security Health Plan of Wisconsin provides health insurance products and related services to some 150,000 members in more than 30 Wisconsin counties. Its network includes about 4,000 physicians, hospitals, and health care facilities, as well as pharmacies across the US. Security Health Plan provides policies for groups, individuals, and families. Its products include HMO plans, Medicare plans, prescription drug and equipment coverage, and disease management programs, as well as administration services for self-funded plans.

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 server 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.

Involved in ETL process under development, testing and production support environments.

Provide flexibility and performance to simplify the creation and maintenance of partitioned tables in SQL Server 2005.

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.

Develop all the required stored procedures, user defined functions, and triggers using T-SQL and PL/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 2000 to 2005, SQL Server 2005 to 2008 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.

Hands on experience with the third party tools (Erwin, Fog Light, VERITAS)

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.

Maintain the database consistency with DBCC, DMF and DMV’s at regular intervals.

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, PL/SQL, MS Access, Erwin.

DELL, Roundrock , Texas Oct 09-June 10

SQL Server DBA/Developer

Dell Inc. (Dell) is a global information technology company that offers its customers a range of solutions and services delivered directly by Dell and through other distribution channels. Dell is a holding company that conducts its business worldwide through its subsidiaries. The Company operates in four segments: Large Enterprise, Public, Small and Medium Business, and Consumer. The Company’s Large Enterprise customers include large global and national corporate businesses. Its Public customers, which include educational institutions, government, health care, and law enforcement agencies, operate in their own communities.

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.

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 procs.

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, MYSQL.

Washington Mutual Bank, Seattle, WA Mar 08-Sep09

SQL SERVER DBA

Washington Mutual one of national bank of USA provides day to day banking to consumers offers credit cards, gift cards. WaMu application developed to provide customer care solution (BPO, online queries and handling customer’s requests). The application has got all functionalities like call start handler, call end handler, call recording, call disposing features and other functionalities.

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.

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

Michigan Department of Transportation, MI Nov 07 –Mar 08

SQL Server DBA/Developer

Michigan is the international center for automotive engineering and design and is known for its outstanding transportation facilities available throughout the United States.

Responsibilities:

Involved in Providing Complete Database and Application Support which includes Server Upgrades, Build out’s and Migration of Servers from 2000 to 2005 SP3

Performance tuning operations like Load balancing, Archiving, Indexing, Query optimization, performance monitoring.

Controlling day-to-day activities of Production database and troubleshooting the issues.

Index Defragmentation by Rebuild/Reorganize of Indexes on a monthly basis across all Databases.

Providing technical helpdesk support & assistance for online Production issues 24X7

Co-coordinating with Team Members & supporting the clients for product implementation & daily support activities

Responsible for Installation, Upgrade, Design, and Implementation of SQL Server 2000 and 2005 Enterprise database environment for multiple client’s sites.

Responsible for more than 50 SQL Server instances and 100 databases

Resolved database performance issues (IO saturation, disk bottleneck, network bottleneck, etc.…), database capacity issues, replication, and performance tuned the stored procedures for optimal efficiency using execution plans, profiler traces and database engine tuning advisor

Created and implemented best backup, recovery strategies (Full Backup Model with 1-hour period transaction logs backup.) and re-indexing process.

Designed and implemented Disaster Recovery sites using Mirroring and Log Shipping

Environment: SQL Server 2000/2005, Windows 2003/2000, T-SQL, Profiler, Lite speed.

Intelligroup, India Jun 05 – Sep 07

Database Engineer / System Engineer

Intelligroup is a global provider of innovative consulting, technology, and outsourcing services. We pride ourselves on delivering quantifiable value to our customers and exceeding their expectations. We understand industry pain points, and deliver solutions that leverage the process knowledge of our consultants. Our services are broad based and include business process improvement, analytical services, ERP implementations, global roll-outs, E-business solutions, upgrades, testing, as well as application management, and infrastructure support. Our Lifecycle management services leverage tools that we have developed for system performance and business process optimizations.

Responsibilities:

Administered and maintained production/Development servers with more than 1 TB of database size 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 Database mirroring, 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 Planner for the Performance of SQL Server which covers Database Integrity Checks.

24/7 on call support, 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/7.0, Windows 2003/2000, VB, T-SQL

Contact this candidate