Software Engineer II

2 weeks 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

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

  • Software Engineer II

    2 weeks 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

    20 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

    3 days ago

    Buffalo, NY, United States Frontier Science Full time

    Do you enjoy programming? Are you interested in joining a team dedicated towards advancement in clinical trial research with public health? Frontier Science is looking for a Software Engineer to join their growing team to assist in the creation of software for the medical clinical trials industry. At Frontier Science, we value collaboration and innovation,...

  • Software Engineer

    1 week ago

    Buffalo, NY, United States Frontier Science Full time

    Do you enjoy programming? Are you interested in joining a team dedicated towards advancement in clinical trial research with public health? Frontier Science is looking for a Software Engineer to join their growing team to assist in the creation of software for the medical clinical trials industry. At Frontier Science, we value collaboration and innovation,...

  • Software Engineer

    22 hours ago

    Buffalo, NY, United States Frontier Science Full time

    Do you enjoy programming? Are you interested in joining a team dedicated towards advancement in clinical trial research with public health? Frontier Science is looking for a Software Engineer to join their growing team to assist in the creation of software for the medical clinical trials industry. At Frontier Science, we value collaboration and innovation,...

  • Software Engineer

    6 days ago

    Buffalo, NY, United States Frontier Science Full time

    Do you enjoy programming? Are you interested in joining a team dedicated towards advancement in clinical trial research with public health? Frontier Science is looking for a Software Engineer to join their growing team to assist in the creation of software for the medical clinical trials industry. At Frontier Science, we value collaboration and innovation,...

  • Software Engineer

    4 days ago

    Buffalo, NY, United States Frontier Science Full time

    Do you enjoy programming? Are you interested in joining a team dedicated towards advancement in clinical trial research with public health? Frontier Science is looking for a Software Engineer to join their growing team to assist in the creation of software for the medical clinical trials industry. At Frontier Science, we value collaboration and innovation,...

  • Software Engineer II

    2 days ago

    Buffalo, NY, United States Computer Task Group Full time

    Are you ready to join a growing team? CTG is seeking to fill a Software Engineer II opening for our client.Location: Buffalo, NY Duration: 12 months Overview: The Software Engineer II supports enterprise applications and systems with a focus on system administration, application support, and environment management rather than full-time software development....

  • Software Engineer II

    1 week ago

    Buffalo, NY, United States Computer Task Group Full time

    Are you ready to join a growing team? CTG is seeking to fill a Software Engineer II opening for our client.Location: Buffalo, NY Duration: 12 months Overview: The Software Engineer II supports enterprise applications and systems with a focus on system administration, application support, and environment management rather than full-time software development....