Latest Jobs  
Advance your technical career… Find a tech school and start an IT career!
Start your career in the fast-growing technical field – Get more info here »
Advance your technology career with the latest technology skills - Get more info here »
 
This job has expired.
 
Job Information
Job title

SQL Developer/DBA (#31-19-MH182)

Company ADATECH, Inc.
Wage Not specified
Location United States, Alabama, Birmingham
Employment type Full Time
Education Not Specified
Year Experience 4 - 5 Years of Practical Experience
Travel None
Published on 1/17/2005
Description
Responsibilities include the migration of existing data from primitive database structures such as BTrieve, AMSI, ACCESS, Dbase, Lotus, and DB2 to uniform SQL Server data warehouse. Also experience in Transact-SQL, Database design, stored procedures, triggers, and data views is required.
Tools used: VB 6.0, ASP, SQL Server 2000, ACCESS, SQL, Sharepoint 2003, , Microsoft Project, Crystal Reports, Visio, HTML, DHTML, ASP.Net, VB.Net, MetaData(XML), XML Web Services, etc.

In addition to the above, listed below are the skills most desired in bold and others that are nice to have in regular font:

. SEVEN years of experience in database backend work, development of Database stored procedures, triggers, packages, and also system design and applications development in Oracle and MS SQL Server environment.
. Data warehousing involving data warehouse analysis and design, multi-dimensional modeling, multi-dimensional cube design, Star / Snow Flake Schema Design, OLAP using Oracle Express (OLAP server), Relational Access Administrator (RAM), Oracle Sales Analyzer (OLAP Report) in Oracle 8 / 8i environment, OLAP using MS Analysis Services, Analysis Manager, Excel in SQL Server 7.0 / 2000 environment. Also carried out Data Migration
. Extensive work in ETL process consisting of data transformation, data sourcing, mapping, conversion and loading; data testing and validation against staging databases. ETL tools and Utilities like Informatica, Data Transformation Service (DTS), SQL*Loader, UTLFile package etc.
. Experience in logical and physical data modeling using Erwin, Dimensional Data Modeling, OLTP design
. Actively participated in the design and implementation of Data warehouse methodology, metadata designs, schema designs etc.
. Experience in Word, Excel, Outlook macros using VBA.
. Expert level skills in client server technologies like Visual Basic 6.0/5.0, ASP, ADO, RDO, DAO, ODBC, ActiveX Exe, ActiveX DLL, ActiveX Controls, Perl Scripting etc.
. Microsoft Certified Professional - SQL Server 2000 Database Design & Implementation Microsoft Training - Designing & Implementing OLAP solutions using MS SQL Server 2000.
? Web Development using .Net framework
? Client Service troubleshooting using Team II
? Creating Sharepoint 2003 front-end document management systems
? Creating XML Web Services
? Creating, working with Virtual Machine technology

Operating Systems Windows 9x, Windows NT 4.0, Windows 2000
Hardware IBM Compatibles, Sun Solaris, HP
Languages SQL, PL/SQL, MS TSQL, MDX queries for MAOLAP, VB 6.0/5.0, VBA (Visual Basic for Applications), Perl
RDBMS SQL Server 7.0 / 2000, MS Access, dBase,
Database Query Tools SQL*Plus, TOAD 6.3
Database Modeling Data modeling / Database design (logical / physical)
Data Warehouse Modeling Multidimensional Data Warehouse
SQL Server Environment: Designing and implementing OLAP solutions using Microsoft Analysis Manager, Data Transformation Services, Implementing OLAP, MOLAP or HOLAP models for data warehouse with SQL Server 2000 RDBMS
ETL Tools / Utilities / Object Lib Informatica 5.0 - Power Center, Designer, Repository Manager, Server Manager; Data Transformation Service (DTS), SQL*Loader, UTLFile Package, ADOMD
OLAP Reports / BI Tools Oracle Sales Analyzer (OSA) an OLAP reporting tool of Oracle Express,
Crystal Reports 6.0/7.0,
Cognos Impromptu V6 and PowerPlay V6.6,
Executive Viewer and EVWeb Server from Temtec
Other Tools MS Project, Microsoft Word, Excel, Outlook, PowerPoint, etc

Experience/Skills
SQL Server, SQL DBA, Data Transformation (DTS),MS Project, VISIO, MS Office Suite & Clarify, logic nd programming, SQL Coding and Developing

Other desired skills:
SQL Server, SQL DBA, Data Transformation (DTS),MS Project, VISIO, MS Office Suite & Clarify, logic nd programming, SQL Coding and Developing
This job has expired.