Senior Oracle Exadata & NoSQL Data Architect

People (Professional Employers Pvt Ltd); Islamabad; On-site; PKR 3,000,000 - 4,800,000; Full time

Job summary

People (Professional Employers Pvt Ltd) seeks a Senior Database Developer to design scalable Oracle Exadata solutions, optimize SQL/PL/SQL, and lead ETL and data migration efforts. You will work across cloud and on-premise environments, collaborating with application teams for deployment, testing and production support.

The role emphasizes performance tuning, data modeling, and reporting with dashboards (Power BI/Tableau), ensuring data integrity and high availability.

Qualifications

• 6+ years of hands-on experience with Oracle Database and Exadata.
• Advanced SQL and PL/SQL development skills; able to normalize 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.

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.

Skills

Oracle Database

Exadata

SQL

PL/SQL

Data modeling

Performance tuning

NoSQL

Cloud platforms

ETL/data migration

Dashboard reporting

Education

Bachelor's/Master's in CS/IT/Engineering

Enterprise DB development experience

Tools

MySQL

Oracle Goldengate

Power BI

Tableau

Job description

People (Professional Employers Pvt Ltd) seeks a Senior Database Developer to design scalable Oracle Exadata solutions, optimize SQL/PL/SQL, and lead ETL and data migration efforts. You will work across cloud and on-premise environments, collaborating with application teams for deployment, testing and production support.

The role emphasizes performance tuning, data modeling, and reporting with dashboards (Power BI/Tableau), ensuring data integrity and high availability.