SQL Server Database Administrator (DBA)

Hello Hello

a new requirement from the MTA

12 months

Local to New York City

Rate: 50.00 an hour c2c

:

*PLEASE NOTE THIS POSITION WILL ALLOW CONSULTANT TO WORK REMOTELY. HOWEVER AS A Database Administration DUTIES WILL OCCASSIONALLY NESSITATE CONSULTANT TO WORK ONSITE. THEREFORE, WILL BE CRITICAL FOR THE CONSULTANT TO BE LOCAL TO NYC AND ABLE TO TRAVEL TO OUR OFFICE WITHOUT ISSUE AS NEEDED (AT THEIR OWN EXPENSE).*

Responsibilities:

• Design, implement, and maintain Microsoft SQL Server and Azure Managed Instance databases.

• Perform SQL server, database installations, upgrades, patches and migrations.

• Troubleshoot and remediate database-related issues.

• Ensure database security and compliance.

• Monitor performance and provide ongoing tuning of databases

• Optimize SQL database performance and query tuning.

• Develop and implement database backup and recovery strategies.

• Collaborate with application development teams to support database requirements.

• Stay up-to-date with the latest Microsoft SQL Server and Microsoft Azure technologies and best practices.

• Develop and maintain procedures, best practices and standards documentation

• Perform other duties as assigned.

• Participate in on-call.

• 5+ years of hands-on experience as a SQL Server Database Administrator.

• Experience in designing, implementing, and maintaining Microsoft SQL Server on-prem and in cloud.

• Experience implementing High Availability (Always-on).

• Experience with all aspects of database administration including database installations, upgrades, migrations, backup and recovery, performance and query tuning, database security

• Expert knowledge in Windows Server, SQL Server, Azure cloud platform and specifically SQL. Managed Instance, Azure Storage account and Azure security fundamental.

• Strong Knowledge of SQL. Knowledge of Python is preferred.

• Strong problem-solving skills with a focus on logical troubleshooting.

• Certifications in Microsoft technologies are preferred

• Bachelor's degree in computer science or a related discipline, and three years or more of related full-time, paid experience as SQL Server administrator.

• Strong initiative and leadership skills, strong work ethic, responsibility and dedication

• Ability to work independently, as well as in a team environment Strong verbal and writing skills