SQL Developer

Role, Responsibilities & Person Specification

Job Title:              SQL Developer

Department:      Operations

Reports to:          IT Manager

Location:              Clonshaugh Ind Estate, Dublin 17

 

 

Key Purpose of the Role:

As a SQL Developer at Magnet Networks, you will work within the systems development and administration team to ensure that projects, development patches and ad-hoc requirements are documented, coded, implemented and supported in accordance with the best industry standards. You will be required to work with different Magnet business units to implement efficient, scalable solutions that aid delivery of Magnet Networks’ services and customer support. This role is technically challenging and rewards the successful applicant with an excellent opportunity to work in a truly innovative and ambitious company.

 

 

Principle Responsibilities:

  • Extrapolate from project requirements additional database objects or alterations to existing objects to facilitate these requirements
    Analyse implications for alterations to existing objects on any referring object.
    Analyse implications to Data flow processes for the addition of new objects.
    Creation of Scripts to implement results of the above analysis
    Creation of Unit test scripts.
    Creation of Migration scripts to be used to roll the changes into production.
    Documentation of all scripts.
    Creating database objects such as tables, indexes, views, stored procedures and user-defined functions.
    Code review/optimisation.
    Developing and managing a centralised management reporting platform, including data analysis for financial & operational metrics, among others.
    Creating & maintaining databases required for development, testing usage.
    Monitoring and Administration of SQL environments ensure quick resolution and root cause of issues.
    Implementing and enforcing security for the databases.
    Staying up-to-date on the latest database technologies and standards.
Experience

Essential:

  • Minimum of 3 years’ experience working as a Microsoft SQL Developer.
  • Minimum 1 years’ experience working with Microsoft SQL Server Reporting Services.
  • Experience working with Microsoft SQL Server Analysis Services.
  • Experience working with Microsoft SQL Server Integration Services.
  • Experience working with Microsoft SQL Profiler, or extended events.
  • Strong analysis skills.
  • A solid understanding of database systems and architectures.
  • Strong oral and written communications skills.

 

Desirable:

  • A third-level qualification in Information Systems or relevant industry experience.
  • Experience with MySQL.
  • Knowledge of Microsoft Navision v4, or Microsoft Dynamics v2012 onwards.
  • Expertise in consumer billing, preferably in the Telecoms industry.

 

Skills

  • Be self-motivated and self-directed.
  • Ability to identify areas of concern within current processes and propose detailed improvements to these areas.
  • Be able to work in a fast-paced technology environment.

 

Core Competencies Required & Importance

 Competence Requirements: Essential Desirable
Core Job Related competences (to be defined by Manager)
      Ability to interact constructively with cross functional teams   D
      Deliver on Project requirements within the defined timeline   D
  D
 Core competences
      Customer / Project Focus E
      Commercial and Business Awareness  
      Performance and Results focussed E
      Leadership, Motivation and People Management  
      Teamwork E
      Effective Communication and Impact E
      Continuous Improvement and Managing Change E
      Self Management and Personal Development E
      Ability to matrix manage teams  
      Experience of dealing with senior managers as both customers and suppliers E
      Persuasive skills E
      Integrity E
      Commitment E
      Relationship Building E
      Influencing   D
      Client Satisfaction E
      Delighting Customers E
Additional competences
      Strong Financial Awareness   D
      Global Awareness  
      Creative Thinking and Innovation E
      Planning, organisation, project management   D
      Ability to adapt to a changing environment E
      Problem Solving and Decision Making E
      Strategic Vision & Direction Setting  
      Professional (Sales & Bid Mgmt)
      Excellent numerical & data analysis  E  
      Deliver Results E
Other competences
      Excellent English spoken and written E
      Understanding of the Telecoms / Hi tech Markets  
      University level D
      Windows Processing experience  E  

Apply for this Job