Senior IT Analyst – Databases

Jobtailor; Brasil; Presencial; BRL 90 000 - 150 000; Tempo integral

Resumo da oferta

Jobtailor in Brazil is seeking an experienced Database Administrator to manage and optimize enterprise database systems. You will install, configure, and maintain databases, implement security policies, and develop disaster recovery plans to ensure data availability.

Responsibilities include query optimization, performance tuning, backups, and collaboration with cross-functional teams to meet requirements. Travel occasionally may be needed; strong automation and IaC experience preferred.

Qualificações

• Bachelor's degree in CS/IS or related field.
• Experience in advanced administration of relational databases and migrations.
• Strong SQL, performance tuning, and data security knowledge.

Responsabilidades

• Manage and maintain database servers, including installation, configuration, updates, backup and restore.
• Analyze and optimize queries to improve database performance.
• Implement and maintain data security policies, including access control and auditing to protect sensitive data.
• Develop and test disaster recovery plans to ensure continuous data availability in case of system failures.
• Monitor database integrity, support load testing, identify and resolve performance issues, diagnose and fix system failures.
• Prepare performance reports, metrics and analyses.
• Collaborate with and support projects across other departments to understand requirements and ensure the database meets them appropriately.

Conhecimentos

Advanced SQL

Relational databases

NoSQL databases

Cloud databases

IaC

Monitoring & observability

Scripting (Shell/PowerShell)

Project leadership

Formação académica

Bachelor's degree in CS/IS

Postgraduate specialization

Ferramentas

PostgreSQL

MySQL

SQL Server

MongoDB

DynamoDB

Cassandra

Redis

Terraform

CloudWatch

Datadog

Grafana

Prometheus

Descrição da oferta de emprego

Responsibilities

• Manage and maintain database servers, including installation, configuration, updates, backup and restore.
• Analyze and optimize queries to improve database performance.
• Implement and maintain data security policies, including access control and auditing to protect sensitive data.
• Develop and test disaster recovery plans to ensure continuous data availability in case of system failures.
• Monitor database integrity, support load testing, identify and resolve performance issues, diagnose and fix system failures.
• Prepare performance reports, metrics and analyses.
• Collaborate with and support projects across other departments to understand requirements and ensure the database meets them appropriately.

Requirements

• Bachelor’s degree in Computer Science, Information Systems, or related fields.
• Postgraduate degree or specialization in related areas is a plus.
• Experience in advanced administration of relational databases.
• Experience in system and database migration and integration.
• Strong knowledge of SQL (advanced queries, stored procedures, indexes and performance tuning).
• Experience administering relational databases such as PostgreSQL, MySQL, SQL Server.
• Experience with NoSQL databases such as MongoDB, DynamoDB, Cassandra, Redis.
• Scripting skills (Shell Script, PowerShell).
• Experience with public cloud managed services, such as AWS: Amazon RDS, Aurora, DynamoDB, Redshift; Azure: Azure SQL Database, Cosmos DB, Database for PostgreSQL/MySQL, Azure Synapse Analytics; GCP: Cloud SQL, Cloud Spanner, BigQuery.
• Experience automating and provisioning cloud databases using Infrastructure as Code (IaC).
• Experience using monitoring and observability tools such as CloudWatch, Azure Monitor, Datadog, Grafana, Prometheus.
• Knowledge of database security best practices: encryption, automated backups, disaster recovery.
• Experience creating policies, automations and CI/CD integrations.
• Previous experience leading projects, demonstrating strong communication, decision-making and problem-solving skills.
• Availability for occasional travel.