Role:Senior Database Analyst /Wilmington, DE (Hybrid)/must have 10+years of experience
M RANJITH
Hi,
Greetings for the day!!!
This is #Ranjith . We have an immediate opportunity with one of our clients. Please find the job description below, and if you are interested, please forward your updated resume to # ran...@interaslabs.com
Role: Senior Database Analyst/Architect
Wilmington, DE (Hybrid)
Duration: Long Term Contract
Must have 10+years of experience
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
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