Reed Smith LLP: SQL Database Engineer - (Remote)

Related keywords: legal remote jobremote job microsoftdata engineer remote job

Overview

Reed Smith LLP is a dynamic international law firm committed to delivering innovative legal services and driving better outcomes for its clients. The firm operates globally from over 30 offices across the United States, Europe, the Middle East, and Asia, serving as a pivotal partner for complex disputes, transactions, and regulatory matters. The collaborative structure involves a team of approximately 3,000 people, including more than 1,600 lawyers, working as one global partnership.

Position Summary

The firm is currently seeking a SQL Database Engineer to join its remote team. This role is essential for ensuring the performance, availability, and security of SQL Server databases. The database engineer will collaborate closely with application owners and development teams to design, develop, implement, and maintain database solutions that are vital for meeting business requirements. Expertise in troubleshooting database-related issues and assisting users will also be part of their responsibilities.

Job Duties and Responsibilities

The primary responsibilities of the SQL Database Engineer include:

• Designing, implementing, and maintaining database systems that support applications and business operations.

• Optimizing database performance through meticulous capacity planning, query optimization, index tuning, and related techniques.

• Performing essential database engineering and administration tasks, encompassing installation, configuration, tuning, monitoring, and backups.

• Developing data management policies to ensure data integrity, availability, and security, along with implementing security measures for databases.

• Collaborating with software developers, system administrators, and other stakeholders to ensure that database solutions align with business needs.

• Leading database-related projects such as upgrades, migrations, and deployments from planning through execution.

• Designing and managing high availability solutions and developing disaster recovery plans to minimize downtime.

• Providing expertise in cloud-based database platforms, particularly PaaS environments such as Azure SQL and Azure Data Factory.

• Supporting the firm's Document Management System (DMS) through managing data transfers, imports/exports, and troubleshooting.

• Documenting database configurations, procedures, and best practices, and offering training to application owners and developers.

• Staying current with emerging database trends and recommending solutions to enhance infrastructure.

  ---

Required Qualifications

Education

• A Bachelor's Degree is strongly preferred, though comparable training and experience in IT may suffice. Relevant Microsoft Certifications (MCSE and/or MCDBA) are advantageous.

Experience

• A minimum of 5+ years of experience in database administration, with specific expertise in enterprise-level database systems (e.g., Microsoft SQL Server, MySQL) is a must.

• Proficiency in database design, implementation, optimization, exceptionally focused on performance tuning, query optimization, and capacity planning.

• Familiarity with database security principles and best practices, as well as hands-on experience with backup and recovery procedures.

Skills

• Strong analytical, organizational, and communication skills are essential.

• Ability to work independently and as part of a team, providing leadership and innovative solutions under pressure.

• Excellent verbal and written communication skills, with the ability to interact across various organizational levels.

Salary and Benefits

The anticipated salary range for this role in Pittsburgh is between $94,000 and $106,000. Actual salaries may vary based on various factors, including location and experience. The comprehensive benefits package offered includes:

• 401(k) Retirement Plan
• Medical, Dental, and Vision Insurance
• Health Savings Account (HSA)
• Virtual Health Services
• Various insurance options (accident, life, short-term disability)
• Flexible Spending Accounts (FSA)
• Paid Family Leave
• Tuition assistance
• Paid Time Off (PTO) for all full-time employees.

Work Conditions

This position is remote but may occasionally require in-office attendance due to project needs. The nature of the role may sometimes demand working beyond regular hours, requiring flexibility and adaptability.

Summary

In conclusion, the SQL Database Engineer role at Reed Smith LLP offers an excellent opportunity for skilled professionals seeking to enhance their careers in a collaborative and innovative legal environment. With competitive salary offerings, extensive benefits and the potential for growth, this position is ideal for database experts committed to excellence and leadership in technology.

This job offer was originally published on weworkremotely.com