*Position : Essbase Administrator Location : Concord, NH Duration : Long term Rate : $45/h*r
Shared Services IT - Enterprise Data Services This position is required to maintain and support multidimensional database systems and software on the Enterprise Data Services team. Primary concentration is on the day-to-day activities required to maintain a reliable OLAP database environment. In addition, this position is accountable for the support of accessory components to the Hyperion software, such as Planning, Reports and Analytics. This position is responsible for analyzing the OLAP database needs of Lincoln Financial business units; assisting in the development of multidimensional data designs to address business requirements and assuring that detailed data standards and structures are established and utilized by system and application developers. The position will be involved with the development, implementation and enforcement of database policies and procedures, will ensure the availability of data through backup and recovery best practices and will execute regular performance tuningexercises on the OLAP database portfolio and corresponding servers. This position will work very closely with the EDS staff in all locations and will be involved in building key relationships with the Corporate Systems team. Primary Duties/Accountabilities 1. Support System 9 infrastructure components to deliver a stable environment for production and non-production platforms . Estimate, monitor and tune Essbase DBMS to meet retrieval and calculation performance and storage capacity requirements . Monitor capacity . Tune OS for performance . Develop/Implement backup and recovery plan . Provide defragmentation services for Essbase cubes . Monitor hardware usage and recommend upgrades . Troubleshoot operating system problems 2. Provide production control services and execution of the following Essbase components: . ETL Processes . Load Rules . Calc Scripts . Business Rules . HFM Applications . Report Scripts and MAXL Scripts. 3. Provide technical support to the Corporate Services (CS) development team for ongoing operational support for Hyperion applications including installation, configuration, testing, tuning and development of the Hyperion suite of products: . Analyzer . Hyperion Financial Management (HFM) . Hyperion Planning and Hyperion Reports 4. Work with CS staff to transform documented business requirements into logical and, ultimately, physical design specifications for the following Essbase components: . Essbase cubes . ETL Processes 5. Provide ongoing support to the development team for existing applications and ensure that recurring processing schedules and deliverables are met. 6. Provide support to development staff for unit testing, system testing and implementations, exercising full life cycle development of new functionality, enhancements and bug fixes. 7. Foster and maintain good relationships with CS colleagues. 3. Responsibility and Decision-Making Authority . Creation and/or modification of disaster recovery procedures . Restoring data to prod/non-prod database environments . Changing Essbase Server configuration parameters for prod/non-prod environments . Enabling Performance Monitor statistics for prod/non-prod environments . Assist in designing and developing OLAP database structures for all prod/non-prod environments . Troubleshooting database and server performance issues . Researching new versions and features of Hyperion Essbase and OLAP software component packages . Testing and applying appropriate service packs to the prod/non-prod environments . Calling Oracle/Hyperion support to resolve issues pertaining to Essbase . Creating OLAP objects for prod/non-prod environments . Expanding databases, logs, and data devices for prod/non-prod databases . Backup, recovery and reorganization of prod/non-prod databases . Running performance monitors or appropriate tracing mechanisms to troubleshoot or monitor the Essbase environment 4. Dimensions This position has no direct dollar responsibility, however, has major control, at the computer operating level, of integrity of critical data and software, which directly affects the company's ability to do business. 5. Most Difficult Part of Job Heavy emphasis on analytical and creative skills needed to perform duties of this position. This position is required to create intermediate to complex OLAP databases by assisting development staff in the analysis of customer requirements. The position must develop a workable environment for the use of all Essbase components. The position requires excellent written and oral communication skills and must be able to learn quickly and adapt to different customer situations. The person must be able to work independently as well as in a team environment, must be well organized and willing to closely follow policy and procedures. This position must be able to communicate effectively with people at all levels of the organization as well as outside the organization. This person should be able to make effective presentations and be able to teach various aspects of OLAP technologies and software. 6. Experience . College degree in Information Technology or Computer Science or equivalent work experience. . 5 years of applications programming is preferred, 3-5 years database applications programming, 3-5 years database analyst experience, advanced level of analytical skills and a college degree (or equivalent experience). . Expert, applied knowledge of Hyperion Essbase software (7.0.x and above) from an administration perspective. . Understanding of client server and multi-tier hardware platform architectures. . Excellent communication skills, analytical ability and problem solving skills. . Business Objects, PowerCenter,.Net, IIS and Java experience a plus. . Excellent SQL skills. . Ability to work both independently and as part of a team across multiple locations, self-starter. . Ability to work effectively with development staff across multiple locations. . Experience with Software Development Life Cycle (SDLC). . Oracle, SQL Server and UDB experience is helpful. . Ability to manage several tasks in a fast changing and challenging environment. . Thorough understanding and experience in working with ASO and BSO cubes. . Experience with Maxl/ESSCMD scripts, security, tuning/optimization, outline design. . Experience in OLAP environments. . Proficient in database design; familiarity with ETL and data warehouse concepts. . Extensive knowledge of standards, procedures, performance characteristics, and software component logic and interfaces. . Insurance knowledge is a plus. Thanks & regards Asha Suryadevara G Technologies Inc 4340 Stevens Creek Blvd San Jose, CA 95129 408-715-1594 (cell) 408-414-2032 Ext 201 FAX:408-716-8873 [email protected] www.Gtechnologiesinc.com <http://www.gtechnologiesinc.com/> Under Bill s.1618 Title III passed by the 105th U.S. Congress this mail cannot be considered Spam as long as we include contact information and a remove link for removal from our mailing list. To be removed from our mailing list reply with "remove" in the subject heading and your email address in the body. Include complete address and/or domain/ aliases to be removed. If you still get the emails, please call us at the numbers given above. -- You received this message because you are subscribed to the Google Groups "Exact Match" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/exact-match?hl=en.
