Senior SQL Server Database Administrator - FARFETCH

Location
PT Porto
Posted
29 Sep 2020
Closes
30 Mar 2021
Ref
e1fe4104-ca49-44ee-829b-5f2c765b3591
Function
Technology
Hours
Full Time
FARFETCH exists for the love of fashion. Our mission is to be the global platform for luxury fashion, connecting creators, curators and consumers.

We're a positive platform for good, bringing together an incredible creative community made up by our people, our partners and our customers. This community is at the heart of our business success. We welcome differences, empower individuality and celebrate diverse skills and perspectives, creating an inclusive environment for everyone. We are FARFETCH for All.

TECHNOLOGY

We're on a mission to build the technology that powers the global platform for luxury fashion. We operate a modular end-to-end technology platform purpose-built to connect the luxury fashion ecosystem worldwide, addressing complex challenges and enjoying it. We're empowered to break traditions and revolutionise, with the freedom and autonomy to make a difference for our customers all over the world.

PORTO

Our Porto office is located in Portugal's vibrant second city, known for its history and its creative yet cosy environment. From Account Management to Technology and Product, whatever your skills are, you'll find your fit here. You can have an informal meeting in the treehouse or play the piano in your lunch break!

The role

We are looking for an Infrastructure Database Engineer with a DevOps mindset obsessed about automation, scalability, performance and infrastructure reliability to join our Database team. As part of this team, you will be responsible to guarantee database stability, performance and security. We maintain more than 700 VMs, divided into more than 50 clusters for SQL Server, Cassandra and MongoDB.

What you'll do

    • Support all areas of the enterprise Microsoft SQL database environment, ensuring all databases run at optimal performance.
    • Work closely with the development team to plan new applications and maintain current ones.
    • Perform research into database performance issues and come up with solutions to address those concerns.
    • Owning, tracking and resolving database-related incidents and service requests within SLAs.
    • Perform auditing, monitoring, capacity management and security patching of our database.
    • Manage the security and disaster recovery aspects of databases and platforms.


Who you are

    • Graduate in Computer Science or another technical discipline, or related practical experience.
    • You have more than 5 years of experience in database development and production support in SQL Server.
    • You have a solid knowledge of Microsoft SQL Server 2016+.
    • Good experience with SQL Server Always On, Windows Server Failover Clustering and Transactional Replication.
    • You have extensive experience writing and improving SQL Server T-SQL queries.
    • You have a strong knowledge of backups, restores, recovery models, database shrink operations and DBCC commands.
    • You have troubleshooting experience in SQL Server including performance (query tuning and index optimization), blocking and deadlocking issues, High Availability and Disaster recovery issues, log analysis.
    • Experienced with the following technologies will be considered a plus:
    • Cassandra, MongoDB, PostgreSQL, Azure SQL Databases.
    • Cloud (GCP/AWS/Azure) and Linux.
    • Python, PowerShell, Bash, SaltStack.
    • Proficient in English - written and verbal communication skills.
    • Strong team player with the ability to work collaboratively and independently.


REWARDS & BENEFITS

    • Health insurance for the whole family, flexible working environment and well-being support and tools
    • Extra days off, sabbatical program and days for you to give back for the community
    • Training opportunities and free access to Udemy
    • Flexible benefits program
    • FARFETCH Equity plan


EQUAL OPPORTUNITIES STATEMENT

    • FARFETCH is an equal opportunities employer ensuring that all applicants are treated equally and fairly throughout our recruitment process. We are determined that no applicant experiences discrimination on the basis of sex, race, ethnicity, religion or belief, disability, age, gender identity, ancestry, sexual orientation, veteran status, marriage and civil partnership, pregnancy and maternity, or any other basis prohibited by applicable law. We continue to build our consciously inclusive culture as part of our Positively FARFETCH strategy throughout our business, partnerships and communities.




We are looking for an Infrastructure Database Engineer with a DevOps mindset obsessed about automation, scalability, performance and infrastructure reliability to join our Database team.${description2}

Similar jobs

Similar jobs