Department Overview
Database Services team, a vital component of the Application and Infrastructure Support division, plays a crucial role in ensuring the company`s data ecosystem is robust, secure, and optimized for performance. This team, responsible for the backbone of HedgeServ's data landscape, is structured into three key areas: DB Architecture, DB Engineering, and DB Operations (DB Ops).
DB Architecture: The Blueprint for Data Excellence
The DB Architecture team serves as the visionary arm, responsible for designing, planning, and modelling HedgeServ's database systems. Database Design and Modelling: Creating logical and physical database models, ensuring data integrity, efficiency, and scalability. Technology Evaluation and Selection: Researching and recommending appropriate database technologies based on performance, scalability, and cost considerations. Best Practices: Defining and enforcing database standards, naming conventions, and security protocols across the organization. Capacity Planning: Predicting future storage and performance requirements and planning for necessary infrastructure upgrades. Data Governance: Contributing to overall data governance strategies, ensuring data quality, consistency, and compliance with regulatory requirements.
DB Engineering: Building and Maintaining the Data Infrastructure
The DB Engineering team is the hands-on builder, responsible for implementing and maintaining the database infrastructure designed by the architecture team.
Database Installation and Configuration: Setting up and configuring database servers, ensuring optimal performance and security. Performance Tuning: Monitoring database performance and implementing optimizations to improve query speeds, resource utilization, and overall system responsiveness. Backup and Recovery: Implementing and testing backup and recovery strategies to ensure data resilience in case of failures. Security Implementation: Configuring and maintaining database security measures, including user access controls, encryption, and vulnerability patching. Automation and Scripting: Developing scripts and automation tools to streamline database administration tasks and reduce manual errors.
DB Operations (DB Ops): Keeping the Data Flowing 24/7
The DB Ops team provides operational support for database systems, responsible for the continuous operation and maintenance of the database environment.
Incident Management: Responding to and resolving database-related incidents, minimizing downtime and impact on business operations. Monitoring and Alerting: Monitoring database performance and health, identifying and addressing potential issues before they escalate. Change management: Implementing database changes following established procedures, ensuring minimal disruption to users. User Support: Providing technical support to users, troubleshooting database-related issues, and assisting with data access requests. Patching and Upgrades: Applying security patches and upgrades to database servers to maintain a secure and stable environment.
Collaborative achievement:
The success of HedgeServ's Database Services team lies in the constructive collaboration between these three core areas. The DB Architecture team sets the strategic direction, the DB Engineering team builds and maintains the infrastructure, and the DB Ops team ensures its continuous operation.
Job Description
We are seeking a Database Services Senior Engineer with deep knowledge and proven experience of SQL Server, both in administration and development. Knowledge and experience with cloud platforms like AWS, Infrastructure as code and orchestration tools such as Terraform and Ansible, DHW and NoSQL solutions like Snowflake or MongoDB, ITIL and Agile framework would be considered huge advantage.
This role requires you to work on shifts including Sat and Sun