Professional Summary:

• Solid 7+ years in depth experience in MS SQL Server 2008 R2/2008/2005 database development and administration in enterprise production environment including server installation, configuration, upgrade, maintenance, performance tuning, optimization, backup/restore, disaster recovery, migration, monitoring, security planning and trouble-shooting high availability related issue.
• Expertise in mentoring and setting up High availability environments like active-active and active-passive clustering, Database Mirroring, Replication (Snapshot, merge, transactional), Log shipping, setting up servers from scratch on clustered environment, Linked servers.
• Expertise in Installs, deployments, certificate renewals, service accounts resets, add patches, performing upgrades / migrations, process job tickets & bugs, test verify backups and recovery.
• Strong understanding of components of SQL Server Architecture, Backups, Restore Strategy involving complete database backup/restore and transaction log backup/restore.
• Experience in maintaining the security for databases (creating logins for users, roles, and assigning permissions to them).
• Proficient with SQL Management Studio, Enterprise Manager, Query Analyzer, Business Intelligence development studio, report builder 2.0, rescheduling jobs with SQL Server Agent, SQL Profiler, restoring database using full, differential, and log backups. OLAP, OLTP, trouble shooting.
• Responsible for design, setup, installation, and implementation of DB’s, data maintenance (re-indexing, integrity checks, statistics update, log file monitoring), performance tuning (fragmentation, compression drive distribution, load balancing, replication), technical documentation and implementation of SQL Server disaster recovery models.
• Provide software build support & ongoing assistance with build activities to ensure timely delivery of testing & production software builds in a highly software development life cycle process.
• Optimization of indexes and statistics in relation to reporting data model.
• Involved in optimizing code and improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks.
• Expertise in Hardware SAN and RAID levels configuration and placement of database files/file groups across different drives
• Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, Database consistency checks using DBCC utilities and Index Tuning Wizard.
• Expertise and Interest include Administration, Development, Database Design, Performance Analysis, and Production Support for Large (VLDB) and Complex Databases.
• Experience in Migrating SQL Server 2000 to SQL Server 2005.
• Experience in creating complex Stored Procedures, DTS packages, triggers, cursors, tables, views, table partitioning and other SQL joins and statements.
• Experience working with production and 24 x 7 on call environments.
• Good team player, strong interpersonal and communication skills combined with self-motivation, initiative and the ability to think outside the box.

Educational Qualifications:

• Bachelors in computer science

Software Skills:

Database:

MS SQL Server 2008 R2/2008/2005, Oracle 11g, MS Access

Languages/Tools:

T-SQL, C, C++, JAVA (CORE), ORACLE 11G, IDERA, SQL Light Speed, REDGATE, SCOM, Ignite, IIS 6.0, html, PHP, java, javascript

Operating System:

Windows, Win NT 4.0, Win server 2003/2008/ 2008 R2, UNIX

System:

PC Internals, S/W Installation & Internet

RDP Tools:

Remote Network Connection, VPN, Citrix, VNC, Smart Card, FOB, RAS

Reporting Tools:

SQL Reporting Services, Crystal Reports, Active Reports, SSRS, Oracle Forms/Reports Developer.

DBA & Others Tools:

Toad, Erwin DM, MS Visio, DB Visualizer, DTS xChange, redgate, Quest LiteSpeed, Quest Enterprise, Confluence, Hummingbird Exceed, Quest Spotlight, VCenter 4.0

Professional Experience: -
Confidential,CA
SQL SERVER DBA MAR 2011-Till date

Responsibilities

• Installed and Configured SQL Server 2008 R2 Servers in Production, QA, UAT, DEV and DEV-INT Environments.
• Created databases, Logins, Roles and granted appropriate permissions.
• Created jobs, alerts, activity logs, error logs to capture any possible error.
• Participated in SDLC methodologies such as planning, analysis, design and implementation.
• Solved issues related to server performance and disk space
• Successfully implemented Database Mirroring in SQL Server 2005/2008R2 for high availability.
• Installed SQLSafe on all the database servers.
• Evaluated database performance and performed maintenance duties such as tuning, backup, restoration and disaster recovery.
• Maintained High Availability such as Log Shipping and Mirroring as a database disaster technique.
• Supported 24*7 production support and solved all kinds of critical problems.
• Created Clustered and Non Clustered Indexes on tables, views, and columns
• Creating and managing schema objects such as tables, views, index, and procedures.
• Created SQL Server Clustering on multiple nodes.
• Involved in database backup, recovery and restoration
• Created various reports like charts, sub reports, graphs and scheduled these reports using windows task scheduler to run on daily, weekly and monthly basis.
• Wrote documentation for all the Database maintenance related issues.

Environment: Microsoft Windows Server 2008/2003 32/64 bit, MS SQL Server 2008 R2/2005/2000, Idera SQLSafe, T-SQL.

Confidential,Memphis TN MAY 2010 – FEB 2011
SQL SERVER DBA
.
Responsibilities

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
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.
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, SSRS, SSIS and Windows 2003 Server

Confidential,CA JAN 2009 – APRIL 2010
SQL Server DBA
Responsibilities:

