Address
Salary At Barings, we are as invested in our associates as we are in our clients. We recognize those who work diligently for us and reward them for personal and professional integrity, communication skills, distinct competencies and expertise in specific strategies, ability to collaborate as a team member and true dedication to the interests of our clients.
We thank you for your interest in joining the Barings team, and invite you to explore our current employment opportunities.
Job Title: Database Engineer (Azure, SQL)
Location: London
Position description
Barings’ Global Technology and Operations division is seeking an experienced individual to join its Database Administration (DBA) team. As a member of the DBA team, the associate will be part of a fast-paced environment that services developers and application support teams from around the globe. The associate will be responsible for working with these application teams to help with coding standards, performance tuning and implement changes to the data tier of our business applications.
Key responsibilities and accountabilities
- Day to day support of Barings’ database environment. This will include the implementation of change requests and work orders through testing and into production environments.
- Work with the development teams to ensure their adherence to coding standards and help with performance tuning and troubleshooting.
- Support of Business Intelligence services such as Reporting Services, Integration Services and Analytic Services.
- Monitoring the availability of the Barings database environments to ensure uptime SLAs are being met.
- Continuously monitoring of Barings database environment and providing database performance tuning as appropriate.
- Provide 3rd level technical support for all components of the Barings database environment. This will include some off-hours work to support Barings offices located in other geographic areas. This will also include participation in an on-call rotation as well to support overnight batch processing.
- The design, implementation, and documentation of a disaster recovery solution for the SQL server environment to ensure the successful and rapid recovery of all applications.
- Adhere to, and enforce, change control processes throughout the application deployment cycle.
- Adhere to and apply security standards across the Barings database environment
- Work with developers and application support teams on the creation and implementation of new databases, or modifications to existing ones.
- Day to Day support of Barings database environments
Goals
- The associate will participate in the day-to-day operations, maintenance, and support of the Barings database environments (on prem/cloud) as well as assisting with strategic projects.
Knowledge, skills and abilities
- Experience working in environments that require strict adherence to change control policies
- Experience using the SQL Client Tools for administering Microsoft SQL 2016 and above, or newer, databases
- Experience working in a fast-paced development environment
- Experience working with developers to ensure coding standards and helping with performance tuning and troubleshooting SQL code is highly desirable
- Good knowledge and understanding of TSQL queries, Stored Procedures, Views and Functions is required
- Experience conducting SQL code reviews and making recommendations for tuning and optimization
- Experience with creating and testing Backup and Recovery processes for Microsoft SQL environments
- Experience implementing high availability options such as Microsoft SQL Server Clustering, Replication, Mirroring and Always-On
- Experience with Microsoft Windows Server 2016 and above
- With a focus on time-to-market the associate must have time-management and organization skills to prioritize effectively and manage information flow in order to meet deadlines
- Experience managing Azure database environments is a must have.
- Azure Data factory ETL processing
- Azure Synapse Data Warehouse
- Azure Security management
- Azure SQL Backup and Recovery management
- Azure Databricks
- Azure SQL/NoSQL experience
- Performance and Tuning
- Cost Management
Preferred Skills
- Microsoft PowerShell experience is a required.
- Experience automating SQL routines is desirable
- Experience implementing CI\CD practices to optimize SQL routines a plus
- Experience managing and supporting ADF pipelines in Azure a plus
- Experience managing Accounts and Workspace Security in Azure Databricks will be a plus·
- Experience managing Catalogs, Clusters, and SQL code changes in Azure Databricks will be a plus
- Experience working in environments that require strict adherence to change control policies
Education and experience
- Strong experience of development and administration experience with Microsoft SQL Server 2016 or newer edition
- MS and Azure certifications required
Support hours
UK shift - TBD
#LI-JB1
Barings is an Equal Employment Opportunity employer; Minority/Female/Age/Sexual Orientation/Gender Identity/Individual with Disability/Protected Veteran. We welcome all persons to apply.
