SUMMARY

• Total 12 years of experience in IT industry, over 9 years of experience as SQL SERVER DBA / Database Support / Designer/ Architect on MS SQL Server 2008/2005/2000 in Windows environment.
• Worked in production environment providing Production Support, Production database server implementation, Database Migration
• Experience in designing relational database model and implementation as per business requirement.
• Microsoft Certified IT Professional in Microsoft SQL Server 2008/2005/2000.
• 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 (DDL and DML).
• 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.
• Installed and configured SQL SERVER 2008/SQL2005 on Windows 2003 Clustered Server as well as on standalone server.
• Migrated SQL SERVER 2005 to SQL SERVER 2008 on clustered environment.
• Upgrades done from SQL 2000 to SQL 2005 and SQL 2005 to SQL 2008.
• Experience in maintaining SAN IBM ( NetApp) and DELL(EqualLogic).
• Provide capacity planning analysis for database resource requirements.
• Assigning of database change control tasks (CCT/tickets) using CA tool.
• Performed Migration of DTS to SSIS.
• Created and modified Stored Procedures and Functions to generate reports.
• Installation and configuration of SSIS, SSRS and SSAS.
• Lead medium to large-sized projects and participates on large projects dealing with leading edge technology.
• Develop and support connectivity strategies involving heterogeneous systems such as - SQL Server, MYSQL, Sybase, Oracle, Informix linked servers, remote procedure calls, open query commands.
• Support and trouble-shoot jobs and other system control processes.
• Experience in extracting and transforming data using DTS, Import Export wizard, Bulk Insert, BCP and SSIS Packages
• Experience in planning and implementing MS SQL Server Security and database permissions.
• Experience in using tools like Database Engine Tuning Advisor, SQL Profiler, and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.
• Experience in creating Jobs, Alerts, Database / SQL Mail Agent, and scheduled SSIS Packages.
• Excellent skills in database backup, recovery and restoration
• Implemented High Availability solution for databases like failover clustering, mirroring, log shipping.
• Fine tuned the weekly Purging procedures to reduce the total execution time from 4 hours to 1 hour. Also fine tuned Complex Queries and modified the existing indexes.
• Worked on Team Foundation server (TFS).
• 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

TECHNICAL SKILLS

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

Database Technologies/Tools: SQL Server Management Studio, SQL Server Integration Services, SQL Server Business Intelligence Development Studio, SQL Profiler, Database Engine Tuning Advisor, SSRS, SSAS, SSIS, Windows Performance Monitor, SQL IO, database structures, theories principles, and practices, reporting

Reporting Tools/ OLAP: Excel Spread Sheet

Programming Languages: VB 6.0

Operating Systems: Windows 2003, XP, 2000, NT

PROFESSIONAL EXPERIENCE

Confidential, SLC, UT

Sr. SQL SERVER DBA

Responsibilities:

