Senior Database Developer
Interactive Group of Companies, Pakistan

Purpose of the Job:

To support application development team WITH objectives of Database Design, Administration, scripting and maintenance plus aiding in Data Migration while maintaining Database Backups within the limits of Organizational SOPs, Scope of domain and Products.

Functions & Responsibilities (duties to be performed by this position):

Database Design:

• To design application database IN ORDER TO fulfill use case requirements of information persistence/access through the database.

Database Administration:

• 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 etc. IN ORDER TO generate automated inputs and databases.

Database Maintenance:

• 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.

Database Backups:

• To log the jobs & paths configured as per oracle IN ORDER TO maintain and monitor backups of all jobs to revert back to or utilize in future.

Database Issue Resolution:

• To fix database issues / bugs identified by QC or the client pre or postproduction 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 responsibility assigned by the Management within the scope of this job.

Required Skills & Knowledge Areas:

• Database Analysis
• Database Administration
• Application DB Support
• SQL Development
• SQL Server
• PL/SQL
• SQL YOG
• Data Guard
• HORA
• Oracle 10/11g
• Linux
• Software Development Life Cycle
• Requirement Change Management
• Validation
• Relational Modeling
• Time Management
• Analytical Skills
• Communication Skills
• Interpersonal Skills
• Risk Management

Job Rewards and Benefits