Previous Job
Cognos Administrator
Ref No.: 17-00343
Location: Rockville, Maryland
Position Type:Regular, Fulltime
Experience Level: 4 Years
Start Date: 09/15/2016
Job Req -Additional Info
Clearance Requirement:Public Trust
Shift Work?:No
Work Schedule::8 am - 5 pm
Must be a US Citizen or a US Permanent Resident. Must have or be able to obtain and hold a Public Trust clearance.

Telesis has an immediate need for a TM1/COGNOS/Data Warehouse Administrator with excellent proactive skills, to join an established Operation and Support team. The mission of this group is to provide 24x7x365 operational and administrative support for a government Civilian Agency client, and to manage all incoming and outgoing support requests related to the network and business infrastructure.
The effort will provide system administration for networks, servers, and cloud services to include architecture documentation and testing.
Job Responsibilities:
  • As a TM1/Cognos Database Administrator, support the Sr. DBA and perform the following duties:
  • Responsible for ensuring services are delivered effectively and efficiently, to include restoring service interruptions, fulfilling user requests, resolving service failures, troubleshooting and fixing problems, as well as carrying out routine operational and maintenance tasks.
  • Provide database administration, maintenance, and optimization support for AWS MySQL instances.
  • Ability to evaluate, understand and implement patches to the environment
  • Advanced knowledge on Cognos TM1 Platform Administration & Maintenance.
  • Provide occasional support of Oracle databases. Operate, maintain, and administer database servers, hardware, and software in support of application systems; troubleshoot issues with existing or developed systems; work with the appropriate resources to resolve them; and develop database interfaces to Agency databases.
  • Ability to create complex reports - with prompts, filters, grouping, and sorting - based on relational data
  • Administer & monitor multiple Cognos environments including BI and/or TM1 Planning
  • Coordination and where applicable, administration of the Cognos TM1 environments, including managing Cognos TM1 security using Active Directory, and migration of objects from development to production
  • 3+ years of current experience in administering and managing industry standard Business Intelligence applications such as OBIEE, Cognos, Tableau, TM1 & Hyperion EPM
  • Provide database administrative support to SAMHSA systems.
  • Experience on TM1 backup strategy including Integration of TM1 as a data source for Cognos BI reporting
  • Supporting Cognos TM1 end users on basic functionality, running processes, viewing/updating cubes and dimensions
  • Document a strategy, develop a plan, and implement and maintain a more robust database-managed environment, in line with industry best practices.
  • Must have significant experience with database design and optimization including writing and executing DDL statements

  • In addition, must have:
  • Understanding of database performance and tuning.
  • Strong working knowledge of AWS
  • Demonstrable experience with issue detection and resolution;
  • Working knowledge of backup and recovery procedures
  • Develop and maintain Cognos reporting, querying and analysis solutions.
Minimum Qualifications
  • 3 - 5+ years SQL Development on multiple DB Platforms (SQL Server, DB2, Oracle, Sybase, MySQL.
  • 3 - 5+ years' experience with Cognos version 9, 10 & 11.
  • MS Access and Excel reporting preferred.
  • Experience with Open Source solutions (BIRT, Talend, Jaspersoft, Pentaho), Data Modeling, SQL Server Reporting/Integration Service and AS400 (Client System i) environment a plus.
  • Education: Bachelor's degree and 5 years related experience. ITILv3 Foundations Certification
Desired Qualifications:
  • Previously worked for a federal civilian government agency
  • Previously worked in an O&M environment where ITIL best practices were employed
  • COGNOS Certification or related Microsoft certifications