OVERVIEW
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.
DESCRIPTION
Managing locking, process blocking and performance tuning of our databases
Creating and maintaining a high availability and disaster-recovery-friendly architecture
Managing, optimizing, testing and verifying the backup and restoration processes
Creating and maintaining monitoring and metrics tooling and dashboards, to give both high-level and granular insight into database performance and operation
Managing our infrastructure in a preventative manner, considering and avoiding potential future issues, mitigating damage from future incidents
Handling support tickets when necessary, backing up your peers
Develops 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 development
Designs, develops and maintains a multitude of complex relational database reports using SSRS
REQUIRED SKILLS
Advanced understanding of relational database architecture/infrastructure, specifically MSSQL
Knowledge of SSMS, SSRS, support tooling
Knowledge of T-SQL, Stored Procedures, and day-to-day DB functions
Advanced knowledge of how to optimize MSSQL, support HA/DR, etc
Strong knowledge of systems and software development lifecycles; application integration techniques; and relational database design
Experience with Always on High Availability Groups is a plus
Analyze, troubleshoot and break-down complex problems
Choose appropriate tasks to work on relative to our current workload
Understand and implement best-practices balanced with our team standards
Clearly communicate ideas, thoughts and suggestions to manager and peers
Participate, review and offer constructive criticism to peers’ changes and code
Experience with cloud database storage technologies.
REQUIRED EXPERIENCE AND QUALIFICATIONS
Minimum Bachelor’s degree or its equivalent
Job details are sourced from the employer's original posting.
Open job postingAbout the company
For over 20 years, TransPerfect has provided comprehensive language and technology solutions to help our clients communicate and conduct business more effectively in a global marketplace. Equipped with a quality management system certified to both the ISO 9001:2008 and EN 15038:2006 standards, TransPerfect provides a full array of language and business support services, including translation, interpretation, multicultural marketing, website globalization, subtitling, voiceovers, staffing services, multicultural marketing, training and learning, and legal support services. TransPerfect also offers a suite of cutting edge technologies that significantly reduce costs and improve consistency throughout the translation process, making TransPerfect the vendor of choice for the world's leading multinationals. With annual revenues of over $470 million, TransPerfect is the world's largest privately held provider of language services and technology solutions. From offices in more than 85 cities on six continents, TransPerfect offers a full range of services in 170+ languages to clients worldwide. With an unparalleled commitment to quality and client service, TransPerfect is fully ISO 9001 and EN 15038 certified. TransPerfect has global headquarters in New York, with regional headquarters in London and Hong Kong. TransPerfect offers a comprehensive benefits package including: medical, dental, vision, 401k, paid time-off, company sponsored life insurance, short term and long term disability, flexible spending account options, and a pro-active and accessible HR department that focuses on the staff's health and happiness.