- Familiar with SQL Server 2005 (including SQL Server Integration Services)
- Experienced with very large database systems (tables with millions of rows, and/or table partitioning)
- Performance Tuning (of queries, database state analysis, and data import/export)
- Good understanding of general (relevant) Operating Systems concepts, particularly diagnostics – i.e. able to resolve memory and/or file system problems due to high-volume conditions
- Very good understanding of ETL: parsing and data transformation issues (such as date conversions, data cleansing - i.e. bad characters, bad lines)
- Transact-SQL programming: creation/modification/optimization of procedures, views, and functions
- Passionate about SQL Server
- Prior experience specifically with import/export of very large files (DTS/bulk inserting of files > 2GB)
- Excellent relational design skills for upcoming schema redesign
- Experience with multiple, redundant databases and third-party source control management of DDL
- Solid strategies for backups and data integrity preservation
- .net/C# Experience
- Computer Science and/or Math background
- Interest in Statistics
Please mention datashaping.com when applying. Thank you.
No comments:
Post a Comment