Talent.com
Senior SQL Server DBA
Senior SQL Server DBARaymond James • St Petersburg, FL, United States
Senior SQL Server DBA

Senior SQL Server DBA

Raymond James • St Petersburg, FL, United States
[job_card.1_day_ago]
[job_preview.job_type]
  • [job_card.full_time]
[job_card.job_description]

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.

Job Description

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.

Skills / Previous Experience

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

  • 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.
  • Licenses / Certifications

  • None required.
  • Education

    Bachelors : Business Administration, Bachelors : Computer and Information Science, High School (HS) (Required)

    Work Experience

    General Experience - 3 to 6 years

    Travel

    Less than 25%

    Workstyle

    Hybrid

    At Raymond James our associates use five guiding behaviors (Develop, Collaborate, Decide, Deliver, Improve) to deliver on the firm's core values of client-first, integrity, independence and a conservative, long-term view.

    We Expect Our Associates At All Levels To

  • Grow professionally and inspire others to do the same
  • Work with and through others to achieve desired outcomes
  • Make prompt, pragmatic choices and act with the client in mind
  • Take ownership and hold themselves and others accountable for delivering results that matter
  • Contribute to the continuous evolution of the firm
  • At Raymond James as part of our people-first culture, we honor, value, and respect the uniqueness, experiences, and backgrounds of all of our Associates. When associates bring their best authentic selves, our organization, clients, and communities thrive. The Company is an equal opportunity employer and makes all employment decisions on the basis of merit and business needs.

    #J-18808-Ljbffr

    [job_alerts.create_a_job]

    Senior SQL Server DBA • St Petersburg, FL, United States

    [internal_linking.similar_jobs]
    Server Assistant - Teak

    Server Assistant - Teak

    Teak LLC • Saint Petersburg, FL, US
    [job_card.full_time]
    [filters_job_card.quick_apply]
    A Teak Server Assistant is plays a fundamental role in our Front of House team, enhancing the guest experience by assisting the team members in providing the highest quality of hospitalit...[show_more]
    [last_updated.last_updated_variable_days]
    Server Assistant - Busser

    Server Assistant - Busser

    Texas Roadhouse • St. Petersburg, FL, United States
    [job_card.full_time]
    At Texas Roadhouse, we are a people-first company that just happens to serve steaks.Legendary Food and Legendary Service is who we are. We're about loving what you're doing today and preparing you f...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Remote Senior SQL Engineer - AI Trainer

    Remote Senior SQL Engineer - AI Trainer

    SuperAnnotate • Pasadena Hills, Florida, US
    [filters.remote]
    [job_card.full_time]
    As a Senior SQL Engineer, you will work remotely on an hourly paid basis to review AI-generated SQL queries, database designs, and data-processing logic, as well as generate high-quality reference ...[show_more]
    [last_updated.last_updated_variable_days]
    Server

    Server

    Whiskey Joe's Manatee River • Ellenton, FL, USA
    [job_card.full_time]
    [filters_job_card.quick_apply]
    We've recently evolved our menu and plating to provide a polished upscale dining for our guests.As new server to our team you will be instrumental in elevating more polished guest experience.The Wh...[show_more]
    [last_updated.last_updated_30]
    Server

    Server

    OTO Development • St. Petersburg, Florida, United States, 33701
    [job_card.full_time]
    We are pleased to announce a wonderful opportunity for a.What will you be doing most days?.Adhere to all sanitation, safety, and alcohol service protocol. Consistently hold a friendly, relaxing, and...[show_more]
    [last_updated.last_updated_variable_days]
    Digital Consulting Associate / Sr. Associate - Oracle Cloud ERP

    Digital Consulting Associate / Sr. Associate - Oracle Cloud ERP

    Huron Consulting Group • St Petersburg, FL, United States
    [job_card.full_time]
    Huron is a global consultancy that collaborates with clients to drive strategic growth, ignite innovation and navigate constant change. Through a combination of strategy, expertise and creativity, w...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Server

    Server

    LongHorn Steakhouse • Saint Petersburg, FL, US
    [job_card.full_time]
    Legendary food and service begins with legendary people.We believe in earning the loyalty of our Team Members with our strong, diverse culture, well-done benefits and growth opportunities.It takes ...[show_more]
    [last_updated.last_updated_30]
    Server - Hiring Immediately

    Server - Hiring Immediately

    Artistry Restaurants • St. Petersburg, FL, United States
    [job_card.full_time] +1
    At Oak & Stone, we're redefining the tavern experience with a modern twist.As a New American tavern, we offer a laid-back atmosphere where guests can enjoy craft beers from our self-serve beer wall...[show_more]
    [last_updated.last_updated_variable_days]
    Server - Senior Living

    Server - Senior Living

    Inspired Living at Ivy Ridge • St. Petersburg, FL, USA
    [job_card.full_time]
    [filters_job_card.quick_apply]
    We're passionate about personal and professional growth and will do everything we can to help you flourish.We deeply care about our team-members and partners and strive to provide a culture where p...[show_more]
    [last_updated.last_updated_30]
    Server

    Server

    Ruth's Chris • St. Petersburg, FL, US
    [job_card.full_time]
    For this position, pay will be variable by location.Are you ready for the best job ever?.Since Ruth’s Chris was founded in 1965, the most important ingredient in our recipe for success has been a t...[show_more]
    [last_updated.last_updated_30]
    BI Report Developer

    BI Report Developer

    Kobie Marketing • St. Petersburg, Florida, United States, 33701
    [job_card.full_time]
    Named a Top Workplace in the USA and Top Remote Workplace, Kobie is where the best minds in loyalty come together, driven by passion and innovation. Were always looking for talented individuals who ...[show_more]
    [last_updated.last_updated_variable_days]
    Server - Ellenton Chili's

    Server - Ellenton Chili's

    Chilli's • Ellenton, FL, United States
    [job_card.full_time]
    Server - Ellenton Chili's 6010 US Highway 301 N Ellenton, FL 34222 < Back to search results Role Overview Our Servers don't just provide our Guests with amazing food and drinks.They deliver ho...[show_more]
    [last_updated.last_updated_30] • [promoted]