* Position : Senior SQL DeveloperLocation : Washington DCDuration : 12+ months *
*Must Have 10+Years Of Experience* *Responsibilities:*Design database schema based on data modeling of business requirements and entities Document schema design in E-R diagrams using MS Visio and maintain data dictionaries for all tables Write new stored procedures, functions, views, triggers, constraints, etc. Review SQL code written by application developers to ensure compliance to coding standards and best practices as well as maximum performance Create deployment and rollback scripts for all database objects manually or auto-generated Analyze access patterns and propose the best combination of indexes, constraints, foreign keys, and queries Troubleshoot performance problems and propose short term fixes and long term solutions Create SSIS packages for data transformation, cleansing, caching, aggregation, staging, and transfer Work with Architects and lead developers to come up with optimal database design *Qualifications* B.S. in Computer Science and 10+ years related experience 6+ years of hands on SQL Server development experience Expert knowledge of all aspects of SQL Server 2008 Transact SQL including the ability to write and deploy effective triggers, stored procedures and user defined functions Profound understanding of SQL Server concurrency features, transactions, and locking; Excellent data modeling and schema design skills, including normalization and de-normalization Full grasp of the pros and cons of table partitioning and distributed partitioned views and how large data volume affects replication in SQL Server environment; In-depth knowledge and hands-on experience developing, deploying, and maintaining substantial SSIS packages Thorough understanding of best practices for database maintenance, including index and file management, backups, failure recovery, database defragmentation, documentation; Ability to analyze disk space requirements and hardware utilization, automate error notification Basic SQL Server administration skills, such as backups, restores, taking and reverting snapshots, user/role security, access permissions, etc. ------------------------------ Regards: Amer Ali - Sr.IT Recruiter ITBrainiac Inc. Direct : 609-423-4147 || [email protected] Gtalk: Ameritbtalent Princeton,NJ 08540 Website: www.itbrainiac.com -- You received this message because you are subscribed to the Google Groups "oraapps" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/oraapps. For more options, visit https://groups.google.com/d/optout.
