SUMMARY

• Over 7 years of working experience in SQL Server Database Administration, Performance Analysis, Database Design, Development and Support of SQL Server 2008/2005/2000 in Production, Development, Test, Cluster and Replication Server Environment.
• A highly qualified, goal - oriented IT professional with extensive experience with SQL Server 2008/2005/2000 Database Administration in 24x7x365 environment.
• Well equipped with the working knowledge of application development life cycle methodologies, database and application performance tuning.
• Expert in installation and configuration of MS SQL Server 2005/ 2000 Databases.
• Extensive experience in SQL server 2000 servers to 2005, few SQL server 2005 servers to 2008, including Replication and clustered SQL Servers and as well as side-by-side upgrade process.
• Experience in Planning and executing disaster recovery (DR) exercises on the DR servers.
• Working experience in clustered environment (Active / Passive, Active / Active) to further increase scalability and stability of business critical systems
• Responsible to follow the company guidelines / regulations to ensure company data is held in a secure manner, including electronic access or in written format.
• Gathering data requirements, and designing and fine-tuning of databases as per the requirement of clients. Complete Administration of MS SQL Server Databases is my primary responsibility
• Increased the Server Availability time with optimum level of Database Recoverability by incorporating the SQL server Differential backup and LOG Backup.
• Extensive knowledge of Relational Database Management Systems.
• Extensive experience in upgrading SQL Server 7.0 to 2000, SQL server 2000 servers to 2005, few SQL server 2005 servers to 2008, including Replication and clustered SQL Servers and as well as side-by-side upgrade process.
• Experience of working in large business critical systems, supporting multiple environments (Production/Business Readiness Test/Development).
• Responsible to follow the company guidelines / regulations to ensure company data is held in a secure manner, including electronic access or in written format.
• Solid experience and outstanding knowledge of high availability SQL Server solutions, including Log shipping, Replication and SQL Server clustering.
• Experience in Replication - Snapshot, Merge and Transactional.
• Good hands on experience on Data Migration
• Extensively worked on 32 bit and 64 bit clustered and standalone server environments.
• Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, Database consistency checks using DBCC Utilities.
• Expert in performing database consistency checks and planning and scheduling Backup & Recovery
• Experience in using methods like Bulk Copy (BCP) and Data Transformation Services (DTS) and SQL Server Integration Services (SSIS) in MS SQL Server 2000/2005 and Analysis services (SSAS).
• Hands-on working experience with analyzing query plans, using extended Stored Procedures, managing indexes and locks, troubleshooting deadlocks
• Experience in configuring SQL jobs and Windows tasks for performing scheduled activities like backups and purging / archiving data.
• Expertise on Implementing High Availability options with Zero Data Loss and real-time apply environment.
• Possess a proven ability to streamline processes and coordinate efforts between diverse groups.
• An adaptable leader rapidly learns new technologies and stays abreast of trends in the industry to place the company at the forefront of technology and increase productivity and profitability
• Good team player, strong interpersonal and communication skills combined with self-motivation, initiative and the ability to think outside the box.

TECHNICAL SKILLS

Databases: MS SQL Server 2000/2005/2008/2008 R2, Ms Access 2000/2005.

Database Tools: SQL Server Management Studio, SQL Server Business Intelligence Development Studio (BIS), Database Engine Tuning Advisor, Enterprise Manager, Query Analyzer, SQL Profiler, Data Transformation Services, Upgrade Wizard, Replication,, SQL reporting, SSIS,MAP Tool, SQL Compare.

Programming: SQL, TSQL, BASIC, C / C++, XML, HTML, Perl and Shell Scripting.

Operating System: Windows 2008R2/2003/2000, Advanced Server, NT & Windows 9x, Linux.

Network Topologies: TCP/IP, DNS, WINS, DHCP, FTP, SNMP, SMTP

Case Tools: MS Office 2000/XP/2003/2007, MS Outlook 2000/2003/2007 , Visio, Clear Quest.

PROFESSIONAL EXPERIENCE

Confidential, AZ

Database Administrator

Responsibilities:

