Senior SQL Server DBA

Raymond James•Southfield, MI

4d•Hybrid

About The Position

As a Senior SQL Server Database Administrator, you will be part of a dynamic team that administers and manages complex database systems. You will create, manage, and monitor mission-critical databases that are core to the firm. You will be responsible for database administration of SQL Server systems, solving complex performance problems, capacity planning, and automation. In this role, you are the primary on the most complex or escalated issues and may provide direction and guidance to team members.

Requirements

More than five (5) years of experience with Microsoft SQL Server 2016/2017/2019/2022, including Availability groups, Database Mirroring, Transactional replication, and Change Data Capture. Systems preferred.
Experience supporting multiple production, QA, and development servers in large environments (400 plus instances).
Experience with large databases (> 1 TB).
Good transactional SQL skills – writing and tuning complicated stored procedures and views utilizing inner and outer joins, etc.
Experience diagnosing performance issues both at a database and code level, resulting in driving technical solutions to the development team.
Experience troubleshooting production issues in a timely, methodical manner that leads to accurate Root Cause Analysis.
Capacity planning for all aspects of a database system (storage, computing, memory, etc.).
Experience recovering databases after hardware or other catastrophic failures.
General knowledge of Windows Server and hardware.
Experience with supporting and developing SSIS packages.
Experience with Windows Power Shell.
Experience with one or more performance tuning tools – SQL Profiler, SolarWinds.
Experience with Query Store and Extended Events.
Ability to write efficient stored procedure code, strong understanding of triggers, indexing strategies, and effective database maintenance for optimal performance.
Ability to think through problems critically, ask good questions and provide solutions.
Able to use and/or create documented standards and apply those standards.
Able to multi-task and parallelize work efforts.
Willing to learn new technologies and drive to be a change advocate.
Good customer service, interpersonal, and communication skills.
Willingness to carry on-call support through rotation.
Bachelor’s: Business Administration, Bachelor’s: Computer and Information Science, High School (HS) (Required)
General Experience - 3 to 6 years

Nice To Haves

Strong performance tuning skills help the team be more proactive in solutions and tools.
Experience in financial services or other regulated industries is preferred.
Strong troubleshooting skills to help the team react faster and more efficiently to issues, identify root causes, and to prevent these issues from recurring.
Strong and more profound database administration skills in database management, best practices, high-availability solutions, and strong background working with development teams.
Strong focus on automation and tools development.
Experience supporting Neo4J a plus.

Responsibilities

Ensures availability, security, and integrity of the SQL Server environment.
Resolves database performance, capacity, replication, and other distributed data issues.
Installs and configures database management software (DBMS) and applicable service packs and/or patches.
Develop and implement database maintenance plans, including performing integrity checks, updating statistics, and monitoring security and hardware resource utilization.
Establishes regular backups of databases and transaction logs.
Manages logins and user accounts, including assigning database object permissions and ancillary privileges.
Schedules and manages jobs for data transfers and sundry procedures and monitors performance and impact on operations.
Participates in data modeling and database logical and physical design.
Participates in application development processes and code reviews of database objects.
Analyzes long-term database performance trends to optimize database and application performance.
Configures database server to work with middleware, web servers, and Online Analytical Processing (OLAP) tools.
Configures, supports and optimizes replication.
Performs acceptance testing on computer systems, applications, and hardware.
Performs other duties and responsibilities as assigned.