SUMMARY:

• Over 7 plus years of Microsoft SQL Server Database Administration & Development experience in SQL Server 2008R2/2008/2005/2000.
• Installed SQL Server 2000/2005/2008/2008R2 on new 32 - bit and x64-bit Operating System.
• Involved in Migrating from SQL Server 2000 to SQL Server 2005 and SQL Server 2005 to SQL Server 2008.
• Experience in upgrading SQL server software to new versions and applying service packs and patches.
• Worked on applying SQL Server hot-fixes / Service Packs on all production and development instances on quarterly basis based on recommendations from Microsoft Tech-net.
• Installed SQL Server Client on all Client Desktops.
• Experience in working with Windows Servers 2000 / 2003 / 2008 .
• Proficient with SQL Management Studio, Enterprise Manager, Query Analyzer, Business Intelligence development studio, report builder 2.0, rescheduling jobs with SQL Server Agent.
• Expertise in deployments, certificate renewals, process job tickets & bugs, test verify backups and recovery.
• Highly proficient in database Backup, Restore, Recovery, Linked servers, and Database Maintenance Plans.
• Created Security by setting up groups and then logins for each Roles or Users for Maintenance of Databases.
• Documented Disaster recovery plans and participated in disaster recovery drills.
• Successfully tested and implemented Log Shipping technique used for warm backup solution for MS SQL server2000/ 2005/2008 databases.
• Proficient in implementing different types of Replication models like Snapshot, Transactional, Merge and Peer-Peer.
• Experience in Implementing Database Mirroring in SQL server 2005/2008.
• Involved in Installing, Configuring and Maintaining of Cluster in SQL Server 2008 and SQL Server 2005 in Active/Passive.
• Auditing database configuration and security configurations.
• Actively involved in System Performance by tuning SQL queries and stored procedures by using SQL Profiler, Database Engine Tuning Advisor, Windows performance monitor, DMVs, Resource Governor, Data collection Reports, DBCC and Custom Script, Built in performance Report and Activity Monitor.
• Scanned teh data pages, Indexes and checked teh storage space used by each table.
• Experience with Database Backup and Restore.
• Experience in Scheduling and creating SQL Server jobs as well troubleshooting when jobs fail.
• Proficient in migration of Data from Excel, Flat file, Non SQL db's Oracle/Db2/Sybase to MS SQL Server by using SSIS.
• Working noledge in SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS) to manage ETL environment.
• Experience in working with huge databases, troubleshooting issues and documenting teh causes.
• Developed writing parameterized Queries for generating reports, formatting report layout, sub reports using global variables, expressions and functions in SSRS 2005/2008R2.
• Ability to meet deadlines, quickly adapt to different project environments and ability to work with different team across geographical locations.
• Experience in providing good production support for 24x7 over weekends on rotation basis.
• Excellent organizational, interpersonal and communication skills with high level of adaptability and flexibility to adjust to changing work positions.
• Strong time Management skills and excellent team player.
• Ability to adapt quickly to changing environments.

TECHNICAL SKILLS:

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

Database: MS SQL Server 2000/2005/2008/2008R2, MS Access

Operating System: WindowsNT4.0,Windows2000,Windows2003/2008/professional/winxp prof/standard, Performance Monitor.

Reporting Tools: MS SQL Server Reporting Services

SQL Server Tools: MS SQL Server Reporting Services (SSRS), MS SQL Server Integration Services (SSIS), Data Transformation Services (DTS), SQL Server Management studio (SSMS), MS SQL Server 2000 Enterprise Manager, SQL Query Analyzer, SQL Profiler, DTA, Execution Plan.

PROFESSIONAL EXPERIENCE:

Confidential, Woodland Hills, CA

SQL Server DBA

Responsibilities:

• Upgrading and installation, creating and managing databases, integrating MS SQL Server and Windows 2003/2000.
• Involved in Database backups and Transaction log backups & restoration, backup strategies, scheduling teh backups. Backing up system & user databases and restoring them whenever necessary.
• Administering teh MS SQL Server by creating user logins with appropriate roles, dropping teh logins, monitoring teh user accounts, creation of groups, granting teh privileges to users and groups.
• Scheduled teh transaction logs for Log shipping operations, to apply them on other standby server sequentially.
• Implemented Database Mirroring for critical operational databases to provide no loss of data.
• Successful in implementing and setting up teh replication ( Snapshot / Transactional/ Merge/Peer-Peer).
• Configured and Implemented Active/Passive clustering and Active/Active clustering.
• Performance Monitoring with SQL Profiler and Windows System Monitor.
• Creation of maintenance plans of teh SQL Jobs using SQL Server Agent.
• Responsible for stored procedures optimization, index tuning by using Database Tuning Advisor (DTA).
• Involved in Creating tables, indexes and designing constraints.
• Maintaining teh consistency of databases using DBCC commands.
• Installed SQL Server hot fixes from SQL Server 2000/2005/2008/2008R2.
• Worked on DTS Packages, DTS Import/Export wizard for transferring data from Database.
• Monitoring teh performance of SQL Server on pre-production servers.
• Worked on Change control management.
• Planning and Testing to Upgrade SQL Server 2000 Databases with SQL Server 2005 and SQL Server 2005 databases with SQL Server 2008.
• Generated different reports using MS SQL Reporting Services.
• Working noledge on Disaster Recovery Plan, Testing and analyzing and continuous update of documentation.
• Redesign of database architecture with halp of Microsoft Database development group and internal staff to increase application concurrency and performance.
• Resolving Locking and Blocking issues.

Environment: SQL Server 2000/2005/2008 R2, T-SQL, Excel, Windows 2003/2008R2 Server, Visual Source Safe 6.0, Erwin 5.0, Confidential Internal applications.

