Summary

• Highly motivated SQL Server DBA role with over 8 years of experience in Database administration, Production support, Development, Reporting services using MS SQL Server 2008R2/2005/2000/7.0, OLAP, BI Suite (SSAS, SSIS, SSRS) and ETL Processes..
• SQL Server database administration strengths include: Installation, Configuration, Database design (physical and logical) using Erwin, Server and System security, Patching, Database creation, Performance tuning, Change Management, Schema change, Space management, Query optimization, Backup, LiteSpeed, Recovery, Normalization, Hot and Cold Backups, Data conversion, Authorizations, Tables, Indexes, Migration, running Database Consistency Checks (DBCC), Data mapping, Data dictionary tables, Planning capacity, Monitoring growth, Application database replication, Replication server, Logshipping, Database Mirroring, DTS, SSIS, SSRS, Security administration, User administration, Support, Maintenance, NDM (Network Data Mover/Connect: Direct), BMC Patrol, Microsoft Operations Manager (MOM), HP PolyServe.
• Hands on experience in Installing, Configuring, Managing, Monitoring, Troubleshooting, Upgrading and Migrating SQL Server 2008/2005/2000 on Clustered and Standby Environments.
• Migration from SQL server 2000 to 2005 and 2000/2005 to 2008 by using In-Place upgrade process and as well as side-by-side upgrade process, And documented the Upgrade Process.
• Worked with SQL Server 2008 new MERGE statement
• Expertise in Migrating SQL Server 2000 data bases into SQL Server 2005 and SQL Server 2008 and also expert in migrating DTS packages to SSIS Packages.
• Experience in implementing different types DR (disaster recovery) scenarios like Replication models like Snapshot, transactional, log shipping and Configure Database Mirroring in Cluster environment.
• Setting up and Monitoredtransactional replication, Database mirroring on Production and QA servers.
• Configured the servers on 32 bit and 64 bit clustered and standalone server environments.
• Have good understanding of SQL Server Active/Passive, Active/Active Clustering.
• Experience in supporting Very Large Database (VLDB) more than 2TB and troubleshooting problems
• Expertise in Database Backup and Recovery procedures by using native and litespeed to/from Disk /Legato server (Tape).
• Extensively used tools like SQL Profiler, Index Tuning Wizard, and Windows Performance Monitor for monitoring and tuning MS SQL Server performance.
• Experience in using Performance Monitor/Profiler to resolve Dead locks/Long running queries. And also good experience in data (table) partitioning.
• Good experience with implementing reporting solutions using transactional replication.
• Experience in data modeling like physical data modeling and logical data modeling by using Erwin tool.
• Expertise in writing Stored Procedures, Functions and Triggers using T-SQL and also expert in tuning Complex Queries.
• Good experience on physical storage configuration and optimization of SAN/NAS/DASD with different RAID levels.
• Experienced in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using DBCC Utilities and DMV’s and DMF’s, Re-indexing, Updating Statistics and online indexing.
• Created linked servers between SQL Server 2000 & Oracle 9i & 10g.
• Expertise on Business Intelligence Tools to Create SSRS Reports, SSIS Packages and SSAS with OLAP.
• Extensively worked on Data and Backup compression in SQL Server 2008.
• Expertise in implementation of security models; Database authentication modes, creation of users, configuring permissions and assigning roles to users.
• Expertise in performing data transformations between servers using BCP, DTS, SSIS and bulk insert. And also Expert in using DMV’s, DMF’s.
• Good understanding in database and data warehousing concepts (OLTP & OLAP). Experience with logical and physical data modeling and database design using Erwin.
• Experience in managing Alerts, Operators and Jobs through SQL Server Agent.
• 24 X 7 Production Database on Call Support.
• Strong Technical background with excellent problem solving and communication skills. Strong time management skills and excellent team player with reputation of integrity and an ability to work on multiple technologies.

Technical Skills

RDBMS: MS SQL Server 2008R2/2005/2000/7.0, Oracle 10g/9i, Sybase 12.0, MySQL 4.1,
And MS Access 2010/2007/2003.
Languages: T-SQL, C #, Perl, SQL, PL/SQL, XML, HTML, DHTML.
Web Technologies: ASP, ASP.Net, VB.Net, ADO.Net, CSS
GUI & Tools: VB 6.0, Developer 2000, TOAD.
Web servers: IIS, Netscape Enterprise Server, BEA WebLogic and IBM WebSphere.
OLAP & ETL tools: SQL Server Analysis Services (SSAS), Informatica.
Operating systems: Windows Server 2003 EE, Windows 2000 Server/Advanced Server and Windows
Vista/XP/NT/2000
Data modeling tools: Erwin, MS Visio.
Monitoring Tools: BMC Patrol, Idera, SQL Server Profiler and Performance Monitoring
Version control: MS Team Foundation Server (TFS), VSS, CVS, PVCS, ClearCase
Reporting tools: Business Objects/Crystal Reports, SSRS (Report Builder)
MS-Office: Word, Excel, Access, Outlook, Outlook Express and Power point.
Data migration: DTS, SSIS, BCP, SQL Loader, Import/Export Wizard.

