Database Admin with Redshift || Onsite in Phoenix, AZ || W2 & C2C || Need local to AZ

Responsibilities

• Supports the bank’s Analytics platforms as part of a centralized team of database engineers.
• Maintain and support the Client’s most critical databases.
• Develop Basic Entity-Relationship diagrams.
• Conceptual understanding of cloud computing.
• Solve routine problems using existing procedures and standard practices.
• Execute explains and identify poorly written queries.
• Review data structures to ensure they adhere to database design best practices.
• Develop a comprehensive backup plan.
• Manage risks associated with the use of information technology.
• Identify, assess, and treat risks that might affect the confidentiality, integrity, and availability of the organization's assets.
• Design and implement a highly performing database using partitioning & indexing that meet or exceed the business requirements.
• Document a complex software system design as an easily understood diagram, using text and symbols to represent the way data needs to flow.
• Code complex SQL.
• Perform effective backup management and periodic databases restoration testing.
• General DB Cloud networking skills – VPCs, SGs, KMS keys, private links.
• Understand 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.
• Design & Implement strategies like failover, load balancing, active/active and disaster recovery solutions.
• Review, test and document when and how to use new database features.
• Optimize queries for performance and resource efficiency.
• Design, document and implement highly available resilient database architectures for multiple DB platforms including NoSQL.
• Implement strategies like failover, load balancing, active/active and disaster recovery solutions.
• Research, design, apply, and evaluate new information technologies for business environments.
• Design and deploy CI/CD pipelines using terraform, bitbucket and Jenkins pipelines.
• Lead others to solve complex problems; uses analytical thinking, tools and judgement to identify innovative solutions.

Requirements

• Conceptual knowledge of database practices and procedures such as DDL, DML and DCL.
• 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.
• Conceptual understanding of cloud computing.
• Ability to solve routine problems using existing procedures and standard practices.
• Ability to look up error codes and open tickets with vendors.
• Ability to execute explains and identify poorly written queries.
• Ability to review data structures to ensure they adhere to database design best practices.
• Ability to develop a comprehensive backup plan.
• Understanding the different cloud models (IaaS, PaaS, SaaS), service models, and deployment options (public, private, hybrid).
• Ability to 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.
• Ability to manage risks that are associated with the use of information technology.
• Ability to identify, assess, and treat 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.
• Ability to document 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.
• Ability to perform effective backup management and periodic databases restoration testing.
• Ability to manage general DB Cloud networking skills – VPCs, SGs, KMS keys, private links.
• Ability to understand 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 design, document and implement highly available resilient database architectures for multiple DB platforms including NoSQL.
• Ability to implement strategies like failover, load balancing, active/active and disaster recovery solutions.
• Ability to review, test and document when and how to use new database features.
• Ability to optimize queries for performance and resource efficiency.
• Ability to review database metrics to identify performance issues.
• Ability to design, document and implement highly available resilient database architectures for multiple DB platforms including NoSQL.
• Ability to implement strategies like failover, load balancing, active/active and disaster recovery solutions.
• Ability to research, design, apply, and evaluate new information technologies for business environments.
• Ability to design and deploy CI/CD pipelines using terraform, bitbucket and Jenkins pipelines.
• Ability to lead others to solve complex problems; uses analytical thinking, tools and judgement to identify innovative solutions.

Qualifications

• 15+ years of experience with database 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.
• A deep understanding of Application Integrations –PaaS/Middleware.
• Strong SQL performance & tuning skills.
• Excellent communication and client interfacing skills.
• Ability to mentor junior team members.
• A proactive and results-driven mindset.