|
|
| Company Name: |
|
|
Job Category:
|
|
| Career Level:
|
| Mid Career (2+ years of experience) |
|
| Job Type:
|
|
| Positions: |
|
| City/Location: |
|
| Country: |
|
| Skills: |
|
| Description: |
ob Description
Job Summary
This position involves a mixture of both DBA and software architect roles. On the DBA-level, you will work with the systems administration team to provide support and maintenance of the Travelfusion production database environment to ensure high performance and 24/7 availability.
As a software architect you will also drive architectural improvements and refactoring of the TravelFusion application codebase related to database access. You will work with the Java development team to review all levels of database usage from the low-level schema design through to profiling and optimising the Java code to maximise database efficiency and eliminate bottlenecks.
Key Responsibilities
Maintain production MySQL database environment
* Monitor usage patterns to be able to troubleshoot real-time issues.
* Profile database usage to identify potential bottlenecks.
* Tune server settings to maximise efficiency.
* Assist systems administration team with the setup and maintenance of MySQL replication.
* Monitor scheduled batch import jobs.
* Maintain and monitor daily database backup procedure.
Review and Optimise existing database schema
*Optimise table structure and indexing for maximum efficiency with the InnoDb storage engine.
Review and refactor Java codebase related to database access
* Identify and optimise inefficient database access code (inefficient queries, unnecessary updates, etc.)
* Review and refactor in-house developed JDBC wrapper framework.
* Investigate opportunities for using second level caching solution to take load off the database.
* Peer review of database access code in future development projects.
WE DO NOT WORK WITH RECRUITMENT AGENCIES. WE ONLY ACCEPT DIRECT APPROACHES FROM CANDIDATES, ANY APPROACH BY AGENTS WILL BE REPORTED TO THE RELEVANT AUTHORITIES.
Skills
Skills
Required Skills:
* Professional experience administrating and tuning MySQL 5 database servers.
* Detailed knowledge of optimising database schemas/indexing for the MySQL InnoDB storage engine.
* Professional coding experience developing database-driven enterprise software.
Preferred Skills:
* Java development experience, specifically with JDBC.
* Knowledge of distributed second-level caching solutions such as TerraCotta, MemCached, EHCache.
* Knowledge of modern Java database frameworks such as Hibernate and iBatis.
* Remote Linux administration experience.
Company Description
Travelfusion is a leader in Direct Connect travel distribution systems and the world's largest technology & content supplier for travel meta-search solutions. Travelfusion has built the largest direct connect distribution system with direct links to 150 airlines with a single XML API booking engine that powers the world's largest leisure & corporate agencies.
|
|
|
