Overview
Skills
Job Details
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 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 the common threats and vulnerabilities that affect databases, such
as SQL injection, data breaches, ransomware, denial-of-service, and human
errors, and how to prevent and mitigate them.
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.
Design & Implement strategies like failover, load balancing, active/active and
disaster recovery solutions.
Prepare solution designs & approaches, product standards, and other
architectural diagrams and present them to tech boards.
Researches, designs, applies, and evaluates new information technologies for
business environments.
Ability to design and deploy CI/CD pipelines using terraforms, bit bucket and
Jenkins pipelines.
Leads others to solve complex problems; uses analytical thinking, tools and
judgement to identify innovative solutions.
Required Qualifications
10+ years of experience with database management/administration, Redshift,
Snowflake or Neo4J
10+ 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
Experience with agile development methodology
Deep understanding of Application Integrations PaaS/Middleware.
Strong SQL performance & tuning skills
Excellent communication and client interfacing skills
Ability to mentor junior team members. Maintain a proactive and results-driven
mindset.
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