Database Administrator
SME Bank Limited, Pakistan

Reports to: Dept. Head MIS

Location: Head Office, Islamabad

Key Responsibilities:

• Reviews, develops, and designs data models using standard diagramming techniques, in conjunction with application development teams; creates logical data models and translates into physical database structures that integrate with existing or proposed database structures.
• Monitors relational databases to optimize database performance, resource use, and physical implementations of databases; addresses a variety of database integration issues including migration between disparate databases, integration, maintenance/conversion, capacity planning issues, and new applications.
• Maintains development, test, and production RDBMS environments.
• Design and Implement database solutions for Disaster Recovery, Business Continuity and Cyber Security.
• Monitors and maintains database security and database software, in cooperation with data security administrators.
• Provides advice to applications programmers in the effective use of database languages; advises on troubleshooting, exception processing needs, and other data management issues.
• Maintains availability and integrity of databases through multiple access schemes; facilitates sharing of common data by overseeing proper key and index management and data dictionary maintenance.
• May evaluate and recommend testing and evaluation of new procedures, software, and hardware.
• Monitors and manages database backups, logs, and journals; installs, maintains, and upgrades database software; restores and/or recovers data as required.
• Creates, procures and maintains various database related documents such as manuals and programmers handbooks.
• Provide 24 hour on-call support. Job shall be shift based.
• Maintains a broad knowledge of state-of-the-art technology, equipment, and/or systems.
• Performs other related duties as assigned.

Knowledge, Skills and Abilities Required

• Ability to interpret data models and to develop database structures.
• Ability to use standard diagramming techniques to design and develop computer data models.
• Ability to implement and troubleshoot programming changes and modifications.
• Ability to program, configure, manage, and maintain the operation of complex relational databases.
• Ability to develop and manipulate large, complex data sets.
• Knowledge of computer and/or network security systems, applications, procedures, and techniques.
• Knowledge of data integrity methods and techniques.
• Ability to perform acceptance testing on computer systems, applications, and hardware.
• Ability to install, maintain, modify, and upgrade database software.
• Technical writing skills.
• Ability to provide technical guidance and leadership to professional personnel in area of expertise.
• Ability to operate on a scheduled 24-hour on-call basis.
• Develops and implements the overall database Information Security Strategy.

Experience: Minimum one year’s experience of managing an online corporate Oracle Enterprise Database. Knowledge of Oracle 12c/9i will be given preference.

Age Limit: Up to 30 years

Job Rewards and Benefits