Overview
Skills
Job Details
Job Title: Azure SQL Database Engineer
Location: Buffalo, NY
Hire Type : Contingent
Work Model: Hybrid (3 days a week at the office in Buffalo, NY)
No C2C or Sponsorship Available
Nature & Scope:
Positional Overview Are you a talented Azure Database Engineer looking to join an innovative and dynamic team? Look no further! We are excited to announce an exceptional opportunity at our client s company for a skilled 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. As part of their team, you will have the chance to work on impactful projects that push the boundaries of technology and make a real difference. We offer a collaborative and supportive work environment where creativity and innovation thrive. If you are ready to take your career to the next level and contribute to exciting projects, apply today and be part of their forward-thinking team!
Role & Responsibility:
Tasks That Will Lead To Your Success
- 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.
Skills & Experience:
Qualifications That Will Help You Thrive
- Minimum of an Associates 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.
- 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.