Apply Now

Redshift DBA || Onsite in Phoenix, AZ || W2 & C2C || Need Local to AZ

Phoenix, AZ, US • Posted 1 day ago • Updated 1 day ago

Contract W2

Contract Corp To Corp

6 Months

Travel Required

Able to Sponsor

On-site

$60 - $65/yr

Value Spectrum Technologies LLC

Fitment

Dice Job Match Score™

📋 Comparing job requirements...

Job Details

Skills

Amazon Redshift
Amazon Web Services
Analytical Skill
Computer Networking
Database
IBM InfoSphere DataStage
Java
Database Administration
Database Design
Middleware
NoSQL
Snow Flake Schema
JavaScript
Neo4j
Golang
Design Documentation
Jenkins
Continuous Integration
Extract, Transform, Load
Backup Administration

Summary

Title: Redshift DBA
Experience: 12+
Location: Phoenix, AZ

Responsibilities
As a Database Admin supporting the bank’s Analytics platforms, you will be part of a centralized team of database engineers responsible for maintaining and supporting the Client''s 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 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.

Required 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
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

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

Dice Id: 91165686
Position Id: 8984674
Posted 1 day ago

Company Info

About Value Spectrum Technologies LLC

Step into a future defined by empowerment at Value Spectrum Technologies. With leading-edge software solutions and strategic consulting, were dedicated to shaping and elevating your digital tomorrow. Experience the synergy of innovation and collaboration as we unlock unparalleled opportunities for growth in the dynamic landscape of technology. Welcome to empowerment.

Join us in navigating the ever-evolving digital landscape with confidence, as we work together to unlock unprecedented opportunities and build a tomorrow that is truly empowered by the limitless possibilities of technology. Your digital future starts here.

Go to company profile

Contact the job poster

Laxminath Pabboju

Recruiter @ Value Spectrum Technologies LLC

View Profile

Create job alert

Never miss an opportunity! Create an alert based on the job you applied for.

Phoenix, Arizona

•

7d ago

Title:SnowflakeDBA Experience:12+ Client:Citizens Bank ResponsibilitiesAs a Database Admin supporting the banks Analytics platforms, you will be a part of a centralized team of database engineers who are responsible for the maintenanceandsupport of Client most critical databases. A Database Engineer will be responsible for: Requires conceptual knowledge of database practicesandprocedures such as DDL, DMLandDCL.Requires howtouse basic SQL skills including SELECT, FROM, WHEREandORDER BY.Abilitytoc

Easy Apply

Contract, Third Party

60 - 65

AI Ops – Senior Architect || Onsite in Phoenix, AZ || W2 & C2C || Need Local to AZ

Phoenix, Arizona

•

12d ago

Role:Senior AI Ops Architect Location:Onsite in Phoenix, AZ Experience:12+Job Description We are seeking a highly skilled AI Ops Senior Architect to lead the design, implementation, and optimization of AI-driven operational platforms across large-scale, mission-critical environments. The ideal candidate will possess deep expertise in machine learningenabled operations, observability, automation frameworks, cloud engineering, and enterprise SRE/DevOps practices. This role will drive the transfo

Easy Apply

Contract, Third Party

60 - 65

DevSecOps Senior Architect With SRE || Onsite in Phoenix, AZ || W2 & C2C

Phoenix, Arizona

•

14d ago

Role:Senior DevSecOps Architect Location:Onsite in Phoenix, AZ Experience:10+Job Description We are seeking a highly experienced DevSecOps Senior Architect to lead the design and implementation of secure DevOps practices across enterprise cloud environments. The role involves defining DevSecOps strategy, building secure CI/CD pipelines, integrating automated security tools, and architecting cloud and container security controls. Key Skills: DevSecOps architecture, governance, and security frame

Easy Apply

Contract, Third Party

80 - 85

Network Engineer with SRE || Onsite in Phoenix, AZ || W2 & C2C || Need Local to Phoenix, AZ

Phoenix, Arizona

•

Today

Role: Network Engineer with SRE Location:Onsite in Phoenix, AZ Experience:10+ Role Summary We are seeking a Network SRE to ensure the reliability, scalability, and performance of cloud and hybrid network platforms.This role applies SRE principles to networking by shifting from manual network operations to automated, observable, and resilient network services.The ideal candidate is a network engineer who thinks like a software engineer and SRE. Key Responsibilities Network Reliability Engineerin

Easy Apply

Third Party, Contract

60 - 65

Search all similar jobs

Redshift DBA || Onsite in Phoenix, AZ || W2 & C2C || Need Local to AZ

Value Spectrum Technologies LLC

Dice Job Match Score™

Job Details

Skills

Summary

Company Info

About Value Spectrum Technologies LLC

Laxminath Pabboju

Similar Jobs