• Develop simple to complex database solutions for OLTP (Online Transaction Processing) and OLAP (Online Analytical Processing) environments.  This experience utilizing SQL/PLSQL within an enterprise-class Relational Database Management System (RDMS) with Strong working knowledge of Oracle 12c.
  • Design and develop database applications.
  • Develop complex PL/SQL scripts to perform various database related tasks (Temp tables, Cursors, Functions, Procedures, Views, Performance tuning of applications and database), Indexes, Constraints, etc...)
  • Design the database structure for an application.
  • Estimate storage requirements for an application.
  • Specify modifications of the database structures for an application.
  • Establish an application's security requirements during development.
  • Works with technical team to define conceptual, logical and physical data models
  • Recommends and takes action to solve database or business intelligence related problems.
  • Develops designs and scripts for the extraction, transformation, and loading of data from external sources.

 REQUIRED SKILLS: 

  • Proficient in Oracle SQL (Complex queries, Joins, Analytical functions) 
  • Proficient in Oracle PL/SQL (Functions, Procedures, Triggers, Types, Packages)
  • Experience in DB design and development, Create Tables, Views, Indexes and Sequences
  • Performance Tuning including tuning/optimizing SQL, PL/SQL code
  • Proven Development Experience in SQL and PL/SQL Programming in Oracle 12/11/10g in windows/ Unix Environment
  • Experience working with development tools like TOAD/PLSQL Developer/ERWIN
  • Enforced data integrity using integrity constraint and database triggers.
  • Proficient in advance features of Oracle for PL/SQL programming like Using Records and Collections, Bulk Bind, Ref. Cursors, Nested tables and Dynamic SQL.
  • Experience in SQL and PL/SQL tuning and query optimization tools like SQL Trace, Explain Plan, and DBMS_PROFILER.
  • Use of package like DBMS_STATS, UTL_FILE, DBMS_SCHEDULER and UTL_SMTP.
  • Strong knowledge with PL/SQL Wrapper to protect the PL/SQL procedures or packages.
  • Use of Cubes & Rollups for making cross tabular reports.
  • Use of Warehouse techniques Star Schema, Snow Flake Schema, Dimension and Fact table.
  • Expertise in handling errors using Exceptions.
  • Exposure & knowledge of designing logical & physical Data Model in Relational Database Management System (RDBMS).
  • Experience in working high-transacted OLTP systems.
  • Extensive experience with all phases of the Software Development Life Cycle including analysis, Resource Planning, code development, testing, implementing and maintenance
  • Documentation of projects for Functional Requirement Spec (FRS), Use case Spec, ER-Diagram, Test Plan, and Test Script & Test Cases.
  • Have worked in fast paced AGILE environment.
  • Assisted QA Teams for bug testing, User Acceptance Testing (UAT) & System Integration Testing.
  • Highly motivated, excellent team player, enthusiastic, strong initiative and quick learner of new technologies.
  • Strong problem identification and analytical skills.
  • Creativity with an eye to developing new and innovative solutions.
  • Excellent analytical and logical skills, including the proven ability to adapt to a dynamic project environment and manage multiple concurrent projects.
  • Would be a plus with knowledge of Embedded SQL, SQLJ/Client-Side APIs/OCI and OCCI, Oracle Jdeveloper, SQL object types, Object reference types, SQL collection types.

نوکری کی تفصیلات

کل عہدے:
4 آسامیاں
نوکری کی شفٹ:
پہلا پہر
نوکری کی قسم:
محکمہ:
Software Development
نوکری کا مقام:
جنس:
کوئی ترجیح نہیں
کم از کم تعلیم:
بیچلرز
ڈگری کا عنوان:
Must have 4 years Bachelors in Computer Science or IT preferably in related majors, from reputed foreign or HEC-recognized institution
کیریئر کی سطح:
تجربہ کار پیشہ ور
کم از کم تجربہ:
غیر تجربہ کار ((0-3) Years of Experience for Jr. Database Administrator & 03 years + experience for Database Administrator)
اس سے پہلے درخواست دیجیۓ:
فروری ۱٦, ۲۰۲۱
تاریخِ اِشاعت:
جنوری ۲۸, ۲۰۲۱

Pakistan Revenue Automation (Pvt) Ltd

انفارمیشن ٹیکنالوجی · 1001-1500 ملازمین - اسلام آباد

Pakistan Revenue Automation (Pvt.) Ltd. (acronym – PRAL) has extensive experience of working with federal and provincial tax and revenue agencies to provide wide variety of tax and revenue collection solutions. Since its incorporation in June, 1994, PRAL has been involved in the development of wide array of tax and revenue related solutions pertaining to Income Tax, General Sales Tax, Federal Excise, Customs, Capital Value Tax, Provincial Sales Tax & Services. etc. Over more than two decades of services, PRAL has gained valuable experience of increasing efficiency and efficacy of tax and revenue agencies through use of latest Information and Communication Technologies with Business Process Improvement / Re-engineering. PRAL has also proven its expertise in the areas of software development, project management, technical advisory and consulting services, managing data centers, large databases management, network administration, software implementations, trainings and data entry services. This wide spectrum of services offered by PRAL facilitates our valued customers looking for One-Stop Shop solutions from conceptualization to post-implementation operations. The essence of PRAL’s business strategy is to develop sustainable partnerships with its customers thus acting as a catalyst in transforming and adapting its IT solutions and integrating these to the “New Wave of Technological Innovations” to meet the global requirements of tax and revenue agencies.

آپ کو کس حوالے سے برتری حاصل ہے؟

اپنے بارے میں ہماری پیشہ ورانہ رائے اور تقابلی جائزہ حاصل کیجیۓ
اپنی سی وی کو موءثر بنانے کیلئے ہماری ماہرانہ مشاورتی ٹیم سے رابطہ کریں
روزی پریمیئم کو آزمائیں

ملتی جلتی نوکریاں

Database Administrator (DBA) - SQL

7NSoft Systems (Pvt) Ltd, کراچی, پاکستان
مئی ۱۰, ۲۰۲۲ شائع ہوئی

Database Administrator / Analyst

Nai Zindagi, اسلام آباد, پاکستان
مئی ۲۳, ۲۰۲۲ شائع ہوئی

Database Administrator

Aftab Currency Exchange Ltd, راولپنڈی, پاکستان
مئی ۱۸, ۲۰۲۲ شائع ہوئی

Database Administrator

PureLogics, لاہور, پاکستان
مئی ۱۸, ۲۰۲۲ شائع ہوئی
تمام دیکھیں
I found a job on Rozee!