Job details

Database Developer

Company DescriptionWe 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.Job DescriptionDescription:• 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 requireAdditional InformationGOOD COMMUNICATION SKILLSDURATION:4 - 6 MONTHSINTERVIEW: PHONE & SKYPE

Average salary estimate

Estimate provided by employer

$20 / HOURLY (est.)

min

max

$13.1

$26.05

If an employer mentions a salary or salary range on their job, we display it as an "Employer Estimate". If a job has no salary data, Rise displays an estimate if available.

What You Should Know About Database Developer, Atria Group LLC

Are you an experienced Database Developer looking to take your career to the next level? AG, based in Vernon Hills, IL, is on the lookout for a skilled professional to join our dynamic team. Here, we specialize in offering top-notch Staffing, Consulting, and Software Development services tailored to small and medium-sized companies. As a Database Developer, you'll play a crucial role in developing, testing, and documenting SQL programs that support our disease management applications using Oracle and MS SQL technologies. If you have expertise in MS Access and Crystal Reports, you’ll find yourself at home in our collaborative environment. Your day-to-day responsibilities will involve crafting packages, stored procedures, and triggers, while also optimizing queries for optimal performance. We take pride in gathering and analyzing business requirements for our data warehouse and Business Intelligence projects, ensuring the highest quality oversight for data cleansing and consolidation efforts. With a focus on building effective documentation, our Database Developers have a fantastic opportunity to shine where their efforts truly matter. If you meet the qualifications and have a passion for data optimization and reporting, join us at AG where your skills will help us make a difference in how companies navigate their IT needs!

Frequently Asked Questions (FAQs) for Database Developer Role at Atria Group LLC

What are the main responsibilities of a Database Developer at AG?

As a Database Developer at AG, your primary responsibilities include developing, testing, executing, and documenting SQL programs to support our disease management applications. You'll also create custom reports and collaborate with the App Support team on various data projects, focusing on improving data quality and performance.