SR BI SPECIALIST

As the Sr. Business Intelligence Specialist you will join the most employee-centric company in the Midwest with a rich history and deep commitment to work/life balance. They have finished a 3-5 year road map with IBM to go from a Point To Point, Ad-Hoc DW solution to become a true Enterprise Datawarehouse to use information to create better partnerships and drive value. You will join a team of 4, going to 8 by next year since B.I./DW is the #1 mission in this 2,500 employee private company. They are running Cognos 8 that has 800-900 users currently. You must have experience with Cognos 7.3 creating Cubes and Framework Manager developing Packages. You will learn Cognos 8, Datastage, industry specific IBM architectures and create custom controls using Cognos SDK (Software Development Kit). There are about 10-12 Cubes in production with 85 Project Packages running. There are 12,000 views in the database. They are deploying Websphere Portal and plan to interface Cognos through Websphere Portal! This will create a single point access for better control, security, ease of use, and allow daily analysis from one point. Currently only internal employees are Cognos users, this will be extended to external employees that will double the number of users! This is a green field opportunity to go from extracting the majority of the business data from M/F VSAM files to a mature, value adding EDW in DB2. There are several DataMart running and an ODS. There are 2 waves defined with 30 projects lined up for the next 3-5 years. Recently created "customer retention cubes" in Cognos and are converting from Informatica to Datastage. Issues to solve are customer identification, getting data staged correctly, and data redundancy in flat file format. 80% New Development, and 20% Maintenance. 50% Requirements and Design, and 50% Code and Test. Please contact Eric Heineman at ext. 239 or e-mail heinemane@kendalldavis.com Position I064

DBA

This position will be part of the current group of 6 DBA’s functioning as a high-level technician on a large, complex, 24/7 RDMS environment that includes DB2/MF, Oracle, Sybase, DB2/Unix and SQL Server. All of the in-house development is on DB2/MF and DB2/Unix, with the exception of one large financial application on Sybase. All of their 3^rd Party applications are on Oracle and SQL Server. DB2/Unix has 20 instances, 90 databases, and 3 terabytes of data, Oracle has 14 databases at 200 gig (primarily Filenet apps), and SQL Server at 400 databases with 2 terabytes. All just in their production environments. The majority of these databases are web-enabled using Weblogic and Websphere. These databases support their Lawson Financial application, registered investments and all brokerage and financial applications. This position will be responsible for design and analysis, installation, monitoring, maintaining, troubleshooting and training for DB2/MF, DB2/Unix, Sybase, Oracle, and SQL Server databases for customers locally and remotely. The individuals on this team all bring their areas of expertise to the group, but still support all databases, so they are interested in candidates that have experience with DB2, Oracle, or Sybase on Unix with the ambition to learn the others as they will train you. Please contact Steve Martin at ext. 229 or e-mail martins@kendalldavis.com Position I049

DATAWAREHOUSE SPECIALIST

This multi million dollar division of a global manufacturing company has recently changed the focus of their Datawarehouse from supporting only North America, to having a global presence. As part of this shift, the current team of two is being expanded by bringing in two Datawarehouse Specialists, along with two Contractors. The regions that the team is responsible for include Europe, Asia, U.S., Latin America, and South America. This is a great opportunity for an energetic, enthusiastic individual to get in on the ground floor of a global Datawarehouse. Your expertise and experience will be an important part of this teams development within the company. Right now the Datawarehouse is set up with many small cubes, they have 50 currently in production. Everyone who requests data gets a cube, all cubes derive their data from the same source. One of the first projects you will be involved with will be the creation of one cube, which has sub-cubes for all requested data. Cognos 7.4 is the Datawarehouse package, drawing its data from an Oracle database using Oracle 9.2. The team is getting new Unix Servers in July, with an upgrade to 10g to follow that. The team currently has one Cognos Specialist and one Generalist. They need ETL experience the most, but would prefer a Generalist, especially with Project Management skills. Please contact David Rhodes at ext. 220 or e-mail rhodesd@kendalldavis.com Position I033

ORACLE DBA

This company purchased the interior division of a major corporation. This is a ground floor new company opportunity! Over the first year a lot of the work will be deciding upon, purchasing and deploying all new Hardware and Software tools. You will have input on those decisions. Also converting applications and databases over. Currently this company has four Production Oracle databases including the datawarehouse at 10g’s and some small custom OLTP applications all on 9i with plans this year to go to 10g. They are planning on using 10g grid control for the VM Ware and Linux Cluster Future. Should be at 20+ Oracle databases in production by the end of the year as they bring more and more systems over. Current databases are running under HP-UX but looking at porting over to Linux. Some databases are web enabled with the Oracle Applications Server (OAS). As a DBA you would support OAS (Performance tune, set up users, set up database links, OAS installs, etc.) 95% physical work – installs, upgrades, patches, performance monitoring and tuning, backup, recovery, add space, etc. 5% Consult with programmers on their code PL/SQL, Forms, etc. Please contact Trevor Howenstine at ext. 259 or e-mail howenstinet@kendalldavis.com Position I029

BUSINESS OBJECTS DEVELOPER/ANALYST

You will join a team of 8-10 FTEs and 2-3 contractors consisting of Data Modelers, DBAs, ETL Developers and Business Object Developers. Just two months ago this team started building the Enterprise Data Warehouse, which is expected to take 2-3 years to complete, making this a ground floor opportunity. There are two major projects planned over the next 18 months: 1. Supplier Metrix Project. 2. Finance Project: Multiple Universes (AR, AP, GL, and Inventory). They will be using a combination of Kimball and Inmon because they believe both have valuable strategies as this will be Star Schema. This position will play a critical role as a functional expert on new Business Objects related projects, creating complex universes while supporting an existing end-user base with all B.O. related questions and requests. Responsibilities will include enhancement of ad-hoc analysis and report writing, conversion of existing reports into Web Intelligence reports, deploying new and existing B.O. reports, Universe development/maintenance, and the day to day maintenance. It is important that this person have the ability to translate business requests into reporting and analytical deliverables. 10% Gather requirements and design. 70% Code. 15% Test and de-bug. 5% Implementation and Maintenance. Pluses: General business knowledge of Sales, Manufacturing and Finance. Any ERP System Software experience. Dashboard Manager. Please contact Steve Martin at ext. 229 or e-mail martins@kendalldavis.com Position I022

DATA QUALITY ANALYST

As the Data Quality Analyst you will be the first to start a new department that is vital to the future success of the company. You will start a department to identify and create processes and standards. This company is using cutting edge tools and is based on innovation. You will focus on the DW environment that sits at over 2 TB and is growing 3 gigs every day! They have 30 DM’s in a Ralph Kimball Star Schema Design in SQL Server and Oracle using Transactional Replication. They are converting from DTS to Informatica for ETL. They are rolling out Cognos 8 Reportnet and have about 40 cubes in Cognos 7.3 Enterprise Server. You must have experience with Object Oriented development in .Net and SQL Server. Be ambitious in your desire to grow your career to learn new tools. Your focus will be to look through the entire DW to insure data matches the DW, staging, and reporting front-end. There are currently 3 on the team doing Statistical Modeling in SAS for an analytical view. They want an exploratory effort from you to determine what is the disbursement of data? What is the data in Cognos Cubes that matches the datawarehouse using Cognos Event Studio? Verify data in the DW matches the staging environment. You will learn Dataflux (SAS product) that is very sophisticated that has hooks to dig into the database in a SAS based language. So far they built a prototype in Cognos Event Studio to verify data in cubes and Datawarehouse – big issue right now. Data labeling is an issue in the Datawarehouse. They also want to get into Householding with custom algorithms in Dataflux based on household data not just customer data. Please contact Eric Heineman at ext. 239 or e-mail heinemane@kendalldavis.com Position I014

DW ANALYST

