Sr. Dba

hace 2 semanas


En remoto, España Solera A tiempo completo

**Job Spec/Qualifications**:

- Experience in large Postgres environments (6+ years preferred)
- Excellent communication and collaboration skills, excellent organizational skills, proven ability to prioritize multiple activities and objectives to thrive in a rapidly changing environment
- Ability to write effective technical documentation with attention to detail and accuracy
- Familiarity SQL Monitoring and Alerting Management systems
- In-depth knowledge of Postgres HA (Stream, Clusters)
- Project Management skills
- Ability to manage maintain ETL & DW processes
- On-call troubleshooting within a 24/7 production environment and providing escalation support as necessary
- Expert knowledge of Postgres 10 and up
- Ability to communicate clearly and effectively with various departments such as Engineering, IT Infrastructure, Project Management, etc...
- Solid experience with Postgres in Kubernetes, VMware platforms
- Agile Methodology familiarity
- Experience using Bash, Python, Perl scripting techniques to manage a large environment
- In-depth Windows operating system knowledge
- Attend training conferences and sessions that may require travel
- While on-call be available by phone 247 and be able to get online immediately should an outage occur

**Level of the position might be aligned with the years of experience requested**

**Soft skills**:Diplomatic, good communication skills, understands accountability.

**Must**:Good level of English, Opensource with PostgreSQL with Linux experience, PGbackrest, Operational work, Working on call. Automation skills (Ansible). Monitoring tools. Analize performance issues. Set up environments, restore databases, check up if backups are okay.

**Desirable**:knowledge of other database skills, Jenkins, working with incidents.

**Job Duties / Responsibilities**:

- Ensure production Postgres maintain the company's requirements for HADR, Security, and RPORTO
- Provide on-call support (as part of a rotation) for production alerts or issues both during and outside normal working hours
- Provide support during maintenance windows or deployment/release activities
- Join war-room calls to triage and troubleshoot outages as they occur, including after-hours and weekends
- Build and improve automation around configuring and administering Postgres
- Optimize performance of Postgres and determine the most effective ways to increase performance including hardware purchases, server configuration changes, or index/query changes
- Continuous evaluation and implementation of proactive measures to improve performance and stability of Postgres
- Create and maintain procedural and technical documentation
- Collaborate with other teams in enterprise level projects and provide support guidance as needed
- Lead assigned quarterly projects from initial concept and drive to successful completion
- Identify technical developmental opportunities and provide guidance to Mid and Junior Level DBA team members

Tipo de puesto: Jornada completa

Salario: 40.217,34€-50.903,80€ al año

Beneficios:

- Seguro dental
- Seguro de vida
- Seguro médico privado
- Ticket restaurante

Horario:

- De lunes a viernes

Tipos de compensaciones complementarias:

- Bonus anual

Ubicación del trabajo: Remote



  • En remoto, España Solera A tiempo completo

    Who We Are The Role This position is responsible for acting as a primary technical resource for the support and administration of MySQL or Postgres in both large-scale production and development environments across multiple products. This position continually evaluates the entire MySQL or Postgres topology to identify and create plans to address...