Job Responsibilities: Will provide a blend of Technical/Functional subject matter expertise in the areas of maintenance, support and development for a variety of database platforms including Teradata, Oracle, SQL Server, IDMS, and Sybase. This role specifically works in collaboration with vendor engineering teams and the internal community to provide enterprise and system level consulting on business analysis, database design, and development efforts. This role identifies ways technology solutions can be applied to support business strategies and improve business processes. Individuals in this role partner with business units and company Business Consultants team to communicate and clarify business needs to vendor resources, contribute to development of long-range systems plans and architecture, assist in requirements elaboration, and ensure products and services are aligned and implemented to meet business needs. May be required to participate minimally in hands-on development work, specifically when it comes to assisting with high severity incident reports or time-critical project deadlines. Incumbents will conduct business process analysis, needs assessments, and preliminary cost-benefit analysis. They also review estimates and designs to ensure compliance with architectural standards. Strong collaboration with the architecture team is expected. This position can also act in a Business Relationship Management capacity partnering with the business functions to ensure that their IT systems needs are met. Working in collaboration with the Business Consultant, the role may also be responsible for developing end to end Level 4 business requirements and the management of Level 0-4 capabilities and requirements for small, vertical domain focused business requests, documented using the Blueprint tool. Following are general accountabilities as well as targeted accountabilities depending on the nature of the position.
Job Requirements: HS diploma + 8 years experience in all phases of IT system development Life Proven appropriate degree of Functional and Technical acumen for the respective technology domain. Knowledge of large complex systems with respect to the Business Processes, Technology, Integration points, and Infrastructure. Ability to size concepts and develop L4 use cases using Blueprint or related tool. Ability to work and collaborate effectively with offshore-based vendors. Understanding of Organizational Change Management (OCM) and Quality Assurance
Technical Requirements: 1. 2+ plus years hands on experience with Erwin 2. Extensive knowledge in all facets of data warehouse design (Star, Snowflake, normalized verses denormalized, referential integrity, etc.) 3. Certified DBA in either Oracle or Teradata with working knowledge of one or more of the following databases: SQL Server, Sybase, IDMS, Sybase Prior experience writing ETL solutions 4. 8+ years experience in the design, build, deployment, and maintenance of an Enterprise Data Warehouse environment 5. 8+ years SQL coding experience 6. 8+ years managing databases from planning and testing stages through implementation and support 7. In-depth understanding of security and backup procedures to ensure database integrity 8. Good understanding of database schema objects including tables, views, packages, procedures, sequences, indexes, and constraints 9. Experience in database reorganization, migration, server tuning, capacity planning, collecting statistics, software upgrades, Disaster Recovery, and High-Availability 10. Strong in-depth experience in database performance tuning and SQL tuning
Desired Requirements: BS in CS or IT; IBM DataStage experience is a plus
Interested candidates should send me a WORD copy of your resume and I will contact all qualified respondents. Only Green Card holders or US Citizens will be considered.