Senior Backend .NET Developer

Aspire IT Solutions is in a need of -

Role: Senior Backend .NET Developer
Location: Berkeley/Oakland/Richmond/San Jose, CA (Onsite)
Duration: long term contract

Job Description:
Our client is seeking a bright, imaginative, and capable technologist specifically seeking a smaller and dynamic environment where their potential will be maximized through the challenging projects that the group acquires. The ideal candidate will have a modern backend focus with strong experience in ASP.NET Core and C#, along with deep hands-on expertise in database development and administration.

Scope of Responsibilities

• Perform SQL Server and Oracle database administrative tasks across multiple environments
• Design, develop, and support applications using Microsoft .NET technologies
• Manage and support multiple projects and competing deadlines
• Document existing solutions and identify urgent fixes or upgrade needs
• Collaborate with multiple development teams on database design, performance tuning, and SQL best practices
• Write complex SQL queries, stored procedures, and ETL processes
• Perform ETL development and management
• Hands-on programming with SQL Server and Oracle databases
• Support data architecture initiatives
• Work with Linux/UNIX environments and shell scripting
• Exposure to or experience with AI technologies is a plus

Required Skills

• Full SDLC experience: analysis, design, development, testing, deployment, and support
• Ability to design, develop, and maintain small to large-scale databases
• Strong expertise in Transact-SQL, MS SQL Server, and MySQL
• Advanced experience with:
  • Stored procedures
  • User/authentication management
  • Performance tuning
  • Linked servers
  • ETL processes
  • SSRS and SSIS
• Strong experience with Microsoft .NET technologies including ASP.NET and ADO.NET
• Python development experience
• Ability to manage multiple projects and deadlines simultaneously
• Strong communication skills with developers, business users, and project managers
• Experience creating technical documentation and user guides
• Project management skills are a plus
• Experience creating and maintaining ETL jobs

Qualifications & Experience

• 7 10 years of professional experience
• Databases: SQL Server and Oracle (DB2 is a plus)
• Experience configuring and managing web application database connections
• 5 8+ years of backend development with SQL Server, stored procedures, and T-SQL
• Strong experience with:
  • Authentication and authorization
  • Performance tuning
  • Linked servers
  • ETL
  • SSRS and SSIS
• Development experience with Microsoft .NET technologies including ASP.NET and ADO.NET
• Programming languages: VB.NET, C#, SQL/T-SQL, JavaScript/DHTML, VBScript, HTML, XML
• Frameworks & Tools: ASP.NET MVC, ASP.NET Core, C#, VB.NET, Python
• Operating Systems: Windows and Linux (shell scripting experience preferred)