Job Description
• Active in all phases of system development; planning and analysis, design, development, and testing
• Provides architectural/database technical expertise to team concerning methods, procedures, and standards to be used during design and development phases
• Maintains application performance and scalability; focus on performance tuning SQL queries, table design, indexing, query plan analysis and SQL refactoring
• Develops and maintains technical documentation and operational procedures for areas of responsibility
• Investigates and fixes defects; pre and post-release
• Prepares and deploys complex schema updates, data migration and ETL scripts
• Follows and contributes to team standards and utilizes industry best practices
Requirement
Bachelor’s degree in Computer Science, Software/Computer Engineer or related field and a combination of work experience
• 3+ years of designing databases using Microsoft SQL Server in a professional team environment
• Expert in SQL database development (‘05 & ‘08)
• Hands-on experience creating all key database objects – Tables, Views, Triggers, Indices, Stored Procedures, User Defined Functions, Dynamic SQL
• Ability to troubleshoot/resolve complex database issues
• Strong database performance tuning experience in a RDBMS environment
• Strong general ETL / data integration experience; specific experience with SSIS is required
• Proficient in database modeling & design with a focus on performance and scalability
• Experience developing/managing large-scale databases
• Excellent organizational skills with the ability to achieve results within tight deadlines
• Excellent verbal and written communication skills
• Active in all phases of system development; planning and analysis, design, development, and testing
• Provides architectural/database technical expertise to team concerning methods, procedures, and standards to be used during design and development phases
• Maintains application performance and scalability; focus on performance tuning SQL queries, table design, indexing, query plan analysis and SQL refactoring
• Develops and maintains technical documentation and operational procedures for areas of responsibility
• Investigates and fixes defects; pre and post-release
• Prepares and deploys complex schema updates, data migration and ETL scripts
• Follows and contributes to team standards and utilizes industry best practices
Requirement
Bachelor’s degree in Computer Science, Software/Computer Engineer or related field and a combination of work experience
• 3+ years of designing databases using Microsoft SQL Server in a professional team environment
• Expert in SQL database development (‘05 & ‘08)
• Hands-on experience creating all key database objects – Tables, Views, Triggers, Indices, Stored Procedures, User Defined Functions, Dynamic SQL
• Ability to troubleshoot/resolve complex database issues
• Strong database performance tuning experience in a RDBMS environment
• Strong general ETL / data integration experience; specific experience with SSIS is required
• Proficient in database modeling & design with a focus on performance and scalability
• Experience developing/managing large-scale databases
• Excellent organizational skills with the ability to achieve results within tight deadlines
• Excellent verbal and written communication skills