Database Developer
Jobbeschreibung
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.
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 require