Senior Database Developer SC-08

People Perfect; Islamabad; On-site; PKR 250,000 - 320,000; Full time

Job summary

People Perfect in Islamabad seeks a Senior Database Developer to design and maintain Oracle Exadata-based databases, perform performance tuning, ETL/data migration, and data integration across on-premises and cloud environments.

You will design complex data models, manage reports and dashboards, ensure security and high availability, and mentor teammates while supporting PMU and WFP Nutrition teams with data-driven insights.

Qualifications

• Requires 6+ years of hands-on Oracle Database/Exadata experience.
• Strong SQL and PL/SQL development skills.
• 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.

Responsibilities

• Design 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 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 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.

Skills

Oracle Exadata

SQL

PL/SQL

Performance tuning

ETL

NoSQL databases

Cloud platforms

Data modeling

Dashboard reporting

Application support

Education

Bachelor's degree in computer science/IT

Master's degree

Tools

Power BI

Tableau

Oracle Goldengate

MySQL

Job description

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.