Confidential, Minneapolis, MN

SQL Server DBA

Responsibilities:

• Installed MS SQL Server2005/2008, Performed Database Design and created User Databases
• Performed migration of all teh databases from Sql Server 2000 to Sql server 2008 along with all DTS packages to SSIS.
• Troubleshooting of Upgrades issues like SQL Server 2000 to SQL Server 2008, Edition upgrades and hotfix upgrades
• Excellent noledge in Recovering databases in emergency/data file missing/log space full
• Scheduled backups and performed restore operations for system test data depending on developers’ requirement.
• Created maintenance plan and sql server jobs and scheduling them, setting emails alerts on failure.
• Managed Disk space, memory and User connections.
• Tuned SQL Server using DMVs, SQL Profiler and Windows Performance Monitor.
• Detected and troubleshootSQLServer related CPU, memory, me/O, disk space, and other resource contention
• Performed Database Integrity Checks, updated Database Statistics and performed Re-indexing.
• Performed query plans and made sure each and every query is using appropriate indexes.
• Using profiler to find badly performing queries and deadlocks
• Created SSIS Packages to upload test data from Text files.
• Used DBCC checks and fixed data corruption in Application databases
• Administered MS SQL Servers by creating User logins and assigned them proper permissions, observing all process running on teh server making sure server will run at its best.
• Responsible for Stored Procedures optimization, Performance tuning & index tuning.

ENVIRONMENT: MS SQL Server 2000 and 2008, Windows 2000 Advanced Server, Erwin

Confidential, Palmerton, PA

SQL SERVER DBA

Responsibilities:

• Administration and support on Large number of SQL Server instances in multiple data centers including Production, Stage, Test and Development Environment.
• Supporting 24x7 for production systems
• Managed logins and user accounts, including assigning database object permissions and ancillary privileges.
• Database Migration and configure database Recovery if necessary.
• Install Service Packs on clustered and non-clusteredSQLServersystems.
• Backup and restore large-scale SQL Server databases
• Implemented and maintainedSQLServerdatabase replication between multiple databases.
• Implement data availability solutions like Online Restore, Online index Operation, Database Snapshot, and Fast Recovery.
• TEMPHas experience in creating, configuring and managingSQLServerdatabase from scratch.
• Perform redirected restores of databases to Test, QA and development system.
• Troubleshoot, diagnose, remedy and documentSQLServerperformance and othercustomer issues.
• Support and Clearing teh database logs everyday
• Production support role to keep existing system stable and available, and to resolve end user issues as they arise.
• Performance monitoring and tuning T-SQL and database engines.
• Develop all teh required stored procedures, user defined functions, and triggers using T-SQL
• Database Maintenance and create Maintenance SQL Stored procedures
• Regular check done, updating statistics and monitoring security and hardware resource utilization
• Monitor performance, update statistics and rebuild indexes at regular intervals for better performance.
• Analyzed long-term databases performance trends to optimize database and application performance.
• Maintained documents and implement Disaster recovery models.
• Built scheduled-jobs to migrate data from flat files to database

Environment: Windows 2000 Advanced Server, SQL Server 2000/2005; Windows 2003 Advanced Server, SQL Profiler.

Confidential, Troy, Michigan

SQL SERVER DBA/DEVELOPER

Responsibilities:

• To provide day to day support to user queries and customer advice Due to teh nature of teh environment, their is often a necessity to carry out scheduled work outside of Working hours.
• Involved in SQL Server Installation and applying Service Packs for teh Servers as released/requested.
• SQL Server Performance Monitoring and problem resolution.
• Excellent team working skills balanced with ability to work alone and a positive attitude.
• Backing up System, User databases (Complete Backup, Differential Backup, Transaction log backup) and Scheduling.
• Restoring (Complete Backup file restore, Differential Backup file restore, Transaction logs backup files restore), Monitoring (Error Logs, Jobs).
• Monitoring Database Server’s Health and Tuning accordingly.
• Upgraded teh Jobs, Alerts, SQL Mail Agent and Scheduling DTS and SSIS, SSRS Packages.
• Handling Blocking/Locking incidents if any.
• Moving teh Databases from one location to another location.
• Managing Database Users and Security.
• Managing Database vs. Data files (.mdf, .ldf).
• Creating Databases, Database Size estimation, File growth, Log Data Files.
• System & User Databases Maintenance and Administration.
• Setting Database properties, SP Migration, Tables migration, Database Security.
• Working on tickets sent by customers for migrating objects and data from test server to production server, restoring and backing up databases in production environment.
• Available production support for 24*7 whenever required.

Environment: MS SQL SERVER 2000, SQL Profiler, Enterprise Manager, Query Analyzer, SSIS, MS ACCESS.

Confidential

SQL DEVELOPER

Responsibilities:

• Installed and configured MS SQL server on multiple environments.
• Involved in creating tables, columns, triggers, and T-SQL code. Used Indexes, views, trigger and store procedures for updating and cleaning teh existing data and also teh new data which TEMPhas to be added.
• Expertise in software development life cycle (SDLC) processes.
• Creating new database / tables to put in teh extracted data and rebuilding teh relationship.
• Involved in writing triggers to apply teh business rules. Back up & restoring user databases.
• Monitoring of teh log files. Maintaining teh database by taking teh backup of teh data and log files and restoring teh backup files on different environments (development, test).
• Involved in teh Performance Tuning and backup of two Microsoft SQL Servers.
• Involved in creation of distributed partitioned views, debugging/troubleshooting stored procedures, upgrading existing ones.

Environment: SQL Server 2000, Windows 2000/XP SQL Query Analyzer, SQL Enterprise Edition.