Software Engineer II

2 days 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).

  • Software Engineer II

    14 hours ago

    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...

  • Software Engineer II

    11 hours ago

    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...

  • Software Engineer II

    2 days ago

    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...

  • .NET Software Engineer II

    6 days ago

    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...

  • .NET Software Engineer II

    2 days ago

    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...

  • Software Engineer II

    16 hours 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...

  • 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...

  • Software Engineer II

    1 week 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...

  • Software Engineer II

    4 days 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...

  • Senior Software Engineer II

    4 days ago

    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...