Database Administrator
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 executionData extraction for reporting/business
Requirements
intelligenceLogic implementation in stored procedures, views and data extraction queriesDatabase architecture definition, deployment and operation:Resilience of database services; definition and test of DRPs, backup policies and restore proceduresAvailability and performance of database service; scaling and migration of servicesMonitoring and troubleshooting database performance issues, getting to the root cause of anomalies in the database response time/availabilityConfidentiality: security, patching, authentication, authorization and accountingTechnologies in use: Postgres and MSSQL in AWS CloudAutomation of workloads: definition and maintenance of pipelines; scripting knowledgeSystem administration skills: general knowledge about networking, security, operating systems and systems engineering; integration in on call shifts for Platform monitorization and reaction to critical issuesQualifications/skills: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..