SUMMARY:

• Having 10+ years of experience in MS SQL SERVER 2014/2012/2008 R2,2008,2005/2000 database Development and Administration (DBA) in business & technical environments domains with a strong working knowledge of high availability
• I have an experience in database administration activities like installation, configuration of SQL servers and database lifecycle, Data migration and upgrading, strong SQL server.
• Experience in implementing different types of Replication models like Snapshot, Merge and Transactional.
• Completed multiple database implementation projects through all phases of development
• Understand complex database concepts as well as the implications of different database designs Demonstrate proficiency with physical and logical database design
• In - depth knowledge of SQL Server architecture - engine, query processing, query optimization, locking
• Experience on Active/Passive and Active/Active Cluster.
• Strong knowledge of features and functionality in SQL Server Database legacy
• Implemented Database Mirroring and Log shipping in SQL Server 2005,2008,2012 and 2014
• Experience in using SQL Server Profilers, Index Tuning Wizard and Windows Performance monitor to monitor SQL Server.
• Excellent knowledge in creating Databases, Tables, Stored Procedure, DDL/DML Triggers, Views, User defined data types, Cursors and Indexes using T-SQL.
• Expert in using Bulk Copy Program (BCP), Data Transformation Services (DTS) packages and SSIS (integration services) with MS SQL Server 2000/2005/2008 & 2012.
• Designed DTS/SSIS packages to export and import data from SQL Server to MS Access, Oracle10g, text files and Excel files.
• Experience in Design, deployment, and maintenance of SSAS,SSRS and SSIS SQL Server
• Hands on experience on Always on concepts in SQL 2012 & 2014
• Strong command of SQL Server architecture - engine, query processing, query optimization, locking
• Experience on Cluster Installation and Up gradation
• Strong command of performance tuning and proven experience in troubleshooting application performance problems (Indexing, Optimizer, server configuration, Profiler, DMV etc) including TSQL programming and debugging skills
• Experience in resolving MSI & MSP Files missing issues.
• Knowledge of VMWARE and Veeam.
• Experience in working with SSAS in creating cubes, data source views, named queries, dimensions and deploying of analysis services projects.
• Expertise in identification of Business & Data requirements and converting them into conceptual & logical data models.
• Experience in Dimensional Data Modeling Star and Snow Flake Schemas.
• Worked on Building table spaces, data files, tables, logins, roles, and indexes.
• Experience in SSIS, SSAS and SSRS of MS SQL Server tools.
• Proficient in Data Migration from sources like MS Access, SQL server, Text Files, Excel to SQL server 2000/2005/2008 using SQL Server Integration Services (SSIS).
• Worked on Cold and hot backups of oracle database.
• Worked on Exporting and importing data from different sources to oracle databases in both legacy and data dump method.
• Experience in Analyzing Execution Plan, Managing indexes and troubleshooting deadlocks.
• Experience in Configuring and Managing Linked Servers, data transfer between SQL Server and other heterogeneous relational database such as Oracle, Sybase and DB2.
• Highly dedicated, dynamic, ability to meet deadlines within fast paced environments
• Self-Starter, Result Oriented, Responsible Team Member and Co-Operative Individual
• Thorough experience with Recovery of SQL Server in a Disaster Condition. Provided 24x7 Production Support for mission critical applications on call rotation basis.

TECHNICAL SKILLS:

Languages: C, C++, T-SQL, .NET

RDBMS: MS SQL Server 2000/2005/2008/2012 and 2014, MS-Access, and Oracle 8i/9i/10g/11g/12c

Reporting Tools: Crystal Reports, SQL Server Reporting services (2000/2005)

Database Tools: SQL Server Management Studio, SQL Server Enterprise Manager, Query Analyzer, SQL Server Reporting Service, SQL Developer

Development skills: T-SQL, PL/SQL

Operating Systems: Windows 2000/NT/XP, Windows Server 2003/2008/2012, UNIX

Software Packages: MS Word, MS Excel, PowerPoint, Power shell, MS Access, Visual Source Safe 2005,Visio

PROFESSIONAL EXPERIENCE:

Confidential, Pleasanton, CA

Sr. SQL Server DBA

Responsibilities:

