Database Admin- PostgreSQL

Job 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 Stored Procedures and Database Triggers in support of application development.
• Participate in application development projects and be responsible for the 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.
• Participate in a 24×7 support rotation.
• Support complex web-based applications.
• Perform other duties as assigned.

Requirements:

• Minimum 5 years’ experience in IT/ software development / IT system projects / Website Development / Mobile Application Development.
• Development with Minimum of 2 years’ experience in same role (i.e., Database Admin).
• Must have experience in PostgreSQL database architecture, logical and physical design, automation, documentation, installs, shell scripting, PL/ SQL programming, catalogue 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 PHP and web application framework.

Behavioral Competencies:

• High attention to detail regarding accounting skills
• Ability to work under indirect supervision.
• Good problem-solving skills
• Strong verbal and written communication skills.
• Ability to influence technical discussions and decisions.