Resume

Sign in

Sql Server Manager

Location:
Frisco, Texas, United States
Posted:
February 03, 2018

Contact this candidate

Professional Summary:

** + years of IT experience in SQL Database Administration and planning & designing of very large and complex databases in most of the SQL versions like SQL Server 2016, 2014,2012, 2008 R2, 2008, 2005 and 2000.

Currently Handling 700+ servers and maintaining large volume DB’s like 10 Terabytes.

Client facing role and handling the 20 members DBA team at onshore & offshore.

Experience in Installing, Configuring, Managing, Monitoring and Troubleshooting SQL Server 2000/2005/2008/2012/2014.

Expertise in datacenter migration projects with side by side and in place upgradations.

Expertise in Always-On Availability Groups (AAG) and HA/DR Troubleshooting on multi datacenters with multiple subnets in SQL 2014 & 2016.

Expertise in Replications with standalone and Always-On Availability Groups (AAG) SQL instances from SQL to SQL and SQL to Oracle (heterogenous) systems.

HA/DR Troubleshooting on multi datacenters with multiple subnets in SQL 2014 & 2016.

Expertise in NUTANIX, ESX, UCS and VM ware technologies and configurations.

Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.

Strong technical background along with the ability to perform business analysis and write effective documentation and specifications.

Expertise in T-SQL writing stored procedures, triggers and functions.

Administering SQL Server High Availability and Disaster Recovery strategies with RPO & RTO’s.

Expert in data transformation services and Bulk Loads with SSIS and BULK INSERT ETL operations.

Implemented the new SQL Server 2014 & 2016 mechanisms like data compression, online indexing, Contained Databases, security principals and AAG.

Experience in using DMV and dynamic management functions for finding out long running queries.

Experience in Disaster Recovery Planning and Security Management operations.

Proficiency and expertise in SQL Server Replication with multiple versions and Heterogeneous replication from SQL server to Oracle databases and planning.

Having hands on experience in DR processes like traditional SQL Server failover clustering (MSFC), Log Shipping and Database Mirroring.

Worked on configuring SQL Server with minimum privileged access.

Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on RAID levels & Nutanics Infrastructure’s with VMWare platform.

Troubleshoot performance problems, fine-tuning of databases and index Analysis.

Worked on SQL Server 2014 migration from SQL Server 2008 / 2005 versions.

Experience on 64 bit SQL Server 2012 / SQL Server 2008 R2 systems and MSCS Configurations.

Applied service packs on most of the SQL versions like SQL 2000/2008/2008R2/2012/2014.

Maintained individual service accounts for SQL Server services on cluster with different Security groups to raise security mark.

Having Experience on Data center migration project with minimal downtimes.

Handling Memory configurations for SQL Server 2014 and SQL Server 2012 on Windows 2012.

Experience in Batch processes, Import, Export, Backup, Database Monitoring tools and Application support.

Created Linked Servers between SQL Server 2008 R2 & Oracle 9i and 10g. Also created DTS package for data transfer between the two environments.

Working knowledge in Analysis Services(SSAS), Reporting Services(SSRS) and Clustering.

Experience in supporting Very Large databases (VLDB) and troubleshooting the problems.

Strong experience in mentoring team members and writing documentation.

24 X 7 Production Database on Call Support

Technical Education

Bachelors of Engineering, Anna University, Chennai, India in 2006.

Administering Microsoft SQL Server 2012 Databases certification.

Technical Expertise

Databases:

MS SQL Server 2016, 2014, 2012, 2008, 2005 and 2000

Programming:

Visual Basic 6, Visual Basic 5, C, C++ & SQL

DBA:

database administration of MS SQL Server 2016,2014,2012,2008, 2005

Operating System:

Windows 2012/2008/2003 Advanced Server, NT & Windows 9x, Linux

Other Software:

Windows 2012/2008/2003 Advanced Server, NT & Windows 9x, Linux

Tools:

VMware, NetBackup, Commvalut Backup Utility, SQL Lite Speed, Visio, IDERA, SSIS,SSRS, SSAS, Red Gate Data & SQL Compare.

Network Topologies:

TCP/IP, DNS, WINS, DHCP, FTP, SNMP, SMTP

Professional Experience

Working as Sr Profession Database Administrator (TEAM LEAD) at Toyota Motor Engineering & Manufacturing North America, Inc. (TMNA), Plano, TEXAS through DXC (formally CSC India Pvt ltd) since Oct 2015 to Jan 30th, 2018.

Worked as Project Lead at DXC (formally CSC India Pvt ltd), Hyderabad since Jan 2012 to Sept 2015.

Worked as Sr System Analyst at Sonata Software, Hyderabad since Dec 2009 to Dec 2011.

Worked as Jr Engineer at Cyient (formerly Infotech Enterprises), Hyderabad since Sept 2006 to June 2008.

#Project 4:

Title: TEAM LEAD - SQL DBA

