Oracle Database Administrator
Description
This position will be responsible for designing, implementing, and optimizing databases for companies proprietary operational support system. You will be tasked with all administration of the Oracle 10G RDBMS including Oracle RAC, Oracle Database Replication, Oracle Data Guard, Partitioning, backup/recovery, security/auditing, and performance tuning. You will also assist with the dispersal of data throughout the company via Microsoft SQL Server tools such as DTS, Reporting Services, and Analysis Services. Other responsibilities include SQL tuning, ERD documentation, data imports/exports, as well as planning and managing the database components of the software, patch management, upgrades and integration. Additionally, you will be responsible for the gathering and analysis of system metrics to better manage and keep aware of capacity issues especially in regards to Space, I/O and CPU utilization.
Your responsibilities include but are not limited to:
· Install and maintain Oracle 10g RAC primary and standby databases with Data Guard, RMAN, partitioning, AQ, etc. in 24x7 production environment
· Regular on-call rotation
· Troubleshoot and solve performance issues with OLTP and Data Warehouse databases
· Enforce change control management and database security
· Promote database best practices through collaboration, white papers, presentations, etc.
· Review data models, SQL, PL/SQL and pair with development and reporting teams in an agile environment
· Provide courteous customer service throughout the engineering department and other areas of the organization
Required Skills & Experiences
· BS in Computer Science or Engineering or equivalent education and experience
· Strong knowledge with Oracle 10g databases and appropriate new features
· 3+ years of Oracle database administration experience on Solaris and Linux
· Strong performance tuning skills and experience
· Solid knowledge and experience with shell, perl, SQL and PL/SQL
· Change management with versioning systems
· Team player with excellent verbal and written communication skills
· Ability to provide courteous customer service throughout the engineering department and other departments within the organization
· Strong attention to detail
· Ability to manage project and complete work with clear scope and deliverables
· Understanding of agile development methodologies
· Ability to carry a pager during on-call rotation and be available to work during maintenance windows is a must
· Some travel required
Email this Job