NexGen Data Systems
Senior Oracle Database Administrator
NexGen Data Systems, Hanahan, South Carolina, United States,
NexGen Data Systems is seeking a Senior Oracle DBA to create, update, configure, manage, and administer databases for Oracle 12c - 19c environments. The ideal candidate must be able to create, edit and execute scripts to process data and perform software updates. You will be required to create instances with the ability to modify control files, redo logs, archive log and other parameters as required. This role will be relied on to provide IT project management guidance/input and expertise for projects and special projects as needed. The candidate must be able to integrate DBMS(s) data with existing application software, websites, portals, storage devices, or business applications as well as assisting and testing Disaster Recovery (DR) and Continuity of Operations Plans (COOP). The position will have a strong focus on performance tuning. Must have an extensive knowledge in database performance tuning in both data center and cloud environments.
Roles and Responsibilities:
Install, configure, and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security Perform scheduled maintenance and support release deployment activities Configure and document security measures as required by DoD Security Technical Implementation Guides (STIGs) Refine and automate regular processes, track issues, and document changes Provide 24x7 support for critical production systems Create, update, configure, manage, and administer databases for Oracle 12c - 19c environments. Create, edit, and execute scripts to process data and perform software updates. Create instances with the ability to modify control files, redo logs, archive log and other parameters as required. Provide IT project management guidance/input and expertise for projects and special projects as needed. Integrate DBMS(s) data with existing application software, websites, portals, storage devices, or business applications Assist and test Disaster Recovery (DR) and Continuity of Operations Plans (COOP). Conduct performance tuning activities using various Oracle tools and database metrics. Review PL/SQL packages, procedures, functions for performance issues. Implement oracle security features such as fips140 communication and DoD CAC/PKI authentication for Oracle products. Other Duties:
Please note this job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee for this job. Duties, responsibilities and activities may change at any time with or without notice.
Requirements
Desired/Required Skills:
5+ years of advanced database performance tuning. Experience in analyzing and determining cause/solutions of wait events. Experience with Oracle performance monitoring tools such as AWR to include capturing and analyzing reports. Secret clearance or higher preferred 8570 compliance (Active Security and OS certifications) Ability to write simple to complex PL/SQL queries along with ability to understand execution plan of existing ones and adjust them as needed. Previous experience with installation, configuration, and tuning of Middleware; Deploying EAR & WAR files. Experience with Solaris, Linux, and Windows Administration ideal. Comfortable with High Availability and Disaster Recovery technologies. Experience using RMAN to perform various database backups and recover databases from backups including partials, point in time, and full recovery. Experience cloning databases using RMAN and Data Pump Ability to handle implementing, configuring, and monitoring Oracle Data Guard, including standby reporting databases with little to no assistance. Experience encrypting SQL traffic between clients and database, including thick clients and data sources. Knowledge of implementing database authentication using common access cards and Oracle wallets required. Experience implementing Oracle auditing processes including Oracle Unified Auditing. 5-7 years' experience with monitoring, analyzing server logs, and configuring additional logging. Experience engaging with Oracle Corporation for technical support. Experience with Oracle Advanced Security, Oracle Fusion Architecture, RAC, and ASM. Familiarity with Oracle Database development is a plus. Senior level proficiency in key systems (minimal training required) Must have an extensive knowledge in database performance tuning in both data center and cloud environments (AWS Preferred). Experience administering SQL Server/ DB is a plus. About the Company:
NexGen Data Systems is an emerging technologies focused company providing expert systems and network engineering solutions to the Department of Defense. NexGen Data Systems promotes a culture of knowledge and career advancement through continued learning, keeping our team current on the latest advances in systems and networking, and enabling our team to provide the best available solutions to our clients.
Benefits:
Company covers 100% of premiums for the employee's medical, dental, and vision insurance and subsidizes premiums for spouse and dependents. Company provides short and long term disability plans. 401(k) match up to 10% of the employee's salary contributions to 401(K) plan. Comprehensive training and development program. 11 paid holidays and paid time off (PTO) accrual level starts at 15 days annually.
All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or protected veteran status.
NOTE: US Citizens and those authorized to work in the US are encouraged to apply. In order to be qualified for this position, you must be able to obtain and maintain a United States Department of Defense (DoD) security clearance. We are unable to sponsor Visas at this time. NexGen Data Systems provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, gender, sexual orientation, national origin, age, disability, marital status, amnesty, or status as a covered veteran in accordance with applicable federal, state and local laws.
Roles and Responsibilities:
Install, configure, and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security Perform scheduled maintenance and support release deployment activities Configure and document security measures as required by DoD Security Technical Implementation Guides (STIGs) Refine and automate regular processes, track issues, and document changes Provide 24x7 support for critical production systems Create, update, configure, manage, and administer databases for Oracle 12c - 19c environments. Create, edit, and execute scripts to process data and perform software updates. Create instances with the ability to modify control files, redo logs, archive log and other parameters as required. Provide IT project management guidance/input and expertise for projects and special projects as needed. Integrate DBMS(s) data with existing application software, websites, portals, storage devices, or business applications Assist and test Disaster Recovery (DR) and Continuity of Operations Plans (COOP). Conduct performance tuning activities using various Oracle tools and database metrics. Review PL/SQL packages, procedures, functions for performance issues. Implement oracle security features such as fips140 communication and DoD CAC/PKI authentication for Oracle products. Other Duties:
Please note this job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee for this job. Duties, responsibilities and activities may change at any time with or without notice.
Requirements
Desired/Required Skills:
5+ years of advanced database performance tuning. Experience in analyzing and determining cause/solutions of wait events. Experience with Oracle performance monitoring tools such as AWR to include capturing and analyzing reports. Secret clearance or higher preferred 8570 compliance (Active Security and OS certifications) Ability to write simple to complex PL/SQL queries along with ability to understand execution plan of existing ones and adjust them as needed. Previous experience with installation, configuration, and tuning of Middleware; Deploying EAR & WAR files. Experience with Solaris, Linux, and Windows Administration ideal. Comfortable with High Availability and Disaster Recovery technologies. Experience using RMAN to perform various database backups and recover databases from backups including partials, point in time, and full recovery. Experience cloning databases using RMAN and Data Pump Ability to handle implementing, configuring, and monitoring Oracle Data Guard, including standby reporting databases with little to no assistance. Experience encrypting SQL traffic between clients and database, including thick clients and data sources. Knowledge of implementing database authentication using common access cards and Oracle wallets required. Experience implementing Oracle auditing processes including Oracle Unified Auditing. 5-7 years' experience with monitoring, analyzing server logs, and configuring additional logging. Experience engaging with Oracle Corporation for technical support. Experience with Oracle Advanced Security, Oracle Fusion Architecture, RAC, and ASM. Familiarity with Oracle Database development is a plus. Senior level proficiency in key systems (minimal training required) Must have an extensive knowledge in database performance tuning in both data center and cloud environments (AWS Preferred). Experience administering SQL Server/ DB is a plus. About the Company:
NexGen Data Systems is an emerging technologies focused company providing expert systems and network engineering solutions to the Department of Defense. NexGen Data Systems promotes a culture of knowledge and career advancement through continued learning, keeping our team current on the latest advances in systems and networking, and enabling our team to provide the best available solutions to our clients.
Benefits:
Company covers 100% of premiums for the employee's medical, dental, and vision insurance and subsidizes premiums for spouse and dependents. Company provides short and long term disability plans. 401(k) match up to 10% of the employee's salary contributions to 401(K) plan. Comprehensive training and development program. 11 paid holidays and paid time off (PTO) accrual level starts at 15 days annually.
All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or protected veteran status.
NOTE: US Citizens and those authorized to work in the US are encouraged to apply. In order to be qualified for this position, you must be able to obtain and maintain a United States Department of Defense (DoD) security clearance. We are unable to sponsor Visas at this time. NexGen Data Systems provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, gender, sexual orientation, national origin, age, disability, marital status, amnesty, or status as a covered veteran in accordance with applicable federal, state and local laws.