Senior Database Administrator Postgres/MySQL/MariaDB/MSSQL-Server

An extraordinarily talented group of individuals work together every day to drive TNS' success, from both professional and personal perspectives. Come join the excellence!

##

Overview

• This role requires strong technical expertise in the areas of Database administration in both on-prem data centers and AWS cloud and provide L3 production support.

This Sr DBA role is responsible for development and administration of software systems utilizing both SQL (PostgreSQL, MySQL, and MS SQL Server) and no-SQL databases by collaborating with various internal teams including Global System Admins, Product development, QA, DevSecOps teams.

##

Responsibilities

• Must have hands on Database expertise, must serve as a go-to-DBA
• Excellent communication and collaboration skills
• Must work independently with minimum supervision
• Install, configure, upgrade, migrate, and patch various RDBMS databases including PostgreSQL, MySQL, MicroSoft SQL Server in traditional on-prem set up as well in AWS public cloud.
• Provide technical guidance on large, complex database projects.
• Write and maintain Unix shell scripts to facilitate and automate database administration tasks.
• Review space reports, responding to non-critical requests for assistance, and manage data backups and restores.
• Serve as primary point of contact for technical support and troubleshooting of database management issues.
• Perform problem resolution for complex issues including root cause analysis, status updates, and outline resolution options.
• Design and test Disaster Recovery scenarios.
• Review and establish policies, procedures, and standards relating to database management.
• Proactively monitor production databases to circumvent potential problems and errors.
• Perform continuous quality improvements by learning new technologies, product trends and/or database administration techniques
• Define and communicate project milestones, service level agreements, and resource allocation to executive team, department leads, support staff, and end users.
• Design creative solutions to address proprietary database issues, including development of architecture for new systems.
• Working knowledge of migrating on-prem databases into AWS cloud with minimum downtime
• Should be part of 24x7 on-call DBA rotation schedule (about 1 week per month)

##

Qualifications

• 10+ years’ experience supporting supporting/managing multiple, high volume, large multi-terabyte production databases.
• Advanced database management skills including Database monitoring, performance tuning and capacity planning; proven experience implementing and supporting SQL Tuning.