• Expertise in Always-On Availability Groups (AAG) and HA/DR Setup and Configuration
• Migrated SQL server 2008 to SQL Server 2012 / 2014 in Confidential Windows Server 2012 Enterprise Edition.
• Installed and administered cluster Active/Passive on Confidential Windows Server 2012 Enterprise Edition on SAN environment.
• Worked on Virtual Servers and Azure virtual machines.
• Migrated SSIS packages from SQL Server 2008 R2 to SSIS 2012.
• Extensively worked on SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS).
• Expert in Using DMVs, Performance dash board, Mirroring, database snapshots and tracking Performance Counters.
• Rebuilding / monitoring the indexes at regular intervals for better performance.
• Recovering the databases from backup in disasters. Implementing Point-In-Time Recovery solutions.
• Configuration of Log shipping and Replication
• Configuration and troubleshooting of Always-on on Type 1,2,3and Type 4
• Configuration of Mirroring (Synchronous &Asynchronous)
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• 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.
• Experience in using SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor(DTA).
• Expert in implementing the snapshot isolation and DDL triggers.
• 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.
• Performed installation of SQL Enterprise 2012 SP1 CU 5 64bit version on Windows 2012 Sp1 Clusters.

Environment: Windows 2003/2008/2012 server, MS SQL Server 2000/2005/2008 R2, 2012, 2014 MS Access, T-SQL, MS Excel, PowerShell, Virtual Machines, Performance analyzer and SQL developer

Confidential, Mountain View, CA

Sr. SQL Server DBA

Responsibilities:

• Installation of SQL Server 2008 R2,2012 & SQL2014 on Standalone Servers
• Installation of SQL Server 2008 R2,2012 & SQL2014 clusters
• Performed SQL 2008 to SQL 2012/2014 migration
• Applying Service packs and Patches on standalone servers & cluster nodes
• Resolving the issues related to installations and up gradations
• Worked on Test, Dev, and pre-prod and production servers
• Worked on Virtual Servers and Azure virtual machines.
• Extensive hands-on experience with MSSQL Server upgrades/migrations and VMWare environments including SQL 2012/2014
• Worked creating logins, tables, indexes, table spaces and Data files
• Configuration of Log shipping and Replication
• Configuration of Mirroring (Synchronous &Asynchronous)
• Developed Data warehousing environments using SSIS packages
• Worked on high availability options of both SQL 2012 and SQL 2014.
• Configuration of Transactional replication (Push & Pull Subscriptions)
• Up gradation of SQL Server 2008,SQL Server 2008 R2 to SQL Server 2012 & 2014
• Migration of SQL Server from physical servers to Virtual servers and Vice versa
• Configuration and troubleshooting of Always-on on Type 1,2,3and Type 4
• Developing Successful Backup Strategies based on recovery model.
• Involved in CDC (change data capture) and CT (change tracking) process.
• Recovery of Database at the time of Database crashes
• Experience with PowerShell Scripting
• Working with Foglight(Monitoring tool) and Litespeed(Backup tool)
• Worked on MSI & MSP files issues which were a raised at the time of SQL up gradation.
• Manage assigned support tickets to insure timely escalation and resolution of issues and provide required status to customer. Take ownership of assigned support issues, including “misdirected issues” when reported by the customer.
• Provide all levels of email/phone technical support for Change Management
• Provided strategic direction for the database team and functioned as the technical/project leader on projects.
• Work directly with MSIT customers, partners, and sales technical staff to provide technical support services.

Environment: Windows 2003/2008/2012 server, MS SQL Server 2000/2005/2008 R2, 2012, 2014 MS Access, T-SQL, MS Excel, PowerShell, Virtual Machines, Performance analyzer and SQL developer

Confidential, Houston, TX

Sr. SQL Server DBA

Responsibilities:

• Maintained a stable process of database refresh from production to internal environments.
• Installed Configured and Maintained deployments for SQL 2008,2008r2 and 2012
• Responsible for Setup, configuration, maintenance of SQL Servers and their Mirroring.
• Ensured the integrity and security and auditing the SQL Servers.
• Used Performance Monitor/Profiler, trace flags to solve Dead Locks/Long running queries.
• Used SQL profiler, system monitor, query analyzer for troubleshooting, monitoring, optimization and tuning of SQL Server and SQL code
• Responsible for regular database maintenance process and disk defrag procedures in Production and Non production environments
• Configuring log shipping and replication
• Developed automated daily, weekly and monthly system maintenance tasks such as database backup, database integrity verification and indexing.
• Worked on Virtual Servers.
• Involved in CDC (change data capture ) and CT(change tracking ) process.
• Configuration and troubleshooting of Always-on on Type 1,2,3and Type 4
• Controlled and coordinated the installations (Security Patches, Service packs) and evaluated the performance before Pre-deployment.
• Configuration of Log shipping and Replication
• Configuration of Mirroring (Synchronous &Asynchronous)
• Created Linked Servers between SQL Server 2000, SQL Server 2008 and OLE DB data sources.
• Creating and scheduling maintenance plans which include Database Backups database maintenance checks like shrink database, re-organizing and rebuilding of Indexes
• Provided strategic direction for the database team and functioned as the technical/project leader on projects.

