Peninsula is the leading provider of marine energy services and solutions globally. For the last 25 years, we have positioned ourselves as the benchmark for quality in our industry. We offer local knowledge on a global scale.

WHAT YOU’LL DO

The Database Architect/Administrator will be responsible for constantly monitoring our databases and immediately addressing database issues and problems. The successful candidate will also submit reports to management that outline the changing data needs of the company and come up with related solutions.

Work closely with our software and application development teams to recommend database structures based on the data storage and retrieval needs within each department.

MAIN RESPONSIBILITIES

• Database estate administration and monitoring
• Managing application system Disaster Recovery and high availability
• Managing backup and recovery strategies / automation of maintenance and batch processing
• Database performance tuning including TSQL / Procedural performance tuning (Optimizer and Index usage)
• Database design and architecture, development and administration
• Setting up best practice database development and acting as a database quality authority and stage gate for promotion of database code to production
• Responsible for database object design
• Training development team as to best practice database development standards
• Implementation of source control and change control of Database and Middleware systems
• Keeping database systems up-to-date with the latest service packs and security updates
• Troubleshooting issues with both databases and third party applications
• Managing ETL processes
• Key player in the migration of database systems to Azure
• Building and migration of SQL servers to appropriate versions
• Ensure database systems (Dev / Test / UAT / Live) are kept at the appropriate versions and configuration
• Managing database security and integrity
• Managing Middleware
• Provide insight into the changing database storage and utilization requirements for the company and offer suggestions for solutions
• Quality control for SQL objects and queries produced by peninsulas software development teams
• Responsible for middleware design, monitoring and maintenance
• Database documentation
• Development of data flow diagrams (current and future state)
• Perform analytical testing and investigative work
• Proposing system improvements
• Experience as an escalation point for database issues and provide out of hours cover and be part of release process

KNOWLEDGE, SKILLS AND EXPERIENCE

Essential:

• Experience as a Database Architect /Administrator
• Excellent troubleshooting and problem solving skills with good attention to detail
• Ability to think logically and be proactive.
• Ability to work as part of a team and on own initiative in a constructive manner
• Strong analytical skills
• Data Modelling
• Relational Database Design
• Database Application Development
• Microsoft - SQL Server / Transact SQL Server /Data Warehousing & Reporting
• PowerShell, DOS
• Database performance tuning
• Degree in Computer Science / Information Systems Design or equivalent

Desirable:

• Knowledge of Fuel oil and the Bunker Industry desirable