Senior SQL Server DBA: Azure & High-Availability Expert

Aries Solutions Intl Inc; New York (NY); On-site; USD 120,000 - 160,000; Full time

Job summary

Aries Solutions Intl Inc is seeking a seasoned SQL Server Database Administrator in New York to design, implement, and optimize database environments for active applications. Responsibilities include installing, configuring, maintaining, and tuning SQL Server and Azure Managed Instance databases, ensuring security and high availability, and collaborating with IT teams on infrastructure needs.

The ideal candidate holds a CS/IT degree with 5+ years of SQL Server experience, strong SQL and Python

Qualifications

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

Skills

SQL skills

Python

Problem solving

Analytical thinking

Communication skills

Technical direction

Education

Bachelor's degree in Computer Science or IT

Tools

Windows Server

SQL Server

Azure

Azure SQL Managed Instance

Azure Storage

Oracle

UNIX/Linux

Shell scripting

Job description

Aries Solutions Intl Inc is seeking a seasoned SQL Server Database Administrator in New York to design, implement, and optimize database environments for active applications. Responsibilities include installing, configuring, maintaining, and tuning SQL Server and Azure Managed Instance databases, ensuring security and high availability, and collaborating with IT teams on infrastructure needs.

The ideal candidate holds a CS/IT degree with 5+ years of SQL Server experience, strong SQL and Python