afotakel Posted December 9, 2016 Report Share Posted December 9, 2016 wipo.taleo.net/careersection/wp_2/jobdetail.ftl?lang=en&job=16328 (FT) Database Specialist - 16328 (FT) Systems Management and Integration Section, IT Technical Division, Administration and Management Sector Grade - P4 Contract Duration - two years * Duty Station : CH-Geneva Publication Date : 09-Dec-2016 Application Deadline : 13-Jan-2017, 11:59:00 PM IMPORTANT NOTICE REGARDING APPLICATION DEADLINE: please note that the deadline for applications is indicated in local date and time. 1. Organizational context The post is located in the System Management and Integration Section, IT Technical Division, Information and Communication Technology Department, Administration and Management Sector. The primary responsibility of the Section is to provide efficient and cost-effective ICT platform services that fulfill the essential business and technical requirements for hosting the Organization’s complex and diverse business-critical systems. As the Organization’s fee-generating services almost exclusively rely on such systems to receive and process information online, major underlying considerations for the Section are security and performance, ongoing system consolidation, the use of standardized solutions and a progressive move towards integrated ICT architectures for sustainability. The objective of the Section is to manage information security controls with respect to server platforms, firewalls and Internet and to ensure that business systems can be used as integrated services and meet the business requirements as a whole, regardless of the intricacies and interdependencies of the underline technical systems. The main role of the incumbent is to provide database support for WIPO business systems and applications, coordinate secure database administration activities, oversee the maintenance of WIPO’s database systems and lead ICT service continuity related activities. The incumbent works under the supervision of the Head of the System Management and Integration Section. 2. Duties and responsibilities The incumbent performs the following main duties: (a)Provide expertise on database facilities for architecture, design and development, performance tuning and integration of business applications. Draft and maintain procedures and documentation for databases. Collaborate with the Security and Information Assurance Division on the setting of standards for definition, security and integrity of database objects and ensures conformity with these standards. Monitors database activity and resource usage. (b)Identify performance errors and service incidents and coordinate the debugging process with application owners and service providers. Define, validate and manage controls for operational alerts, query optimization, use of indexes and database connections, scheduling of resource-intensive queries or scripts etc. that need to be applied to ensure adequate performance and to minimize operational risks. Ensure clear delineation of roles and responsibilities between WIPO and service providers. ©Analyze system utilization and plan for database system upgrades and resource extension to meet growing capacity needs. Review and validate change requests, including, but not limited to database system updates/upgrades, raised by service providers and WIPO application custodians. Plan and coordinate large scale interventions involving multiple parties including different WIPO business areas and the service providers; (d)Regularly review and enhance database backup and archiving strategy and monitor the implementation of database backup policies from the point of view of performance and conformity with defined business requirements (including service recovery targets: RPO/RTO); (e)Design the ICT Disaster Recovery (DR) Plan and related procedures and processes. Lead ICT resiliency/high availability activities, including the coordination and organization of periodic service continuity tests. Liaise with and provide feedback to WIPO’s Business Continuity (BC) function. Ensure that ICTD BC/DR is aligned with the Organization’s resilience policy and strategy. (f)Collaborate with the Security and Information Assurance Division for the development of operational processes and control mechanisms that support information security policies and standards for the business systems and ensure that they are suitably implemented and maintained for all production systems in the area of responsibility; (g)Apply agreed ITIL service support processes, in particular incident, problem, configuration, change, and release management and make recommendations to the Head of the Section for service and operational improvements. (h)Manage IT projects assigned to the Section in line with WIPO standard project management practices as well as Prince2 methodology. (i)Oversee and measure the fulfillment of contractual obligations of service providers. Monitor and challenge service provider performance and identify opportunities for continuous improvement. Develop strategies to address under-performance and compliance failures, including application of contract terms. Identify where changes are required, evaluate the impact, and advise stakeholders about the implications and consequences for the business. Negotiate variations and seek appropriate authorization. Actively support and engage with experts and stakeholders to ensure continuous improvements are identified through review and benchmarking processes. Develop and implement change management protocols. (j)Perform other duties as required. 3. Requirements Education: Essential: Advanced university degree, preferably in Computer Science, Engineering or related discipline. A first-level university degree plus two years of relevant experience in addition to the experience requested below may be accepted in lieu of an advanced university degree. Desirable: Specialized training or certification in Oracle Database systems. Training or certification in at least one of Microsoft SQL Server or MySQL Database systems. Experience: Essential: At least nine years’ professional work experience in managing large Oracle database system environments. Experience with architecting, designing, implementing and maintaining Database cluster systems, such as Oracle RAC. Desirable: Experience with managing at least one other type of database system (MySQL or MS SQL). Experience with the development and testing of ICT infrastructure disaster recovery capabilities. Experience in the secure configuration and deployment of open-source solutions in an enterprise environment. Experience with vendor performance / contract management. Languages: Essential: Excellent knowledge of written and spoken English. Desirable: Knowledge of French or other UN languages. Job-Related Competencies: Essential: Excellent knowledge of database administration and database server management in an Oracle RAC environment. Excellent knowledge of application development, database application integration and troubleshooting of application integration or performance related issues. Knowledge of ITIL Service Management methodology. Knowledge of Networking and Information Security concepts. Knowledge of System Administration and Operating Systems configuration. Excellent analytical skills and the ability to document complex ICT platforms and processes, as well as related operating and risk management procedures. Ability to clearly explain complex issues, and communicate with technical actors, and business area representatives. Service orientation and attention to quality. Ability to work under pressure and successfully prioritize tasks in order to manage multiple commitments and deadlines. Excellent communication and interpersonal skills, with the ability to clearly explain complex issues, and communicate with technical actors, and business area representatives. Proven ability to coordinate and collaborate with technical teams; managing in a cross cultural environment. Desirable: Knowledge of Linux System Administration (RHCT/RHCE), and administration of MySQL or MS SQL databases. Knowledge of PRINCE 2 project management methodology. Knowledge of Enterprise Architecture concepts. Advanced knowledge of Computer programming and Programming Languages. 4. Organizational Competencies 1.Communicating effectively. 2.Respecting individual and cultural differences. 3.Showing team spirit. 4.Managing yourself. 5.Producing results. 6.Embracing change. 7.Respecting ethics and values. 5. Information Mobility: Candidates appointed to an international position with WIPO are subject to mobility and may be assigned to any activity or duty station of the Organization throughout the world. Annual salary: Total annual salary consists of a net annual salary (net of taxes and before medical insurance and pension fund deductions) in US dollars and a post adjustment. The post adjustment (cost of living allowance) is variable and subject to change without notice in accordance with the rates as set within the UN Common System for salaries and allowances. The figures quoted below are based on the December 2016 rate of 80.0% P4 Annual salary $69,032 Post adjustment $55,226 Total Salary $124,258 Currency USD Salaries and allowances are paid in Swiss francs at the official rate of exchange of the United Nations. These are subject to change in view of the entry into force of the new common system compensation package on January 1, 2017. Please refer to WIPO’s Staff Regulation and Rules for detailed information concerning salaries, benefits and allowances. Additional Information * Initial period of two years, renewable, subject to satisfactory performance. No fixed-term appointment or any extension hereof shall carry with it any expectancy of, nor imply any right to, (further) extensions or conversion to a permanent appointment. This vacancy announcement may be used to fill other posts at the same grade with similar functions in accordance with Staff Rule 4.9.4. Applications from qualified women candidates are encouraged. The Organization reserves the right to make an appointment at a grade lower than that advertised. ___________________________________________________________________ By completing an application, candidates understand that any willful misrepresentation made on this web site, or on any other documents submitted to WIPO during the application, may result in disqualification from the recruitment process, or termination of employment with WIPOat a later date, if that employment resulted from such willful misrepresentations. In the event that your candidature is shortlisted, you will be required to provide, in advance, a scanned copy of an identification and of the degree(s)/diploma(s)/certificate(s) required for this position. WIPO only considers higher educational qualifications obtained from an institution accredited/recognized in the World Higher Education Database (WHED), a list updated by the International Association of Universities (IAU) / United Nations Educational, Scientific and Cultural Organization (UNESCO). The list can be accessed through the link: http://www.whed.net/. Some professional certificates may not appear in the WHED and these will be reviewed individually. Additional testing/interviewing may be used as a form of screening. Initial appointment is subject to satisfactory professional references. Additional background checks may be required. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.