Senior SQL Database Architect and Development Team Lead

About Aayla Solutions

At Aayla Solutions, we specialize in empowering construction companies with cutting-edge technology solutions. Our commitment extends beyond erecting structures; we are dedicated to constructing a future where innovation and efficiency define the success of your projects. With years of expertise, our profound understanding of Vista by Viewpoint speaks volumes, consistently surpassing client expectations and setting a new standard in customer satisfaction and technical proficiency.

About Aayla Technology Department

At the Aayla Technology Department, we are at the forefront of integrating sophisticated technology solutions within the construction and financial sectors, harnessing the power of SQL for robust database management, SSRS (SQL Server Reporting Services) and Crystal Reports for advanced reporting, alongside Vista by Viewpoint, a premier Construction ERP system tailored for the industry. Our teams expertise spans developing, managing, and optimizing these technologies to streamline operations, enhance project management, and improve profitability. By combining SQL databases with the analytical capabilities of SSRS and Crystal Reports, and leveraging the comprehensive features of Vista by Viewpoint, we offer seamless, unified platforms that address the full spectrum of construction project management needs. Our commitment to innovation, coupled with an agile approach, ensures we deliver practical, efficient, and scalable technology solutions that propel our clients towards operational excellence and competitive advantage in their respective markets.

About Technology Department Team Leader

The Technology Department Team Leader at Aayla Solutions is a master of SQL and SQL-related technologies, expertly navigating and resolving complex database challenges to drive forward the companys technology solutions. This individual stands at the helm of a talented team, focusing primarily on optimizing SQL database management, enhancing performance through SSRS, and leveraging the full capabilities of Construction ERP systems like Vista by Viewpoint. With a keen eye for identifying and solving intricate SQL problems, the Team Leader ensures that the integration and management of these technologies are seamless, scalable, and perfectly aligned with the needs of the construction and financial sectors. The Technology Department Team Leader at Aayla Solutions acquires deep technological expertise, adeptly steering the team toward cutting-edge solutions in SQL databases, SSRS, Crystal Reports, and Construction ERP systems like Vista by Viewpoint. Balancing technical acumen with exceptional managerial skills, the Team Leader fosters an environment of professional growth and innovation, aligning team efforts with the overarching goals of Aayla Solutions to drive the company forward in a competitive technology landscape.

Job Type and Work Arrangement

• This position is offered as a remote contract, allowing for flexibility and the ability to work from any location.with the requirement to be available during the Australian time. zone from 8:00 AM to 5:00 PM.

• The role operates on an hourly basis, providing the flexibility to accommodate various scheduling needs and project demands.

Equal Opportunity Employment

Aayla Solutions is committed to fostering a diverse and inclusive workplace. We believe that diversity enriches our performance and products. Therefore, we offer equal employment opportunities based on skills and qualifications, without regard to geographical location, ethnic background, or religious beliefs. We encourage candidates from all backgrounds to apply, as we value the unique perspectives and experiences that each individual brings to our team.

Key Responsibilities:

SQL Expertise and Database Management

• Design and manage complex SQL queries, stored procedures, views, and functions to support data analysis, reporting, and business intelligence, optimizing query performance and ensuring data integrity.

• Architect scalable and robust database schemas to support business data requirements, utilizing extensive SQL experience for efficient database structures.

• Apply expertise in SQL performance tuning to optimize database operations and enhance data retrieval and manipulation speed.

• Implement SQL database security measures, including robust access controls, encryption, and auditing policies, to protect sensitive data.

• Lead data migration and integration projects, ensuring seamless data transfers and accurate data consolidation with extensive SQL expertise.

• Develop strategies utilizing SQL expertise to ensure business continuity, including robust backup procedures and data replication.

• Manage SQL databases across various platforms (e.g., Microsoft SQL Server, MySQL, PostgreSQL), ensuring consistent performance and data integrity.

• Develop bespoke SQL solutions to address unique business challenges, enhancing operational efficiency and decision-making capabilities.

• Create comprehensive documentation for SQL database architectures, coding standards, data models, and reporting protocols to ensure consistency and clarity across technical projects.

Reporting, Analysis, and ERP Integration

• Utilize SSRS, Crystal Reports, and other tools to create and optimize reports, delivering actionable insights and meeting stakeholder needs.

• Optimize the integration of Construction ERPs, like Vista by Viewpoint, ensuring seamless data flow and efficiency across business processes.

Leadership, Strategy, and Innovation

• Lead and develop a team of SQL developers and database professionals, fostering a culture of innovation and continuous improvement.

• Align database and reporting projects with business objectives, ensuring timely delivery within scope and budget.

• Contribute to strategic planning, focusing on SQL technologies, reporting tools, and ERP systems to support business goals.

• Stay updated on SQL database technologies and ERP systems, implementing innovative practices to enhance departmental efficiency.

• Lead the development of best practices, guidelines, and procedures for database management, reporting solutions, and ERP system integration, facilitating knowledge sharing and continuity within the team.

• 
  

Quality Assurance, Support, and Communication

• Maintain quality assurance processes for database operations and reports, ensuring data governance and security compliance.

• Provide expert advice and support on SQL database management, reporting, and ERP system integration.

• Share SQL knowledge by training and mentoring team members, developing training programs to elevate SQL capabilities.

• Maintain effective communication with stakeholders, understanding their needs and delivering updates on database and reporting services.

• Maintain up-to-date records of system configurations, data dictionaries, and integration mappings to support database administration, disaster recovery planning, and compliance audits, enhancing organizational knowledge and operational resilience.

Qualifications:

• Bachelor's or Master's degree in Computer Science, Information Technology, Data Science, or a related field, emphasizing database management, software development, or data analytics.

• Minimum of 5 years of hands-on experience in SQL database development, management, and optimization, including extensive work with SQL Server, MySQL, PostgreSQL, or similar RDBMS. Demonstrated experience in leading data migration, integration projects, and database security implementations.

• Advanced knowledge of SQL and proficiency in database architecture design, performance tuning, and optimization. Experience with reporting and analytics tools such as SSRS and Crystal Reports, and familiarity with ERP systems like Vista by Viewpoint.

• Certifications in SQL database management, Microsoft SQL Server, MySQL, or similar technologies are highly regarded. Additional certifications in project management or related areas can be beneficial.