Senior Database Developer (Oracle)

Pakistan Revenue Automation (Pvt) Ltd Verified

Islamabad , Pakistan

Posted May 08, 2019 280 views

PKR. 70,000 - 150,000/Month

Apply For This Job

Close

Job Description

  • Maintaining and developing new database objects (tables, packages, procedures, functions, views etc.) by following Database standards
  • write complex queries, refactor existing procedures, tuning and schema refinement
  • Understanding of existing and new business processes
  • Evaluate existing database and recommend improvements for performance efficiency.
  • Develop best practices for database design and development activities.
  • Refine and automate regular processes, track issues, and document changes
  • Ensure data quality and integrity in databases
  • Design, implement and support data movement solutions across multiple platforms and data sources (Database tables/views and external files) using custom code and ETL tools and frameworks
  • Independently analyse, solve, and correct issues in real time, providing problem resolution end-to-end.
  • Develop and maintain database ER Modeling and data dictionaries
  • Become proficient in the data model, data structures and business logic to be able to efficiently respond to business queries and requests
  • Provide ongoing maintenance and support of database schemas and views
  • Conduct root cause analysis and resolve production problems and data issues
  • Work within the defined software development lifecycle, following rigorous change control policies
  • Create and maintain up to date documentation of the data model, data flow and field level mappings
  • Provide quick and quality work for critical production systems.
  • Share domain and technical expertise, providing technical mentorship and cross-training to other peers/team members.

Skills

  • 5+ year Oracle Database Development experience required
  • Strong SQL experience and Proficient in writing and optimizing SQL statements
  • Create complex functions, scripts, stored procedures and triggers to support application development.
  • Experience with Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools
  • Sound knowledge of performance optimization, indexing & Partitioning
  • Experience in designing and maintenance of Database Modeling (ER-Win Data Modeler, Toad Data Modeler etc.)
  • Being deadline oriented.
  • Excellent written and verbal communication
  • Ability to organize and plan work independently
  • Ability to work in a rapidly changing environment
  • Ability to multi-task and context-switch effectively between different activities and teams
  • Knowledge /experience in other relational databases will be a plus point

Job Details

Functional Area:
Total Positions:
1 Post
Job Shift:
First Shift (Day)
Job Type:
Full Time/Permanent
Department:
SOFTWARE DEVELOPMENT
Job Location:
Gender:
No Preference
Minimum Education:
Bachelors
Degree Title:
4 years of bachelor's in Computer Science / Information Technology, from some reputed foreign or HEC-recognized institution.
Career Level:
Experienced Professional
Minimum Experience:
6 Years (Relevant Experience will be preferred.)
Apply Before:
May 25, 2019
Posting Date:
May 08, 2019
Show fewer details Read full job description

What is your Competitive Advantage?

Get quick competitive analysis and professional insights about yourself
Talk to our expert team of counsellors to improve your CV!
Try Rozee Premium

Pakistan Revenue Automation (Pvt) Ltd

Information Technology · 1001-1500 employees - Islamabad

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 ...Read More

Similar Job Titles

Oracle Database Administrator

EcoLogix, Lahore, Pakistan
Posted Jun 17, 2019

Database Developer

CS Recruiter, Multiple Cities, Pakistan
Posted Jun 11, 2019

Senior Software Engineers - Java

InfoTech Pvt Ltd, Lahore, Pakistan
Posted May 31, 2019

Database Administrator

Telenor Microfinance Bank, Karachi, Pakistan
Posted Jun 04, 2019
View All