Snowflake & Redshift DBA || Onsite in Phoenix, AZ || W2 & C2C

Title: Snowflake DBA
Experience: 12+
Client: Citizens Bank

• 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 solve 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 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, bitbucket and Jenkins pipelines.
• Leads others to solve complex problems; uses analytical thinking, tools and judgement to identify innovative solutions.

• 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
• 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.

• 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)

• Bachelor’s degree in computer science or related discipline