Browse Jobs
For Employers
Post JobLog inGet Started

Senior PostgreSQL Database Administration

Ultimate Solutions Egypt
6th of October, Giza
Posted 3 years ago
10Applicants for4 open positions
  • 0Viewed
  • 0In Consideration
  • 0Not Selected
Search other opportunities

Job Details

Experience Needed:
Career Level:
Education Level:
Salary:
Job Categories:

Skills And Tools:

Job Description

  • This Candidate is responsible for full life cycle support of client and internal database(s).
  • This Candidate is responsible for Developing Stored Procedures, Functions, Packages, and Database Triggers in support of application development.
  • This Candidate is responsible for building Database Relational Structure including tables, views, and relations.

Responsibilities:

  • Responsible for the monitoring and uptime of all production databases.
  • Estimate PostgreSQL database capacities; develop methods for monitoring database capacity and usage.
  • Lead efforts to develop and improve procedures for automated monitoring and proactive intervention, reducing any need downtime.
  • Develop Procedures, Functions, Packages, and Database Triggers in support of application development.
  • Participate in application development projects and be responsible for database architecture and design.
  • Participate in the creation of development, staging, and production database instances, and the migration from one environment to another.
  • Responsible for developer SQL code review to ensure queries are optimized and tuned to perform efficiently prior to production release.
  • Responsible for regular backups and recovery of databases.
  • Responsible for regular maintenance on databases (e.g., Vacuum, Reindexing, Archiving).
  • Responsible for pro-active remediation of database operational problems.
  • Responsible for Query tuning and preventative maintenance.
  • Support complex web-based applications.
  • Perform other duties as assigned.

Job Requirements

Qualifications & Skills:

  • Education: B.S. in Computer Science or Engineering or equivalent work experience.
  • 4+ years of PostgreSQL and Database Administration.
  • Must have experience in PostgreSQL database architecture, logical and physical design, automation, documentation, installs, shell scripting, PL/ SQL programming, catalog navigation, query tuning, system tuning, resource contention analysis, backup and recovery, standby, replication, etc.
  • Must have strong knowledge of Linux.
  • Strong understanding of command line and server administration.
  • Knowledge of shell scripting (e.g., Bash, Perl).
  • Understanding of web application framework and App. Server Deployments.

Featured Jobs

Similar Jobs

Search other opportunities
JobsInstallation/Maintenance/RepairSenior PostgreSQL Database Administratio...