SUMMARY

• Over 8 plus years of Microsoft SQL Server Database Administration & Development experience in SQL Server 2012/2008R 2/2008/2005/2000.
• Installed SQL Server 2000/2005/2008/2008 R2/2012 on new 32 - bit and x64-bit Operating System.
• Expertise in migration of SQL Server databases from lower version to higher versions.
• Experience in upgrading SQL server software to new versions and applying service packs and patches.
• Worked on applying SQL Server hot-fixes / Service Packs on all production and development instances on quarterly basis based on recommendations from Microsoft Tech-net.
• Installed SQL Server Client on all Client Desktops.
• Experience in working with Windows Servers 2000 / 2003 / 2008/2008 R2 .
• Proficient with SQL Management Studio, Enterprise Manager, Query Analyzer, Business Intelligence development studio, report builder 2.0, rescheduling jobs with SQL Server Agent.
• Expertise in deployments, certificate renewals, process job tickets & bugs, test verifies backups and recovery.
• Highly proficient in database Backup, Restore, Recovery, Linked servers, and Database Maintenance Plans.
• Created Security by setting up groups and then logins for each Roles or Users for Maintenance of Databases.
• Experience in planning, documenting Disaster recovery plans for critical, enterprise level applications and also participated in disaster recovery drills.
• Successfully tested and implemented Log Shipping technique used for warm backup solution for MS SQL server 2000/ 2005/2008 databases.
• Proficient in implementing different types of Replication models like Snapshot, Transactional, Merge and Peer-Peer.
• Experience in Implementing Database Mirroring in SQL server 2005/2008.
• Highly experienced in Installing, Configuring and Maintaining of Cluster in SQL Server 2012 and SQL Server 2008 in Active/Passive and Active/Active modes.
• Actively involved in System Performance by tuning SQL queries and stored procedures by using SQL Profiler, Database Engine Tuning Advisor
• Windows performance monitor, DMVs, Resource Governor, Data collection Reports, DBCC and Custom Script, Built in performance Report and Activity Monitor.
• Experience in Scheduling and creating SQL Server jobs as well troubleshooting when jobs fail.
• Proficient in migration of Data from Excel, Flat file, Non SQL db's Oracle/Db2/Sybase to MS SQL Server by using SSIS.
• Working knowledge in SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS) to manage ETL environment.
• Developed writing parameterized Queries for generating reports, formatting report layout, sub reports using global variables, expressions and functions in SSRS 2005/2008R2.
• Experience in providing good production support for 24x7 over weekends on rotation basis.
• Excellent organizational, interpersonal and communication skills with high level of adaptability and flexibility to adjust to changing work positions.

TECHNICAL SKILLS

SQL Server Tools: SQL Server Management studio (SSMS), MS SQL Server 2000 Enterprise Manager, SQL Query Analyzer, SQL Profiler, DTA, Execution Plan.

Reporting Tools: MS SQL Server Reporting Services

ETL Tools: SSIS, Informatica

RDBMS: MS SQL Server, Oracle

Operating Systems: WindowsNT4.0,Windows2000,Windows 2003/2008/2012/ XP

Programming Skills: C, C++, T-SQL, PL/SQL, Java

Backup Tool: Snap Manager for SQL, Data Domain

PROFESSIONAL EXPERIENCE

Confidential, Foster City, CA

SQL Server DBA

Responsibilities:

• Administration and support on large number of SQL Server instances in multiple data centers including Production, Validation, QA, Stage, Test and Development Environment.
• Successful in Knowledge Transition from Gilead Spoc and prepared a High level document for Document of Understanding and Playback session.
• Installed SQL Server 2005/2008, 2008R2/2012/2014, Performed Database Design and created User Databases.
• Installed SQL Server hot fixes from SQL Server 2000/2005/2008/2008 R2.
• Worked mainly on Windows 2003/2008R2/2012 R2 servers.
• Monitoring the production instances with central management system.
• Experience in ITSM, SPARC ticketing tool by fulfilling SLA.
• Monitoring Production servers with the help of FOGLIGHT, Solarwinds and SCOM.
• Worked with Application System Managers directly and provide suggestions under database side.
• Centralized the environment by fixing the issues with their necessary maintenance plans and service accounts.
• Supporting various enterprise level applications like SharePoint, ITSM, G-Net, EQMS, and Business Intelligence, GVD, E-Vault, and GFAM systems.
• Close monitoring of critical production applications
• Implemented Database Mirroring for critical operational databases to provide no loss of data.
• Successful in implementing and setting up the replication (Snapshot /Transactional/ Merge/Peer-Peer).
• Configured and Implemented Active/Passive clustering and Active/Active clustering.
• Implementation and documentation of AOAG on SQL Server 2012 instances.
• Prepared multiple documents to explain the standard procedures and also best practices with off shore team.
• Performance Monitoring with SQL Profiler and Windows System Monitor.
• Work closely with multiple system managers and discuss on-going issues and future deployments.
• Highly experienced in working with Storage, Server, and Network team to completed the tasks and meet the project deadlines.
• Creation of maintenance plans of the SQL Jobs using SQL Server Agent and troubleshoot them in case of any failure.
• Moving TEMPDB folder to another drive on Production Environment to improve Performance.
• Scheduled Maintenance plans for Backups, Rebuild-Index.
• Have Experience in working with Onsite/Offshore team.
• Available production support for 24*7 whenever required.

