Responsibilities of the DBA Specialists include but not limited to:
- Be subject matter expert in at least one of the domains: Oracle or MS SQL
- Responding, resolving and troubleshooting 2nd level Support issues on all IT areas such as desktops/laptop.
- Resolve issues escalated by the 1st level support team
- Diagnose and rectify any problems with installed databases and associated peripherals
- Setup and co-ordinate database maintenance schedules & plans where required
- Prepare relevant documentation to support, give input to the problem and knowledge processes based on daily work experience.
- If assigned to projects, work with project managers to ensure managed system changes/ tasks are completed to meet business requirements.
- Identify the opportunities to improve overall operational performance & saving costs.
- Adherence to MDIT, Group policies and compliance
- Willingness and flexibility to travel as per business needs.
- Be part of the 24/7 rotation scheme
- Create and update SOPs for L2 and L1
- Update and maintain documentation
Skills
- 3-5 years work experience in a similar position
- Self-Motivated with the ability to work independently and with high personal integrity
- Very strong customer service mindset
- Excellent English skills – both Oral and Written
- ITIL foundation certified preferred
- Scripting and/or programing skills preferred
- Mindset for monitoring, automation and self-service
- Oracle and MS SQL DBA skills is a prerequisite
- For the Oracle DBA Oracle Certified Administrator (OCA) is preferred
- Can automate many basic database administration tasks, and ensure that the database runs hands-free, by applying decision rules to detect impending problem and fixing them before they cripple the database.
- Can review an SQL query and understand why it fails or runs too long
- Experienced with root cause analysis in own area
Technologies to support:
- Working experience as DBA on Oracle (EE & Std ONE) and/or MS SQL (Ent & Std.)
- Good knowledge of Office Suite (Outlook, Lync, Word, Excel, Powerpoint)
- Good knowledge of Windows 7 OS and Windows server OS (from 2003 and up)
- Experience with Power Shell is an advantage
- Working experience as a MS AD administrator is an advantage
- Working experience in with the following technologies: MS Active Directory, Cisco Network, SCCM, Virtualization (HyperV and VMware), System monitoring (SolarWinds), Outlook 365, Windows Server 2012 is an advantage.
- Knowledge of HP Servers
- Knowledge of Citrix
- Knowledge Service Now
