Database Specialist
Role details
Job location
Tech stack
Job description
optimize PostgreSQL based database/clusters, including installation, configuration, backup and recovery, performance tuning, and security management. * Troubleshoot and resolve infrastructure and database-related issues in a timely manner, ensuring minimal impact on production systems. * Monitor system performance, availability, and reliability, and proactively identify and address issues to ensure optimal uptime and performance. * Collaborate with development teams to understand application requirements and optimize database schema and queries for performance and scalability. * Collaborate with business stakeholders, attending export and transformation of data attending management needs in a reliable and maintainable way. * Integrate in Platform Team, participating in the rest of general system administration tasks and on call shifts. Overview: * First point of contact for data-related requests from internal customers: * Database structure changes analysis and execution * Data extraction for reporting/business intelligence * Logic implementation in stored procedures, views and data extraction queries * Database architecture definition, deployment and operation: * Resilience of database services; definition and test of DRPs, backup policies and restore procedures * Availability and performance of database service; scaling and migration of services * Monitoring and troubleshooting database performance issues, getting to the root cause of anomalies in the database response time/availability * Confidentiality: security, patching, authentication, authorization and accounting * Technologies in use: Postgres and MSSQL in AWS Cloud * Automation of workloads: definition and maintenance of pipelines; scripting knowledge * System administration skills: general knowledge about networking, security, operating systems and systems engineering; integration in on call shifts for Platform monitorization and reaction to critical issues Qualifications/skills: *
Requirements
Bachelor's degree, or relevant professional experience, in Computer Science, Engineering, or related field. * Proven experience as DBA, with a minimum of 5 years experience, ideally in Cloud environments. * Proficiency in database administration, ideally with PostgreSQL, including installation, configuration, monitoring, performance tuning, backup and recovery. * Familiarity with database security best practices and tools for encryption, access control, and auditing. * Excellent analytical and problem-solving skills, with a keen attention to detail. * Strong communication and collaboration skills, with the ability to work effectively in a cross-functional, full remote, team environment. * Valuable experience with infrastructure as code (IaC) tools such as Terraform, Ansible, or CloudFormation. * Valuable experience with ETL jobs, data ware house solutions and BI tools and observability stacks like Prometheus/Graphana and ELK. * Valuable proficiency in cloud platforms, particularly AWS. * Relevant general networking and systems knowledge and experience. * Valuable Scripting skills in languages such as Python, Bash, or PowerShell..