Senior Application Data Architect

Sword Group; Dubai; On-site; AED 240,000 - 420,000; Full time

Job summary

Sword Group in the United Arab Emirates seeks an experienced Application Database Designer to design, implement, and optimize database architectures for enterprise software. You will translate business requirements into robust data models and schemas, ensuring performance, scalability, and data integrity across PostgreSQL, MSSQL, Oracle, and Redis.

Collaborating with architects, DBAs, and developers, you will lead data migrations, enforce security controls, and drive modernization from on-prem

Qualifications

• Bachelor's degree in Computer Science, Information Technology, or related field.
• 10+ years of hands-on experience as a Database Designer with increasing responsibilities.
• Expert-level knowledge of Microsoft SQL Server, plus strong understanding of at least one other major RDBMS (Oracle, PostgreSQL, MySQL).
• Experience with backup/recovery, HA/DR design, and replication strategies.
• Deep understanding of database security, access control, and compliance best practices.
• Ability to manage complex databases with multiple integrations and high transaction volume.
• Excellent communication and leadership skills with capability to mentor/lead technical teams.

Responsibilities

• Design, implement, and optimize database architectures for software applications.
• Translate business requirements into logical and physical data models and define tables, relationships, constraints, and indexes.
• Collaborate with solution architects, DBAs, and developers to create scalable database structures.
• Create logical and physical DDL for system enhancements and migrations.
• Experience with ETL processes and data integration (webMethods) and performance tuning.
• Support migration from on-premise to cloud or hybrid environments and ensure governance.

Skills

Data modelling

Schema design

Normalization

Indexing

Query optimization

PostgreSQL

MSSQL

Oracle

Redis

ETL

webMethods

Cloud

RDBMS

Education

Bachelor's degree in Computer Science or related

Tools

SQL Server

Oracle

PostgreSQL

MySQL

Job description

Sword Group in the United Arab Emirates seeks an experienced Application Database Designer to design, implement, and optimize database architectures for enterprise software. You will translate business requirements into robust data models and schemas, ensuring performance, scalability, and data integrity across PostgreSQL, MSSQL, Oracle, and Redis.

Collaborating with architects, DBAs, and developers, you will lead data migrations, enforce security controls, and drive modernization from on-prem