Database Administration and Development Specialist

Brown and Caldwell has an exciting opportunity for a Database Administration and Development Specialist to join our Vancouver, British Columbia office. When you join Brown and Caldwell, you will find that we offer a non-hierarchical and collaborative work environment intended to support you in doing your best work. You will be trusted and supported to produce quality work by our project managers and given the flexibility to manage your efforts to achieve project objectives. The work we do is interesting, challenging, and impactful for the communities we live in.

The ideal candidate should have strong verbal and written communication skills, be highly organized and capable of working in a diverse team environment and handling multiple tasks with competing priorities.

Responsibilities

• Maintain SQL database containing EIC discipline data for efficient delivery of client standard documents.
• Maintain data connections between the CadWorks drawing files and the SQL database.
• Update SQL database as required to manage the development of the EIC drawings.
• Work closely with CAD drafter/designers.
• Generate output reports to meet client requirements (i.e., PLC I/O lists, data sheets, cable lists, etc.).
• Work with the project electrical engineers to leverage the power of the database to create design deliverables.
• Assist the project electrical engineers with adherence to client standards.
• Design customized Microsoft SQL Databases to meet Electrical and EIC design engineering.
• Select the appropriate toolsets to manage Data Flow.
• Use of Structured Analysis Methodology for design and documentation.
• Proficient in creating Data Flow Diagrams (Main tool of the Structured Analysis).
• Design, create, and test customized interfaces (data entry screens).
• Create user manuals for the customized interfaces developed.
• Lead code development.
• Supervised in-house software development.
• Support users with multiple software applications to ensure smooth integration.
• Supervise database performance.
• Troubleshoot software system issues.
• Perform scheduled machine backups, database backups and project backups.
• Extensive use of ETL (Extraction Transformation and Load) tools.
• Proficient with SSMS (SQL Server Management Studio), SSRS (SQL Server Reporting Services), and SSIS (SQL Server Integration Services).
• Performing daily T-SQL coding.
• Knowledge of AutoCAD data structures and their utilization in Metro Vancouver design requirements and standards.
• Proficient in the application of Metro Vancouver Standards in the design workflow.
• Develop SQL application outputs and reports to align with Metro Vancouver approved deliverables.
  
  

Required Qualifications

• Minimum of 15 years of experience with database design, implementation, and management.
• Associate’s degree (or higher) in computer science or computer engineering.
• Proficient with SSMS (SQL Server Management Studio), SSRS (SQL Server Reporting Services), and SSIS (SQL Server Integration Services).
• User experience with AutoCAD; proficient with data structures.
• Working knowledge of industrial electrical and control systems and their presentation on engineering documents such as drawings, data sheets, and lists.
  
  

Salary Range: The anticipated starting pay range for this position is based on the employee’s primary work location and may be more or less depending upon skills, experience, and education. These ranges may be modified in the future.

$110,000 - 150,000 CAD

You can view which BC location applies to you here. If you have any questions, please speak with your Recruiter.

Benefits and Other Compensation: We provide a comprehensive benefits package that promotes employee health, performance, and success which includes medical, dental, vision, short and long-term disability, life insurance, an employee assistance program, paid time off and parental leave, paid holidays, 401(k) retirement savings plan with employer match, performance-based bonus eligibility, employee referral bonuses, tuition reimbursement, pet insurance and long-term care insurance. Click here to see our full list of benefits.

About Brown And Caldwell

Headquartered in Walnut Creek, California, Brown and Caldwell is a full-service environmental engineering and construction firm with 50 offices and 2,100 professionals across North America and the Pacific. For 75 years, we have created leading-edge environmental solutions for municipalities, private industry, and government agencies. We strive to be the company of choice—to our clients, who benefit from our passion for delivering exceptional quality, and to our employees, present and future, who share our commitment to client service, collaboration, and innovation. Join us, and you will find a home where you can do your best work, reach new levels of expertise, and enjoy exceptional development opportunities. For more information, visit www.brownandcaldwell.com

Notice to Third Party Agencies: Brown and Caldwell does not accept unsolicited resumes from recruiters or employment agencies. In the event a recruiter or agency submits a resume or candidate without a previously signed agreement and approved engagement request with Brown and Caldwell, Brown and Caldwell reserves the right to pursue and hire those candidate(s) without any financial obligation to the recruiter or agency.