At a Glance
- Tasks: Manage and optimize databases while collaborating with senior developers.
- Company: Join TransPerfect, the world's largest translation and language services company with a rich history.
- Benefits: Enjoy a dynamic work environment with opportunities for growth and innovation.
- Why this job: Be part of a tech-savvy team that simplifies lives through cutting-edge database solutions.
- Qualifications: Advanced knowledge of MSSQL, T-SQL, and relational database architecture required.
- Other info: Experience with cloud database technologies is a plus!
The predicted salary is between 36000 - 60000 £ per year.
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 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
The 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 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
By applying, I confirm I have read and accept TransPerfect\’s Privacy Policy: https://www.transperfect.com/about/data-privacy-recruiting
Database Administrator employer: TransPerfect
Contact Detail:
TransPerfect Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Database Administrator
✨Tip Number 1
Familiarize yourself with TransPerfect's GlobalLink platform and its database architecture. Understanding their specific systems will give you an edge in discussions during the interview process.
✨Tip Number 2
Brush up on your T-SQL skills and be prepared to discuss how you've optimized databases in previous roles. Real-world examples of performance tuning can showcase your expertise.
✨Tip Number 3
Highlight any experience you have with high availability and disaster recovery solutions, especially with MSSQL. This is a key responsibility in the role, and demonstrating your knowledge will set you apart.
✨Tip Number 4
Prepare to discuss your approach to troubleshooting complex database issues. Being able to articulate your problem-solving process will show that you're ready to handle the challenges of the position.
We think you need these skills to ace Database Administrator
Some tips for your application 🫡
Understand the Role: Before applying, make sure you fully understand the responsibilities and requirements of the Database Administrator position at TransPerfect. Familiarize yourself with their GlobalLink platform and the specific technologies mentioned in the job description.
Tailor Your Resume: Customize your resume to highlight relevant experience and skills that align with the job description. Emphasize your knowledge of MSSQL, T-SQL, and any experience with high availability and disaster recovery solutions.
Craft a Strong Cover Letter: Write a compelling cover letter that showcases your passion for database management and your understanding of TransPerfect's mission. Mention specific projects or experiences that demonstrate your ability to manage and optimize databases effectively.
Highlight Problem-Solving Skills: In your application, provide examples of how you've analyzed and resolved complex database issues in the past. This will show your capability to handle the challenges mentioned in the job description.
How to prepare for a job interview at TransPerfect
✨Showcase Your Technical Skills
Be prepared to discuss your advanced understanding of relational database architecture, especially MSSQL. Highlight your experience with T-SQL, stored procedures, and any relevant tools like SSMS and SSRS.
✨Demonstrate Problem-Solving Abilities
Expect questions that assess your ability to analyze and troubleshoot complex database issues. Prepare examples from your past experiences where you successfully resolved similar challenges.
✨Discuss High Availability and Disaster Recovery
Since managing high availability and disaster recovery is crucial for this role, be ready to explain your experience with these concepts. If you have worked with Always On High Availability Groups, make sure to mention it.
✨Communicate Clearly and Collaboratively
TransPerfect values clear communication and teamwork. Practice articulating your ideas and suggestions effectively, and be open to providing and receiving constructive feedback during the interview.