• Administrating 400+ databases with max size of 4 TB on 30 SQLServersinto Production, Development, QA, Staging and Test Environment.
• Actively involved in designing the logical and physical architecture of the Databases.
• 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
• Installed and configured SQL SERVER 2008 Failover Cluster on Windows 2003 clustered server and standalone servers.
• Migrated SQL SERVER 2005 to SQL SERVER 2008 on clustered environment.
• Work extensively on Windows 2003 installation and Configuration.
• Installation Service Pack 3 and Cumulative updates installation on all SQL Server 2005 Instances.
• Installed and configured Instance SQL 2005 Failover Cluster on newly built Windows 2003 Server Cluster.
• Created Clustered and Non Clustered Indexes on tables, views, and columns
• Configured Server for sending automatic mails to the respective people when a SQL Job is failed, log files are grown beyond the predefined limit, or free space of the hard disks fall below the threshold limit.
• Created SQL scripts to pull OLTP data from different Informix servers into the staging database.
• Actively involved in System Performance by tuning SQL queries and stored procedures by using SQL Profiler, Database Engine Tuning Advisor and Windows performance monitor.
• Deployed the databases into the production server clustered environment
• Optimize Server Performance by Configuring Virtual Memory and Server tasking.
• Monitoring the system bottlenecks - CPU, RAM, Disk IO and Networking using performance counters, alerts.
• Created ETL process using SSIS for processing of data from ORACLE,MYSQL and Informix server for SQL SERVER backend reporting servers.
• Configured Server for sending Automatic Alerts to the support team when a SQL Job is failed, log files are grown beyond the predefined limit, or free space of the hard disks fall below the threshold limit.
• Deployed reporting server
• Installed and configured IDERA/Quest for audit of login and performance monitoring.
• Implemented database encryption(TDE) using certificates for securing sensitive data of credit card, account number, SSN no according to PCI standard.
• Created Database Maintenance Plans for Backup, Index rebuilding, Database consistency checks and statistics updates.
• Reviewing the database for the bottlenecks and implement the recommendations to improve performance.
• Installed and configured High Availability Solution mirroring and replication on SQL SERVER 2008/SQL SERVER 2005.
• Created disaster recovery site using SAN mirroring.
• Managing data storage in IBM (NETAPP) and Dell (EqualLogic) SAN.
• Fine tuned Functions, views, and the table schema for optimal performance
• Involved in database backup, recovery and restoration
• Capacity Planning - Analyzed the Database Growth and reported future space requirements.
• Closely worked with client services and development team for analysis of client requirement and worked with development team to configure those changes into database management configuration.
• Worked on translating business and application requirements into database environment configurations according to ITIL recommendation.
• Security Management - Handling Roles, Users, Logins and granting the Rights

Environment: SQL Server 2008/2005,Oracle,MySQL,Informix,Idera,Quest,SSRS, SSIS, VB.NET, Windows 2003 Server, SAN (IBM NETAPP, DELL Equal Logic)

Confidential, Seattle, WA

SQL SERVER DBA

Responsibilities:

• Administered 250+ databases in Database infrastructure of 50TB in total on SQL Servers.
• Installed and configured SQL SERVER 2008 on windows 2003 clustered server.
• Migrated SQL SERVER 2005 to SQL SERVER 2008.
• 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.
• Extensively worked on 32 bit, x64 bit clustered and standalone server environments.
• 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.
• Fixing data issues and writing various SQL scripts and procedures for migration process.
• Good at Data availability solutions like Online Restore, Online index Operation, Database Snapshot and Fast Recovery .
• Created and modified Stored Procedures and Functions to generate reports.
• Deployed Reports on Report Server.
• Implemented TDE encryption using certificates for sensitive data like credit card numbers and SSN number according to PCI standard.
• Migrated SQL SERVER 2000 to SQL SERVER 2008.
• Worked on High Availability Solution clustering and mirroring.
• Monitored and modified Performance using execution plans and Index tuning.
• 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.
• Involved in Troubleshooting existing and new DTS packages.
• Configured SQL mail agent for sending automatic emails when a DTS process is failed or succeed.
• Managing data storage using IBM NETAPP SAN.
• Worked on the DR site on IBM (NETAPP) by using SAN level mirroring.
• Created reports by using Crystal Reports and Excel Spreadsheet
• 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.
• Determine the SQL Server Installation options. Helped install SQL Server Management tools using SQL Server Setup Program.
• 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, VB 6.0, ASP, Windows 2003 Server, SQL Server Reporting Services (SSRS), SAN (IBM NETAPP)

Confidential, NYC, NY

SQL SERVER DBA

Responsibilities:

