Database Developer

AtriaGroupLLC

Vernon Hills, IL, United States permanent

Posted: November 17, 2015

Quick Summary

We specialize in Staffing, Consulting, Software Development, and Training along with IT services to small to medium size companies. 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, int

Job 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.

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.

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

GOOD COMMUNICATION SKILLS

DURATION:4 - 6 MONTHS

INTERVIEW: PHONE & SKYPE

Why Apply Through MisuJob?

AI-Powered Job Matching: MisuJob uses advanced artificial intelligence to analyze your skills, experience, and career goals. Our matching algorithm compares your profile against thousands of job requirements to find positions where you have the highest chance of success. This saves you hours of manual job searching and ensures you only see relevant opportunities.

One-Click Applications: Once you create your profile, applying to jobs is effortless. Your resume and cover letter are automatically tailored to highlight the most relevant experience for each position. You can apply to multiple jobs in minutes, not hours.

Career Intelligence: Beyond job matching, MisuJob provides valuable career insights. See how your skills compare to market demands, identify skill gaps to address, and understand salary benchmarks for your experience level. Make data-driven decisions about your career path.

Frequently Asked Questions

How do I apply for this position?

Click the "Register to Apply" button above to create a free MisuJob account. Once registered, you can apply with one click and track your application status in your dashboard.

Is MisuJob free for job seekers?

Yes, MisuJob is completely free for job seekers. Create your profile, get matched with jobs, and apply without any cost. We help you find your dream job without any hidden fees.

How does AI matching work?

Our AI analyzes your resume, skills, and experience to understand your professional profile. It then compares this against job requirements using natural language processing to calculate a match percentage. Higher matches mean better fit for the role.

Can I apply to jobs in other countries?

Absolutely. MisuJob features jobs from companies worldwide, including remote positions. Filter by location or look for remote opportunities to find jobs that match your preferences.

Ready to Apply?

Join thousands of job seekers using MisuJob's AI to find and apply to their dream jobs automatically.