As a DW Analyst you will join a team of 3 BA’s focusing on Financial DM’s where the goal of the team is to be a Strategic Enterprise Datawarehouse to deliver faster financial data analytics. This environment uses a hybrid of Kimball and Inmon Methodology. Closer to the Carolyn Hepp Methodology. This is a unique role where you will perform hands-on technical and requirement gathering. The DW is over 2 TB on SQL Server with 10 DataMarts built on Fact Tables and Star Schema. DTS is used for ETL pulling out of JD Edwards on the AS/400 using FTP and ODBC. Reporting is done with Crystal Reports, Business Objects, and Web Intelligence. This is an 80 year old company with $ 2 Billion in sales. The average length of service in I.T. is 20+ years. They pride themselves on stability and having an environment that is relaxed and family oriented. You must have experience working with the business side and users gathering detailed requirements, creating functional specs, and design specifications. You must have technical experience using T-SQL, DTS, and understand the Kimball/Inmon Methodology. 50% User Interface, Requirement Gathering. 50% Coding, DataModeling. You will rely on your technical skills at first until you get up to speed on the architecture and the business. Then you will do 60-70% Req and 30-40% Coding. Please contact Eric Heineman at ext. 239 or e-mail heinemane@kendalldavis.com Position H997

SQL SERVER DBA

This position is part of the Enterprise Data Warehouse/Business Intelligence team, where you will join two other SQL Server DBA’s. Just two months ago this team started building the Enterprise Data Warehouse, which is expected to take at least 2 years to complete, making this a ground floor opportunity. This team is in the process of building a centralized data repository from data on legacy systems (AS400) to create an enterprise view of the data so it can be used for multiple functions (marketing, product info, finance, sales, inventory, etc.). There are currently approximately 80 silos of data that will be brought into the centralized repository. This is a 4-tiered architecture environment that has some SQL Server 2000 that will be converted to 2005, with all new projects on 2005. This company is looking for a person who can pro-actively plan for capacity and growth changes (EDW is currently at 2 terabytes and rapidly growing) in a clustered and non-clustered environment. You will be involved in the design, set-up, installation and implementation of databases, data maintenance (re; indexing, integrity checks, log file monitoring), performance tuning (indexing, compression drive distribution, load balancing, replication) and disaster recovery efforts. Percents of time will depend on the person they hire. There is an opportunity to be cross-trained within the DW/BI team. You could do as much BI as desired using/learning Erwin, create, populate and put in Universes. Pluses: Clustering and Replication, SQL Server Integration Services (SSIS). Please contact Steve Martin at ext. 229 or e-mail martins@kendalldavis.com Position H956

DBA III

As a DBA III you will join a team of 3 focusing on Clustering, Partitioning, and Replication on SQL Server 2000 going to SQL Server 2005 this year. This environment is based on innovation and you will be allowed to push the envelope in order to make a difference. This company’s revenue has increased 50% each of the past 3 years. You will not have to deal with "red tape", your ideas will be valued, and you can put together your own plan. You will support the backend of a 2 TB DW that is growing at 3 gigs per day! Your first area will focus on Performance. Put together a plan to get the OLTP in shape using partitioning because one table is over 500 gig and another table is over 500 million rows. Next will be Clustering, only the production environment is clustered. The development, test, QA, and staging need to be clustered. So you must have experience with High Availability Clustering. Remote Replication – currently they have CDP short term for stand by servers to perform Log Shipping. They are building a second site out West for remote data replications. Down the road will be Archiving, you will work with the team for product selection. This group also manages the SAN environment, they just purchased 2 EMC Clarion CX500 boxes. You will also be exposed to Oracle, their CRM system runs on Oracle 9i RAC Cluster, going to 10g. You will still over-see day to day operations also doing installs, upgrades, patches, B/U, recovery, monitoring, and tuning. 80% Logical, 20% Physical. Please contact Eric Heineman at ext. 239 or e-mail heinemane@kendalldavis.com Position H948

SR DBA

You will be one of three DBA’s on this team. The databases you will be responsible for are Oracle 9i up to 10g on AIX Unix. Also SQL Server 2000 with plans to upgrade to 2005 this year. The environment consists of around 75 Oracle databases with the largest at 450 gig. There are around 200 SQL Server databases with the largest being the Portal Data Repository at 300 gig. 60-80% of the work will be Oracle with 20-40% of the work dedicated to SQL Server. Some databases are Web enabled with Weblogic while SQL Server uses IIS Web Server. They have Peoplesoft Financials and H/R on Unix with Oracle. Duties will be 100% Physical DBA Production work: Installs, upgrades, patches, monitoring, tuning, backups, recovery, script automation and table maintenance – (add space). Oracle 10g – doing RAC, Grid, Cloning. Planning an RMAN implementation. Tools – Toad, TSM, TimeFinder replication S/W Oracle Enterprise Manager. Please contact Trevor Howenstine at ext. 259 or e-mail howenstinet@kendalldavis.com Position H947

GROUP MANAGER DBA (VP)

As the Enterprise Data Management (EDM) Group Leader, you will oversee three Managers, five database architects, six full-time and two contract DBA’s that perform the physical DBA work, along with two DB2 mainframe system programmers. The EDM group supports, DB2, Oracle, and SQL platforms in this OLTP environment. The mainframe DB2 supports the financial datawarehouse and this company’s credit/debit datawarehouse. There is also a datawarehouse environment on DB2/UDB that contains several data marts for marketing and HR. Because of the size of the staff and number of projects, all of the DBA’s perform the design/architecture, logical and physical definition and data modeling in both the test and production environments. The production environment that the EDM team supports consists of DB2/UDB (18 db’s, 15 servers), DB2/zOS (48 db’s, 4 servers), Oracle (24 db’s, 8 servers), and SQL Server (443 db’s, 116 servers). You will be responsible for leading this organization in the development and implementation of processes and tools to improve performance and reliability while partnering with application teams to improve design and delivery of new apps through more efficient processes and standards. This position will need to communicate initiatives and deliverables to executive management while functioning as the primary vendor liaison, keeping current with trends and technological innovations in the banking I.T. industry making strategic and tactical recommendations. You will be responsible for the EDM budget as well. Client is looking to this person to energize this team toward their common goal. This includes responsibility of career development, training and salary administration. High level strategic position! Must have 10 years DBA/Mgmt experience, and a Bachelors Degree. Please contact Steve Martin at ext. 229 or e-mail martins@kendalldavis.com Position H886

DATAWAREHOUSE DEVELOPER

As the Datawarehouse Developer you will join a team of two on the Datawarehouse team. You will look at the process they have now and shed light on the ETL standards. They are in survival mode now and need solid standards to become more scalable and flexible to manage the rapid growth they are experiencing. The Datawarehouse is collecting three gigs of data per day and is currently at two TB. You will make a difference by guiding the team in Ralph Kimball design methodology and Informatica ETL standards Informatica Power Center is new to this environment. This is a unique environment that has SQL Server Replication hooked to Informatica Power Exchange that watches for any new data collected from their web-based Price Quoting Engine to hand off to Informatica Power Center to be transformed and written out to the target in Oracle. They currently have over 30 Data Marts using Form Dimensions. There are 7-8 Data Marts that need developed now for reconciliation, commission, A/P, G/L. These systems are tied into 17 different customers, credit agencies, Axiom, etc. to deliver real-time pricing information every 5 seconds. 70-80% ND using the Ralph Kimball methodology. You will perform: Design real-time DW/DM’s. Create slow changing dimensions. Lead your own projects. Gather requirements. Design data flow and data mappings. You must have Informatica Power Center experience, knowledge of the Ralph Kimball methodology, and know how to do query overwrites in SQL Server. Please contact Eric Heineman at ext. 239 or e-mail heinemane@kendalldavis.com Position H899

B.I. ARCHITECT

