Database Administrator, Level I
ExcelleRx Inc. - Philadelphia, PA

This job posting is no longer available on Omnicare, Inc. Find similar jobs: Database Administrator jobs - ExcelleRx jobs


Responsible for the support, monitoring, performance, and documentation of all Microsoft SQL databases used within excelleRx.

The primary responsibility of the Database Team is support and maintenance associated with the company’s core & proprietary patient medication reference application. This application is mission critical and therefore requires appropriate overnight monitoring and maintenance. The application currently has an aggressive release cycle and the database team participates in all production releases.

A successful Database Administrator (DBA) will be able to monitor the application, give consistent reports of the state of the databases that support the applications utilized, provide over night support, administer log shipping and transactional replication, and provide suggestions for performance improvement of all database operations.

Environment – Scope · excelleRx has forty-six (46) SQL Servers: twenty-six MS SQL 2000, seventeen MS SQL 2005 and three MS SQL 2008 servers
· The environment supports a three-phased life-cycle: development, testing and production
· The monitoring tools used for mission critical servers are from Idera Diagnostic Manager, Compliance Manager and Defrag Manager.
· Quest software Lite Speed for SQL Server is used for backups and log shipping
· The DBTeam works closely with the system administration, technical support and software development teams on a daily basis
· Written and verbal reports of database status to management on periodic basis
Essential Duties and Responsibilities · Creating primary database objects (tables, views, indexes, etc.) as required by developers or packaged application vendors
· Design and maintain log shipping (or other method) for disaster recovery readiness.
· Design and maintain Transactional Replication process
· Controlling and monitoring user access to databases
· Monitoring and optimizing the performance of databases. Provide regular reports of the state of the database environment.
· Implementing, and documenting processes for backup and recover of databases
· Support other databases/applications as and when required. Research new technologies and recommend applications.
· Assist with ad hoc query requests, including performance tuning
· Coordinate and communicate production schedules within IT/Development team.
· Participate in the regular on-call rotation, providing off hour support
· Work on Special Projects as Required
Qualifications: · Ability to juggle multiple projects
· Ability to work independently
· He/She will have excellent verbal and written communication skills as well as organizational skills to work in a multi-task, fast-paced environment with minimal supervision.
· He/She will demonstrate the ability to interact with multiple levels of personnel within the organization and externally.
Education and/or Experience: · The successful candidate will have a Bachelor’s Degree in Computer Science or equivalent experience and education.
· Must have a minimum of 4 years experience o
As a DBA using Microsoft SQL Server o
Designing databases for both OLTP and OLAP systems o
With TSQL and stored procedure programming o
Writing DTS packages o
Experience supporting RAID technologies, mirroring g and hot backups, and clustering preferred
Computer Skills: · Strong Microsoft SQL Server Stored Procedure development · Strong Microsoft SQL Server T-SQL
· Transactional Replication and Log Shipping
· Familiar with Quest Lite Speed and Idera Management tools
· Working knowledge of BCP
· Working knowledge of Microsoft Integration Services Packages
Certificates, Licenses, Registrations:

MCDBA - Microsoft Certified Database Administrator - preferred

Omnicare, Inc - 16 months ago - save job