Syntricate Technologies ยท 4 months ago
Azure SQL Database Engineer
Buffalo, NY
Full-time
Hybrid
Senior Level
$70/hr - $85/hr
5+ years expSyntricate Technologies is seeking a highly skilled Azure SQL Database Engineer to manage, optimize, and secure SQL databases hosted in Azure. This role will support a new middleware application, ensuring high availability, performance, and data integrity.
Information TechnologyProject ManagementQuality Assurance
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
Qualification
Required
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)
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
Solid understanding of relational database design and data modeling
Experience with database backup and restore procedures
Ability to work effectively with development teams
Excellent analytical and troubleshooting skills for database issues
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
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)
Company
Syntricate Technologies
Syntricate Technologies offers quality assurance, validation, regulatory, business analysis, and project management services.
51-200 employees
H1B Sponsorship
Syntricate Technologies has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2024 (2)
Funding
Current Stage
Growth StageCompany data provided by crunchbase