Senior Database Administrator

Description

Job Summary: The professional will plan, design, and implement robust database solutions, ensuring high availability and security, while optimizing and automating processes. Key Highlights: 1. Extensive experience in database optimization and tuning 2. Expertise in high availability and disaster recovery 3. Collaboration with development and infrastructure teams Description: What we expect from you: * Bachelor's degree in Database Administration * Databases: Advanced administration of Microsoft SQL Server, Oracle Exadata, PostgreSQL, MySQL, MongoDB, SQL Server Reporting Services (SSRS), and Pentaho. * Performance and Tuning: Extensive experience in tuning, query optimization, indexing, and execution plan analysis. * High Availability & Disaster Recovery: Experience with Always On Availability Groups, Log Shipping, Failover Cluster, Oracle Data Guard, and RAC. * Backup & Restore: Planning and execution of backup, recovery, and Disaster Recovery (DRP) procedures. * Migration and Upgrade Projects: Experience in version migrations, environment refactoring, and adoption of new technologies. * Cloud: Advanced knowledge of cloud-based databases. * Scripting and Automation: Proficiency in PowerShell, T-SQL, PL/SQL, and Shell Script for process and routine automation. * Operating Systems: Experience with Windows Server and Linux for database environment administration. * Soft Skills: Analytical mindset, proactivity, resilience, and strategic vision. Nice-to-have qualifications: * Certifications such as Microsoft (Azure Database Administrator Associate, MCSE: Data Management & Analytics), Oracle (OCP, OCM), PostgreSQL, MySQL, and MongoDB. * Experience with Kubernetes and Docker for containerized database management. * Knowledge of DevOps and Infrastructure-as-Code (Terraform, Ansible, CI/CD for Databases). * Experience in Big Data environments, Data Lakes, and distributed processing (Apache Kafka, Spark, Snowflake). * Experience with monitoring and observability tools (Datadog, Redgate SQL Monitor, etc.). Day-to-day responsibilities: * Plan, design, and implement robust database solutions, ensuring high availability and security. * Define and execute tuning and optimization strategies to ensure maximum database performance and scalability. * Manage backup and restore processes, ensuring efficient disaster recovery policies. * Administer and monitor databases to identify and resolve performance bottlenecks. * Plan and execute migrations and upgrades, ensuring compatibility and security during version transitions. * Automate repetitive tasks and implement proactive monitoring to reduce downtime and operational failures. * Collaborate with development and infrastructure teams to ensure best practices in query modeling and optimization. * Ensure data security by implementing encryption policies, auditing, access controls, and LGPD principles. 2511010202241463001