JOB TITLE:                      DBA/Senior Software Engineer

LOCATION:                     Manchester

REPORTING TO:              Product Team Leader

DIRECT REPORTS:          None

JOB PURPOSE:

Reporting to the Product Team Leader, the DBA/Senior Software Engineer will design and deploy database solutions in line with the goals of the company. Responsible for supporting Oracle databases and ensuring their performance, availability and security is maximised.

OBJECTIVES

• Provide technical leadership to the team in regard to database solutions and ensure developments are future proof and fall in line with company strategy.
• Ensure that the company prescribed processes and standards are adhered to and contribute to their improvement
• Assist with the development and mentoring of team members in accordance with the personal development process.
• Assist in the maintenance of the product cores and ensuring any code changes made to the core fit with the future direction of the product and are technically sound.

MAIN DUTIES AND RESPONSIBILITIES

• Responsible for designing database solutions to large and complex problems in line with long term product goals.
• Responsible for implementation and release of database changes according to agreed timescales and costs.
• Perform reviews on advanced/complex designs and code changes.
• Responsible for ensuring availability and performance of databases solutions is maximised.
• Responsible for troubleshooting and problem solving of SQL and Oracle development.
• Responsible for improvement and maintenance of the databases.
• Provide mentoring and coaching to the team.
• Provide training and lunch and learns to other teams/team members.
• Perform the role of Lead Developer on large projects.
• Provide assistance solving appropriate complex problems (technically complex and presents various viewpoints) with peers and more junior members of the team during the feasibility and planning stages of the lifecycle.
• Actively seek the identification and mitigation of development risks.
• Perform planning and tracking on large pieces of work.

QUALIFICATIONS/KNOWLEDGE

Essential:

• Oracle Certified Professional (OCP) DBA.
• A solid understanding of database administration with particular focus on Oracle and Oracle Technologies (in particular DataGuard and RMAN).
• The ability to breakdown problems, analysis performance and design the most efficient solutions.
• A solid understanding of High Availability solutions.

Desirable:

• Experience of designing solutions for the airport industry.

SKILLS /EXPERIENCE

Essential:

• Extensive experience of Oracle Database Administration.
• High Availability Oracle solutions, for example Oracle DataGuard.
• Backing up Oracle databases using RMAN.
• Hands-on experience of software development throughout the whole software development lifecycle.
• Integration, testing and deployment experience.
• Experience of Source Control tools (PVCS, SourceSafe, etc)
• Experience of tiered architectures.
• Experience of writing papers and proposals.
• Experience and ability to teach or instruct co-workers.
• Experience of on site work and working with customers.
• Methodologies/Tools/Platforms:
• UNIX (Solaris/AIX/HP, Shell Scripts)
• Windows
• RDBMS development (Oracle)
• Oracle PL/SQL

Desirable:

• Experience of Microsoft Project and developing plans.
• Methodologies/Tools/Platforms:
  • Java
  • .NET, Visual Basic, C#
  • Pro*C

PERSONAL STYLE AND BEHAVIOUR

Approachability  

Is easy to approach and talk to; spends the extra effort to put others at ease; can be warm, pleasant, and gracious; is sensitive to and patient with the interpersonal anxieties of others; builds rapport well; is a good listener; is an early knower, getting informal and incomplete information in time to do something about it.

Composure 

Is cool under pressure; does not become defensive or irritated when times are tough; is considered mature; can be counted on to hold things together during tough times; can handle stress; is not knocked off balance by the unexpected; doesn't show frustration when resisted or blocked; is a settling influence in a crisis.

Customer Focus

Is dedicated to meeting the expectations and requirements of internal and external customers; gets first-hand customer information and uses it for improvements in products and services; acts with customers in mind; establishes and maintains effective relationships with customers and gains their trust and respect.

Managing Diversity

Manages all kinds and classes of people equitably; deals effectively with all races, nationalities, cultures, disabilities, ages and both sexes; hires variety and diversity without regard to class; supports equal and fair treatment and opportunity for all.

Functional/Technical Skills

Has the functional and technical knowledge and skills to do the job at a high level of accomplishment.

Integrity and Trust   

Is widely trusted; is seen as a direct, truthful individual; can present the unvarnished truth in an appropriate and helpful manner; keeps confidences; admits mistakes; doesn't misrepresent him/herself for personal gain.

Peer Relationships  

Can quickly find common ground and solve problems for the good of all; can represent his/her own interests and yet be fair to other groups; can solve problems with peers with a minimum of noise; is seen as a team player and is cooperative; easily gains trust and support of peers; encourages collaboration; can be candid with peers.

Perseverance

Pursues everything with energy, drive, and a need to finish; seldom gives up before finishing, especially in the face of resistance or setbacks.

Self-Development

Is personally committed to and actively works to continuously improve him/herself; understands that different situations and levels may call for different skills and approaches; works to deploy strengths; works on compensating for weakness and limits.

Time Management

Uses his/her time effectively and efficiently; values time; concentrates his/her efforts on the more important priorities; gets more done in less time than others; can attend to a broader range of activities.