|
|
Sr. Database Developer
| Location: | Downtown, Toronto, Ontario, Canada |
|---|
| Job Type: | Permanent |
|---|
| Posted: | 13th Aug 2009 |
|---|
| Closing Date: | 10th Sep 2009 |
|---|
| Posted By: | Red Canary |
|---|
| Details: | |
|---|
Sr. Database Developer
About the Company
Headquartered in Toronto, this company develops and sells advanced data mining software and services to leading Fortune 500 organizations.
Over 300 clients, primarily in the financial services and information and communications technologies industries use this company to address their marketing, sales and credit risk analytics requirements.
This is not a maintenance role in the dimly lit corner of a suburban data warehouse. It’s a chance to work with very bright people in an organization where R&D is the lifeblood of the company.
The Opportunity
This company is the rarest of public-traded organizations – an R&D-focused company with a nimble development team that loves the ‘big idea’.
Working with recent releases of both Oracle and SQL, you’ll slice and dice massive pools of consumer data. Testing, troubleshooting, designing and developing business logic solutions for hot segments like Geospatial Data.
In addition to supporting and optimizing the Warehouses that house this data, you’ll work with 3rd party data providers to establish ETL processes for automated data load and production. You will also work closely with the development teams to support the schema design and implementation for data-centric applications.
Additionally, you’ll support system-level programs by gathering requirements from customers and Business Intelligence Analysts. This role calls for a multi-faceted database designer and developer.
If that’s you, you can expect challenges both wide and deep. Big projects. Complex projects.
This is not a maintenance role in the dimly lit corner of a suburban data warehouse. It’s a chance to work with very bright people in an organization that values you.
This company provides hosted services and next generation applications for interactive marketing, business intelligence, customer data integration and communications.
Key Responsibilities
* Designing, developing, managing and maintaining multiple internal data warehouses running on Oracle Database 10g, and Microsoft SQL Server 2005/2008.
* Testing and QA activities for daily ETLs and jobs, resolving data load issues on an on-going basis as well as carrying out pro-active testing and quality control activity to ensure data warehouse data integrity and quality is maintained.
* Designing, developing and maintaining existing PL/SQL code to implement business logic for multiple clients and carrying out one-time operational activities.
* Production support and maintenance of the Data Warehouse, working with other team members in optimizing system performance.
* Addressing operational issues to meet established Service Level Agreements for product delivery and support.
Who Should Apply
Specific Technology Skills
* Bachelors Degree required, preferably in Computer Science, or an equivalent combination of education and experience.
* Comprehensive knowledge of ETL, data modeling, schema development and ER diagramming
* Ability to perform complex PL/SQL and T-SQL tuning, troubleshooting database performance problems, and administer very large databases Experience with UNIX and Windows based operating systems
The work environment is very much run in ‘agency’ style
* Ability to develop shell scripts that carry out and schedule system ETL-related activities including file transfers and synchronization between multiple hosts, data import/export from flat files and data comparison and archiving.
Oracle
* 3-5 years of proven experience in Database and Data Warehouse design and development including Data Mart structures and Oracle PLSQL coding.
* Strong knowledge of ETL tools and strong experience with Oracle Warehouse Builder 10g Release 1 and Release 2, Oracle Enterprise Manager and Oracle Warehouse Builder Execution Manager.
* Thorough working knowledge of Oracle Database Servers 9i, 10g and 11g, PLSQL, Oracle Application Server with Portal and Oracle Discoverer.
SQL Server
* 3-5 years of experience with Microsoft SQL Server 2005/2008
* Proficient use of Integration Services and Reporting Services Desired Qualifications and Experience
* Strong knowledge of Java, C#, XML, and knowledge of .NET frameworks
* Experience with CRM and marketing data warehouse implementations.
* Experience providing support for disaster recovery exercises (or actual disaster recoveries).
* Experience with OLAP and Reporting tools.
* Familiarity with data mining and statistical or modeling packages and concepts Familiarity with GIS or spatial data design.
|
| |
| Sorry! This job is no longer active as the closing date for applications has passed. You can view other
vacancies from this company (if they have any) by clicking on their name above, alternatively we may have some suggestions
for similar vacancies listed below that might be of interest. |
| |
Featured External Adverts
|
|
|
|
 |
|
