SQL Developer

Description

POSITION SUMMARY The main purpose of this position is to specialize in one or more areas of new application/database development. The Developer will be responsible for administrating, analyzing, programming, documenting, debugging, database builds and testing applications in the development environment.ESSENTIAL FUNCTIONS Dedicate majority of time to the development of new products/support of applications already in production.Mentor Analysts on technical and functional aspects of the applications.Attend staff and departmental meetings.Provide status updates to Supervisor and Manager.Adherence to predefined programming standards set by Application Architects.Develop recommendations regarding further definition of development standards and application architecture principles.Create documentation using established PMO standards.Perform unit testing and assist in user testing of programming modifications.Maintains technical knowledge through training or other measures.Address system problems during off hours with the guidance from other members of the development staff as needed.Translate highlevel requirements into detailed technical designs.Provide technical estimates.Lead and facilitate design sessions and code walkthroughs.Develop and maintain effective partnerships with Scottrade product development and business teams in order to understand and anticipate their needs, the business environment, other challenges and opportunities.Disseminate information on any problems or potential delays.Coordinate with multiple internal and external groups.When assigned, build database objects from source, create database release deployment scripts and distribute release notes.When assigned, develop and maintain documentation on all database build procedures.Perform other duties as assigned.KNOWLEDGE, SKILLS AND ABILITIES REQUIRED High level understanding of technologies, procedures, and concepts within specialized area.Ability to read and create UML diagrams. Ability to handle multiple tasks. Excellent organizational skills.Great attention to detail.Foster company success through a professional appearance, being courteous to customers and all Scottrade associates and by having a positive attitude.PHYSICAL ACTIVITES & REQUIREMENTS, VISUAL ACUITY, WORKING CONDITIONS AND NOISE LEVEL While performing the duties of this job, the employee is required to sit, talk, hear, and use hands to finger, handle or feel objects, tools or controls.The physical requirements of this position are considered to be sedentary work (Exerting up to 10 pounds of force occasionally and/or negligible amount of force frequently or constantly to lift, carry, push, pull or otherwise move objects. Sedentary work involves sitting most of the time.).While performing the duties of this job, the employee is required to have close vision (clear vision at 20 inches or less in order to view a computer screen). The noise level in the work environment is considered moderate (business office with coworkers, copiers, shredders, printers, etc).MINIMUM EDUCATION & EXPERIENCE Bachelors degree in MIS, Computer Science, or related field, or equivalent combination of education and experience required. 5+ years proven success as a database developer and/or DBA required.5+ years proven technical experience with SQL, Transactional SQL, Stored Procedures, RDBMS.5+ years proven technical experience with SQL Server or DB2 or Oracle 10G5+ years technical experience with ETL tools such as DTS or SSIS (SSIS Preferred).Experience with Windows, Linux, Unix and/or iSeries.Experience with index tuning and query optimization.Extensive experience with designing and documenting relational databases.Experience as a Database Developer in an Application Development environment.Experience with using source control systems such as VSS, CVS or TFS.Experience in Enterprise information integration is preferred.