Environment: Windows 2003/2008/2012 server, MS SQL Server 2000/2005/2008 R2, 2012,MS Access, T-SQL,Oracle 11g, MS Excel, Virtual Machines, Performance analyzer and SQL developer

Confidential

Lead SQL Server DBA

Responsibilities:

• Providing 24/7 On-Call supports for critical production databases.
• Install, configure, administer, secure and maintain SQL Server 2000, 2008 and 2012 instances and databases
• Refreshes from Production backup to Stage and Development environments
• Managed the migration of SQL Server 2008 databases to SQL Server 2012.
• Troubleshooting performance issues with Native SQL Profiler, Perfmon and other third party tools
• Proactively monitoring space and minimizing space issues.
• Design and implementation of standards across all the SQL Servers.
• Implementing and administering database replication.
• Configure and Monitoring log shipping and planning for Disaster recovery.
• Managing SQL Server on a cluster and experience in installing service packs.
• Monitoring DBA and Application jobs and troubleshooting the same.
• Managing Database security my providing the appropriate permissions to the users.
• Planning downtime for patching and other application maintenance activities
• Troubleshooting SQL Server and application related issues
• Supported high available technologies like Clustering and Database mirroring and resolved critical issues.
• Resolving connectivity and ad-hoc user issues.
• Monitoring replication and resolving related issues.
• Experience on performance tuning and query tuning.
• Experience in SSIS, SSAS and SSRS of MS SQL Server tools.
• Proficient in Data Migration from sources like MS Access, SQL server, Text Files, Excel to SQL server 2000/2005/2008 using SQL Server Integration Services (SSIS).
• Worked on Creating logins and providing Permissions to user.
• Work on Stored Procedures, Modifying Tables, Views, Indexes, and User-defined Functions.
• Performed Backup and recovery & Automation of Backups using maintenance plans.
• Writing T-SQL code.

Environment: Windows 2003/2008 server, MS SQL Server 2000/2005/2008 R2, MS Access, T-SQL, MS Excel, lite speed.

Confidential

Sr. SQL Server DBA

Responsibilities:

• Performing SQL server daily health check and preparing a report based on it.
• Monitoring Disk Space of all the Servers and freeing up space as per SQL Server i.e. Older Backups, Unused Files etc.
• Handling creation of new SQL Server databases as per Client/Application Team request using Build Sheet Template.
• Scheduled and maintain routine Jobs, Alerts and Maintenance Plans.
• Applying Service Packs and Security patches for the Servers as released.
• Monitoring the Log Space for successful execution of all the specified jobs.
• Managing backups on a daily basis and recovery (as per request).
• Reviewing SQL Server and SQL Server Agent Error Logs.
• Involved in CDC (change data capture ) and CT(change tracking ) process.
• Created jobs to rebuild indexes and updating index statistics in regular intervals.
• Monitoring of server performance by profiler during peak periods of server utilization.
• Have prepared User-Manuals and Technical documents for the project, which includes ED (Environment Description) documents/ Run Books / RCA’s within the team.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security policies and also preparing Auditing Reports for following auditing standards.
• Setting Perform counters for monitoring the server as per request about degraded performance from Application Team and then passing the trace files for L3 for an advanced review.
• Configuration and Maintenance of Log Shipping, Mirroring & Replication across different Environments.
• Configured SQL Servers with appropriate settings to resolve various resource allocation & memory issues and disk I/O issues, created baselines stats.
• Captured and analyzed the long running stored procedures using SQL Server Profiler and tuned the same to optimize application and system performance.
• Develop, implement and administer database policies and procedures and provide technical support and assistance to all database end-users.

Environment: SSMS SQL Server 2008/2005/T-SQL, Windows XP, Windows 2000, 2003, 2008 Advanced servers.

Confidential

SQL Developer/.Net Developer/ SQL DBA and Oracle DBA

Responsibilities:

• Started working as developer and created advanced stored procedures
• Quickly migrated into SQL Server DBA and Worked on SQL 2000 and SQL 2005 servers.
• Created Maintenance plans to Automate Backups and Database maintenance
• Worked on Exporting and importing tables in oracle, Worked on Backup and restore on oracle databases and Databases creations, Worked on .net coding for App
• Performed day to day actions on the server
• Designed and prepared web services using Visual Studio and CSharp Dot Net.
• Maintained required architecture documentation.
• Created linked servers for both SQL to SQL and SQL to ORACLE 8i & 10g.
• Worked Migration of databases from SQL 2000 to 2005

Environment: SQL Server 2008/05/00, Windows 2003, Windows 2000 Server, MS SQL Server 2000/2005,Oracle 8i/10g, Confidential SQL server Visual Studio 2005/2008, MS BusinessIntelligence Development Studio 2008.