We are proud to be an EEO/AA employer M/F/D/V. Minorities and women are encouraged to apply. We maintain a drug-free workplace and perform pre-employment substance abuse testing.
Working under minimal supervision, plan, design, implement and manage the database environment for client server, data warehouse and local area network applications to ensure that quality and timely service levels for both internal and external clients are maintained.
Key Job Requirements:
Bachelor’s Degree, in a related discipline 3 years experience in database administration in a Windows environment. Working knowledge of data warehouse, client server and LAN database systems. Experience must include 3 or more years administering a SQL 2005/2008 SSIS/SSRS server environment and SAS or related data warehouse management skills. Understanding of conceptual, logical and physical data modeling techniques. Knowledge of SSRS and SSIS code development is highly desirable. Demonstrated ability to communicate well with management, peers and customers throughout the company. Demonstrated ability to train peers and less experienced personnel so that organizational growth can be accomplished. Advanced plus data competency level: Understands the data structures throughout both the transaction system and the data warehouse. Works with the data on a daily basis analyzing the data, writing reports and queries and supports other departments with their complex data needs. Experience serving as an administrator for off the shelf packages a plus. Familiarity with MicroStrategy or Kalido advantageous.
•Analyze, plan, design and implement new database structures in an efficient and timely manner to support the business needs of the company while maintaining the standards of a well-structured and normalized relational database model.
•Analyze and improve existing databases to achieve optimal performance, relational design, database normalization, data integrity, and structured database environment flexible for any future functional additions and database growth.
•Assist business units in designing technical specification documents for internal or external database projects by providing a mock-up of a relational database model in sync with the business needs to a vendor.
•Review database structures developed by development teams
•Work on troubleshooting and correcting database issues in an efficient and timely manner ensuring uninterrupted continuation of a business flow.
•Implement and perform regular SQL server database performance tuning tasks including but not limited to index rebuilding, log truncation, SQL SSIS / SSRS / DTS tuning, backup and recovery.
•Investigate, plan, and apply necessary SQL server database and SAS warehouse patches and fixes.
•Document all database architecture and relevant procedures according to established standards.
•Monitor resource utilization to ensure client response time meets expected service levels and to help ensure uninterrupted system availability.
•Develop new and utilize existing database performance and status reporting tools.
•Assist the Network Services and the disaster recovery team in the planning, documentation, coordination and execution of all disaster recovery testing.
•Assist in the training of various staff to ensure they possess the required skills to help support the Health Partners Database environment.
•QA all data base designs before applications are implemented into the production environment.
•Interface with various Information Services staff and outside vendors for program product evaluation and customer support as required.
•Perform other duties as assigned.