Database Administrator - Bengaluru, India - StoneX

Description

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 teamTake 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 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 toDesigning and building high performance Always On SolutionsWhen 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 businessMaintain a high level of conduct, ethical standards and valuesWork to identify risks and enhance control across the businessReport control weaknesses, illegal, suspicious or unusual activityMaintain an appropriate level of competence through ongoing training, making requests for updates or development as requiredEnsuring 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 ServerExperience of SQL2016 and aboveMaintaining high availability of all databases using AGs and SQL ClusteringDatabase design, build, tuning and monitoring in a high transactional organizationExperience 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 issuesHighly proficient in T-SQL, writing complex stored proceduresNice to haveCloud exposure (Azure, Databricks, Datafactory), certification would be beneficialExperience of administering Open Source Databases such as MongoDB, Postgres and MariaDB or a willingness to learn these DB technologiesExperience of working within Financial Services organizationExperience of working in an Agile/SCRUM environmentMicrosoft SQL Server MCITP/MCA level certificationKnowledge and experience of current 3rd party SQL Server tools (eg Solarwinds, Redgate)Coding skills (PowerShell, C#, Python) to automate tasks and interact with APIsAutomation and Orchestration tools (Jenkines, Ansible, GIT, TeamCity, Azure Devops)Data Virtualisation and Protection Tooling experience, preferably Delphix & Delphix Masking