DBA Analyst managing PostgreSQL databases at INFOXER, responsible for database performance, security, and integrity. Working closely with development and infrastructure teams to implement best practices.
Responsibilities
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.
Asset Based Lending Analyst Senior responsible for collateral integrity and loan information for banking clients. Involvement in documentation review, processing advances, and maintaining client relations.
Lighting Analyst I performing duties as assigned to complete lighting system surveys. Supporting design and analysis for lighting retrofit projects with a team.
Lighting Analyst I at ENFRA conducting lighting system surveys and supporting lighting retrofits design. Collaborating with survey teams to analyze site requirements and prepare detailed lighting documentation.
HR Analyst managing personnel administration processes in a modern pharmaceutical support company. Collaborating on payroll, benefits, and employee documentation tasks.
Fraud Analyst developing fraud - related reporting and identifying trends for fraud prevention at Banner Bank. Collaborating with teams to align with regulatory requirements and internal standards.
Senior Analyst managing MRP processes for defense projects within Collins Aerospace's Operations team. Responsible for material planning and ensuring alignment between material position and production schedule.
Designer in aerospace sector developing high complexity mechanical equipment and collaborating with engineering teams. Producing 3 - D models and layout drawings while ensuring compliance with industry standards.
Analista PL Tributário Fiscal ensuring compliance with tax audits and regulations for RD Saúde. Responsible for managing fiscal documentation and supporting internal audits.
External Reporting Sr. Analyst preparing Autodesk's SEC filings including Forms 10Q and 10K. Responsible for financial statement preparation and assisting with regulatory reporting standards.