Database Administrator

Description

Business Job Description Strong Database Administration knowledge, Project Management skills, Analytical skills. Senior level database administrator with project management skills to assist the team lead with project and compliance work for the NA DBA team. Responsibilities are provided in the accountability section. Standard Job Description The maintenance of an indepth knowledge of a specific technical specialism in information systems, the support, the execution or supervision of specialized tasks directly involved in its application and the performance of related quality assurance activities. The subject of the technical specialism can be an IS technology, technique, method, product or application area. Business Requested Skills Excellent working knowledge of Oracle 10g internals and database administration tasks in association with the above listed purpose and accountabilities. Pior experience with either Sybase or MS SQL 3 plus years experience with Oracle 10g on the UNIX operating system. 3 plus years experience with UNIX shell scripting. Strong understanding of application and infrastructure technologies. Strong people and communication skills, required to solicit support and agreement to plans across diverse delivery groups and customers. Personal flexibility to accommodate situations outside normal working hours Prior experience with Oracle OEM, RAC, ASM technologies Previous significant work experience in a trading environment preferred Previous DBA leadership experience A Bachelors or Graduate University degree in a related field of studyPrevious experience with Application Architectures, Application Development, and/or Applications Support with emphasis on database technologies. Strong communication and negotiation skills to be able to influence others and speak with confidence to stake holders. Strong people skills required to collaborate and solicit support/agreement to plans across diverse delivery groups and customers to achieve business objectives. Standard Requested Skills Professional Standards, Help Desk Procedures, Corporate Quality Management System, Programming Standards, Operating Infrastructure, Databases, Hardware, Operating Systems, Proficient in National/International Standards, ISO 9000, Legislation, Business Proposals, Leadership skills. Role Accountability Assisting the team lead in managing, leading, coaching and developing the analysts on the database team as well as managing the team workload in order to achieve an effective, useful and versatile database environment. Providing primary support activities for all Shell Trading database systems, including the provision of 24x7 oncall support (problem/incident management). Provide user support and consultancy service to Trading Application and Infrastructure Developments teams and projects (i.e. assisting development in writing and tuning of SQL and PL/SQL code) Coordinate with DBMS vendor support services regarding database problems and issues. Coordinate requests of server resources with the server Systems Administration teams. Review releases, upgrades and fixes available from database software suppliers and subscribed security organizations and identify those which merit action. Install, configure, and test database and database related software patches, packages, and new releases. Perform and maintain database backups, recovery, and refreshes. Manage database capacity including capacity planning and monitoring usage limits. Perform and report database performance monitoring and fault monitoring. Coordinate with Application Development/Production