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