As the B.I. Architect you will join a team of four designing and creating cubes in Cognos 7.3 Enterprise Server while this company is rolling out Cognos 8 Report-Net. This environment has no red tape and is able to move very quickly. You will be in charge of all the process from design, build, test and allowed to push the envelope to write custom controls in Java Script or Style Sheets. This environment’s DW is growing three GB’s every day! They currently have 40 cubes in production, 12 of those are pointing at the EDW. 28 cubes need to be re-written since they are pulling from a set of denormalized tables. They must re-design those cubes to pull from the EDW. New cubes are requested every day. You must have experience with Cognos Access Manager to apply dimensional views using Apexing and Cloaking. They have over 400 accounts and don’t create a cube for each individual customer. So you must have skills with Access Manager to restrict views so customers can only see their data in a cube that also contains competitor data. Also know Framework Manager. The DW consists of SQL Server DM’s, Oracle for EDW using the Ralph Kimball Star Schema approach. They are converting ETL from DTS to Informatica Power Center/Exchange. Data is in real-time every 5 seconds. You will be doing every step in incremental builds: Identify Dimension Model. Write your own queries and macros. Apply security. Elevate to test. Production. Admin of cubes/boxes. Increase build speed. Must have Cognos 7.3-8.1 Access Manager (Apexing and Cloaking). Please contact Eric Heineman at ext. 239 or e-mail heinemane@kendalldavis.com Position H911

DBA II

As a DBA you will join a team of three focusing on over 50 instances of SQL Server 2000. They are going to SQL Server 2005 this year as soon as they get a handle on the fast growth they are experiencing now. This environment has no red tape and is able to make changes very quickly. This is a rare place where ideas are valued, everything is based on innovation, and you can put together your own plan. This department is in the early stages so there is unlimited areas for you to make a difference. This team does Remote Replication, Partitioning, SAN, and Clustering! You will support the back-end of a 2 TB DW that is growing over 3 GIG’s every day! Your first area of focus will be the 50 instances of ancillary systems for monitoring, MAS account package, call center, etc. that need you to improve performance using T-SQL, Indexing, DTS packages, Table Scans. If you don’t have Clustering experience, you will learn. Partitioning is needed where one table is over 500 GIG and another table has over 500 million rows of data that causes a tremendous performance impact during the day when they run a statistics report. Remote Replication – currently they have CDP for short term stand by servers to perform Log Shipping. They are planning a second-site for Disaster Recovery out West to have Replication of data. This team also manages the Storage Area Network. They just purchased two EMC Clarion CX500 boxes. You will also be exposed to Oracle 9i going to 10g where they have a Rac Cluster on their CRM system. Currently the SQL Server production environment is Clustered, but the test, development, QA, and staging is not Clustered yet. 30-40% Logical, 60-70% Physical. You will perform installs, upgrades, patches, B/U, recovery, monitoring and tuning. Please contact Eric Heineman at ext. 239 or e-mail heinemane@kendalldavis.com Position H927

SR DBA

You will be joining the Information Technology Division. SQL experience is what is needed most. They have five databases of SQL in Production and five as Test platforms. Other Databases include: Most databases are on these OS. UDB DB, Linux, AIX, Windows. DB2 z/OS. IMS – not critical – Phasing out in the next 4-5 years. Some of the databases are web enabled. Small team of DBA’s. Create and maintain an overall data architecture on all computer platforms. Architect, develop, model and analyze databases and datawarehouses. Perform capacity planning. Handle medium to large scale projects with minimal supervision and direction. Maximize database access and performance. Maintain the database parameters for all production and test databases. Pro-actively monitor database performance and make tuning adjustments as necessary. Maintain database schemas and data documentation. Design, test and implement all database and structural changes. Complete thorough functional and technical evaluation of products and database upgrades. 2+ years experience as an application programmer/developer using DB2, IMS and/or CICS. Experience with IMS, MS SQL Server database and related DB tools. Oracle or Siebel experience. Project management experience is a plus. Please contact Jeff Treptow at ext. 233 or e-mail treptowj@kendalldavis.com Position H928

BI ARCHITECT

This position is the highest level position on the Solutions Design team, consisting of four others plus the manager. This team is responsible for the data acclimation and designing and delivering all reporting around Business Intelligence with Business Objects and Essbase. In addition to building new and enhancing reports for the business users, the project at the top of the priority list for 2007 is to develop a large dashboard for 2,000 – 3,000 users. This dashboard will allow management to monitor employee’s performance/production, among other functionalities. This is being built from the ground up and is expected to be about a one-year project. As the senior member of this team, you will need to be familiar with either Business Objects or Essbase, but your strengths should lie with working on business requirements and design with some project management skills utilizing a PMO. The majority of your time will be spent working with users, determining what tools to use to deliver, understanding the dimensionality of the requirements, and translating that to a design. You could also be involved in building some of the prototypes or solutions and the user acceptance processes. This is a very strategic position as you will be part of the analysis of tools and processes and have input on improving these areas. 60% work with users to deliver effective business requirements. 40% translate the business requirements to design. Please contact Steve Martin at ext. 229 or e-mail martins@kendalldavis.com Position H833

PROJECT MANAGER

As a P/M you will be part of a new strategy around project delivery in this Fortune 200 company. You will manage projects with average budgets of $ 5-10 Million covering application development, D.B., Infrastructure, data movements, voice, and Business Intelligence. This organization is very focused on Service Oriented Architecture, Enterprise Services, and Server Virtualization. They use Clarity as their P/M tool. You will focus on improving the quality of delivery, cost planning, and optimize the process. Currently this environment has a high degree of unpredictability, unforeseen issues with the architecture, and it takes a lot of effort to get things in production. You will be part of the team that brings new talent to solve these issues. This company has over 1500 I.T. employees. You will join common services that has 200 people broken into 3 different teams. The ideal candidate is someone that started in development/engineering and grew to be a P/M. Execution: Scope and date is achievable. Task sequencing. Budgets. Risk Management. Test Sequencing. Production. They have B/A’s that gather the requirements, you will drive this effort to focus on efficiency. Please contact Eric Heineman at ext. 239 or e-mail heinemane@kendalldavis.com Position H739

REPORTING SYSTEMS DEVELOPER

You will join a team of 6-7 FTE’s and 4-5 consultants on bigger projects. Corporate wide, I.T. is viewed as an asset (not an expense) the business side is beginning to understand the power of data and still learning how the data can make more money and save money. The managers objective is to help turn data into higher assets for the business. This is a ground floor opportunity to build this D.W. There are 5-6 projects scheduled now. The backend is being designed now. The Framework itself is a combination of both Kimball and Inman but leaning more to Kimball. Doing some design in ETL area, cube building now as well. This position is very hands on, it is more than just designing. This will be Datawarehouse project work and non-project work – creating reports, and any .Net experience would be very helpful. i.e. VB, ASP, or C#. 70% Coding – using SSI and reporting – Brio Intelligence or Brio SQR (Batch jobs). 5-20% Gathering Requirements – depends on the level of the candidate. 5-10% Testing. 5-10% Support/Maintenance – keep lights on. Please contact Casey Wills at ext. 228 or e-mail willsc@kendalldavis.com Position H733

REPORTING SYSTEMS ANALYST/ARCHITECT

You will join a team of 6 to 7 FTE’s and 4-5 consultants on bigger projects. Corporate wide I.T. is viewed as an asset (not an expense). The business is beginning to understand the power of data and still learning, how the data can make more money and save as well as when they are already making money. The manager’s objective is to help turn data into higher assets for the business. This is a ground floor opportunity to build this D.W. There are 5-6 projects scheduled now. You will be asked to provide technical subject matter expertise and consultation to business units and colleagues in I.T. in the design, development, and implementation of reporting systems, data marts, operational data stores, and data analytics applications. Also recommend and implement best practices for the effective and efficient retrieval and delivery of data and reporting output from company computer systems. The back-end is being designed now. The Framework itself is a combination of both Kimball and Inman but leaning more to Kimball. Doing Design/Architecture in ETL area, cube building now as well. This position is very hands on; it is more than just designing. 70% to start: Gathering Requirements, Design, and Coding. 10% Testing – participate in it to ensure customers are getting what they want and need. 10% Coordinating – Not a P/M role but helping coordinate projects. 10% - Training/Mentoring – Training manuals, workbooks. Please contact Casey Wills at ext. 228 or email willsc@kendalldavis.com Position H728

