Postgresql DBA Contract

PRINCIPAL RESPONSIBILITIES:

- Manage PostgreSQL and other open source databases through multiple product life cycle environments, from development to mission-critical production systems;
- Responsibility for data Models and data design across the business;
- Configure and maintain database Servers and processes, monitoring of system health, capacity planning, to ensure high levels of performance, availability, and security;
- Establish and maintain backup and recovery policies and procedures;
- Responsible for database storage architecture design and management;
- Refine and automate regular processes, track issues, and document changes;
- Independently analyse, solve, and correct issues in Real Time, providing problem resolution;
- Responsible for performance tuning, query optimization and indexing strategies or all corporate databases;
- Responsible for the Database Disaster Recovery strategy, as part of the overall IT DR strategy;

EXPERIENCE/KNOWLEDGE:

- Experience operating a large scale production database environment
- Experience in troubleshooting skills with relational databases (PostgreSQL, MySQL)
- Experience in independently performing root cause analysis and coming up with recommendations
- Experience in replication techniques, database clustering, LDAP authentication, partitioning and security issues
- Experience with backups, restores, and recovery;
- Experience with database security concepts, including access, auditing, and encryption.
- Knowledge and experience in Open Source solutions to include vetting patches, applying patches to the database and the open source tools, libraries, and daemons;
- Experience of High Availability and Disaster Recovery for PostgreSQL and MySQL;
- SQL Development (psql and T-SQL) experience with ability to write and troubleshoot SQL code (stored procedures, functions, tables, indexes, constraints);
- Experience with system monitoring tools;
- Experience with logical and physical Datamodelling;
- Experience on both Windows and Linus platforms;
- Ability to organize and plan work independently
- Ability to communicate effectively both orally and written