Senior DBA Analyst (PostgreSQL)

🕒 April 15

Apply Now

Find Similar Remote Jobs

Receive Emails For Remote Jobs

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Upload Resume

INFOX Tecnologia da Informação

WebsiteLinkedInAll Job Openings

11 - 50 employees

Founded 1986

🏛️ Government

🏢 Enterprise

🤝 B2B

Government • Enterprise • B2B

INFOX Tecnologia da Informação is a technology company specializing in delivering digital transformation solutions for the Judiciary and other legal/government institutions. It provides software and services designed to optimize judicial processes, improve efficiency, accessibility, and security across the judicial ecosystem. The company focuses on enterprise-grade, specialized IT solutions for public sector clients and organizations involved in legal administration.

📋 Description

• PostgreSQL Database Administration: Installation and Configuration: Perform installation, configuration and upgrades of PostgreSQL servers across different environments (on-premises, cloud). • High Availability: Create hot-standby replicas and promote replicas. • Capacity Management: Monitor disk usage and other resources; plan and implement scalability strategies to ensure adequate database capacity. • Documentation: Create and maintain detailed technical documentation for database configuration, architecture and procedures. • Upgrades and Migrations: Plan and execute PostgreSQL upgrades and migrate data between different PostgreSQL versions. • SQL Development and Queries: Write and optimize complex SQL queries. • Create and maintain stored procedures, functions and triggers. • Execute SQL scripts (DDL and DML). • Database Modeling and Design: Design database schemas. • Normalize and denormalize data as appropriate. • Implement indexes and foreign keys. • Performance Tuning and Troubleshooting: Identify and resolve performance issues. • Analyze and optimize slow queries. • Investigate incidents (troubleshooting). • Analyze performance, tune the DBMS or recommend improvements to application maintenance teams. • Monitor server resources and tune the operating system for PostgreSQL. • Backup and Data Recovery: Design and implement backup strategies. • Plan disaster recovery procedures. • Experience with tools such as pg_dump and pg_basebackup. • Monitor regular routines (backups, VACUUM, restore tests). • Database Security: Implement and maintain access security policies, managing users, roles and permissions. • Audit access and activity logs. • Complementary Tools and Technologies: Knowledge of PostgreSQL log analysis tools such as pgBadger. • Familiarity with monitoring tools such as Zabbix or Grafana. • Experience with Linux operating systems, especially for PostgreSQL optimization. • Scripting in Bash, Python or other relevant languages for automating administrative tasks. • Experience with high-availability and disaster recovery environments (HA/DR). • Knowledge of clustering and replication technologies such as Barman, Pgpool or PgBouncer.

🎯 Requirements

• Bachelor’s degree in Computer Science, Computer Engineering, Information Systems or related fields. • Minimum 3 to 5 years of experience in database administration, with at least 2 years focused on PostgreSQL. • Hands-on experience in production environments with high availability and disaster recovery. • Proven track record implementing backup and data recovery strategies. • Experience in PostgreSQL performance optimization and tuning. • Experience developing complex SQL queries and PL/pgSQL scripts. • Experience with PostgreSQL migrations and version upgrades. • Experience with monitoring and observability tools such as Prometheus, Grafana, Zabbix and the ELK Stack to ensure visibility and rapid response in IT environments. • Application of IT service management best practices, including frameworks such as ITIL, to optimize processes, reduce risks and increase operational efficiency.

🏖️ Benefits

• Meal voucher (food or meal card) to support balanced meals. • Group Health Plan (Bradesco) to support your and your family's well-being. • Dental plan to keep you smiling. • Group Life Insurance. • Transportation voucher for in-office days. • Partnership with SESC.