Robert Half Technology SQL and Server Developers in Philadelphia, Pennsylvania
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. Provide oversight to more junior DBAs and SAS Admins.
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.
Document existing data base architecture and ensure it is maintained and updated as changes occur.
Manage Heat Ticket process for Data Administration and ensure that Change Management issues are raised and rectified.
Assist department management in assigning work for other members of the data base administration group.
Act as SME for other departments with questions about data base activity, development and operational support.
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 and provide direction for performance improvements and standardized coding techniques.
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 and/or SAS performance tuning tasks including but not limited to index rebuilding, log truncation, SQL SSIS / SSRS / DTS tuning, Enterprise Guide support, 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 Health Partners SQL and/or SAS 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.
With more than 100 locations worldwide, Robert Half Technology is a leading provider of IT professionals on a project and full-time basis for initiatives ranging from web development and systems integration to network security and technical support. Through our alliances with industry-leading organizations such as HDI® and the Microsoft® Partner program, we have access to client companies that other staffing firms don't. In addition to our free job search services, we provide our candidates with access to free online technical training and a competitive benefits and compensation package.
Our parent company, Robert Half, once again was named to FORTUNE® magazine's list of "World's Most Admired Companies" and was the highest-ranked staffing firm. (March 1, 2016)
Contact your local Robert Half Technology office at 888.674.2094 or visit roberthalf.com/technology to apply for this job now or find out more about other job opportunities.
All applicants applying for U.S. job openings must be authorized to work in the United States. All applicants applying for Canadian job openings must be authorized to work in Canada.
Equal Opportunity Employer M/F/Disability/Vet
Req ID: 03720-9500272618
Functional Role: Database Administration
Postal Code: 19103
Compensation: $85,000.00 to $95,000.00 per year
Requirements: Key Job Requirements: Education: Bachelor's Degree, in a related discipline 5 years experience in database administration in a Windows environment. Skills/Abilities:
Working knowledge of data warehouse, client server and LAN database systems
Experience must include 5 or more years administering a SQL server environment and SAS or related data warehouse management skills.
Provide direct interface with Network Services departments with regard to Data Base health and maintenance.
Oversee Security and Patch process for all HPP Sql Data Bases. Ensure that all required levels are met and that updates are applied in a timely and safe fashion.
Understanding of conceptual, logical and physical data modeling techniques.
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 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 data, writing reports and queries and supports other departments with their complex data needs.
Familiarity with support requirements for key core Healthcare software products and services. These should include care management systems (e.g. CCMS, Disease Monitor), enrollment systems (e.g. Market Prominence) and various external analytical vendor solutions (e.g. Milliman, Cave, Med Solutions).
Experience serving as an administrator for off the shelf packages a plus. Compliance Statement: Compliance with all applicable rules, regulations and laws is a condition of employment. Employees must read and sign the Code of Conduct and be expected to perform their duties ethically and honestly.