SUMMARY

• Over 7 years of experience in IT industry as SQL Server Administrator/Developer and support of MS SQL Servers 2008/2005/2000 in Production, QA, and Development environments.
• Experience in installation and configuration of MS SQL Server 2008/2005/2000 versions.
• Experience in Creating Databases based on Functional Requirements and System Design.
• Administered, Maintained, Developed, Implemented Security Policies using Database authentication modes, creation of users, configuring permissions and assigning roles to users.
• Experience in implementing Backup and Recovery Strategies.
• Experience with configuring high availability and Disaster recovery scenarios like clustered environments, Log shipping, mirroring and Setting up different topologies in Replication (Transactional Replication, Snapshot Replication, Peer - to-Peer and Merge Replication).
• Experience in creating Maintenance plans, jobs and alerts.
• Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, Database consistency checks using DBCC utilities, Database Engine Tuning Advisor (DTA) and Index Tuning Wizard.
• Experience in monitoring database performance using SQL Profiler and Windows Performance Monitor.
• Experience in Policy Based Management, Resource Governor, Performance Data Collector and Transparent Data Encryption (TDE).
• Experience in creating Linked Servers.
• Extensively involved in Upgrading SQL 2005/2000 to SQL server 2008.
• Experience in creating and maintaining Documents for future needs.
• Good understanding of different RAID levels implementation and SAN.
• Expertise in writing and reviewing Stored Procedures, Functions, Cursors and Triggers using T-SQL.
• Administer & Support mission critical databases and provide 24*7 Production support.
• Good communication, analytical and inter personal skills and ability to learn new concepts.

TECHNICAL SKILLS

Databases: Microsoft SQL SERVER 2008/2005/2000

Languages: SQL, HTML, XML, Asp.Net, VB.Net, C, C++

Reporting Packages: SQL Server Reporting Services

Database Utilities: Enterprise Manager, Query Analyzer, Sql server Management Studio, Profiler, import & Export, Data Base Tuning Advisor, Business Intelligence Development Studio (BIDS), Perfmon

Operating System: Windows 2008/2003/2000 XP, UNIX, Linux

Tools: MS Visual Studio, MS Visio, ITSM (Remedy), MS CRM 4.0.

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

SQL Server DBA

Responsibilities:

• Responsible for Installation, Configuration and Complete Administration of MS SQL Server 2008/2005.
• Created Logins, users, roles and involved in Daily User Maintenance.
• Implemented and performed backup, restoration, and disaster recovery.
• Migrated databases from SQL Server 2005 to SQL Server 2008.
• Created DB objects like Tables, Stored procedures, Functions, Triggers and Views using T-SQL.
• Created the Constraints, Clustered and non-clustered Indexes on the tables for effective performance of the T-SQL query.
• Implemented Database Mirroring with High Availability Mode in SQL 2008.
• Implemented Log Shipping from Primary Server to Standby Server to support DR Solution.
• Generated automation alerts for backup jobs, scheduled jobs, and system performance.
• Solved Tickets on Daily Basis for Production Issues.
• Managed the use of disk space, memory and connections. Running DBCC consistency checks, fixing data corruption in application databases.
• Worked with Transparent Data Encryption using SQL server 2008.
• Implemented Resource Governor in SQL server 2008.
• Used Performance Monitor, Profiler, and Database Engine Tuning Advisor to solve Dead Locks/Long running queries.
• Used Policy Based Management feature (SQL Server 2008).
• Worked on reviewing the code developed by developers.
• Worked with various business groups while developing their applications, assisting in Database design, creating E-R diagrams.
• Worked with System and Networks administrators as a team to analyse system performance, determining proper applicability of maintenance and programmatic approaches versus hardware solutions.
• Prepared and documented database Backup and Maintenance Plans.
• 24 X 7 Production Database on Call Support.

Environment: MS SQL Server 2005/2008, T-SQL, Win 2008/2003

Confidential

SQL Server DBA

Responsibilities:

• Installation & Configuration of SQL Server 2005/2000 Servers
• Application of latest database releases, service packs, hot fixes and security patches.
• Created new Instances, databases, schemas, objects and table spaces/file groups.
• Worked with the application team, SME, business leads and vendors to identify project requirements.
• Involved in Creation of DB objects like Indexes, Stored procedures & triggers using T-SQL
• Created Logins, users & roles and involved in Daily User Maintenance
• Created Database Maintenance jobs to perform Full, differential & transaction log Backups and scheduled them with the SQL Server agent job scheduler
• Capacity planning and allocating disk storage for databases.
• Configuration, creation and administration of jobs, schedules, DTS tasks.
• Migrated SQL server 2000 to SQL Server 2005 across various environments
• Extensive Experience implementing In place upgrades and New server builds, Migration of logins, DTS Packages to SQL 2005 SSIS Packages
• Verification of Post-migration results, Legacy compatibility and Feature pack installations
• Set up Transactional Replication between servers and troubleshoot the issues
• Worked on Active/Passive two node Clustering servers for high availability.
• Monitoring and tuning the performance of database using Perfmon, SQL Profiler and Trace files.

Environment: MS SQL Server 2005/2000, T-SQL, Win 2003

Confidential

SQL Server DBA

Responsibilities:

• Responsible for Providing 24x7 fast paced DBA support for production, development and testing environment.
• Granted, updated and revoked privileges to database users on database objects in SQL Server 2005.
• Created new database objects like tables, views, indexes, stored procedures, user defined functions and triggers on user databases in SQL Server 2005.
• Setup and maintain Transactional replication, Snapshot replication and SQL Server Clustering.
• Responsible for creating, scheduling and monitoring SQL server agent jobs and alerts.
• Monitored Event viewer, SQL Error logs and Log File Viewer for Software and hardware related errors.
• Worked on Linked Servers to run distributed queries between SQL server and other data sources like excel using ODBC, OLE DB Drivers.
• Running DBCC consistency checks, and fixing data corruption in application databases.
• Daily monitoring of the database performance and network issues by using Performance monitor and Profiler.
• Resolved Dead locks and blocking issues.
• Documented the complete Disaster Recovery Plan for the Database servers.

Environment: Microsoft SQL Server 2005, T-SQL, Windows 2003, Query Analyzer, SQL profiler

Confidential

SQL Server DBA

Responsibilities:

• Installation, Creation, Administration and Maintenance of SQL Server Databases (Production / Development / test)
• Maintenance of Production and Development Servers, ensure the availability of the production databases to end-users and development database to developers in a 24x7 environment
• Wrote stored procedures, which generates SQL statements depending upon the combination of parameters passed for the search module.
• Involved in creation and design of Database and its normalization.
• Creating and managing DB objects such as tables, views, indexes, stored procedures, triggers and constraints.
• Involved on implementing Backups/Restores of data, index and log files.
• Involved in configure and maintaining Replication Server
• Security Implementation, Administering the MS SQL server by creating users logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of Groups, Granting the Privileges to Users and Groups.
• Data transfers between various servers using DTS.
• Involve in co-ordination between On-site and off-shore teams member. Working effectively around the clock for resolving issues
• Perform code review on SQL and related code as needed.
• Documenting and bug fixes and resolution of Tickets

Environment: SQL Server 2000, DTS, Visual SourceSafe, Enterprise Manager, Windows 2000, Data Transformation Services (DTS)