MSSQL Database Administrator

Blackrock, Co Dublin

€75,000 Plus Benefits (see below)

Our client is a solutions provider for the Software as a Service (SaaS) market, using the internet as a delivery platform to revolutionise the way businesses manage their accounts. They are now looking for an MSSQL Database Administrator to join their team in an initially home based position until COVID-19 restrictions allow a return to our Blackrock office.

If you are a proven, certified SQL Server DBA, this is a fantastic opportunity to grow and develop with our client’s organisation and deliver outstanding database solutions.

Your Role

As an MSSQL Database Administrator, you will be responsible for:

- Ensuring high levels of performance, availability, and security of our client’s production database platform on Azure

- Providing level 2 administration/support work to MS SQL databases on our client’s production platform

- Writing SQL scripts to facilitate the diagnosis and resolution of issues in real time

- Constantly managing the database platform according to best practices, providing recommendations and implementing improvements

- Working with Engineering Team on database design and implementing changes as part of the normal software development process

- Analysing SQL Level Performance and providing recommendations

- Co-ordinating team resources to effectively manage projects, incidents and problems

- Mentoring/leading other team members

- Managing disaster recovery, backup and restore processes for SQL Server on Azure platform

- Learning and adopting the latest technologies and tools and making recommendations

- Managing and monitoring SQL jobs and SSIS packages

About You

To be considered as an MSSQL Database Administrator, you will need:

- At least five years’ verifiable track record as a SQL Server DBA including performance monitoring and performance tuning of existing databases and database backups

- Expert knowledge of MS SQL Server, T-SQL and experience with running SQL Server on Microsoft Azure Managed Instance

- Experience with database migration projects (e.g. version upgrades) and data centre migration

projects

- Experience with database design and working with a software engineering team implementing

changes

- Experience with disaster recovery solutions.

- Knowledge and experience of building and supporting SSIS packages

- Experience of leading and/or mentoring other team members

- MSSQL certifications

- A degree in a relevant IT related discipline

Fluent English is required for the role.

You must have access to right to work documents and/or an EU Passport or Stamp 4 visa.

You must be able to attend physical office location in Blackrock Dublin (post Covid).

Experience in working with source control and continuous delivery would be beneficial to your application. Experience in Microsoft data tools and database solutions would also be advantageous, as would previous experience with Azure Monitoring.

Other organisations may call this role SQL DBA, Database Administrator, Database Developer, SQL Server Engineer, MS SQL Server DBA, or SQL Database Administrator.

But what’s in it for you?

- A friendly and supportive culture

- Ongoing subsidised professional development

- Company pension

- Access to Employee Share Ownership Scheme

- Flexibility in terms of working from home

- Taxsaver Public Transport Travel Scheme

Webrecruit Ireland and our clients are equal opportunities employers, value diversity and are strongly committed to providing equal employment opportunities for all employees and all applicants for employment. Equal opportunities are the only acceptable way to conduct business and we believe that the more inclusive our environments are, the better our work will be.

To apply for the role of MSSQL Database Administrator, please apply via the button shown. This vacancy is being advertised by Webrecruit Ireland Ltd. The services advertised by Webrecruit Ireland Ltd are those of an Employment Agency.

• • Client facing role being the lead between client and the team.
  • 
    Manage upgrades, design queries, retrofits, integrated and remote support, management or parts, production performances, maintenance etc.
    
  • 
    To take ownership of the clients and manage accordingly
    
  • Assess performance

• Full driving license
• Solid experience of automated machinery within a manufacturing/ automated sector ideally pharma, automotive or FMCG but others are accepted.
• 
  Ideally used to travelling and staying away from home for small periods
  
• 
  Proven management of projects
  
• Engineering background and freely able to understand automated installations, upgrades, design related queries etc.

• Min of 3 years+ experience in Recruitment role in a Consultancy or Agency,
• Recruitment of / knowledge in an Engineering related discipline essential.
• Excellent experience and understanding of modern sourcing methodologies
• High Fill ratio of jobs.
• Great follow through, proven experience in Client delivery & wiling go the extra mile to find the right person.
• Energetic, interested in being part of an innovative and growing firm with a huge vision.
• Fully authorized to work in ROI.

