Administrador de Bases de Datos SQL en una compañia de videojuegos con fama internanional.

Como administrador de bases de datos, te unirás a un equipo de ingeniería enfocado en ofrecer la mejor experiencia posible al cliente asegurando el tiempo de actividad, la escalabilidad y el rendimiento de nuestros productos. Con sistemas que necesitan ser altamente resilientes, de latencia extremadamente baja y escalables a grandes volúmenes, trabajarás con otros administradores de bases de datos, arquitectos y equipos de ingeniería de productos para mantener las cosas óptimas hoy, mientras te enfocas también en el estado futuro a medida que avanzamos hacia un panorama altamente automatizado y dirigido por servicios.

Lo que harás:

• Trabajar dentro de un equipo central de DBA interactuando con un equipo de desarrollo asignado.
• Tareas tradicionales de administración de MS SQL Server que incluyen copias de seguridad, mantenimiento de grupos de disponibilidad, actualizaciones de versión, problemas de conectividad y gestión de infraestructura.
• Optimización preventiva de T-SQL, identificando y afinando consultas de alto consumo mediante un monitoreo exhaustivo del rendimiento de las consultas.
• Particionamiento y gestión del tamaño de las bases de datos.
• Revisión de código T-SQL para un equipo de desarrollo asignado, así como apoyo a los desarrolladores en el diseño eficiente de bases de datos.
• Desarrollo y mantenimiento de estrategias de archivado de datos, extracción e inserción usando T-SQL y/o Azure Data Factory.
• Automatización de código e infraestructura utilizando PowerShell, Terraform y Azure DevOps.
• Migración y creación de servicios de bases de datos gestionados como Azure SQL Database y Azure SQL Managed Instances.
• Participación en una lista de soporte de guardia.

Esencial para el rol:

• Experiencia como administrador de bases de datos de MS SQL Server.
• Experiencia en afinación de rendimiento y optimización de T-SQL.
• Experiencia con bases de datos de alto volumen de transacciones.
• Fuertes habilidades interpersonales y capacidad para trabajar con una amplia gama de interesados hasta el nivel C.
• Un solucionador de problemas natural con excelentes habilidades de organización y priorización.
• Experiencia tomando decisiones en un entorno de alta presión.
• Excelentes habilidades de comunicación verbal y escrita.
• Título universitario o equivalente en términos de conocimientos y experiencia.
• Deseable:
• Experiencia en ingeniería de datos.
• Experiencia en Microsoft Azure.
• Se considera un activo la experiencia con cualquiera de los siguientes: Azure SQL, Azure Data Factory, MongoDB, MySQL, Terraform, Databricks, Azure Data Lake Storage.
• Fecha de inicio: Tan pronto como sea posible
• Horas: 160 horas/mes durante 12 meses
• Idiomas: Inglés (fluidez profesional)
• Modalidad de trabajo: Híbrido - 2 días a la semana en la oficina de Madrid (de lunes a jueves, si es posible).
• Salario: 50,000 - 77,000 anuales, dependiendo de la experiencia

El trabajo es freelance, pero incluye beneficios y facilidades para convertirse en uno.

SQL Database Administrator at a World-Class Gaming Company

As a database administrator, you will join an engineering team focused on delivering the best possible customer experience by ensuring our products' uptime, scalability, and performance. With systems that need to be highly resilient, extremely low latency, and scalable to massive volumes, you will work with other database administrators, architects, and product engineering teams to keep things optimal for today while also focusing on the future state as we move towards a highly automated and service-driven landscape.

What you will do:

• Work within a central DBA team while interacting with an assigned development team.

• Traditional MS SQL Server administration tasks include backups, maintaining availability groups, version upgrades, connectivity issues, and infrastructure management.

• Preventive optimization of T-SQL, identifying and tuning high-consumption queries through comprehensive query performance monitoring.

• Database partitioning and size management.

• Reviewing T-SQL code for an assigned development team, as well as supporting developers in the efficient design of databases.

• Developing and maintaining data archiving strategies, extraction, and insertion using T-SQL and/or Azure Data Factory.

• Automating code and infrastructure using PowerShell, Terraform, and Azure DevOps.

• Migration and creation of managed database services like Azure SQL Database and Azure SQL Managed Instances.

• Participation in an on-call support roster.

• 
  

What is essential for the role:

• Experience as an MS SQL Server database administrator.

• Experience in performance tuning and T-SQL optimization.

• Experience with high-volume transaction databases.

• Strong interpersonal skills and the ability to work with a wide range of stakeholders up to the C-level.

• A natural problem solver with excellent organizational and prioritization skills.

• Experience making decisions in a high-pressure environment.

• Excellent verbal and written communication skills.

• University degree or equivalent in terms of knowledge and experience.

Desirable:

• Data engineering experience.

• Experience in Microsoft Azure.

• Experience with any of the following is considered an asset: Azure SQL, Azure Data Factory, MongoDB, MySQL, Terraform, Databricks, Azure Data Lake Storage.

