skillfactor-pipeline/docs/qa/database-administrator-sample.md

QA sample — database-administrator

1 of 56 records (2%). Judge each extraction against QUALITY_BAR.md 'Extraction quality': faithful, no invented items, plausible seniority.

SQL DBA (us)

Ad (first 2000 chars):

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, upda

Extraction:

{
 "hard_skills": [
  "data modeling",
  "database design",
  "sql programming",
  "data analysis",
  "data mining",
  "system integration",
  "software application architecture",
  "data quality analysis",
  "performance tuning"
 ],
 "tools": [
  "Oracle",
  "Exadata",
  "ERwin 7.3",
  "SAS",
  "SPSS Modeler",
  "Enterprise Manager",
  "SQL Developer"
 ],
 "methods": [
  "fully normalized relational modeling (3NF)",
  "large-scale OLTP database design"
 ],
 "responsibilities": [
  "data model development",
  "database design and development",
  "team management",
  "data scrubbing",
  "data interpretation",
  "application documentation",
  "performance tuning"
 ],
 "qualifications": [
  "10-15 years database experience",
  "3-5 years leadership experience",
  "master's degree in computer science or related field"
 ],
 "soft_skills": [
  "communication skills",
  "teamwork skills",
  "organization skills",
  "time management skills"
 ],
 "seniority": "mid"
}