Please login/register to apply for this job.
29 Nov 2021

Full-Time Database Administrator II/Senior

Clyde & Co – Posted by clydeco Kansas City, Missouri, United States

Job Description

The Firm

Clyde & Co is a leading, sector-focused global law firm with 400 partners, 2000 legal professionals and 3600 staff in over 40 offices across six continents. Its core global sectors position it at the heart of global trade and commerce: insurance, trade & commodities, energy, transport and infrastructure. With a strong emerging markets focus, the firm has achieved compound average annual revenue growth of 12% over
the last five years, making it one of the fastest growing law firms in the world with ambitious plans for further growth.

Our achievements were recognized in 2016, when we were awarded the accolade of Law Firm of the Year by The Lawyer. This award is one of the most sought-after in the industry as it recognizes the firm that has performed most strongly on a number of measures including; strong leadership and strategic vision, strong financial management and growth, talent management and workplace development and client innovation.

Our vision is to be our clients first choice for complex, multi-jurisdictional matters in our chosen sectors by investing in our core practice areas in chosen locations, serving an international client base and build a network of offices in key trading zones. Our key focus is also to become the “go to” firm in emerging markets, running ourselves professionally by attracting and developing the best people.

The Role

The mission of the Enterprise Data and Analytics team is to design, build, and maintain data and analytical technologies that enable the firm to quickly and efficiently query and use management information, business intelligence, and various forms of data. The Data Administrator enables this mission by designing, developing and managing key business databases and integrations primarily using Microsoft data management services. This role requires an excellent understanding of the on-premise and cloud database administration, data integrations and solutions to data-related issues.

Key Responsibilities

Database and Data Administrator

  • Work within the existing DBA team to provide standard DBA functions to manage the global SQL Server infrastructure.
  • Act as technical lead for database issues, advising IT staff world-wide and assisting where relevant, to meet local needs.
  • Assist in translating business needs and architectural requirements into commensurate database requirements.
  • Develop database build and deploy standard operating procedures and runbook materials.
  • Deploy, maintain and support reliable, secure and scalable bespoke databases, SSIS Packages, Analytics and SSRS
    and Power BI.
  • Undertake ETL operations to accurately import, convert and extract bulk data and documents from existing and new applications.
  • Assist in-house developers and external vendors with “best-practice” use of the database platform for releases and database features.
  • Manage and monitor the Development and UAT SQL environments to ensure consistency, and reset upon agreed change periods.
  • Ensure database security standards and best practices are monitored and enforced; support auditing needs.
  • Perform/support DMS and datacenter database migrations.
  • Manage standards and tools around database estate capacity and performance management, ensuring efficient use of hardware and license resources.
  • Participate in team activities to design and maintain global data warehouse and relevant data cubes.
  • Perform license and vendor management as appropriate for the database estate, collaborating with other license and
    vendor management stakeholders as required.
  • Support business continuity and disaster recovery planning.

Database Performance and Availability

  • Maintain the SQL Database platform, ensuring that upgrades and patches are applied appropriately and EOSL versions deprecated as relevant.
  • Monitor the enterprise database estate/SQL environment for performance, availability and errors.
  • Troubleshoot the global database estate as necessary to optimize databases and the SQL server environment while ensuring high-availability and performance.
  • Improve operational stability across the global database estate whilst reducing the costs and overhead associated with deployment, maintenance and support.
  • Provide proactive event management processes to ensure all issues are escalated as appropriate and within a timely fashion.
  • Support day-to-day requests for backups, system recoveries, database configurations, and performance investigations.
  • Assist the IT service desk and act as point of escalation, if required, for support calls that may involve database platform issues.

Collaboration and Project Support

  • Facilitate discussions within and outside IT to ensure database administration technologies and processes are correctly integrated across business programs.
  • Write reports for IT and business consumption as related to administration of the database estate.
  • Support project governance activities as required to ensure database engineering and administration principles
    continue to be integrated correctly as projects progress.
  • Act as team representative in various meetings and collaboration activities, include project planning meetings, Technical Advisory Boards, and other meetings where data solutions engineering and database administration expertise is required

Key Responsibilities

  • Works mostly independently with minimal supervision. Determines own approach to assigned tasks of moderate complexity.
  • Exercises considerable latitude and technical judgement in deciding work methods.
  • Able to effectively train and lead other members on small team projects. Able to give effective presentations and write convincing proposals/reports for team consumption.
  • Can creatively tackle problems and identify/isolate contributors within areas of technology that responsible for, in order to think through problem solving.
  • Experienced with a number of systems. SME in at least one area or system. Working knowledge of a number of other areas of specialization.
  • Identifies technology options for possible solutions. Can run/direct POCs to evaluate technologies, document results, and make recommendations.
  • 3 – 8 years of experience with relevant data technology roles, such as system or solutions developer preferred.
  • Experience with 3+ technologies and SME with at least 2 technologies from the list below:
    • Standards
      • Data standards
      • Global data design patterns
      • Database deployment
      • Performance management, tuning, installation, and configuration
      • SQL database systems/database security
      • SQL queries, stored procedures, analytics SSIS,SSRS
      • Microsoft Power Platform – PowerBI, Power Automate
      • SQL Unit Testing and automated testing
      • Delivering bespoke application solutions in an end-user organization providing B2B services
      • Implementing and supporting SQL Clusters and other HA/DR solutions
      • Continuous Integration and Continuous Delivery environment
    • Technologies
      • Core Microsoft applications
      • Azure Platform (IaaS/Managed Instances/SQL DB)
      • MS SQL Server/DBA/Development – 2008 and newer
      • SQL Clusters and other HA/DR solutions
      • Microsoft Data Tools
      • Team Foundation Server (TFS)
      • Azure DevOps
      • PowerShell
      • Data management tools (backups, archiving, monitoring)
      • Document management systems
      • Practice management systems
      • Business process systems

Education

Diploma or degree in Computer Science, Information Technology, or related field preferred; relevant education and experience in other disciplines are also considered.

Clyde & Co shifted to virtual work for the majority of our lawyers and business services team with the global outbreak of Covid-19. This precaution was taken to help protect our people, clients and communities. It is likely that this role will start virtually while the firm continues to evaluate the situation.

-Principals Only-

We offer a rewarding work environment that supports professional growth and opportunities. We value diversity in our work place and it is the policy of the Firm to recruit, hire, promote, reassign, compensate and train highly qualified persons without regard to race, color, sex, sexual orientation, gender identity or expression, religion, national origin, age, disability or any other basis protected by applicable law.

CLYDE & CO PRIVACY NOTICE: https://www.clydeco.com/help/privacy

How to Apply

Please apply directly through the Clyde & Co website: Clyde & Co Job Board (cvmailuk.com)

Job Categories: LGBT. Job Types: Full-Time. Job Tags: Information Technology and IT. Salaries: Not Disclosed.

Job expires in 36 days.

82 total views, 1 today

Apply for this Job