Design and develop database solutions including schemas, tables/collections, indexes, constraints, and data access patterns aligned to application requirements and performance SLAs. Build and maintain SQL and PL/SQL components (queries, views, stored procedures, functions, packages, triggers) and support batch/transactional workloads. Design MongoDB collections and implement efficient query patterns (including aggregation pipelines), indexing strategy, and schema evolution approaches. Perform performance tuning and troubleshooting across platforms (execution plan analysis, indexing/partitioning strategies, query optimization, and workload profiling). Implement data quality checks, reconciliation routines, and controls to ensure accuracy, integrity, and auditability of data. Collaborate with engineering teams on API/data contract design, transaction management, and integration patterns (batch, near-real-time, and service-based). Support production operations: monitoring/alerting, incident response, root cause analysis, and preventive remediation; contribute to runbooks and operational documentation. Follow engineering discipline: code reviews, version control, testing practices, and change/release management
Database (SQL, Oracle, Mongo) in London employer: CSI GLOBAL LTD
As a Microsoft Power Platform CoPilot Architect in London, you will join a dynamic and innovative team that values collaboration and creativity. Our hybrid work culture promotes flexibility while providing ample opportunities for professional growth through hands-on projects and cutting-edge technology. With a focus on employee development and a commitment to leveraging the latest advancements in AI and automation, we offer a rewarding environment where your contributions will make a significant impact.