Database Engineer (SQL Server / MSSQL) at TransPerfect
TransPerfect helps organizations navigate the global marketplace. The TransPerfect TechOps team delivers technology and services that simplify the lives of clients and colleagues, including scalable client interfaces and core services for the GlobalLink platform.
Overview
The Database Engineer will work directly with senior developers to design, test, plan, protect and implement our department’s databases.
Responsibilities
- 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 provide 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 peers
- Developing and deploying new database objects and changes to existing objects including tables, stored procedures, views, etc.
- Creating complex functions, scripts, stored procedures and triggers to support application development
- Designing, developing and maintaining a multitude of complex relational database reports using SSRS
Qualifications (minimum we’re looking for)
Advanced understanding of relational database architecture / infrastructure, specifically MSSQLKnowledge of SSMS, SSRS, and support toolingKnowledge of T-SQL, stored procedures, and day-to-day DB functionsAdvanced knowledge of how to optimize MSSQL, support HA / DR, etc.Strong knowledge of systems and software development lifecycles; application integration techniques; and relational database designExperience with Always On High Availability Groups is a plusAbility to analyze, troubleshoot and break down complex problemsAbility to choose appropriate tasks relative to workload and communicate ideas clearly to manager and peersParticipate in code reviews and offer constructive feedbackExperience with cloud database storage technologiesAdditional Information
Privacy policy : Upon applying, I confirm I have read and accept TransPerfect's Privacy PolicySeniority level : Mid-Senior levelEmployment type : Full-timeJob function : Information Technology and EngineeringIndustries : Translation and Localization and Software DevelopmentTransPerfect values referrals and keeps candidates informed about new opportunities in their area.
Location : Madrid, Community of Madrid, Spain
#J-18808-Ljbffr