Professional Summary:

• A Microsoft certified Professional over 7 years in databaseadministration, testing &programming ofSQL Server 2000/2005/2008/2008 R2
• Proficient in SQL Server 2000/2005/2008on large scale/mission critical/ high available environments.
• Expertise in administering SQL Server Installation, configuration, Security, Backups, High Availability, Performance tuning and maintenance with outstanding troubleshooting capabilities.
• Involved in database design and data modeling, creation of DB Objects like Tables, Constraints (Primary Key, Foreign Keyand Unique), Indexes, Defaults, rules using DM Tools likeSQL Diagrams.
• Expert in T-SQL DDL/DML, perform most of the SQL Server Enterprise Manager and Management studio functionality using T-SQL Scripts and Batches.
• Expertise in creating complexQueries, heavyStored Procedures,Views, effective functions, and appropriate Triggers to facilitate efficient data manipulation and data consistency.
• Experience in using tools like Database Engine Tuning Advisor,Index Tuning Wizard,SQL Profiler, PSSDIAG’sand Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.
• Worked extensively on system analysis, design, development, testing and implementation of projects (Complete SDLC) and capable of handling responsibilities independently as well as a proactive team member.
• Expert in Data Extraction, Transforming and Loading (ETL) using SQL Server Integration Services (SSIS), DTS,Bulk Insert, BCP involving data migrations and loads.
• Used DTS/Integration services (SSIS) to migrate data from one system to another and performed several transformations to ensure data integrity and validity.
• Experience in creating Jobs, Alerts, Maintenance plans, SQL Mail Agent, and scheduled DTS and SSIS Packages.
• Good Hands on Resolving complex issues and Error Handling in SSIS.
• Involved in Installation, Configuration, Development, Deployment and Troubleshoot Reporting services using SSRS 2000/2005 across various environments.
• Expertise in generating reports using Crystal Reports, SQL Server Reporting Services and MSExcel spreadsheets.
• Strong ability in defining query for generating drill down reports, handling parameterized reports and creating stylish report layouts in SSRS 2005.
• Good SQL Server Administration skills including backup/recovery, database maintenance, user authorizations, Database creation, Tables, indexes.
• Key player in design and migration of SQL databases from one data center to other data center as a part of enterpriselevel data center migration.
• Worked extensively on Server consolidation, High availability. Worked with Disaster RecoveryPlanning, Security Management, Replication and Log shipping under Server High Availability plans.
• Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAIDlevels.
• Configured and maintained Transactional replicationfor standby/Reporting environments and having outstanding capabilities in troubleshooting replication errors and handling logs.
• Highly experienced with SQL Server 2008 upgradation & Upgrade Advisor (In place & Side-by-Side) forlarge and mission critical applications.
• Highly experienced on SQL Server 2005 migration from SQL Server 2000.
• Experience in using DMV and dynamic management functions for finding out long running queries.
• Implemented SQL Server 2005 concepts like database mirroring, database snapshot, DDL triggers, online indexing.
• Created Linked Servers between SQL Server& other heterogeneous systems like Oracle, Sybase, and IBM DB2. Also created DTS packages for data transfer between various environments.
• 24 X 7 Production Database on Call Support.
• Having hands on experience in using Third party tools likeLitespeed, Spotlight,VeritasNetBackup.
• A well-organized, goal-oriented, highly motivated effective team member with excellent analytical, troubleshooting and problem solving skills.

Education

• Bachelors of Technology in Computer Science

Microsoft Certification

• Implementation and Maintenance with Microsoft SQL Server 2005 Enterprise Edition (Exam 70-431)

Technical Expertise

MS SQL Server 2008 R2/2008/2005, MS SQL Server2000

Programming

Visual Basic 6, C, C++ & T- SQL, PERL

Operating System

Windows 2008 R2/2003 R2/2000 Advanced Server, NT & Windows 9x

Other Software

Active X, IIS, Microsoft Transaction Server, VBScripts, HTML, XML

Tools

SQL DB Access, Performance Monitor, Backup Utility, QuestLitespeed, Veritas Net Backup, SSIS, SSRS, ESP scheduler, SCOM,IBM Director, Spotlight, DBArtisan,

Network Topologies

TCP/IP, DNS, WINS, DHCP, FTP, SNMP, SMTP

Professional Experience:

Confidential,Des Moines,IA April ’09 –till date
Database Analyst
Aviva USA, part of Aviva plc, is the fifth-largest insurance group in the world. One of the fastest-growing U.S. life insurers, Aviva USA offers a competitive portfolio of long-term savings, insurance and retirement income products designed to help customers make the most out of life. The job was to develop, implement and maintain all databases including stored procedures, triggers, and complex queries, which include the administration of various databases in all SDLC (DEV/UAT/Preprod/Prod) environments.
Responsibilities:

