Database Administrator II

For the past 11 years, eCollege has been improving educational delivery methods by providing enterprise eLearning solutions with innovative technology and high-touch services. eCollege provides an on demand, or Software as a Service (SaaS) learning platform to growing colleges, universities and educational institutions across the globe. eCollege has been recognized as a proven leader in the use of educational technology. Our Course Management System (CMS) was ranked first in customer satisfaction in 2007 in independent research conducted by the IMS Global Learning Consortium. According to leading IT researchers, more than 40% of all software will be deployed with on demand, or Software as a Service (SaaS) models by 2012. If you want to make a contribution to the future of learning and prefer an open-minded approach to work, join the eCollege team! As a Pearson company, eCollege offers competitive benefits in a challenging work environment, steeped in a supporting IT culture.Pearson Education is an Equal Opportunity Employer EOE/M/F/V/D.



SUMMARYA Development DBA II administers SQL Servers and their databases in a software development role.DUTIES AND RESPONSIBILITIESDesigns logical and physical databases with data modeling tools Writes scripts and processes for developmentReviews database design changes with the team to determine the impact to the physical database and other systems Scripts database objects to comply with current standards Utilizes company version control toolSupports Application Development staff with respect to database objects Supports production issues for cubes, DW Reporting, and ETL jobsManages and performs maintenance, backups and security for the development databases Troubleshoots database issuesEnforces database standardsConfigures and maintain SQL Server and database settingsPerforms data migrationsResponsible for database backup and disaster recoveryMonitors database and SQL Server performanceImplementation and maintenance of replication concepts Performs capacity planning Applies updates and upgrades to non-production database environmentsDocument as necessary Implements approved database technologiesAttends product specification meetings with project team members to determine the scope and limitations of the projectParticipates with review of QA test plansWorks closely with other team members Other duties as assigned EDUCATION and/or EXPERIENCEHigh school diploma or equivalent required. Bachelor's degree in Computer Science or related area preferred. Minimum two- (2) years of DBA experience required.KNOWLEDGE, SKILLS AND ABILITIES Experienced in Microsoft SQL Server 2000 and 2005 in the following areas: database design; SQL Server architecture; T-SQL programming; performance tuning; stored procedure, function and trigger design and coding; index implementation and maintenance; database backup and recovery; SQL Server replicationUnderstanding of n-tier application designsMathematical skills including basic algebra and statisticsThe ability to extrapolate database schema to meet the business needs of the applicationAbility to perform multiple tasks concurrentlyStrong PC skills including thorough knowledge of Microsoft Office suiteAbility to be flexible and adapt to any given situationExcellent customer service attitude, communication skills (written and verbal), and interpersonal skillsExcellent organizational and time management skillsExcellent analytical and problem-solving skillsAbility to make timely and sound decisionsDetail orientedAbility to work independently and in a team based environmentAbility to work efficiently in a fast paced environmentAbility to work under pressure and in high stress situationsAbility to be self-motivatedCERTIFICATES, LICENSES, REGISTRATIONS Microsoft Certified Database Administrator (MCDBA), Microsoft Certified Systems Engineer (MCSE), Microsoft Certified Technology Specialist (MCTS), and/or Microsoft Certified IT Professional (MCITP) a plus.