Not currently receiving applications. For agency users and internal applicant, please login, or register.
Job Title
Database Administrator II/Senior
Job Location
Kansas City
Job Type
Business Services
Country/Territory
United States
Region
The Americas
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 recognises 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 optimise
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
Microsoft Power Platform - PowerBI, Power Automate
SQL Unit Testing and automated testing
Delivering bespoke application solutions in an end-user
organisation 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.
Clyde & Co US LLP is committed to protecting the health and
well-being of our employees and partners, their families, and
members of our community against COVID-19. Accordingly, we require
all partners and employees based in the United States to be fully
vaccinated against COVID-19 to enter the Firm's office, unless they
have been granted a reasonable accommodation based on documented
medical or religious grounds. Offers of employment will be
conditioned upon applicants presenting proof of full COVID-19
vaccination unless exempted by the firm based on medical or
religious grounds.
-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