Job Description:
Qualifications, Skill Set & Experience required:
1. B.E./B.Tech. (Computer /IT /Electronics) / MCA/ M.Sc. Computer Science / Equivalent or higher from a recognized
university
2. Certification in Linux Database Administration
3. Minimum experience - 6-8 Years
4. Experience of installation & configuration of Linux based MySQL/PostgreSQL/Oracle Database/application Server software
with high availability solutions like Clustering/ load balancing/ log-shipping of servers
5. Extensive Knowledge of administration and management of Linux based Database Servers. Knowledge of
related/ dependent OS services.
6. Knowledge of IIS / Apache/Tomcat Web Server for http services etc. for integration with Web/ Application Server.
Scope of Work:
a. Installation & configuration:-
Should be capable in setting up servers Installing MySQL, PostgreSQL, Oracle Server etc. Software (Enterprise class)on Linux Platform with using various technologies like Cluster Solutions, multiple instances, Virtualization overSAN /NAS environment.
Ensure proper configuration of server parameters, operating systems administration and tuning. Implementation & maintenance of Mirroring/Log shipping as Backup/DR Solutions.
b. Administration & Trouble Shooting:-
Should be capable in undertaking end-to-end management of database on an on going basis to ensure smooth functioning of the same.
Should be capable in conducting configuration reviews to provide tuning inputs to, in order to improve the performance or resolve bottlenecks if any.
Manage database upgrade or patch upgrade as and when required with minimal downtime.
Conduct regular backups for all databases in accordance with the backup and archive policies and conduct recovery
whenever required with appropriate permissions. Testing of backup media shall be undertaken from time to time to ensure availability of data.
c. Routine Task
Should be capable in using DBA tools related to performing database creation, maintenance. Undertake tasks including, but not limited to, managing changes to database schema, disk space, storage, user roles.
Performance monitoring and tuning of the databases on a regular basis including, preventive maintenance of the database as required. Configuring & monitoring of Local and Remote backups as to support the Business continuity.
