MS SQL Server Database Administrator - R

Next Step Systems

Full-time

Remote

Professional, Scientific, and Technical Services

About the position

We are seeking a talented and self-motivated MS SQL Server Database Administrator to join a growing IT team. This position requires experience administrating MS SQL Server, including tasks such as creating indexes, database maintenance, backups, and recovery. The role is hybrid, necessitating both onsite and remote work in Brooklyn, NY. As a Database Administrator, you will be responsible for ensuring the availability and performance of critical databases, providing 24/7 support, and performing troubleshooting, resolution, and root cause analysis for database and application-specific incidents. You will also engage in schema design, capacity planning, and change control management tasks, while executing database baselining, benchmarking, performance analysis, and tuning. In addition to maintaining and enhancing database maintenance routines, you will collaborate with company technical leads and development teams to create and execute project plans that align with customer expectations and company strategic goals. Your responsibilities will include executing database backup and recovery operations, database patching and upgrades, and implementing database security policies. You will also integrate SQL systems with third-party tools and environments, document policies, processes, and procedures, and cross-train members of the organization on effective database usage. Supporting other key initiatives as the business dictates will also be part of your role.

Responsibilities

• Provide 24/7 support for firm critical databases.
• Perform troubleshooting, resolution and root cause analysis for database and application specific incidents.
• Perform schema design, capacity planning and change control management tasks.
• Execute database baselining, benchmarking, performance analysis and tuning.
• Maintain and enhance database maintenance routines.
• Work with company technical leads and development teams to create and execute project plans in line with customer expectations and company strategic goals.
• Execute database backup and recovery operations, database patching and upgrades and implementation of database security policies.
• Integrate SQL systems with third-party tools and environments.
• Document policies, processes and procedures.
• Cross-train members of the organization on how to use databases effectively and efficiently.
• Support other key initiatives as the business dictates.

Requirements

• Bachelor's Degree from a 4-year university in computer science, information science or related technical field.
• 5-7 years of DBA experience.
• Experience administrating MS SQL Server (creating indexes, DB maintenance, backups/recovery, etc.) is required.
• DDL experience is required.
• Need experience with MSSQL.
• Excellent written and verbal communication skills.
• Strong analytical and troubleshooting skills.
• Highly organized, self-motivated, able to multi-task, able to work independently as well as a team player.
• Solid project management skills; able to take a project from inception to completion.
• Knowledge of database design methods and techniques.
• Knowledge of database security methods and procedures.
• Understanding of ETL best practices across the enterprise.
• Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profile and other related monitoring and troubleshooting tools.
• Expertise of High Availability and Disaster Recovery options for MS SQL.
• Knowledge of indexes, index management and statistics.
• Experience with database backup, restore and recovery models.
• Ability to work effectively in a fast-paced, dynamic environment.