Oracle Database Administrator Stf

Oracle Database Administrator Stf

Req ID 223058BR
Industry Job Title Oracle Database Administrator Stf
Standard Job Code/Title E4824:Database Administrator Stf
Required skills Demonstrated Oracle 11g Database Administration experience in a Unix Environment
Experience tuning Oracle 11G databases and queries
Experience providing Database Administration of an Oracle Data warehouse
Solid understanding of Data warehousing principles and methodology, including design, dimensional data models, data dictionaries and metadata.
Ability to articulate complex concepts in a clear concise fashion, both verbally and in writing.
Work cooperatively with internal team members, external project stakeholders, infrastructure architects and system administrators. Develop and maintain database and design documentation.
Understand the logical and conceptual relationship of data and the needs of a complex application.
Develop innovative, efficient database solutions to complex business problems.
Desired skills Familiarity with Informatica or other ETL tools
Familiarity with the MicroStrategy BI tool
Experience with very large databases in a Business Intelligence environment.
Strong Hands-on experience using data modeling tools, preferably ER/Win
At least 5 years of experience as a database administrator in an Oracle environment with at least one year using Oracle 11g. 5 years of experience in data modeling and design
Specific Job Description The Oracle Administrator will lead or assist in the development, configuration, and ongoing operations & maintenance of multiple Oracle database environments. The candidate will leverage years of experience to tune the Oracle databases and make recommendations in the area of database management and performance. The candidate will support internal database users, such as the development and testing teams by providing consulting support on all aspects of the Oracle infrastructure including participating in peer reviews and walkthroughs.

The Oracle Administrator will also be expected to collaborate with the design team to analyze and understand Business/Functional requirements in order to design, model, develop, validate, and implement logical and physical data models including both relational and dimensional models in a data warehousing environment.
Standard Job Description Implements and maintains smooth operation and physical design of databases. Reviews database design and integration of systems, provides backup recovery and makes recommendations regarding enhancements and/or improvements. Maintains security and integrity controls. Formulates policies, procedures, and standards relating to database management, and monitors transaction activity and utilization. Responsibilities include: database loading; development and management of operational procedures; environment management; database health (e.g. monitoring, proactive and reactive responses); resource planning; database upgrade planning; backup and recovery strategy planning and implementation; environment transition planning (development, test, stage, production).
Security Clearance Public Trust
Typical Minimums Bachelors degree from an accredited college in a related discipline, or equivalent experience/combined education, with 10 years of professional experience; or 8 years of professional experience with a related Masters degree. Considered an emerging authority.
LMCareers Business Unit ESS0997 IS&GS-CIVIL (S8200)
Business Area Info Systems & Global Sol
Program CMS CCS
Department 8284024:CMS CCS
Job Class Information Technology
Job Category Experienced Professional
State Maryland
Relocation Available No
Work Schedule STANDARD-Mon-Fri/8 hours a day
Req Type Full-Time
Direct/Indirect Direct
Shift First