Environment: SQL Server 2000/2005/2008/2008 R2/2012, T-SQL, Excel, Power point, Windows 2003/2008R2/2012 R2 Server, Visual Source Safe 6.0, ITSM, Foglight, SCOM, Net App Snap manager, SolarWinds.

Consolidated, Huston, TX

SQL Server DBA

Responsibilities:

• Participated in designing the Logical model by using Erwin based on the business requirement.
• Implemented the logical design to the physical design by creating tables.
• Created Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity checks, Database Statistics update and Re-indexing
• Optimized the performance of queries by modifying the existing index system and rebuilding indexes again with respect to the I/O.
• Maintained data integrity by creating checks and constraints.
• Facilitated easy user interface implementation and consistent data entry into the database by creating views with triggers.
• Supported efficient data storage and manipulation by creating complex stored procedures and functions
• Worked on DTS Package, DTS Import/Export for transferring data from heterogeneous database
• Data migration (import & export - BCP) from Text to SQL Server
• Created and modified indexes to optimize query performance
• Participated in designing, testing disaster recovery model and implantation
• Developed stored procedures and functions to implement necessary business logic for interface and reports
• Converted complex business logic into SQL Stored Procedures and user-defined functions to achieve functionality required by the UI team

Environment: SQL Server 2008, Informatica, Windows 2008 R2, SQL Query Analyzer, SSRS, DTA, Activity Monitor, Query Optimizer, Maintenance Plan.

Confidential, Minneapolis, MN

SQL Server DBA

Responsibilities:

• Installed MS SQL Server2005/2008, Performed Database Design and created User Databases
• Performed migration of all the databases from Sql Server 2000 to Sql server 2008 along with all DTS packages to SSIS.
• Troubleshooting of Upgrades issues like SQL Server 2000 to SQL Server 2008, Edition upgrades and hotfix upgrades
• Excellent knowledge in Recovering databases in emergency/data file missing/log space full
• Scheduled backups and performed restore operations for system test data depending on developers’ requirement.
• Created maintenance plan and sql server jobs and scheduling them, setting emails alerts on failure.
• Managed Disk space, memory and User connections.
• Tuned SQL Server using DMVs, SQL Profiler and Windows Performance Monitor.
• Detected and troubleshootSQLServer related CPU, memory, I/O, disk space, and other resource contention
• Performed Database Integrity Checks, updated Database Statistics and performed Re-indexing.
• Performed query plans and made sure each and every query is using appropriate indexes.
• Using profiler to find badly performing queries and deadlocks
• Created SSIS Packages to upload test data from Text files.
• Used DBCC checks and fixed data corruption in Application databases
• Administered MS SQL Servers by creating User logins and assigned them proper permissions, observing all process running on the server making sure server will run at its best.
• Responsible for Stored Procedures optimization, Performance tuning & index tuning.

ENVIRONMENT: MS SQL Server 2000 and 2008, Windows 2000 Advanced Server, Erwin, Service now, Foglight, and SCOM.

Confidential

Software Developer

Responsibilities:

• Installed and configured MS SQL server on non-prod environment under senior engineer supervision.
• Involved in creating tables, columns, triggers, and T-SQL code. Used Indexes, views, trigger and store procedures.
• Working closely with senior engineers in preparing standard process documents.
• Creating new database / tables to put in the extracted data and rebuilding the relationship.
• Involved in writing triggers to apply the business rules. Back up & restoring user databases.
• Monitoring of the log files. Maintaining the database by taking the backup of the data and log files and restoring the backup files on different environments (development, test).
• Involved in creation of distributed partitioned views, debugging/troubleshooting stored procedures, upgrading existing ones.

Environment: SQL Server 2005, Windows 2003/XP SQL Query Analyzer, SQL Enterprise Edition.