Lead Database Administrator

Ocuco Ltd; Dublin; Hybrid; EUR 100,000 - 150,000; Full time

Job summary

Ocuco Ltd in Dublin 15 is seeking an experienced Lead Database Administrator to join our Database Team. This is a hands-on leadership role with responsibility for the day-to-day management and development of team members, ensuring reliability, performance and continuous improvement of both customer and internal database environments.

You will oversee database maintenance, performance, recovery activities, and schema/script work, while establishing best practices through mentoring and knowledge

Qualifications

• 8+ years' commercial Oracle DBA experience across Windows and Linux/Unix.
• 5+ years' experience with Oracle RAC.
• Experience working in an IT development environment.
• Excellent SQL and PL/SQL skills.
• Hands-on Oracle database configuration and administration.
• Experience with Azure SQL Database.
• Strong ability to diagnose database performance issues.
• Experience carrying out preventative database maintenance.
• Experience using bulk data transfer methods.

Responsibilities

• Team coordination: Lead and coordinate the work of Database Administrators and Data Engineers, working closely with the Operations Director on priorities.
• People leadership: Provide day-to-day line management for members of the Database Team, including performance management and coaching.
• Knowledge development: Provide technical guidance and mentoring and establish knowledge-transfer practices.
• Database ownership: Own customer and internal database requirements ensuring reliability and service quality.
• Database administration: Manage configuration, maintenance, recovery and performance-tuning across hosted and remote environments.
• Performance and resilience: Diagnose issues and implement effective solutions for resilience and capacity planning.
• Schema and scripting: Maintain schemas and migration scripts across the product range.
• Data management: Write and review SQL/PLSQL/T-SQL to manipulate and transfer data.
• Technical collaboration: Work with Development, Operations and Support on database-related needs.
• Support enablement: Mentor Support Engineers and promote best practices.

Skills

Leadership

Oracle DBA

SQL

PL/SQL

Oracle RAC

Azure SQL

Linux/Unix

Scripting

Data modeling

Performance tuning

Bulk data transfer

Job description

Company Profile:

Ocuco Limited is a leading software solutions provider in the eyecare industry, dedicated to helping eyecare professionals streamline their operations and provide exceptional patient care. With a global presence and a focus on innovation, Ocuco has built a reputation for delivering cutting-edge technology and outstanding customer service.

Job Description:

Ocuco is seeking an experienced Lead Database Administrator to join our Database Team at our HQ in Dublin 15. This is a hands-on technical and people leadership role, with responsibility for leading a small team while ensuring the reliability, performance and continuous improvement of customer and internal database environments.

As Lead Database Administrator, you will combine strong technical expertise with people leadership, taking responsibility for the day-to-day management and development of team members alongside critical database administration activities. You will oversee database maintenance, performance and recovery activities, support schema and scripting work, and establish consistent best practices through mentoring and knowledge sharing. This is a hybrid role requiring office attendance three days per week.

Responsibilities:

• Team coordination: Lead and coordinate the work of Database Administrators and Data Engineers, working closely with the Operations Director on team priorities, scheduling, resource planning, and workload management.
• People leadership: Provide day-to-day line management for members of the Database Team, including performance management, development and coaching.
• Knowledge development: Provide technical guidance and mentoring to the team and take ownership of a structured knowledge-transfer framework to strengthen capability and continuity across the function.
• Database ownership: Take overall responsibility for customer and internal database requirements, ensuring high standards of reliability, availability, performance and service quality.
• Database administration: Manage database configuration, maintenance, recovery, preventative maintenance and performance-tuning activities across hosted and remote customer environments.
• Performance and resilience: Diagnose database performance issues, implement effective solutions, and contribute to database recovery, resilience and capacity planning.
• Schema and scripting: Maintain database schemas across the product range, including database migration and maintenance scripts.
• Data management: Write, review and execute SQL, PL/SQL and T-SQL scripts to manipulate, load, extract and transfer data, supported by a strong understanding of database structures and relationships.
• Technical collaboration: Work closely with Development, Operations and Support teams on database-related requirements, changes and technical issues.
• Support enablement: Mentor Ocuco Support Engineers and promote consistent application of database best practices across database-related support activities.

Required Experience & Skills:

• Demonstrated experience leading and developing technical team members, including people-management responsibilities.
• 8+ years' commercial Oracle DBA experience, covering database design, development and performance, with experience of Oracle 11g or later across Windows and Linux/Unix environments.
• 5+ years' experience with Oracle RAC.
• 5+ years' experience working within an IT development environment.
• Excellent SQL and PL/SQL skills.
• Hands-on experience in Oracle database configuration and administration.
• Experience working with Azure SQL Database.
• Strong ability to diagnose database performance issues and implement effective solutions.
• Experience carrying out preventative database maintenance.
• Experience using bulk data transfer methods.

Additional Preferred Experience:

• Knowledge of Oracle Multimaster Replication.
• Experience with Oracle Data Guard.
• Advanced Linux/Unix knowledge.
• Knowledge of Python and/or Perl.
• Experience working with cloud or SaaS technologies.
• Advanced SQL tuning experience.
• Data modelling experience.