• Performed Functional, Regression, Stress and System testing.
• Analyzed results of the tests by creating reports
• 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 with users and sign offs.
• Expertise in designing databases and capacity planning.
• Working on data mining and Microsoft analysis services
• Rebuilding the indexes at regular intervals for better performance
• Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.
• Monitored and modified Performance using execution plans and Index tuning.
• Rebuilding the indexes at regular intervals for better performance
• Managing the VERITAS net backups.
• 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.
• Developed various views and functionalities for the Affinity Compensation system department according to their specification.
• Designed and developed file loading process by creating complex stored procedures, functions and bind them with DTS package for logical execution.
• Created DTS 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.

Environment: MS SQL Server 2008 Enterprise Edition, ETL, VB Script, T- SQL, MS Excel, MS Access, Crystal Reports 11, Oracle.

Confidential, MA

SQL Server DBA

Responsibilities:

• Designed and developed Packages, Stored procedures, Functions and Triggers, Views and complex SQL statements for applications.
• Responsible for creating Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Rules and Defaults
• Designed and developed ETL packages for extracting and loading the data into appropriate tables in the database using SQL Server Integration Services (SSIS)
• Created automated stored procedures for day end operations using SQL Server agent.
• Coordinated with front-end for implementing logic in stored procedures and functions.
• Created jobs, alerts to run SSIS packages periodically.
• Designed DTS/SSIS package to export and import data from SQL Server to Access, text files and Excel files.
• Performed Server installation and configuration using SQL Server 2005.
• Created the automated processes for the activities such as database backup processes using the Integration Services.
• Setup backup restoration for the development and test boxes.
• Automated processes using SQL Server jobs.
• Scheduled Database and Transactional log backups using the Database Maintenance Plan Wizard.
• Created and monitored database maintenance plans for checking database integrity.
• Generated periodic reports based on statistical analysis of data using SQL Server Reporting Services (SSRS) according to the client requirements.
• Created Windows Logins and privileges to User Accounts/Groups and objects.
• Used DBCC commands to troubleshoot issues related to database consistency.
• Worked with Application Developers and Business Analysts to produce all required documentation.

Environment: MS SQL Server 2005, MS Access, Windows Server 2003, HP-UX.

Confidential, MEMPHIS TN

SQL Server DBA

Responsibilities:

• Installed MS SQL Server 2005 and 2008, updating with latest service packs and security patches.
• Managing Databases spread across multiple servers in Production, Development, staging & testing environments.
• SQL 2000, 2005 - Performed installation of SQL Enterprise 2005 64bit version on Windows 2003 servers on Enterprise systems of clustered and standalone HP servers in enterprise Data Centers. Patch applications.
• Installed and administered two node cluster Active/passive on Microsoft Windows Server 2003 R2 Enterprise Edition SP2 on SAN environment
• Worked on SQL 2008 data Compression and saved 8.0 TB of disk space.
• Using Policy based management of sql 2008. Created and implemented some polices which reduced the incident volume to 30%.
• Worked extensive with database design team and development team for database design and implementation, used Erwin and Visio for database design and SQL 2008 for development.
• We implemented a live data mirroring without any witness for all store databases.
• Worked on enhanced security features Data encryption.
• Configured Audit at server level and database level using All Action Audit (AAA) in SQL server 2008.
• Performing Version control of all DDL schemas and stored procedures of development Application databases into Team foundation server 2008(TFS).
• Expert in implementing the DDL triggers, Created DDL triggers to prevent accidental table drop and also to restrict access for unauthorized user.
• Used Data Partitioning, File and file group backups in SQL Server 2005.
• Performing Backup/Restore to/from Tape (Legato server) and Disk.
• Created custom log-shipping to manage Disaster Recovery and Production Support restores
• Worked in Huge Replication Environment.
• Scheduling the DBCC commands to run daily, weekly basis.
• Developed automated tasks for daily, weekly and monthly database maintenance such as database backup, database integrity verification and indexing using Control-M agent and SQL Server Agent.
• Expert in Using DMV’s, Performance dash board, Mirroring, database snapshot.
• Worked file and file group Backup/Restore.
• Involved in logical designing and physical designing the databases using ERWIN.
• Forward engineer tool used to generate DDL scripts from physical model.
• Performing DB Security, creating users, roles, and assigning permission to them.
• Used Online Indexing and online Restoring in SQL 2005
• Used Performance Monitor/SQL Profiler to analyze long running /slow queries and tune the same to optimize application and system performance.
• Installed, authored, and managed reports using SQL Server 2005 Reporting Services.
• Evaluated data storage considerations to store databases and transaction logs.
• Involved in Source Data Analysis, analysis and designing mappings for data extraction also responsible for Design and Development of SSIS Packages to load the Data from various Databases and Files.
• Installed, authored, and managed reports using SQL Server 2005 Reporting Services.
• Worked on different third party tools like FogLight, Spotlight and Redgate.
• Review T-SQL code to verify it meet standards for both performance and error handling according to DBA standards.
• Created Logon trigger to validate users connecting through different applications.
• Supporting 24/7 Production Environment.

