Home Online Database Administrator

Home Online Database Administrator

Database Administrator

Full time at StoneX Group Inc. in Online
Posted on May 1, 2024

Job details

Overview A Database Administrator is a highly motivated individual responsible for implementing enhancements to all aspects of the current database architecture. Similarly, they will need to ensure that all database systems are high performing and highly available at all times Responsibilities

  • 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 reported
Qualifications Job Requirements:
  • 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
Nice to have
  • 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

Apply safely

To stay safe in your job search, information on common scams and to get free expert advice, we recommend that you visit SAFERjobs, a non-profit, joint industry and law enforcement organization working to combat job scams.

Share this job
Improve your chance to get this job. Do an online course on SQL Server starting now. Claim $10 promo towards online courses. See all courses
See All Database Jobs
Feedback Feedback