DATA ARCHITECT

As the Data Architect you will create an Enterprise Data Model from the existing architecture guidelines by mapping out all the data sources, where all the data resides, document interfaces, and data movement throughout the system. Enhancing data paths and get an integrated view of the data. You must understand the relationship between business and data. Knowledge of ETL tools, data management tools, and experience creating data models. Understanding of integration technology in a MQ Series hub and spoke framework and bridging M/F, Unix and WebServices with WebSphere Message Broker. This is a hands-on position. The data modeling tool is TROUX that is connected to the network and can map out anything while giving future looks as well. You will advise the Program Office on the direction of projects as well. Projects include * Forecasting and Analytics. You will work with IBM vendors to create an ODS (Operational Data Store in DB2) using Datastage for data cleansing, repair, and finding data. Cognos is currently used for reporting. They currently use Informatica for ETL and might be replaced with Datastage. * Metadata, define technical standards, leverage existing standards, sell Metadata to business owners by building relationships with them. You will select a Metadata repository to implement and create Metamodel standards. * IBM Content Mgr has been deployed and is in the second phase. * IIW is running commercial lines, but is still in the early stages. IAA is currently being defined with the functions of the business. There are several functions underway. You will be the bridge between all the different data teams, keeping everyone on the same page. Please contact Eric Heineman at ext. 239 or email heinemane@kendalldavis.com. Position H703

PROJECT MANAGER

As a Project Manager you will be responsible for the project charter, budgets, and resources in a Matrix team environment. You must have experience with multi-platforms environments because you will be assigned projects in M/F, Unix, and Web. Once you are handed your project by the PMO, your team will be chosen with the available skill set required for each phase of the project. Your team will change with each new project (Matrix), so when a developer is finished with their assignment – they will roll on to a new team. When a project begins, you will sit down with each team member to go over duties and expectations. You will fill out a resource form listing your teams needs to determine the skill sets needed and how many. Then the Matrix team is drafted from the available skill sets for each phase. You will also hire your own contractors and manage the HW/SW, and salary budgets. You must have experience with over $10 Million budgets. You must have experience writing performance reviews, managing vendors, implementing architecture, while leading each phase from initiation, planning, execution, and closure. Team size ranges from 2-40 members. Consulting style with different teams and technology on each project. This company deployed the Rational Unified Process and purchased the Rational Tool Suite. So each project will follow these guidelines. They converted from homegrown PMBOK methodology. Please contact Eric Heineman at ext. 239 or email heinemane@kendalldavis.com. Position H684

SR ANALYST

Client has a global presence and has been growing through acquisition. They currently just purchased a company in Europe that runs SAP, adding yet another ERP system to their enterprise. They have 14 different ERP packages running at different facilities and have plans to standardize across the company with one ERP solution, either JD Edwards or SAP. They currently have a data warehouse that pulls data from each of the 14 ERP systems with Microsoft DTS and some .Net code. The data warehouse is a star schema design using SQL Server. The only data in the warehouse currently is sales data. The CFO is very excited about the warehouse and is pushing and investing in expanding it to multiple subject areas such as customer data, finance, distribution, etc. The front-end of the warehouse consists of Microsoft Analysis Services and a tool called Proclarity. These front-end tools allow for multi dimensional reporting cube technology. As a Sr Datawarehouse Analyst you will be doing the DTS work as well as the front-end cube and report development. You will also do design, requirements, architecture for the data warehouse. 25% Requirements Gathering. 25% Design, Analysis, Architecture. 50% Coding, Testing, Modeling, Automating Processes. Tools used: SQL Server, DTS, .Net, Microsoft Analysis Services, Proclarity. Must have a 4-year Degree. Please contact Trevor Howenstine at ext. 259 or email howenstineT@kendalldavis.com Position H663

DIVISION MANAGER TECH OPERATIONS

As the Division Manager, you will lead your team through an exciting transition. There are currently two separate teams, one responsible for the network and distributed platform environments, and the other responsible for Mainframe Operations. These two groups will be combined and funnel up to the Division Manager. As a combined group, there will be five to seven managers and a total of roughly 70 people reporting to this position. The Division Manager will need to provide strategic vision for operations and monitoring and recognize opportunities for improved monitoring and event correlation. The current environment consists of 7,000 MIP’s and 2,500 servers with a global network. One of the initial goals will be to transform this team from a passive, re-active stance to an effective, pro-active team to better serve their customers, adding more value to the company. This position will be involved in creating and administering internal controls to protect the integrity of the operation, while participating in areas such as continuos improvement, quality management, and setting the direction for the Enterprise Data Center Services Organization. The Data Manager is responsible for managing the setup and support of the data transmissions with over 4,000 clients. Challenges: Introducing this change (integrating the two groups) to the existing staff. They do know it’s coming. Build/Foster a pro-active mindset. Instill more accountability/responsibility. Coordinate the two groups. 33% Management of staff. Leadership. 33% Strategize: Be a visionary – "How do we get to the next level?". 33% Work with partners outside of this organization – Development teams, different lines of business, vendors, etc. Please contact Steve Martin at ext. 229 or e-mail martins@kendalldavis.com Position H675

LEAD DBA

As the Lead DBA you will join a team of six DBA’s supporting DB2, IMS, SQL Server, and UDB. Currently this global company is on UDB 8.1. This platform is the future of the company with strategic I.T. dollars supporting the enterprise-wide goal to present a common face to customers. Currently customers must go to different website to do business with different divisions. Right now there are three instances of UDB 8.1, going to four to rollout a new Order Mgmt system this year. These databases are Web-Enabled to support engineering using Websphere with links to have pictures. The UDB environment runs on AIX and Wintel. These systems support Engineering and Product Development. You will perform installs, upgrades, patches, B/U, recovery, monitoring, and tuning. AIX will manage DASD and installs. You will work with developers as well to handle the installs and support of packages. You will perform 20% Logical and 80% Physical moving to 30% Logical and 70% Physical. Currently they are using Veritas for B/U and recovery moving to IBM tools. No tools yet for monitoring and tuning. This is a green-field environment where you will be able to train and lead others on UDB as well as Fail-Over and HADR (High Availability Disaster Recovery). HADR experience is very important for this role. You will have the opportunity to be cross-trained on DB2 z/OS, IMS, or SQL Server! You will also learn Siebel and Yantra as you are directly involved in these implementations. Projects: Implementations in IBM Message Broker, MQ Series, Data Propagator, Info Integrator, Siebel, and Yantra (Order to Cash system). Please contact Eric Heineman at ext. 239 or e-mail heinemane@kendalldavis.com Position H608

SR DB2 DBA

The Senior DB2 DBA functions as a high-level technician working on a large complex RDMS environment (DB2 UDB, z/OS DB2, Sybase, Oracle, MS SQL). As a member of a team of six DBA’s, the Sr. DBA should be capable of thinking independently, while operating in a team environment with a willingness to follow pre-defined I.T. policies to satisfy our customers. You will be responsible for design/analysis, installation, monitoring, maintaining, troubleshooting and tuning DB2 UDB databases for customers remotely and on-site. Project management responsibilities include identifying the scope of assigned projects, generating solutions to technical issues, reporting analysis and results, and providing deliverables in a timely manner. You must be adaptive to the use of new software aids and programming techniques as they are adapted within I.T. The Sr. DB2 DBA may also research and provide recommendations in support of procurement and development of database software and related tools. More than four years experience in DB2 UDB production support. SQL and SQL performance/tuning. Data modeling and other Development DBA skills. AIX, Linux. Unix Shell Scripting and data partitioning implementation. DB2 implementations (large databases, replication, cluster-based). DB2 UDB internals, memory configurations and in-depth knowledge of database snapshots. Maintain and monitor availability, security and integrity of databases. Backup, recovery and forward recovery experience. DBA with Sr. Level Oracle or Sybase experience. Unix Scripting and problem solving are a must. Large environments. Change Control. Please contact Steve Martin at ext. 229 or e-mail martins@kendalldavis.com Position H594

