Dileep Bokam

acvmwu@r.postjobfree.com

Mobile: +1-425-***-****

SUMMARY

A professional with strong database administration skills across all versions of MS SQL Server from 7 to 2016. Having 11 years of extensive work experience in troubleshooting all kinds of database issues and managing large- scale OLTP [2 TB] databases. Ability to manage SQL Server databases through multiple product lifecycle environments, from development to mission-critical production systems on windows & Azure platforms. Ability to develop, design and delivering critical and innovative Business Intelligence solutions. HIGHLIGHTS

Review and design high-availability solution based on the available technologies like Log shipping, Database Mirroring, Replication & Always On high availability solutions. Involved in building two node active-passive SQL Server 2008/2012/2104 clustering on Windows 2008/2012 servers also implemented 3& 4 node SQL Server 2012 active/passive & Active/active clustering. Analyze current performance issues to determine trends, provide solutions to increase performance, reliability and connectivity. Expertise in Query Performance & Index Tuning, Maintenance, Troubleshooting, Query Optimization, Client/Server connectivity and Database Consistency Checks using DBCC Utilities, DMVs and DMFs

Implementing tight security to SQL server database & BI instances, by providing appropriate privileges to the users/groups and also protecting the critical database backups by enabling [TDE] Transparent database encryption.

Extensively involved in migrating all database components, SSIS packages, SSRS reports & building new SQL server instances during data center migration from SFO/SNA to Quincy data center. Experienced in automating administrative tasks by using T-SQL Programming, SSIS packages, Power Shell, Stored Procedures, functions and generating automatic reports from SSRS reporting services Experience in administering entire SQL Server Business Intelligence stack by building SSIS packages, SSAS Cubes and hosting SSRS reports as per business requirement. TECHNICAL SKILLS

Databases Administration : MS SQL Server 2016/2014/2012/2008/2005/2000/7.0, Azure SQL Database & BI Tools : Fail over Cluster manager, Database Tuning advisor, SQL Profiler, SSRS, SSIS, SSAS Programming & Scripting : T-SQL, PowerShell 3,4,5, Command Shell Monitoring & 3rd Party Tools : Lite Speed Backup, Active Batch 9, 10 & Spotlight Process Tools : SVN, BMC Footprints, BMC Remedy, MOM, SCOM EDUCATION

Master of Engineering : BITS Pilani – 2005, Rajasthan, India. Bachelor of Engineering : K L University – 2002, Vijayawada, Andhra Pradesh, India. PROFESSIONAL EXPERIENCE

Cognizant Technology Solutions : Technology Lead May 2011 to till Date IBM India Pvt Ltd : Sr SQL DBA Feb 20011 to May 2011 CSC India Pvt Ltd : Sr SQL DBA May 2009 to Feb 2011 Wipro Technologies Ltd : Project Engineer Aug 2005 to July 2008 CERTIFICATIONS

70-462 : Administering Microsoft SQL Server 2012 Databases 70-463 : Implementing a Data Warehouse with Microsoft SQL Server 2012 Risk Management Foundation- Harvard Medical- Boston, MA - Sr DBA May 2016 – PRESENT RMF offers a number of risk solutions that deliver the highest degree of insight and data integrity. It unique vulnerabilities, accurately prioritize needs, support resourcing, and mobilize solutions that will dramatically reduce medical errors, mitigate financial loss, and minimize harm. The sensitive PHI data is stored across 250+ SQL servers. I am acting as SME also responsible to co-ordinate between onsite and onshore.

Heavily involved in migrating all in house SQL server instances & databases to SQL Azure cloud platforms. To assist customers’ Capacity Management team by reviewing platform capacity design and offer best practices solution.

Implementing, Monitoring & trouble shooting of all kinds of Always on Availability database issues across business critical servers.

Good knowledge and in-depth troubleshooting experience on all transactional replication and data synchronizing issues.

Deployment of SQL Codes, SSIS Packages, SSAS Cubes, and SSRS Reports across multiple product lifecycle environments.

Implementing tight security to SQL server instances, databases by providing least privileges to the users/groups and also protecting the database backups by enabling [TDE] Transparent database encryption on sensitive & critical databases.

