Software Engineer II

19 hours ago


Buffalo, NY, United States Syntricate Technologies Full time
Software Engineer II - Azure SQL Database Engineer
Buffalo, NY (Hybrid 3 days onsite/2 days remote)
12+-month contract
Web Cam Interview

$64-$74/Hr on W2

NOTES FROM MANAGER/REQUIRED SKILLS & EXP.:
  • We are seeking a highly skilled and experienced Azure SQL Database Engineer to manage, optimize, and secure our SQL databases hosted in Azure.
  • This role will be integral to supporting a new middleware application that facilitates data flow to/from a SaaS hosted application, ensuring high availability, performance, and data integrity.

Skill Set 1: Azure SQL Database (T-SQL, stored procs, schema design, TDE, Azure AD Auth)
Skill Set 2: Azure Networking, Managed Identities, Security
Skill Set 3: Database Design, Modeling, Performance tuning, optimization, query plan analysis, backup/restore

Software Engineer II - Azure SQL Database Engineer
  • We are seeking a highly skilled and experienced Azure SQL Database Engineer to manage, optimize, and secure our SQL databases hosted in Azure.
  • This role will be integral to supporting a new middleware application that facilitates data flow to/from a SaaS hosted application, ensuring high availability, performance, and data integrity.
Responsibilities:
  • Design, implement, and maintain Azure SQL Databases to support middleware and other applications.
  • Collaborate closely with Java middleware developers to optimize database interactions, queries, and schema designs for seamless integration and performance.
  • Monitor database performance, identify bottlenecks, and implement tuning strategies (indexing, query optimization, resource scaling).
  • Implement and manage database security, including user permissions, role-based access control, encryption (TDE), and network security.
  • Plan and execute database backup and recovery strategies, ensuring data resilience and business continuity.
  • Implement and manage high availability and disaster recovery solutions (e.g., Geo-replication, Availability Groups, Failover Groups).
  • Troubleshoot and resolve database-related issues, including connectivity, performance, and data corruption.
  • Automate database management tasks using Azure tools, PowerShell, or other scripting languages.
  • Ensure compliance with data governance, privacy, and security standards.
Essential Skills and Experience:
Azure SQL Database Expertise:
  • Strong hands-on experience with Azure SQL Database
  • Proficiency in T-SQL for complex queries, stored procedures, and schema design.
  • Experience in database performance tuning, optimization, and query plan analysis.
  • Experience with Azure SQL Database security features (TDE, Azure AD Authentication).
Azure Ecosystem & Integration:
  • Understanding of Azure Networking for secure database connectivity.
  • Experience using Managed Identities for secure application access for databases.
  • Familiarity with Azure Monitor for database monitoring and alerting.
Data Management:
  • Solid understanding of relational database design and data modeling.
  • Experience with database backup and restore procedures.
Collaboration & Problem-Solving:
  • Ability to work effectively with development teams.
  • Excellent analytical and troubleshooting skills for database issues.
EDUCATION AND EXPERIENCE REQUIRED:
  • Minimum of an Associate's degree and 5 years systems analysis/application development experience, or in lieu of a degree, a combined minimum of 7 years higher education and/or work experience, including a minimum of 5 years systems analysis/application development experience.
  • Familiar with application development software and hardware platforms.
  • Proficiency with personal computers as well as pertinent project management, word processing and spreadsheet software.
  • Capable of working on multiple projects of a complex nature.
  • Excellent problem-solving skills to assist in issue resolution.
  • Strong verbal and written communication skills, with prior experience presenting to the target audience.
  • Strong organizational and time management skills.
  • Detail-oriented.
  • Strong lateral thinking skills.
  • Experience coordinating between Applications and business units.
  • Experience recommending and implementing systems solutions.
  • Experience driving project milestones and delivery dates.
