Senior Relacionamento Analyst
Insight Value
Mid-level DBA Analyst, PostgreSQL
INFOX Tecnologia da Informação
full-time
Posted on:
Location Type: Hybrid
Location: São Paulo • 🇧🇷 Brazil
Visit company websiteJob Level
Mid-LevelSenior
Tech Stack
GrafanaPostgresPrometheusSQL
About the role
- PostgreSQL Database Administration: installation and configuration.
- High Availability: create and hot-standby replica.
- Capacity Management: monitor disk space usage.
- Documentation: create and maintain detailed technical documentation.
- Upgrades and Migrations: plan and execute PostgreSQL upgrades.
- SQL Development and Queries: write and optimize complex SQL queries.
- Database Modeling and Design: design database schemas.
- Performance Tuning and Troubleshooting: identify and resolve performance issues.
- Backup and Data Recovery: design and execute backup strategies.
- Database Security: implement and maintain access security policies.
Requirements
- Bachelor’s degree in Computer Science, Computer Engineering, Information Systems, or a related field;
- 3 to 5 years of experience in database administration, with at least 2 years focused on PostgreSQL;
- Hands-on experience in production high-availability environments 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 version migrations and upgrades;
- Experience with monitoring and observability tools such as Prometheus, Grafana, Zabbix, and the ELK Stack;
- Application of IT service management best practices, including frameworks like ITIL.
Benefits
- Meal or Food Voucher to support balanced meals.
- Group Bradesco Health Plan to support the well-being of you and your family.
- Dental Plan to keep your smile healthy.
- Group Life Insurance.
- Transportation Voucher for on-site office commutes.
- Corporate partnership with SESC.
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard skills
PostgreSQL Database AdministrationHigh AvailabilityCapacity ManagementSQL DevelopmentDatabase ModelingPerformance TuningBackup and Data RecoveryDatabase SecurityPL/pgSQLDatabase Migration
