Overview:
Connecting clients to markets and talent to opportunity
With 4,300 employees and over 400,000 retail and institutional clients from more than 80 offices spread across five continents, we're a Fortune-100, Nasdaq-listed provider, connecting clients to the global markets focusing on innovation, human connection, and providing world-class products and services to all types of investors.
Whether you want to forge a career connecting our retail clients to potential trading opportunities, or ingrain yourself in the world of institutional investing, The StoneX Group is made up of four segments that offer endless potential for progression and growth.
Business Segment Overview
Corporate: Engage in a deep variety of business-critical activities that keep our company running efficiently. From strategic marketing and financial management to human resources and operational oversight, you'll have the opportunity to optimize processes and implement game-changing policies.
Responsibilities:
Technology Ecosystem:
Database: SQL
Cloud: Azure
Primary duties will include:
On call cover as a part of a rotation with other members of the team
Take proactive measures to monitor, trend, and tune SQL databases, such as running maintenance jobs (backups, DBCCs, apply indexes/re-indexing, etc.), to meet or exceed baseline stability and performance SLAs on large databases (1 TB+) and large volumes of databases (100+).
Create, implement, and maintain SQL DB Health Checks/Monitoring, and have a demonstrated ability to automate SQL health reporting/event notification, and corrective actions.
Developing best practice standards within the DBA team and working with local and remote development teams to ensure these standards are adhered to
Designing and building high performance Always On Solutions
When performance issues arise, determine the most effective way to increase performance including scaling up or out, server configuration changes, index/query changes, etc.
Identify code defects and enhancements and develop a detailed root cause analysis that can be leveraged by the product management and development teams to improve application availability and decrease the total cost of ownership.
Perform all database management responsibilities in Microsoft Azure for production and non-production workloads.
Adhere to and proactively enhance the firm's compliance with applicable laws, regulations and codes of conduct in all jurisdictions in which the Firm conducts business and which have an impact on its business
Maintain a high level of conduct, ethical standards and values
Work to identify risks and enhance control across the business
Report control weaknesses, illegal, suspicious or unusual activity
Maintain an appropriate level of competence through ongoing training, making requests for updates or development as required
Ensuring the clients are treated fairly by knowing the customer and giving suitable advice where appropriate, providing an appropriate level of service, communicating clearly and fairly and ensuring complaints are reportedQualifications:
To land this role you will need::
A minimum of 2 years administering SQL Server
Experience of SQL2016 and above
Maintaining high availability of all databases using AGs and SQL Clustering
Database design, build, tuning and monitoring in a high transactional organization
Experience working in a 24/7/365 operation.
Strong educational background with a degree preferably in Computer Science or Information Systems.
Ability to work under pressure to solve production issues
Highly proficient in T-SQL, writing complex stored procedures
What makes you stand out:
Cloud exposure (Azure, Databricks, Datafactory), certification would be beneficial
Experience of administering Open Source Databases such as MongoDB, Postgres and MariaDB or a willingness to learn these DB technologies
Experience of working within Financial Services organization
Experience of working in an Agile/SCRUM environment
Microsoft SQL Server MCITP/MCA level certification
Knowledge and experience of current 3rd party SQL Server tools (eg Solarwinds, Redgate)
Coding skills (PowerShell, C#, Python) to automate tasks and interact with APIs
Automation and Orchestration tools (Jenkines, Ansible, GIT, TeamCity, Azure Devops)
Data Virtualisation and Protection Tooling experience, preferably Delphix & Delphix Masking
Working environment:
Hybrid/In-office/Remote
