Senior Consultant - DBA
Salary Range: Salary commensurate with experience
Range - $75, 00 - $120,000

BACKGROUND

Company is a Wellington-based company specializing in the design, development, and database administration of systems utilizing Oracle database and tools.

Workload is split fairly evenly between software development, maintenance and support and outsourced Database Administration services. In addition, our organization is accredited as an Oracle Certified Solution Partner and is the sole Value Added Distributor for Oracle in New Zealand. In this role, we foster the use of Oracle within the partner community, and provide a prompt, efficient and personal service to partners.

VALUES

Our organization is committed to embracing the following values:

Integrity: Encompasses the notions of honesty, trustworthiness, impartiality, mutual respect, consistency, fairness and transparency.

Excellence: Refers to the notion of striving for the best, being professional, continually seeking to improve and leading the way in the fields in which we operate.

Collaboration: Refers to people consulting each other, seeking honest feedback, working co-operatively together and negotiating outcomes.

Leadership: Means more than providing direction. It embodies the ability to create and convey a compelling vision that invigorates and excites colleagues to make that vision a reality.

Innovation: Involves seeking creative and lateral solutions, seeing problems differently and finding opportunities that may not be immediately obvious. Adding value for the client.

Client Focus: Delivering a high standard of service to clients; exceeding their expectations. Understanding the client and the client’s business, and using that knowledge to deliver appropriate solutions and service to the client.

DATABASE ADMINISTRATION UNIT OVERVIEW

The role of the Database Administration unit is to deliver outsourced DBA service to clients. In providing these services, the overriding principles of the team are:

• Customer focus
• Service delivery
• Business enablement
• Professionalism
• Added-value
• Client satisfaction

The services delivered by the team are delivered through a combination of:

• Support services work; providing ongoing database, operating system, network, and application server administration services.
• Project-based work; providing DBA services in support of application development projects, undertaking various one-off projects and initiatives.
• System administration; where business systems are monitored and administered on a daily basis.
• In many instances, the DBA unit will work collaboratively with the Development unit to deliver and/or administer a business system.

POSITION PURPOSE

The Database Administration unit is responsible for developing, implementing, maintaining and administering/operating databases, operating system environments, network environments and application server environments.

The primary purpose of the role is to take a senior role in delivering such services.

The secondary purpose of the role is to contribute to the success of the Database Administration practice by taking a leadership role within the practice; specifically in the areas of:

• Capability improvement
• Supervising and mentoring more junior staff
• Managing smaller projects
• Ensuring the quality of deliverables produced for clients, and
• Working to ensure client satisfaction

WORKING RELATIONSHIPS

Responsible To: DBA Team Leader Client Account Managers

Responsible For: Formally – none Informally – team members and more junior staff

Functional Relationships: Sales Team, Management Team, Application Development Team, Clients Vendors & Suppliers

KEY RESULT AREAS -- Job holder is accountable for...

DBA Services - Design and Implementation:

1. Liaise with and support application development teams.
2. Plan for, prepare, install and configure Operating System, DBMS, Application Server and related software products.
3. Plan, prepare and configure administrative tasks, processes and procedures.
4. Manage and install software patches.
5. Manage the implementation of application and/or database changes.
6. Design and develop data migration and /or other data management solutions.

Jobholder is successful when:

• Operating System, DBMS, Application Server and other closely-related infrastructure is designed and implemented effectively.
• Appropriate jobs and processes to manage, secure and sustain the implemented environment are defined and deployed according to appropriate operational standards as expected by the client.

DBA Services – Administration and Support

1. Monitor and manage disk space.
2. Undertake, as required, performance monitoring and tuning for applications and databases.
3. Administer security definitions.
4. Administer operating system and network configurations.
5. Prepare Monthly Reports

Jobholder is successful when:

• Databases and related infrastructure are proactively managed according to best-practice standards.
• Managed components deliver service according to defined operational constraints.
• Regular status and analytical reporting is prepared according to agreed schedules.

DBA Services – On-call and business-hours support

1. Participate in the 7x24 on-call support roster.
2. Provide support, advice and guidance to customers during the business day.

Jobholder is successful when:

