Job Summary Provide analysis, design, deployment, and technical administration support for database and oracle application environments that are used to support the Laboratory\'s operations and mission processes. Evaluates and configure complex application system components and the supporting database and operating system functions. Analyzes and respond to a variety of complex issues that require in-depth theoretical, technical and functional knowledge. Concentrated efforts towards Business Intelligence, Integrations, and the ability to support large analytical databases. Required skills in Oracle Middleware and Oracle Databases, including administration and support Oracle Business Intelligence Enterprise Edition (OBIEE), Essbase, SQL Server, Hyperion, Informatica, Oracle E-Business Suite, Oracle RDBMS, and Oracle Fusion Middleware Servers. Additionally, knowledge of related tools and support for Change & Release Management, Security and Compliance, PL\\SQL, Query and System Performance Tuning, Data Backups & Recovery. Responsibilities Participates in both daily and off-hours administration and support, monitoring database system performance, assisting with critical or emergency failures as a primary technical subject matter expert. Responsible for updates, patches, continuity plans and on-going maintenance for databases, application servers and third party software packages. Contributes to production support and project teams and provides clear and updated project task status to stakeholders, management and team members. Contributes to design and architecture of platform and functional solutions, change and release processes, developer support, and security and compliance auditing. Understands business requirements and determines database and configuration requirements for implementing applications using industry standard best practices. Functions as primary liaison for Oracle Support and related Third Party Vendor support. Responsible for change and release management for code and configuration deployments (both custom/in house developed and third party). Contributes to the design, implementation, and continuous improvement of DBA and Information Technology processes and standards that meet compliance, quality assurance, and auditing needs. Effectively balances multiple competing priorities and work activities. Frequently is a liaison between vendors, developers, clients, and management. Enhances customer service and relationships between clients, management, and technical staff. Maintains a high level of understanding of the Laboratorys application environments and technical infrastructure. Evaluates new hardware, software, systems tools and applications Required Qualifications (at least 8 years practical, hands on experience with the following): Database Administration and support for Oracle R11 & R12 RDBMS, Oracle Fusion Middleware, Hyperion, Oracle E-Business Suite, Oracle Business Intelligence Enterprise Edition (OBIEE), Essbase, SQL Server, Hyperion, and Informatica. Security compliance and requirements for moderate level financial and business data, including HIPPA, Oracle wallet configuration, encryption keys and support for content and transport encryption using SSL, SSH, PGP, SFTP, and other related tools. In-depth administration knowledge of operating systems and system support functions on a cross platform environment including Linux and Microsoft Windows Server, shell scripting and automation. Administration, deployment, and support of client and server side Java installations, including security, patching, and integration testing. Experience utilizing source code change control tools such as subversion/GIT and knowledge of best practices of software configuration and schema change management. Strong experience working with third party support infrastructure (i.e., My Oracle Support) and working issues through third party technical support organization. SQL and PL/SQL development (including data architecture and tables, views, procedures, packages, triggers, schemas). An emphasis in performance tuning queries and application systems, working with developers to create needed functionality with proper performance. Required Education, Experience, And Skills Relevant Bachelor\'s Degree and 14 or more years of experience or equivalent relevant education/experience. Or, relevant Master\'s Degree and 12 or more years of experience or equivalent relevant education/experience. Or, relevant PhD and 9 or more years of experience or equivalent relevant education/experience. Applies extensive IS expertise and has full knowledge of related disciplines. Contributes to the development of new principles and concepts. Superior leadership and project management skills. Skilled in analytical techniques, practices and problem solving. Extensive architecture and design for various computer software programs and information systems. Preferred Qualifications Experience with Oracle Enterprise Grid Control Experience with Oracle Authentication mechanisms for integration with LDAP / Single Sign On. Familiarity with API architecture and related data formats (XML/XML tables, JSON, REST, and other transformations) Familiarity with unstructured data management solutions (Document Management, Mongo, Cassandra, etc.). Microsoft SQL Server and Reporting Server Administration and support Familiarity with additional development languages and scripting: shell, groovy, php, java, PowerShell, JavaScript, etc. Excellent leadership and communication skills. Submission Guidelines Please note that in order to be considered an applicant for any position you must submit an application form for each position for which you believe you are qualified. Applications are not kept on file for future positions. Please include a cover letter and resume with each position application. EEO Policy we are dedicated to the principles of equal employment opportunity. we promotes a work environment that does not discriminate against workers or job applicants and prohibits unlawful discrimination on the basis of race, color, religion, sex, national origin, disability, age, marital status, ancestry, actual or perceived sexual orientation, or veteran status, including special disabled veterans. we validates right to work using E-Verify. we will provide the Social Security Administration (SSA) and, if necessary, the Department of Homeland Security (DHS), with information from each new employees Form I-9 to confirm work authorization. For additional information, click here . Seniority Level
Key Skills: