Must have 7 years of experience in each of the following: Administrating and managing best practices for SQL Server; Writing complex SQL, including stored procedures, triggers, agent jobs, and maintenance scripts; Administrating large databases greater than ten terabytes; Working with cloud-based database solutions; Working with SQL Server features (SSRS, SSIS, and replication) to determine which are most suited in various scenarios to address technical and business needs; Troubleshooting and resolving database problems involving a diverse portfolio of technologies, applications, sites, vendors, and customers in mid and large cap companies; Conducting in-depth evaluations, diagnosing, troubleshooting and resolving complex technical issues; Working with backups, restores, various recovery models, and backup and restore strategies; Conducting Performance Tuning and Optimization (PTO) while using native monitoring, custom scripts, and 3rd party tools; and. Our portfolio of brands includes Oldcastle APG, Oldcastle Infrastructure, Belgard hardscape, Echelon Masonry, RDI railing, Catalyst Fence Solutions, Sakrete packaged concrete, Amerimix mortar, Pebble Technology International pool finishes, and Techniseal sands and sealant technologies.