Database Administrator (10-month Contract)
Job Summary
We are Two Circles. We are a Sports & Entertainment Marketing business. We grow audiences and revenues. We do that by knowing fans best. We work with clients to help them understand & influence what their fans are doing the way fans spend their money the events that fans attend the channels fans respond to the content fans watch and more. And we use the understanding this gives us to help our clients grow. Grow their audiences and grow their revenues - both direct to consumer and business to business revenues. Our platforms and services are trusted by over 900 clients globally including the English Premier League Red Bull UEFA VISA the NFL Nike and Amazon. We are almost 1000 people based out of 14 offices and we deliver work for sports and entertainment businesses of all shapes and sizes all over the world.
We are seeking a skilledDatabase Administratorto join our team on a fixed-term contract covering a maternity leave. This role focuses primarily onSQL Server database administration with approximately 30% involvement in DevOps-related tasks. The first stage interviews may be conducted remotely but final interviews are ideally in-person.
Key Responsibilities:
- Manage and support mission-criticalSQL Server environmentsacross Production QA and Development.
- Install configure and maintain enterprise-wide SQL Server instances (2016 and higher).
- PerformWindows Server administration(2016/2019/2022) and manage OS/SQL Server patching via AWS tools (SSMRunCommand).
- Configure and manageSQL ServerAlwaysOnavailability groupsand failover clustering.
- Optimize database performance throughquery optimization index tuning and execution plan analysis.
- Managebackup/restore processesand perform point-in-time recovery.
- Administer database security users roles and permissions includingAWS IAM roles and permissions.
- Develop and maintainSSIS packages and SSRS reports.
- Monitor andrightsizeinfrastructure using tools likeCloudWatch andNewRelic.
- Understand and configure ODBC clients andHAProxyas needed.
- Performcapacity planning forecasting and proactive performance tuning.
- Conductroot cause analysisfor outages and performance issues.
- Automate tasks usingT-SQL scripts SQL Agent jobs and basic PowerShell scripting.
- Troubleshoot connectivity and network issues including TCP/IP DNS resolution and hostname configuration.
- UsePerformance Monitor (Perfmon)to monitor OS-level metrics (CPU memory disk I/O).
- Basic understanding ofWindows Firewall rules VPN access and private vs public network configurations.
- Experience withAWS services(RDS S3 DynamoDB EC2 IAM); Azure experience is a plus.
Required Skills & Experience:
- Strong expertise inSQL Server administrationand performance tuning.
- Hands-on experience withWindows Server environments.
- Knowledge ofDevOps practices and cloud platforms particularly AWS.
- Solid troubleshooting skills acrossdatabasenetwork and server layers.
- Familiarity with monitoring automation and reporting tools.
- Excellent communication skills with the ability to guide less experienced team members.
This is an excellent opportunity for aSQL DBA with DevOps capabilitiesto join a dynamic team and contribute to critical enterprise systems.
Required Experience:
Unclear Seniority
About Company
Two Circles is a data-driven sports agency that helps sports organisations grow direct relationships between sports and fans. We use data to help our clients understand their customers and act on this insight. We help them improve customer experience, increase revenue and enhance thei ... View more