Senior SQL Server DBA

Job Description Summary

Note:

This position will follow our hybrid work model, we expect the selected candidate to be in office 50% of the total number of business days in a given month at one of the following offices:
Memphis, TN (primary), St. Petersburg, FL, or Southfield, MI.

This role is not eligible for Work Visa sponsorship, either currently or in the future.

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.

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

• 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, Solar Winds.
• 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.

• 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…