• Install, configure, and upgrade Microsoft SQL Server instances on AWS (EC2, RDS, RDS Custom). • Perform proactive performance tuning, indexing, and query optimization. • Manage database backups, restores, and disaster recovery strategies. • Implement high availability solutions (Always On Availability Groups, replication). • Lead migration efforts from on-premises SQL environments to AWS RDS. • Deploy and manage SQL databases using AWS services such as RDS, Aurora, and EC2. • Utilize AWS tools like CloudWatch, CloudTrail, and IAM for monitoring and security. • Implement Infrastructure as Code using AWS CDK with TypeScript for database provisioning. • Enforce database security policies, encryption, and access controls. • Ensure compliance with industry standards (GDPR, ISO 27001, SOC 2) and internal governance. • Monitor system health and performance metrics. • Troubleshoot database and AWS-related issues promptly. • Maintain detailed documentation of configurations and operational procedures. • Work closely with Cloud Operations and Application teams for migrations and integrations. • Participate in planning and execution of database modernization initiatives. • Participate in a 24/7 on-call rotation to support critical infrastructure, respond to operational incidents, and ensure high availability.

Company Background Our client is an award-winning travel company that connects travelers with a nationwide network of independent travel advisors. The company combines innovative technology, personalized service, and strong supplier partnerships to deliver customized vacation experiences across cruises, resorts, tours, and more. Project Description The project focuses on rebuilding a proprietary agent-facing travel platform from the ground up using a modern, cloud-native architecture on Microsoft Azure. The new platform aims to improve performance, scalability, and usability while enabling faster feature delivery and seamless integrations. A key part of the initiative is migrating data from legacy systems to a new PostgreSQL-based architecture and ensuring high availability, security, and performance of critical data systems. Technologies - PostgreSQL - Microsoft Azure - SQL - High Availability (Failover, Replication, Backup/Recovery) - Database Security & Encryption - CI/CD & DevOps What You'll Do - Administer and maintain Azure-managed PostgreSQL databases across environments - Design scalable and efficient database schemas and architectures - Monitor and optimize database performance (queries, indexing, execution plans) - Implement and maintain backup and disaster recovery strategies - Ensure database security, access control, and compliance - Plan and execute data migrations from legacy systems - Write and optimize complex SQL queries, procedures, and functions - Collaborate with development teams on database design and query optimization - Automate routine DBA tasks using scripting tools - Troubleshoot and resolve database issues - Maintain documentation (data models, ER diagrams, data dictionaries) - Participate in on-call rotation Job Requirements - 5-8 years of experience as a Database Administrator - Strong experience with PostgreSQL, including Azure-managed environments - Expert-level SQL skills and query optimization - Experience with high availability and disaster recovery solutions - Strong experience with performance tuning and indexing strategies - Understanding of database security, encryption, and compliance - Experience with data migration from legacy systems - Familiarity with database monitoring and performance tools - Strong analytical and problem-solving skills - Excellent communication skills - Ability to work in a greenfield environment - Strong experience in schema design - English level: B1 (Intermediate) or higher What Do We Offer The global benefits package includes: - Technical and non-technical training for professional and personal growth; - Internal conferences and meetups to learn from industry experts; - Support and mentorship from an experienced employee to help you professional grow and development; - Internal startup incubator; - Health insurance; - English courses; - Sports activities to promote a healthy lifestyle; - Flexible work options, including remote and hybrid opportunities; - Referral program for bringing in new talent; - Work anniversary program and additional vacation days.

