SQL Database Administrator

Primary Responsibilities

• Manage and maintain the firm’s SQL environments, ensuring databases and servers operate reliably and securely. This includes tuning performance, applying updates, handling installations, managing storage, and overseeing backup and recovery processes.

• Administer SQL Server configurations and maintain accurate documentation of database structures and changes.

• Lead backup, restore, and recovery readiness activities, including recurring DR validation. Requires hands-on experience with SQL Server high-availability methods such as Failover Clustering, Replication, and Always-On availability sets.

• Continuously monitor system health and optimize performance at both the server and database layers, including query fine-tuning and configuration adjustments.

• Enforce internal standards for data protection, access control, and overall integrity of the database environment.

• Design and document data models, database schemas, and architecture to support evolving business and application needs.

• Build and refine stored procedures, queries, functions, and views to support operational and analytical workloads.

• Partner closely with the Senior DBA, infrastructure teams, developers, and business stakeholders to troubleshoot issues and support application releases or upgrades.

• Participate in scheduled on-call rotations and provide after-hours assistance as needed.

Required Background

• Bachelor’s degree in Computer Science, Information Systems, or an equivalent technical discipline.

• At least two years of experience working with enterprise-level databases and large datasets in a production environment.

• Strong communication skills and the ability to clearly convey technical information to both technical and non-technical audiences.

• High attention to detail and the ability to work effectively both independently and collaboratively.

• Advanced knowledge of Microsoft SQL Server (2016–2019) and T-SQL.

• Exposure to additional database systems (MySQL, PostgreSQL) is beneficial.

• Familiarity with cloud-based data platforms—such as Snowflake or Databricks—for tasks including access management and usage monitoring is considered an advantage.