SR. SYSTEMS ANALYST

As a Sr. Systems Analyst you will join a team of 10 supporting all DW systems. This group supports Data Mgmt (the business area) and this team is considered the support group. Currently the business area handles most of the development for ETL. The manager wants that to change. You will come in and learn the daily load. Currently they perform a lot of manual synchronization where everything does not load cleanly. They want to implement scorecards and dashboards. They are also looking at Real-Time replication. The manager expects you to have at least 10 years experience so you can drive out requirements and specifications by asking the right questions. The technical environment is Oracle sitting on Solaris and Linux with PL/SQL for ETL with about 200+ ETL batch jobs that run every night. Currently the source to target is 1 to 1 with over 4 TB’s of data. They have Crystal Reports and Business Objects for reporting. They are looking at 3^rd Party packages for ETL. You must have experience with PL/SQL for ETL, Datamodeling and Metadata standards. You will interact directly with customers to define business requirements. Currently 10-20% New Development, 80-90% Maintenance. 10-20% Req. and Design, 80-90% Code and Test. To be: 50% New Development, 50% Maintenance. 50% Req. and Design, 50% Code and Test. Please contact Eric Heineman at ext. 239 or e-mail heinemane@kendalldavis.com Position H589

DBA MANAGER

As the DB2 DBA Manager, you will manage 10 full-time DBA’s and two contractors. They are currently on DB2 v.7, but are upgrading to v.8. There are about 2400 total DB2 databases that include the development, testing, and production environments within roughly 120 business critical applications. With all databases combined, there is 11 or 12 terabytes of data all running under z/OS. The applications running on these databases include a handful of the bank’s largest – Internet banking, corporate banking, accounting, teller systems, all datawarehouse applications, and the company’s largest undertaking which is the CRM System that will be on DB2. 25% Resource management, resource development, loading resources for service requests. 25% Finance: Vendor relationships, review expenses, salaries, bonuses, etc. 25% Quality: Monitor environment, making sure your team is addressing production issues, preventing future issues. 25% Projects: Partner others in the organization to make sure database and business needs are being met. Contact Steve Martin at ext. 229 or e-mail martins@kendalldavis.com Position H587

COGNOS DEVELOPER

As the Cognos Developer you will join a team of direct-hire ETL Developers, BAs, and a Project Manager along with some contractors that are currently doing the Cognos development. Currently all of the reporting is done with Oracle Reports, with over 300 reports on inefficient Legacy systems, using the operational database which is dragging these systems down, and require a lot of maintenance. Going forward, all reports are moving to Cognos, utilizing an Oracle datawarehouse, which is already in place. They are creating an operational data store that will mirror the operational database, and will run the Cognos reports against the ODS, using Oracle datawarehouse builder for ETL. They have 4-6 cubes up and running on version 8, with more being designed and developed. It is estimated that they have 50 reports in constant use, 50 regular use (weekly/monthly) and about 150 with limited use (yearly), and they feel that they can eliminate about 100 current reports through consolidation. This position will champion all reporting process, design, development, reporting standards, efficient and effective ways of interacting with business, etc. They have prioritized the reports being moved to Cognos and are initially concentrating in the areas of Academic Affairs and Marketing and Recruiting. 50% Technical/Code and 50% Design/Analysis. Experience in order of importance: Reporting; Cube design and development; Model, Architecture, Security; Analysis – work with business. Contact Steve Martin at ext. 229 or e-mail martins@kendalldavis.com Position H578

SR DATABASE WAREHOUSE ANALYST

SR SQL SERVER DBA

As the SQL Server DBA you will join a team of 15 where you will be responsible for several DB’s. The Manager is looking for a Sr. Level DBA with replication clustering a must! The DB’s are currently running on SQL 2000, but will be upgrading to SQL 2005 this year. These DB’s range from the smallest ones being measured on megs up to the larger ones being measured in terabytes. Some of the DB’s are web-enabled using C# and ASP. They run on Windows 2000 and 2003. The business applications ran on these DB’s include Claims, Policy Service, Direct I.T. Business as well as others. While in this position with team member you will be expected to do the installs, upgrades, patches, backup, recovery, monitoring, and tuning that is normally associated with most DBA position. This position is 60% physical and 40% logical. They will be using Veritas for backup and Net IQ for monitoring. You will be adjusting the policy services available and doing a lot of DataWarehousing. There are a lot of projects currently on the table. Contact Trevor Howenstine at ext. 259 or e-mail howenstinet@kendalldavis.com Position H568

SR. APPLICATION ANALYST

You will be 1 of a 2-man team for all of the Americas. There is 1 other team of 2-3 in Europe as well. As the Lotus Notes development goes, it will be mostly GroupWare applications, building applications for local, regional and global and for internal business use ranging from CRM to a wide variety of other applications. If you have any Microsoft .Net skills, you will also be used on the E-Solutions team. If not they will train you. They have 15 external sites and 1 internal Intranet site. All of the E-Solutions people (4) are in Cincinnati, the GroupWare team is regional, and will also work in Cincinnati. There is very little travel with this position except for training to maintain certification levels, the cost is covered by the company. Requirements Gathering 15% - directly from business owners and end users, formalize this and get agreements. Analysis/design 15% - diagram or prototype solutions to get agreements or solutions. Development/testing 40% - Lotus Scripts and Notes formula language and M/S web technologies. P/M 10% - lead projects themselves or other development, helping with testing and prototyping, communicating progress of project. Staying on schedule, managing scope. Support 20% - keep apps running, implement minor enhancements and related tasks. Performance tuning. The goal is to build applications to help the business side by being more efficient, increase sales affecting the bottom line. Please contact Casey Wills, at ext. 228 or email wills@kendalldavis.com. Position H517.

DATA/INFO SUPERVISOR

As the Data/Info Supervisor you will manage a team of 10 DBA’s and 1 Data Modeler. This environment consists of over 50 instances of DB2 z/OS, over 50 instances of UDB AIX, and around 24 instances of SQL Server. These databases are Web-Enabled using Weblogic/J2EE going to WebSphere. These systems run all the business applications from Customer Info, Employee Info, G/L, Payroll, A/P, A/R, etc., including Peoplesoft for HR data. This team performs installs, upgrades, patches, back-up, recovery, monitoring, tuning. 75% Physical, 25% Logical. BMC products used for B/U and recovery. You must have a DBA technical background to lead this team and maintain their trust. You must also be familiar with Kimball and Inman methodologies. The big push for this team is to meet the demand the business has for information. On average the team performs 50% Support and 50% Transaction system enhancements to meet the business demand. You will also collaborate with the BI team to create an Enterprise Data Warehouse. They currently have an ODS with DM’s feeding it running on UDB AIX with Informatica for ETL and Cognos for reporting. There were 4 OLTP systems, now there are 3 OLTP disparate systems using MQ Series for messaging. The 3 goals in the first 6 months are to: 1- Work with the Data Arch to establish standards. 2- Establish effective process for system enhancements. 3- Manage the people to deliver projects efficiently. You will perform 80% Mgmt – budgets, vendor relationships, tactical and strategic planning, use metrics to determine performance, team reviews, goal planning, work with other Managers to align strategy. 20% Technical – hands on DBA experience, thrown in with team to solve technical problems. Please contact Eric Heineman, at ext. 239 or email heinemane@kendalldavis.com. Position H534.

ENTERPRISE DATA ARCHITECT

