Posted Sep 04, 2024 1128 views Report Job
We are looking for a Database developer having hands on experience with database designing, Database programming, complex queries writing, performance and query optimization. He will work with other developers for optimizing DB Statements as necessary and establishing best practices.
Responsibilities
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
- Develop and maintain database ER Modeling and data dictionaries
- 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
- Independently analyse, solve, and correct issues in real time, providing problem resolution end-to-end.
- 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
- Development experience required in Oracle
- 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.)
- Strong knowledge of ORDBMS/RDBMS
- 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
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?
Similar Job Titles
Database Administrator - Oracle
Zubair Anjum
Business Excellence Specialist
Nestle Pakistan
Ali Aziz
CEO
Shopistan
Ayesha Shaukat
Social Media Marketing Manager
Ivoke
Muzammil Baig
Digital Marketing Manager
IT Services Group
Usman Habib
Recruitment & Training Executive
ACS Synergy (Pvt) Ltd.
Mona Sharif
Senior Team Lead
Konext PVT. LTD
Zohaib Ali
Marketing Manager
Digital Online Devices
Sehrish Azhar
Motivational Speaker & Blogger
Living Upbeat
Babar Ahmed Khan
Territory Sales Manager
Engro Foods
Aqib Irshad
Head of HR, Training & OD
FINCA
