Database Administrator | Pune
Job Description
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