Job Title: SQL Data Architect Skill Set : SQL Server, database modeling, ERWIN, OLTP, dimensional data modeling, SSIS, SQL Duration : 6 months and extendable Location: Los Angeles, CA
Job Description: • SQL Server 2005, 2008 database design, ensuring performance, availability and security • Data modeling and initial database optimization • Work closely with development teams to identify any potential issues in their design • Implementation and release of database changes as submitted by the development team • High-availability design • Database standards enforcement • Performance monitoring and tuning • Maintaining and improving databases, including rollouts and upgrades • Managing database scripts/code with version control tool • Using ERwin ERD tool to model, generate scripts and compare models with physical databases Accomplishments • Designed logical and physical database schemas of 500+ tables for OLTP and analytical purposes using relational and dimensional modeling, including the design of tables, relationships, index strategy and referential integrity • Reverse engineered production databases for analysis/re-factor, including the analysis of tables, relationships, index strategy and referential integrity • Used, in production, advanced SQL Server features including SSIS, replication, mirroring, full text indexes. • Developed and used, in production, scripts to implement processes and build/deploy objects with transact SQL. Skills • Finding and fixing performance issues • Analyzing explain plans • Bringing order to complex and ambiguous situations • Working in a team that delivers a high availability service • Creating metadata-driven reusable database components in complex shared infrastructures Knowledge • Problem escalation procedures to SQL Server Development team and third parties • Capacity and performance planning of memory, CPU, disk space, and I/ O Desired experience levels: • 5+ years experience SQL Server Database Architecture/Administration • 3+ years of data modeling and application database design experience • 1+ years experience with ERwin ERD tool to model, generate scripts and compare models with physical databases *****Please send your updated resume to [email protected] -- You received this message because you are subscribed to the Google Groups "Hot List" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/directclienteq?hl=en.