As the Enterprise Data Architect you will look horizontally across all of this Fortune 500’s assets to find ways to maximize value and lower costs of data delivery! You will define the approach to capturing and representing both business and software info to turn concepts into actual architecture and design. Determine high level approaches and modeling guidelines for Enterprise Level application info processing systems, identify areas for sharing and re-use of systems, facilitate the B/A’s and Architects construction of data models that bridge the two roles and keep projects in line. You must be comfortable being in a boardroom to champion the Enterprise Data Warehouse. Currently Enterprise Data is delivered by Point-To-Point that has caused an unmanageable amount of interfaces where the data consumers interpret data inconsistently, redundant cost to build and maintain legacy ETL, no common dimensions for Data Access Services, inconsistent database design, no way to measure data quality. The goal is to lead change to use and see the value of an Integrated Data Environment where the data consumer can get info from data sources through the Enterprise Data Warehouse that will deliver a consistent and manageable view of information, thus eliminating the "Hair-Ball" effect of the Point-To-Point interface madness. Currently there are 35 Data Sources consumed from 7 different lines of business that feed 253 Data Publishing sources. Legacy, source systems sit on M/F DB2, VSAM, and Flat Files using an outdated ETL tool that performs 95% of the work here. The DW sits on Oracle and Informatica only doing about 5% of the work! This is leaving millions of dollars on the table in lost business! This position can turn into you selecting and managing your own team of Data Architects depending on your skill level and ambition. 80% requirements (analysis-level models and process models), Architecture and Design Presentations, get buy-in! 20% technical (Case Tool and Prototypes). Please contact Eric Heineman, at ext. 239 or email heinemane@kendalldavis.com. Position H537.

BI ANALYST II

You will join a team of 5 others. The Manager is hands on but his time is spent 90% mgmt and 10% technical. They have 5 websites and 1 Intranet. They maintain these sites, which are a Service Web site, PDA Servicing Website, E-Commerce, and Pharmaceutical sales which is known as E-Pedigree, and that is the current hot project with a drop dead date of July 1^st for it to go live. These sites pull from SQL Server databases on Windows, Unix-BAAN (ERP)-Oracle. WebSphere sites are Java, JSP Pages and are converting all ASP to JSP as well. SQL Server has 7 D.B.’s in production. The biggest is around 250 gig and the smallest is 25 gig, which is the B/I web server. Cube development is done with data beacon-OLAP cubes. The reporting tool is Crystal Reports using Excel spread sheets. The front-end of static reporting is VB scripting – Access – VB.6.0-Visual Studio. You will also be creating Stored Procedures, DTS, queries, and creating tables. No installs, upgrades and patches. Communication skills are critical to this position. You will be working directly with the users. The manager describes this part of the position as a combination of a P/A and B/A, doing requirements gathering and design testing and coding. This is Full Life Cycle development. 80% Data mining and reporting, 20 % documentation. As an overall high level view this position will be 70% technical and 30% user interface. Please contact Casey Wills, at ext. 228 or email willsc@kendalldavis.com. Position H541.

APPLICATION DBA

As the Applications DBA you will join a team of 4 where you will spend 50% of your time on Oracle and 50% of your time in SQL Server supporting new development. Build the databases right, then build the application on top of it. These systems are Web-Enabled with WebSphere and J2EE on the front-end. Currently there are legacy batch jobs that the M/F has an extract program that DTS pulls data out of to push data downstream. There are about 50 DTS batch jobs that run every night. The future of this team is to convert all legacy ETL and DTS to Informatica. Business systems here are Distribution, Sales, Customer MGMT, and Marketing. You will work with and interact with production DBA’s, DW Developers, and application developers to gather requirements and understand the business need. Find how to clean up the batch infrastructure, integrate back-end systems, clean up the data model, determine the frequency of data up-load from the M/F, and create reporting requirements. The current project focus is consolidating systems that are core to the business. There are currently 3 different DW systems representing 3 different business units. These 3 systems will be integrated creating an Enterprise Data Warehouse in Oracle and Informatica in 2007. There is fresh leadership here, even Sr. Management is from a technical background. They want to create systems right with a data architecture that is more global. You will create PL/SQL ETL, DTS Maps, Stored Procedures, Schema Development, Table Design, and Data Modeling. 50% New Development - Building from scratch back-ends. 50% Maintenance – Improve performance. Please contact Eric Heineman, at ext. 239 or email heinemane@kendalldavis.com. Position H501.

MARKETING ANALYST

As the Marketing Analyst you will join one of the premier companies in the world focusing on the financial sector. You will use SAS to allow your team to make better business decisions. You will manage the interface between legacy systems and front-end reporting systems. Perform analysis to understand the client base of over 25,000 indirect clients (StoreFronts) who carry this company’s products. Analyze the client behavior (Segmentation) broken down in StoreFront Size of small, medium and large, and determine the level of penetration your employer has within this client. 2 ½ years ago this company developed a large householding system. Currently they are creating a new prospect D.B. integrating clients to target more effectively and expand penetration. Such as - a company only 2 years old is too small or new to be a target! You will manage all data and info for clients regarding their current marketing lifecycle interacting with marketing managers, client development, sales force, credit risk, lenders agents, and operations. Your work product is to plan, code, coordinate, report on and analyze client marketing programs, create and manage segmentation and modeling schemas for clients. Develop "Data Products" that form the foundation for consistent processing and accurate measuring. Provide data fulfillment for new product development, and output monthly dashboards and scorecards. 65% Database Management, 20% Reporting, 10% Analysis, and 5 % Modeling. Percents of time will change as you learn the business! Please contact Eric Heineman, at ext. 239 or email heinemane@kendalldavis.com. Position H468.

MARKETING MANAGER

As the Marketing Manager you will join one of the premier companies in the world focusing on the financial sector. You will be in a managing role on high visibility projects as you use data to sell more financial products. You will be responsible for 4-5 SAS Marketing Analysts working with sales V.P.’s to develop strategy, drive growth, market analysis, acquisitions, and business retention to increase ROI across the entire client base. This organization has over 100 different clients and generated $ 12 Billion in sales for 2005. You will perform 50% Mgmt/50% Tech. The technical side consists of *Database mgmt – by using SAS for ETL, data creation, data flow from in and out of multiple systems. *Reporting by proper alignment of output from request and productionalization. *Analysis – identify (or be given) a problem and figure out what is happening (leading indicators) and make suggestions or recommendations on how to fix/address: use statistical concepts, common sense, and business knowledge. *Modeling – true statistical modeling, either personally doing it or managing internal or external support teams. The management side consists of directing team efforts, assigning projects, mentoring, using business knowledge to get buy in from business representatives. This company has over 20 million records using SAS 9.1 to target home equity lines of credit and deposit products. You will manage over 100 monthly marketing campaigns and cross-sell marketing. SAS is used for database marketing, using data from credit bureau, customer performance, customer demographics, and historical data. You will see the fruits of your labor in this position! Please contact Eric Heineman, at ext. 239 or email heinemane@kendalldavis.com. Position H466.

DBA

You will join a team of eight DBA’s, two of which will work with you on UDB, while the others are focused on SQL Server. This role will focus on UDB 8.2 (64 bit) sitting on Aix and Solaris utilizing Unix Scripting (Korn) to initiate the ETL process, moving data from the Mainframe. There are a total of 18 UDB databases in the development, QA, and production environments ranging in size from 2 gig to 300 gig. You will work on the ETL application, Web application and the Customer Service Agent application, which includes the Master File data and will have over one terabyte of data just from the initial load, not including future growth. They currently have all of the data for customers who have purchased specific products, but need to incorporate all data for the buyers of other merchandise, since the merger of the two companies. This initiative will require UDB EEE experience, and these databases will be web-enabled via Java, JBoss and JDBC. This position will be responsible for 24x7 support of the ETL process, analyzing script failures, table space, etc., database changes for new development, execute the ETL process, change control for moving from development environments to production environments as well as configuring EEE as the additional data is added. You would also be responsible for performance tuning working with the data access layer of the application. You will use all of the DB2 tools including TSM, Control Center, DB Artisan, Snap Shot and Event Monitor. 100% Physical, 50% DBA duties, and 50% Unix Scripting. Please contact Steve Martin, at ext. 229 or email martins@kendalldavis.com. Position H465.

SQL SERVER DBA

ORACLE DEVELOPER

