--
*Hiring: SQL Server Developer / Des Moines, IADirect ClientJob Title: SQL Server DBALocation: Des Moines, IADuration: 12 MonthsClient: State of IAInterview: in personDescripation:Day-to-Day ActivitiesThe successful candidate will spend a good portion of their time working with source system data owners and analytics developers to design and develop dimensional databases and associated ETL packages. While working on projects, the candidate is expected to propose, design, and develop solutions in concert with the other staff to fulfill the request. The candidate will also be responsible for system testing and working with the business users during acceptance testing. The successful candidate will be required to follow standard practices for migrating changes to the test and production environments and provide post production support. When not working on enhancement requests or problem reports, the candidate would concentrate on performance tuning.Senior level Database Administrator may work with more than one database architecture or have deep knowledge in a specific application database or set of databases to support architectural or decision support activities. The Database Administrator (DBA) is responsible for data analysis and database management. DBAs are typically involved in maintenance, enhancement, designing of data dictionaries, physical and logical database models, and performance tuning. DBA’s have a range of skills and knowledge of the utilities and production tools used for data storage management to support the Application Team. DBAs must be able to work in a team environment, follow quality standards and have strong written and verbal communication skills. DBAs coordinate physical changes to computer data bases; and codes, tests, and implements physical data base, applying knowledge of data base management system: Designs logical and physical data bases reviews description of changes to data base design to understand how changes to be made affect physical data base (how data is stored in terms of physical characteristics, such as location, amount of space, and access method). Establishes physical data base parameters. Codes data base descriptions and specifies identifiers of data base to data base management system or directs others in coding data base descriptions. Calculates optimum values for data base parameters, such as amount of computer memory to be used by data base, following manuals and using calculator. Specifies user access level for each segment of one or more data items, such as insert, replace, retrieve, or delete data. Specifies which users can access data bases and what data can be accessed by user. Estimates time and cost required to accomplish project. Directs programmers and analysts to make changes to data base management system. Reviews and corrects programs. Answers user questions. Confers with coworkers to determine impact of data base changes on other systems and staff cost for making changes to data base. Modifies data base programs to increase processing performance, referred to as performance tuning. Workers typically specialize in one or more types of data base management systems. May train users.Skill Required / Desired Amount of Experience Expertise Rating Required SkillsExperience in working with SQL Server 2005 and 2008 R2, Familiarity with SQL 2012 Required 5 Years Expert knowledge of T-SQL Required 5 Years Experience in developing and optimizing complex stored procedures Required 5 Years Experience developing data extract (SSIS) packages from source normalized databases. Required 5 Years Database modeling and design, specifically dimensional database modeling/STAR Schema’s Required 5 Years Knowledge of SQL best practices Required 5 Years Knowledge of SQL best practices in regards Data Warehousing and Decision Support Required 5 Years Experience in building ETL processes using SQL Server Integration Services(SSIS) Required 5 Years Excellent problem solving skills (for debugging problem reports) Required 5 Years Experience in working with big databases ( over 100 GB) Required 5 Years Experience in working closely with Analytics developers Required 5 Years Knowledge of Business Intelligence Tools (e.g. OBIEE, Business Objects) Required 5 Years Experience with SDLC and Agile development practices Required 5 Years Please send resume to alb...@cncconsulting.com <alb...@cncconsulting.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 oraapps+unsubscr...@googlegroups.com. To post to this group, send email to oraapps@googlegroups.com. Visit this group at http://groups.google.com/group/oraapps. For more options, visit https://groups.google.com/d/optout.
