Senior Database Administrator

Job Description:  Senior Database Administrator

 

The Senior Database Administrator is responsible for leading the design and implementation of databases, monitoring and maintaining existing databases, resolving complex database issues, optimizing performance, and implementing protocols for disaster recovery and security. This may include providing task direction, mentoring, and project management to other team members.

 

Job Responsibilities:

 

- Pro-actively maintain database performance by monitoring space, CPU usage, fragmentation of data and by tuning queries, etc. Assist other IT staff with complex problems and analyze and resolve issues using database tools.

 

- Determine, implement, and oversee the need for database maintenance and communicate/coordinate with affected customers, minimizing business interruption wherever possible.

 

- Provide 24x7 customer response to requests for support on database performance issues. Provide advice, task direction, and guidance to others and correct and communicate resolution through appropriate channels.

 

- Recommend long-term technology solutions in accordance with an understanding of the methodology, architecture, and business needs of the organization.

 

- Work with other IT staff, System Engineers, Software Developers, and appropriate parties to coordinate integration and ensure compatibility of hardware, operating systems, database tools, and applications.

- Ensure database integrity by developing, documenting, communicating, managing and enforcing protocols involving changes to database structure, data, procedures, and user access.

- Develop, communicate, and carry out procedures designed to facilitate recovery from database failure, such as backups, recovery, archiving, and exports.

- Collaborate with project teams to evaluate new database needs. Review the proposed logical and physical database models, and participate in creation of the final database structure as necessary.

 

Requirements

 

Education:Applicable Bachelor’s degree requiredExcellent written and verbal communication skills are required

Work Experience must demonstrate:

§  5+ years experience with Oracle as a DBA.
(Oracle 9i or 10g on Unix OS, Solaris preferred)

§  Full knowledge of and experience with Oracle 9i

§  Experience with scripting of stored procedures using PL*SQL, SQL*PLUS, shell scripting.

§  Oracle software installation and upgrade

§  Database performance monitoring and tuning

§  Database backup and recovery

§  Database troubleshooting and problem resolution

§  Database capacity planning, physical database design and implementation

§  Must also be capable of working independently with a minimum amount of supervision

 

Desired Skills:

§  Knowledge of the following: Microsoft SQL Server databases would be a plus.

§  Experience with Oracle RAC would be a plus