Database Development Manager / Sr. Database Developer (Oracle)
Pakistan Revenue Automation (Pvt) Ltd
Islamabad , Pakistan
Posted Aug 02, 2021 5 views
Pakistan Revenue Automation (PVT) LTD is looking for a Manager Database developer having hands on experience with database designing, complex queries writing, performance and query optimization.
He will work with other resources 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 identify any issues related to database performance and provide corrective measures.
- Evaluate existing database and recommend improvements for performance efficiency.
- Develop best practices for database design and development activities.
- Perform space management and capacity planning for database systems.
- Refine and automate regular processes, track issues, and document changes
- Ensure data quality and integrity in databases Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end.
- Analyzes business processes and procedures to recommend technical system/software solutions.
- Review proposed database structure changes by development teams and approve or modify based company standards and best practices.
- Provides support for software releases
- Researches interfaces to identify and code required updates to support integration
- 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.
- Skills10+ year Oracle Database (10g,11g, 12C & 19C latest) Development experience required
- Experience with software Agile methodology and software development common practices (code reviews, unit testing etc.).
- Experience with logical and physical data modeling and Strong knowledge of ORDBMS/RDBMSExperience in designing and maintenance of Database Modeling (ER-Win Data Modeler, Toad Data Modeler etc.)
- Firm understanding of the overall architecture required to support common schema-based objects used to store data and implement business logic.
- Ability to provide guidance, oversight, and peer review to more junior database developers and direction to other technical resources as required.
- Aptitude for debugging problems in complex, unfamiliar codeSolid work ethic, self-driven, can function independently with minimal oversight and direction
- Experience with PL/SQL analytical functionsStrong 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 & PartitioningBeing able to plan technical solutions.
- 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
Specific Tasks
- Team work
- Work under pressure
- Manage Teams
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?
Similar Job Titles
Zubair Anjum
Business Excellence Specialist
Nestle Pakistan
Zohaib Ali
Marketing Manager
Digital Online Devices
Mona Sharif
Senior Team Lead
Konext PVT. LTD
Ali Aziz
CEO
Shopistan
Muzammil Baig
Digital Marketing Manager
IT Services Group
Sehrish Azhar
Motivational Speaker & Blogger
Living Upbeat
Ayesha Shaukat
Social Media Marketing Manager
Ivoke
Usman Habib
Recruitment & Training Executive
ACS Synergy (Pvt) Ltd.
Aqib Irshad
Head of HR, Training & OD
FINCA
Babar Ahmed Khan
Territory Sales Manager
Engro Foods
