SQL Server Database Administrator

Job Description

SQL Server Database Administrator (LOCAL CANDIDATES ONLY) - NYC, NY MOSTLY REMOTE

Location- Local candidates only from NY due to occasional onsite meetings- submit local here

Looking for at least 8 to 9 years of experience :

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

REQUIRED SKILLS :

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

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.

Feel free to reach me at gauravverma@kanakits.com