SUMMARY

• Over 8 plus years of Microsoft SQL Server Database Administration & Development experience in SQL Server 2012/2008R2/2008/2005/2000.
• Installed SQL Server 2000/2005/2008/2008R2/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 wif Windows Servers 2000 / 2003 / 2008/2008R2 .
• Proficient wif SQL Management Studio, Enterprise Manager, Query Analyzer, Business Intelligence development studio, report builder 2.0, rescheduling jobs wif 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 server2000/ 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 wif 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,Windows2003/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/2008R2.
• Worked mainly on Windows 2003/2008R2/2012 R2 servers.
• Monitoring teh production instances wif central management system.
• Experience in ITSM, SPARC ticketing tool by fulfilling SLA.
• Monitoring Production servers wif teh help of FOGLIGHT, Solarwinds and SCOM.
• Worked wif Application System Managers directly and provide suggestions under database side.
• Centralized teh environment by fixing teh issues wif 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 teh 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 teh standard procedures and also best practices wif off shore team.
• Performance Monitoring wif SQL Profiler and Windows System Monitor.
• Work closely wif multiple system managers and discuss on-going issues and future deployments.
• Highly experienced in working wif Storage, Server, and Network team to completed teh tasks and meet teh project deadlines.
• Creation of maintenance plans of teh 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 wif Onsite/Offshore team.
• Available production support for 24*7 whenever required.

Environment: SQL Server 2000/2005/2008/2008R2/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.

Confidential, Huston, TX

SQL Server DBA

Responsibilities:

• Participated in designing teh Logical model by using Erwin based on teh business requirement.
• Implemented teh logical design to teh physical design by creating tables.
• Created Database Maintenance Planner for teh Performance of SQL Server, which covers Database Integrity checks, Database Statistics update and Re-indexing
• Optimized teh performance of queries by modifying teh existing index system and rebuilding indexes again wif respect to teh me/O.
• Maintained data integrity by creating checks and constraints.
• Facilitated easy user interface implementation and consistent data entry into teh database by creating views wif 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 teh 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 teh databases from Sql Server 2000 to Sql server 2008 along wif 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, me/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 teh 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 wif senior engineers in preparing standard process documents.
• Creating new database / tables to put in teh extracted data and rebuilding teh relationship.
• Involved in writing triggers to apply teh business rules. Back up & restoring user databases.
• Monitoring of teh log files. Maintaining teh database by taking teh backup of teh data and log files and restoring teh 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.