Dillip Jena
Sql Database Administrator @Tata Consultancy Services
Signup · Get unlimited contacts
WORK HISTORY
Sql Database Administrator @Tata Consultancy Services
Bangalore Urban, IN
EDUCATION
Sushree Institute of Technical Education(SITE)
Diploma Engineering (IT), Information Technology
GITAM Deemed University
Master of Computer Applications - MCA, Computer Science
Sikkim Manipal University - Distance Education
BCA, Computer Science
ABOUT DILLIP JENA
Master in Computer Application with 7 Year\'s of IT experience in which 5.5 yrs working as a MSSQL DBA, Azure DBA (IAAS & PAAS) for several clients such as Health care, Retail, Manufacturing etc with TCS.Certifications- AZ-900, DP-900, ITIL V3 & Persuing AZ-104MSSQL dba skills · Working as a SQL Server DBA that provides 24*7 production support for the various client’s mission in critical database environment· Experience in MS SQL Installation, Migrations, Configuration & Maintenance of multiple SQL Server environments such as 2005/2008/2008 R2, 2012, 2014 & 2017 and Windows Server 2003/2008/2012/2014· Experience in Managing Database Security by creating Users, Roles and assigning proper permissions according to the business requirements· Proficient in Database back up ((Full, Differential and T-Log) and restoring) handling issues with Log files, Shrinking Log and Data files· Having work experience on creating and monitoring daily maintenance plans for Full Diff T Log backups jobs weekly maintenance plans· Upgrade/Migration of MS SQL Server 2005 to 2008/2012 and applied service pack· Having experience on installing and configuration SQL Server instances service packs and host fixes on windows & cluster environment· Knowledge in SQL Database Migration from On Premise to Azure cloud· Experience with troubleshooting of databases issues· Utilization of DBCC commands for maintaining database consistency· Experience in High Availability solutions log shipping, DB Mirroring, Always On AG· Handling blocking/locking issues and troubleshooting accordingly· Monitoring the Disk spaces on all the servers · 3 Years of experience in Azure IAAS & PAAS Database Administrator for Healthcare domain for the activities like installation, database migration from On Premises to Azure cloud· Expertise in SQL High Availability strategies like Always ON, Mirroring, log shipping on Azure IAAS environment and on premises SQL database servers.· Basic knowledge on BI tool.· Fast learner with excellent problem-solving skills and having good client interaction skills.· Have knowledge on ITIL processes systems especially Change Management, Incident management & Service request· Ability to work proactively in 24x7 customer facing delivery environment.· Excellent Team player with good communication, analytical & problem-solving skills
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.