Vacancy expired!
TECHNOGEN, Inc. is a Proven Leader in providing full IT Services, Software Development and Solutions for 15 years. TECHNOGEN is a Small & Woman Owned Minority Business with GSA Advantage Certification. We have offices in VA; MD & Offshore development centers in India. We have successfully executed 100+ projects for clients ranging from small business and non-profits to Fortune 50 companies and federal, state and local agencies. Hi, This is Reshita from TechnoGen Inc. Please check the below role and if you are interested then share your updated resume with contact information so that we can discuss more to move forward ASAP. Please reach me at 571-350-0469 or reshita.p@technogeninc.com. Also please provide if you have any references. Senior Database Analyst/Architect Senior DBA/Architect Contract End Date: Long Term On-site Flexibility: Hybrid Job Location full address: Carvel State Office Building, 820 N French St, Wilmington, DE 19801 Max Hours/Contract - 40 hours a week / 12-24 month contract /with possible extensions
- 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:
-
-
- 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:
-
-
- Required/Preferred Education:
- BS/MS degree in Computer Science, Engineering, or a related subject
- Required/Preferred Education:
Vacancy expired!