Database Administrator

Analysis Group is one of the largest international economics consulting firms, with more than 1,500 professionals across 15 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 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 Database Administrator will work closely with other IT professionals to assist with any database related questions and provide guidance on SQL Server best practices, as well as writing custom reports and queries.

Essential Job Functions and Responsibilities:

• Oversee SQL database and servers including performance management, security, installations, upgrades, patches, backup, recovery, space management, performance tuning and capacity planning.
• Support administration of SQL Database Server, including changes to database definition, structure and documentation.
• 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.
• Execute 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 and Senior DBA to support various products/applications and assist business users and developers with database-related issues.
• Rotating on call and off hours support.

Qualifications:

• Degree in computer science or management information systems or equivalent is required.
• Minimum of two years of relevant experience in a technical environment, managing large, complex data sets and database systems is required.
• Strong interpersonal, oral, and written communication skills.
• Excellent attention to detail.
• Able to effectively work independently and as part of a team.
• In-depth knowledge of SQL Server 2016-2019, TSQL, is required.
• Experience with other database platforms, such as MySql and Postgres SQL, is a plus.
• Exposure to cloud warehouse management, such as adjusting permissions and monitoring usage in Snowflake or Databricks, is a plus.

Analysis Group embraces equal opportunity. We are committed to building teams that bring a variety of backgrounds, perspectives, and skills, as we believe that a strong and inclusive workforce directly supports our goal of providing the highest-quality work. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, or any other class protected under applicable federal, state, or local law, and we encourage candidates of all backgrounds to apply.

Analysis Group offers competitive compensation and a comprehensive benefits package. The estimated salary range for this position is $100,000—$125,000. Compensation offered will be based on a number of factors including work experience, education, and skill level. This role is eligible for a discretionary annual bonus that is determined in large part by individual performance. To learn more about our benefit offerings, click here.

#LI-Hybrid

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 the EEOC’s “Know Your Rights” poster here.