Database AdministratorWe are offering an exciting opportunity for a Database Administrator in the construction/contracting industry, located in Avon, Minnesota, 56310, United States. In this role, you will be responsible for the deployment, administration, maintenance, and technical support for all database environments. You will work closely with development teams and senior architects to implement hybrid cloud and cloud-native solutions.<br><br>Responsibilities:<br>• Handle the deployment, administration, and maintenance of database environments<br>• Investigate and resolve operational or systematic problems using advanced analytical skills and tools<br>• Analyze database performance issues and recommend tuning changes to improve performance<br>• Collaborate with development teams and senior architects to design and implement hybrid cloud and cloud native solutions using Azure infrastructure, platform and software as a service (IaaS, PaaS, SaaS) offerings<br>• Work with Identity & Access Team to maintain database security and provide access<br>• Participate in the design, implementation, security, and support of SQL Server & Azure SQL workloads<br>• Assist with environment/database refreshes and troubleshoot application database connectivity, SQL server issues, query performance, SQL HA/DR (i.e. SQL cluster, Always On, Log Shipping, DB replication) and other issues in production and development<br>• Monitor and maintain database security & perform DB user/service account administration<br>• Monitor overall SQL system health, database performance and perform schema review following best practices<br>• Handle database software and server installation, migrations, configuration, and management<br>• Assist with the installation of changes to database software, service packs and hot fixes as needed<br>• Conduct database backups, restores, consolidation and reorganization<br>• Optimize and tune database systems to maximize their performance and operation<br>• Define and improve the overall release process for database systems<br>• Monitor and support existing product and custom developed databases<br>• Troubleshoot production support issues post-deployment and come up with solutions as required<br>• Write T-SQL code and stored procedures to monitor, automate and support DBA tasks<br>• Provide code review and offer suggestions for improvements to T-SQL code and stored procedures.Accounts Payable Specialist<p>We are offering a long term contract employment opportunity, with potential for hire, for an Accounts Payable Specialist. The role involves collaborating with different departments to establish clear Accounts Payable procedures as well as providing training and guidance for the Accounts Payable team. </p><p><br></p><p>Responsibilities:</p><p>• Validate and input vendor invoices into the JD Edwards ERP system AP module to ensure prompt payments.</p><p>• Coordinate approval and general ledger coding for non-PO invoices.</p><p>• Review and audit employee expense reports in accordance with company guidelines.</p><p>• Liaise with vendors and internal teams to facilitate resolution of missing invoices and late payment issues.</p><p>• Organize check, ACH, and virtual card payment batches for vendor invoices and employee expense reports.</p><p>• Reconcile vendor statements and ensure discrepancies are resolved.</p><p>• Ensure the validation of US vendor W-9 data within the IRS TIN Matching application.</p><p>• Identify vendors eligible for 1099-NEC or 1099-MISC reporting based on W-9 information and payments made.</p><p>• Check Purchase Order (PO) invoices through the three-way match process.</p><p>• Validate annual 1099 reporting data and review W-8 forms received from non-US vendors</p>