Client: Toyota Motor Engineering & Manufacturing North America, Inc. (TEMA)

Location: PLANO, TX, USA

Duration: Oct 2015 to till date.

Responsibilities

Transmission the new account from client and stated supporting.

Migrated SQL servers Erlanger datacenter to Phoenix data center from 2005\2008\2012 to SQL Server 2014 in Microsoft Windows Server 2012 Enterprise Edition.

Installed and administered Eight-Node Cluster Active/Passive on Microsoft Windows Server 2012 Enterprise Edition on SAN environment.

Expertise in Always-On Availability Groups (AAG) and HA/DR Setup and Configurations.

Extensively worked on SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS).

Migrated SSIS packages from SQL Server 2008 R2 to SSIS 2012.

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.

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 (HP servers in enterprise Data Centers).

Environment: SQL Server 2000,2005,2008,2012 & 2014 Enterprise\Standard editions, Windows Enterprise Server 2012, .NET, Microsoft Visio, SFTP, Microsoft Reporting Services.

#Project 3 :

Title: Project Lead, SQL DBA

Client: Toyota Motor Sales, U.S.A (TMS)

Location: Hyderabad, India

Duration: Jan 2012 to Sept 2015

Responsibilities

Perform business analysis, technical analysis, systems design, application software programming.

Prepared DFD's & Entity Relationship(ER) diagrams.

Restructuring the stored procedure, designing, coding and developing the same using the T_SQL Programming.

Transferring the data (ETL) to Data warehouse by SSIS.

Extensively worked on Dynamic Management Views in SQL Server 2005.

Installed, authored, and managed reports using SQL Server 2005 Reporting Services.

Managed the migration of SQL Server 2000 databases to SQL Server 2005.

Monitoring SQL server performance using SQL Profiler to find performance and dead locks.

Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.

Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.

Extensively worked on Data Partitioning and Snapshot Isolation in SQL Server 2005.

Unit Testing the SSIS packages with respect to its flow and performance issues.

Rebuilding the indexes at regular intervals for better performance.

Monitored and modified Performance using execution plans and Index tuning.

Rebuilding the indexes at regular intervals for better performance.

Managing the VERITAS net backups.

Extensively worked on DBCC commands and Dynamic Management Objects.

Expertise in SQL Server Reporting Services and SQL Server Analysis Services.

Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.

Complete documentation about the database. Recovering the databases from backup in disasters.

Export or Import data from other data sources like flat files using Import/Export through DTS, SSIS.

To analyze long running slow queries and tune the same to optimize application and system performance.

To set up SQL Server configuration settings for better server management.

Worked on SQL Server tools Like Enterprise Manager and SQL Query Analyzer.

Environment: SQL Server 2008/2005, Oracle 10g/ 9i, .Net Framework 2.0, C#.Net, Asp.Net2.0, JavaScript, VSS, Windows 2000, Windows 2003 Server, MS TFS, MS-Access.

#Project 2:

Title: Sr System Analyst

Client: Enterprise Business Management System (EBMS), Microsoft.

Location: Hyderabad, India

Duration: Nov 2009 to Dec 2011

Responsibilities:

Database Administrator, Database Programming.

Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.

Rebuilding the indexes at regular intervals for better performance

Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.

Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.

Monitored and modified Performance using execution plans and Index tuning.

Rebuilding the indexes at regular intervals for better performance.

Perform SQL Server service pack and Windows Service pack upgrades.

Extensively worked on Enterprise Manager for managing the database.

Troubleshoot performance problems and fine-tuning of databases.

Involved in Index Analysis and Performance Tuning.

Converting DTS packages into SQL Server 2005 Integration Services.

Migrating SQL Server 2000 data bases into SQL Server 2005.

Recovering the databases from backup in disasters.

To analyze long running slow queries and tune the same to optimize application and system performance.

Environment: SQL Server 2005, SQL Server 2000, Windows 2003/2000 Server, SQL LiteSpeed 4.5, MSE, ME Change Request, Visio. Enterprise Manager, SQL Query Analyzer, SQL Profiler.

#Project 1:

Title: Jr Engineer Analyst

Client: TOM TOM, Infotech enterprises.

Location: Hyderabad, India

Duration: Sept 2006 to July 2008

Responsibilities:

Installing the SQL server 2000 & 2005.

Creating logins, users and fixing the orphaned users.

Monitoring backups and moved the backups to tapes for archival.

Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.

Monitored and modified Performance using execution plans and Index tuning.

Deploying new code base release to UAT and Production Environments.

Working with customers on Application rollouts and server migrations.

Extensively worked on Enterprise Manager for managing the database.

Troubleshoot performance problems and fine-tuning of databases.

Migrating SQL Server 2000 data bases into SQL Server 2005.

Environment: SQL Server 2005, SQL Server 2000, Windows 2003/2000 Server, SQL LiteSpeed 4.5, MSE, ME Change Request, Visio. Enterprise Manager, SQL Query Analyzer, SQL Profiler.



Contact this candidate