Senior DBA

Overview

Summary : Responsible for coordinating changes to computer databases, test and implement the database applying knowledge of database management systems. Responsible for planning, coordinating and implementing security measures to safeguard the computer database.

Responsibilities

• Design, engineer, and deploy on a breadth of RDBMS and NoSQL database technologies and platforms such as Db2 LUW, Netezza, Oracle, SQL Server, Postgres, MongoDB, AWS RDS, Redshift, other DBMS technologies.
• Design and develop optimal solutions to migrate or upgrade existing databases to new platform or DBMS versions
• Build and leverage automation and DB DevSecOps pipelines to provision, upgrade, patch and maintain DB systems
• Support DB change request and problem investigation and resolution of both production and non-production environments.
• Monitor capacity, high-availability and performance for non-production and production databases to ensure they are highly reliable, efficient, cost effective, and provide the required functionality.
• Seeks opportunities to improve database performance by identifying tuning measures and implementing them when appropriate.
• Develops and maintains database backup and recovery strategy and procedures. Ensures that databases are properly backed up and recovered when necessary
• Ensures databases are properly maintained, meeting security, audit and compliance requirements. Databases are reorganized / groomed when necessary and other DBA utilities run when appropriate.
• Tests upgrades / new releases of database software and related products. Assesses impacts to application and the database environment.
• Responds immediately to critical issues. On call and / or shift duty may be required.

Requirements

#J-18808-Ljbffr