Position Description **Job Title: Technical Specialist - PostgreSQL** **Location: Bogotá, Colombia** **Education: B.E/B. Tech/ BSc/ Graduation** **Experience: 9+ Years** **Key Skills: Core PostgreSQL 9.6+, AWS RDS/Aurora, Azure.** **Are you a seasoned PostgreSQL Database Administrator? Does working in a multi customer, multi domain environment on global scale motivates you? If yes, this role could be a good fit for you.** **Datavail is seeking a highly skilled, self-motivated, and passionate PostgreSQL DBA to join our PostgreSQL Global Practice. As a PostgreSQL DBA, you will be working on the latest Opensource technologies in the industry. This position is based out of our onshore delivery center in Bogotá, Colombia.** Datavail is one of the largest data-focused services company in North America and provides both professional and managed services and expertise in Database Management, Application Development and Management, Cloud & Infrastructure Management, Packaged Applications and BI/Analytics. **Why should you work at Datavail?**: - **Learn from a vast pool of global PostgreSQL DBAs with over 500 combined years of industry experience.**: - **You would be working with multiple customers in a multi domain environments.**: - **Work would range from On-Prem core PostgreSQL DBs, Azure flexible server, CitusDB, Patroni, Percona, AWS RDS and Aurora.**: - **Your Certifications would be on us.**: - **100 days of working from home (since inception of Datavail).**: - **Future Opportunity for permanent deputation on H1B to work in US.**: - **Leverage the DV Training program to upscale the technical skills.** **Required Skills**: - 9+ years of relevant experience. - PostgreSQL 9.6+ experience required. - Must have strong analytical, verbal, and written communication skills. - Must have experience in PostgreSQL database architecture, logical and physical design, automation, documentation, installs, shell scripting, PL/ SQL programming, catalog navigation, query tuning, system tuning, resource contention analysis, backup, and recovery, standby, replication, etc. - Must have strong knowledge on AWS Cloud and Azure Cloud. - PostgreSQL deployment and implementation support (24*7*365) - Good Knowledge on pgbadger and pg-collector report analysis - Hands on experience on HA Configuration - Must have strong knowledge of Linux/Unix & Windows. - Strong understanding of command line and server administration. - Knowledge of shell scripting (e.g., Bash, Python). - AWS Solutions Architect - Associate level certified (preferred). - AWS Solutions Architect - Professional level certified (preferred). - AWS DB Specialty certified (preferred). **Desired Skills**: - Strong knowledge of DevOps technologies - Strong troubleshooting skills with the ability to identify issues before they become problems - 2-3+ years of deep experience building cloud data solutions - Possess working knowledge of agile development methodologies including DevOps concepts - Experience with cloud SDKs and programmatic access services - Proficient in a relevant programming language for cloud platforms (e.g., Python, Shell,, etc) **Role and Responsibilities**: - 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. - Administration on AWS Cloud (EC2, RDS & Aurora), S3 Backups, Replication. - Administration on Azure Cloud (Single server & Flexible server). - 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, Re-indexing, Archiving). - Responsible for pro-active remediation of database operational problems. - Responsible for Query tuning and preventative maintenance. - Participate in a 24×7 support rotation. - Responsible for the monitoring and uptime of all production databases. - Experience in automation development, shell, python or Golang - Lead efforts to develop and improve procedures for automated monitoring and proactive intervention, reducing any need downtime.