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

TNS Inc.; Bengaluru; On-site; INR 2,500,000 - 4,000,000; Full time

Job summary

TNS Inc. Bengaluru-based Senior DBA role requires strong expertise in database administration for on-prem and AWS cloud environments. You will manage PostgreSQL, MySQL, and MS SQL Server, and collaborate with Global System Admins, Product development, QA, and DevSecOps teams.

Responsibilities include installation, upgrades, migrations, scripting for automation, backups, DR testing, performance tuning, and proactive monitoring. Eligible to work in a 24x7 on-call rotation.

Qualifications

• 10+ years’ experience supporting/managing large multi-terabyte production databases.
• Advanced database management skills including monitoring, performance tuning and capacity planning.
• Backup and recovery processes; UNIX shell scripting, and SQL skills.
• Experience managing infrastructure including server, storage, and network.
• Bachelors or Masters in CS/Data Eng; AWS Public Cloud knowledge.

Responsibilities

• Install, configure, upgrade, migrate, and patch RDBMS databases in on-prem and AWS.
• Provide technical guidance on large, complex database projects.
• Write and maintain Unix shell scripts for automation of DBA tasks.
• Review space reports and manage backups and restores.
• Serve as primary contact for database support and troubleshooting.
• Perform root-cause analysis, status updates, and outline resolutions.
• Design and test Disaster Recovery scenarios.
• Proactively monitor production databases to prevent issues.
• Communicate milestones, SLAs, and resources to stakeholders.
• Design solutions and architecture for new systems; migrate on-prem to AWS with minimal downtime.
• Participate in 24x7 on-call rotation (about 1 week per month).

Skills

Database administration

Unix shell scripting

AWS

PostgreSQL

MySQL

MS SQL Server

Troubleshooting

On-call rotation

Education

Bachelors or Masters in CS/Data Eng

Tools

AWS

RDS

Aurora

CloudWatch

Splunk

Job description

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.
• Backup and recovery processes; UNIX shell scripting, and SQL skills
• Experience managing infrastructure systems, including server, storage, and network.
• Bachelors or Masters degree in Computer Science/Data Engineering
• Working knowledge of AWS Public cloud, RDS, Aurora, Cloud watch, Splunk
• Working knowledge of Data Warehouse (DW), BI Reporting Knowledge of Data modeling, pros and cons of normalization
• Knowledge of CI/CD automations and Database deployment tools

If you are passionate about technology, love personal growth and opportunity, come see what TNS is all about! TNS is an equal opportunity employer. TNS evaluates qualified applicants without regard to race, color, religion, gender, national origin, age, sexual orientation, gender identity or expression, protected veteran status, disability/handicap status or any other legally protected characteristic. With employees based in 21 countries around the world, TNS is a leading global provider of data communication and interoperability services to diverse industries, such as retail, banking, payment processing, telecommunications and the financial markets. TNS’ services extend to over 60 countries and we deliver mission critical solutions to many Fortune 500 companies. TNS employees play a vital role in the delivery of our services and we recognize them as our most valuable asset. We are proud to offer competitive salaries and benefit packages, and due to the global nature of our business we can offer opportunities to relocate to different locations, if your personal circumstances change.