iMethods is seeking a Senior DBA for a full time role with a large health system in the Jacksonville market. Candidates must live in or be willing to relocate to Jacksonville.
As the Senior Database Administrator, they 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 & Qualifications
In this Role:
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
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)
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