PostgreSQL DBA

  • Job Ref: 3268
  • Location: Sofia, Bulgaria
  • Type: Permanent

Overview

Database Administrator (DBA)

The DBA will work as part of the IT operations, and Software Development teams.

 

The DBA’s principal responsibilities are:

  • 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;
  • Perform scheduled maintenance and support release deployment activities after hours
  • Apply data modelling techniques to ensure development and implementation support efforts meet integration and performance expectations;
  • Assist developers with complex query tuning, schema refinement and index management
  • Share domain and technical expertise, providing technical mentor-ship and cross-training to peers.

 

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 tsql) 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 data modelling;
  • Experience on both Windows and Linus platforms;
  • Ability to organize and plan work independently
  • Ability to communicate effectively both orally and written

 

Educations/Certification

  • Bachelor’s Degree in Computer Science, Engineering or related field
  • 3 years of professional experience
  • PostgreSQL Certification (Professional Level) or similar DBMS certification
  • Project Management certification (desirable)

 

 

 

Roxana Sandu, Technical Recruiter - Your e-Frontiers consultant for this job

Roxana Sandu is an e-Frontiers Technical Recruiter based in Bucharest, Romania. She holds a degree in Foreign Languages and Literature (French) and chose to work in IT recruitment as she feels this is a sector that has the most impact on our lives. She lived in Dublin for over seven years and had a really good experience here, becoming “half” Irish. She now wants to share this experience with all the IT people interested in having a professional experience in Ireland.

Specialises in: QA, C#, Java, ServiceNow