SQL Database Engineer - (Remote in Pittsburgh)

US Job Description Firm Information Reed Smith is a dynamic international law firm dedicated to helping clients move their businesses forward. With an inclusive culture and innovative mindset, we deliver smarter, more creative legal services that drive better outcomes for our clients. Our deep industry knowledge, long-standing relationships and collaborative structure make us the go-to partner for complex disputes, transactions and regulatory matters. Our team of 3,000 people (including more than 1,600 lawyers) across more than 30 offices in the United States, Europe, the Middle East and Asia, operate as one global partnership to drive progress for our clients, for ourselves and for our communities. Position Summary The SQL Database Engineer is responsible for ensuring the performance, availability, and security of our SQL Server databases. They will work closely with applications owners and development teams to design, develop, implement, and maintain database solutions that meet business requirements. The SQL Database Engineer will also be involved in troubleshooting database-related issues and providing support to users as needed. They will perform database administration tasks associated with various enterprise-wide systems, as well as some enterprise application responsibilities. This role requires a deep understanding of database administration principles, information security, and proficiency in relevant technologies. Serve as an internal consultant and resource to others in the department. Job Duties and Responsibilities • Design, implement, and maintain high-performance database systems to support our applications and business operations. Optimize database performance through capacity planning, query optimization, index tuning, and other performance-tuning techniques. • Perform database engineering and administration tasks, including installation, configuration, tuning, monitoring, backup, recovery, and troubleshooting. • Develop and implement data management policies, procedures, and best practices to ensure data integrity, availability, and security • Implement and maintain database security measures, including access controls, encryption, and auditing. • Collaborate with software developers, system administrators, and other stakeholders to design and deploy database solutions that meet business requirements. • Lead database-related projects, including upgrades, migrations, and deployments, from planning through execution. • Design and implement backup and recovery strategies to ensure the integrity and availability of data. Perform regular backups and test restore procedures to ensure recoverability. • Design and manage database security by configuring user access, roles, permissions, and auditing. Implement security best practices to protect sensitive data. • Design, configure, and maintain high availability solutions such as AlwaysOn Availability Groups. Develop and test disaster recovery plans to minimize downtime in the event of failure. • Apply patches and updates to SQL Server instances and related components in a timely manner. Perform regression testing to ensure compatibility with existing applications. • Design, develop, and maintain proactive monitoring and alerting solutions to detect and respond to database issues in real-time. Develop automated scripts and jobs to streamline monitoring tasks. • Provide cloud related expertise and administration of PaaS based database platforms, including but not limited to Azure SQL, Azure Data Factory, and more. • Lead, take ownership, and work on projects related to the firms’ Document Management System (DMS) including upgrades, conversions, integrations and migrations. Document Management System (DMS) tasks related to managing data transfers, document imports/exports, user access, advanced troubleshooting of issues, and escalating with vendors to resolve system related issues. • Advanced support of DMS related systems including Knowledge Management systems, full text indexing/searching functions, Records Management systems, ethical wall systems. This includes working with other business and technical teams for implementation and support of these systems. • Develop documentation of database configurations, procedures, and best practices. Provide training and support for application owners and developers as needed. • Stay current with emerging technologies, trends, and best practices in database administration and recommend innovative solutions to enhance our database infrastructure. • Maintain skill level and knowledge through formal and informal means. • May volunteer or be selected to serve on special committees, work groups, project teams, or escalation teams related to various firm wide IT initiatives. Initiatives may be specific one-time events (e.g., research, testing, rollouts, upgrades, installations) or ongoing activities. All other duties as assigned. Job duties and responsibilities included are not exhaustive and may be supplemented as necessary. Reed Smith reserves the right to revise or modify job duties and responsibilities at any time. Requirements Education: Bachelor’s Degree strongly preferred or comparable training and experience in IT discipline. Microsoft Certifications (MCSE and/or MCDBA) a plus. Experience: Required: 5+ years of experience in database administration, with a focus on enterprise-level database systems (e.g., Microsoft SQL Server, MySQL). Strong proficiency in database design, implementation, optimization, and troubleshooting. Extensive experience with database performance tuning, query optimization, and capacity planning. In-depth knowledge of database security principles and best practices. Hands-on experience with database backup and recovery procedures. Database Always on Availability Groups, Multi-Tier, High-Availability application architecture, SAN environment, Virtual SQL Server environments, PowerBI, PowerShell, productivity tools (e.g., Office, Project, Visio). Familiarity with Document Management Systems a plus. Skills: Strong analytical, organizational, and communication skills. Able to work independently and as part of a team, and solve problems using creative solutions. Ability to organize and prioritize workload, and remain flexible in an environment of constantly changing priorities. Demonstrated ability to lead projects and people, and make sound decisions and stay calm under pressure. Strong verbal and written communication skills, and ability to interact with all organizational levels. Other Supervisory Responsibilities: None Equipment to be Used: Personal computer and other office equipment. Essential Job Functions: • Ability to analyze complex problems, identify root causes, and develop innovative solutions. • Ability to use independent judgment and discretion and adapt to changing work situations. • Ability to communicate effectively, orally and in writing, with various personalities at all levels. • Ability to sit and/or stand for prolonged periods, intense eye usage, and finger, hand and wrist dexterity associated with prolonged computer use. • Ability to utilize technology, including computers and telecommunication devices. • Ability to read and interpret written documents, computer screens and other visual displays accurately. • Ability to hear and understand verbal communication, including conversations and instructions, is important for effective collaboration and communication. Working Conditions: The position is remote; however, the individual must reside within 1–2 hours of commuting distance from the Pittsburgh office. This is to accommodate potential emergencies, special circumstances, or occasional in-office work requests. While the role primarily follows a regular schedule, there may be instances requiring flexibility to work beyond standard hours, making proximity to the office important Pay Range: This represents the presently-anticipated low and high end of Reed Smith’s pay range for this position. Actual pay may vary based on various factors, including but not limited to location and experience. • Pittsburgh: $94,000 - $106,000 Employee Benefits Overview Our comprehensive benefits package includes: • 401(k) Retirement Plan • Medical Insurance • Health Savings Account (HSA) • Virtual Health Services • Dental Insurance • Vision Insurance • Accident Insurance • Hospital Indemnity Insurance • Critical Illness Insurance • Life Insurance • Short-Term Disability Coverage • Long-Term Disability Coverage • Flexible Spending Accounts (FSA) • Lyra Health Employee Assistance Program (EAP) • Paid Family Leave (for eligible Exempt and Non-Exempt staff) • College Savings Plan • Transportation Benefit • Back-up Child Care Services • College Coach Program • Pet Insurance • Paid Sick Time (for Exempt staff) • Paid Time Off (available to all full-time, non-temporary employees) Reed Smith offers a challenging work environment, business casual dress code and a total compensation package that includes a competitive salary, flexible benefits program, tuition assistance, and generous 401(k) plan. Reed Smith is an Equal Opportunity Employer with Core Values of Integrity, Excellence, Teamwork & Respect, Innovation, and Impact. Reed Smith also provides reasonable accommodations in accordance with law, including in the application and interview process. Qualified candidates only. No search firms. Remote Skills: Access Control, Analysis Skills, Auditing, Best Practices, Business Operations, Capacity Management, Childcare, Cloud Computing, Coaching, Communication Skills, Consulting, Cryptography, Customer Support/Service, Data Management, Data Quality, Data Recovery, Database Administration, Database Design, Database Optimization, Database Programming, Database Technology, Dental Insurance, Disaster Recovery, Document Management, Documentation, Emerging Technology, Enterprise Applications, Establish Priorities, Flexible Spending Accounts, Healthcare, High Availability, High Availability Software, Identify Issues, Import/Export, Information/Data Security (InfoSec), Insurance, International Law, Knowledge Management Systems, Leadership, Legal, Life Insurance, MCDBA - Microsoft Certified Database Administrator, MCSE - Microsoft Certified Systems Engineer, Manual Dexterity, Microsoft Certifications, Microsoft SQL Server, Microsoft Virtual Server, Microsoft Visio, Microsoft Windows Azure, MySQL, Organizational Skills, Performance Tuning/Optimization, Platform as a Service (PaaS), Policy Implementation, Power BI, Presentation/Verbal Skills, Problem Solving Skills, Query Optimization, Records Management, Regression Testing, Regulations, Root Cause Analysis, SQL (Structured Query Language), SQL Databases, Scripting (Scripting Languages), Security Auditing, Security Monitoring, Software Administration, Software Development, Software Patches, Storage Area Network (SAN), Systems Administration/Management, Team Player, Telecommunications, Test Plan/Schedule, Testing, Time Management, Training/Teaching, Trend Analysis, Windows PowerShell, Work From Home, Writing Skills About the Company: Reed Smith LLP Although Reed Smith works from multiple locations, the firm's lawyers are linked by more than technology. All share a common culture, with Core Values supporting Reed Smith's firm-wide commitment to add value, achieve excellence, and promote professional development. These foster a workplace in which diversity and inclusion, pro bono service and community support are manifest. As the firm continues to grow, it remains sharply attuned to its Core Values, which define its professional character as well as what clients can expect from Reed Smith lawyers, who live these values every day. Company Size: 2,500 to 4,999 employees Industry: Legal Services Founded: 1877 Website: https://www.reedsmith.com/ Apply tot his job Apply To this Job