Senior Database Developer - ( Closing date 20-October 2026)

People (Professional Employers Pvt Ltd) · Islamabad, Pakistan

Position Name: Senior Database Developer
Contract Duration: 01 Year (Extendable)
Duty Station: Islamabad
Number of Position:01

Job Overview:

We are seeking a Senior Database Developer with strong experience in Oracle Exadata, SQL, PL/SQL, database design, performance tuning, ETL/data migration, NoSQL, cloud technologies, reporting, and application support. The role involves developing scalable, secure, and high-performance database solutions and collaborating with applicationand business teams.

Key Responsibilities:

• Design and implement complex database models aligned with business requirements.
• Create and manage reports, tables, indexes, views, partitions, materialized views, and other database objects in Oracle Exadata.
• Analyse execution plans and optimize SQL/database performance through query tuning, indexing, partitioning, and resource optimization .
• Develop and manage ETL, data migration, validation, cleansing, reconciliation, and integration processes using Oracle, MySQL, Oracle Goldengate, and related tools.
• Design and maintain data replication and synchronization across systems with minimal downtime.
• Support integration between relational databases, NoSQL databases, APIs, data warehouses, and cloud platforms .
• Design and support NoSQL databases such as MongoDB, Cassandra, DynamoDB, or Redis , including data modelling, indexing, partitioning, replication, and performance tuning would be a plus.
• Support cloud and hybrid-cloud database environments using OCI, AWS, Azure, or GCP.
• Support database migration, modernization, backup, disaster recovery, security, and high-availability initiatives in on premises & cloud environments.
• Create and optimize dashboards, reports, and analytical queries , providing support for dashboard infrastructure and performance.
• Collaborate with application teams on development, integration, testing, deployment, and production support .
• Perform unit, integration, regression, performance, and data-validation testing.

• Design databases with appropriate security, access control, data integrity, and protection mechanisms .
• Provide technical support, mentoring, and knowledge sharing to team members.
• Support payment-related systems and financial institution integrations where required.
• Support PMU and WFP Nutrition teams with reports, data analysis, dashboards, and capacity building .
• Prepare and maintain technical documentation , including database architecture, data models, ETL processes, technical specifications, and operational procedures.
• Provide technical evidence and support for audit activities & reconciliation.
• Troubleshoot database, application, integration, and performance issues in production environments.
• Create/Manage dashboard data models, power BI and tableau.
• Perform database administration and production support , including health and performance monitoring, user/access management, backup and recovery.
• Perform other responsibilities assigned by the Reporting Manager.

Required Skills & Experience:

• 6+ years of Strong hands-on experience with Oracle Database and Exadata , SQL & NOSQL database.
• Advanced SQL and PL/SQL development skills can normalize existing non-normalized databases.
• Experience with complex queries, stored procedures, triggers, functions, cursors, jobs, and schedulers.
• Strong knowledge of database performance tuning, indexing, partitioning, and execution plans .
• Experience with at least one NoSQL database such as MongoDB, Cassandra, DynamoDB, or Redis.
• Experience with cloud platforms , preferably OCI, AWS, Azure, or GCP.

• Experience with dashboards, reporting, and data analytics using Power BI, tableau and any other tool.
• Strong troubleshooting, documentation, communication, and team-collaboration skills.

Education & Experience:

• Bachelor's/master's degree in computer science, IT, Engineering, Data Management , or a related field.
• Relevant experience in enterprise database development , preferably with Oracle Exadata and large-scale data environments.