Job Description :Database Administrator

Department : U.S. Software Engineering



Purpose

The Database Administrator (DBA) is responsible for performing or validating database designs for OLTP and OLAP applications, and for the technical infrastructure design of our database applications.



In particular, we are looking for a multi-platform DBA (SQL Server 2000/2005, Oracle 9.0i/10g, MySQL). This individual would participate in many projects, but one area of focus would be our "ArcLight" campaign management system. This system has a highly complex database design and each new client implementation presents a unique set of ETL and scoping challenges.



The DBA's other responsibilities include assistance with the maintenance of our development environment, participating in project documentation and mentoring of other members of the team on database concepts. The DBA position reports directly to a Software Engineering Manager (SEM).





Technical Skills Required

1.3-6 years of DBA experience with a focus on database logical and physical design and maintenance

2.Thorough familiarity with database design concepts and knowledge of various theories of database design, including third-normal-form (3NF) and star schemas.

3.Experience with both Microsoft and Oracle database platforms, and a willingness to set any preferences aside and embrace both platforms as valid solutions.

4.Experience with MySQL or other alternative solutions is a plus

5.Experience with the development of batch jobs and ETL processing tasks

6.Master-level experience with all facets of the SQL language, including platform specific DDL

7.Experience setting up and maintaining regular maintenance jobs for backups, validation and optimization

8.Experience performing physical hardware design for complex database solutions

9.Experience in modeling and implementing database redundancy solutions such as transactional replication, log shipping, and failover clustering





Teamwork Expectations

Works with other senior team members to determine project scope, and to accurately determine project work estimates and timelines.

Mentors more junior team members to enhance their understanding of database design concepts

Creates thorough, intuitive documentation for their solutions

Presents accurate technical information, in written and oral form. Must be able to speak and write confidently in client-facing situations.



Delivery Expectations

Follows and contributes to Arc World Wide development standards and guidelines.

Attends status meetings which may include all members of the project team, including project managers, user-centered design specialists, designers, QA analysts, systems architects, and hosting operations team to ensure all functional requirements of the assigned development task have been considered and can be implemented according to plan.

Ensures that development possibilities and realities are clearly communicated to project team.

Develops reusable, flexible, accurate, well-documented solutions for broad user base.

Works with QA Analysts as necessary to resolve issues.

Clearly documents solutions, testing results, and application changes in a timely fashion.

Provides maintenance of their own personal development environments.





Education and Experience

BS/BA in Computer Science or MIS, or equivalent work experience

Typically requires 6 or more years of experience as a DBA in a full lifecycle application development capacity.

To Apply to this job go to http://www.GadBall.com or click here