Illinois jobs

Database Developer

Atria Group LLC (agency)Vernon Hills, ILContract7+ years experience

Pay not listed

2 things to check before you apply.

On Atria Group LLC’s own careers site (SmartRecruiters), checked open today.

  • To check: Posted by the employer 11 years agoLong-open jobs are sometimes already filled. Ask when they plan to hire.
  • To check: No pay range listed, though one is likely required in ILAsk for the pay range before you interview. The law here likely requires one.
  • Checked: On the company's own careers siteSmartRecruiters board
  • Checked: Checked open todaySmartRecruiters board
  • Checked: No reposts foundSmartRecruiters board
  • Trust score 55 / 100 · Check details
See all 6 checksShow fewer
How we check

What you’ll do

  • Develop, test, execute, and document SQL programs for disease management applications using Oracle and MS SQL.
  • Develop custom reports and work with application support on data cleanup.
  • Build database programs and UNIX scripts, and optimize queries, stored procedures, ETL processes, and database performance.
  • Gather and analyze requirements for data warehouse and Business Intelligence projects; oversee data cleansing, quality, and consolidation.

Summarised from the posting by AI and can be wrong. The full description is the source.

Requirements

Experience

  • Minimum of 7 years of Oracle, MS SQL, and data warehouse design and development experience
  • Experience designing and developing high-volume transaction-based systems
  • Experience with SQL, SQL*Plus, SQL*Loader, Exp/Imp, Oracle Scheduler, Advanced Queues, object management, Informatica PowerCenter, PL/SQL development, stored procedures, and triggers
  • Experience using bulk processing and DBMS packages
  • Experience analyzing query plans and performing query tuning, partitioning, and optimizer hints
  • Experience in data warehouse and Business Intelligence implementation
  • MS Access and Crystal Reports experience

Skills

  • Proficiency in Toad, MS Access, Erwin, Visio, and version control tools
  • Intermediate computer skills and proficiency in MS Word, Excel, PowerPoint, and Outlook

Your match

Sign in and add your resume to see which of this job's requirements it shows.

Sign in to check your match

Saved to your account, encrypted. The AI that reads it doesn't keep it or train on it.

Full job description

From Atria Group LLC’s careers site

Company Description

We specialize in Staffing, Consulting, Software Development, and Training along with IT services to small to medium size companies. AG's primary objective is to help companies maximize their IT resources and meet the ever-changing IT needs and challenges.

Show full descriptionShow less

In addition, AG offers enterprise resource planning and enterprise application integration, supply-chain management, e-commerce solutions, and B2B public exchanges and B2B process integration solutions. Our company provides application analysis, design, development and programming, software engineering, systems development, testing, integration, and implementation, and management consulting services to various clients – including governmental agencies and private companies – throughout the United States and India.

We provide these services in multiple computing environments and use technologies such as client/server architecture, object-oriented programming languages and tools, distributed database management systems, state-of-the-art networking, and communications infrastructures. Our honest and realistic approach to recruiting dictates that AG does not entice or lure engineers from their employers. We represent only high caliber technical professionals who have committed to making a change required by career.

Job Description

Description:

  • This position develops, tests, executes and documents database SQL programs for use in supporting disease management applications utilizing both Oracle and MS SQL technologies.
  • Development of custom reports and working with App Support team on a data cleanup project.
  • MS Access and Crystal Reports experience is a must.
  • Delivery of documentation is required at the end of the contract period.

Responsibilities:

  • Develop Packages, Stored Procedures, Triggers, and other PL/SQL and T-SQL programs.
  • Develop custom reports using Crystal Reports, Cognos, or Business Objects
  • Develop UNIX scripts to support batch processes or data conversion.
  • Optimize Queries, Stored Procedures, ETL process, and databases performance.
  • Gather and analyze business requirements for Data warehouse and Business Intelligence Projects.
  • Provide quality oversight for all activities related to data cleansing, data quality and data consolidation using standard data modeling methodologies and processes.
  • Write user documentation for database systems created and/or maintained by the department.

Requirements:

  • Minimum of seven (7) years' Oracle, MS SQL, Data warehouse design and development experience required
  • Experience in designing and developing high volume transaction based systems required
  • Experience in SQL, SQL*Plus, SQL*Loader, Exp/Imp, Oracle scheduler, Advanced Queues, Object management, Informatica Power Center, PL/SQL development, stored procedures, and triggers required
  • Proficient in Toad, MS Access, Erwin, Visio, and Version Control tools required
  • Experience using bulk processing, DBMS packages required
  • Experience in analyzing query plans and query tuning, partitioning, and optimizer hints required
  • Experience in Data warehouse and Business Intelligence implementation required
  • Intermediate computer skills and proficiency in MS Word, Excel, PowerPoint and Outlook require

Additional Information

GOOD COMMUNICATION SKILLS

DURATION:4 - 6 MONTHS

INTERVIEW: PHONE & SKYPE

Something wrong with this job? Report it · This flag looks wrong

Similar jobs

Database Developer

NT Concepts · Remote · US only

$120k–$181k/yr

StrongChecked open todayPosted 1 month ago

Oracle Database Developer

Bright Vision Technologies · Remote · US only

$115k–$165k/yrFull-time

StrongChecked open todayPosted 11 days ago

Salesforce Developer

Cherokee Federal · Remote · US only

$130k–$140k/yr

StrongChecked open todayPosted 9 days ago

ETL Developer

GRVTY · McLean, VA

$150k–$250k/yr

StrongChecked open todayPosted 11 days ago

Developer Advocate

YugabyteDB · Remote · US only

$160k–$215k/yr

StrongChecked open todayPosted 15 days ago

See more like this