• Attractive Basic Salary.
• Uncapped upward scaling commission structure up to 20% on an annual basis.
• Flexible benefits package (% of your salary is allocated to the option you choose)
• 21 days Annual leave ( Increase by one day for each year of service)
• Your Birthday off
• Half day each year for Christmas Shopping
• Mobile Phone
• Engage in our ‘Love to Learn’ programme for professional qualifications such as MBA, Degree, Diploma, Certificates.
• Employee wellness programmes
• Flexible working arrangements.
• A healthy work life balance
• 100% Club
• Quarterly company meeting
• Annual Company Employee Event
• Prizes & competitions throughout the year.
• Opportunities to participate and/or lead internal projects/ team such as Great Places To Work, CSR, Innovation Committee.
• Supported by a Business Development Manager who hunt & win new clients, an Internal Marketing Department who will promote your specialist division.
• Business support who will post your job ads!!

• Responsible for project management activities for the Information Security Team including project definition, documentation, creating and execution of project plans and coordination with other teams as well as project cost management, resource management and reporting.
• The candidate in this role will work with and / or lead implementation consultants, internal implementation teams and internal business organizations to define, document, and present process standards and methodologies.
• The candidate in this role will work with other Internal IT Staff to implement/upgrade/maintain security solutions.
• Train user groups and provide support for new software implementations
• Work with various user groups to develop project presentations to be used with senior management for status reporting, negotiations, and decision making.
• Develop training materials and project presentations in support of projects and department initiatives.
• Assist in the coordination of troubleshooting activities to resolve business process issues and the successful transition of implementations from development and testing through production and post-implementation support.
• Analyze, document, and communicate requirements and work with technical leads to develop an appropriate solution. Create clear and concise functional requirements documentation
• Map complex processes including control points, key data and reporting elements, process training documentation and system interfaces
• Participate in technical reviews to ensure project goal(s) are maintained throughout the project.
• Create, maintain and execute required test case scenarios and use cases to verify requirements
  Develop, maintain, and generate reports for projects, process support, application support, internal training, project expenses, and department initiatives
• Develop project presentations for status reporting, negotiations, and decision making appropriate for a range of audiences.
• Train user groups. Develop training materials, quick guides, and project presentations in support of projects and department initiatives
• Troubleshoot, support and maintain multiple Security Application Operating Systems and Application issues which affect Security Processes

• 5 years experience supporting IT Security tools and applications including Firewalls.
• Bachelor's Degree in Computer Science or related field.
• Process documentation, flow charting and re-engineering experience.
• Some Project Management Experience a plus .
• Encryption technologies and PKI infrastructure
• Knowledge of Information Security regulatory requirements, codes and industry guidance such as such as NIST 800-53, ISO27001, CIS and Cobit.
• Ability to utilize resources to contribute valuable input to Information Security projects and Risk Assessments, e.g. ISACA, CIS, FS-ISAC.
• Networking technologies (TCP/IP/etc…) and protocols (SSL, SSH, LDAP, SMTP, DNS, etc.).
• Unix, Linux, and Windows Operating Systems
• Microsoft Active Directory.
• Familiarity with security monitoring concepts.
• Administration of more than three of the following CyberArk, O365, Proofpoint, Nexpose, Qradar, Ivanti Application and Device Control, Varonis, Sharepoint, Palo Alto and Checkpoint Firewalls, Imperva DAM/WAF.
• Strong verbal and written communication skills.
• Ability to communicate effectively to all levels in the organization and adapt information delivery based on audience.
• Ability to communicate information security concepts across a broad range of technical and non-technical staff.
• Ability to multitask and work under tight deadlines.
• Ability to raise awareness and issues to executive leadership, engage leaders and stakeholders in understanding their roles in delivering enterprise Change, Configuration and Release Management process.
• Good communication and written skills.
• Self motivated and ability to work within stringent time frames.
• Strong analytical and investigation skills.
• Strong team player.
• Experience dealing with both technical and non technical staff.
• Weekend and late night work will be required on occasion for support.

Content Specialist - EMEA
Cork

Working for a multination networking company who are looking to hire a Digital Content Specialist to support their EMEA Brand online.

Ensure product content is always up to date, new product information is posted on time, ensure consistency across all countries across EMEA and grown profit and sales volume for the company. The role is a combination of project manager and digital design, production and SEO optimization.

Duties include:
• Project manage execution of all New Product Introductions (NPI) across EMEA - both consumer and business-to-business solutions.
• Project manage and produce all digital content projects across EMEA - plan, track and execute these deliverables on a daily basis.
• Work with each country account manager to ensure local language accuracy, responsible for ongoing SEO and product page variation updates.
• Develop content, assist with localisation of, and manage execution of product page content for EMEA-specific products where content has not originated in the US.
• Update and maintain brand stores across Europe
• Design and develop creative assets for Search and Display advertising.

