*Hybrid Contract Opportunity*
Lighthouse Technology Services is partnering with our client to fill their Azure SQL Database Engineer position! This is a 6+ month contract opportunity with potential extensions and will be hybrid in 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:
- 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.Â
Pay Range:Â $68-$83+/hr
Questions about any of our jobs? Email us at [email protected]
View all of our open jobs here: jobs.lhtservices.com