SQL DATABASE ADMINISTRATOR

Position Summary: TransPerfect helps organizations navigate the global marketplace. It remains founder- led – and has striven to maintain the ethos and drive that led them to grow organically year-on-year for the past 30 years. Starting in an NYU dorm room in the early 1990s, TransPerfect is today recognized as the largest translation and language services company in the world with thousands of employees located in 90+ offices worldwide. In 2021, TransPerfect exceeded $1 billion in revenue.The TransPerfect TechOps team has been a vital part of the company’s success since its formation 10 years ago – delivering technology and services that have drastically simplified the lives of our clients and colleagues – from workflow improvements for colleagues, to core services that form the basis of the company’s GlobalLink platform, to creating scalable client interfaces that allow novice users to navigate complex ecosystems.As a Database Administrator, you will work directly with senior developers team to design, test, plan, protect and implement our department’s databases.To find out more about our solutions, please visit: https://globallink.transperfect.com/Your responsibilities and tasks will include:Managing locking, process blocking and performance tuning of our databasesCreating and maintaining a high availability and disaster-recovery-friendly architectureManaging, optimizing, testing and verifying the backup and restoration processesCreating and maintaining monitoring and metrics tooling and dashboards, to give both high-level and granular insight into database performance and operationManaging our infrastructure in a preventative manner, considering and avoiding potential future issues, mitigating damage from future incidentsHandling support tickets when necessary, backing up your peersDevelops and deploys new database objects and changes to existing database objects including tables, stored procedures, views, etc.Create complex functions, scripts, stored procedures and triggers to support application developmentDesigns, develops and maintains a multitude of complex relational database reports using SSRSThe minimum we’re looking for (show us what you’ve got if you aren’t a perfect fit):Advanced understanding of relational database architecture/infrastructure, specifically MSSQLKnowledge of SSMS, SSRS, support toolingKnowledge of T-SQL, Stored Procedures, and day-to-day DB functionsAdvanced knowledge of how to optimize MSSQL, support HA/DR, etcStrong knowledge of systems and software development lifecycles; application integration techniques; and relational database designExperience with Always on High Availability Groups is a plusAnalyze, troubleshoot and break-down complex problemsChoose appropriate tasks to work on relative to our current workloadUnderstand and implement best-practices balanced with our team standardsClearly communicate ideas, thoughts and suggestions to manager and peersParticipate, review and offer constructive criticism to peers’ changes and codeExperience with cloud database storage technologies Work model:This position is intended to be largely in-office with a focus on flexibility. Today, most of the global team is on a hybrid model ranging between 3-4 days in the office per week. We aim to find an inclusive balance between everyone's personal lives and responsibilities and the value created from in-office collaboration. We work with new team members to find that balance with them while building the trust and collaboration that our team values.We believe that sharing the same physical space with our colleagues creates a level of trust and understanding that fosters innovation and a sense of purpose.The socializing and relationships formed from these in-person interactions have created the bonds that make our team successful.We not only want to encourage people to safely spend time in the office, but also, schedule regular travel between our offices in Europe and the US – and a regular conference where the entire worldwide team is gathered together. Maybe the metaverse will replace the office some day – but it hasn't yet! Online meetings were a powerful connector during the pandemic – but they don't foster the same connection. By applying, I confirm I have read and accept TransPerfect's Privacy Policy: https://www.transperfect.com/about/data-privacy-recruiting