Beschreibung
For our banking client in Zurich, we are looking for a
Application Oracle DBA
Start: ASAP
Duration: 12 months
Location: Zurich
GPP (Global Payment Program) develops and integrates a new distributed payments processing platform with Oracle RAC 11gr2 as primary data-Back End. We are looking for the role of an "Application DBA" to bring in distinct expertise to further optimize the interaction with our database clusters in development & operation.
Responsibilities
In alignment with different stakeholders, ensure the quality in two main focus areas:
Focus on production delivery & quality:
Help to maintain the configuration of the application databases (data objects, database-level, system-specific parameters)
Together with an infrastructure DBA:
Drive production deployments for database-specific activities
Provide production support (performance & throughput issues)
Focus on application design:
- Accompany non-functional and functional testing activities:
- Understand and explain the impact of the application onto the database
- Identify, analyze generic or specific performance bottlenecks in the database and help to get them resolved
- Propose changes to database configuration where necessary
- Accompany development activities:
- Contribute to the application design from a database perspective
- Development of more complex data migrations & cleanup tasks (one-time or automated regular tasks)
- Help to streamline and enhance the database script quality (DDL, DML) in terms of guidance and reviews
- Share knowledge with developers & testing experts to broaden awareness for good and bad habits
Skills:
- Structured and practical approach to database health & performance analysis
- Good skills:
- Any relevant database tools to analyze, tune and operate Oracle databases
- Linux ("RedHat") as underlying runtime platform: Understand the impact of the Oracle database processes onto the underlying OS and hardware (eg, CPU scheduling & consumption, IO & network usage)
Experience & Qualifications
- Must have in-depth experience with the nature of our application: OLTP, high throughput, high concurrency, understand RAC specifics (application does load-balancing in RAC). This originates ideally from a combination of:
- Designated experience as production DBA or production support for OLTP systems with Oracle RAC
- Designated experience in working with application development projects providing consultancy in database-relevant design (throughput & other non-functional aspects)
- Certified in either "Oracle Database 11g Performance Tuning Certified Expert" or "Oracle Database 11g Administrator Certified Professional"
Michael Bailey International is acting as an Employment Business in relation to this vacancy.