Job Description
Charger logistics Inc. is a world- class asset-based carrier with locations across North America. With over 20 years of experience providing the best logistics solutions, Charger logistics has transformed into a world-class transport provider and continue to grow.
“Experienced SQL Developer" is needed at our Brampton,ON office with exceptional collaboration, listening, presentation, written and verbal communication skills.”
Job responsibilities:
- Manage and maintain all development, test, and production databases under general supervision.
- Assist in the design, creation, and maintenance of MS-SQL databases.
- Develop and support standards and database design, as well as maintenance, access, and security administration.
- Provide database quality control and auditing to ensure accurate and appropriate use of data.
- Perform backup and recovery on Database Management Systems (DBMS).
- Possess the ability to optimize database access and allocate/reallocate database resources for optimum configuration, database performance, and cost.
- Required to be on-call for database support on a scheduled basis
- Contributes to the strategic direction of the function and advises senior management on issues as they pertain to larger organizational issues/business initiatives.
- Prepares system documentation and maintains security, integrity, and business continuity controls and documents.
Requirements:
- 3+ years of practical SQL development experience.
- ETL tools such as Azure Data Factory will be an asset. Cloud experience will be an asset.
- Solid knowledge of database design to produce sound logical and physical data models.
- Experience with SQL 20162017, replication (including merge), table partitioning, Clustering, Always on, DR setup. Experience with SQL 2017
- Experience with PowerShell, troubleshooting all types of ETL issues, text file formats.
- Microsoft Azure, Google Cloud, Azure SQL Database (Singleton, Hyperscale, Managed Instance, PAAS, IAAS), AzureKey Vault, Blob Storage, Azure file Storage, Azure Monitoring Tools.
- Experience with varied forms of data design, such as online transaction processing, online analytical processing, data warehousing, operational data stores, and decision support systems
- Knowledge of SQL, scripting and other coding techniques to code scripts, stored procedures and triggers.
- Knowledge of IP addressing and port.
Benefits:
- Competitive Salary
- Healthcare Benefit Package
- Career Growth