Main duties/responsibilities will include:
The job is Oracle software centric and involves understanding business processes and tuning software components to precisely match the requirements. It encompasses below Generic Oracle Database Administration related activities –
1. Consult and Identifying source of problems and propose solutions by liaising with development teams.
2. Develop quality standards and validation techniques for IT software/applications/systems.
3. Proactively Assess and optimize database performance.
4. Implement security policies to protect application data and meet regulatory requirements.
5. Develop computer or information security policies or procedures.
6. Highlight discrepancies concerning software/system quality and make recommendations for improvement.
7. Examine IT system for potential threats to its security and integrity and draw up plans for disaster recovery if security is compromised.
8. Deal with and report on breaches in security.
9. Deal with and report on unusual behaviour of systems.
10. Oracle software related activities like Software Installation, Performance Tuning, Database design & Data Migration
11. Automate critical routine tasks that will help in saving cost for customer.
12. Understand business case and design databases that will meet not only the current but also the future capacity requirements.
13. Develop performance metrics or standards related to oracle database that can be widely deployed across all databases.
14. Coordinate project activities with other personnel or departments.
15. Engage with Oracle Customer support for resolving any faults raised during usage of database.
16. Carry out regular patching and maintenance activities on all databases to fix any security vulnerability.
17. Train users or teams to ensure they get the best out of a database system.
18. Coordinate software or hardware installation
19. Contribute to develop detailed project plans for project.
20. Analyze data to identify trends or relationships among variables.
21. Taking regular backups for data and recovering data in case of any data loss.
22. Managing service as per the agreed Service Level Agreements.
Key skills include:
1. Prior experience doing database administration activities on oracle databases.
2. Understanding internal working on oracle database systems and design and implement data centric solutions
3. Coding/scripting experience in Python, Unix, sql PL/SQL.
4. Ability to debug business critical issues and provide quickest resolution possible.
5. Awareness about non oracle database technology like MS SQL, PostrgreSQL, NoSQL databases
6. GCP or AWS Cloud expertise is a plus
7. Passionate about data and technology
8. Excellent people and communication skills, able to communicate with technical and non-technical colleagues alike
9. Good team player with a strong team ethos
10. Show capability to change, evolve and to learn new tools and techniques and help and encourage others to do likewise