SQL Architect

Key Job Responsibilities:

• Perform day-to-day operations (includes monitoring and maintenance, problem investigation and resolution, database optimization and tuning, etc.).
• Analyze existing SQL queries for performance improvements.
• Development of high-quality database solutions
• Develop, implement, and optimize stored procedures and functions using SQL.
• Analyze existing SQL queries for performance improvements.
• Independently analyze and correct issues in real time, providing end-to-end problem resolution.
• Evaluate business data and recommend appropriate analytic approaches/strategies to achieve stated objectives.
• Establish best practices for SQL Developers.
• Apply data modeling techniques to ensure integration and performance expectations are met as well as allow for future flexibility to meet changing business needs.
• Strong software development skills in detailed application design, database design, object-oriented concepts, and Abstraction/Dependency Injection patterns
• Strong Experience in integrating with integration software such as MuleSoft, AWS API Management, Rest API, or equivalent middleware solutions.
• Strong knowledge of relational database concepts, SQL queries, NoSQL
• Experience with Draw.IO or other design tools
• Strong focus on testing during development
• Experience with CI/CD
• Experience with JIRA or some comparable tool
• Focus on customer experience and build product features that delight users.
• Passionate about exploring new technologies.
• Knowledge of application server configurations, memory/connection management 20. Strong problem-solving skills and the ability to make sound technical decisions.
• Excellent communication skills at all levels. Proven ability to lead and communicate orally, in written documents, and in formal presentations is required.

Job Requirements:

• Architect, build and deliver products that delight customers with scalable and maintainable code under the hood.
• Be responsible for the design, implementation, unit testing, performance and monitoring of the team s solutions.
• Proven expertise at consuming REST services and dealing with error cases.
• Ensure consistent process and provide technical guidance during business requirements and specifications development phases.
• Provide oversight, assistance, and guidance to development of the application security architecture supporting the applications.
• Should be comfortable with direct communication with all levels of technical and business resources.
• Responsible for ensuring quality through design reviews, code reviews and development of standards.
• Serve as a mentor to team members by demonstrating alternate techniques, reviewing code, and strengthening skills.
• Must be able to interact well with multiple priorities in an extremely dynamic environment, initiating necessary tasks and ensuring complete follow up.
• Researches and recommends appropriate application development best practices, and tools.
• Develop new functionality on our existing software products and Provide development support and assistance for escalations and issues.
• Strong Experience in integration of multiple systems
• All other responsibilities as assigned.
• Follow Company policies and practices while representing Our ethical and business-like manner in all interactions with employees, governmental agencies, growers, customers, etc.
• Ensure the security of Our confidential and proprietary information and materials.
• This job description is intended to describe the general nature of the work performed by employees in this job. It is not an exhaustive list of all the job's responsibilities. All our jobs include broad responsibilities for continually improving the processes we use to develop our products.
• California driver s license and the ability to be covered under company-sponsored vehicle insurance program.
• Strategic Mindset: Looks toward the future and designs a way to get there.
• Cultivates Innovation: Finds, champions, and implements innovations; large or small.
• Plans & Aligns: Establishes priorities and desired outcomes and creates plans to achieve them.
• Drives Results: Pursues everything with energy, resourcefulness, and the need to achieve desired outcomes.
• Collaborates: Works with a variety of colleagues, inside and/or outside of Our s, seeking win-wins solutions.
• Drives Engagement: Creates a motivating work environment and empowers others.
• Develops Talent: Actively seeks opportunities to develop oneself and others.
• Courage: Tackles difficult issues timely with optimism and transparency.