Education: - B.tech in Electronics

Professional Experience

Confidential, Houstan, TX June’12- Till date

Role: Sr.SQL Server DBA

Responsibilities

• Managed and Administrated theSQL Server 2008 R2/2005/2000 production and Non-production servers.
• Installation ofSQL Server 2008 R2/05onWindows Server Clustered environment.
• prepared maintained and modified SQL server installation and configuration documents
• Upgraded/Migrated SQL Server 2005/2000 databasestoSQL Server 2008 R2 databasesand mentored Junior DBAs and other technical staff.
• Migrated SQL Server 2000 databasestoSQL Server 2005 databasesincludingDTS to SSIS packages.
• Performedbackup using backup compression and Data compression in SQL Server 2008 R2 on clustered environment
• Handled upto 2.5 TB Size databases with clustered environment.
• Implemented new features inSQL 2008 R2likePolicy based Management, Table Compression & backup compression, SQL Server Auditing, Resource GovernorandMERGE statement inT-SQL.
• Issues like connection timeouts, connection pooling issues and memory leaks.
• Setting up and Monitoredtransactional replication, Database mirroring on Production, QA and Dev servers.
• MonitoredLog shipping/ Transactional Replicationand trouble shooting of errors.
• Experience working with data modeling with ERWIN
• Extensively workedon Profiler, Perfmon, DMVs, DMFs and DTAto tune the databases, servers and query tuning.
• Managed Security usingSQL Logins, Roles and Security Modesfor various users.
• Rebuilding the indexes on regular intervals and placing the huge table/non-clustered indexon theseparate file group to improve the performance.
• Optimized the query performance with modification inTSQL queries, removing unnecessary columns, eliminating redundant and inconsistent data, normalizing database, establishing necessary joins,creating usefulclustered indexandnon-clustered indexes.
• Developed and created the new database objects including tables,views, index, stored procedures and functions, advanced queriesand also updated statistics using Query Analyzer and Enterprise Manager on the existing servers.
• Analyze execution plans and generate suggestions for improvement.
• To set upSQL Server configuration settingsto resolve various resource allocation & memory issues for SQL Server databases and to setupideal memory, min/max server options.
• Configureddata partitioning/table partitioningon huge tables containing millions of rows for better performance.
• Monitoring SQL Server logs to ensure whether thebackup operations,batch commands, scriptshave completed successfully.
• Handled numerous change management requests on production servers
• Designed and developedSSIS packages using different control flow tasks, Transformations and dataflow tasks.
• CreatedSSIS packagesto load robust data from differentHeterogeneous data sourceslikeOracle, DB2 to SQL server.
• Created, scheduleddatabase maintenance planusingSSIS Maintenance plan task.
• Configured and deployedSSIS PackagesfromTest to Production Environments.
• Created, deployed and managed reports usingSQL Server Reporting Services(SSRS)
• UsedOnline Indexingandonline RestoringinSQL 2005.
• Extensively used Red Gate SQL Compare and Data Compare tools to compare and synchronize SQL Database Schemas
• Supported24 X 7 Production environment

Environment: MS SQL Server 2008R2/2005/2000, T-SQL, SSIS, SSRS, Performance monitor,SQL Profiler, Replication, Logshipping, Mirroring, Clustering ,Windows XP/2000 and Windows 2003/2008 Server.

Project: Data Center Consolidation (DCC)
Role: Sr.SQL Server DBA

Responsibilities

