Database Engineering Manager

Job Title: Database Engineering Manager

As a Database Engineering Manager, you will be supporting our banking client's Analytics platforms. You will be responsible for managing a centralized team of database engineers for the maintenance and support of the client's most critical databases.

A Database Engineering Manager Responsibilities:

• Define database strategy, architecture, and technology choices; Ensure scalable, resilient, and high-performance data systems supporting mission-critical applications.
• Ability to design and implement a highly performing database using partitioning & indexing that meet or exceed the business requirements.
• Ownership of the complete deliverables from inception to delivery from the client's Global Capability Center (GCC).
• Solves complex problems by taking a new perspective on existing solutions; exercises judgment based on the analysis of multiple sources of information
• Expertise with database practices and procedures such as DDL, DML and DCL.
• Understanding and developing data relationships, schemas and Entity-Relationship Diagrams.
• Understanding of cloud computing; cloud security concepts, including data protection, access control, and compliance.
• 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.
• Identifies, assesses, and treats risks that might affect the confidentiality, integrity, and availability of the organization's assets.
• Documents a complex software system design as an easily understood diagram, using text and symbols to represent the way data needs to flow.
• 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.
• 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.

Required Qualifications

• 5+ years of experience with managing database and cross-functional teams
• 12+ years of experience maintaining and supporting large-scale critical database systems in the cloud.
• 12+ 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.
• 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