LEAD DATABASE ADMINISTRATOR - Store Systems

POSITION PURPOSE - The Lead DBA manages the physical data stores for the enterprise. This includes working with data modeling and development teams to put processes and procedures in place to create new databases, replicate data across platforms, monitor and manage the databases in production, perform tuning and SQL analysis, provide space estimates, grant data level access privileges and provide consultation to application development teams on design issues. The Lead DBA has expert knowledge about database platforms and independently leads the implementation for high priority and complex enterprise databases. Coordinate and lead the definition of database backup/recovery and security strategies. Responsible for mentoring and training other database administrators, managing task assignments for junior database administrators, reviewing work and providing input to performance reviews.

MAIN RESPONSIBILITIES:
Predicting capacity needs
Iterative tuning to optimize performance
Monitoring system performance and tuning appropriately
Proactive examining the system for improvements
Updating schemas as needed

MAJOR TASKS, RESPONSIBILITIES AND KEY ACCOUNTABILITIES - Review physical database structures using complex technical skills based on physical design for development, test, and production environments. Responsible for complex database performance tuning, security, database backup/recovery strategy, and implementing monitoring procedures to maximize availability of the database. Mentoring and training of other database administrators, managing task assignments for associate database administrators, reviewing work and providing input to Manager. Implement monitoring procedures to maximize availability and performance of the database, while meeting defined targets. Provide consultation to application development teams on DBMS product technical issues, techniques and SQL review. Coordinate with system engineers to configure servers for DBMS product installation and complex database creation. Configure and maintain DBMS product software on complex database and application servers.

NATURE AND SCOPE - Typically reports to Manager, Information Technology No associates report to this role on a permanent basis, but requires the leadership of a work group: assign and review work, train and contribute to performance appraisal (but not hiring, firing or disciplinary action).

ENVIRONMENTAL JOB REQUIREMENTS - Located in a comfortable indoor area. Any unpleasant conditions would be infrequent and not objectionable. Typically requires overnight travel less than 10% of the time.EDUCATION REQUIRED - The knowledge, skills and abilities typically acquired through the completion of a high school diplomas and/or GED.

YEARS OF RELEVANT WORK EXPERIENCE - 8

PHYSICAL JOB REQUIREMENTS - Most of the time is spent sitting in a comfortable position and there is frequent opportunity to move about. On rare occasions there may be a need to move or lift light articles.

PREFERRED QUALIFICATIONS - 

Oracle 10, Monitoring, Performance Tuning
Golden gate expertise
- Oracle RAC certification
- Oracle Master certification
Experience with large system support

KNOWLEDGE, SKILLS, ABILITIES AND COMPETENCIES - Expert knowledge of the complete software development life cycle. Significant experience with operating systems software, networking tools, application development and multidimensional tools. Expert knowledge of relational databases, logical modeling, and data warehouse. Ability to work independently with minimal direction. Ability to communicate to a wide variety of technical audiences. Ability to lead and mentor others.