The database administrator (DBA) works as part of a team responsible for the acquisition and storage of financial reference and high-frequency tick data. The successful applicant will be expected to provide technical expertise and support for all database clients. The DBA is responsible for developing, testing, and releasing production updates to our database and associated infrastructure. This will include a wide range of activities ranging from maximizing uptime, data access support, performance tuning, and change management, as well as troubleshooting issues reported by internal customers.
- Designing and improving the database architecture
- Maintaining the existing database systems and handling day-to-day requests from internal customers
- Providing expert guidance and SQL knowledge to developers when they are
designing data models and data access layers
- Monitoring and analyzing daily operations
- Suggesting and implementing improvements
- Planning and performing required backups and migrations
- Actively taking part in building a robust DataOps process
- Building and maintaining documentation on our data environment
- Working with the existing Data team staff to manage and providing after-hours support for critical core business processes that interface with the database
- Post-secondary education in a technical discipline preferred
- 5+ years in a database administrator role with MS SQL Server
- Experience with managing Apache Kafka clusters
- Good interpersonal skills.
- Ability to work independently and within a team
- Excellent English communication skills that facilitate teamwork and interaction with colleagues including strong stakeholder engagement
- Good organizational skills
- A strong drive for results and continual improvement
- Experience with temporal databases would be an asset
- Some degree of software development knowledge in C# and/or Python
- Domain knowledge of finance or trading would also be a plus
- Reliable computer equipment and internet connection for remote work.
- Ability to attend virtual meetings in a quiet, distraction-free environment.
- Availability for a minimum of five hours per day that overlap with standard (9-5) business hours in the Eastern Time Zone.
- Flexibility and responsiveness when dealing with issues outside of normal working hours.
- Occasional business travel to the Bahamas. The candidate should expect to spend four weeks per year in the Bahamas in a typical year.