Redshift DBA

his Database Engineer role requires experience working in a service oriented environment, a high sense of ownership of the projects and tasks assigned, focus on managing and resolving issues in a prompt & efficient manner, establishing and maintaining communication with technology customers to keep them updated with status of their requests, initiating and performing changes on production systems and proactively escalating any issues that cannot be resolved within the established timeframes.

Responsibilities:

Working with other members of the Database Services and external development teams to deliver projects specified in our company roadmap

Owning, tracking and resolving database related incidents and requests across the following database platforms (PgSQL, SQL Server, Opensearch, Redshift)

Fulfilling requests and resolving incidents within SLAs.

Reviewing service-related reports (e.g. database backups, maintenance, monitoring) on a daily basis to ensure operational issues are identified and resolved promptly.

Responding to database related alerts and escalations and working with database engineering to come up with strategic solutions to recurring problems.

Identifying opportunities for process improvement including enhancing automation for database platform provisioning

Enhancing database monitoring & alerting platforms to ensure proactive alerting is always achieved.

Promotion of database engineering best practices within our cross-functional development teams.

Coaching / mentoring junior engineers.

Where you’ll be working:

This hybrid role will have a defined work location that includes work from home and assigned office days as set by the manager.

You’ll need to have:

Five or more years experience with management & operations of Database technologies & services with the majority of your recent experience in the AWS platform.

Strong analytical & problem solving skills

In-depth experience in one or more of the following Technologies operating in a high-volume, high-throughput environment.

PgSQL

Opensearch/ElasticSearch

Redshift

SQL Server

Experience with the above technologies to include but not limited to the following:-

General Database Administration Tasks

Database Troubleshooting & Performance Reviews

Database & Index Design & Maintenance

Design & Maintenance of Partitioning

Database Upgrades

High Availability & Disaster Recovery Options

Performance Tuning & optimisation

Security Hardening & Access Provisioning

Monitoring & Alerting

Experience in managing database platforms which operate regulatory controls such as GDPR/CCPA/CPRA, HIPPA, SOCII etc.

Experiencing in designing, development & maintaining CI/CD pipelines for AWS Infrastructure & Database Code deployments (using services such as GIT, Bamboo, Powershell, RedGate Flyway, Cloud Formation Templates, etc.)

Ability to troubleshoot software, hardware & service related issues.

Excellent organizational skills & attention to detail

Excellent written and oral communication skills

Ability to coach, mentor, and influence team members through the necessary database disciplines

Even better if you have one or more of the following:

A bachelor’s or associate degree in management information systems, computer science or a related field.

Strong experience in agile/lean methodologies and processes (ideally Kanban or scrum) leading process improvements and engineering disciplines.

Deployment & operational support experience in any of the following

SQL Server

DynamoDB

GraphDB

Redis

Experience managing defect backlogs and requirements management with relevant tools (e.g., JIRA).