高级云数据库管理员工程师 - PostgreSQL & AWS RDS
Senior Cloud DBA Engineer - PostgreSQL & AWS RDS
One Sutherland 是一个全球团队，每个人都在共同努力创造突破性的解决方案。我们的员工在一个思想、经验和背景多样化的环境中茁壮成长。我们庆祝并全心全意地拥抱多样性。Sutherland 是一家平等机会雇主。我们通过专业地行事并互相帮助实现“One Sutherland 团队，赢在赛场”的目标，营造积极的工作环境。
Sutherland 成立于 38 年前（1986 年）。从那时起，我们已成为领先的全球业务流程和技术管理服务提供商，提供以分析驱动的后台和面向客户的解决方案组合，支持整个客户生命周期。
该职位的目的是部署、运营和维护 NICE 的全球客户托管数据库，同时解决需要直接访问数据库基础设施的客户问题，并以适当的专业工作方式行事。工程师将向基础设施云运营经理汇报，同时作为数据库团队的一员，负责管理 AWS 云中的数据库。
岗位职责
· AWS 控制台管理
· 数据库和 RDS 服务的新部署任务
· 使用 CloudWatch 和性能洞察等工具对 AWS RDS 数据库进行健康检查和可用性检查
· 阅读和分析数据库的日志/错误日志
· 配置警报、监控警报并优化阈值
· 执行 RDS 实例操作并与 Terraform 代码进行比较
· 导出/导入（Postgres）或备份/恢复（SQL Server）特定数据
· 安装/部署数据库，配置备份、维护作业和其他功能，以支持数据库容量、性能或产品功能需求
· 执行数据库管理任务，包括最新版本的数据库
· 执行数据恢复、补丁集/服务包安装和卸载、版本升级和降级、解决锁定、损坏等问题，并提出并实施最小停机时间的解决方案
· 执行操作职责，包括数据库备份、应用服务器健康状况、服务回收
· 识别并解决操作问题（例如批量失败、网络问题、客户端数据馈送错误）
· 具备监控服务器性能、内存使用、CPU、文件系统、数据库、批量作业、备份和恢复概念的最佳实践经验
· 准备、审查、
查看英文原文
We are One Sutherland — a global team where everyone is working together to create great breakthrough solutions. Our workforce has thrived in an environment of diversity of thought, experience and background. We celebrate our diversity and embrace it whole-heartedly. Sutherland is an equal opportunity employer. We promote a positive work environment by conducting ourselves professionally and helping each other achieve our goal of One Sutherland Team, Playing to Win.
Sutherland was founded 38 years ago (1986). Since then, we have become a leading global provider of business process and technology management services offering an integrated portfolio of analytics-driven back office and customer-facing solutions that support the entire customer life cycle.
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
- 6 to 10 Yrs. of experience as DBA in managing multiple DB engines.
- Minimum 6 years relevant experience as DBA.
- Hands on experience in multiple versions of Postgres database is mandatory.
- Knowledge or experience working in Microsoft SQL, Aurora, MySQL will be an added advantage.
- Hands on experience on AWS Cloud, AWS RDS apart from DB technology.
- Basic coding skills in Powershell, Python, Terraform
- Understand how automated backups are performed by AWS, know how to check the historical backup timings and how to perform ad-hoc snapshot
- 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
This position is remote in Colombia.