• Installing and maintaining SQL Server database systems. Maintaining the database systems includes but is not limited to ensuring successful backups, resolving system issues, opening cases with technical support to resolve issues, monitoring success and failure of automated jobs, monitor system availability, updating system documentation, system and database recovery, etc.
• Coordinating with the Systems Administration team, install and maintain Boardwalk approved application software and systems that integrate with Boardwalk’s database systems.
• Updating database systems by reviewing, planning, testing and installing database security patches and service packs.
• Design, document, and promote security "best practices", policies, standards and protocols.
• Migrating application code and objects from development/test environments to production.
• Working with development and systems teams to perform application and database tuning.
• In conjunction with development teams, define and maintain database and code standards and naming conventions for the organization to ensure consistency in database and code development.
• Migrating Databases from SQL Server 2005 to SQL Server 2008.
• Setup and maintenance of appropriate database and application monitoring.
• Setup, test and maintain business continuity/disaster recovery infrastructure database and applications.
• Providing highly available database and application infrastructure according to Business Continuity requirements using SQL clustering, load-balancing, etc.
• Evaluating data modeling, database administration, and database backup and recovery tools and make recommendations.
• Setting up and Monitoredtransactional replication, Database mirroring on Production and QA servers.
• Responsible to Monitor and troubleshooting Log Shipping.
• Review of physical and logical database design; Promote the reliability of database design by ensuring appropriate referential data integrity is implemented and appropriate data types are used.
• Create processes and procedures for application code and database object migrations to support an efficient and reliable system development lifecycle.
• Extract Transform Load (ETL) development using SQL Server Integration Services (SSIS).
• Created new database objects like Tables, Procedures, Functions, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2005.
• Worked in Active Active, Active Passive Cluster environment as a High availability solution.
• Failover cluster testing and resolution on HP servers as well as monitoring and backup reporting setup with Microsoft Operations Manager and backup teams.
• Tuning queries which are running slow using Profiler and Statistics Io by using different Methods in terms of evaluating joins, indexes, updating Statistics and code modifications.
• Created complex stored Procedures, Triggers, Cursors, Tables and other SQL Joins and Statements for Applications by using T-SQL.
• Checking Database Health by using DBCC Commands and DMVS
• Monitored and modified Performance using execution plans and Index tuning.
• Prepared Documentation for the Disaster Recovery plan
• Daily routine DBA tasks like handling user’s permissions and space issues on Production and Semi-Production Servers and handling maintenance Jobs.
• Handled monthly Database Refresh in QA-Test environment for testing of new Deployments and Build.
• Responsible routine DBA jobs like Backups and Restores.
• Good experience in data modeling and metadata services.

Environment:MS SQL Server 2008R2/2005/2000,T-SQL,SSIS,SSRS,ReportBuilder,Lite Speed, BCP, SQL Profiler, Replication, Logshipping, Mirroring, Clustering ,Windows XP/2000 and Windows 2003/2008 Server.

Project: Common Facilities Project
Role: SQL Server DBA

Responsibilities

• Installed and Upgraded from SQL Server 2005 to SQL server 2008 on Various Production Servers.
• Migrating Databases from SQL Server 2005 to SQL Server 2008.
• Worked with table partitioning (SQL Server 2008) mechanism to allow the SQL Server engine to escalate locks to the partition level before the table level.
• Worked with Transparent Encryption, table compression, database compression and merge statements using SQL server 2008.
• Extract Transform Load (ETL) development using SQL Server Integration Services (SSIS).
• Used Policy Based Administration feature (SQL Server 2008).
• Worked With \'upsert\' commands to programmatically INSERT data if it does not exist or UPDATE the data if it does all in 1 set of logic (SQL Server 2008).
• Created new database objects like Tables, Procedures, Functions, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2005.
• Setting up and Monitoredtransactional replication, Database mirroring on Production and QA servers.
• Worked in Active Active Cluster environment as a High availability solution.
• Performing Backup/Restore to/from Legato server (Tape) and Disk
• Tuning queries which are running slow using Profiler and Statistics Io by using different Methods in terms of evaluating joins, indexes, updating Statistics and code modifications.
• Extensively used TSM litespeed backups
• Created complex stored Procedures, Triggers, Cursors, Tables and other SQL Joins and Statements for Applications by using T-SQL.
• Expert in Performance Tuning of the Stored Procedures.
• Checking Database Health by using DBCC Commands and DMVS
• Monitored and modified Performance using execution plans and Index tuning.
• Experience in Database security and integrity planning
• Used log shipping for synchronization of databases.
• Prepared Documentation for the Disaster Recovery plan
• Designed Data Integrator jobs with Error Handling and email notifications.
• Managing Databases spread across multiple servers in Production, Development, staging & testing environments.
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Daily routine DBA tasks like handling user’s permissions and space issues on Production and Semi-Production Servers and handling maintenance Jobs.
• Handled monthly Database Refresh in QA-Test environment for testing of new Deployments and Build.
• Responsible routine DBA jobs like Backups and Restores.
• Good experience in data modeling and metadata services.

Environment: MS SQL Server 2008R2/2005/2000, T-SQL, SSIS, Composite Software 5.0.0, Report Builder, Lite Speed, BCP, SQL Profiler,Log Shipping, Replication, Mirroring,Clustering Windows XP/2000 and Windows 2003 Server.

Project: Provider Claims
Role: SQL Server DBA

Responsibilities

