DBA Administrator
Role details
Job location
Tech stack
Job description
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. 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
Requirements
deployment and operation: Resilience of database services; definition and test of DRPs, backup policies and restore procedures Availability and performance of database service; Monitoring and troubleshooting database performance issues, getting to the root cause of anomalies in the database response time/availability Postgres and MSSQL in AWS Cloud 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 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. 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..