SQL Database Administrator

Overview
The Database Administrator is responsible for configuring and customizing the SQL environment and facilitating connections between databases and internal systems according to the organization s specifications. Design, install, configure, and maintain database systems, including monitoring, optimizing, scripting, reporting, and troubleshooting issues. Provide a seamless flow of information by keeping the database running smoothly and maintaining API and middleware connectivity. Ensure data security and integrity, including implementation of access controls, backups, and recovery plans.
Duties and Responsibilities

• Oversee the development and maintenance of on-prem/cloud-based ERP database and Data Warehouse, including development and maintenance of related reports, forms, integrations, and workflows.
• Development, maintenance, and enhancements of cloud and on-prem connections, including SQL, PowerApps, Power BI.
• Experience with managing middleware/Boomi, API s, ETL s, stored procedures, scripting, and data integration.
• Knowledge of Azure DB connectivity, Synapse environment, Data Lake helpful.
• Analyzing business operations and systems to determine and improve application and user efficiency.
• Using & developing software applications consistent with business processes and procedures.
• Help create and document version change control and testing processes.
• Protects organization's value by keeping information safe, secured & confidential.
• Strong communication skills, team collaboration, mentoring.
• Work closely with other IT Team members, other IT functional stacks and corporate departments, divisions, and managers.
• Must be an advocate of safety and follow safety policies and procedures.

Work Experience

• Knowledge and experience of SaaS, SQL, Azure, Power App s/BI.
• Construction-related background is preferred.
• Helpful, if experienced with ERP (Vista by Viewpoint/Trimble), B2W Estimating and Ops by Trimble, Salesforce CRM, Boomi, middleware, Planful integration.
• Operates independently in a fast-paced team environment.
• On premise and cloud infrastructure experience.
• Highly organized with attention to detail.
• Priority customer support (internal/external).
• Able to work individually, part of a team and support other corporate departments.
• Ability to communicate effectively supporting companywide offices and end users
• Certifications in networking, MS SQL, MS Building Applications and Solutions, Azure, helpful.

Education

• A Bachelor s or Graduates degree in Computer Science or business information systems or relevant experience.
• Five plus year's industry experience or equivalent combination of education and experience in MS-SQL, middleware, API s and integration.