Icodde along with TMT, is looking for the right People to work for a world's leading professional services firm in risk, strategy and people.
We are looking for a
**Database Administration Specialist**
**The job is Hybrid and the offices are located in CDMX.**
**Responsibilities**:
- Build/Configure Postgres database cluster and replication
- 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 PostgreSQL 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.
- Participate in the creation of development, staging, and production database instances, and the migration from one environment to another.
- Responsible for developer SQL code review to ensure queries are optimized and tuned to perform efficiently prior to production release.
- 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
- Participate in a 24×7 support rotations
**Required Skills**:
- 3+ year’s hands-on experience as DBA.
- Encryption (TLS 2)
- ** Strong DBA Experience - **Postgres.**:
- 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