Oracle DBA

Duties performed will include, but not be limited to the following:

• Hands on, end to end administrator of the Oracle 10g/11g database platforms. Participates in complete application lifecycle management process including the planning, design, development, maintenance, and management of multi-terabyte databases in a 24/7 support environment.
• Participates in the development of long-term database strategies and objectives, standards and procedures for enterprise-wide systems.
• Helps ensure that the transactional databases have stable operating environments which consist of a high degree of data integrity, availability, performance, and recoverability.
• Monitors and maintains physical database structures for data integrity, database performance, quality, and recoverability, maintenance, and space requirements to maintain optimal service levels.
• Tunes the databases to meet service level agreements and ensures the effective utilization of enterprise system resources.
• Researches, evaluates, and coordinates software releases, system upgrades, enhancements, and software updates to ensure that client specifications and best practice guidelines are met.
• Encourages adoption of industry standards and best practices in support of very large databases and clustering on Oracle RAC 10g/11g databases.
• Standardizes database environments and evaluates reusability of current data for additional analysis, while maintaining integrity and confidentiality of information.
• Supports the team responsible for architecture, design, creation, monitoring, troubleshooting, and administration of all new and existing database systems.
• Ensures alignment with enterprise IT operations, applications development, and IT business units to understand and interpret on-going business needs, storage and reporting requirements, and emerging trends.
• Implements strategies and data models that translate business requirements into acceptable database designs.
• Database design deployments include the development of base definitions, structure, documentation, long-range requirements, and operational guidelines.
• Assists in enhancing governance and supports adoption of guidelines on data quality, stewardship, and data ownership.
• Supports the development, implementation, and monitoring of operational standards; including policies and procedures for database application development and database programming.
• Administrator maintains up-to-date knowledge of the following: DBMS internals and how they work in an OLTP environment; DBMS optimization and how queries and updates execute in an OLTP; writing of scripts to perform database administration functions; backup and recovery using backup scripts and Oracle Recovery Manager; and, security / access requests including verification and granting permissions.
• Follows change control policies and procedures.
• Attends conferences and develops relationships with professional organizations, peer groups, and industry trade groups to remain current on emerging technology and industry trends