SQL DBA
Resume:
RESUME
UJJAVAL KUMAR
FARIDABAD, HARYANA (INDIA) -121002
EMAIL: **************@*****.***
Mob. No- +91-828*******, +91-883*******
Linkedin: - https://in.linkedin.com/in/ujjawal-deshwal-97402474
Relocate :- Anywhere in India and only major develop countries.
OBJECTIVE:-
To seek a challenging position with opportunities for growth by contributing through my ambition, sincerity and dedication. To be a part of an environment that promotes team effort and provide an opportunity for value based growth while making a significant contribution to employer’s organization.
CSE EXPOSURE:
Programming Languages: c#
Server side Programming: ASP. Net,
Databases: MS-SQL 2008 R2
Platforms: Visual Studio 2008
TRAINING:-
1 months Training on PHP at SAHASRA SAMBHAV institute of training.
4 months training on .Net at APTECH INSTITUTE of training.
Working in IT field in BMCHRC Hospital Jaipur as a Sr ERP Coordinator from MAY-2017 to till date.
I have worked in FORTIS HOSPITAL LTD. Ludhiana, Punjab from Sept-2013 to MAY-2017 as a Sr. System Engineer.
SQL SKILLS:-
4+ years of experience in Database Administration for very large and complex databases in SQL
Server 2008/R2 and SQL Server 2005/2000.
Experience on Installing, configuring, monitoring and troubleshooting SQL Server
Experience in upgrading SQL Server to new versions and applying service packs and hot fixes.
Management of Database Space, Growth Monitoring of Data &Transaction log files.
Expertise in Database Administration on Production Servers with server configuration, performance monitoring and maintenance with outstanding troubleshooting capabilities.
Administering SQL Server High Availability and Disaster Recovery strategies.
Setup DB Mail and SQL Server Alerts (Disk Space, TLog Full, Replication, Backup, Schema Change, CPU, Indexing Fragmentation etc.)
Worked extensively on Clustering.
Troubleshooting production issues and raising high availability.
Creating Indexes on tables to improve the performance as per Dev/App team request.
Proficiency and expertise in SQL Server Replication, Backup/Recovery.
Having hands on experience in DR processes including Log shipping and Database Mirroring.
Worked on SQL Server 2008 R2 Migration from SQL Server 2005.
24 X 6 Production Database on Call Support.
JOB RESPONSIBILITIES:- Current Company(BMCHRC Hospital)
Maintain HIS (Hospital information system) software and handle all bugs like patient registration issue, Patient admissions, Patient Billing issue, beds reservations issue.
Daily check data in HMIS interface for tally server.
Check all jobs for their current status
Create new stored procedures and job scheduler according to company requirement.
Create and modify the Triggers.
Update the procedure for different view changes according to user need.
Check the daily backup file and all jobs which are related to procedures..
I do main data backup file restored on demo server twice in a week.
Check daily all interfaces like SRL and radiology for data transfer which are inter- connect with our software.
Create all main services through software like ;- Bed creation, Surgery/Procedures, Blood component, consultation, room categories, investigations, etc….
Modify any crystal report according to user requirements.
Create and modify the crystal report and add new data according to requirements.
PREVIOUS COMPANY
I have worked in FORTIS HOSPITAL LTD. Ludhiana, Punjab from Sept-2013 to MAY-2017 as a Sr. System Engineer.
JOB RESPONSIBILITIES:-
Maintain HIS (Hospital information system) software and handle all bugs like patient registration issue, Patient Billing issue, beds problem.
And maintain all reports in crystal format which plug in with front end application like stores and pharmacy reports, Finance reports, IP and OP billing reports.
Handle all hospital related SMS like :- occupancy SMS, Patient registration SMS, Revenue SMS, Patient discharge SMS, Patient billing SMS.
Handle all crystal report(Fix bugs) with according to user requirement.
Create new reports according to user requirements.
Maintain the LAN networking like handle the server and router inter-connectivity.
Provide the Static IP range and proxy certificate. And V-LAN configuration.
Handle the Server bugs like RAID configuration, storage partition, windows server installation and troubleshooting.
Handle domain joining, outlook email certificate configuration, Network printer installation, network path sharing for data transfer from one location to another location
EDUCATIONAL QUALIFICATION:
Qualification
B.Tech (c.s.e)
College
Aravali college of Engg. & mgmt.,Faridabad
University
MDU Rohtak
Year
2013
Percentage
71%
Sr. Sec. School
R.K.Inter College,Shamli
State Board
2009
68%
High School
S.S.N. Inter College,Shamli
State Board
2007
61%
HOBBIES/SPARE TIME ACTIVITIES:
Learning new skill
Surfing Internet.
Playing Cricket.
PROJECT:
Worked on FITNESS CENTER WEBSITE (major project) on .Net technology.
PERSONALITY TRAITS:
Learning Attitude
Smart working
Positive Strength
Team Work.
ACHIEVEMENTS:
Awarded by Employee of the month in 2014 and 2015(Fortis Healthcare Ludhiana).
Awarded by Best Technical Support in DEC-2016 (Fortis Healthcare Ludhiana).
Gold in General Knowledge interschool competition.
Gold in District level Badminton tournament.
Participate in college fest as resource planner.
Won 2nd prize in “SAVE THE GIRL CHILD” half marathon.
PERSONAL PROFILE:
Father’s name : Mr. Ajay Kumar
Mother’s name : Mrs. Manju
Date of birth : OCT. 08th, 1991
Sex : Male.
Nationality : Indian.
Marital status : Single.
Languages known : English, Hindi
Permanent address : H.NO. - 105,SECTOR- 46
FARIDABAD, (HARYANA) 121002
DECLARATION: I hereby declare that information provided by me is true to best of my knowledge.
"References available on request".
Date: 01-08-2018 (UJJAVAL KUMAR)
Place: Jaipur, Rajasthan (INDIA)
Contact this candidate