• SQL Server 2008 Database Administration.
• Installed and configured more than 2GB RAM in SQL Server 2005.
• Performed the migration of SQL Server 2000 to SQL Server 2005.
• Configured the servers on 32 bit and 64 bit clustered and standalone server environments
• Installed and maintained 2-Node (Active-Active) Clustering as a High availability solution.
• Responsible to Monitor and troubleshooting Log Shipping.
• 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.
• Implemented and maintained Database mirroring as a Disaster Recovery Solution.
• Setting up and Monitoredtransactional replication, Database mirroring on Production and QA servers.
• Installed, authored, and managed reports using SQL Server 2005 Reporting Services
• Experience in trouble shooting Client connections, viewing error logs and application logs.
• 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.
• Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.
• Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions.
• Experience in implementing and maintaining new T-SQL features added in SQL Server 2005 that are Data partitioning, Error handling through TRY-CATCH statement, Common Table Expression (CTE).
• Transferred data (ETL) to Data ware house Environment using SSIS.
• Used Data Partitioning, Snapshot Isolation in SQL Server 2005.
• Expertise and Interest include Administration, Database Design, Performance Analysis, and Production Support for Large (VLDB) and Complex Databases up to 2.5 TB.
• Expertise in SQL Server Analysis Services.
• Expertise in creating and supporting in OLAP Cubes
• Managed VERITAS net backups and Litespeed backups.
• To analyze long running queries and tune the same to optimize application and system performance.
• Maintaining the database consistency with DBCC at regular intervals.

Environment: MS SQL Server 2005/2000, SQL Server BI Suite (SSAS, SSIS, SSRS), Log Shipping, Replication, Clustering, MOM, T-SQL, Report Builder, DTS, MySQL, ASP.Net, C#, VSS, ADO.Net, SQL Profiler, OLAP, Windows XP/2000, BCP, Active Directory, Windows 2003 Server.

Project: Receivables Management iConsole (RM iConsole)
Role: SQL Server DBA

Responsibilities

• Database Administrator, Database Programming.
• Relocation of Databases from one server to another server using attach and detach databases.
• Involved in up gradation of Touch works Database.
• Touch works application was implemented in Active Passive clustered environment.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Rebuilding the indexes at regular intervals for better performance.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies.
• Migrated DTS packages from Legacy system to SQL SERVER 2005.
• Using the Litespeed to take backups.
• Involved in Weekly Change Management, in which code developed by developers is being run on production server.
• Implemented log shipping between two instances of servers using Database Maintenance Plan by creating a Monitor server and a shared Folder.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Monitored and modified Performance using execution plans and Index tuning.
• Recovering the databases from backup in disasters.
• Maintaining the database consistency with DBCC at regular intervals.
• Created many SSIS packages using Import/Export Wizard. Designed many Packages using SSIS Designer by using Control Flow and Data Flow Tasks with ETL Tool.
• Transferred data (ETL) to Data ware house Environment using SSIS.
• To set up SQL Server configuration settings.
• Used Data Partitioning in SQL Server 2005.
• Good experience in data modeling and metadata services.
• Expertise in SQL Server Analysis Services (SSAS).
• Expertise in SQL Server Reporting Services (SSRS).
• Monitoring SQL server performance using profiler to find performance and dead-locks.
• Maximum performance and uptime in production environment.
• To analyze long running slow queries and tune the same to optimize application and system performance.

Environment: MS SQL Server 2005/2000, T-SQL, SSAS 2000/2005, SSRS, Report Builder, DTS, SSIS, MySQL, ASP.Net, C#, VSS, ADO.Net, Lite Speed, BCP, SQL Profiler, NDM (Connect: Direct), OLAP, Crystal Reports/Business Objects XI, Windows XP/2000, Active Directory, Windows 2003 Server.

Confidential, Andhra Pradesh, India May ‘04-Dec ‘05
Projects: Commercial Finance
Role: SQL DBA/SQL Server Developer

• Responsible for installation, configuration, and maintenance of MS SQL Server on various environments.
• Responsible for Performance and tuning of SQL servers and application issues related to migration.
• Testing of applications for performance, data integrity and validation issues.
• Data Transfers between various servers using BCP.
• Wrote stored procedures, checking the code for efficiency.
• Responsible for routine Backups and Restoration.
• Administration and Production support for various applications in all environments.
• Database Backup Procedures, Restoration Procedures, and Disaster Recovery procedures. Testing and implementing these procedures.
• Administering the MS SQL Server by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.
• Monitoring MS SQL Server performance and managing the use of disk space, memory and connections.
• Used DTS as an Extract Transform Loading (ETL) tool of SQL Server to populate data from various data sources, creating packages for different data loading operations for application.
• Running DBCC consistency checks, fixing data corruption on application databases.
• Monitor and tune SQL scripts. Creating upgrade scripts for Production database and supporting it.
• Auditing stored procedures for optimization and improving performance.
• Designed database maintenance plans, profiler and execution plans for stored procedure development and indexes for optimizing performance.
• Involved in writing T-SQL programming for implement Stored Procedures and Functions for different tasks.
• Worked to establish connectivity between VB applications and MS SQL Server by using ODBC.

Environment: SQL Server 7.0, T-SQL, DTS, XML, VB6.0, ODBC, Windows NT 4.0 Server/Workstation.