EDUCATION AND EXPERIENCE PREFERRED:
  • Good understanding of the Bank's application framework.
  • Subject matter expert in business with knowledge or experience utilizing application/system being supported.
  • Advanced understanding of applications supported with a sound knowledge of interfacing/integrated applications.
  • Ability to work in a team environment as well as autonomously.
  • Ability to multitask for various components of complex projects.
  • Action-oriented.
  • Pro-active.
  • Advanced knowledge and focus of the entire system to work on projects outside of normal business-as-usual (BAU).


  • Buffalo, NY, United States M&T Bank Full time

    Title: Software Engineer II Job Location: 465 Main Street, Buffalo, NY 14203 **Must be available to work off business hours and be On Call nights and weekends. Job Description: Contribute to team responsible for maintaining the M&T Equipment Finance Co. suite of applications; support and maintain software and web applications using C#, .Net, SQL Server and...


  • Buffalo, NY, United States M&T Bank Full time

    Title: Software Engineer II Job Location: 465 Main Street, Buffalo, NY 14203 **Must be available to work off business hours and be On Call nights and weekends. Job Description: Contribute to team responsible for maintaining the M&T Equipment Finance Co. suite of applications; support and maintain software and web applications using C#, .Net, SQL Server and...


  • Buffalo, NY, United States M&T Bank Full time

    Title: Software Engineer II Job Location: 465 Main Street, Buffalo, NY 14203 **Must be available to work off business hours and be On Call nights and weekends. Job Description: Contribute to team responsible for maintaining the M&T Equipment Finance Co. suite of applications; support and maintain software and web applications using C#, .Net, SQL Server and...


  • Buffalo, NY, United States Lighthouse Technology Services Full time

    Lighthouse Technology Services is partnering with our client to fill their .NET Software Engineer II position! This is a 12+ month contract opportunity based in Buffalo, NY and will be remote in the United States (working EST hours). This role will be a W2 employee of Lighthouse Technology Services. Position Overview: We're seeking a strong Software Engineer...


  • Buffalo, NY, United States Lighthouse Technology Services Full time

    Lighthouse Technology Services is partnering with our client to fill their .NET Software Engineer II position! This is a 12+ month contract opportunity based in Buffalo, NY and will be remote in the United States (working EST hours). This role will be a W2 employee of Lighthouse Technology Services. Position Overview: We're seeking a strong Software Engineer...


  • Buffalo, NY, United States Suncap Technology Full time

    Job Description Title: Software Engineer II Location: BUFFALO, NY (Remote) Duration: 6 months OVERVIEW: Provides designs, specifies information systems solutions and highly technical direction in the development of new or existing applications to solve basic to complex problems or enhancements. Serves as a principal application designer for major...

  • Software Engineer II

    2 weeks ago


    Buffalo, NY, United States Suncap Technology Full time

    Job Description Title: Software Engineer II Location: BUFFALO, NY (Remote) Duration: 6 months OVERVIEW: Provides designs, specifies information systems solutions and highly technical direction in the development of new or existing applications to solve basic to complex problems or enhancements. Serves as a principal application designer for major...


  • Buffalo, NY, United States Suncap Technology Full time

    Job Description Title: Software Engineer II Location: BUFFALO, NY (Remote) Duration: 6 months OVERVIEW: Provides designs, specifies information systems solutions and highly technical direction in the development of new or existing applications to solve basic to complex problems or enhancements. Serves as a principal application designer for major...


  • Buffalo, NY, United States AuditBoard Full time

    Join AuditBoard as a Senior Software Engineer II and play a pivotal role in our mission to enhance audit, risk, ESG, and InfoSec processes for over 50% of the Fortune 500. Our technology has propelled us to over $300M ARR, and we are recognized as a top-rated solution on review platforms. We are dedicated to innovation and collaboration, and we value the...

  • Software Engineer IV

    17 hours ago


    Buffalo, NY, United States Excellus BlueCross BlueShield Inc Full time

    Job Description: Summary: The Software Engineer is responsible for working on projects that are currently being visualized or developed by our organization. This role will be involved with the Software Development Life Cycle methodology and framework, directing software system validation and testing methods, as well as directing software programming...