Database Administrator L2

Qualifications, Skill Set

B. Tech/ B.E/ MCA/ equivalent

Required Experience

Minimum 3 years of working experience in DBA and operation management in MS SQL Enterprise Server.

Degree, preferably IT or Engineering-related.

Experience in setting up and supporting database mirroring, failover clustering would be advantageous.

Relevant working experience as an MYSQL/ MARIA DB / MS SQL Database.

Administrator in a production environment would be preferred

Roles & Responsibilities

Supports the installation of database software and migrations to new data management system software levels, and tests the migrations to ensure data reliability and functionality.

Analyzes, designs, modifies and maintains database structures.

Designs and implements procedures necessary to save, retrieve, and recover databases from hardware and software failures.

Establishes and implements database security controls and user access levels.

Evaluates and recommends database software packages for potential acquisition.

Prepares and develops database documentation, procedures, and definitions for data dictionaries.

Performs logical and physical data modeling, designs relational database models, and creates physical data models from logical data models.

Performs database performance monitoring and implements efficiency improvements.

Assists in modifying existing databases and database management systems.

Assists in developing standards, guidelines, policies, and procedures designed to ensure the integrity of the database environment.