Job Purpose
The position is responsible for leading the design, implementation and maintenance of Britams data architecture and contributing to Britams data governance and data analytics strategic initiatives.
This role is primarily responsible for the design, installation, management, monitoring and maintenance of the Britam Group enterprise databases including Oracle & Microsoft SQL databases.
Oracle E-Business Suite (EBS) applications administration including installation, management, monitoring and maintenance of the following applications;
Siebel CRM
Oracle Financials (ERP)
Oracle Human Capital Management (HCM) ERP
Oracle Supply Chain Management (SCM) ERP
Oracle Fusion Middleware (SOA Suite, Identity Management, WebLogic, Business Intelligence, BPM)
Responsible for all service level agreements (SLAs) for database services across the organization including Uptime/Availability, Backups & Restores, MTTR, Issue Resolution etc.
Responsible for leading the design, implementation and maintenance of Britam’s data architecture and contributing to Britam’s data governance and data analytics strategic initiatives.
Key Responsibilities
Providing support to systems developers and interfacing with business users to ensure the database is satisfying business requirements;
Define service level agreements (SLAs) both internally and externally. Define metrics to ensure we are meeting those SLAs and holding the support team accountable;
Monitor SLA performance for compliance with organizational needs and requirements, including follow-up checks for corrective action;
Support strategic projects with business partners and systems groups providing technical services on a wide range of database technologies running on IBM AIX, UNIX, Linux, Solaris and Windows platforms to ensure operational excellence. Builds DB schemas and structures based on customer needs and established standards;
Work in a team environment and provide knowledge sharing to entire IT department;
Recommend improvements to processes and procedures to increase productivity, reduce maintenance cycles, and improve quality delivery.
Ensure appropriate documentation is created and maintained for projects and operational procedures;
Support and maintain backup and recovery activities and processes utilizing Oracle RMAN (Recovery Manager). At times this will require the incumbent to create and maintain UNIX Shell scripts for automation of Oracle RMAN backup and recovery, and cloning of applications and database instances, monitoring etc;
Provide on-call support to production environments including night time, holiday and weekend support as and when required;
Participate and provide support to testing activities for projects and monthly maintenance. Cloning DEV and TEST from PROD and coordinating regular backup integrity testing;
Perform software change configuration management functions through program standard tools to deploy approved changes to applications and database environments;
Work with Hosting Service provider for server, storage, network, and firewall requirements;
Perform installation, patching and upgrade of applications, databases, and tools across the technology stack to maintain the system health for all databases (Patch management & Version Control);
Apply database and application performance monitoring & tuning techniques for keeping all environments at optimal performance;
Uses data and DB processes and procedures for daily tasks such as log analysis;
Implement and maintain database security (create and maintain users and roles, assign privileges). Evaluates Security Auditing and Maintaining server and DB permissions;
Documents business continuity plan processes and procedures. Implements and maintains transactional replication for the DB environment (MSSQL Clustering, Oracle DataGuard, Oracle RAC, GoldenGate etc.); and
Troubleshoots and resolves DB integrity issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues etc. Interface with Oracle Corporation for technical support.
Degree in IT, MIS, Engineering or Computer Science
Oracle Certified Database Administrator
Microsoft Certified Database Administrator
Working knowledge of ITIL
Minimum of 5 years’ Apps DBA experience in a 24×7 service provision environment
Working experience with Oracle EBS & Fusion Middleware applications is a must
Demonstrates ability to solve moderately complex technical problems independently
Good verbal and written communication skills
Essesntial competencies
Deciding and Initiating Action: Ensures, key organisational objectives are met, takes responsibility for decisions, actions, projects and people while focussing on achievement of strategic results; takes initiative and works under own direction; initiates and generates activity; makes quick, clear decisions with limited information available which may include tough choices or considered risks; decisions and actions takes into account possible impact on all parts of the business.
Leading and Supervising: Provides the business with a clear direction based on the overall strategic intent of the organisation; motivates and empowers others with a clear sense of purpose; creates a positive organisational climate that fosters learning and development; acknowledge high potential talent; sets and articulates the vision and values through own personal behaviour.
Relating and Networking: Easily establishes, as well as assists others in building good relationships with customers and staff across all departments, inside and outside of the organisation; relates well to people at all levels; facilitates the resolutions of conflict and manages disagreements with tact and diplomacy.
Persuading and Influencing: Gains clear agreement and commitment from others by persuading, convincing and negotiating to the benefit of the organisation, promote the organisational strategy during conversations; makes effective use of political processes to influence and persuade others; promotes ideas on behalf of oneself, the department or the organisation; makes a strong personal impact on others; takes care to manage the organisation’s impression and brand on others.
Formulating Strategies and Concepts: Works strategically to realise organisational goals; sets and develops organisational strategies; identifies, develops positive and compelling visions of the organisation’s future potential; takes account of a wide range of issues across, and related to, the organisation; encourage others to take a strategic and long term view in terms of the organisation’s future; communicates the organisational strategy, vision and objectives effectively across all levels of the organisation.
go to method of application »
