Report this job

---

What is the problem? *

Incorrect company
Incorrect location
Job is expired
Job may be a scam
Other

About Genzeon:

Genzeon is delivering excellence in IT services and solutions for the healthcare and retail sectors. Genzeon is a leading provider of intelligent automation, security, compliance, cloud, and managed services. Our healthcare capabilities integrate data systems, facilitate information flow, and leverage interoperability to improve clinical and operational outcomes. Genzeon empowers retail enterprises with multichannel IT solutions that deliver a personalized experience for consumers.

We have an exciting opportunity for Database Developer in Seattle, WA and Austin, TX (Onsite from Day1).

Database Developer

Onsite in Seattle or Austin.

1 Year

Details

Are you passionate about working with data/database technologies and have a consistent track record of delivering high quality BigData solutions. As part of this team, you will be responsible for the delivery of solutions on top of the MPP databases/Hadoop platform implementation and will be playing a key role in this huge technology pivot.

You will not only help train our existing staff making the leap over to our new technologies, but you will also empower the team to approach problems differently.

These solutions drive business value from powering the most critical business decisions to powering how the site behaves through various avenues of personalization.

This entails working with the delivery team and business partners to flush out requirements, complete solution design, development and ultimate delivery to the end consumers.

General Responsibilities:

Design database applications, such as interfaces, data transfer mechanisms, global temporary tables, data partitions, and function-based indexes to enable efficient access of the generic database structure. Develop load-balancing processes to eliminate down time for backup processes. Develop data models for applications, metadata tables, views or related database structures. Develop data models for applications, metadata tables, views or related database structures. Identify, evaluate and recommend hardware or software technologies to achieve desired database performance. Plan and install upgrades of database management system software to enhance database performance. Level II Intermediate level resource with significant experience.

• Development of high-quality database solutions ensuring performance, security, and availability of databases
  Strong understanding of distributed systems, operating systems, networking, databases, security, and analytics.
  Experience developing continuous integration, continuous delivery, and continuous deployment pipelines for distributed apps.
  Participating in the design and database and able to create ER diagrams, integrate with applications and reporting
  Able to write tests for SQL connectivity, data validation and for performance throughput
  Strong proficiency with SQL and its variation among popular databases
  Knowledge of best practices when dealing with relational databases
  Good understanding of ANSI SQL code and databases such as MS sql server, Teradata and Postgres SQL
  Creating and maintain database objects such as Tables, Views, and Stored Procedures
  - Develop various facets of the Hadoop ecosystem, data processing, and Map Reduce jobs.

Developer requirements and qualifications
Candidate must have 8-10 years demonstrable programming experience in SQL development
A minimum of 6-year experience in MS SQL SERVER including proficiency in SQL and stored procedures.
Excellent understanding of Microsoft SQL Server , Teradata and Oracle
Develop, implement, and optimize queries, procedures and functions using T-SQL (DQL, DML, DDL, DCL and TCL).
Excellent knowledge in creating objects like Indexed Views, complex Stored Procedures, effective functions, and appropriate Triggers to facilitate efficient data manipulation and data consistency.
Hands on experience with performance tools like SQL Profiler, Index Tuning Wizard and Database Engine Tuning Advisor.
Experience with ETL technologies, hands on experience with developing, deploying, and monitoring packages for ETL tasks using Informatica/ SSIS DTS Import/Export Utility, BCP and DTS packages.
Excellent understanding of T-SQL programming and Teradata SQL
Understanding PERL for any legacy code debugging, ability to write shell and python scripts
Hands on experience using SQLServer agent jobs and logshipping for SQLServer
Develop a test framework for database migrations to compare objects and data from source systems to target systems
Write test cases for comparing performance throughput across Hybrid data centers, and capturing and storing the results for performance benchmarking

Data engineering team that builds solutions both onPrem and into cloud. Build data pipelines, system migrations, cloud engineering database setup etc.