CHANDRA SEKHAR

Certified SQL Server DBA

Ph# : 650-***-****

aczvbb@r.postjobfree.com

SUMMARY

Chandra Sekhar is an SQL Server Certified Professional, having 10+ years of experience in IT industry as SQL Server DBA. He is mainly responsible for implementing Database Administration, Client Server Technology, Customer interaction and which includes Performance Enhancement, Installation, System Administration, troubleshoot network related problems and isolate faults.

Working in 24x7 database support for UK, US client's critical database environments.

Migration of databases servers and performed database refresh activities.

Migrated SQL Server 2000,2005 databases into SQL Server 2008R2,SQL Server 2012and Sql server 2014.

8+ years of experience in Database Administration and Developer for very large and complex databases in SQL Server SQL Server 2008 R2, 2008.

8+ years of experience on logical and physical database design.

Extensive experience in migration and conversion of data to/from various data sources like Sybase client from 4.9 to 11.0 of Sybase to 2008, 2008R2 and 2012 of SQL.

Administration includes Installation and Configuration of SQL Server 2000/2005/08/12.

Good understanding of SQL Server Database Engine Architecture, Physical and Logical Structure.

Install, configure, optimize and manage complex enterprise-wide SQL Server 2005, 2008 R2 and 2012.

Instance De-installation and Deactivation and regular all type of maintenance activities.

Create, perform and managed the Patch rollout plan for release management, point-in-time database recoveries.

Implemented and maintained the SQL Server high availability solutions using Failover Clustering for 64-bit Windows Server with SQL Server 2008, 2008 R2 & 2012 for 40+ instances.

8+ years of experience of SQL Server high availability solutions using Failover Clustering for 64-bit Windows Server with SQL Server 2008, 2008 R2

Installing, Configuring and maintain the Integration Services on Clustered Environment for High Availability.

8+ years of experience in 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.

Resolved issues mission critical high usage of system cpu disk, deadlocks, transactions per/sec and memory.

Proficient using DMVs, Wait-States & Performance Monitor Counters to quickly find the Root Cause of performance slow-downs.

Excellent Experience in monitoring SQL Server Performance tuning in SQL Server 2000/2005 /2008 using SQL Profiler, Query Analyzer, Enterprise Manager, Index Tuning Wizard, and Windows Performance Monitor.

Configured the log shipping and implemented transactional and snapshot replication as high availability techniques in SQL Server.

8+ years of experience of troubleshoot the problems related to availability of data to system users and disk space.

8+ years of experience of Enforce Database Security by Managing user privileges and efficient resource management by assigning profiles to users.

4 years of experience of configured and maintained backup & restore using 2012 Agent-Backup/Recovery.

8+ years of experience of managing multiple database instances.

Experience in Database Mirroring as disaster recovery solution.

Automated the SQL Backup execution using PowerShell 3.0 with Symantec Net backup 6.5.

Create and maintained all SQL Server operational documentation including manuals for most every change.

Worked in OLTP & OLAP environment that includes Production (24x7), QA and development databases in SQL Server.

Adhered to ITIL V3 processes.

Excellent communication, analytical and problem solving skills. Works well across organizational functions and management levels.

knowledge on Oracle 11g-StartUp a Database using EM

knowledge on user creation in oracle using Enterprise Manager

knowledge on Monitor and Manage Microsoft SQL Server Using Enterprise Manager 12c

SKILLS MATRIX

Server OS: Windows Server (2003/2008/2012)

Databases: MS SQL Server (2000/2005/2008/2012)

Languages: T-SQL, PowerShell 3.0.

Scripting: PowerShell 3.0

Ticketing tool: Remedy 7.5

Big Data: Cloudera and MapR

SQL Server Tools: Database engine tuning advisor, profiler, Perfmon, Surface Area Configuration,

DBCC commands, Net Vault Lite Speed for SQL Server6.5, SQL Diagnostic Manager 7.1, SQL Doc 3.0, Foglight 5.6.

