At Cencora, the Database Developer III is responsible for working with business analysts and business users to gather and interpret business requirements for multiple financial and healthcare systems including large data warehouses. The successful candidate will create technical designs within the existing architecture and develop complex SQL query logic to accomplish the task.
Requirements
- 6+ years of SQL Server programming experience
- SQL Server Database Architecture and Design (OLTP/OLAP), and SQL Server Database Programming and Development
- SQL Server 2000 and SQL Server 2005 (SQL Server 2008 a plus)
- Strong knowledge of T-SQL, Stored Procedures, Triggers and DTS development
- Knowledge of physical database administration with SQL Server a plus
Responsibilities
- Design and develops database applications using SQL Server Integration Services, TSQL and Stored Procedures
- Consult with the business to determine logical design for new business solutions according to existing data architecture
- Perform code reviews, analyze execution plans, and re-factor inefficient code
- Follows data standards, resolves data issues, completes unit testing and completes system documentation for ETL processes
- Collaborate with business analysts, source system experts, and other team members to determine data extraction and transformation requirements
- Collaborate with IT operations and testing organizations to ensure timely releases of projects and database environments are sustainable
- Collaborate with IT operations for support in problem resolution and root cause analysis
Other
- BS or BA or equivalent experience required
- Excellent written and verbal communications skills required
- Must be able to work in a fast paced team environment
- Provides on-call assistance as needed
- Ensure development follows the ABSG SDLC process
