SQL Administrator
Sarnova 5 reviews - Dublin, OH

This job posting is no longer available on CareerBuilder. Find similar jobs:SQL Administrator jobs - Sarnova jobs

Sarnova, Inc. is a leading specialty provider of healthcare products across the emergency medical services and acute care continuum. It is comprised of three major business units: Bound Tree Medical, Tri-anim Health Services, Inc. and Emergency Medical Products, Inc. (EMP).Together, Sarnova offers more than 100,000 healthcare products to thousands of emergency care providers, hospitals and advanced patient-care facilities nationwide.Essential Function: Seeking a highly qualified Database Administrator to perform lead role in managing the support of enterprise databases that support our applications. The selected DBA must ensure the optimal performance and security of all production databases, advise management of potential risks and mitigations, and proactively take steps to ensure smooth performance. Primary Responsibilities: · Responsible for monitoring, maintaining, and managing SQL Server 2008 · Implements and maintains database security. · Establishes and maintains documentation and standards. · Performs database capacity planning and involved in server capacity planning. · Provides general technical troubleshooting and consultation to the development team. · Provides SQL Reporting Services (SRS), analysis cubes, SQL Server Integration Services (SSIS), and analysis services.· Performs integration design, production, and implementation.· Develops, revises and implements policies, standards, procedures and guidelines necessary to effectively administer the database environment.· Plans and conducts structured testing of database designs to confirm functionality and performance.· Performs routine and customary operational and monitoring activities to ensure the database environment is stable and capable of meeting ongoing business needs.· Optimizes SQL queries and jobs. · Responsible for troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues etc.· Responsible for Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools.· Provides technical training to staff as necessary. · Assists with application and user support when needed.Reports To: MIS Application Support Manager
Sarnova is an Equal Opportunity Employer. We offer a competitive salary, commensurate with experience, along with a comprehensive benefits package, including 401(k) Plan.Education: Bachelors Degree in Information Technology or related fieldExperience: · 5+ years of professional IT/IS experience, including 3-5 years experience in MS SQL Server database administration in a SQL 2008 environmentSkills: · Experience in MS SQL Server database environments with a focus on maintaining, backing up, administration of critical data systems including performance tuning, stored procedures, triggers, and SSIS packages.· In-depth knowledge of MS SQL server from both the application and the server standpoints in a Microsoft development environment. · Strong knowledge of indexes, index management, integrity checks, configuration, and patching. How statistics work, how indexes are stored, how they can be created and managed effectively.· Knowledge of SQL Server tools ( Profiler, DTA, SSMS, SAC, SSCM, PerfMon, DMVs, system stored procs) · Proficient in integration of SQL Server, relational databases, SQL, and database management. · Strong knowledge of Microsoft SQL Server Replication. · Ability to work independently and in a team environment along with strong customer service skills and the ability to interface with all levels of users.· Data Base Tuning, Security, Management, Administration, RDBMS skills.· Knowledge of ERP system (Microsoft Dynamics Great Plains) preferred.· Exposure to other applications and development languages such as MS Access, XML, ASP, C#, .Net, JavaScript, VB Script, and HTML is a plus. · MCITP highly desirable.

About this company
5 reviews
Sarnova is comprised of four major business units: Bound Tree Medical, DXE Medical, Emergency Medical Products and Tri-anim Health Services....