SQL Database Administration Consultant
JOB DETAIL
UNICC is committed to achieving diversity and inclusion within its workforce, providing an environment that reflects the values enshrined in the Charter of the United Nations and encourages all qualified applicants, irrespective of gender, nationality, disabilities, sexual orientation, culture, religious and ethnic backgrounds to apply. UNICC is dedicated to the SDGs, making SDG-5 (Gender Equality) and SDG-10 (Reduce Inequalities) the organization goals.
https://www.un.org/sustainabledevelopment/sustainable-development-goals/
The objective of the Centre is to provide trusted ICT services and digital business solutions to its Clients and Partner Organizations.
Background information:
As part of the Database Services Team within the Oracle Unit (OPOU), the SQL Database Administration Consultant will be responsible for delivering ongoing database administration and support for SQL Server services.
Main duties and responsibilities:
The incumbent will work under the supervision of the Lead, Database Services team (OPOU), and will be in close collaboration with the Database Services team.
- Following the team’s best practices, manage and prioritize tasks assigned to Database Services Team, including service requests, change requests, incidents, problem investigation, projects and other tasks as required for keeping SQL Server database services up and running properly
- Monitor and take ownership of tasks assigned to SQL Server database team, ensuring completion within SLA targets
- Follow-up on problem management cases including problem detection, logging, categorization, investigation, diagnosis and complete resolution plans
- Perform installation and configuration of standalone and high-available SQL Server infrastructures hosted at UNICC or customer datacenters and in Cloud – Microsoft (Azure), Amazon (AWS) and Google (GCP), in accordance with established change management processes
- As per established procedures within the team, conduct the following operations:
- Collaborate in maintenance and outage resolution with the infrastructure and business groups
- Creation and configuration of databases, users, permission and SQL Server Agent jobs
- Configuration, synchronization and support of SQL Server disaster recovery environments
- On-going patching and upgrades of SQL Server instances
- Operational support and maintenance of SQL servers hosted at UNICC or customer datacenters and in cloud environments
- Perform parallel migrations of SQL Server database environments
- Conduct SQL Server storage and VLAN in place migrations
- Feasibility assessment, implementation, deployment and support of SQL Server services in customer datacenters, and in Cloud
- Conduct documentation of operating processes, procedures and installations including technical diagrams and infrastructure setup
- If and when required, provide on-call support services outside business hours
Recruitment Profile
Experience and Skills required:
Essential:
- Four (4) or more years of working experience in SQL Database Administration
- Experience in Microsoft SQL Server 2014, 2016, 2017, 2019 & 2022
- Good understanding of one or more of the following Cloud services: Microsoft (Azure), Amazon (AWS) and Google (GCP)
- Experience On-premises and in Cloud, using technologies such as Azure SQL database, Azure SQL Managed Instance and AWS RDS
- Experience in High availability solutions including SQL Server Always On technology, Failover Clustering (FCI), and Availability Groups (AG).
- Experience in Disaster recovery technologies including database mirroring and transaction log shipping
- Experience in SQL Server Reporting Services (SSRS), Analysis Services (SSAS), Integration Services (SSIS), and Master Data Services
- Experience in SQL Server Replication technology including snapshot, merge and transactional replications
- Experience in SQL Server backups and database recovery procedures including the ability to recover user and system databases from failed processes and engine crashes
- Good scripting skills using PowerShell and Transact-SQL
Desirable:
- Experience with data storage virtualization technologies
- Experience with Windows failover clusters
- Experience with Linux and MySQL replication
- Experience with Ansible or other automation technologies
Education:
Essential:
- High school diploma supplemented by training in Database Systems Administration
Desirable:
- First university degree in Information Technology or related field
Languages:
- English: Expert knowledge is required
UNICC Global Competencies:
- Teamwork: Develops and promotes effective relationships with colleagues and team members. Deals constructively with conflicts.
- Communicating: Expresses oneself clearly in conversations and interactions with others; listens actively. Produces effective written communications. Ensures that information is shared.
- Respecting and promoting individual and cultural differences: Demonstrates the ability to work constructively with people of all backgrounds and orientations. Respects differences and ensures that all can contribute.
- Knowing and managing yourself: Manages ambiguity and pressure in a self-reflective way. Uses criticism as a development opportunity. Seeks opportunities for continuous learning and professional growth.
- Producing results: Produces and delivers quality results. Is action oriented and committed to achieving outcomes.
- Moving forward in a changing environment: Is open to and proposes new approaches and ideas. Adapts and responds positively to change.
Other Information
Compensation:
Fee will be based either on the National Officer salary scales or the Individual Consultancy band levels (for Headquarters)
- National Officer Salary Scale
- For headquarters, Individual Consultancy band levels will be used
Closing date for applications:
Applications will be accepted until midnight (Geneva Time) on the 14 April 2025
Notes:
- Technical and/or personality tests may be carried out as part of the selection process
- Only short-listed candidates will be contacted
- Though you may not be selected for this advertised position, the UNICC will keep your application in a roster if your profile is deemed to be of potential interest for the Centre. You may thus be solicited by our HR department to participate in an interview for another position
The UNICC workforce consists of many diverse nationalities, cultures, languages, and opinions. UNICC seeks to sustain and strengthen this diversity by ensuring equal opportunity and an inclusive working environment for its entire workforce. Applications are encouraged from all qualified candidates without distinction on grounds of race, ethnicity, sex, national origin, age, religion, disability, sexual orientation and gender identity.
For applications to be valid, they must contain a motivation letter and the filled Personal History Form.
