Job Details

ID #46448565
State Delaware
City Wilmington
Job type Contract
Salary USD Depends on Experience Depends on Experience
Source TRT
Showed 2022-10-14
Date 2022-10-04
Deadline 2022-12-02
Category Et cetera
Create resume

Senior DB Analyst/Architect - COGNOS

Delaware, Wilmington, 19801 Wilmington USA

Vacancy expired!

Senior Database Architect

High-level Position/Job Description:
  • Maintain a Cognos platform: perform software product upgrades, and support existing and create new Cognos reports based on business requirements
  • Create, maintain, and tune complex PL/SQL queries and stored procedures
  • Create and maintain existing SQL based custom reports
  • Maintain complex data models
  • Create and maintain interfaces between our on premise Oracle environment and MS SQL Server on the Azure based platform

Job Description:We are seeking a Senior Database Analyst/Architect who has strong Cognos developer experience and SQL experience. Additionally, the candidate should have a deep experience with Oracle databases deployed on a Linux platform, data warehouses, where retrieving and manipulating the housed data using ETL processing and complex SQL. The candidate should be able to quickly come up to speed on a complex database model, a database star schema architecture, and immediately contribute to development and/or support of Cognos reporting, complex SQL needs, business-requested reporting, extracts, loads, stored procedures, interfaces, ETL work, and an upcoming effort to upgrade our Oracle platform from Windows to Linux.This individual will be working with one of our government partners who is in the process of modernizing their platform. The current database platform will remain and be heavily used. The candidate will primarily support our current platform with the intent to eventually move to our new Azure based environment, where MS SQL Server is the current database platform.Working in a very dynamic and fast-moving environment, the candidate will need to leverage strong problem-solving and analytical skills, organizational abilities, and attention to detail. The candidate will work with the client and team members to gather and validate requirements, validate designs, and develop database application solutions.

Specific responsibilities may include:
  • Partner with existing team members to support a Cognos platform: perform software product upgrades, support existing and create new Cognos reports based on business requirements
  • Create, maintain, and tune complex PL/SQL queries and stored procedures
  • Quality reporting deliverables
  • Create and maintain existing SQL based custom reports
  • Maintain complex data models
  • Create and maintain interfaces between on-premise Oracle environment and MS SQL Server on the Azure based platform
  • Review and interpret ongoing business report and interface requirements
  • Strong analytical and troubleshooting skills. Analyze existing data structures and queries and develop/update reports, queries, data loads, and interfaces.
  • Accurately develop database queries, reports, data loads/extracts in a logical manner from scratch.

Required Skills and Experience:
  • 7 years of experience as a Senior Database Analyst/Architect
  • BS/MS degree in Computer Science, Engineering, or a related subject
  • 7 years of experience working on a Cognos platform doing reporting
  • Proven experience in upgrading a Cognos platform to new versions and/or other operating systems
  • A strong SQL developer who can quickly come up to speed on an existing and complex SQL Server database underlying a leading financial based COTS product
  • Extensive experience in all aspects of Oracle PL/SQL programming and query manipulation.
  • Some experience working with a SQL Server database
  • Extensive experience working with large sets of data and resolving data-oriented issues.
  • Extensive experience in tuning queries for optimal performance
  • Ability to work directly with business users to translate business reporting requests/requirements into a backend database design that clearly identifies database object impacts
  • Strong communication skills, both written and oral
  • Ability to investigate and identify query performance related issues
  • Critical thinker and problem-solving skills
  • Team player
  • Good time-management skills
  • Sense of ownership and pride in your performance and its impact on team’s success

Preferred Skills and Experience:
  • Experience with MS-SQL Server
  • Experience with creating interfaces using SQL Server Integration Services (SSIS) ETL Tool
  • Experience with Microsoft Power BI

Required/Preferred Education:
  • BS/MS degree in Computer Science, Engineering, or a related subject

Vacancy expired!

Subscribe Report job