ICT Architect – Database

Job Detail

  • Job ID 2286
  • Career Level  Others
  • Experience  8-10 Years
  • Industry  Telecommunications
  • Qualifications  Degree Bachelor

Job Description

Responsibilities:

  • Design and architect database solutions based on business requirements, performance considerations, and scalability needs.
  • Define database standards, guidelines, and best practices for data storage, indexing, partitioning, and optimization.
  • Experience with code review and revision control software like Git, Gerrit.
  • Strong experience with Linux OS.
  • Working knowledge of database’s critical underlying services such as Storage/Network/Virtualization.
  • Develop and maintain scripts, stored procedures, functions, triggers, and views to support application functionality and data manipulation.
  • Implement database changes and enhancements in collaboration with development teams, ensuring compatibility and performance.
  • Optimize database queries, indexes, and data structures for improved performance and resource utilization.
  • Install, configure, and upgrade database software and related tools, ensuring compatibility, security, and reliability.
  • Monitor database performance, troubleshoot issues, and implement corrective actions to minimize downtime and ensure optimal performance.
  • Implement backup and recovery strategies to protect data integrity and ensure business continuity in case of system failures or disasters.
  • Implement security measures to safeguard sensitive data and ensure compliance with regulatory requirements.
  • Manage user access and permissions, encryption, and data masking techniques to protect data confidentiality and integrity.
  • Identify and resolve performance bottlenecks, slow queries, and resource contention issues through query optimization, index tuning, and database configuration adjustments.
  • Conduct performance testing and analysis to identify areas for improvement and scalability enhancements.

Qualifications:

  • Proven 8+ years of experience as a Database Developer, Database Architect, or similar role in designing, developing, and managing complex database systems.
  • Proficiency in database technologies such as OpenSearch, MSSQL, MySQL, PostgreSQL, MongoDB, or similar relational and NoSQL databases.
  • Familiarity with database monitoring and performance tuning tools (e.g., SQL Profiler, Oracle Enterprise Manager, pgAdmin, MongoDB Compass).
  • Knowledge of data integration techniques, ETL processes, and data migration strategies.

Required skills