Senior SQL Server DBA Architect – Azure – Contract role

Tech Mirrors; New York (NY); Hybrid; USD 120,000 - 150,000; Part time

Benefits offered by this job

Hybrid work model

On-site support in NYC

Job summary

Tech Mirrors in New York, NY seeks a Senior SQL Server DBA Architect - Azure to design, implement, and maintain SQL Server and Azure Managed Instance databases. This contract role requires 12+ years of hands-on experience and a hybrid work setup with 3 days on site in NYC and 2 days remote.

You will collaborate with infrastructure and development teams on patching, security, backups, and performance tuning, ensuring HA and compliance.

Qualifications

• 12+ years of hands-on SQL Server DBA experience.
• Bachelor’s degree in CS/IT or equivalent.
• Expert knowledge in Windows Server, SQL Server, Azure cloud platform and specifically SQL Managed Instance, Azure Storage account and Azure security fundamentals.
• Experience implementing High availability (Always-on).
• Strong Knowledge of SQL. Knowledge of Python is preferred.
• Certifications in Microsoft technologies are preferred

Responsibilities

• Design and oversee the installation, configuration, and maintenance of database technologies and resources to ensure that all application and systems availability targets are met.
• Perform database administration tasks including but not limited to defining data process flows, data modeling, data migrations, security and fine tuning database performance.
• Design, configure and install database software modules and applications.
• Develop system backup schedules, verification testing and all related documentation requirements.
• Work with system administrators, network administrators, help desk staff and other IT technical resources to coordinate database infrastructure requirements and analyze / troubleshoot issues as they arise.
• Ensure all required system documentation and record keeping requirements associated with maintaining and controlling IT assets are completed accurately, timely and in accordance with policies and procedures and department requirements.
• Participate in the evaluation of new database products and technologies and influence future direction and provide input into the overall impact of introducing the technology in the environment.
• Guide less senior database technicians and staff in the performance of their tasks.
• Design, engineer and document solutions and standards to be applied within the IT Department.
• Contribute to the planning and coordination of tasks associated with database installations, support and maintenance.

Skills

SQL Server

Azure

Windows Server

Always-on HA

Python

Security compliance

Education

Bachelor’s degree in CS/IT

Tools

SQL Server Management Studio

Azure Portal

Azure SQL Managed Instance

Job description

Senior SQL Server DBA Architect - Azure

3 days on site and 2 days remote in NYC

Contract

Job Title: Senior SQL Server DBA Architect - Azure

Duration: 12 months(37.5 hrs per week)

Location: NYC(3 days on site and 2 days remote)

This role is hybrid and no chance of 100% remote. 3 days on site or as needed in 2 Broadway, NYC

Job Summary

• Design, implement, and maintain Microsoft SQL Server and Azure Managed Instance databases .
• Perform SQL server, database installations, upgrades, and migrations.
• Collaborate with infrastructure team for Patching on regular basis.
• Troubleshoot and remediate database-related issues.
• Ensure database security and compliance.
• 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

Critical skills

• 12+ years of hands-on experience as a SQL Server Database Administrator.
• Bachelor’s degree in Computer Science, IT, or equivalent experience.
• Expert knowledge in Windows Server, SQL Server, Azure cloud platform and specifically SQL Managed Instance, Azure Storage account and Azure security fundamental.
• Experience implementing High availability (Always-on).
• 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

Qualifications

• Advanced knowledge and familiarity with installing, maintaining and troubleshooting database technology, computer hardware, operating system software and storage area network equipment as it relates to the proper installation and performance of the databases.
• Advanced knowledge of general purpose programming languages used to support automation of database tasks.
• Ability to troubleshoot and support technical issues both remotely and on-site using standard tools and techniques.
• Ability to read and understand schematic diagrams, technical manuals and documentation such that supported equipment and software can be maintained with minimal training.
• Strong oral and written communications skills.
• Strong analytical skills.
• Strong people skills.
• Ability to plan activities and provide advanced technical direction to less senior staff members.
• Ability to design & engineer solutions and standards.
• Bachelor’s degree in Computer Science, Information Technology or related discipline; or a minimum of 15 years’ experience with programming, systems administration and/or database administration disciplines.
• Must possess a minimum of 8 years’ experience installing, maintaining, administrating and supporting, computer hardware, operating systems software (UNIX, LINUX & Windows) and database products such as Oracle and MS-SQL.

Responsibilities

• Design and oversee the installation, configuration, and maintenance of database technologies and resources to ensure that all application and systems availability targets are met.
• Perform database administration tasks including but not limited to defining data process flows, data modeling, data migrations, security and fine tuning database performance.
• Design, configure and install database software modules and applications.
• Develop system backup schedules, verification testing and all related documentation requirements.
• Work with system administrators, network administrators, help desk staff and other IT technical resources to coordinate database infrastructure requirements and analyze / troubleshoot issues as they arise.
• Ensure all required system documentation and record keeping requirements associated with maintaining and controlling IT assets are completed accurately, timely and in accordance with policies and procedures and department requirements.
• Participate in the evaluation of new database products and technologies and influence future direction and provide input into the overall impact of introducing the technology in the environment.
• Guide less senior database technicians and staff in the performance of their tasks.
• Design, engineer and document solutions and standards to be applied within the IT Department.
• Contribute to the planning and coordination of tasks associated with database installations, support and maintenance.