Job Description :
Database Lead/Application DBA
Location is Lansing MI
2 years
We are implementing an extensive set of integration tests for a system that
conducts over 4 billion dollars of business per year. One of the challenges
is that as we re-factor modules and add features the database schema will
change which we know will break some integration tests. We have a strong
focus on Test validated development which means we must always have a
database loaded with sufficient data to ensure we can run a full set of
integration tests quickly. This is complicated by the fact that we are
covered by HIPAA rules that prevent using production data in some test
environments so we will have some environments with a de-identified or
synthetic data set and others such as Stage where the full data set will be
present. The job of the database refresh lead is to work with our
development leads to understand what schema changes are coming then plan and
implement processes to ensure they always have a viable test database. This
person will also assist in database migration scripts and act as backup DBA
to approve or comment on proposed schema changes. This will require
significant coding in languages like Java and Python as well as extensive
SQL and DBA skills.
If you are a DBA who still prefers to write code and thrives on writing
complex scripts to transform data in several different languages and have a
strong TDD mindset then you are the person we need. You need to be a
self-starter with good communication skills who can draft a plan by
extracting knowledge from many engineers who only have partial visibility to
the stack
MINIMUM QUALIFICATIONS
Database migration scripting
Experience deploying domain schema changes with minimal downtime
Extensive skills using database extracts; convert in python and
reload using bulk loading tools.
Recent Java and J2EE exposure with seven years of experience.
Experience writing RESTful services with JSON
RDBMS schema refactoring experience with experience releasing
breaking changes to prod with minimal downtime
4+ years'' experience in SQL and Oracle
Excellent communication skills with the ability to solicit and
formalize requirements and work with end users/customers
Ability to work in a semi-structured environment where requirements
and priorities are dynamic
HIGHLY DESIRABLE QUALIFICATIONS
Experience with agile development methodology
Experience in HIPAA and PCI security Domain
Experience with Webscale technologies such as Kafka, Memcache, Riak,
AWS, Shared nothing architectures
Experience with Test Driven Design (TDD) methodology
JavaServer Faces (JSF) technology knowledge and experience.
Good understanding of junit testing and continuous integration
environment.
Working knowledge of developing and deploying applications in
Weblogic portal environment.
Understanding of Service Oriented Architecture and experience
working with web services.
Experience in the insurance industry, specifically with the health
care industry.
Bachelor of Science in Computer Science, Information Systems,
Engineering or a related field or comparable work experience.
This job''s responsibilities may include task assignment to support,
administer, or access systems, which contractually requires ADP I or II
Public