Overview

Make an impact at Analysis Group, where we provide our clients with thoughtful, pragmatic solutions to their most challenging business and litigation problems. Analysis Group is one of the largest private economics consulting firms, with more than 1,200 professionals across 14 offices in North America, Europe, and Asia. Since 1981, we have provided expertise in economics, finance, health care analytics, and strategy to top law firms, Fortune Global 500 companies, and government agencies worldwide. Our internal experts, together with our network of affiliated experts from academia, industry, and government, offer our clients exceptional breadth and depth of expertise.

The Senior Database Administrator is responsible for updating, monitoring, and troubleshooting development and production environment database servers and associated infrastructure. In addition to ensuring database availability, reliability, and security, the Senior Database Administrator will work closely with other IT professionals to assist with any database related questions and provide guidance on SQL Server best practices.

Essential Job Functions And Responsibilities

Support SQL database and servers including performance management, security, installations, upgrades, patches, backup, recovery, space management, performance tuning and capacity planning
Responsible for planning, designing, coordinating and administration of SQL Database Server, including database definition, structure, documentation and standards
Responsible for database backup and restore functions including scheduled tests of disaster recovery (DR) availability. Requires in depth experience with SQL server High Availability technologies, such as Clustering, Replication and Always-On Availability Groups
Monitoring and Performance Tuning; physical server level, database level (database settings and options) and query tuning
Develop and establish policies and procedures related to data security and integrity; monitor and limit database access as needed
Design, model, and document database schema
Develop stored procedures, ad-hoc queries, functions and views
Work with IT teams to support various products/applications and assist business users and developers with database-related issues

Additional Responsibilities And Areas For Expansion

SQL Sentry Job monitoring software usage and alert design
PowerShell experience to assist with managing common tasks such as server reboots and Availability Group failovers
Expertise in designing, validating and implementing projects across the hybrid infrastructure (On-cloud to On-Premise and vice versa)

Qualifications

Bachelor’s degree required. Degree in computer science, management information systems, or equivalent is preferred
Minimum of 5 years of substantive relevant experience required. An ideal candidate will have 5-10 years’ experience in a technical environment, managing very large, complex data sets and database systems
In-depth knowledge of SQL Server 2012-2022, TSQL
Experience with SSAS, SSMS, and SSRS
Experience with Microsoft Clustering, High Availability, Disaster Recovery, Replication and other resiliency technologies
Strong interpersonal, oral, and written communication skills
Excellent attention to detail
Able to effectively work independently and as part of a team
An inclusive and growth-oriented mindset, strong interpersonal skills, and an ability to work across functions.
To the extent permitted by applicable law, eligible candidates must be authorized to work in the United States, without sponsorship or restriction, now and in the future.

Analysis Group embraces diversity and equal opportunity in a deep and meaningful way. We are committed to building teams that represent a variety of backgrounds, perspectives, and skills. The more inclusive we are, the better our work will be.

We provide equal access and opportunities regardless of sex, sexual orientation, gender, gender identity, gender expression, age, religion, race, color, ethnicity, national origin, ancestry, mental and physical ability or disability, medical condition, genetic information, citizenship status, socioeconomic status, veteran and military status, or membership in any other class protected under applicable law. We encourage candidates of all backgrounds to apply.

Privacy Notice

For information about Analysis Group’s privacy practices, please refer to the applicable Analysis Group privacy policy .

Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities.
Please view Equal Employment Opportunity Posters provided by OFCCP here .
The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor's legal duty to furnish information. 41 CFR 60-1.35(c)

Analysis Group jobs

Senior Database Administrator