Senior SQL Server DBA


  • Location: Jacksonville, FL
  • Type: Perm Placement
  • Job #33711

iMethods is currently seeking a full time Senior SQL Server DBA for a healthcare client in Jacksonville, Florida. This position will require candidates either live in or be willing to relocate to the Jacksonville, FL. The Senior DBA will implement and maintain the performance of essential SQL Server RDBMS systems to ensure availability and consistency for enterprise applications. They will be hands-on, showcasing both their solid technical and interpersonal skills. In addition to complex work, they will perform routine database administration tasks and enter data in system admin logs. They will have knowledge of debugging protocols and processes, as well as the ability to troubleshoot issues and implement corrective actions. They will review database performance trends and identify opportunities for improvement.

RESPONSIBILITIES:

  • Manage SQL databases in development, QA and production environments
  • Resolve all database-related issues
  • Monitor databases both from a performance and capacity management perspective
  • Perform database maintenance activities such as backup/recovery and rebuilding/reorganizing indexes
  • Ensure that all database releases are assessed and measured from a functionality and performance perspective
  • Provide technical expertise on all database design (Logical and Physical modelling) and development project
  • Demonstrate SQL Development(T-SQL) expertise related to performance tuning of database schema, stored procedures, etc.
  • Create and schedule SQL Server agent jobs.
  • Set-up and manage fail-over clusters (in partnership with Infrastructure)
  • Develop packages, database mirroring, and replications
  • Automate database management activities using PowerShell and other technologies
  • Perform system monitoring, metric reporting, and diagnostics

REQUIRED QUALIFICATIONS:

  • Bachelor’s degree in computer science, related field or equivalent combination of education and experience
  • At least 7 years of related experience
  • Experience with Microsoft SQL Server Clustering, Replication, and Always On
  • Experience with database technologies, such as MS SQL Server 2008, 2012, 2014 and above
  • Experience in performance tuning, query optimization using Performance Monitor, SQL Profiler or other related tools
  • Familiarity with JASON, XML, and .NET framework
  • Experience managing large numbers of databases in a real-time production environment
  • Experience resolving database integrity issues, performance issues, blocking/deadlocking issues, connectivity issues, and data replication issues
  • Experience with database maintenance activities such as backup/recovery and capacity monitoring/management
  • Knowledge of how indexes work; management of index statistics and fragmentation
  • Deep, specialized domain expertise in deployed systems (i.e. distributed systems algorithms, storage allocation algorithms, and deep database skills)

PREFERRED SKILLS:

  • Experience managing and making software deployments/changes in real-time production environments
  • Experience collaborating with development teams on logical/physical database design activities and performance tuning
  • Knowledge and experience managing Oracle databases
  • Experience supporting Business Applications DB and Data Warehousing/BI platforms
  • Familiarity with Operational Data Stores, Enterprise Data Warehouses
  • Experience with cloud technologies
  • Experience with MuleSoft Integration platform
  • Experience with ETL tools

Back to Featured Jobs