Oracle DBA Manager
Oracle DBA Manager We have a fantastic opportunity for an experienced and professional Oracle DBA Manager to be a key member of the IS 1st Line Management Team. The Oracle DBA Manager will be managing and over-seeing high quality levels of database services, Providing IT assistance and support, Chief Technical architect involving the design, management, support and control over development of all databases, primarily support and maintenance of the Oracle eBusiness suite (currently R12.1.3 hosted on an HP RedHat Linux VMWare) and BI, with a large footprint of modules covering Manufacturing, CRM and Financial Applications. The experience gained in the position could open up opportunities that lead to future roles in IS Management. Summary of Position - Hands-on senior DBA responsible for management, task assignment, prioritization of tasks, training, developing and coaching a team of three DBAs. - Very closely liaising with 1st Line Management, IS Staff, Functional Support, Functional Line Management over infrastructure strategy and issues. - Responsibility for database back-up and recoveries, Disaster Recovery strategy, testing and documentation. - Contributing to the development of IS and Business Systems strategy and policies for the business influencing and initiating developments required to improve current and future service. Planning and implementing processes to take forward the strategy and policies. - Working on Projects and enhancements, mostly part time, as member of project team. - Maintaining an in-depth knowledge of Oracle DBA technical issues, providing expert advice reference database applications. Experience and Skills required performing this Job: - Qualified with degree in computing discipline with minimum 5 years Oracle E-Business Applications (11i/R12) DBA experience in Oracle RDMS 11g R2 with RAC ASM /RedhHat Linux /Windows /HP SANS gained in production, test and development environments. - Evidence in career history of sound experience and significant responsibility on Oracle E-Business implementations and upgrades, including, cloning, performance tuning and resolution of crisis situations such as database crashes. Backups and recoveries using RMAN, Veeam and Netbackup. - Extensive knowledge of the Oracle toolset. - Excellent understanding of Oracle patching techniques, Opatch and Adpatch utilities, problem resolving, Metalink and SR logging. - Knowledge of architecture and operating of Oracles BI environment. - Complete commitment to satisfying the security and uptime requirements of all database systems with rapid restoration of services after down-time. Utmost dedication and flexibility over working arrangements to support existing systems and meeting business led project deadlines. - Highly customer focused and self-motivating, committed to the needs of the business. - Be able to deal with highly complex work activities. Ability to think clearly and concisely, work accurately and rapidly when under intense pressures. - Have a "can-do" attitude and when dealing with customer issues. Promote a sense of urgency on prioritisation and immediacy in effort undertaken. Must command respect of peers, be excellent at both written and verbal English interpersonal communications skills, with IT and non-IT staff. - Good strong documenter with dedicated commitment to producing timely quality outputs. Experience of working within a controlled environment with good understanding of control processes and procedures. - Staff Management capabilities. - Good SQL and reasonable PL/SQL knowledge. - Understanding of Oracle software licencing issues. - Having worked within manufacturing or distribution company environment would be extremely beneficial. - R12.2 experience beneficial. Activities: - Complete authority and responsibility for all DBA work, accountable for all actions. - Involves management of databases and applications. Live and test applications including providing ad-hoc Oracle DBA and Oracle Apps R12 DBA support. - The management of all changes to the components of the live infrastructure, from Supportworks Helpdesk Tickets through to implementation and review, to support the continued availability, effectiveness and safety of the infrastructure. - Perform Oracle installations and upgrades, cloning and refreshes for Project teams, whilst providing Oracle related technical support for all relevant teams, working closely with Business Systems Developers and Analysts, Systems Accountant, Systems Operations Support Team, Functional Business Analysts in producing developments that assist in the continual improvement of business processes and execution of the company business. - Supporting and maintaining existing systems, including bug fixing and receiving and recording problems and providing resolutions. - Application of database security patches. - Initiate the development of systems to monitor, measure and report on service delivery, identify any changes to business and service requirements. - Management and maintenance of all Oracle passwords. - Sharing information on emerging database trends and new technologies, and identify areas for improvement. - Managing, assisting, developing and guiding DBAs and more junior IS department staff. - Perform such other duties and responsibilities appropriate to this position. - Understanding of VMWare i.e. VM creation from templates, snapshots and storage maintenance Availability: - Must be available to work hours required to resolve urgent problems. Will be required to carry a company mobile phone and on occasions of emergencies, be available for call out 24 hours a day. Will be part of DBA Rota for Standby and Call-Out. Training: Appropriate and extensive on-the-job training and internal / external courses will be provided as and when necessary to meet business objectives and personal aspirations through formal, documented, PDS (Personal Development Scheme) reviews. Career Prospects: The experience gained in the position could open up opportunities that lead to future roles in IS Management. Salary Range: £55k - £65k dependent on experience Overtime is not payable With agreement, any significant out of hours work can be off-set against future Lieu Time. Location: Should reside within 60 miles radius of Chard, or be prepared to re-locate. Mobility: Clean driving license. Ability to react quickly to reach Chard site.