Data Analyst

Job Title: IT Database Analyst

Location: Hybrid/Remote

Note : We need the person to be an infrastructure DBA not a developer.

Description

Create the objects in the database, such as triggers, indexes, etc.

Monitor the performance of the database and ensure optimum performance.

Identify potential issues in the database to solve them early.

Maintain backups and perform disaster recovery in case a disaster destroys the database.

Monitor security and prevent any unauthorized access to the database

Schedule consistent maintenance on the server

Maintain database schema

Manage database availability

Performance tuning

Give best practice guidance to the development team

Resolve any production data issues

Taplespace management

Role management

Develop automation technologies to accelerate the process of data loading.

Develop relational databases

Ensure data integrity

Manage user access and permissions by adding and removing users as required

Maintain the database using different utilities. This includes using like pg_ctl and psql.

• Senior position with 5 years of Experience supporting Postgres in an enterprise environment.
  
• We need the person to be an infrastructure DBA not a developer.
  Infrastructure DBA s maintain the system, help optimize, ensure backups, DR processes, etc. They do not write any code like a developer.
• Supporting Postgres in an large scale environment 10 TB databases.
• Knowledge of management tools necessary to support and monitor the environment.
• Knowledge of how Postgres operates on Red Hat Linux to most effectively configure the system for performance
• All should be 5 years experience
• Knowledge of other database technologies would be a huge plus (MSSQL and MySQL).