Database Engineer

Job Title

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 cloud security concepts, including data protection, access control, and compliance.
• Manages risks that are associated with the use of information technology.
• Identifies, assesses, and treats risks that might affect the confidentiality, integrity, and availability of the organization's assets.
• Ability to design and implement a highly performing database using partitioning & indexing that meet or exceed the business requirements.
• Documents a complex software system design as an easily understood diagram, using text and symbols to represent the way data needs to flow.
• Ability to code complex SQL.
• Performs effective backup management and periodic databases restoration testing.
• General DB Cloud networking skills – VPCs, SGs, KMS keys, private links.
• Knowledge of firewalls, antivirus, encryption software, access control systems, audit logs, backup software, and recovery software.
• Ability to develop stored procedures and at least one scripting language for reusable code and improved performance. Know how to import and export data into and out of databases using ETL tools, code, migration tools like DMS or scripts
• Knowledge of DevOps principles and tools, such as CI/CD.
• Solves complex problems by taking a new perspective on existing solutions; exercises judgment based on the analysis of multiple sources of information
• Ability to optimize queries for performance and resource efficiency
• Review database metrics to identify performance issues.
• Ability to design, document and implement highly available resilient database architectures for multiple DB platforms including NoSQL.
• Knowledge of full-text indexing & composite indexes.
• Implement strategies like failover, load balancing, and disaster recovery solutions.
• Review, test and document when and how to use new database features.
• Attention to detail and demonstrate a customer centric approach.
• Ability to develop clear concise documentation. Willingness to continuously improve and enhance your skills.

Required

• 8+ years of experience with database management/administration, Redshift, Snowflake or Neo4J
• 8+ 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.
• 3+ years of experience working with AWS cloud hosted databases
• An understanding of multiple programming languages, including at least one front end framework (Angular/React/Vue), such as Python3, Java, JavaScript, Ruby, Golang, C, C++, etc.
• Experience with cloud computing, ETL and streaming technologies – OpenShift, DataStage, Kafka
• Understanding of Application Integrations –PaaS/Middleware.
• Experience with agile development methodology
• Strong 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