Job description : Location : St. Loius, MO POSITION SUMMARY:
The main purpose of this position is to participate on a team of SQL Server professionals supporting the application development lifecycle. This position will be responsible for analyzing, programming, documenting, debugging, database builds, testing applications in the development environment, supporting production Database Administration with production deployments and providing post-productions support. ESSENTIAL FUNCTIONS: ? Develop new products as part of the project team. ? Mentor Analysts on technical and functional aspects of the applications. ? Attend staff and departmental meetings. ? Provide status updates to Supervisor and Manager. ? Adherence to pre-defined programming standards. ? Provide 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. ? Maintain 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 high-level requirements into detailed technical designs. ? Provide technical estimates. ? Lead and facilitate design sessions and code walk-throughs. ? 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. MINIMUM EDUCATION & EXPERIENCE: ? Bachelor?s degree in MIS, Computer Science, or related field, or equivalent combination of education and experience required. ? 5+ years experience with SQL Server, e.g. T-SQL stored procedures, functions, views, triggers, indexes, query tuning, and SSIS required. ? 5+ years database development experience required. ? 5+ years experience with SQL, Transactional SQL, Stored Procedures, RDBMS required. ? 5+ years experience with SQL Server or DB2 or Oracle 10G required. ? 5+ years experience with ETL tools such as DTS or SSIS (SSIS Preferred). ? Extensive experience with designing and documenting relational databases. ? Experience with using source control systems such as VSS, CVS or TFS. ? Experience with Windows, Linux, Unix and/or iSeries. ? Experience with index tuning and query optimization. ? Experience as a Database Developer in an Application Development environment. Experience in Enterprise information integration is preferred -- *Thanks & Regards Hitesh Gurditta Phone :609-681-2604* *Email:h...@kpgtech.com* <email%3...@kpgtech.com> *| KPG99 Inc. 3240 E STATE ST EXT Hamilton, NJ 08619* -- You received this message because you are subscribed to the Google Groups "Citrix and Sap problems" group. To unsubscribe from this group and stop receiving emails from it, send an email to citrix-and-sap-problems+unsubscr...@googlegroups.com. To post to this group, send email to citrix-and-sap-problems@googlegroups.com. Visit this group at http://groups.google.com/group/citrix-and-sap-problems. For more options, visit https://groups.google.com/d/optout.