Key skills
AWSOraclePostgresSQLShellCloudWatchPostgreSQLPerformance Optimization
About this role
Role Overview
- Monitors and reviews database performance parameters
- Generates performance reports
- Works on multiple concurrent projects, proposing database solutions
- Performs and reviews performance optimizations and execution plans
- Recommends improvements to environment management and performance in mission-critical, high-availability systems
- Analyzes database performance indicators
- Optimizes performance of relational and non-relational databases
- Troubleshoots relational and non-relational databases
- Performs query performance optimization
Requirements
- Experience analyzing wait events
- Experience analyzing query execution plans
- Experience analyzing performance using AWS Database Performance Insights
- Experience analyzing performance of relational databases
- Experience with database instrumentation on AWS
- Experience with PostgreSQL (performance analysis, development of database objects and queries)
- Experience analyzing operating system performance metrics
- Experience with monitoring using AWS CloudWatch
- Experience with SQL and PL/SQL
- Knowledge of shell scripting and development of infrastructure scripts
- Knowledge of backup strategies
- Knowledge of Oracle Database
Tech Stack
- AWS
- Oracle
- Postgres
- SQL
Benefits
- Bradesco Health Plan (30% co-payment)
- Bradesco Dental Plan (no employee contribution)
- Life Insurance
- Wellhub (Gympass)
- Childcare allowance
- Allowance for dependents with special needs
- Payroll-deductible loan
- Private pension plan
- Pet care plan
- SESC benefits
- Telemedicine (Conexa)
- Expense allowance
- Meal and Food Allowance
- Multi-benefits card
- Medical plan upgrade
- Extended maternity and paternity leave
- Pregnancy support program
- Newborn gift basket and the book "Acontecia quando eu nascia"
- Professional development: courses available through the internal university
- 100% remote or hybrid work, depending on project requirements.