Posted Oct 09, 2019 3 views
Purpose of the Job:
To be part of application development team WITH objectives of Database Design, Database Development, Database Administration, Scripting and Maintenance, aiding in Data Migration while maintaining Database Backups.
Functions & Responsibilities (duties to be performed by this position):
Database Design:
1. Develop a database subject to the standards and managing multiple enterprise databases and/or data warehouses some of which may spawn hundreds of tables.
Database Administration:
2. To handle successful and streamlined administration IN ORDER TO avoid dead locks, keep servers up and monitor application for smooth running.
Database Scripting:
To plan and process scripts, PL/SQL procedures, functions, triggers and jobs etc. in order to generate automated inputs and databases
Database Maintenance:
1. To ensure local environment integrity in order to enable smooth operations for development, QC, staging, production and showcasing
Data Migration:
To align and format the data in accordance with the ETL protocol (Extract Transfer Load) and verify in accordance with the system in order to integrate data into application
Documentation & Reports:
1. To prepare the release notes documents for product and project, In order to provide information to QC Team or Client.
2. Use BIRT Application, in order to manage and update reports.
Database Conversion:
To convert database from one brand to another like Oracle to Postgres IN ORDER TO achieve application shifting to another database from existing.
Database Issue Resolution:
To Fix database issues / bugs identified by QC or the client pre or post production IN ORDER TO incorporate changes or start a separate DB script
Database Release Management:
Perform Database Sync activities IN ORDER TO incorporate new features / changes, maintain scripts, reflect changes in development and forward to QC for staging and production in parallel.
Intradepartmental Coordination:
To coordinate with other technical departments within P&SD in order to produce the best products as per client requirements
Any other task assigned by Supervisor.
Required Skills and Knowledge Areas:
· Database Analysis
· Database Administration
· Application DB Support
· SQL Development
· Linux / Redhat
· Software Engineering
· Software Development Lifecycle
· Requirement Change Management
· Requirement Traceability
· Validation
· Postgres
· PostgreSQL
· Oracle 10/11g/12c
· MySQL
· HORA
· SSIS
· RMAN
· Putty
· WinSCP
· TeamViewer
· AnyDesk
· VSS
· Issue View
· Time Management
· Analytical Skills
· Communication Skills
· Interpersonal Skills
- Risk Management
Skills
Job Details
Interactive Group of Companies
pHarnessing the synergies of over Seven hundred team members whilst maintaining an international presence, Interactive has actively led Pakistan's Telecommunications and Information Technology industries for a quarter of a century. We have proudly served a prestigious portfolio of clientèle, spanning a wide range of verticals in the Public & Private sectors. Interactive offers turnkey solutions for your automation, hosting, storage, connectivity and security needs, covering the complete suite of technology services including consultancy, design, implementation, operations and maintenance, technical support and training. At Interactive, our people are our strength. We pursue a tradition of continuous improvement in a permanent quest to acquire new competencies and in-depth knowledge in our areas of expertise. We have earned our value through progressive effort and extensive industry experience. We share your goals to employ the power of technology to transform your business./p
What is your Competitive Advantage?
Similar Job Titles
Ayesha Shaukat
Social Media Marketing Manager
Ivoke
Babar Ahmed Khan
Territory Sales Manager
Engro Foods
Muzammil Baig
Digital Marketing Manager
IT Services Group
Usman Habib
Recruitment & Training Executive
ACS Synergy (Pvt) Ltd.
Zubair Anjum
Business Excellence Specialist
Nestle Pakistan
Mona Sharif
Senior Team Lead
Konext PVT. LTD
Ali Aziz
CEO
Shopistan
Aqib Irshad
Head of HR, Training & OD
FINCA
Sehrish Azhar
Motivational Speaker & Blogger
Living Upbeat
Zohaib Ali
Marketing Manager
Digital Online Devices