• Analyzing the load on the system, based on that laying out disks memory, processors of the Prod, UAT and development servers MS SQL Server applications in the organization.
• Creating standard controlled environment for DEV, UAT and Prod for all the MS SQL Server applications in the organization.
• Fine tuned the Indexes, Stored Procedures using SQL Profiler, Database Engine Tuning Advisor, Query Execution Plans and DMVs setup Backup, Restore, Maintenance plans, and Disaster Recovery plan.
• Installed and configured SQL SERVER 2005 on windows 2003 clustered and standalone server.
• Creating Development, system test, Integration test, Staging and production database environments.
• Database Designing, creating Database, users and giving appropriate permissions.
• Providing support to development team for writing Triggers, Views, User defined functions and stored procedures.
• Involved in performance tuning in SQL Server through Query, Server & Database Level and Query optimizations.
• Implemented mirroring for high availability of database server.
• Migrated SQL SERVER 2000 to SQL SERVER 2005.
• Using DTS (Import-Export) packages & SSIS (SQL 2005).
• Implemented Transactional Replication Server for online reporting server.
• Scheduling backups for MS SQL server databases.
• Security administration for MS SQL server.
• Producing reports to client (weekly & monthly).
• Regular backup and restore of database on development, acceptance and Production Server, use of replication, log shipping, security administration for MS SQL server.
• Solution of Trouble Tickets Like as Incidents and looking change control tasks CCT.
• Setting up scheduled jobs in SQL server agent for end of day activities. Regular deployment of (Databases, SQL Scripts, DTS) for acceptance & production environment.

Environment: SQL Server 2005, Windows 2003 Server, .NET 3.0, Informix

Confidential

SQL SERVER DBA

Responsibilities:

• Actively participated in gathering of User Requirement and System Specifications.
• Analyzing the Database change impact and Restructuring the existing database design when a change request comes in .
• Installed and configured SQL SERVER 2000 on windows 2000 advanced server on clustered environment.
• Created new database logical and physical design to fit new business requirements, and implemented new design into SQL Server 2005/2000.
• Migration of old data from SQL Server 7.0 to SQL Server 2000 using DTS and Backup and Restore option.
• Database Server Performance, tracking user activity, troubleshooting errors, tracking server resources and activities, tracing server events.
• Planned, implemented and monitored database maintenance and maintained a log of results
• Participation in client meetings.
• Installed and configured High Availability Solution mirroring and replication on windows advanced server and windows 2003 clustered server.
• Develop prototypes based on client's business needs and technical objectives
• Maintained Database authentication modes, creation of users, configuring permissions and assigning roles to users.
• Defined and administered database standards, controls, procedures and documentation
• Filtered bad data from legacy system using complex T-SQL statements, and implemented various constraint and triggers for data consistency.
• Created Views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Created DTS packages to transfer data from SQL Server to Access, Excel, and text file
• Extracted data from SQL Server for report, backup, testing purposes by using DTS, BCP, and Import/Export option.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensured database optimization by using Index Tuning Wizard, SQL Profiler and Query Analyzer (execution Plan).
• Created Users and Roles, and managed security and permission of database.
• Created stored procedures for automatic Scripting to backup transaction logs, log files, maintain archive of objects using schedules jobs.
• Restore database backups when required.
• Worked on translating business and application requirements into database environment configurations according to ITIL recommendation.
• Actively participated in User Acceptance Testing, and debugging of the system.
• Trouble shooting the failed jobs and setting up Replication to transfer data between servers.

Environment: SQL Server 2005/2000, Windows 2003 Server, Windows 2000 Server, ASP, VB6.

Confidential

SQL SERVER Support/Sr. Software Support Engineer

Responsibilities:

• Development of conversion scripts for conversion of data of non VSTL software’s for unhindered migration to VSTL software.
• Installed Sql Server 2000 on Windows 2000 server on clustered and standalone server.
• Designing and developing SSIS packages for Extraction, Cleansing, Transformation and Loading (ETL) of data from multiple feeds and sources into Data mart.
• Involved in Planning, installation and configuration of SQL Server.
• Administered, maintained, developed and implemented policies and procedures for ensuring the security and integrity of the bank database resources and activities.
• Testing of Any where banking solution module.
• Testing/Debugging of phone banking solution.
• Installation and configuration of Software at client premises
• Rectification of problems and explanation of queries to staff regarding software and hardware.
• Upgrading of software and coordinating with hardware vendor for problems in hardware.
• Proper training to the client

Environment: Windows 2000 Server, VB 6.0, IIS 4.0, Microsoft SQL Server 2000/7,Novell Netware 4.2