Very urgent DIRECT CLIENT OPENING. *Please send resume at ds...@dsscorp.com <ds...@dsscorp.com>*
*Role: Data Architect and DBALocation: Des Moines, IADuration: 12 Months* This position will be working full-time on a large new development program that requires an advanced Data Architect and DBA skillset while also interacting with the department’s database support team. The program involves working with several different projects for distinct business units while also assembling the data in one place for reporting, analysis, and validation. All development is being done in a SQL Server/.Net environment. Experience in database design and modeling for new application development is required. In this position, you will be the face of all things data. You will need to be able to see the big picture while also able to work though the details to implement the big picture. This will involve data migration from other systems, script development and execution, creating DB backups, database design and verification, data integrity validation, and interactions with external stakeholders and customers. The candidate will have experience working in a fast-paced environment, with aggressive timelines. The project is currently transitioning to agile, so agile experience is a plus. Initial contract funding is for 1 year, but a longer 3-5 year engagement is anticipated. Responsibilities Quickly learn and understand the project’s database, tables, structures and fields from a big picture perspective (across business functions and project iterations) to provide architectural and decision support direction. Data Architect Provide a consultative approach with business users, asking questions to understand the business need and deriving the data flow, logical, and physical data models based on those needs Analyze data requirements and data stored in a disparate set of systems and designing a robust relational structure for the future Be accountable for integrity and quality of data, ensuring the information meets customer needs Ability to proactively participate in customer engagements, follow direction from lead technicians, work with customers, and participate in technical planning Plan for collection method, data cleansing, and normalization of data across multiple applications Understand how the data interacts with the application code Understand .Net Entity Framework Database Administrator Technical understanding of infrastructure components, their dependencies, and interactions between servers, virtual systems, networks, databases, web applications, etc. Perform all database updates, changes and enhancements utilizing and upholding a formal, structured naming convention Create, maintain, and deploy scripts across all project environments (Dev/Test/UAT/Prod) Perform and maintain all database backups and database restores associated with the project across all project environments (Dev/Test/UAT/Prod) Be accountable for integrity and quality of data, ensuring the information meets customer needs Perform necessary testing related to the project and its iterations Ability to prioritize and manage concurrent projects, demonstrate initiative and work independently with minimal supervision Ability to read, understand and create design documents Experience working in a team-oriented, collaborative environment Ability to present ideas in a user-friendly language Some overtime may be necessary in order to meet aggressive deadlines Complete other duties as assigned by Project Manager or Administrative Manager Skill requirements The above statements are intended to describe the general nature and level of work being performed by people assigned to this job. They are not intended to be a complete list of all responsibilities, duties and skills required of personnel assigned to this job. Required / Desired Skills Experience in database design and modeling for new application development Required 5 Years Extensive background in relational database systems, preferably with MS SQL Server Required 5 Years Transact SQL (T-SQL) Required 5 Years Strong database design experience and understanding of relational database structures, theories, principles and practices Required 5 Years Proficient translation of business requirements and functional specifications into technical data requirements Required 5 Years Superior interpersonal and communication skills, including the ability to be both directive and collaborative and to present ideas in a user-friendly Required 5 Years Demonstrated leadership skills Required 5 Years Exceptional analytical, conceptual and problem-solving abilities required Required 5 Years Strong written, technical documentation and oral communication skills Required 5 Years Experience with iterative and/or Agile Scrum development methodologies Desired 2 Years SQL Server Integration Services (SSIS) Desired 2 Years Experience with XML and XPath Desired 2 Years Extract, Transform and Load (ETL) migrations Desired 2 Years Experience with BizTalk Desired 2 Years Thank you, David Shah ds...@dsscorp.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 https://groups.google.com/group/oraapps. For more options, visit https://groups.google.com/d/optout.
