Job Description
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 Database Administrator is needed at our Monterey, MX office with exceptional collaboration, listening, presentation, written and verbal communication skills.”
Job responsibilities:
- Designs, develops, implements, and installs defined Microsoft SQL Sever database systems and maintains enterprise level database systems in a multi server environment.
- Develop and support standards and database design, as well as maintenance, access, and security administration
- Create, maintain, and optimize stored procedures, functions, inline SQL, database structures, and ETL processes to adapt to changes in needs and requirements
- Design, document, implement, validate, and maintain organizational strategies for database backups, security, high availability, and disaster recovery
- Solid knowledge of database design to produce sound logical and physical data models
- Knowledge of SQL, scripting and other coding techniques to code scripts, stored procedures and triggers
- Perform backup and recovery on Database Management Systems (DBMS)
- Configure database parameters and design prototype logical data models, as well as define data repository requirements, data dictionaries, and warehouse requirements
- Conceptualizes, designs, constructs, tests and implements business and technical IT solutions through application of appropriate software development life cycle methodology
- Contributes to the strategic direction of the function and advises senior management on issues as they pertain to larger organizational issues/business initiatives
- Create backup/recovery utilities according to defined standards
- Code and implement stored procedures and triggers in Microsoft SQL Server
Requirements:
- Must have 10+ years of hand-on experience in Database administration in SQL server
- 5+ years of practical DBA and SQL experience
- ETL tools such as Azure Data Factory will be an asset
- Extensive experience with troubleshooting database performance issues & SQL performance tuning
- 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 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
- Experience in troubleshooting all types of ETL issues
- Experience with text file formats
- Ability to write custom scripts using shell scripts
- Knowledge of IP addressing and ports
Benefits:
- Savings fund
- Life insurance
- Healthcare Benefit Package
- Food coupons
- Career growth
- High competitive salary
- Performance-based bonus and Christmas bonus.
- Christmas Loyalty Bonus