Dieses Jobangebot ist archiviert und steht nicht mehr zur Verfügung.
Vakante Jobangebote finden Sie unter Projekte.

Software Database Engineer

Eingestellt von Zylog Systems (Canada) Ltd

Gesuchte Skills: Sql, Engineer, Client, Transact

Projektbeschreibung

Zylog delivers top jobs to top talent. We are currently seeking experienced professionals for exciting new opportunities and career advancement.

Zylog represents hundreds of client companies for both contract and permanent positions. New jobs are being filled every day and our experienced professional resource managers are waiting to help you screen the top jobs that match your skills and experience.

You don't have time to search long lists of postings repeated on multiple web sites, so let our trained and experienced resource managers do the work for you. We review top jobs and will be the first to alert you when the right opportunity arises.

About the Job

Our client has a requirement for a Software Database Engineer for a 4 Month Contract opportunity. The position is located in Vancouver, BC.

What makes this Special

Our client is one of the largest computer technology corporations in the world. They develop, manufacture, license, and support a wide range of software products for computing devices. Known for what is generally described as a developer-centric business culture, they are a worldwide leader in software, services and solutions that help people and businesses realize their full potential.

Role

Database Development Engineer partners with the Business Intelligence (BI) team in the design, development, and review of all database development activities. The engineer works closely with the BI team to ensure that the database is used optimally end to end from the data access from end users to the data feeds into the Datawarehouse.

Responsibilities

- Design database schemata based on data modelling of business requirements and entities.
- Document schema design in E-R diagrams using Erwin or other similar tools and maintain data dictionaries for all tables.
- Write new stored procedures, functions, views, triggers, constraints, etc.
- Code review SQL code and SSIS packages to ensure optimal performance and adherence to the best practices.
- Create deployment and rollback scripts for all database objects manually or auto-generated.
- Analyze access patterns and propose the best combination of indexes, constraints, foreign keys, and queries.
- Troubleshoot performance problems and propose short term fixes and long term solutions.
- Create SSIS packages for data transformation, cleansing, caching, aggregation, staging, and transfer.
- Create tabular and multi-dimensional models for SSAS.
- Create Self-serve SSAS cubes.
- Create Real Time reports from Azure Service Bus, StreamInsight and HDInsight using SSRS and PowerView or other tools
- Create OLAP reports using SSAS, SharePoint and Excel

Requirements or Qualifications

Qualified Candidates will have:

- Hands on SQL Server development experience.
- Expert knowledge of all aspects of SQL Server 2008/2012 Transact SQL and MDX
- Expert knowledge of SSAS.
- Extensive experience in SQL performance analysis and optimization (query plans, hints, perf tests, etc).
- Knowledge of SQL Server concurrency features, transactions, and locking.
- Excellent data modelling and schema design skills, including normalization and de-normalization.
- Strong experience with SQL Server debugging and tracing.
- In-depth knowledge and hands-on experience developing, deploying, and maintaining substantial SSIS packages.
- Full grasp of the pros and cons of table partitioning and distributed partitioned views.
- Basic SQL Server administration skills, such as backups, restores, taking and reverting snapshots, user/role security, access permissions, etc.
- Profound understanding of SQL Server high availability and disaster recovery technologies, such as backups and restores, log shipping, mirroring, and replication.
- Strong familiarity with data access technologies and protocols, such as ODBC, OLEDB, ADO.NET, LINQ to SQL, Entity Framework, JDBC, Hibernate/NHibernate, etc.
- Strong familiarity with BI technologies, such as ETL, data warehousing, SSAS/OLAP, data mining, and big data technologies.
- Strong familiarity with.NET, C#, and CLR objects.
- Experience using Visual Studio for Database Professional (2008 or 2010) to maintain source control and deployment scripts of all DB objects highly preferred.

KEYWORDS: Data Warehousing, Performance Tuning, SQL Server, Data Modeling, ETL, SSAS, SSIS

Projektdetails

  • Einsatzort:

    Vancouver, Kanada

  • Projektbeginn:

    asap

  • Projektdauer:

    4 month

  • Vertragsart:

    Contract

  • Berufserfahrung:

    Keine Angabe

Geforderte Qualifikationen

Zylog Systems (Canada) Ltd