• Installed&Configured SQL Server 2008 R2/2008/2005 64/32bit versions on Windows 2008/2003 R264/32 bit servers on Enterprise systems comprising of clustered and standalone enterprise Data Centers.
• Installed and administered two node cluster on Microsoft Windows Server 2003 R2 Enterprise Edition SP2 on SAN environment via VERITAS Cluster Suite
• Migrated SQL server 2005 to SQL Server 2008 R2/ 2008 acrossvarious environments includingDev,Test,Production and DR environments.
• Involved in Patching Servers, Applying hot fixes, schedule downtime, co-ordinate Server/Database related activities.
• Upgraded SQL Server 2008 to SQL Server 2008 R2forTFS Share point 2010 internal environments.
• Involved in Day to day administration activities like Security, DB objects creation,Change Control Promotion across environments, Troubleshooting developer issues, Backups & jobs monitoring.
• Designed and implemented a release management structure to support changes to the primary customer facing application.
• Interfaced with various application teams on technical requirements, proposed solutions and developed specifications.
• Designed and implemented restore system for SQL 2005 that interfaced with both the application team and the database administration staff.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies and Scheduled Replication process for updating our parallel servers.
• Automated databases refresh from primary to reporting web application to run on a daily\\monthly basis.
• Designed and implemented a standard weekly database maintenance job to all databases using maintenance plan which involves DBCC Checkdb, Rebuild\\Reorganize indexes based on index fragmentation.
• Performed daily task monitoring including backup and restore and extensive usage of SQL Server 2005 tools and 3rd party toolslikeLitespeed, VeritasNetBackup and ESP.
• Used DMVs to troubleshoot performanceissues and to determine long running queries.
• Involved in Hardening of Windows\\SQL Servers based on CIS document to comply audit standards to avoid potential security breaches.
• Involved in scheduling and maintaining batch jobs thru SQL Server Agent and thru various Shell scripts, VB script, .bat files, ESP.
• Involved in configuration of Raid Levels, Files and File group placements for VLDB’s up to 2 Terabytes to achieve maximum performance and uptime.
• Responsible for 24/7financiallycritical production servers support.
• Stabilized a Cognos reporting system with a SQL Server 2000 backend, implementing job error notifications and job monitoring tools
• Refreshed lower(Dev,Research) environments often as requested by the Developers and testers, and applied the schema changes in respective environments.
• Extensively worked on SQL Server Integration Services (SSIS). Designed and built DTS/SSIS packages and ran several scripts for implementing changes in the backend for applications.
• Migrated DTS packages from SQL Server 2000 to SSIS SQL server 2005 as part of upgrading various systems.
• Developed SSIS packages in SQL Server Business Intelligence Development Studio and deployed them to Dev\\Integration\\UAT\\Prod using manifest files.
• Extracted data from different Data sources and transformed the data using Lookup, Data conversion, Derived columns etc. and loaded this data to the destination SQL Server using SSIS.
• Used expressions to setup standard Logging in all SSIS packages for troubleshooting errors.
• Involved in SSRS Installation, Deployment, and configuration, and Support various business units and systems.
• Worked with Server Support team and configuredSCOMalerts to monitor and address server\\db related issues
• Planned migration process from one Data center to other Data centers.
• Develop and documented all software and hardware applications within Windows Server environments as part of Data center migration.
• Adhere to SOX regulations and followed Change Control procedures and tickets for DB Changes.

Environment:SQLServer2008 R2/2008/2005/2000, SSRS 2005/2000/DTS/SSIS, Windows 2008/ 2003 R2/2000 Server, VCS, SCOM, VERTIAS Net Backup, MSE, VSS,PSSDIAG,SQLProfiler,LiteSpeed 5.2,Spotlight,DBDiff, ChangeManager

Confidential,TXAug ’08 –Apr’09
MSSQL DBA/ SSIS/ SSRS Developer
Responsibilities:

• As a member ofDatabaseandBIteam, extensively worked on Database Administration activities and BI Support activities.
• Migrated multiple financially significant applications from SQL Server 2000 to SQL Server 2005.
• Involved in Database Administration activities like Installation, Configuration, Backup, Security, Replication, and Data Migrations acrossall the servers.
• Created Logins, Roles, Schemas and other Security related activities for various groups accessing the systems.
• Created all the required Databases and objects like Tables, Indexes, and Constraints and maintain source control versions.
• Implemented Full, Bulk-Logged and Simple recovery models according to requirements.
• Involved in writing stored procedures for both Online and Batch requests handling business logic and functionality of various modules.
• Responsible for monitoring and making recommendations for performance improvement in databases by proactively involving in index (Defrag, Rebuild, Alter), DBCC maintenance jobs, file group modifications.
• Involved in writing various DB Objects like User defined functions, Instead of triggers, Usage of Indexes for accomplishing various tasks.
• Worked on analyzing and Performance tuning queries by looking at the Indexes, appropriate joins, Query Statistics and Execution plans using SQL Profiler /Query Analyzer/SSMS.
• Used SQL Server Profiler to determine deadlocks and identify possible causes.
• Worked on SSRS 2005/2000 to generate about 30+ reports for various user groups and developer groups.
• Have written Reports, Sub Reports, Data driven subscriptions, drill down reports using various features like Charts, graphs, filters etc.
• Created stored procedures to use as the datasets for the Report Design.
• Involved in generating reports for Forecasting Revenues based on the historical data and used various delivery mechanisms and formats to deliver the reports.
• Configured Subscriptions and Security for all critical reports.
• Involved in ETL Loads using SSIS/DTS Packages from various heterogeneous source systems into the databases for Dashboard Reporting on a daily basis.
• Involved in package migration from DTS to SSIS, running upgrade advisor against DTS Packages before migration, troubleshooting issues and conversion into SSIS through wizard or manually
• Involved in Table partitioning to improve I/O access.
• Handled the database components (Code migration, Change control) for application releases.
• Created technical specifications, test plans and test data to support ETL processes.

Environment: SQL Server 2005/2000, SSRS 2005/2000, SSIS/DTS, Visual SourceSafe, OLAP, Enterprise Manager, Query Analyzer, SQL Profiler,Active Directory and Windows XP platform, DB2 (Main-Frame), VB Script, MS Visio.

Confidential,FL Feb’07 - Jun‘08
SQLDBA
Responsibilities:

• Day to Day Administration activities for Installation, Upgradation, Security Configuration and Backup activities.
• Supporting applications in various stages (Dev, Int, Test, Pre-prod and Prod) before migrating to Production.
• Responsible for logical and physical designs for application and database tuning.
• Compare the diff environment and apply the schema changes to reflect the changes to the Pre prod environments that have gone to prod before the Target environment.
• Set up the scripts and format files to BCP to load the data from the Heterogeneous system to the Prod environment.
• Debug the slow running queries by running the trace & analyze load file thru query tuning.
• Involved in implementing the Job schedule on ESP scheduler as part of the standardization of the Job schedule.
• Involved in creating DTS packages to collect the configuration parameters and report any discrepancies in day to day changes of values.
• Extensive usage of data Migration tools such as DTS Export/Import, BCP& BULK INSERTwhich involves multimillion rows of data.
• Setup the Linked Servers between SQL Servers and other Heterogeneous environment (Mainframes).
• Setup the Jobs to Outdated Statistics which is essential when we run the BCP jobs.
• Added / Changed Tables, columns, triggers, and T-SQL code using Indexes, Views, Trigger and Store Procedures for updating and cleaning the existing data and also the new data which was to be added.
• Applying constraints and writing triggers to apply the business rules. Backing Up & Restoring User Databases.
• Responsibilities include the performance tuning and backup of Microsoft SQL Servers.
• Creating Distributed Partitioned Views, Debugging / Troubleshooting Stored Procedures, upgrading existing ones.

Environment: SQL Server 2000, Windows 2000/XP, Business Objects 5.x/6.x, Informatica 6.x/7.x, SQL Query Analyzer, DTS.

Confidential,India Apr’04 - Dec’06
SQL DBA /Developer

Responsibilities:

• Responsible for MS SQL Server Installation and configuration as well as applying service packs and hot fixes.
• Timely completion of activities fordatabase backup, restoration and health check of databases.
• Created Linked Servers between SQL Server 2000 & Oracle 8i and 9i. Also created DTS package for data transfer between the two environments.
• Provided User Access at all levels for both the network and the SQL Server databases;
• Configured and audited SQL Server security; managed SQL Server logins and user accounts/passwords; managed database object permissions.
• Involved in creating Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures, Triggers, Rules and Defaults.
• Created regular backups of databases and transaction logs.
• Implemented Log Shipping to move the database to another server at regular intervals.
• Responsible for capacity planning, monitoring Disk I/O, CPU and memory
• Performed Database Integrity Checks, updated Database Statistics and performed Re-indexing.
• Extracted query plans and made sure each and every query is using appropriate indexes.
• Created Logical & Physical Database modeling using Erwin tool.

Environment:MS SQL Server 2000, Oracle 8x, Windows 2000, Windows XP Professional, C#.Net 2.0