JOB DESCRIPTION
POSITION TITLE: PostgreSQL DBA
Full Time Employee, 1 Position
REPORTS TO: Chief Technology Officer
POSITION SUMMARY: This individual will
support/design/maintain all transactional database aspects iKobo. This
includes database maintenance/tuning, testing, troubleshooting and
providing support. The ideal candidate will have, as a minimum, a
four-year degree or equivalent experience in computer science, a
exceptional understanding of database design methodologies in a Linux
and Windows environment, schema design, and troubleshooting on mission
critical systems. Must be an individual that thrives on dynamic, fast
moving environment.
ESSENTIAL FUNCTIONS:
* Minimum 3 years Database Administration/Architect experience in
24/7 production environments (preferably in mission critical
environments)
* Practical knowledge of Installing & Configuring PostgreSQL on
Linux environments
* Setting up of Database Backups & Recovery mechanisms
* PostgreSQL database activity/log monitoring and debugging
* Ability to perform Major/Minor DB version upgrades on
production/test environments
* Query Analysis & tuning
* Database parameters/performance tuning
* Strong understanding of Database Storage mechanisms
* Strong SQL query/stored procedure writing capability and working
knowledge of PL/PGSQL
* Scripting knowledge using shell or PERL
* Expert relational database design (normalization) &
documentation experience
* Database Security/Access control
* Ability to trouble-shoot from looking through logs, application
C++/PHP code to the database/operating system level
* Ability to work closely with development team and involvement in
new designs, practical Knowledge of SDLC process
* Completion of one or more successful full life-cycle development
project
QUALIFICATIONS:
1. Education & Experience:
* Bachelors degree or equivalent experience (3 -5 years) preferred
in Computer Science specializing in database technology
* Experience with client/server technology
* Experience with relational databases
2. Skills & Abilities:
* Good oral and written communication skills
* Ability to work under pressure
* Strong people skills
* Creative problem solving
* Replication experience a plus
* Basic Linux administration skills a plus
* Experience with Crystal Reports a plus
* Microsoft Visio knowledge a plus
* Ability to perform Backend Testing, a plus
* Ability to understand C++ & PHP code and object oriented
programming, a plus
* General understanding of web technologies and experience
developing web applications a plus
* Oracle Database experience a plus
3. Physical Requirements:
* No special requirements
4. Working Conditions:
* No unique working conditions