Mid+/Senior Database and Applications Architect
Dentons Business Services EMEA
Iasi, Romania
4 zile în urmă
source : Just Join IT

API (advanced)

SQL Server (advanced)

About the Opportunity

This is a third line technical position within the IT Applications team based in UK and Warsaw. The role entails ensuring that the firm's technical architecture (in relation to its enterprise database applications and systems) is suitable for current business needs and integrates well into the firm’s overall applications strategy.

The database systems include the firm’s Document Management System (DMS) (Worksite) and other related SQL applications.

About the Role

  • Provide day-to-day support for the firm's SQL systems and applications, including monitoring database functionality to ensure a stable environment as well as diagnosing and resolving database access and performance issues.
  • Assist with day-to-day support for the firm's DMS and integrated applications, including account setup, server maintenance and configuration.
  • Troubleshooting and performance monitoring.

  • Gather requirements and translate them to business requirements.
  • Assist with the overall design and strategy for the application and infrastructure architecture of Dentons UKIME and any changes to them.
  • Adhere to standards and guidelines based on industry best practices towards management of information within an enterprise environment encompassing data integrity and security protocols.
  • Ensure all proposed changes to the live application or infrastructure environments are suitably tested with roll-back capability and change controls exercised accordingly.
  • Provide estimates and target dates for projects / tasks assigned; is committed to target dates.
  • Provide 3rd line applications support and database administration support, as appropriate.
  • Troubleshoot and resolve escalated issues.
  • Work with the Data Centre team, to ensure databases and critical data (on enterprise application systems) are properly backed up and protected in accordance with the needs of the application's primary stakeholder and the firm's business continuity and data retention policies.
  • Provide timely responses and resolution towards database backup, restore, mirroring, and synchronisation requests.
  • Adhere to the Dentons' processes and procedures including ISO 9001, ISO27001 and Cyber Essentials +
  • Assist other teams and team members, as and when required.
  • Technical Skills

  • Proven experience in an IT technical role in a 24 x 7 global support environment
  • Expert knowledge of SQL Server 2014 / 2016 / 2017 / 2019 administration
  • Expert knowledge of Transact-SQL, Stored Procedures, Indexes and Triggers.
  • Performance monitoring and troubleshooting on SQL instance level.
  • Expert knowledge of SQL Server disaster recovery technologies.
  • Good working knowledge of Microsoft Azure SQL database.
  • Expert IntApp Integrate knowledge
  • Good knowledge of Microsoft Power Platform : Power Automate, Power Apps, Power BI and Power Virtual Agent
  • Can support and integrate standard legal systems including Worksite, Elite PMS, Interaction CRM.
  • API Integration expertise - experience of seamlessly connecting and automating business processes and enhancing the sharing and embedding of data between various applications and systems.
  • Excellent working knowledge of Windows Server, IIS, and Active Directory.
  • PowerShell scripting and Python knowledge desirable
  • iManage Worksite experience desirable but not essential
  • Able to document processes and procedures, including technical diagrams towards organizational data flow
  • Can demonstrate a strong understanding, from an enterprise perspective, about how all data, applications, hardware, and users function and interact.
  • Soft Skills

  • Excellent written and verbal communication skills.
  • Able to interact positively at all levels within the firm and a good team player.
  • Strong problem solving and analytical skills; can clearly explain and present problems and issues to others and contribute to their resolution.
  • Has commercial awareness and understands the business value required from IT investments.
  • Able to exercise tact and diplomacy in an organizational setting.
  • Benefits

    Dentons is always looking to invest in the highest-quality talent, recognizing that our success is built on the diverse and unique strengths of each of the members of our Firm.

    Our team of business services professionals play a significant role in the success of Dentons, and we recruit Talent into a wide variety of areas.

    Here, we look for focused, flexible individuals from a variety of backgrounds who are team players. Previous experience within the legal sector is not essential.

    We want to give everyone the opportunity to develop his or her potential fully and, therefore, provide support, training and encouragement to members of teams at all levels

    Raportați această lucrare
    checkmark

    Thank you for reporting this job!

    Your feedback will help us improve the quality of our services.

    Aplică
    Email-ul meu
    Făcând clic pe "Continuă", acord nevoo consimțământ de a procesa datele mele și de a-mi trimite alerte prin e-mail, așa cum este detaliat în policyApplicația de confidențialitate a lui neuvoo. Pot să-mi retrag consimțământul sau să mă dezabonez în orice moment.
    Continuă
    Formular