RESUME
Sivakirankumar.N Email:**************.********@*****.*** Mobile: +919*********
Work Experience:
Having 2+ years of experience in IT industry working extensively in Database Administration
Qualifications:
B.Tech in Information Technology from JNTU Hyderabad(2005-2009).
Personality:
Quick grasping of new technology and adaptation to new environment.
Possessing good communication skills and Quick Learner.
Possessing Excellent Teamwork Spirit.
Analytical and Optimistic Approach to problems
Extra Curricular Activities:
Participated in Various School and College Competitions in Sports and Cultural Events.
Participated in Many Seminars Conducted in our college.
Actively participated in Social Welfare Activities.
Professional Experience:
Current Project#1:
Title : Human Resources Manangement System
Client : Directorate of Treasuries and Accounts (DTA), Andhra Pradesh
Platform : Windows XP
Database : SQL
Public IP : www.treasury.ap.gov.in/ddoreq/
Role : ASST.DBA.
Description:
It is very simple to use and operate it. Our project is aimed to maintain employee data of various government departments all over Andhra Pradesh which is used to accept employee data and to prepare the salary bills, calculating various Allowances (DA, TA), generating Payslips and various other bills like festival advance, scholarships etc .Using this HRMS package user will prepare the salary bill and submitted to Treasury in on line
Roles & Responsibilities:
Team providing 24/7 production support to the clients
Monitoring the Scheduled jobs
Ensuring high availability of the database.
Monitoring the Disk spaces on all the servers.
Checking the general Health of the servers for identifying Bottlenecks
Planning, Database performance tuning for optimal results.
Developed Backup strategies for Database Recovery.
Performing Database maintenance activities like Backups, Restoring, Re indexing etc.
Ensured back-up procedures executed without failure
Creating Maintenance plans and jobs for automation of the repetitive task
As a part of the DBA implementation and administration of Database.
Monitoring Transactional Replication
Monitoring database Mirroring,Troubleshoot long running Queries and Stored Procedures
Professional Experience:
Current Project #2
Title : IMPACT (Integrated Management of Pay and Accounts and Treasuries)
(March 2011 to till date)
Client : Directorate of Treasuries and Accounts (DTA), Andhra Pradesh
Platform : Windows XP
Database : SQL
Public IP : www.treasury.ap.gov.in/impact1213/
Role : ASST.DBA
Description : The main function of Treasuries department includes processing of all Government transactions across the state except in Twin cities of Hyderabad & Secunderabad; Where Payment activities are taken care by Pay & Accounts office. Main Objective of Treasuries/ PAOs is Bill processing as per the Treasury Act, Which involves extensive Bill auditing, budget monitoring, Reconciliation and Submitting of monthly accounts to Accountant General and Directorate of Treasuries and Accounts.
Role & Responsibilities:
Team providing 24/7 production support to the clients
Monitoring the Scheduled jobs
Ensuring high availability of the database.
Monitoring the Disk spaces on all the servers.
Checking the general Health of the servers for identifying Bottlenecks
Planning, Database performance tuning for optimal results.
Developed Backup strategies for Database Recovery.
Performing Database maintenance activities like Backups, Restoring, Re indexing etc.
Ensured back-up procedures executed without failure
Creating Maintenance plans and jobs for automation of the repetitive task
As a part of the DBA implementation and administration of Database.
Monitoring Transactional Replication
Monitoring database Mirroring
Troubleshoot long running Queries and Stored Procedures
(SIVAKIRANKUMAR.N)