Senior Oracle Exadata & NoSQL DB Architect

People Perfect; Islamabad; Vor Ort; PKR 250.000 - 320.000; Vollzeit

Zusammenfassung

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.

Qualifikationen

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

Aufgaben

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

Kenntnisse

Oracle Exadata

SQL

PL/SQL

Performance tuning

ETL

NoSQL databases

Cloud platforms

Data modeling

Dashboard reporting

Application support

Ausbildung

Bachelor's degree in computer science/IT

Master's degree

Tools

Power BI

Tableau

Oracle Goldengate

MySQL

Jobbeschreibung

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.