SQL Developer

SQL DeveloperClient: ViaviLocation: Santa Rosa Onsite required. Open to someone who will relocate to Santa Rosa on their own expenses.Remote Till Covid.Duration of Assignment: 6+ months (possibility of conversion)Team: Business Information Systems TeamReason for hire: Backfilling someone retiring in December 2021, want 6-7 months of transition time.Job Description: SQL server development and works on Lotus Notes.REQUIRED SKILLSMicrosoft SQL Server 2016 or higher – 10+ years• Query creation and optimization• Relational Database Design and Data Normalization• View creation• TSQL – Transact SQL Language• Stored Procedures• Server Administration• Automated Tasks• MS SQL Data Warehouse Development• SSIS – SQL Server Integration Services• SSRS – SQL Server Reporting ServicesMicrosoft C# / .NET Application Development – 10+ yearsMicrosoft Windows 7, 10General User Support for Application Trouble Shooting, Share Access, Application Access, User Training, etc.Develop and Maintain Technical DocumentationTo confirm to U.S. Government Industry regulations, applicant , lawful permanent resident of the U.S., protected individual as defined by ITAR (22 CFR§120.15) or eligible to obtain the required authorizations from the U.S. Department of State.OPTIONAL SKILLSMicrosoft Access Application DevelopmentVIAVI Environmental Application (Access Front End / MS SQL Server Back End)IBM Notes / Lotus Notes• Application Development• User SupportZEBRA Label Printer Support and Programming (ZPL)• GX430 Desktop Series Printers• ZT410/411 Industrial Series Printers• Application Programming using C# and ZPLBartender Application (Seagull Scientific Software)• User Support• Site License ManagementCAMSTAR MES (Management Execution System)TABLEAU Reporting System Report DevelopmentORACLE SQLORACLE EBS