Location: Cape Town
Description:
[FONT=\]
S1 (incorporating the business previously known as Postilion) delivers integrated financial services on an open platform to leading financial institutions, retailers, and processors. Our solution family spans payments, online banking, branch banking, and lending.
[/FONT]
Role Definition
Realworld Performance Lab (RPL) is an S1 Payments initiative to simulate a large production system in a laboratory environment with the aim of identifying usability, quality, scalability and performance issues.
The RPL DBA is responsible for supporting the databases that the S1 Payments suite of products (developed in-house) uses that is deployed on the RPL system. This support involves:
· The RPL DBA has to perform detailed analysis of issues that appear to be database related. This analysis will require the RPL DBA to use tools such as SQL profiling tools, Windows Performance Monitor and other utilities provided by the database engine to assist in the troubleshooting process. If an issue requires input from one of the development teams the analysis has to be documented in detail. The RPL DBA might be required to explain the issue verbally to the development team involved.
· The RPL DBA has to do continuous bottom-up analysis (from a database perspective) of the S1 Payments suite of products to identify inefficient/incorrect queries, potential bottlenecks and inefficient database design and to recommend solutions to these problems.
· The RPL DBA has to ensure that the databases are properly maintained to ensure optimal performance and availability of the S1 Payments suite of products.
The RPL DBA has to package all recommendations, lessons learnt and utilities developed for distribution to the wider organization, including Product Engineering and the regional teams. The RPL DBA should also strive to automate as much of these support tasks as possible.
The RPL DBA is also required to perform detailed analysis of issues on client systems that appear to be database related. Although this is not the RPL DBA’s primary task it might be required on an ad-hoc basis.
The RPL DBA has to be involved in discussions with the development teams if new products/features require extensive database changes/design. The RPL DBA should also be available in an advisory capacity if advice regarding database design, inefficient queries, etc. is required.
The RPL DBA has to provide mentorship to other team members by exposing them to the DBA environment and ensuring that skills transfer takes place.
The RPL DBA is responsible for testing and promoting changes (non-database related) to the RPL production environment. Each change has to be documented in detail, tested (regression, unit and performance testing) and applied in the RPL QA/pre-production environment before being promoted to the RPL production environment. The RPL DBA will be responsible for reviewing changes from other team members and should also ensure that the formal change control process is adhered to.
The RPL DBA has to be involved in planning sessions to discuss the roadmap for the RPL system. The RPL DBA might also be required to perform basic project management tasks, including but not limited to:
· Estimating tasks and tracking each task’s progress.
· Ensuring that the team follows the project management methodology being used.
· Escalating to management if tasks are not tracking as expected.
Other tasks related to the job may be required from time to time depending on team/management requirements.
Qualification and Experience
Education and experience
3 years+ relevant university or technikon qualification
3 years+ application database administration experience
Any relevant industry accepted database certification is an
advantage.
Databases
Excellent understanding of relational database design.
Extensive Microsoft SQL Server 2005/2008 experience, including use of SQL Server Profiler and other database engine utilities.
Extensive experience using TSQL for querying, updating, etc. databases.
Knowledge of DB2 is an advantage.
Operating systems and networking
Microsoft Windows server environments and networking. AIX / Linux knowledge is an advantage.
OS command line utilities and scripting.
TCP/IP. Network tracing / sniffing experience is an
advantage.
Knowledge of routers and firewalls.
Using tools like Windows Performance Monitor.
Hardware
Good knowledge of different hardware platforms and server technologies like RAID and SANs.
Exposure to 24/7/365 or “99.999%” uptime environments an
advantage.
Development
Any development experience is an advantage (Java
knowledge in particular).
Environment and communication
Strong written and spoken skills are essential.
Experience in report writing and other written deliverables.
Experience in application support.
Exposure to corporate IT and big business an advantage.
Apply to this job
Description:
[FONT=\]
S1 (incorporating the business previously known as Postilion) delivers integrated financial services on an open platform to leading financial institutions, retailers, and processors. Our solution family spans payments, online banking, branch banking, and lending.
[/FONT]
Role Definition
Realworld Performance Lab (RPL) is an S1 Payments initiative to simulate a large production system in a laboratory environment with the aim of identifying usability, quality, scalability and performance issues.
The RPL DBA is responsible for supporting the databases that the S1 Payments suite of products (developed in-house) uses that is deployed on the RPL system. This support involves:
· The RPL DBA has to perform detailed analysis of issues that appear to be database related. This analysis will require the RPL DBA to use tools such as SQL profiling tools, Windows Performance Monitor and other utilities provided by the database engine to assist in the troubleshooting process. If an issue requires input from one of the development teams the analysis has to be documented in detail. The RPL DBA might be required to explain the issue verbally to the development team involved.
· The RPL DBA has to do continuous bottom-up analysis (from a database perspective) of the S1 Payments suite of products to identify inefficient/incorrect queries, potential bottlenecks and inefficient database design and to recommend solutions to these problems.
· The RPL DBA has to ensure that the databases are properly maintained to ensure optimal performance and availability of the S1 Payments suite of products.
The RPL DBA has to package all recommendations, lessons learnt and utilities developed for distribution to the wider organization, including Product Engineering and the regional teams. The RPL DBA should also strive to automate as much of these support tasks as possible.
The RPL DBA is also required to perform detailed analysis of issues on client systems that appear to be database related. Although this is not the RPL DBA’s primary task it might be required on an ad-hoc basis.
The RPL DBA has to be involved in discussions with the development teams if new products/features require extensive database changes/design. The RPL DBA should also be available in an advisory capacity if advice regarding database design, inefficient queries, etc. is required.
The RPL DBA has to provide mentorship to other team members by exposing them to the DBA environment and ensuring that skills transfer takes place.
The RPL DBA is responsible for testing and promoting changes (non-database related) to the RPL production environment. Each change has to be documented in detail, tested (regression, unit and performance testing) and applied in the RPL QA/pre-production environment before being promoted to the RPL production environment. The RPL DBA will be responsible for reviewing changes from other team members and should also ensure that the formal change control process is adhered to.
The RPL DBA has to be involved in planning sessions to discuss the roadmap for the RPL system. The RPL DBA might also be required to perform basic project management tasks, including but not limited to:
· Estimating tasks and tracking each task’s progress.
· Ensuring that the team follows the project management methodology being used.
· Escalating to management if tasks are not tracking as expected.
Other tasks related to the job may be required from time to time depending on team/management requirements.
Qualification and Experience
Education and experience
3 years+ relevant university or technikon qualification
3 years+ application database administration experience
Any relevant industry accepted database certification is an
advantage.
Databases
Excellent understanding of relational database design.
Extensive Microsoft SQL Server 2005/2008 experience, including use of SQL Server Profiler and other database engine utilities.
Extensive experience using TSQL for querying, updating, etc. databases.
Knowledge of DB2 is an advantage.
Operating systems and networking
Microsoft Windows server environments and networking. AIX / Linux knowledge is an advantage.
OS command line utilities and scripting.
TCP/IP. Network tracing / sniffing experience is an
advantage.
Knowledge of routers and firewalls.
Using tools like Windows Performance Monitor.
Hardware
Good knowledge of different hardware platforms and server technologies like RAID and SANs.
Exposure to 24/7/365 or “99.999%” uptime environments an
advantage.
Development
Any development experience is an advantage (Java
knowledge in particular).
Environment and communication
Strong written and spoken skills are essential.
Experience in report writing and other written deliverables.
Experience in application support.
Exposure to corporate IT and big business an advantage.
Apply to this job