Senior Database Developer at Scottsdale

The Senior Database Developer has overall responsibility for developing and maintaining ETL/SQL code for PFCB, primarily in SSIS. This role will work with project managers, analysts, other developers, and business resources to build highly-performing enterprise applications. It includes responsibility for the full development life cycle (analysis, architecture, design, and support), and establishment of software policies, standards, controls, and procedures. This position reports to the IS Development Manager.

• Work with clients, business analysts, technical staff, and project team members to plan, design, develop, implement and enhance ETL/SQL code using appropriate software methodology. Projects should be designed to be delivered in functional stages
• Review current data structures and recommend optimizations and reconfigurations as warranted
• Ensure ETL /SQL architecture will integrate with current and cross functional requirements
• Accurately estimate project/code development time
• Convert designs and specifications into ETL/SQL code using designated tools in accordance with PFCBs coding standards and development practices
• Unit test code; confirm ETL/SQL functions meet specifications prior to delivery to Quality Assurance
• Document unit tests and ensure that the tests meet Quality Assurance requirements
• Provide input on prioritization of software changes, assist in planning efforts related to software releases with Quality Assurance, deployment and training teams
• Monitor performance of developed ETL/SQL after implementation
• Maintain ETL/SQL applications
• Create Design artifacts for each application solution including application and database design
• Develop and maintain detailed documentation on all steps and process flows around application/solution
• Facilitate and/or participate in design and code reviews
• Participate in the development and publication of best practices, standards and policies related to the ownership and usage of ETL/SQL solutions
• Identify and evaluate new technologies by maintaining professional expertise and knowledge through ongoing training and research of data technologies
• Mentor junior staff on development team

• Bachelors degree or greater in Computer Science or a related field is required.
• 5+ years experience with logical and physical modeling along with design and implementation
• 5+ years of experience using SQL with a relational DBMS such as Oracle or Microsoft SQL Server
• 5+ years experience using SSIS
• Well versed with SQL Server best practices
• Exhibit strong knowledge of ETL/SQL development technologies and quality assurance methodologies.
• Development: SSIS, Microsoft SQL Server 2005/2008/2012, Microsoft Visual Studio 2005/2008/2010, SQL Management Studio
• Expertise with data architecture, design & development
• Critical thinking and problem solving
• Design and implement processes and improvements
• Ability to follow development practices and deliver timely technology solutions
• Be highly organized and methodical with high attention to detail
• Ability to present projects to technical and non-technical senior management
• Ability to communicate and express difficult concepts to all levels of the organization
• Interact with internal customers and external vendors to discuss proposed applications or existing issues
• Be a self-starter showing initiative and flexibility but also be able to follow guidelines when appropriate
• Ability to cope with change
• Ability to think outside the box
• Deal with issues and problems promptly
• Think in a strategic manner focusing on future-oriented plans

Job Code : 5272
Division/Department : PF Changs China Bistro Home Office

Country: USA, State: Arizona, City: Scottsdale, Company: PF Chang.