SQL DBA
- Full-time
Company Description
Veredus recently named one of the “Best Staffing Firms to Work for in 2012″ by Staffing Industry Analysts!
6 months contract
$45/hr
Job Description
Day to day responsibility
Ability to understand and analyze data models – how the data is stored in relational databases
Design and development of complex large scale OLTP system in Oracle environment
Manage a small team of data engineers responsible for performing various data analysis and on-going data base design and development
Obtain, scrub, explore, model and interpret data currently stored in Oracle databases – using SQL and other data mining tools like SAS or SPSS Modeler
Ability to understand system integration aspects of integrating model input and output in transactional systems to help real time decision making
Good understanding software application architecture and develop integration approaches for predictive models
Understand the data flow in ATS systems for targeting and incorporate models from both input and output perspective into these streams
Skills required
10-15 years of experience in data base programming, data modeling and design and development of large OLTP database using Oracle preferably running on Exadata.
3-5 years of leadership experience
Strong SQL programming skills
Experience in Oracle application design (e.g. Enterprise Manager, SQL Developer)
Experience in database/SQL performance tuning of large – multi-terabytes OLTP database
Hands-on experience creating and maintaining conceptual, logical and physical data models, preferably using ERwin 7.3 or later.
Hands-on experience developing fully normalized relational (3NF) data models
Candidate must be familiar modeling data structures to accommodate large scale (multi-terabytes) OLTP database systems
Experience in application/database documentation development, Database documentation: design/implementation recommendations, updated design specifications/database diagrams, data dictionaries, generate PDM DDLs, updated coding standards, performance tuning parameters.
Ability to support and assist the development and testing team in the design and implementation of database applications
Experience in performing data quality analysis and profiling tasks, including: Source/target assessments, Data model integrity, Redundancy checks, Ranges and outliers Sparsity/density metrics.
Prior experience in working with Customs or ICE travel related data a plus
Experience with statistics, modeling and machine learning techniques a plus
Advanced – Master’s degree Computer Science or Applied Mathematics or Computational Statistics preferred
Strong organization and time management skills – prior experience in leading a small team is preferred
Excellent oral and written communication skills
Ability to work effectively within a team environment
Ability to work effectively in a high energy and a very rapid dynamic environment
Additional Information
Why Veredus?
Candidates work with a professional recruiter whose average experience is eight years in the industry. That means they have intimate knowledge of the Information Technology industry and market trends-who is in demand now and who will be next. Your Veredus Recruiter will lead you through a thorough screening process in order to understand your skills, experience, needs, and desires. They also counsel their candidates in resume writing, interviewing, and career planning so when there’s a position you really want, you’re fully prepared to get it. Additionally, Veredus provides the following benefits:
o Medical Benefits
o Consultant Lunches and Outings
o Dental Benefits
o Life Insurance ($20,000 benefit)
o Vision
o ATOP-Accrued Time Off Program
o 401K
o Consultant Web-Site
o Name Plates
o Care packages/Survival packs
o Dedicated Consulting Services Representative