Senior Database Developer

We are looking for a Senior Database Developer with extensive experience in Oracle Exadata, SQL, PL/SQL, database design, performance tuning, ETL/data migration, NoSQL, cloud technologies, reporting, and application support. The successful candidate will be responsible for developing scalable, secure, and high-performance database solutions while collaborating closely with application and business teams to meet organizational goals.

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 within Oracle Exadata.
- Analyze 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 modeling, indexing, partitioning, replication, and performance tuning.
- Support cloud and hybrid-cloud database environments using OCI, AWS, Azure, or GCP.
- Manage database migration, modernization, backup, disaster recovery, security, and high-availability initiatives in both on-premises and 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 as required.
- Assist 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 and reconciliation.
- Troubleshoot database, application, integration, and performance issues in production environments.
- Create and manage dashboard data models using Power BI and Tableau.
- Perform database administration and production support, including health and performance monitoring, user/access management, backup, and recovery.
- Undertake other responsibilities as assigned by the Reporting Manager.

Required Qualifications:
- Over 6 years of hands-on experience with Oracle Database and Exadata, along with strong skills in SQL and NoSQL databases.
- Advanced SQL and PL/SQL development capabilities, including normalization of existing non-normalized databases.
- Proficiency in writing complex queries, stored procedures, triggers, functions, cursors, jobs, and schedulers.
- Strong expertise in database performance tuning, indexing, partitioning, and interpreting execution plans.
- Experience with at least one NoSQL database such as MongoDB, Cassandra, DynamoDB, or Redis.
- Familiarity with cloud platforms, preferably OCI, AWS, Azure, or GCP.
- Experience in dashboards, reporting, and data analytics using Power BI, Tableau, or similar tools.
- Excellent troubleshooting, documentation, communication, and team collaboration skills.

Education & Experience:
- Bachelor’s or 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.

This contract position is based in Islamabad for an initial duration of one year, with the possibility of extension. The role demands a proactive and skilled professional capable of managing complex database environments and supporting critical business functions.