Joseph J. Albanese, Inc. is seeking a Database Developer responsible for designing, developing, and maintaining databases and applications that interact with them. The database developer works closely with other developers, analysts, and stakeholders to ensure that the data and functionality meet the business needs and specifications. The database developer also performs database administration tasks such as backup, recovery, migration, optimization, and security. Voted “Best Places to Work” for the past 5 years in a row, JJA is a dynamic, fun environment with significant career opportunities to further grow and develop professionally.

ESSENTIAL DUTIES & RESPONSIBILITIES:

• Analyze the data requirements and specifications of various projects and applications.
• Develop and test SQL queries, stored procedures, triggers, and functions for data manipulation and retrieval.
• Monitor and tune the performance, availability, security, and reliability of the databases and applications.
• Profile server resource usage and optimize and tweak per best practices.
• Perform data backup, recovery, migration, and integration tasks.
• Document and maintain the database structure, code, and processes.
• Provide technical support and guidance to other developers and users.
• Research and evaluate new database technologies and trends.
• Collaborate with other team members and stakeholders.

NOTE:These duties listed are meant to describe the general scope of the work. Other duties may be assigned based on business needs within the organization.

QUALIFICATIONS:

• Bachelor’s degree, preferably in Computer Science or Information Systems or equivalent experience
• 5 years of experience in designing, developing, and maintaining databases and applications.
• Ability to plan resource requirements from high-level specifications.
• Capable of troubleshooting common database issues.
• Excellent communication and documentation skills for presenting solutions to both technical and business audiences.
• Proficiency with MS SQL Server
• Ability to write and optimize in-application SQL statements.
• Skilled at optimizing large, complicated SQL statements.
• Design and maintain MS Reports (SSRS)
• Design and maintain MS Integration packages (SSIS)
• Job Scheduling and Monitoring
• Knowledgeable of SQL Linked Services and Replication
• Working knowledge of application development life cycle
• Working knowledge with Version Control Tools such as DevOps, Git, SVN
• Experience with MS Visual Studio and building Business Integrations (SSIS packages)
• Experience with building RESTful APIs through use of MS Visual Studio or other third-party application
• Working knowledge of Postman or Insomnia
• Knowledge of best practices when dealing with relational databases and application development.

OTHER:

• Working knowledge of HCSS Suite (Heavy Job, Heavy Bid, Dispatcher)
• Viewpoint Vista ERP
• SharePoint
• PowerShell
• MS Power Platform (Power Automate)
• C#
• Source Code Control
• Java Scripting
• Automation Development
• Experience with Crystal Reports
• ASPRunner

• General work environment – sitting for long periods, standing, walking, typing, bending.
• Occasional lifting of up to 25 lbs.

WHY JOIN JJA

Joseph J. Albanese is a family-owned construction business established and based in Santa Clara, California since 1955. With approximately 1000 employees the company has been instrumental in developing Silicon Valley by performing site / structural concrete, demo, grading, and paving for many of the outstanding projects in Northern California. Our core values of Safety, People, Quality, and Truth! JJA utilizes BIM and other cutting-edge technology to verify constructability and to communicate complex project geometries to field professionals. We offer competitive pay and benefits. See some of our highlighted projects on our website atwww.jjalbanese.com.

Joseph J. Albanese, Inc.provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.