• Involved in installation, configuration, and up gradation of MS SQL Server 2000/2005/2008 servers.
• Involved in Data modeling, designing and building Relational Databases using Tools like Erwin and SQL Database Diagrams.
• Performed huge data transfers between various servers using BCP and SSIS for developer requests, Environment Migrations, Backing up and Archiving Data for various business requests.
• Heavily involved in writing stored procedures with complex logic for both Reporting needs and DBA Script libraries.
• Security Administration by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granted privileges to users and groups.
• Running Index tuning wizard and rebuilding indexes (Clustered/NonClustered) for faster query response.
• Worked on performance tuning, Query Optimization and increasing the performance of store procedures by looking into the execution plan, Indexes, Outdated Statistics, Optimizer Hints, Partitioned Views etc
• Maintained Operators, Categories, Alerts, Notifications, Jobs, Job Steps and Schedules as well as Monitored Connections, locks and Performance of SQL server.
• Involved in Configuring and Monitoring SQL Server clustering and SQL Server Transactional Replication for reporting capabilities
• Worked on SSIS packages and Export & Import wizards for transferring data from data sources like Oracle, MS Access, XML Files and Excel
• Extensively Involved in SSRS 2005/2000 (Reporting Services Configuration, Deployment, Development)
• Involved in design and development of large reports with different features such as drop downs, hidden parameters, and drill through depending on the requirement.
• Created various reports like charts, sub reports, graphs and scheduled these reports using windows task scheduler to run on daily, weekly and monthly basis.
• Create and support reporting data mart, which includes tables, views, cubes and dimensions, as well as necessary infrastructure to support pre-built reports.
• Develop metadata models, schemas and views to support user-defined reports.
• 24/7 Production support for SQL Server databases
• Performed documentation for capacity usage factor data validations and work summary for capacity usage factor calculations.

Environment: Windows2003 Advanced Server, MS SQL Server 2000/2005, TSQL, SQL Lite Speed, Visual Basic 6.0.

Confidential,Boston,MA OCT 2007 – DEC 2008
SQL Server DBA
Responsibilities:

• Installation and configuration of SQL Server 2000/2005 on windows 2003 and maintenance of Servers in Production, QA and Development Environment.
• Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions
• Up-gradation of SQL databases from SQL Server 2000 to SQL Server 2005
• Monitored and tuned databases to meet the performance and availability requirements of on-line systems and multiple applications.
• Scheduled and monitored all maintenance activities of SQL Server 2000 including database consistency check, and index de-fragmentation by DBDEFRAG and DBREINDEX.
• Monitored database status including CPU, memory, I/O, space, and dead lock issues using SQL Server Utilities
• Implemented database mirroring
• Installed, authored, and managed reports using SQL Server 2005 Reporting Services
• Used third party tool like Quest lite speed for taking backups and restoring them.
• Created Jobs to Automate & Schedule database administrative tasks.
• Created alerts, notifications, and emails for system errors, insufficient resources, fatal database errors, hardware errors, and security breach.
• Used SQL Profiler for troubleshooting, monitoring, optimization of SQL Server and non-production database code as well as T-SQL code from developers.
• Worked on all phases of database management with application development team and other vendors to maintain maximum availability.

Environment: SQL Server 2000/2005, Windows 2000/NT, Excel, Access, SQL Profiler, Replication, Enterprise Manager, Lite Speed Backup software, DTS, T-SQL, BCP, ERWIN.

Confidential,India AUG 2006-SEP 2007
SQL Server DBA

Responsibilities

• Installing, configuring and administration of SQL Server databases.
• Logical and Physical design of SQLServer databases using Erwin
• Database configuration including instance and database creation, database sizing, file placement, specification of storage media.
• Creation and configuration of database objects such as tables, indexes, sequences, procedures, functions and triggers.
• Writing and tuning of database resident code such as procedures, functions, triggers and views for consistent enforcement of rules.
• Database logical and physical design – file groups, segments and data files.
• Utilized tuning tools such as Perfmon, Trace files, Sql profiler, and Query analyzer to diagnose performance issues and tune the database.
• Design and develop backup and restore plans and procedures for backup, full and incremental backups.
• Utilized import and export utilities to supplement backup and recovery routines.
• Developed and implemented security plan used to monitor and restrict database access.
• Provided on-call services after hour and weekends.
• Participated in disaster recovery, high availability and business continuity planning.
• Migrate; upgrade databases within specified downtime and minimal production impact.
• Creation and management of logins, user accounts, schemas, roles, profiles and privileges.
• Participated in defining and documenting policies and procedures for maintenance of the systems.

Environment: MS SQL Server 2000, Windows NT 4.0, Perfmon, and Erwin 4.0.

Confidential,India July 2005 -JUNE 2006
SQL Server DBA
Responsibilities:

• Migrated databases from SQL server 2000 to SQL server 2005.
• Handled complex SQL programming issues independently, performed independent database on different clinical trials and reviewed to ensure programming consistency.
• Wrote T-SQL queries and T-SQL stored procedures in SQL SERVER 2000.
• Performed validation and quality control checks of SQL programs.
• Worked with client representatives to define data output specifications in form of data transfer plan.
• Configured complex SQL queries to meet customer requirements as needed.
• Used DBCC utilities to fix data corruption in application databases.
• Assign permission to user(s), role(s), and object. Support column level permission. Administrate security for server’s logins (Windows and SQL Accounts).
• Expertise in Security Issues such as creation and granting permissions on various Objects.
• Preparing the reports for the day-to-day as well as weekly/monthly purposes.
• Created maintenance plans for optimization, integrity, backups of databases, transaction logs, restoring databases and DBCC Checks.
• Responsible for MS SQL Server 2000/2005, configuration, tuning and provide 24X7 dedicated support to all Production, development and cluster servers.
• Performed all aspects of database administration, including backups andrecovery.
• Additionally, designed and implemented a disaster recovery system.
• Environment: SQL Server 7.0, SQL Server 2000, Cognos, Windows 2000.