*Hybrid Contract Opportunity*

Lighthouse Technology Services is partnering with our client to fill their Azure SQL Database Engineer position! This is a 12+ month contract opportunity and will be hybrid in downtown Buffalo, NY. This role will be a W2 employee of Lighthouse Technology Services.

What You'll Be Doing:

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

What You'll Need to Have:

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

Pay Range: $55-$70/hr +

Questions about any of our jobs? Email us at recruiting@lhtservices.com

View all of our open jobs here: jobs.lhtservices.com