Sundeep Anand

Mobile : +91-998******* / 998-***-****

Email : adl6kw@r.postjobfree.com

adl6kw@r.postjobfree.com

LinkedIn : https://www.linkedin.com/in/sundeep-anand-835a438/ Objective

Looking to secure a senior Database Administrator position that will allow me to be an individual with exceptional technical and communication skills benefitting the company. Career Summary

14 plus years of experience in IT industry with overall experience over 15 years.

Good Communications Skills backed by Interpersonal Skills, Self-Motivated followed by good Leadership qualities.

Over 13 years of experience in SQL Server 2005,2008,2012,2014,2016 & 1.3 yrs in Oracle 9i

Over 1.5years experience in handling GreenPlum, MySQL and Postgres Databases.

Exposure to Citrix XenApp 4.0 / 6.5,HyperV and VMWare(VSphere).

Exposure to Active Directory, IIS 6.0/7.0.

Personality Traits

Strong motivational and leadership skills.

Excellent Soft skills backed with strong communication skills.

Ability to produce the best results even under pressure.

Ability to work in a team as well as an individual. Technical Summary

Databases : SQL Server 2008,2012, 2014, 2016 Oracle 9i, 10g, GreenPlum 4.2.5.2, Postgres 8.3, MySQL 5.1,5.6

Operating Systems : Windows Server 2003,2008 and 2012, Linux(RedHat 5.x). Application/Tools : Citrix XenApp 4.0/6.5, VMWare(VSphere) Web Servers : IIS, Apache Tomcat

Work Experience

Currently working with Aspect Technology Center, Bangalore as Principal Customer Care Engineer from March 2016 till date.

Job Profile: Part of the Tier-2/3 level escalations and work on SQL Server 2008,2012,2014 and 2016 Databases and product support to Aspect products. Tasks performed are as below.

• Participate in high level meetings with VP/CTO of Customers during escalations.

• Configure/Troubleshoot issues related to Database Logshipping, mirroring, AlwaysON and replication.

• Configure/Troubleshoot issues related to Backups, Optimization of indexes, SQL jobs and Data/Log files.

• Handle Performance issues related to SQL queries by executing SQL Profiler traces, DBCC Traces, Extended events and Perfmon traces before sharing my analysis/findings.

• Troubleshoot multiple issues related to the applications owned by Aspect viz., Unified IP, Workforce Management(WFM) and Aspect Performance Management(APM).

• Create knowledge articles and manage them by updating them periodically for most of the recurring issues as well as first time issues.

• Provide technical and Product training for new joiners and mentor junior/other Engineers on Database and other products supported by me.

Previously worked as Senior SQL Database Administrator (DBA) -Associate Delivery Specialist-II with EMC2 from March 2014 till March 2016 including Contract-to-hire position for TekSystems-Allegis Services India (Pvt) Ltd, Bangalore for EMC2, Bangalore from March 2014 till Oct 2014. Job Profile: Worked on SQL Server 2008, Postgres and GreenPlum Databases. Tasks performed are as below.

• Supporting SQL Server 2008 and GreenPlum databases on Production, Staging/Dev and DR servers

• Creating / Monitoring Database maintenance plans for compressed full/Differential DB backups and transaction log backups, Check Database Integrity, Index maintenance and update statistics.

• Managing Security like windows and SQL Logins, Roles, permissions for various users.

• Setting up and monitoring Disaster recovery environments like Database mirroring and Failover Clustering between Primary and DR servers.

• Troubleshooting Application and Backup jobs failed issues and cluster resources failed issues.

• Database refresh from Production to Staging (Disaster recovery Drill)

• Resolving Server, Database, query performance, tempDB, Transaction Log full and Low disk space issues.

• 24/7 Database operational/production support for SQL server 2008, Postgres and GreenPlum.

• Verifying Instance and DB health checks, perform Export/Import Database objects.

• Managing and Administering the SQL Server 2008/ Postgres / GreenPlum production and Non- production servers.

• Performance Monitoring, Capacity planning, writing TSQL statements and tuning them for better performance

• Installation of SQL Server 2008 R2 on Windows Server stand-alone and Cluster environment.

• Experience in High Availability techniques like Replication, Logshipping, Database Mirroring and Clustering.

• Managing GreenPlum and Postgres databases, performing upgrades, Maintenance, troubleshooting performance and other Database related issues. Work closely with GreenPlum support and take assistance on Server/hardware replacements.

• Practice ITIL standards like Incident Management and Change Management.

• Also involved in training new joiners and continuously mentoring them in all the major activities. Worked on process improvements and building a strong knowledgebase of known issues and steps to fix them by creating SOPs.

Previously worked as Senior DBA at Techtree IT Systems Pvt. Ltd., Bangalore from July 2013 till March 2014. Job Profile: Worked on SQL Server 2008 and Tasks performed are as below.

• Managed day-to-day Operations and worked closely with the client on gathering the Project requirements then allocating the same to developers and handle project delivery and adhere to SLA on resolving the issues.

• Managed operational activities of team members that involved assigning Tasks, maintaining their Timesheets, setting up Shift schedules, resolving conflicts, etc., Single point of contact for Client requirements and delegating the issues/tasks to the developers.

• Handled issues related to Databases by providing support to Client databases, Performance Monitoring, Capacity planning, writing TSQL statements and tuning them for better performance.

• Managed and created UserAccess/Database, Backup/Restore, Maintenance Plans, Built indexes and performed Reindexing on existing ones, configured Logshipping, Mirroring and other Changes to the Production Database.

