Database Engineer (12 Month FTC) Job ID 201751 Posted 16-Jan-2025 Service line GWS Segment Role type Full-time Areas of Interest Facilities Management Location(s) London - England - United Kingdom of Great Britain and Northern Ireland **Role Overview** We are seeking an experienced Cloud Engineer to support and further develop our existing Microsoft Azure cloud instance. The role involves overseeing SQL database management, developing APIs to facilitate seamless data integration with our client’s data warehouse, and ensuring optimal performance and security of cloud resources. The ideal candidate will leverage their expertise in Azure and SQL while also benefiting from familiarity with the Microsoft Power Platform to enhance application development and data analytics capabilities. They will need to work closely with our client, our Account Global, Regional teams across all service lines, and the CBRE platform specialists. **Responsibilities** + Develop, test & deploy APIs within Azure to facilitate the feed of data to our client’s data warehouse. + APIs must integrate with existing cloud resources and databases. + Ensuring API security, documenting API endpoints and their usage. + Optimize performance and cloud security of the Azure instance. + Ensuring compliance with CBRE cloud security policies. + Using your knowledge of the latest Azure features and trends, ensure best practices are followed. + In conjunction with the Snr Data Analyst, administer and monitor all Azure services and functions, including management of our Azure SQL database. + Optimizing database performance; perfecting queries and indexes to ensure high availability and efficiency. + Ensuring all database objects adhere to established naming conventions and standards, as well as ensuring table designs and structures are optimized for performance and scalability. + Maintaining accurate documentation of database architectures, configurations, and procedures. + Optimize and perfect our automated data ingestion solution using Azure Data Factory to cleanse, transform and normalize data. + Includes the use of Microsoft Power Automate for the transfer of data between environments. + Support our Low Code No Code Engineer with the integration and use of Azure Services with Microsoft Power Apps. + Training, guidance, and best practise solutions to be provided. + Tailoring the existing SQL database to support the hosting of LCNC apps and optimizing app performance. + Collaborate with our BI Analyst and provide technical support in the development of data visualisations and dashboards that integrate with our Azure SQL database. + Understand data requirements and develop new ingestions to the database for additional data sources where required. + Ensuring data quality and integrity during data ingestion and transformation processes. CBRE GWS CBRE Global Workplace Solutions (GWS) works with clients to make real estate a meaningful contributor to organizational productivity and performance. Our account management model is at the heart of our client-centric approach to delivering integrated real estate solutions. Each client is entrusted with a dedicated leader and is supported by regional and global resources, leveraging the industry's most robust platform. CBRE GWS delivers consistent, measurably superior outcomes for our clients at every stage of the lifecycle, and across industries and geographies. Find out more (https://www.cbre.com/real-estate-services/directory/global-workplace-solutions) CBRE, Inc. is an Equal Opportunity and Affirmative Action Employer (Women/Minorities/Persons with Disabilities/US Veterans)