You will join the team responsible for the Lease Finance Management system for equipment leasing worldwide. This system was just rolled out to the U.K., with the next roll out planned for Western Europe, then to Spain and Germany and eventually the U.S. over the next couple of years. This is a complex Oracle Application utilizing several components of the Oracle Business Suite 11.5.10 for the back end/after sale processes such as fulfilling terms, invoicing, asset management, etc. This team was involved in the Beta testing of Oracle Lease Management (OLM), which sits on top of Oracle Financials, during their roll out to the U.K. and now have it in full production. They had about 20% customization of OLM for the U.K. roll out and anticipate this percentage to increase as they move forward. This customization is where you would spend a lot of your time. You will focus on Oracle Financials, Forms and Report, and produce some customized Business Objects reports and depending on the stages of the project work closely with vendors, clients, Unix team, DBA’s etc. Being a financial institution, you will adhere to SOX, so experience with code management/change control and exposure to design reviews is a plus. Pluses: JDeveloper, Database Architect, Apache, JavaScript, Shell Scripting. Unix Background: Familiar enough to work with Hardware Engineers (they are migrating from Aix to Linux). Contact Steve Martin at ext. 229 or email at martins@kendalldavis.com. Position H457

There are three positions on this team:

1. Lead – 60% Lead/Mentor, 40% hands on tech. Experience with entire business suite and Accounting experience.

2. Developer – 80-90% code, 10-20% User interaction.

3. Maintenance – 100% code. As system grows, more maintenance is needed.

ORACLE APPLICATIONS DBA

You will join a team of 11 DBAs. All of these DBAs have Oracle backgrounds, but are getting cross-trained on other platforms including Sybase, Informix, and SQL Server. The Oracle team is responsible for instances of 70 gig on each of the five primary applications totaling 350 gig, which are front-end web-enabled with some Java client on the backend. This is currently an Aix environment, but they are migrating to Linux. The primary focus will be on their international on-line lease management system that includes five application environments, and five database environments with 2-3 schemas each. This is a customized application utilized by the sales force in the U.S. and Europe and continues to expand. You will be a stakeholder in the database architecture and be involved in the design as the migration from Aix to Linux takes place. You would be responsible for performing installations, patching, schema object moves and architecture design for this application while mentoring and assisting other database staff. This position would also involve performing the implementation of very complex/advanced platform solutions while providing input in setting database platform strategy for the corporation. It is important that you have worked with Oracle application tools such as Concurrent Manager and the architecture of Oracle Applications. In-depth experience with Unix and patching and cloning will provide a great knowledge base for this position. Contact Steve Martin at ext. 229 or email at martins@kendalldavis.com. Position H451

BUSINESS OBJECTS DEVELOPER

You will be joining a team of 8-10 people to include other developers, ETL and testers, etc. This is a pretty mature environment, so for the most part in 2006 there will be very little new Universe development, but at the end of 2006 they will be creating a new data mart which will offer the opportunity for a lot of new development. Until then there will be maintenance on the existing Universes. The primary focus for this position will be Data Analysis, trouble shooting with end users, good communication skills, and consult with the users on what they need. Quoting the VP, "Data Analysis is Key!" You will also support Universes by making changes, doing monthly releases and release notes. There will be times as end user Help Desk, you will be answering calls and meeting face to face with users and responding to emails and deposit products space. There are 4 in the rotation now; you will be number 5 on duty for 1 week at a time. 25% Help Desk, 25% Universe Design, 25% Educate end user and 25% Develop complex reports and monitor query. Anyone can learn how to use a tool. You must be willing and eager to learn and be excited about what you will learn. Business savvy is also needed. Contact Casey Wills at ext. 228 or e-mail at willsc@kendalldavis.com. Position H410.

SQL DBA

Sr. Oracle DBA/Arch.

As the Sr. Oracle DBA, you would join their current DBA team of three concentrating on their corporate applications consisting of Oracle Financials, Accounts Receivable, Accounts Payable, Claims Processes and PeopleSoft for HR and Payroll. One year ago, they were going to outsource this work but since Oracle bought PeopleSoft, this has become the strategic platform for new applications. There are currently 30 Oracle databases ranging in size from 100 gig to 300 gig sitting on AIX 5.3. To become acclimated with the environment, you would go through systems review for their Health Check System on all environments performing "Hot Backups." You will then need to identify where the company is on all Oracle Systems. By the end of the first quarter in 2006, they would like you to be a lead on your team, leading the efforts to convert to 10g. This will require that you understand the benefits of 10g and create the vision of where the company should be relative to Oracle. You will perform gap analysis to identify how to get there and then implement/execute your plan. They are looking for someone with an architect mindset focusing on Oracle but open to other technologies. Other areas of focus will be Third Party application, Health Check process and long-term Oracle Strategies. Contact Steve Martin at ext. 229 or e-mail martins@kendalldavis.com. Position H202.

SQL Server DBA

You will join a team of eight SQL Server DBAs working on SQL Server 2000, soon to roll out UCONN (2005). Some of these databases are web-enable via .NET on IIS Servers and they range from 1 gig to 80 gig. They are currently using SQL Server Utilities for back-up/recovery, monitoring and tuning, but are integrating Veritas. SQL Server has become the strategic direction of the company with the CIO directing all new applications to be run on SQL Server. In addition, they are in the process of building a 4-6 Terabyte data warehouse. You will support 15 applications, 5 of which are extremely active and are used for Sales, Service and quoting. You will need to be driven to learn more as in any give month; they will receive 1000+ requests for changes. You will start out working in the development environment, then once acclimated, move into the production environment. Contact Steve Martin at ext. 229 or e-mail martins@kendalldavis.com. Position H203.

DB2 Mainframe DBA

You will join a team of 7-8 other DB2 DBAs working with v.7, soon upgrading to v.8, with over 5,000 MIPS sitting on Z/OS 1.4. There are over 100 DB2 databases ranging in size from 1 gig to 3-4 terabytes. Although DB2 will be your primary focus, you will also be exposed to UDB, Oracle and SQL Server. The company is in the process of becoming compliant to Sarbanes Oxley as well as meeting PCI (personal credit information) guidelines as it relates to vendor security, privacy, inscription, etc. It is imperative that you keep the communication lines open and can effectively communicate with them via conference calls. Your duties will include working with tables, stored procedures, building databases, indexes and database object. You will also be responsible for the day to day overall support and changes for the databases from an applications perspective. Contact Steve Martin at ext. 229 or e-mail at martins@kendalldavis.com. Position H206.

IT/DB2 Manager

As the DB2 Manager you will be responsible for 7-10 full-time employees. The majority of your time will be spent in the management role giving your team direction and performing administrative duties, but it is critical for you to have DB2 DBA experience to effectively lead your team. Any experience with UDB, Oracle or SQL Server would be helpful. Upon joining this team you will need to asses the DB2 team and identify what needs to improve to meet the business needs. Your focus will be 6-18 months out providing the technical direction of your team and of DB2. Your responsibilities will include Administrative: Employee reviews, status reports, training, personnel issues. Team management: Prioritize projects, problem solve, team meetings, making changes to the direction of the team, analyze where they are and where they need to be, future planning and delivery goals while understanding the workload.  Evolve the business technical perspective: Understand from a system and application DBA perspective what new technology they can leverage, stabilize, maximize and preach the new direction. Contact Steve Martin at ext. 229 or e-mail martins@kendalldavis.com. Position H207.

Data Analyst

As the Data Analyst you will join the #1 revenue generating team in this growing company. You will work on the back-end in the Data Warehouse side with DB2 7.1 going to 8.1 next year. The front-end of this system is all Web Based using Websphere and JAVA connecting to field sales agents allowing them to generate more business directly from updated and accurate data. Your focus will be ensuring data objects are loaded properly for application changes, get spread-sheets from business users with specific product information detailing changes to products and/or services, then making those changes in the system. You will also analyze the application for changes and loading of data, handle transaction processing from a data point of view, SQL coding and query performance review, write stored procedures, create test scripts and test cases, and recommend on table and column design and create tables and columns based on your design recommendations. This team is also standardizing on their application and Data Warehouse architectures. Your time will be spent on 80% MF DB2 and 20% AIX UDB (90% physical – 10% logical.) 50% ND and 50% maintenance.  Contact Eric Heineman at ext. 239 or e-mail at heinemane@kendalldavis.com. Position H209.

