Database Administration Specialist

We will rely on you to:

Build/Configure PostgreSQL database cluster and replication

Build/Configure Mongo RS and shard

Fine-tune configurations MongoDB and servers for performance improvement.

Configure Barman server for new database cluster

Install PostGIS/ pgAudit and other required extension

Responsible for the monitoring and uptime of all production databases.

Estimate database capacities; develop methods for monitoring database capacity and usage.

Lead efforts to develop and improve procedures for automated monitoring and proactive intervention, reducing any need downtime.

Responsible for regular backups and recovery of databases.

Responsible for regular maintenance on databases (e.g., Vacuum, Reindexing, Archiving).

Responsible for pro-active remediation of database operational problems.

Responsible for Query tuning and preventative maintenance.

Implement best practices for backups, replication, and health checks.

Database hardening implement best practices.

Design and implement DR plans & HA solutions and recommendations.

Work closely with the application team to understand what changes are coming in a build/patch/hotfix, do an impact analysis, fine-tune the queries if any.

Perform other duties as assigned.

Skills and other Requirements Understanding of enterprise application technology architecture, components, databases, networking, and infrastructure as code.

Encryption(TLS 2)

Strong DBA Experience MongoDB and PostgreSQL.

Write efficient queries.

Strong scripting experience - Unix/Shell Scripting, Python

Technical knowledge of Linux & Windows-based platforms

Strong analytical and problem-solving skills

LDAPs configuration for authentication

Experience in providing after hours emergency support

Working on rotational shifts between 6am - 10pm local time, may include Sat/ Sun.

Desired Skills: Hands-on experience in AWS Disaster Recovery and Business continuity PostgreSQL XL.