COGNOS DATABASE ADMINISTRATOR/DEVELOPER

Our client is a leader in the insurance and financial services sectors. With operations in more than 100 countries, our client serves commercial, institutional and individual customers through the most extensive worldwide property, casualty and life insurance networks of any insurer. In addition, the company is a leading provider of retirement services, financial services and asset management globally. The company is currently seeking a seasoned Database Administrator/Developer for an immediately available position in the northern Delaware vicinity. This position requires solid proficiency with Cognos B1 as well as MS SQL server systems.  Job Summary:Several years experience with Microsoft SQL Server 2000/2005 RDBMS. Expertise in writing complex T-SQL, triggers, and stored procedures; Relational database analysis and modeling experience; configuring database network connectivity; database backup and recovery techniques.  Experience in insurance or financial services and ability to translate business needs to Cognos reporting. Job Responsibilities:This position requires an individual capable of the day-to-day management of multiple Microsoft SQL Server environments and Cognos Framework manager. The DBA will participate in the administrative, support and analytical tasks related to the proper function and tuning of multiple MS SQL Server environments and be responsible for administering MS SQL Server systems supporting data repositories for Cognos BI 8 reporting systems. The successful candidate will also act as a business consultant having the ability to translate business needs into appropriately scoped software solutions.  Develop new or maintain existing databases based on specifications from key business partners Respond quickly and effectively to production & development issues and taking responsibility for seeing those issues through resolution. Resolve database performance issues, database capacity issues, replication, and other distributed data issues. Design & implement data models and database designs into physical databases. Install and maintain database software and manage backup and recovery of databases. Manage security of database structures and corporate data held within databases. Develop database procedures, triggers and SQL scripts for development teams. Maintain database changes from Development, QA to Production. Assist in the definition and implementation of database standards. Monitor databases for errors and perform problem determination when necessary. Assist in coordination of establishing data feeds from Excel templates, flat files or direct feeds. Lead Cognos report building with assistance from business.  Requirements: Bachelor’s degree in technical discipline; or equivalent professional experience with experience in insurance or financial services. Experience writing complex SQL, triggers, and procedures 3 to 5 years of experience with Cognos Business Intelligence (ReportNet, PowerPlay, or  Cognos8), Planning (Analyst, Contributor), Scorecarding (Metrics Manager), and Metadata Modeling (Framework Manager) Ability to work with minimal direction, yet also able to work in team environment. Relational database analysis and modeling experience. Experience configuring database network connectivity. Understanding of database backup and recovery techniques. Proficiency with SQL Server DTS/SSIS Basic knowledge Windows/Intel environment Ability to test deliverable products for verification of stated objectivesThis is an excellent opportunity for those candidates who are seeking transition from a contract based position to a permanent position with long term stability, fringe benefits and solid career growth potential with a well established, thriving company.  MRINetwork is the largest and most successful search organization in the world. Each MRINetwork office is a single point of contact to over 1,100 offices in more than 37 countries, our candidates have access to the right jobs virtually anywhere in the world. LOCATION: US-DE-Delaware JOB CATEGORY: IT/Software Development TYPE: Full Time, Employee SALARY: 80,000.00 - 100,000.00 USD /yearBONUS POTENTIAL TO 10% JOB REFCODE: DBA/DVL/DE COMPANY: MRINetwork CONTACT NAME: Vince Albrecht PHONE: (908) 722-3252 EMAIL: Apply by Email