Senior Specialist Cloud Database Engineer

NICE
Summary
Join NICE, a global leader in customer experience, financial crime fighting, and public safety solutions, as a Database Engineer. In this role, you will deploy, operate, and maintain NICE's global customer-hosted databases, resolving customer issues requiring direct database infrastructure access. You will report to the Manager, Infrastructure Cloud Operations and collaborate with the Database Team, managing databases in on-prem data centers and AWS Cloud. Responsibilities include AWS console administration, database deployments, health checks, log analysis, alert configuration, and performance tuning. You will also perform database administration tasks, including backups, restores, and troubleshooting. The position requires 12+ years of DBA experience managing multiple DB engines and hands-on experience with Oracle and MS SQL databases. NICE offers a hybrid work model (NICE-FLEX) with 2 days in the office and 3 days remote.
Requirements
- 12+ Yrs. of experience as DBA in managing multiple DB engines
- Hands on experience in multiple versions of Oracle and or MS SQL database is mandatory
- Understanding of ITIL β incidents, service requests, change management
- Willingness to learn about technologies related to database and backup infrastructure, such as storage, backup, operating system and automation tools, cloud solutions or other database technologies
- Demonstrated ability to effectively establish and maintain cooperative working relationships within a global, diverse, multicultural environment
- Bachelor or Masterβs Degree on Computer science or Information technology streams
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 (Oracle) 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
- Have a strong skills & experience in Microsoft SQL performance tuning and queries optimization. Used SQL Profiler, Execution Plan, extended event, Performance Monitor and DBCC Commands
- Extensive experience in SQL server high availability solutions- Log shipping, Mirroring, Replication, Clustering and always ON
- 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
Preferred Qualifications
- Knowledge or experience working in Oracle, Microsoft SQL, Aurora, MySQL, Postgres will be an added advantage
- Understand how automated backups are performed by AWS, know how to check the historical backup timings and how to perform ad-hoc snapshot
- Basic coding skills in Python, Terraform
- Nice to have knowledge on AWS Cloud, AWS RDS apart from DB technology
Benefits
- Enjoy NICE-FLEX!
- At NICE, we work according to the NICE-FLEX hybrid model, which enables maximum flexibility: 2 days working from the office and 3 days of remote work, each week