Ancillary Skills: BMC, IBM Tivoli Monitoring, TSM backup, Net backup, MOM

CERTIFICATIONS

SQL Server 2008: MCTS, MCITP

EDUCATION

MCA Osmania University, India

PROFESSIONAL EXPERIENCE

Client: Ernst & Young (EY), Alpharetta, GA OCT 2016 - Present

Role: Sr. SQL Server Database Administrator

EY is a global leader in Assurance, Tax, Transaction and Advisory services. The insights and quality services we deliver help build trust and confidence in the capital markets and in economies the world over. We develop outstanding leaders who team to deliver on our promises to all of our stakeholders. In so doing, we play a critical role in building a better working world for our people, for our clients and for our communities.

Responsibilities:

Actively participated in the Database Deployments(production and Non Production)

Installing SQL 2012/2014 and configuring AlwaysOn ( 2 replica).

Build Active- Active Clusters and Active-Passive Clusters.

Experience with Geo-clustering and AlwaysOn for HA/DR SAN Production environment

Implemented Database mirroring and replication.

Implemented Replication on alwayon Database

Query tuning and performance optimization for the database.

Worked On Databases more than 5TB.

Day-to-day activities like fixing any failed SQL jobs, troubleshooting performance related issues

Worked on the Filestream Issues.

Trouble shooting and fine-tuning of databases for its performance and concurrency

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

Worked on Slow Running Query’s.

Involved in SQL performance Tuning, identifying locking and blocking issues

Resolved log space issues of the databases which are in AlwayOn Configuration.

Created Read only routing between the Replicas (AlwayOn)

Daily Tickets and other Deployment/New Application Rollout’s and Change Requests.

Data Migration using 2014/2012/2008.

Participated in the DR tests.

Worked on Control-M Backup jobs.

Monitoring the CPU usage, IO statistics, Memory Usage to identify any OS level performance killers, enabling database level trace for performance test.

Rebuilding the Indexes and updating the statistics for better performance.

Worked on Automating the Deployments by Using PowerShell.

Worked on configuring and supporting SSIS and SSRS

Execution of DML scripts and Coordinating with server team during patch/service pack installation

Environment: MS SQL Server 2008/2008R2/2012, Business Intelligence – MS SQL Server Integrated Services (SSIS) and MS SQL Server Reporting Services (SSRS), SQL Agent, SQL Profiler, Database Mail, T- SQL,Windows2003/2008 server, SQl sentry, SQLLDba Tools(EY), Visual Studio.

Client: First Care, Austin, TX Jan 2015 – Sep 2016

Role: Sr. SQL Server DBA

Environment: SQL Server 2005, 2008, 2012 Windows Server 2003, 2008, 2012, 2014

Responsibilities

Manage and administer SQL server 2000\2005\2008\R2\2012\2014 servers.

Migrations of databases from SQL 2005 to SQL 2008 and SQL 2008 to SQL 2012/2014.

Configured ALWAYS ON setup between different DATA Centres and on Multi Subnet Cluster.

Configured Windows Fail Over Clustering and SQL Clustering on Multi Subnet Cluster.

Deployment of databases, jobs, cubes from pre-production to production.

Building SQL 2005\2008\2012\2014 cluster environments on VMware or Physical windows

Performed installations of SQL 2005\2008\2012\2014 on clustered and standalone servers

Upgradations of SQL server versions and applying patches and hot fixes.

Adding nodes to already existing clustered servers as a part of data load\High availability

Configured Transactional Replication and Log Shipping with SQL Server Management

Implementation of SQL server logins, Roles and Authentication modes as a part of security policies.

Work on weekly Issues reports which are generated as a part of infrastructure setup.

Creating and scheduling maintenance plans for updating statistics, checking fragmentation, checking database integrity and backup plans

Configured Database mail, linked servers,Transparent Data Encryption (TDE) and Auditing