• Monitored/Fixed issues with System/User Database Files(Transaction Log Full), Monitored Disk space and performed cleanup activities such as Shrinking Log files.

• Performed mock Disaster Recovery activities on quarterly basis.

• Worked towards building a Framework for the Change request and new Task process for the Team deployed at Client location.

Installation and configuration of MySQL 5.1 on QA,Lab environment. Performed data migration from MYSQL to MS SQL Server 2008.

Previously Worked as System Engineer at Talisma Corporation Pvt. Ltd, Bangalore from May 2010 till July 2013.

Job Profile: Worked on Windows 2003 & 2008 Citrix XenApp, VSphere, SQL Server 2000, 2005 & 2008 and Tasks performed are as below.

• Handled Internal Teams issues pertaining to CRM Product and other infrastructure issues.

• Installation of different Talisma CRM Product versions including their Hotfixes.

• Provided Database Administration of more than 60 Production servers.

• Backups and Recovery of Databases, Database Maintenance.

• Installation/ Upgradation of SQL Server 2005 & 2008 in standalone environment & applying service packs.

• Creating and Managing Database Users, assigning server roles and database mapping.

• Implementing Database maintenance plans and disaster recovery plans.

• Monitoring of SQL Server performance and fixing the issues, applying Microsoft suggested patches.

• Creating & Monitoring of Jobs, Replication, and Clustered servers.

• Create Users, Organizational Units, Groups, etc. in Active Directory.

• Install and configure Windows 2003/2008 servers on Virtual environments.

• Configure Internet Information Services(IIS), Virtual Directories, Websites, Application Pools.

• Managing Applications on Citrix(Configuring and Publishing Applications), assigning/removing users to applications published. Adding/Removing servers to published applications.

• Creating Virtual Machines through VM_Templates, Cloning, Creating Snapshots, adding CPUs, Adding/extending Memory and Disks along with other tasks in VSphere client.

• Install & Configure CRM applications for new clients/upgrade to latest version for existing customers, applying patches, hotfixes etc.

• Practice ITIL standards like Incident Management, Change Management and Configuration Management.

• Working on process improvements and building a strong knowledgebase of known issues and steps to fix them.

Previously worked as IT Executive at Goodrich Aerospace Pvt. Ltd., Bangalore from October 2008 to April 2010.

Job Profile:

Worked on ERP Applications used for Timesheet Management, Payroll system and other in-house applications. Installation and configuration of SQL Server, IIS, .Net Framework, Visual Studio and all other required prerequisites for these Applications to run were handled by me. Creating Databases, User Management, Jobs Creation, Handling Backups and restores were all part of my Day- day job.

Have exposure to SAP User administration roles like password resets, Account Locking/Unlocking and troubleshooting the Printer issues.

Was involved in implementation of 2 projects by giving them Infrastructure support like installing the Prerequisites and application installation/configuration. Also worked on preparing and implementing Disaster Recovery for these Applications.

Previously worked as Application Support Engineer at JK Technosoft Pvt. Ltd, Bangalore from August 2007 to October 2008.

Job Profile: Mainly worked on an Application called “Support Online”. My job basically was creating, modifying and maintaining the User ID’s in the database as per the password policy. Worked on ETL via Import-Export and executed SQL scripts and procedures to upload the data into the database in UNIX platform. Backup the database from Production Server and restore the same in Development server to sync both the databases using Export and Import commands.

Previously worked as Software Analyst at Shams HealthCare Software Pvt. Ltd, Bangalore from July 2006 to August 2007.

Job Profile: Worked on SQL Sever 2000 and 2005 and tasks done were SQL Job Scheduling, Security and permission, Creating packages, Tables setup, Backups and Restore, Performance Monitoring, Exception Handling, Analyzing Stored procedure and Triggers, Uploads/Downloads & Meditech upgrades.

Previously worked as Faculty-Lecturer at Sambhram Institute of Technology, Bangalore from November 2005 to June 2006.

Scholastic Profile

Professional:

B.E. in Information science & Engineering from Sambhram Institute of Technology, Bangalore affiliated to Visveswaraiah Technological University, Belgaum with an aggregate of 63.5 % in the year 2005.

Diploma in Computer Science & Engineering from M.N Technical Institute, Bangalore affiliated to Technical Board, Karnataka in the year 2002.

Courses/Certifications:

Have completed 1 year Diploma in Software Management from Aptech, Bangalore.

Have completed 3 months Course on Oracle Application Software Developer at SQLStar International, Bangalore.

Under went Oracle Certified Associate (OCA) certification training.

Underwent Pivotal Greenplum Architecture, Administration and Implementation.

Underwent Microsoft certification course on SQL Server 2K12/2K14(MCTIP)

ITIL V3 Foundation and EMC ISM (Information Storage Management V2.0) certified.

KCS V5 Foundation certified from HDI

Currently pursuing Cloud Architect(Azure/AWS) course from SimpliLearn.

Currently pursuing AZ-104 Azure administration certification training program.

Completed Microsoft Azure Fundamentals AZ-900 certification. Personal Profile:

1. Date of Birth : 11th April 1981

2. Father’s Name : Dayananda. V

3. Familiar Languages : English, Kannada, Hindi, Telugu. 4. Marital Status : Married.

5. Citizenship : Indian.

6. Passport Number : R9508403

Extracurricular Activities & Hobbies:

Listening to Music, Playing Cricket, Net Surfing & Traveling.

Contact this candidate