Dinakaran Joseph Mulkalpally, Professional 1 Database Administrator

Dinakaran Joseph Mulkalpally

Professional 1 Database Administrator

DXC Technology

Location
India - Hyderabad
Education
Bachelor's degree, Computer Science and Engineering
Experience
10 years, 5 Months

Share My Profile

Block User


Work Experience

Total years of experience :10 years, 5 Months

Professional 1 Database Administrator at DXC Technology
  • United States - Virginia
  • My current job since October 2018

• Experience in working on high availability feature Always-On.
• Worked on configuring SQL Server with minimum privileged access.
• Experience in creation and management of databases, tables, indexes, views etc.
• Experience working with SQL Server 2005 Database Administration Tools such as SQL Server Management Studio, SQL Server Configuration Manager, Cluster Administrator.
• Experience in assigning, updating and revoking privileges, roles & profiles to database users.
• Experience in management of transaction logs, database files and file groups.
• Experience in Database Backup, Restore, Recovery, Disaster Recovery planning.
• Experience in Litespeed backup tool.
• Provided 24x7 on call production support.
• Experience in using DMV for finding out long running queries.
• Experience in implementation of backup and recovery strategies
• Experience in Creating, Scheduling and Troubleshooting SQL Server Jobs.
• Excellent interpersonal and communication skills, detail oriented, organized and highly motivated individual & Experience in preparing KB Documents on relevant topics.
• Strong experience in mentoring team members and writing documentation.
• Have an extensive knowledge in SQL Server with good experience in SQL Server 2005, 2008, 2008 R2, 2012, 2014.
• Expertise in Database Administration on Production Servers with server configuration, and maintenance with troubleshooting capabilities.
• Administering SQL Server High Availability and Disaster Recovery strategies.
• Experience in DR processes including Log shipping and Database Mirroring.
• Experience in Configuring, Maintaining & Trouble shooting Replication - Snapshot, Transactional, Peer to Peer, Merge Replications.
• Knowledge in clustering.
• Experience in upgrading the SQL Server database instances with latest service packs and hot fix.
• Experience on Linked Servers creation between different database instances like SQL Server to SQL Server & SQL Server to Oracle.
• Worked on database migration from SQL Server 2005 / 2008/2008R to SQL Server 2012.

Consultant at Data Intensity
  • United States - Massachusetts
  • May 2017 to October 2018

• Experience on installing the SQL Server 2005, 2008 R2 and 2012 instances and configuring the instances as per the DBA standards.
• Experience in upgrading the SQL Server database instances with latest service packs and hot fix.

• Experience in implementing backup strategies including Full, Differential and Log Backups.
• Maintaining SQL server maintenance plans such as backups, index reorgs, update stats and integrity checks.
• Creation of Logins, Users and Managing privileges as a part of Security Policies
• Experience in database refresh and fixing orphaned users.
• Experience in rebuilding system databases during crash scenarios.
• Troubleshooting and providing the fix for transaction logs and tempdb full issues.
• Experience in running the SQL profiler, trace and analysis of DB related issue.
• Experience on moving system and user databases files one drive to another drives.
• Having experience on handling suspect database issues.
• Experience on Configuring, maintaining and handling the issues in Log Shipping, Database Mirroring, replication and clustering.
• Involved in configuration of different replication types i.e. transactional, snapshot, peer to peer replications.
• Experience on troubleshooting replication issues.
• Involved in Always-On configurations and troubleshooting always-on related issues.
• Experience on Linked Servers configurations and troubleshooting the issues.
• Experience on implementation of DR test for Log shipping and mirroring.
• Involved in database migration/up-gradation from one SQL server version to another SQL Server version.
• Experience in creation and management of databases, tables, indexes, views etc.
• Experience on SQL Server Profiler.

Systems Engineer at CGI
  • Canada - Quebec
  • December 2013 to May 2017

• Experience on installing the SQL Server 2005, 2008 R2 and 2012 instances and configuring the instances as per the DBA standards.
• Experience in upgrading the SQL Server database instances with latest service packs and hot fix.
• Handling database fragmentation related issues
• Identifying and resolving Blocking and Deadlock issues.
• Analyzing the job failures and providing the permanent fixes.
• Experience on Configuring, maintaining and handling the issues in Log Shipping, Database Mirroring, replication and clustering
• Creation of Logins, Users and Managing privileges as a part of Security Policies
• Troubleshooting and providing the fix for transaction logs and tempdb full issues
• Experience in database refresh and fixing orphaned users.
• Experience on implementation of DR test for Log shipping and mirroring.
• Experience in creation and management of databases, tables, indexes, views etc.
• Use to provide On-call support on weekends.

Education

Bachelor's degree, Computer Science and Engineering
  • at Jayaprakash Narayan College Of Engineering
  • January 2012

Bachelor of Technology Jayaprakash Narayan College Of Engineering Jawaharlal Nehru Technical University Computer Science and Engineering 73.29 2012

High school or equivalent, education
  • at Bhavitha Junior College
  • January 2008

Intermediate (Class 12) Bhavitha Junior College Intermediate board of education (A.P) Mathematics, Physics and Chemistry 91.00 2008

High school or equivalent, SSC
  • at Christhu jyothi vidyalayam
  • March 2006

SSC Christhu jyothi vidyalayam APSBE 86.00 2006

Specialties & Skills

SQL Server 2005 2000
SQL Server 2000 2008
SQL Profiler
SQL Server
SQL Server
SQL Profiler
Backups and Restores
Database Mirroring
Migration
Performance Tuning
SQL Server Troubleshooting
Logshipping
Always ON
SQL Installation 2005, 2008, 2012, 2016, 2017

Social Profiles

Personal Website
Personal Website

URL removed due to policy violation. Please contact support for further information.

Languages

Hindi
Expert
English
Expert
Telugu
Expert

Training and Certifications

CCNP R&S (Training)
Training Institute:
Vivid Technologies
CCNA R&S (Training)
Training Institute:
Vivid Technologies

Hobbies

  • Cricket, Snookers, Shuttle, TT, Surfing Internet and Social Networking.
    •Participated in college and school level Debate and Essay competition,received applauds. •Organized PRAGNA Tech fest in college for consecutive 2 years. •Workshops Attended-Data Warehouse and Data Mining, Network Programming, Ethical Hacking and Information Security. •Have been part of deployments that are critical to the business.