About CodeNinja & Accelerated AI:CodeNinja is a global technology consulting and services company specializing in scalable digital solutions, driving business growth for startups, enterprises, and tech innovators. With a strong presence in Pakistan and international offices, CodeNinja delivers expertise in software development, cloud engineering, and data platforms.
Accelerated AI is CodeNinja’s regional subsidiary in Dubai, UAE, and serves as a strategic hub for AI-powered solutions and digital transformation projects. Accelerated AI partners with innovative businesses in the region, focusing on building data-driven, intelligent systems across industries, including smart cities, automation, and enterprise applications.
The Opportunity:An exciting onsite opportunity in Dubai, the Global Tech Hub, to work with a leading Dubai-based group of businesses through Accelerated AI.
We are seeking an experienced PostgreSQL Developer (4+ years) to join our innovative team and contribute to building high-performance, scalable database systems that support cutting-edge solutions, including smart city applications.
Job Description:As a PostgreSQL Developer, you will be responsible for the design, development, optimization, and administration of PostgreSQL databases. You will work closely with our software development and data engineering teams to build robust data solutions that power innovative smart city platforms and enterprise systems.
This is a full-time, permanent role, based onsite in Dubai, with sponsored relocation and all benefits as per local UAE employment laws
Key Responsibilities: - Database Design & Development: Design, develop, and maintain robust PostgreSQL databases with a focus on scalability, security, and performance optimization.
- Database Migration: Assist in migrating databases from MSSQL to PostgreSQL, ensuring data integrity and minimizing downtime.
- SQL Query Performance: Write and optimize complex SQL queries, windowing functions, and stored procedures for high-volume applications.
- Database Objects: Create and manage DB objects like Tables, Views, Stored Procedures, Functions, Triggers, and Indexes.
- Performance Tuning: Leverage PostgreSQL internal structures and execution plans to improve performance, optimize queries, and troubleshoot bottlenecks.
- Data Modeling: Design efficient database schemas, ensuring proper normalization and indexing practices.
- Scripting & Automation: Develop Unix/Shell scripts to automate database tasks and streamline operational processes.
- Database Administration: Oversee backup, recovery, and maintenance processes; handle database patching and version upgrades.
- Cross-platform Environment: Work within Linux & Windows-based platforms for database deployment and support.
- Collaboration: Work closely with developers, data engineers, and architects to integrate PostgreSQL databases into smart city platforms and enterprise systems.
- Security & Access: Implement role-based access control and security measures to safeguard data.
- Documentation: Prepare and maintain database documentation, including architecture diagrams, procedures, and configurations.
