Posted May 08, 2019 6 views
- 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
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
Assistant Manager Database Administration
Deputy Manager Database Administrator
Zubair Anjum
Business Excellence Specialist
Nestle Pakistan
Ayesha Shaukat
Social Media Marketing Manager
Ivoke
Muzammil Baig
Digital Marketing Manager
IT Services Group
Aqib Irshad
Head of HR, Training & OD
FINCA
Usman Habib
Recruitment & Training Executive
ACS Synergy (Pvt) Ltd.
Mona Sharif
Senior Team Lead
Konext PVT. LTD
Babar Ahmed Khan
Territory Sales Manager
Engro Foods
Zohaib Ali
Marketing Manager
Digital Online Devices
Ali Aziz
CEO
Shopistan
Sehrish Azhar
Motivational Speaker & Blogger
Living Upbeat
