Job Description

CTG is seeking to fill an Azure SQL Database Engineer opening for our client in Buffalo, NY.

Location: Buffalo, NY - onsite 3 days a week

Duration: 6 months with extension

No C2C please.

W2 only. Should be eligible to work for any employer.

Top Skills:

• Azure SQL Database (T-SQL, Stored Procs, Schema Design, TDE, Azure AD Auth)
• Azure Networking, Managed Identities, Security
• Database Design, Modelling, Performance tuning, Optimization, Query Plan Analysis, Backup/Restore

Overview:

Provides designs, specifies information systems solutions and the highest level technical direction in the development of new or existing applications to solve basic to complex problems or enhancements. Serves as a principal application designer for critical components and major modifications effectively using analytical and technical skills, available technology and tools in the evaluation of client requirements and processes. Provides solutions that are technologically sound. Often directs and monitors the activities of less experienced personnel.

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.
• 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
• Implement and manage high availability and disaster recovery solutions
• 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 DB
• 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

Education and Experience Required:

• Minimum of an Associates degree and 6 years systems analysis/application development experience, or in lieu of a degree, a combined minimum of 8 years higher education and/or work experience, including a minimum of 6 years systems analysis/application development experience

Excellent verbal and written English communication skills and the ability to interact professionally with a diverse group are required.

CTG does not accept unsolicited resumes from headhunters, recruitment agencies, or fee-based recruitment services for this role.

Job Tags

Similar Jobs