Database Admins/Developers

Database Admins/Developers

Responsibilities Include:

- Working with and supporting individual project teams to help setup and support the deployment framework, which builds, updates and deploys their database schemas into the different environments.
- Helping to support the standardization of the deployment frameworks and quality gateways to ensure consistency and reusability across the various platforms.
- Working with the infrastructure that supports and delivers all parts of the technology stack via automatic deployment methods.
- Occasionally to work directly with vendors in order to resolve technical issues.
- Keeping databases up to date and updating the required documentation.
- Helping with database design and development.
- Managing database access.
- Provide input for maintenance procedures and putting them into operation.
- Review data requirements and ensuring that they meet individual project requirements.
- Managing database security/integrity and backup procedures.
- Implementing security measures.
- Testing and modifying databases to ensure that they operate reliably.
- Providing input on the implementation of disaster recovery plans and implementing them.

Key Technical Skills and Competencies:

- Database Administration skills:
- Oracle Database version 11g management including RAC, DG, ASM, Streams and security.
- Keeping databases up to date.
- OEM including health check of database infrastructures.
- Management of tablespace and datafile usage.
- Knowledge about the usage of AWR reports.
- Knowledge about discussion of service requests with Oracle Support.

Continuous Integration and Automated Deployment skills:

- Should have experience using the following tools to support our deployment process: Subversion, Git, Ant, Maven, Hudson. Familiarity with any of them is desirable.
- Database revision management
- Development performance tuning
- Experience with live production deployments 

Programming skills:

- Advanced Oracle DDL/DML SQL Scripting
- PL/SQL programming
- Thorough clear text documentation of programs and scripts
- Query performance tuning
- Familiarity with tools like AWK is desirable

Server Technology skills (understanding):

- Weblogic Server & Portal, JBoss, Oracle Service Bus, Oracle Business Process Manager, ILOG JRules, Apache.
- Message queue techniques.
- Operating System skills:
- Linux, Solaris, Windows

Development Model & Tools:

- Confluence, JIRA, Agile, Scrum, Kanban