Performance tuning of databases by windows performance monitor and SQL Profiler

Used Index tuning wizard to redesign and created the indexes for better performance.

Fine-tuned Stored Procedures using Execution Plan in T-SQL for better performance.

Documenting the standard procedures on regular basis.

Working on tickets\incidents with in the SLA’s, as a part of operations support DBA

Conducted various meetings and conferences with application teams to meet corporate milestones for database consolidation and data migration.

Resource planning and coordination for application migrations with project managers, application and web app teams

Involved in capacity planning, sizing and database growth.

Worked in an environment with Change management process (Service-now tool) for all kind of production and non-production changes

24*7 on call production support

Client: British Petroleum, (HP), Chicago, IL Jan 2011 – Dec 2014

Role: Lead SQL DBA

Environment: SQL Server 2005, 2008, 2012 Windows Server 2003,2008,2012

Responsibilities

Used remedy ticketing tool for user request resolution.

Configured raid levels for data files, log files and temp database at server level.

Performed database refresh task from production to development and staging servers.

Resolved issues mission critical high usage of system cpu disk, deadlocks, transactions per/sec and memory.

Administered SQL server by creating user logins with appropriate roles dropping and locking logins, monitoring the user accounts creation of groups, granting the privileges to user and groups.

Extracted query plans and make sure each query and every query is using appropriate indexes.

Created standard operated procedures and work instructions for SQL server install upgrade and patching.

Supported production and development databases.

Created and configured an OLTP replication database for disaster recovery purpose.

Client: Sanofi Aventis (Accenture), Bangalore, India July 2010 –Dec 2010

Role: Database Administrator

Environment: SQL Server 2005/ 2008 Windows Server 2003/2008

Responsibilities

Responsible for General Database Administration (Database size more than 500 GB)

Tuned the SQL queries using SQL profiler. Involved in tuning the database.

Created, installed, configured SQL Server 2008 R2 cluster for BI data warehouse

Used DBCC commands to check physical and logical consistency of database to rebuild indexes.

Troubleshooting Log shipping issues

Developed Database Backup Scripts and automated the process.

Creating and maintaining users.

Client: MetLife, Mumbai, India April 2009 – July 2010

Role: Database Administrator

Environment: SQL Server 2005, 2008 Windows Server 2003,2008

Responsibilities

Setup and troubleshoot for active/active clustering on SS2K5

Transferred SQL server objects from QA server to production using SSIS packages

Developed automated daily weekly, monthly system maintenance tasks such as database backup, duplication verification, mirroring database integrity verifier indexing and statistic updates.

Handled up to 2TB database sized database with clustered and replication Environment.

Setup snapshots, merge and transactional replication between servers and troubleshoot and monitor publishers, distributers, subscribers.

Created standard operated procedures and work instructions for SQL server install upgrade and patching.

Experienced in resolving deadlock and blocking issues for concurrent users

Administered, maintained, and monitored 56 Production SQL Server 2000/2005 Databases.

Client: NATIONAL CITY BANK, Hyderabad, India March 2006 - April 2009

Role: Database Administrator

Environment: SQL Server 2000, 2005, Windows Server 2003

Responsibilities

Establishes and maintains policies, standard operating procedures, and associated documentation for user interaction with the database environment.

Moved all non clustered indexes to new file group for better performance tuning.

Handled up to 2TB database sized database with clustered and replication environment.

Implemented SQL logins, roles, authentication nodes as a part of securities polices for various categories of users.

Checking the general Health of the servers for identifying Bottlenecks Analyzing Identifying and Resolving performance issues of the server

Automating all the Tasks using Jobs and maintenance plans Configuring DB mirroring and testing the failovers manually to ensure high availability

Developed DTS packages to extract, transform and load into the Campaign database from OLTP database

Establishes and maintains policies, standard operating procedures, and associated documentation for user interaction with the database environment.

Contact this candidate