SQL Database Engineer

Requirements

Must have:

- We require a bachelors degree in computer science, information technology, or a closely related discipline, or equivalent professional experience.

• We value Microsoft certifications such as MCSE or MCDBA, which would be an advantage.
• We need at least 5 years of hands-on database administration experience with enterprise platforms such as Microsoft SQL Server or MySQL.
• We look for proven experience in performance tuning, query refinement, and capacity forecasting.
• We expect familiarity with backup and recovery processes, high-availability architectures, and disaster recovery planning.
• We prefer experience with AlwaysOn Availability Groups, SAN-based environments, virtual SQL Server setups, Power BI, and PowerShell.
• We favor exposure to document management systems and related enterprise tools.
• We need strong technical capability in database design, deployment, optimization, and troubleshooting.
• We require solid knowledge of database security principles, including access governance and protection best practices.
• We seek excellent analytical ability, sound judgment, and strong problem-solving skills.
• We need someone who can manage priorities, adapt in a fast-moving environment, and communicate effectively across all levels of the organization.
• We require the ability to work both independently and collaboratively in a remote or hybrid setting.

Responsibilities:

- We design, implement, and maintain high-performing database environments that support applications and business operations.

• We improve database efficiency through capacity planning, query tuning, index optimization, and other performance-enhancement techniques.
• We carry out database engineering and administration tasks, including installation, configuration, monitoring, backup, recovery, and issue resolution.
• We develop and apply data management policies and operational best practices to protect data integrity, availability, and security.
• We build and maintain security controls such as access permissions, encryption, roles, auditing, and other safeguards.
• We partner with developers, system administrators, application owners, and other stakeholders to deliver effective database solutions.
• We lead database initiatives, including upgrades, migrations, deployments, and related project work.
• We create and test backup and restore strategies, including validation of recovery procedures.
• We configure and support high-availability solutions and disaster recovery plans.
• We apply SQL Server patches and updates and perform regression testing to confirm system stability.
• We develop monitoring and alerting tools, investigate performance trends, and implement corrective actions.
• We administer cloud database services such as Azure SQL and Azure Data Factory.
• We support document management system projects, including upgrades, migrations, and integrations.
• We provide advanced support for related systems such as knowledge management, indexing, records management, and ethical wall platforms.
• We document procedures, share knowledge, and train application owners and developers.
• We stay informed about emerging technologies and recommend improvements to our database infrastructure.
• We participate in firmwide IT initiatives, project teams, and escalation efforts as needed.
• We perform other duties as assigned.

Company:

We are Reed Smith, and we offer a challenging professional environment with a business casual dress code, competitive compensation, and a comprehensive benefits package that includes medical, dental, vision, retirement savings, flexible spending options, health and wellness support, paid time off, tuition assistance, and more. This is a remote role with occasional in-office requirements, and candidates must live within approximately one to two hours of our Pittsburgh office to support onsite needs or emergencies. The position is exempt, with an anticipated Pittsburgh pay range of $94,000 to $106,000 depending on experience and location. We are an equal opportunity employer guided by integrity, excellence, teamwork, respect, innovation, and impact, and we provide reasonable accommodations in the hiring process in accordance with applicable law.