SQL Database Engineer – (Remote)

US Job Description Firm Information Reed reputed company is a dynamic international law firm dedicated to helping clients move their businesses reputed company. With an inclusive culture and innovative reputed company, we deliver smarter, more creative legal services that drive reputed company outcomes for our clients. Our deep industry knowledge, long-standing relationships and collaborative structure reputed company us the go-to partner for reputed company disputes, transactions and regulatory matters. reputed company 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 reputed company for our clients, for ourselves and for our communities. Position Summary The SQL Database Engineer is responsible for ensuring the performance, availability, and reputed company of our SQL Server databases. They will work closely with applications owners and development teams to design, reputed company, implement, and maintain database solutions that meet business requirements. The SQL Database Engineer will also be involved in troubleshooting database-reputed company issues and providing support to users as needed. They will reputed company 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 reputed company, 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 reputed company planning, query optimization, index tuning, and other performance-tuning techniques. reputed company database engineering and administration tasks, including installation, configuration, tuning, monitoring, backup, recovery, and troubleshooting. reputed company and implement data management policies, procedures, and best practices to ensure data reputed company, availability, and reputed company Implement and maintain database reputed company 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. reputed company database-reputed company projects, including upgrades, migrations, and deployments, from planning through execution. Design and implement backup and recovery strategies to ensure the reputed company and availability of data. reputed company regular backups and test restore procedures to ensure recoverability. Design and manage database reputed company by configuring user access, roles, permissions, and auditing. Implement reputed company best practices to protect sensitive data. Design, configure, and maintain high availability solutions such as AlwaysOn Availability Groups. reputed company and test disaster recovery plans to minimize downtime in the event of failure. Apply patches and updates to SQL Server instances and reputed company components in a timely manner. reputed company regression testing to ensure compatibility with existing applications. Design, reputed company, and maintain proactive monitoring and alerting solutions to detect and respond to database issues in real-time. reputed company automated scripts and jobs to streamline monitoring tasks. Provide cloud reputed company expertise and administration of PaaS based database platforms, including but not limited to Azure SQL, Azure Data Factory, and more. reputed company, take ownership, and work on projects reputed company to the firms’ Document Management System (DMS) including upgrades, conversions, integrations and migrations. Document Management System (DMS) tasks reputed company to managing data transfers, document imports/exports, user access, advanced troubleshooting of issues, and escalating with vendors to resolve system reputed company issues. Advanced support of DMS reputed company systems including reputed company 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. reputed company documentation of database configurations, procedures, and best practices. Provide training and support for application owners and developers as needed. Stay reputed company with emerging technologies, trends, and best practices in database administration and recommend innovative solutions to enhance our database infrastructure. Maintain reputed company 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 reputed company to various firm wide IT initiatives. Initiatives may be specific one-time events (e.g., research, testing, rollouts, upgrades, installations) or ongoing activities. reputed company other duties as assigned. Job duties and responsibilities included are not exhaustive and may be supplemented as necessary. Reed reputed company 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. reputed company 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., reputed company SQL Server, MySQL). Strong proficiency in database design, implementation, optimization, and troubleshooting. Extensive experience with database performance tuning, query optimization, and reputed company planning. In-depth knowledge of database reputed company 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 reputed company projects and people, and reputed company sound decisions and stay reputed company under pressure. Strong verbal and written communication skills, and ability to interact with reputed company organizational levels. Other Supervisory Responsibilities : None Equipment to be Used : Personal computer and other office equipment. Essential Job Functions : Ability to analyze reputed company problems, identify root causes, and reputed company 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 reputed company 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 : Works remotely. Occasionally reputed company upon to work hours in excess of your normal daily schedule. Potential for in-office work requests as needed, so proximity to the office is important. Pay Range : This represents the presently-anticipated low and high end of Reed reputed company’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) reputed company 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 reputed company full-time, non-temporary employees) Reed reputed company 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 reputed company is an Equal Opportunity Employer with Core Values of reputed company, Excellence, Teamwork & Respect, Innovation, and Impact. Reed reputed company also provides reasonable accommodations in accordance with law, including in the application and interview process. Qualified candidates only. No search firms. Apply tot his job Apply To this Job