Redshift Database Admin L1 - L5

Responsibilities

As a Database Engineer supporting the bank’s Analytics platforms, you will be a part of a centralized team of database engineers who are responsible for the maintenance and support of Citizens’ most critical databases.  

A Database Engineer will be responsible for:

• Requires conceptual knowledge of database practices and procedures such as DDL, DML and DCL. 
• Requires how to use basic SQL skills including SELECT, FROM, WHERE and ORDER BY. 
• Ability to code SQL Joins, subqueries, aggregate functions (AVG, SUM, COUNT), and use data manipulation techniques (UPDATE, DELETE). 
• Understanding basic data relationships and schemas. 
• Develop Basic Entity-Relationship diagrams.
• Conceptual understanding of cloud computing
• Can solves routine problems using existing procedures and standard practices.
• Can look up error codes and open tickets with vendors
• Ability to execute explains and identify poorly written queries
• Review data structures to ensure they adhere to database design best practices.  
• Develop a comprehensive backup plan.
• Understanding the different cloud models (IaaS, PaaS, SaaS), service models, and deployment options (public, private, hybrid).
• Solves standard problems by analyzing possible solutions using experience, judgment and precedents.
• Troubleshoot database issues, such as integrity issues, blocking/deadlocking issues, log shipping issues, connectivity issues, security issues, memory issues, disk space, etc.
• Understanding of basic security concepts like user access control and data encryption. 
• Complies with the regulations for data security. Ensures personal data is gathered legally and under strict conditions. 
• Protects the data against accidental loss, destruction, or damage.
• Ability to write simple stored procedures for reusable code and improved performance. 
• Run simple data loads and unloads
• Attention to detail and demonstrate a customer centric approach.

Required

• 3+ years of experience with database management/administration, Redshift, Snowflake or Neo4J

• 3+ years of experience working with incident, change and problem management processes and procedures.

• Experience maintaining and supporting large-scale critical database systems in the cloud.

• 2+ years of experience working with AWS cloud hosted databases

• An understanding of multiple programming languages, including at least one front

• Experience with agile development methodology

• SQL performance & tuning skills

• Excellent communication and client interfacing skills

Desired Qualifications

• Experience working in an agile development environment

• Experience working in the banking industry

• Experience working in cloud environments such as AWS, Azure or Google

• Experience with CI/CD pipeline (Jenkins, Liquibase or equivalent)

Education and Certifications

• Bachelor’s degree in computer science or related discipline