Vacancy expired!
- 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
- 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.
- 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
- Experience with MS-SQL Server
- Experience with creating interfaces using SQL Server Integration Services (SSIS) ETL Tool
- Experience with Microsoft Power BI
- BS/MS degree in Computer Science, Engineering, or a related subject
Vacancy expired!