Job: DATABASE ADMINISTRATOR – LEVEL 6

Title DATABASE ADMINISTRATOR – LEVEL 6
Categories DATABASE ADMINISTRATOR – LEVEL 6
Salary [Salary Scale: $2,202,248 – $2,642,698 p.a. plus allowances, if applicable]
Start Date 03/06/2019
End Date 14/06/2019
Location Kingston
Job Information

JOB PURPOSE

To support the protection of national security and delivery of service to customers by creating and maintaining database structures to allow users to update database structures and to maximize system performance

KEY OUTPUTS

  • Specifications for database structures
  • Conversion programs
  • Backup, storage and recovery procedures developed
  • Database system tables maintained
  • Staff assisted
  • Produce database reports

JOB RESPONSIBILITIES

  • Develops and maintains specifications for database structures, including triggers, stored procedures and secondary keys
  • Supports and maintains all SQL and Oracle servers within the Agency including operational systems and corporate data
  • Develops and maintains conversion programs to allow input of data from other formats into the Agency’s databases
  • Implements strategies for archiving and purging data
  • Develops and maintains procedures that allow users to install modifications to database structures without losing data.
  • Maintains separate Development /Test/ Production environments
  • Maintains the availability and optimal performance of all databases, systems tables,
  • Creates SQL scripts
  • Develops reports for Management
  • Maintains and enhances database operations to include integrity testing and database patches
  • Provides in-house technical system support

KEY COMPETENCIES

The post holder needs to demonstrate the following competencies:

  • Sound knowledge of the required operating systems
  • Sound knowledge of relevant programming languages
  • Sound experience with Crystal reporting, SQL reporting services and SQL programming skills
  • Sound knowledge of other scripting languages
  • Basic knowledge of the policies, procedures controls for Immigration, Citizenship and Passports in Jamaica
  • Sound oral and written communication skills
  • Sound organizational and project management skills
  • Sound decision-making and problem solving skills

QUALIFICATIONS – Education and Experience:

  • Bachelor’s Degree in Computer Science, Information Technology or equivalent
  • Sound knowledge / certification in Database Administration
  • Four (4) years related experience

…………………………………………………

Aleta Bartley (Ms.)

Director, Human Resources (Assigned)

If you believe you possess the above qualities and a strong desire to help the Agency fulfill its mandate, you are invited to visit our website at www.pica.gov.jm/ http://picajobs.picaserv.com for details

Submission of applications accompanied by detailed resume including the names of two (2) references should be submitted via the web to:

Director, Human Resources

Passport Immigration & Citizenship Agency

8 Waterloo Road, Kingston 10

NO LATER THAN

Friday, June 14, 2019 @4:00pm

No hand delivered application will be accepted

 

We appreciate your interest in these positions; however only shortlisted applicants will be contacted.

Apply Now