Skills/Qualifications:
• Highly proficient in Adobe Photoshop, Illustrator
• 3+ years’ experience in editing photography/typography/illustration
• 3+ years’ experience project managing a high volume of marketing tactics, with the ability to provide daily, up-to-date status on any given project
• Experience with editing videos ideal but not essential
• Background in light technical writing, marketing would also be ideal but not essential

Please email your CV to modriscoll@sigmar.ie or call Marie on 021-4847133 to discuss the role in further detail.

Following your application for this specific role, Sigmar may contact you regarding other positions that we feel you may be suitable for. If you do not wish to be contacted about other opportunities please let us know. For further information please refer to the Privacy Statement on our website.

• Publish and maintain content on kollect.ie and related websites. Must have a sharp eye for detail!
• Prepare product images, videos, banners, text for web publication
• Collaborate with creative teams internally and externally to produce web assets
• Dynamic and creative content creator to write blog posts, web copy and marketing copy but mainly to curate, edit and write content and ensure content is optimised for SEO
• Develop and execute successful SEO strategies and perform ongoing keyword discovery to identify new opportunities
• Implement changes to website architecture, content, internal linking to improve rankings for target keywords
• Study competitor and industry trends to uncover new content opportunities
• On-site implementations/changes using HTML, CSS, JavaScript, PHP and/or other programming language (via Shopify and Wordpress CMS)
• Troubleshoot on-site technical SEO performance issues including page elements, CMS, server related issues and strategize solutions
• Solid understanding of performance marketing, conversion, and online customer acquisition
• Implementation of conversion tracking for measuring the success of marketing campaigns
• In-depth experience with website analytics tools (e.g, Google Analytics)

• 3+ Years of Experience
• Bachelor's degree in marketing, web design/business or related program
• Have a good understanding of HTML/CSS and Technical SEO
• Familiarity with Content Management Systems (WordPress and Shopify)
• Experience with digital content production, content proofing and editing, SEO best practices, UI/UX concepts, and general web design disciplines
• Experience in implementing conversion tracking on the website to assist the digital marketing team for ecommerce marketing campaigns via Adwords and Facebook
• Love creating content, creative with ability to collaborate with internal and external teams for creative content/graphics/video production
• Must be able to juggle multiple projects at the same time - fast paced environment
• Analytical & strong reporting skills
• Ability to meet deadlines and identify potential risks, resource needs, and prioritise workloads
• Have a strong sense of initiative and positive, creative problem-solver and a can-do attitude

Role Title:Basic Grade Pharmacist

Department:Pharmacy Clontarf Hospital

Reporting to:Chief Pharmacist

Salary scale:HSE Oct 2020 Consolidated payscales

Annual leave: 27 days

Hours per week:37 hours per week

Closing date: 05/03/2021 @ 17.00pm

ESSENTIAL REQUIREMENTS

Must be registered in the register of the Pharmaceutical Society of Ireland. The holder of the post must be registered on a continuing basis

DUTIES AND RESPONSIBILITIES

Subject to the supervision of the Chief II Pharmacist or his or her nominee, the Basic Grade Pharmacist will undertake duties appropriate to the grade, and participate fully in the provision of a comprehensive pharmaceutical service including:

• The provision of a comprehensive pharmaceutical service to service users
• The purchase, storage and supply of all pharmaceutical items consistent with quality, safety and value for money with reference to legal requirements, transit, security and conditions of chemical and physical stability.
• The maintenance of records for purchasing, quality control, compounding and dispensing to the standards required.
• The provision and development of services to the wards, including ward pharmacy services and stock control in accordance with best practice standards.
• The provision of advice as required, to medical and nursing staff on the safe, effective and economical use of drugs and medicines, including participation in schemes and educational activities for the dissemination of information in relation to drugs and drug usage.
• The provision of medicines information and advice services to patients and their families when required
• Identify, report and act as appropriate on medication safety related risks and incidents and actively participate in risk management.
• Production of annual and other reports as required
• Ensure health and safety standards are met
• Participation in the discharge planning of priority patients and liaison with community-based health professionals when deemed necessary.
• Participation in on-going provision of safe systems of generic substitution
• Participation in policy development under the direction of the Chief pharmacist, to ensure adherence to best practice in medicines use and to ensure legal compliance with new and existing pharmacy legislation.
• Co-operation with medical and nursing staff and others as appropriate, to facilitate patient safety and patient care in the management of new and existing treatment strategies.
• Participation in multi-disciplinary hospital committees when deemed appropriate by the Chief pharmacist.
• Participation in audit and research as deemed necessary by the Chief pharmacist.
• Assisting the Pharmacy team in the performance of his/her duties as required.
• Create and promote healthy working relationships within the pharmacy department and with other departments throughout the Hospital.