• Test databases, correct errors, and make necessary modifications • Plan, coordinate, and implement security measures to safeguard information in files • Modify existing databases and database management systems • Write and code logical and physical database descriptions and specify identifiers of database to management system, or direct others in coding descriptions • Perform all aspects of Oracle database administration • Actively participate in the daily Operational activities of customer databases • Monitor production, test, and development database environments and actively pursue any issues limiting the performance, scalability, and availability of these systems • Database bug resolution, address database security vulnerabilities • Analyze trends, report potential problems or areas of improvement concerning internal and customer databases • Performance tuning by analyzing Oracle AWR, ADDM, ASH reports • Setup, Configure and support Physical Standby (Active Data Guard) databases for high availability with proficiency in failover/switchover mechanisms • Setup, Configure Oracle database backups via Recovery Manager (RMAN) utility for Disaster recovery • Manage Database users, roles, and privileges • Provide Technical support to Customers • Plan Database refreshes from Production to non-prod environments to test application changes • Engineer migration plan for Oracle Databases from on-premises environments to AWS and devise suitable approach • Improve Database query workflow via implementing Oracle Table partitioning • Work on Oracle Export Import Utility (Classical & Data Pump) for Object level granular migration • Validate Oracle Database objects code and error corrections • Engineer parameters modifications in Database Management Systems • Automate Statistics collection against Enterprise Database servers to ensure Data dictionary views/tables/schemas are all current • Work closely with DevOps teams to review CPM backups periodically and to establish continuous delivery to Development teams • Devise learning curve via Test cases/Database Proof of Concepts • Participate in Managed Services on-call rotation

Role Description Wir suchen einen erfahrenen Datenbank Administrator (Senior Consultant) für die Sicherstellung des Betriebs von Oracle Golden Gate im Rahmen eines Projekts bei einem führenden Versicherungsunternehmen. Der ideale Kandidat verfügt über mindestens sechs Jahre Berufserfahrung und tiefgehende Kenntnisse in der GoldenGate-Architektur. - Sicherstellung des stabilen Betriebs für Oracle Golden Gate - Review der eingesetzten Verfahren und Architekturen - Durchführung von Know-how-Transfer und Aufbau von Fachwissen bei weiteren Teammitgliedern - Installation und Konfiguration von Oracle GoldenGate Microservices (OGGMA) - Einrichtung von Extract- und Replicat-Prozessen für verschiedene Anwendungsfälle - Konfiguration von DML-Replikationen sowie Konfliktbehandlung (Conflict Detection & Resolution) bei bidirektionalen Setups - Monitoring und Troubleshooting inklusive Analyse von Lag, Checkpoint-Problemen und Blockaden - Durchführung von Fehlerdiagnosen über GoldenGate Logs, Eventlogs und Performance Views - Sicherstellung von Performance und Stabilität der Systeme - Optimierung der Systemparameter durch gezieltes Parameter-Tuning (z.B. BATCHSQL, FETCHOPTIONS, DBOPTIONS) Qualifications - Senior Consultant mit mindestens 6 Jahren Berufserfahrung in der Datenbank-Administration - Fundierte Kenntnisse der Oracle GoldenGate-Architektur einschließlich Extract, Replicat, Trail Files, Checkpoints sowie Classic & Integrated Extract / Replicat - Expertise in der Installation und Konfiguration von Oracle GoldenGate Microservices (OGGMA) - Erfahrung mit unidirektionaler, bidirektionaler und Multimaster-Replikation sowie Replikation zwischen heterogenen Systemen (z. B. Oracle zu Db2 z/OS) - Kenntnisse in der Einrichtung von Extract/Replicat-Prozessen und Konfiguration von DML-Replikation - Erfahrung in der Konfliktbehandlung (Conflict Detection & Resolution) bei bidirektionalen Setups - Sicherer Umgang mit Oracle Version 19c und Redhat Linux in virtualisierten Landschaften - Kompetenz in Monitoring, Troubleshooting und Performance-Tuning von GoldenGate (Lag-Analyse, GG Logs, Parameter-Tuning) - Erfahrung im Einsatz von Tools wie Ansible, Oracle Enterprise Manager, Dynatrace und Rubrik - Verhandlungssichere Deutschkenntnisse Requirements - Ausgeprägte Kommunikationsfähigkeit und Teamfähigkeit - Hohe Problemlösungskompetenz und kritisches Denken - Anpassungsfähigkeit und Flexibilität im Projektumfeld Benefits - Der Einsatz kann zu 100% remote erfolgen - Einarbeitung nach Bedarf am Standort in Kiel vorgesehen