Junior / Senior Oracle Data Warehouse DBA
Pakistan Revenue Automation (Pvt) Ltd
Islamabad , Pakistan
Posted Nov 27, 2019 361 views
PRAL is looking for Junior and Senior Oracle Data Warehouse DBA who has both broad and deep knowledge of Data Warehouse applications to join a team of experts.
REQUIREMENTS:
- Must have (1-3) Years of Experience for Jr. Oracle Data Warehouse DBA and 5+ years of experience for Sr. Oracle Data Warehouse DBA with a reputed IT organization.
- Must have extensive experience in Oracle Analytic Workspace Manager (AWM) and Oracle Essbase.
- Can build cubes and merge metadata with OBIEE (11g/12c). Logical and Physical Database Design & Development using best practices for OLAP (Oracle) systems.
- Deep experience with Data Architecture, Database Design including Data Quality and Master Data Management (MDM) tools, processes and governance.
- Experience with the BI / DW lifecycle components including Source data analysis, ETL, ODS, DataMarts, Reporting, Dashboards, Analytics.
- Experience in complex query techniques, advanced analytical functions and data visualization.
- Hands on experience of ETL to load/clean/convert data between different database objects.
- Strong knowledge of SQL and PL/SQL and able to analyze data and have good trouble shooting skills. Strong working knowledge of Data warehouse, Star and Snowflake schema.
- Experience documenting business requirements and technical architecture/design while translating complex requirements and designs for development, testing and implementation.
- Hands-on experience in proactive monitoring of database environments (backups, recovery, capacity planning, job scheduling…), with Performance Tuning and Troubleshooting Providing support for planning and performing database migrations, upgrades and updates.
Essential Skills Required:
Candidate having required Years of experience with respect to positions of Oracle Analytic Workspace Manager (AWM) 11g, 12c and Oracle Essbase in collaboration with OBIEE Repository and strong Data Warehouse concepts.
Other desirable skills:
- Excellent communicational skills both verbal & written.
- Ability to work in a team environment & learn new technologies.
- Experience in looking after 24×7 environments.
- Be able & available to work on Production issues after hours or on weekends.
- Experience in working under a production support & pressurized environment.
- Troubleshooting, problem solving and able to drive issues to resolution.
- Experience in performing health checks of databases
Skills
Job Details
Pakistan Revenue Automation (Pvt) Ltd
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.
What is your Competitive Advantage?
Ali Aziz
CEO
Shopistan
Mona Sharif
Senior Team Lead
Konext PVT. LTD
Sehrish Azhar
Motivational Speaker & Blogger
Living Upbeat
Usman Habib
Recruitment & Training Executive
ACS Synergy (Pvt) Ltd.
Aqib Irshad
Head of HR, Training & OD
FINCA
Muzammil Baig
Digital Marketing Manager
IT Services Group
Zubair Anjum
Business Excellence Specialist
Nestle Pakistan
Zohaib Ali
Marketing Manager
Digital Online Devices
Babar Ahmed Khan
Territory Sales Manager
Engro Foods
Ayesha Shaukat
Social Media Marketing Manager
Ivoke
