Database Architect (13-21 yrs)

Job Description :

- Hands on experience is designing customer data model with account hierarchy for E-Commerce, Care, CRM or Billing solution

- Very good knowledge in database technology for both NoSQL DB and SQL DB. Working experience with in-memory DB such as Couchbase would be an advantage.

- Good knowledge in designing, building, and operating in-production Big Data, stream processing, and/or enterprise data integration solutions using Apache Kafka

- Establish scalable implementation of data management framework, platform and tools stack

- Good knowledge to develop, implement and managing BAU operational process for data quality functionality and capability such as Data Quality Statistics, Data Quality Scorecards, Data Quality Analysis and Workflows Design

- Experience utilising Visualisation tools such as Tableau, Power BI or any similar tool

- Experience in replication tools like Couchbase XDCR, Mirroring, Log Shipping, MSSQL

- Experience in Clustering, always on, PG Physical and Logical replication

- Scripting : PowerShell, Python

- Proficient in Document-oriented DB ex. Couchbase DB/MongoDB is a must

Job Responsibilities :

- Data Architect will define and document the data model, data policies, rules, and standards to govern which data is collected, how it is stored, accessed, enriched, integrated, and consumed within the BSS solution.

- Design and implement a scalable, high performance data models and data schema to support data integration, storage and retrieval. Output and maintain ERD covering all BSS components.

- Review existing data documentation for gaps. Define Data Security, Data Retention, Back-up & restoration policies aligning to client guidelines

- Design, build and maintain the database platform to provide stable and secure services.

- Proposing and designing plans for database systems based on various factors such as capacity planning/lifecycle

management.

- Collaborate with other team members and stakeholders.

- Should be able to install, deploy, parameters configuration of Databases on any of the platforms Linux/windows/k8s

- Conduct performance turning, capacity planning and optimisation of database systems to ensure optimal data processing and retrieval