Linux Database Administration

Location- Delhi. ( WFO).

Position - Database Administration - Linux

Total Exp - 6+Years

• 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.