Senior Cloud DBA Engineer - PostgreSQL & AWS RDS
Job Description
The purpose of this position is to deploy, operate and maintain NICE’s global customer hosted databases, while also resolving customer issues that require direct access to the database infrastructure, and acting in an appropriate professional working style. The Engineer will report to the Manager, Infrastructure Cloud Operations while acting as part of the Database Team managing the databases in AWS Cloud.
Job Responsibilities
• AWS console administration
• New deployment tasks for databases & RDS services
• AWS RDS DB health check & availability checks using tools like CloudWatch and performance Insight.
• Read & analyse log/error log for Databases
• Alerts configuration, monitoring alerts and fine-tuning thresholds
• Perform RDS instance actions and comparison with Terraform code
• Export/import (Postgres) or backup/restore (SQL Server) specific data
• Installing/deploying databases, configuring backups, maintenance jobs and other features as needed to support database capacity, performance or product functionality requirements.
• Performing database administration tasks, including at latest versions of databases.
• Performing data restores, patchset / service pack installation and deinstallation, edition upgrade and downgrade, troubleshoot locking, corruption issues as well as suggest and implement solutions with minimal downtime
• Perform operational duties including database backups, application server health, service recycling.
• Identify and resolve operational issues (e.g. batch failures, network issues, client data feed errors)
• Experience in Monitor server performance, memory utilization, CPU, file systems, databases, batch jobs, backup and restore concept with best practise.
• Prepare, review, test, and execute T-SQL and PowerShell scripts to perform database administrative tasks as assigned.
• Investigate performance issues, provide and implement tuning solutions
• Act as part of a global team, creating and extending existing documentation as well as continuously sharing information and assisting on tasks with other team members.
• Working with monitoring tools
• Experience providing 24x7 support to production Software as a Service infrastructure, including participating in on-call rota and out of hours/weekend support when needed
Requirements
Function: Information Technology
Experience Level: Mid-Senior Level