Database Engineer

Job Overview:

multiple levels

Responsibilities

• Requires conceptual knowledge of database practices and procedures such as DDL, DML and DCL.
• Knowledge/ Experience with database management/administration, Redshift, Snowflake or Neo4J
• 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.
• Understanding the different cloud models (IaaS, PaaS, SaaS), service models, and deployment options (public, private, hybrid).
• 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.
• 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.
• Attention to detail and demonstrate a customer centric approach.
• 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.

Required

• Experience with database management/administration, Redshift, Snowflake or Neo4J
• Working with incident, change and problem management processes and procedures.
• Experience maintaining and supporting large-scale critical database systems in the cloud.
• Experience working with AWS cloud hosted databases
• An understanding of one 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
• Strong SQL performance & tuning skills
• Excellent communication and client interfacing skills
• Experience working in the banking industry
• Experience working in an agile development environment
• Experience working in cloud environments such as AWS, Azure or Google
• Experience with CI/CD pipeline (Jenkins, Liquibase or equivalent)