DBA SQL Server Jr.- Mid.

You will join a team of two other SQL Server DBAs along with six developers. The SQL Server databases are 2000, service pac 3 and migrating to 2005 in 2006. Oracle is currently 9i and migrating to 10g in 2006. Currently they have 90 Oracle licenses/46 databases with three billion rows of data and 1000 gig. Now in SQL Server they have 20+ licenses going to 40 in 2006. They have 53 SQL Server databases and 115 gig with 263 million rows of data. Oracle Financials is the largest database and in SQL Server a budgeting database is financial related. Some of these databases are web enabled, the Oracle databases are JAVA and Tomcat, and the Microsoft side is IAS, ASP.NET 2003. The current environment is 80% UNIX Solaris and 20% Windows 2003. This job includes the standard DBA duties to include installs, upgrades, patches, back up, recovery, monitoring but the primary duty will be performance tuning on the database level and then helping developers with SQL/Tuning. Projects slated within the next year are the conversion of all financials from Oracle to SQL Server. Contact Casey Wills at ext. 228 or e-mail at willsc@kendalldavis.com. Position H190.

ETL Developer Mid-Level

The team you will be joining has four others who are all report developers/software developers, which means you will have plenty of resources for career development in learning report writing and also the opportunity for you to mentor and train them in Informatica. They would like at least mid-level ETL skills, providing growth opportunities to senior then lead levels. You will be working with all types of data from financials, products, and customer operations just to name a few. Requirements have been gathered for many projects already. Some of the benefits these projects are focused on, delivering to the business and end users, are to ultimately lead to increased revenue through subscriber growth and decrease in expenses through operations efficiency gained. The goal of this team is to be more proactive than reactive. Pluses for this position would be having working knowledge in shell scripting, Actuate, Cognos, and/or OLAP. This position will be 90% development and only 10% maintenance. Contact Casey Wills at ext. 228 or e-mail at willsc@kendalldavis.com. Position H172.

Applications DBA

This company has just recently redefined the role of their system DBA’s to allow them to concentrate on the installs, upgrades, monitoring, and back-up/recovery of the databases. Now that the DBA teams’ role/duties have been redefined there is now a gap between the development team and the DBA’s. This position was just created to be the "go-between" interfacing w/application developers and DBA’s, working with DB2, Oracle 9I, and SQL Server 2000 on I Series Servers. Currently there are roughly 40 application databases, ranging in size from 300 gigs to 1 gig, of which 7 or 8 need attention to their table space, indexing, fine tuning, etc. With this position being new, part of the challenge will be in identifying the role you will play with your developer and DBA teams. You will be responsible for the Imaging and Workflow applications. They are using BizFlow and AWD for their Workflow application. You will optimize queries on existing applications, customize table schemas off of vendor applications, and build indexes part of the time, but the majority of your time will be spent on reorganizing data and database design. It will be important for you to have the knowledge base that will allow you to grasp the functionality of the applications based on the schemas. Contact Steve Martin at ext. 229 or e-mail at martins@kendalldavis.com. Position H187.

Senior Data Analyst

The primary responsibility of this position is to assist in resolving data quality and service issues within the company's Enterprise Data Warehouse environment. This analyst will be responsible for researching data quality issues and working with the EDW developers and business customers to resolve them. The analyst will be responsible for tracking all outstanding issues, their root causes, the time for resolution and any other information. The person in this role will be the primary communicator to the rest of the business regarding issue status and resolutions. In addition, this role will be responsible for monitoring and helping correct data exceptions which occur during nightly EDW processing. This role will also be responsible for communicating service outage information to the EDW customers, and facilitating impact assessment of service disruptions. Key job activities include identifying and documenting quality problems in the EDW, data analysis within the EDW for the purpose of data quality, producing monthly scorecards regarding quality and outstanding issues, communicating impact and service outage information. Candidate must be able to work independently without significant supervision and have proven facilitation skills. Must be a team oriented individual with a results driven attitude. Must have strong written communication skills and must have strong analytical problem solving skills. Other pluses would be writing structured queries (SQL) and experience in or exposure to the following software, technologies and methods: EDW Best practices, Six Sigma methodologies, application software: Informatica, SAS, DB Technologies, IBM DB2 (EEE) UDB, SQL Server, query tools/report writter/ OLAP technologies including Actuate, Cognos, and Crystal. Contact Casey Wills at ext. 228 or e-mail at willsc@kendalldavis.com. Position H153.

Senior Informatica Architect

In this position they are looking for a Senior Level ETL Developer/Architect for the Data Warehouse Services Group within this company’s Enterprise Enablement Department. The candidate possesses high level skills as illustrated by recent roles and responsibilities in the successful delivery, transform, cleanse and move data and metadata for loading into a large EDW and associated data marts. Candidates will assist with infrastructure build, logical physical data modeling, exception handling and auditing of a daily grain EDW. The candidate understands source systems data, working as a Data Steward for those systems. The candidate will interface with other areas including corporate data architecture, information delivery, Portal, and production system DBA’s. Required 5+ years experience of cross-platform exp., spanning mainframe and Unix AIX software product development support. Experience in building and supporting large EDW’s using Informatica Power center ETL tool and best practices methodologies. Strong conceptual, leadership, and technical skills, ability to translate business needs into technical solutions, sound understanding of relational and dimensional data modeling and database design skills. Contact Casey Wills at ext. 228 or e-mail at willsc@kendalldavis.com. Position H154.

UDB DBA X2

There are 2 UDB positions on this team of 14 DBA’s for this global company. They are using UDB 8.2 running on Windows. Currently there are 6 UDB instances with about 50 gig of data. You will work on multiple projects where you will learn Oracle, Sybase and SQL Server. The entire environment has over 20 TB’s of data – very large and complex. However you will focus on UDB for the first year and a half. After that the focus is to standardize the environment and convert all UDB applications to Oracle. Oracle sits on AIX and Linux. You will perform installs, upgrades, patches, backups, recovery, monitoring and tuning. Primary tools are SQL Backtrack and BMC Patrol. These databases are web enabled using MQ Series. The UDB environment is consumer information processing application. The first 3-6 months the manager expects you to adapt to the system and establish relationship with the applications side in this complex environment with talented team members. Contact Eric Heineman at ext. 239 or e-mail at heinemane@kendalldavis.com.  Position H144.

Group Manager for D.B. Support

There will be 20+ DBA’s on this team that will report to you as their manager. There are four sub teams each with a team lead; the teams are Oracle, UDB, M/F DB2, and SQL Server. You will manage the support of the Network Operating System and hardware; everything is fine there till it breaks. Also you will manage upgrades and new releases. You will have DBA’s in three locations in the Cleveland area and one location in Columbus as well. You will be required to sit down at least once every two weeks and discuss with them any and all issues they may have for you and what you need them to be informed about. Also would you like to go to India once every two years to meet DBA’s there? The action verbs to best describe this position according to the director over you are as follows: communication and managing staff. Contact Casey Wills at ext. 228 or e-mail at wills@kendalldavis.com. Position H168.

Enterprise Data Architect/VP

This is a true Enterprise level role at a VP level. You will join a ripe environment where the political battles are over. Now this company understands data and is hungry for more. This is a national company with 19,000 employees nation-wide, with thousands of data sources! They are starting to leverage true integration where you will advise applications on how and where to get the data for EAI purposes. They have a very defined direction of where they want to go; you will set the strategy of how to get there. This organization has taken a centralized approach, so all data is centralized- not federated or distributed. You will understand where the data resides in the company, where to place data – su