• Incidents are responded-to according to contracted service-levels.
• The job-holder is recognized as being approachable, knowledgeable and helpful.

DBA Services – Quality

1. Plan for and undertake appropriate measures to ensure deliverables produced achieve minimum levels of quality.
2. Mentor and coach team members to help them achieve high levels of quality in their work.
3. Actively seek out and implement tools and techniques that assist in delivering better quality deliverables.

Jobholder is successful when:

• Quality is a part of the work process for all projects.
• Deliverables produced achieve a minimum standard of quality appropriate to the project.
• Quality improvement is the status quo.

Client Focus:

1. Undertake database, application or other technical reviews.
2. Prepare, present and discuss specifications, design materials, technical proposals and regular Monthly Reporting.
3. Go the ‘extra-mile’ to ensure high standards of client satisfaction.

Jobholder is successful when:

• The job-holder demonstrates a high standard of client focus and demonstrates added-value.
• The job-holder maintains ongoing contact with appropriate clients.
• Clients have confidence in the standard of activities performed by the holder, and in the quality of deliverables produced.
• The client appreciates the focus applied to the role by the job-holder; and recognizes the value of maintaining ongoing services supplied by company.

Organizational Capability:

1. As required and as time permits, develop and maintain appropriate methodologies, structures, toolsets, and best practice standards for database administration.
2. Maintain currency with industry best-practice and trends. Participate in setting direction of service offering to the market.

Jobholder is successful when:

• The job-holder delivers capability improvement initiatives as agreed in the annual performance objectives setting process.
• The job-holder is recognized by more junior staff as a leader, and by managers as demonstrating the desired attributes of a senior practitioner.
• The job-holder maintains currency in technology trends.

Revenue:

1. Understand and promote the business objectives
2. In conjunction with the sales team, identify opportunities for additional or cross-sales.

Jobholder is successful when:

• The job-holder demonstrates an understanding of the practical realities of a commercial organization.

Note: The above performance standards are provided as a guide only. The precise performance measures for this position will need further discussion between the jobholder and manager as part of the performance development process.

The employee may be required to perform other duties within the range of their skills and knowledge from time to time, and must follow any lawful instruction of the employer.

PERSON SPECIFICATION

Qualifications

Essential: Tertiary degree

Desirable: Oracle Professional certification

Knowledge/Experience

• Expertise and experience of Oracle Database Administration technologies, tools, and best practices.
• Expertise with SQL and PL*SQL.
• Expertise of best practices in the management of data for optimal recoverability and integrity; and in the conversion and migration of data.
• Knowledge of Oracle Application Server, and related operating system and network technologies.
• Understanding of a Systems Development Lifecycle, preferably RUP.
• Experience leading and mentoring others § Experience providing on-call support services.
• Excellent problem diagnosis and investigation skills.
• Understanding of the objectives and mechanics of a professional services organization.
• Solid written and oral communication skills.

Personal Attributes

• Drive and initiative
• Ability to apply focus on customer needs
• Ability to think logically and clearly; ability to rapidly understand business drivers and processes
• Ability to react calmly under stressful situations
• Able to take responsibility and ownership for issues, and attempt to resolve it without supervision
• Able to present a vision clearly to customers, coupled with an ability to accept feedback and criticism
• Ability to communicate calmly and easily with stakeholders at all levels
• A professional and customer-focused attitude
• Interest in business problems and issues that drive IT initiatives

Expected Behaviors

Achievement Focus:
A person demonstrating this competency shows honesty, professionalism, reliability and dedication to achieve results. They readily adjust to change and to different perspectives, think proactively and seek opportunities to build service excellence.

Communicating Effectively: A person demonstrating this competency will use language and style appropriate to the audience and context.

Creating Value for Customers: All jobs exist to provide services for customers. Business objective is to be recognized as an organization that adds real value to our customers.

Working Together: A person demonstrating this competency works constructively with people to achieve a common goal.

Applying Expertise: A person demonstrating this behavior will have the knowledge and skills to perform the requirements of the position.

Leadership: A person demonstrating this behavior supports and inspires others to achieve the best outcomes possible.

Developing Staff: A person demonstrating this behavior builds an environment that is focused on enhancing the skills and performance of individuals and teams.

⇒Go Back