Start date: As soon as possible
Hours: 160 hours/month for 12 months
Languages: English (professional fluency)
Work mode: Hybrid - 2 days a week in the Madrid office (Monday-Thursday if possible).
Salary: 50,000 - 77,000 annually, depending on experience

The job is freelance, but it includes perks and facilitation to become one.

Senior Frontend Engineer at a World-Class Gaming Company

As a Frontend Software Engineer, you will join a team focused on ensuring that our gaming products are highly resilient, have extremely low latency, and are scalable to massive volumes while providing a top-class customer experience. With a deep understanding of modern architectural and engineering practices that underpin successful distributed transactional solutions, your team will work hand in hand with product leaders to design, build, deliver, and execute our gaming platforms and products.

What you will do:

• Develop and maintain user interface components: Use your expertise in JavaScript frameworks like React and TypeScript to create and manage user interface components that align with project requirements.

What is essential for the role:

• Proven experience integrating web applications: Demonstrate your proficiency in seamlessly integrating web applications using RESTful APIs, showcasing your ability to build strong connections between frontend and backend systems.
• Proven experience building high-performance, responsive web applications: Highlight your track record in developing high-performance web applications with optimal user experience across various devices and screen sizes.
• Proven experience using CSS: Show your skills in using CSS to style web pages, emphasizing your ability to create visually appealing and easy-to-use interfaces.
• Proven experience with JavaScript unit testing: Experience in implementing and maintaining effective unit tests using tools like Jest to ensure code reliability.
• Strong architectural knowledge and experience with patterns: Illustrate your senior-level competence by demonstrating deep knowledge and experience with architectural patterns such as SSG, SSR, Islands, and Streaming SSR.

• Proven experience using a CMS: Work with dynamic content provided by a CMS, such as Strapi or Umbraco.
• Experience in web application hosting: Experience hosting web applications using platforms like Cloudflare or Vercel, demonstrating a holistic understanding of the deployment process.
• Familiarity with package managers: Experience with package managers like PNPM and Yarn to facilitate efficient package management within the development workflow.
• Experience with application performance monitoring (APM): Show the value of experience with APM tools like Kibana and Elastic to monitor and optimize application performance.

Start date: As soon as possible

Hours: 160 hours/month for 12 months
Languages: English (professional fluency)
Work mode: Hybrid - 2 days a week in the Madrid office (Monday-Thursday if possible). Therefore, you require a working VISA to work in Spain 
Salary: 50,000 - 77,000 annually, depending on experience

The job is freelance, but it includes perks and facilitation to become one. We will provide you with an accountant for free to help you with taxes and the rest.

Senior Frontend Engineer at a World-Class Gaming Company

As a Frontend Software Engineer, you will join a team focused on ensuring that our gaming products are highly resilient, have extremely low latency, and are scalable to massive volumes while providing a top-class customer experience. With a deep understanding of modern architectural and engineering practices that underpin successful distributed transactional solutions, your team will work hand in hand with product leaders to design, build, deliver, and execute our gaming platforms and products.

What you will do:

• Develop and maintain user interface components: Use your expertise in JavaScript frameworks like React and TypeScript to create and manage user interface components that align with project requirements.

What is essential for the role:

• Proven experience integrating web applications: Demonstrate your proficiency in seamlessly integrating web applications using RESTful APIs, showcasing your ability to build strong connections between frontend and backend systems.
• Proven experience building high-performance, responsive web applications: Highlight your track record in developing high-performance web applications with optimal user experience across various devices and screen sizes.
• Proven experience using CSS: Show your skills in using CSS to style web pages, emphasizing your ability to create visually appealing and easy-to-use interfaces.
• Proven experience with JavaScript unit testing: Experience in implementing and maintaining effective unit tests using tools like Jest to ensure code reliability.
• Strong architectural knowledge and experience with patterns: Illustrate your senior-level competence by demonstrating deep knowledge and experience with architectural patterns such as SSG, SSR, Islands, and Streaming SSR.

• Proven experience using a CMS: Work with dynamic content provided by a CMS, such as Strapi or Umbraco.
• Experience in web application hosting: Experience hosting web applications using platforms like Cloudflare or Vercel, demonstrating a holistic understanding of the deployment process.
• Familiarity with package managers: Experience with package managers like PNPM and Yarn to facilitate efficient package management within the development workflow.
• Experience with application performance monitoring (APM): Show the value of experience with APM tools like Kibana and Elastic to monitor and optimize application performance.

Start date: As soon as possible

Hours: 160 hours/month for 12 months
Languages: English (professional fluency)
Work mode: Hybrid - 2 days a week in the Madrid office (Monday-Thursday if possible). Therefore, you require a working VISA to work in Spain 
Salary: 50,000 - 77,000 annually, depending on experience

The job is freelance, but it includes perks and facilitation to become one. We will provide you with an accountant for free to help you with taxes and the rest.