Database Administrator (DBA)

Job title: Database Administrator (DBA)

Company: CodeNinja


Job description: 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 lawsKey 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.

Requirements

• 4+ years of hands-on experience as a PostgreSQL Developer.
• Proficiency in database design, data modeling, and query optimization.
• Strong knowledge of PostgreSQL internals and windowing functions.
• Experience with database objects creation (e.g., Tables, Stored Procedures, Functions, Triggers).
• Experience with database migration (MSSQL to PostgreSQL) is a plus.
• Solid understanding of enterprise application architecture, networking, and infrastructure as code (IaC).
• Technical expertise in Linux & Windows-based environments.
• Strong Unix/Shell scripting skills for automation.
• Ability to write efficient, high-performance SQL queries.
• Excellent problem-solving and analytical skills.
• Experience working on data-driven or large-scale applications is preferred.

BenefitsBenefits:

• Onsite Opportunity in Dubai – Work in one of the world’s leading tech hubs with exposure to innovative projects.
• Full-time, Permanent Role with long-term career growth potential.
• Sponsored Relocation Package – Support for your move to Dubai.
• Comprehensive Benefits – As per local UAE Employment Laws, including healthcare, paid leaves, and other statutory benefits.
• Exposure to Smart City & AI-driven Projects – Be part of a forward-thinking team shaping the future of smart urban solutions.
• Professional Growth – Work alongside top tech talent, leveraging the latest tools and technologies in the industry.

Why Join Us?

• Be part of CodeNinja’s global team and Accelerated AI’s innovation hub in Dubai.
• Collaborate on cutting-edge projects in smart cities and enterprise solutions.
• Enjoy a dynamic work environment in Dubai’s thriving tech ecosystem.

Apply Now
Ready to build the future with PostgreSQL and cutting-edge smart city solutions?
Join Accelerated AI in Dubai and CodeNinja’s global team – where innovation drives impact!

Expected salary:

Location: Lahore, Punjab

Job date: Thu, 20 Feb 2025 23:02:00 GMT

To help us track our recruitment effort, please indicate in your email/cover letter where (jobsnear.pro) you saw this job posting.Thanks&Good Luck