Environment: MS SQL Server 2008/2005, Enterprise Edition, Business Intelligence Development Studio(BIDS) - SQLServerIntegrated Services (SSIS), DTS, SQL Agent, SQL Profiler, Database Tuning Advisor, Database Mail, Notification Services, T- SQL, Windows 2003 server

Confidential, Minneapolis, MN

SQL Server DBA

Responsibilities:

• Prepared DTS packages to load data from different source systems to Production
• Taking care of client/server connectivity, query optimization, back-up/recovery.
• Monitoring Snapshot and Transactional Replication in production boxes.
• Modifying DTS scripts to handle automated tasks for Data Loading.
• Installing MS SQL Server, configuration and doing performance tuning, capacity planning, and taking care of failover clustering.
• Involved in Creating roles and responsibilities to the developers.
• Created Import, Dimension, Fact and Summary Tables for each Client.
• Created new Stored Procedures for new ETL loads.
• Created new ETL jobs running on SQL ETL Servers
• Proper use of Indexes to enhance the performance of individual queries and hence the Stored Procedures.
• Involved in creation of the database, creating tables, writing stored procedures, functions, triggers.
• Involved in extracting the data using SSIS from OLTP to OLAP and also from the other databases like Oracle by creating a Linked Servers.
• Used SQL Server Integration Services (SSIS 2008) to perform bulk insert operations from SQL Server 2008 databases to flat files/CSV/XML files and vice versa.
• Improved automation of existing processes of SQL using stored procedures and SSIS packages.
• Developed custom reports and deployed them on server using SQL Server Reporting Services (SSRS 2008).
• Developed Queries for generating drill down, drill through reports in SSRS 2008.
• Used various kinds of Data sets with SSRS.
• Involved in creating SQL server Analysis Projects using MS SQL Server 2008.
• Responsible for database backups, restoration and scheduling backup strategies.
• Implemented transactional replication model for Backup and Restore of DB.
• Involved in developing couple of ASP.net pages with c# as the code behind.
• Performed job scheduling to ensure execution of certain jobs and daily updates.
• Used ER-win (ERWIN) for data modeling.
• Performed system administrative tasks in SQL environment, including definition of user roles, setup and security.

Environment: MS SQL Server 2008, Oracle, T-SQL, ASP.Net, C#, Replication, MS ACCESS, MS Excel, SSMS, SSIS, Business Intelligence Development Studio/SSRS, XML, ERWIN, Agile-Scrum.

Confidential

MS SQL Server Developer

Responsibilities:

• Actively participated in interaction with users, team lead, DBA’s and technical manager to fully understand the requirements of the system.
• Used Joins, correlated and non correlated sub-queries for complex business queries involving multiple tables from different databases.
• Implemented Functions, views, triggers and stored procedures and enforced business rules via checks and constraints.
• Created indexes on selective columns to speed up queries and analyses in SQL Server Management Studio.
• Created SSIS Packages to retrieve PII user data from the Flat files on monthly and weekly basis.
• Created datasets, data source and involved in deploying the reports in to the report server.
• Created reports using SQL Server 2005(SSRS) and integrated into the web front end.
• Involved in generating Matrix reports, Sub reports and complex reports with multi value parameters for the analysis of Performance.
• Created Cross-Tab, Sub-Report using RDL. Promoted RDLs to Reporting Service Server.
• Worked on Performance tuning, and optimization of procedures and queries.
• Created ad-hoc queries from SQL Server databases for custom reporting needs.
• Worked on querying data and creating on-demand reports using Report Builder in SSRS.
• Developed complex Stored Procedures to generate various Drill-through reports, parameterized reports and linked reports using SSRS.

Environment: SQL Server 2005, SSIS, SSRS, Erwin, ASP.NET 2.0, VB.NET, ADO.NET, .NET Framework 2.0, IIS 6.0, Microsoft Excel Visual Source Safe 6.0, Microsoft PowerPoint.