Performing Azure backup & restore from Azure SQL database during disaster recovery and quarterly DR testing. Hands on Experience in configuring, maintaining SQL cluster and troubleshooting all cluster related issues and migrating SQL clusters from lower version to higher versions of SQL server 2012 & 2014 Good hands on experience in deploying SSIS packages, SSAS Cubes & SSRS reports in UAT/Prod environments. Automating all SQL DBA tasks by creating the packages and fixing all SSIS package related issues during execution. Technologies: SQL 2008/R2, 2012, 2014, 2016 SSIS, SSAS, SSRS, Active batch, SQL profiler, DTA, SVN, BMC Footprints Core Logic –Los-Angeles, CA – Tech Lead May 2011 – April 2016 Core Logic is a financial services organizations and real estate professionals turn to for unique perspectives that identify, interpret and direct action that helps solve their toughest business challenges. The mortgage data is scored across various data platforms like Oracle, SQL, and Teradata. Our responsibility is to ensure that the data available on 24*7 without any performance issues. To assist the Incident Management team to drive down the number of incidents by identifying the root cause. Perform Post Incident Review on major incidents.

Installing Default/Named instances of SQL servers 2008/12 on standalone & cluster servers during data center migration

Migrating all database components, SSIS packages, SSRS reports from SFO to Quincy data centers. Review and design high-availability solution based on the available technologies like Log shipping, Database Mirroring

& Replication.

Applying service packs, upgrades & security patches on both standalone and clustered instances of SQL server. Hands on experience in using data partitioning/table partitioning on huge tables containing millions of rows for better performance

Expertise in Performance Tuning, Index Tuning, Maintenance, Troubleshooting, Query Optimization, Client/Server connectivity and Database Consistency Checks using DBCC Utilities, DMVs and DMFs To assist our customer with security design, configuration and to provide best practices to ensure our customers’ environment is safe and secure.

Flexible in timings and handling the production issues during weekends and late nights during on call support. Technologies: SQL Server 2005, 2008/R2, 2012, 2014, SSIS, SSRS, Lite speed, Upgrade Advisor, Spot Light, SSMA, MOM DuPont – Wilmington, DE – Sr SQL DBA May 2009 – Feb 2011 DuPont tackles some of the world’s biggest challenges by creating real-world solutions that help make people’s lives better, safer and healthier. DuPont products continue to change the world in which we live, and we’ve been doing so for more than two centuries.

To identify and to implement best practices to ensure continuance of business operations and to reduce the risk and impact of potential disaster scenarios.

Upgrading SQL servers by applying Service packs, Security patches and Hot fixes. Configuring and troubleshooting Log shipping & Database Mirroring across different data centers Configuring transactional replication between the servers for reporting purpose Expertise in resolving slow running queries by using Native tools like SQL Server Profiler, Database Tuning Advisor and Perfmon.

Configuring the Central Management servers for generating the reports which are useful during auditing. Hands on experience in using Policy based management for evaluating policies across the environments. Experience in solving Real Time issues with Index fragmentation, DBCC checks, Query Tuning, Error and Event Handling. Technologies: SQL Server 2000, 2005, 2008/R2, SQL profiler, Database tuning advisor, Lite Speed Backup, BMC Remedy Owens Corning – Toledo, OH – SQL DBA July 2008 – May 2009 Owens Corning offers insulation and roofing businesses make new and existing homes and buildings more energy efficient, comfortable and attractive. Our composites business manufactures products from fiberglass reinforcements to meet diverse needs in diverse markets.

Hands-on experience in resolving locks deadlocks, handling Isolation levels and performance issues like CPU, I/O, Memory bottlenecks

Experience in planning and implementing DB Security by creating Logins, Users, Roles and assigning permissions according to the requirement.

Transferring the data from one to another server by using import and export wizard. Technologies: SQL server 7.0, 2000, 2005, 2008, SQL profiler, Database tuning advisor, SCOM Microsoft –Redmond, WA – Project Engineer Aug 2005 – July 2008 PSITOPS, Platform support IT Operations is to Provide support to all Production MS SQL Server Environment across Microsoft. PSITOPS have ability to maintain/manage 5000+ SQL servers and ensure to run the applications on a 24/7 environment. They are responsible to build new servers and configure high availability solutions as per the business requirements. Creating backup strategy for mission critical databases. Good exposure in trouble shooting all type of backup and recovery issues.

Experience in using SQL profiler to fix/debug the slow running queries/SP. Identify the bottleneck indexes by using the database tuning advisor Involved in the project team working towards confirming to the framework and recommendations of the IT Infrastructure Library for IT Service Management

Technologies: SQL Server 7.0, 2000, 2005, 2008, lite speed, SQL profiler, SCOM

Contact this candidate