Oracle & PostgreSQL Database Administrator (SC Cleared)

Detailed Description From Employer:

Job Title: Oracle & PostgreSQL Database Administrator

Location: Fully Remote

Contract Length: 2 Months (with scope to extend)

Start Date: ASAP

Hours: Part-Time (20-hour weeks - split across weeks TBC)

Interview Process: 1 Stage, MS Teams

Clearance: SC

We are supporting a public sector client in hiring an experienced PostgreSQL and Oracle Database Administrator with strong data modelling expertise to join an established data platform team.

This is a hands-on technical role requiring deep database administration experience across both PostgreSQL and Oracle environments, spanning cloud and on-premises infrastructure. The successful candidate will own core application data structures, drive database performance and reliability, and work closely with software engineers, data pipeline engineers and data scientists to design and maintain robust data models that support business-critical applications.

This role suits an experienced DBA and Data Modeller comfortable managing complex, multi-environment database estates and contributing to data governance, security and platform evolution within a regulated public sector environment.

Key Responsibilities

• Own and administer PostgreSQL and Oracle database clusters across cloud and on-premises environments, ensuring high availability, scalability and reliability
• Monitor, troubleshoot and optimise database performance across all environments, including production, testing and development
• Design, maintain and evolve logical and physical data models to support application and data integration requirements
• Manage database schema changes and migrations across development, testing, production and offline environments
• Define and govern the life cycle of application data, ensuring data quality, consistency and compliance
• Implement and manage database security controls including user roles, permissions, authentication mechanisms and Row-Level Security
• Collaborate with data engineers and data scientists to onboard and integrate diverse internal and external data sources
• Develop and maintain backup, recovery, disaster recovery and business continuity procedures
• Support CI/CD-driven database deployments, schema versioning and automation of database-related activities
• Contribute to capacity planning, database architecture recommendations and establishment of standards and best practices

Essential Skills

• Proven enterprise-scale experience as both a PostgreSQL and Oracle Database Administrator
• Strong expertise in database design, data modelling and schema architecture across logical and physical models
• Oracle RDBMS experience across versions 10g, 11g, 12c and 19c including RAC, Data Guard and GoldenGate
• Minimum 3 years of experience setting up and maintaining production Oracle RAC and Data Guard environments
• Strong knowledge of Oracle performance tuning, RMAN backup and recovery, OEM and Oracle 12c Grid
• Experience with PostgreSQL and Oracle high availability, replication and migration technologies
• Good knowledge of SQL, PL/SQL, stored procedures and packages
• Good knowledge of UNIX Shell or Perl Scripting
• Experience managing database security including role management, permissions, encryption and Row-Level Security
• Experience supporting CI/CD-driven database deployments and schema versioning

Desirable Skills

• Infrastructure automation and Scripting experience across Python, Bash or PowerShell
• Exposure to cloud platforms across AWS, Azure or GCP
• Familiarity with data engineering, ETL and ELT pipelines and data warehousing concepts
• Experience with monitoring and observability tooling for database environments
• Understanding of DevOps practices and Infrastructure as Code frameworks