What are the responsibilities and job description for the Database Developer position at Waste Connections?
Waste Connections is the premier provider of solid waste collection, transfer, recycling and disposal services, along with recycling and resource recovery, in mostly exclusive and secondary markets across the US and Canada. https : / / www.wasteconnections.com / about-us
This is a full-time expert level position at Waste Connections, Inc. located in The Woodlands, Texas. The position will be primarily responsible for management and support of our internal routing and billing application as well as integrating newly acquired company data. This position is a member of the Operations Applications Information Systems group and will be part of the Database Team.
Technology Requirements :
The following technologies are in production use with continual development requirements.
- Working with Microsoft SQL Stack e.g., SQL Server 2016 or higher, SSAS, SSIS, SSRS
- Transact SQL
- SQL Agent jobs
- Database Replication
- Database Administration
- SSRS and Crystal Reports
- Standardized reports as well as ad-hoc reporting in both SSRS and Crystal Reports.
- Tableau Report Writing
- DUTIES AND RESPONSIBILITIES
- SQL Server Development
- Writing SQL queries from scratch, must be very proficient in Transact SQL
- SSIS - take data from the old system, modify that data, and feed into the new system
- Use of data model concepts, master data management, operational process, SDLC, project management, data profiling, data cleansing / de-duplication processes.
- Use of SQL Server database, SQL Server Integration Services (SSIS), SQL Server analysis Services (SSAS), SQL Server Reporting Services (SSRS) and Azure Data platforms (Azure Data Factory, Azure Synapse, Azure Data Lakes, and Azure Databricks). Working with Microsoft SQL Stack e.g., SQL Server 2016 or higher, SSAS, SSIS, SSRS
- Data Analysis and Data Updates
- Live and Test database updates
- Create, update, and maintain Transact SQL scripts
- Create, update and maintain indexes, stored procedures, and triggers.
- Data Conversions
- Create scripts to migrate legacy data into our current routing and hauling software.
- Data migration with source database to target database mapping.
- Support
- Analyze data, provide solutions and support our existing customers.
- Database Administration
- Light administration such as performance monitoring, restores and backups.
- Working directly with the business clients.
- Extensive use of written and oral communication skills, particularly the ability to synthesize complex issues / scenarios into easy-to-understand concepts.
- Works closely with the business team, development team, analysis team, and the users to enhance quality and product delivered.
- Responsible for precisely communicating impact, status, priority, progress, and roadblocks to management
- Provides guidance in terms of priority and ownership of issues and requests.
EDUCATION / TECHNICAL EXPERTISE / EXPERIENCE
What's In It For You :
You will be joining a great team and a company in a "work hard, play harder" environment along with a competitive salary. We also offer excellent benefits including : medical, dental, vision, flexible spending account, long term disability, life insurance, 401K retirement and unlimited opportunities to "Connect with Your Future". Other peripheral benefits include a strong presence in our local communities, sustainability initiatives, and more. For more information and to apply, please visitwww.wasteconnections.com.
Waste Connections is an Affirmative Action / Equal Opportunity Employer (M / F / D / V.)
