Description
POSITION PURPOSE - The Senior DBA will have the responsibility of supporting, troubleshooting issues and building the different oracle environments. This will involve working with data modelling and development teams. The role will involve the creation of new databases, replication across heterogeneous platforms, monitoring and managing database in production. There will be the need to perform tuning and SQL analysis.MAJOR TASKS, RESPONSIBILITIES AND KEY ACCOUNTABILITIES - Create physical mid-sized database structures based on physical design for development, test, and production environments. Partner with DBA's and provide guidance on lower level projects. Work with system engineers to configure servers for DBMS product installation and mid-sized database creation. Configure and maintain DBMS product software on mid-sized database and application servers. Provide guidance to application development teams on DBMS product technical issues, techniques and SQL review. Provide on-call support for databases 7 X 24 to include being able to investigate, troubleshoot and resolve database problems. Mentor and train other database administrators across lower level projects.
NATURE AND SCOPE - Typically reports to Manager, Information Technology Responsible for helping others and providing on-the-job training or guidance
YEARS OF RELEVANT WORK EXPERIENCE - 5 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 - Technical Skills: 5+ years of DBA experience with Oracle on UNIX Platforms; Candidate should show a logical approach to performance tuning and analysis of problems. Experience with Oracle 11g is required and an understanding of RAC, ADG and preferably Golden Gate would be beneficial. Experience with OEM 12c for is also a preferred skill set. The candidate should have experience working with consolidated database environments and have worked in a matrix organization. UNIX scripting is an advantage. Expert knowledge about database platforms and the ability to work in a group as well as independently is required to help drive the implementation and support of high priority and complex enterprise systems.
KNOWLEDGE, SKILLS, ABILITIES AND COMPETENCIES - Working knowledge of the complete software development life cycle. Proficient with operating systems software, networking tools, application development and multidimensional tools. Working knowledge of relational databases, logical modeling, and data warehouse. Ability to work independently with minimal direction.