Database Engineer at Fragomen (Pittsburgh, PA)

| Pittsburgh, PA
Sorry, this job was removed at 2:01 a.m. (CST) on Sunday, May 22, 2022
Find out who's hiring in Pittsburgh, PA.
See all Data + Analytics jobs in Pittsburgh, PA
Apply Now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.
Job Description

Fragomen, the leading global immigration services provider and an AmLaw 100 Firm, is seeking a Database Engineer who will be responsible for the architecture, design, implementation, optimization, and support of our firm's various database platforms.

The candidate will require senior level knowledge of Microsoft SQL Server and the ability/desire to learn other database technologies and new areas of integration with existing on premise and cloud technologies to enhance application availability and performance.

How you will make a difference as a Database Engineer at Fragomen:
  • Assess risks and impacts arising from a business disruption and make decisions and determine actions independently and expediently to eliminate those risks and ensure the continuity of business.
  • Understanding of firm and industry best practices and business requirements as it relates to Microsoft SQL Server and other database technologies.
  • Responsible for reviewing, learning, and recommending database system design and architecture in line with the firm's technical needs.
  • Maintaining documentation of diagrams, processes, procedures, troubleshooting guides and change management logs.
  • Design, implement and ensure that systems achieve 100% uptime 24/7/365 operational availability.
  • Act as technical project manager responsible for project plans, timelines, resource management and related communications to stakeholders.
  • Participate in making decisions and determining actions independently and expediently to eliminate risks and ensure the continuity of business.
  • Act to support all technical projects arising from the project Management office (PMO).
  • Provide training and mentoring on problem identification, analysis and troubleshooting techniques and best practices to Operations teams.
  • Participate in a 24/7 on call rotation and monthly patching cycle.
  • Flexible to work outside of normal business hours as required.

Let's talk if you have the following qualifications and experience:
  • 5-10 years working with SQL Server 2014, 2016, 2017 and/or 2019.
  • Knowledge of Database Design and Architecture.
  • Proficient with Performance Tuning by reviewing Execution Plans and identifying and resolving TSQL Query inefficiencies.
  • Implement and Support SQL Server High Availability with Emphasis on SQL Server Transactional Replication and Always On Availability Groups.
  • Experience developing, trouble shooting and deploying SQL Server Integration Packages.
  • Keep up to date with new releases of Microsoft SQL Server and advise users of the aspects that pertain to them.
  • Ensure that system have appropriate maintenance in place including backups, index maintenance, consistency checks and statistics maintenance.
  • Experience preferred with technologies such as PostGreSQL, ETL (SSIS), Data Modeling, coding languages such as Python/PowerShell/C#, Cloud technology such as Azure or AWS, any DevOps or Automation experience.

Our technology stack includes but is not limited to:
  • MS SQL
  • PostGreSQL
  • SSIS for ETL (SSIS)
  • C#, PowerShell, and Python coding Languages
  • Microsoft Azure

Fragomen is committed to promoting diversity, inclusion and equal opportunity for all employees and applicants, regardless of race, ethnicity, heritage, gender, age, religion, disability, sexual orientation, gender identity or intersex status.
More Information on Fragomen
Fragomen operates in the Legal Tech industry. The company is located in New York, NY, Irvine, CA, San Francisco, CA, Washington, DC, Troy, MI, Wexford, PA, Addison, TX, Phoenix, AZ, Los Angeles, CA, San Diego, CA, Santa Clara, CA, Atlanta, GA, Chicago, IL, Boston, MA and Matawan, NJ. Fragomen was founded in 1951. It has 5000 total employees. It offers perks and benefits such as Flexible Spending Account (FSA), Disability Insurance, Dental Benefits, Vision Benefits, Health Insurance Benefits and Life Insurance. To see all 41 open jobs at Fragomen, click here.
Read Full Job Description
Apply Now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.

Similar Jobs

Apply Now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.
Save jobView Fragomen's full profileFind similar jobs