SQL DBA/Developer

SQL DBA/Developer

The SQL Database Administrator is responsible for the design, management and optimization of the production database. Drawing on excellent database architecture and analytical skills, the Database Administrator enables BuildDirect's success by ensuring database performance and resilience.

Responsibilities:

  • Coordinate, analyze, design, implement, and administer database solutions
  • Ensure availability and performance of the databases that support BuildDirect's systems
  • Ensure hardware resources allocated to the databases provide high resilience and performance
  • Proactively monitor the database systems to ensure secure services with minimum downtime
  • SQL Development - ability to write and troubleshoot SQL Code and design (stored procedures, functions, tables, views, triggers, indexes, constraints)
  • Assist in database design and architecture
  • Recommend best practices for improvements to current operational processes and procedures
  • Assist Data Warehouse Analyst
  • Collaborate with existing DBA on recommendations for optimal design and performance solutions
  • Collect and analyze database performance information; identifying and implementing solutions for improvement

Expected Outcomes:

  • Develop a thorough understanding of current data architecture
  • Provide recommendations for scaling the data architecture
  • Apply industry best practices in one area that improves data performance

Desired Skills & Experience:

  • Proven experience in database development, database administration and data architecture
  • Experience with highly available architectures such as clustering, mirroring, replication and AlwaysOn of MS SQL Server
  • Demonstrated experience in troubleshooting and resolving issues with database integrity, performance, blocking and deadlocking, replication, log shipping, connectivity, and security
  • Skilled in Performance Tuning and Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools
  • In depth knowledge of database design, optimization, and normalization techniques
  • Working experience with Database Cloud an asset


    Date Posted:
    May 12, 2014 12:33 PM PDT
    Company:
    BuildDirect
    Website:
    http://newsroom.builddirect.com/work-at-builddirect/

    Company:
    BuildDirect
    Website:
    http://www.builddirect.com
    Location:
    Vancouver, British Columbia, Canada

    Founded in 1999, BuildDirect is an e-commerce provider completely disrupting the retail building products industry by bridging the gap between the manufacturer and end user. By simplifying the supply chain, solving a heavy freight shipping issue that plagued the industry and creating a proprietary data-driven platform that benefits manufacturers, partners and customers alike, BuildDirect customers ultimately enjoy... more