Education, Training and Self-Development

• To assume responsibility for his/her own professional development and safe work practice and to assist the pharmacy department in maintaining records of continuing professional development as required by the Pharmacy Act 2007.
• Participate in mandatory training programmes.
• To be aware of current developments and issues in health care by reading current literature and keeping abreast of new developments, attending lectures and courses when possible and as appropriate in consultation with your head of department.

Quality, Safety and Risk

• Follow agreed policies, procedures and safe practices in the workplace.
• Assist in ensuring the safety of self and others, and the maintenance of safe environments and equipment used in pharmacy.
• Assess and report risk in their assigned area (s) of responsibility including medication error reporting as per pharmacy SOP and organisational policy.
• Support a non-punitive approach to incident reporting relating to medication and patient safety.
• Act on product defect, recall and caution notifications relating to medicines according to pharmacy SOP and as directed to by the supervising pharmacist.
• Take the appropriate timely action to manage any clinical or non-clinical safety incidents or near misses within their assigned area (s).
• Comply with the Safety, Health and Welfare at Work Act, 2005.
• Take reasonable care to protect her/his own safety, health and welfare and that of any other person who may be affected by her/his acts or omissions at work

This job description will be subject to review in the light of changing circumstances. It is not intended to be exhaustive but should be regarded as providing guidelines within which individuals work.

We’re looking for a highly motivated Sr. Oracle ERP Cloud Analyst. This position will be involved in the development, implementation and support of global implementation of Oracle ERP cloud. The Sr. Oracle ERP Cloud Analyst will be a member of J2 Global’s Enterprise Applications team. As a member of this team, this role will work closely with Finance and other business teams to support their Oracle Cloud development, analysis, and user support needs. This is a hands-on technical role.

Strong Technical skills with some functional knowledge are required. Knowledge and experience working with Oracle ERP Cloud (Fusion) is required. Expert level knowledge of seeded Oracle tables, experience with building interfaces, APIs, modifying BPMS / workflows, reports, jDeveloper are needed. Good knowledge of core financial modules GL, AP, FA, AR, CM is needed. Experience with Oracle ERP cloud is a must.

Experience integrating cloud services (interfaces, conversions, creating applications using FBDI, ADFDI and ADF scripts required.

This position will support the global Finance and Accounting teams from both a functionality and development perspective, and will assist those teams leveraging Oracle Fusion more effectively

Job Duties:

• Apply business process analysis and vision to achieve the company’s Finance objectives through Oracle Fusion.
• Work with end users to resolve day to day Production issues
• Excellent written and verbal communication skills
• Proven ability to handle and prioritize multiple projects and meet deadlines.
• Commitment to excellence and high standards in service build / troubleshoot issues with custom reports and interfaces
• Work with Oracle support by opening SRs and implementing solutions
• Testing and helping users in conducting UAT

Job Requirements and Experience:

• A minimum of 6 years of technical experience, ideally working with large & complex implementations of Oracle EBS/Cloud ERP/ Oracle Apps.
• Minimum 3 years overall experience with ERP Cloud (Fusion)
• Experience with Oracle ERP Cloud architecture and underlying tables
• Demonstrated ability to manage multiple technical work streams and work in a complex global environment.
• Strong understanding of different integration technologies such as: Oracle OCI/SOA
• Must have experience with the different data conversion/integration methods into Oracle ERP Cloud (FBDI/FBDL, HDL, ADFDi)
• Experience with Web Service protocols SOAP/REST is a must
• Ability to work with XML/JSON/POST technologies to read/send information
• Experience building and supporting integrations between Salesforce and Oracle ERP Cloud
• Languages
  • Expert level PL/SQL (mandatory)
  • Expert level SQL (mandatory)
  • Java (or relevant Object Oriented language)
  • Shell: Bash, Korn
• Comfortable with OAF Personalization
• Create, debug and modify custom JCS forms
• Experience with SmartView reporting
• Experience with Workflow and UI personalizations
• Experience with Oracle Cloud module Enterprise Contracts (Service Contracts) is a plus
• Skilled in developing reports/dashboards using Oracle OTBI, XML and Bi Publisher
• Data conversion using different methods in ERP Cloud