What are the responsibilities and job description for the Oracle Database Administrator position at Randstad Digital Americas?
Job Summary
The Customer is seeking the services of an experienced consultant to work as a Database Administrator to work with the Department's ISA, Enterprise Database Management Team to support Oracle Databases.
Tasks, Responsibilities and Activities
The Database Administrator will function as an integrated member of the Enterprise Data Management Team and will provide database support while working on assigned project and tasks and provide database support in the Modernization Project.
Duties
The resource will be responsible for operational duties and assisting with the administration of the Department's Enterprise Oracle Databases and shall perform, at a minimum, the tasks and/or activities described below:
Database administration in a large Oracle UNIX-based production environment including assisting Department staff, as directed by the Contract Manager, with the following:
All stages of database implementation and deployment.
Analysis, review, coordination, and implementation of new database requests.
Monitoring, troubleshooting, and resolving database performance issues or related problem resolution.
Provide direct support for Oracle databases as assigned by the Contract Manager;
Setting up database user accounts.
Verifying backup and recovery plans to protect the database against data loss and reconstruct the data if loss occurs.
Participating in design and planning of database and related database objects
Ensure that the logical data model design adheres to the Department's standards based upon best practices and guidelines;
Coordinate and deploy application changes, including Procedural Language/ Structured Query Language (PL/SQL) object and data model changes, to production databases following industry best practices and Department policies and procedures;
Write Structured Query Language (SQL), PL/SQL, Oracle Stored Procedures, Functions, Packages and Database Triggers, as required, to augment security and performance requirements of application development;
Write and use custom scripts and processes to handle data loads, data cleansing, and data migration to include migrations to and from multiple data sources and types such as Access, SQL server, Excel, flat files, and different Oracle database versions including Oracle version 19c;
Run diagnostic tools to identify database performance issues and take appropriate corrective actions to improve database performance;
Work with development teams to tune SQL queries;
Ensure that the associated hardware resources allocated to the databases result in high availability and optimum performance as defined by the Department;
Design, implement, and maintain database maintenance scripts, including replication and monitoring;
Perform daily operational duties, including monitoring, statistical analysis, and troubleshooting of performance issues using appropriate and Department approved tools and scripts;
Design and maintain automated processes including DBA jobs, DBA scheduler, and CRON scripts
Experience
Knowledge, Skills, and Abilities (KSA's)
10 years of experience as a Database Administrator with Oracle, PL/SQL
2 years of experience with Oracle 19c Multi-Tenant Architecture and database infrastructure design on RAC Databases
Experience in Red Hat Linux & Oracle Linux Operating Systems.
Experience in following processes and procedures to standardize Database installations and configuration
Experience automating, scripting, and streamlining processes for efficiency and accuracy utilizing Unix shell scripting or other scripting tools
Broad experience in the art of performance tuning, utilizing OEM or third-party tools to finely tune objects and queries in Oracle 19c
Comprehensive understanding of Oracle backup methodologies.
Monitor alert logs, OEM and system alerts, and acting on the results
Willingness to participate in after-hours Production support.
Proficiency in Linux, Unix, Java, and DBA
Understanding of production environments, technical support, and troubleshooting
Knowledge of Automatic Storage Management (ASM)
Experience with Oracle Exadata
Experience working in UNIX operating system
Ability to write simple to complex Linux/Unix shell scripts and Perl scripts
Strong knowledge in Unix/Linux System administration
Ability to work independently and to resolve complex Oracle
issues
Experience with data pump and working knowledge to use expdp and impdp
Ability to effectively diagnose, isolate, and resolve complex problems pertaining to data infrastructure
Ability to write, SQL, PL/SQL, Oracle Stored Procedures functions, Packages and Database Triggers
Ability to Tune Oracle SQL and PL/SQL performance
Experience in logical database design and data models
Understanding of the software development lifecycle process
Practical experience in monitoring and tuning a database to provide a high availability service
location: Tallahassee, Florida
job type: Contract
salary: $60 - 75 per hour
work hours: 8am to 5pm
education: No Degree Required
Responsibilities
The Customer is seeking the services of an experienced consultant to work as a Database Administrator to work with the Department's ISA, Enterprise Database Management Team to support Oracle Databases.
Tasks, Responsibilities And Activities
Experience:
10 years of experience as a Database Administrator with Oracle, PL/SQL
2 years of experience with Oracle 19c Multi-Tenant Architecture and database infrastructure design on RAC Databases
Experience in Red Hat Linux & Oracle Linux Operating Systems.
Experience in following processes and procedures to standardize Database installations and configuration
Experience automating, scripting, and streamlining processes for efficiency and accuracy utilizing Unix shell scripting or other scripting tools
Broad experience in the art of performance tuning, utilizing OEM or third-party tools to finely tune objects and queries in Oracle 19c
Comprehensive understanding of Oracle backup methodologies.
Monitor alert logs, OEM and system alerts, and acting on the results
Willingness to participate in after-hours Production support.
Proficiency in Linux, Unix, Java, and DBA
Understanding of production environments, technical support, and troubleshooting
Knowledge of Automatic Storage Management (ASM)
Experience with Oracle Exadata
Experience working in UNIX operating system
Ability to write simple to complex Linux/Unix shell scripts and Perl scripts
Strong knowledge in Unix/Linux System administration
Ability to work independently and to resolve complex Oracle
issues
Experience with data pump and working knowledge to use expdp and impdp
Ability to effectively diagnose, isolate, and resolve complex problems pertaining to data infrastructure
Ability to write, SQL, PL/SQL, Oracle Stored Procedures functions, Packages and Database Triggers
Ability to Tune Oracle SQL and PL/SQL performance
Experience in logical database design and data models
Understanding of the software development lifecycle process
Practical experience in monitoring and tuning a database to provide a high availability service
Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.
At Randstad Digital, we welcome people of all abilities and want to ensure that our hiring and interview process meets the needs of all applicants. If you require a reasonable accommodation to make your application or interview experience a great one, please contact HRsupport@randstadusa.com.
Pay offered to a successful candidate will be based on several factors including the candidate's education, work experience, work location, specific job duties, certifications, etc. In addition, Randstad Digital offers a comprehensive benefits package, including: medical, prescription, dental, vision, AD&D, and life insurance offerings, short-term disability, and a 401K plan (all benefits are based on eligibility).
This posting is open for thirty (30) days.
The Customer is seeking the services of an experienced consultant to work as a Database Administrator to work with the Department's ISA, Enterprise Database Management Team to support Oracle Databases.
Tasks, Responsibilities and Activities
The Database Administrator will function as an integrated member of the Enterprise Data Management Team and will provide database support while working on assigned project and tasks and provide database support in the Modernization Project.
Duties
The resource will be responsible for operational duties and assisting with the administration of the Department's Enterprise Oracle Databases and shall perform, at a minimum, the tasks and/or activities described below:
Database administration in a large Oracle UNIX-based production environment including assisting Department staff, as directed by the Contract Manager, with the following:
All stages of database implementation and deployment.
Analysis, review, coordination, and implementation of new database requests.
Monitoring, troubleshooting, and resolving database performance issues or related problem resolution.
Provide direct support for Oracle databases as assigned by the Contract Manager;
Setting up database user accounts.
Verifying backup and recovery plans to protect the database against data loss and reconstruct the data if loss occurs.
Participating in design and planning of database and related database objects
Ensure that the logical data model design adheres to the Department's standards based upon best practices and guidelines;
Coordinate and deploy application changes, including Procedural Language/ Structured Query Language (PL/SQL) object and data model changes, to production databases following industry best practices and Department policies and procedures;
Write Structured Query Language (SQL), PL/SQL, Oracle Stored Procedures, Functions, Packages and Database Triggers, as required, to augment security and performance requirements of application development;
Write and use custom scripts and processes to handle data loads, data cleansing, and data migration to include migrations to and from multiple data sources and types such as Access, SQL server, Excel, flat files, and different Oracle database versions including Oracle version 19c;
Run diagnostic tools to identify database performance issues and take appropriate corrective actions to improve database performance;
Work with development teams to tune SQL queries;
Ensure that the associated hardware resources allocated to the databases result in high availability and optimum performance as defined by the Department;
Design, implement, and maintain database maintenance scripts, including replication and monitoring;
Perform daily operational duties, including monitoring, statistical analysis, and troubleshooting of performance issues using appropriate and Department approved tools and scripts;
Design and maintain automated processes including DBA jobs, DBA scheduler, and CRON scripts
Experience
Knowledge, Skills, and Abilities (KSA's)
10 years of experience as a Database Administrator with Oracle, PL/SQL
2 years of experience with Oracle 19c Multi-Tenant Architecture and database infrastructure design on RAC Databases
Experience in Red Hat Linux & Oracle Linux Operating Systems.
Experience in following processes and procedures to standardize Database installations and configuration
Experience automating, scripting, and streamlining processes for efficiency and accuracy utilizing Unix shell scripting or other scripting tools
Broad experience in the art of performance tuning, utilizing OEM or third-party tools to finely tune objects and queries in Oracle 19c
Comprehensive understanding of Oracle backup methodologies.
Monitor alert logs, OEM and system alerts, and acting on the results
Willingness to participate in after-hours Production support.
Proficiency in Linux, Unix, Java, and DBA
Understanding of production environments, technical support, and troubleshooting
Knowledge of Automatic Storage Management (ASM)
Experience with Oracle Exadata
Experience working in UNIX operating system
Ability to write simple to complex Linux/Unix shell scripts and Perl scripts
Strong knowledge in Unix/Linux System administration
Ability to work independently and to resolve complex Oracle
issues
Experience with data pump and working knowledge to use expdp and impdp
Ability to effectively diagnose, isolate, and resolve complex problems pertaining to data infrastructure
Ability to write, SQL, PL/SQL, Oracle Stored Procedures functions, Packages and Database Triggers
Ability to Tune Oracle SQL and PL/SQL performance
Experience in logical database design and data models
Understanding of the software development lifecycle process
Practical experience in monitoring and tuning a database to provide a high availability service
location: Tallahassee, Florida
job type: Contract
salary: $60 - 75 per hour
work hours: 8am to 5pm
education: No Degree Required
Responsibilities
The Customer is seeking the services of an experienced consultant to work as a Database Administrator to work with the Department's ISA, Enterprise Database Management Team to support Oracle Databases.
Tasks, Responsibilities And Activities
- The Database Administrator will function as an integrated member of the Enterprise Data Management Team and will provide database support while working on assigned project and tasks and provide database support in the Modernization Project.
- The resource will be responsible for operational duties and assisting with the administration of the Department's Enterprise Oracle Databases and shall perform, at a minimum, the tasks and/or activities described below:
- Database administration in a large Oracle UNIX-based production environment including assisting Department staff, as directed by the Contract Manager, with the following:
- All stages of database implementation and deployment.
- Analysis, review, coordination, and implementation of new database requests.
- Monitoring, troubleshooting, and resolving database performance issues or related problem resolution.
- Provide direct support for Oracle databases as assigned by the Contract Manager;
- Setting up database user accounts.
- Verifying backup and recovery plans to protect the database against data loss and reconstruct the data if loss occurs.
- Participating in design and planning of database and related database objects
- Ensure that the logical data model design adheres to the Department's standards based upon best practices and guidelines;
- Coordinate and deploy application changes, including Procedural Language/ Structured Query Language (PL/SQL) object and data model changes, to production databases following industry best practices and Department policies and procedures;
- Write Structured Query Language (SQL), PL/SQL, Oracle Stored Procedures, Functions, Packages and Database Triggers, as required, to augment security and performance requirements of application development;
- Write and use custom scripts and processes to handle data loads, data cleansing, and data migration to include migrations to and from multiple data sources and types such as Access, SQL server, Excel, flat files, and different Oracle database versions including Oracle version 19c;
- Run diagnostic tools to identify database performance issues and take appropriate corrective actions to improve database performance;
- Work with development teams to tune SQL queries;
- Ensure that the associated hardware resources allocated to the databases result in high availability and optimum performance as defined by the Department;
- Design, implement, and maintain database maintenance scripts, including replication and monitoring;
- Perform daily operational duties, including monitoring, statistical analysis, and troubleshooting of performance issues using appropriate and Department approved tools and scripts;
- Design and maintain automated processes including DBA jobs, DBA scheduler, and CRON scripts
Experience:
10 years of experience as a Database Administrator with Oracle, PL/SQL
2 years of experience with Oracle 19c Multi-Tenant Architecture and database infrastructure design on RAC Databases
Experience in Red Hat Linux & Oracle Linux Operating Systems.
Experience in following processes and procedures to standardize Database installations and configuration
Experience automating, scripting, and streamlining processes for efficiency and accuracy utilizing Unix shell scripting or other scripting tools
Broad experience in the art of performance tuning, utilizing OEM or third-party tools to finely tune objects and queries in Oracle 19c
Comprehensive understanding of Oracle backup methodologies.
Monitor alert logs, OEM and system alerts, and acting on the results
Willingness to participate in after-hours Production support.
Proficiency in Linux, Unix, Java, and DBA
Understanding of production environments, technical support, and troubleshooting
Knowledge of Automatic Storage Management (ASM)
Experience with Oracle Exadata
Experience working in UNIX operating system
Ability to write simple to complex Linux/Unix shell scripts and Perl scripts
Strong knowledge in Unix/Linux System administration
Ability to work independently and to resolve complex Oracle
issues
Experience with data pump and working knowledge to use expdp and impdp
Ability to effectively diagnose, isolate, and resolve complex problems pertaining to data infrastructure
Ability to write, SQL, PL/SQL, Oracle Stored Procedures functions, Packages and Database Triggers
Ability to Tune Oracle SQL and PL/SQL performance
Experience in logical database design and data models
Understanding of the software development lifecycle process
Practical experience in monitoring and tuning a database to provide a high availability service
Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.
At Randstad Digital, we welcome people of all abilities and want to ensure that our hiring and interview process meets the needs of all applicants. If you require a reasonable accommodation to make your application or interview experience a great one, please contact HRsupport@randstadusa.com.
Pay offered to a successful candidate will be based on several factors including the candidate's education, work experience, work location, specific job duties, certifications, etc. In addition, Randstad Digital offers a comprehensive benefits package, including: medical, prescription, dental, vision, AD&D, and life insurance offerings, short-term disability, and a 401K plan (all benefits are based on eligibility).
This posting is open for thirty (30) days.
Salary : $60 - $75