Sr. Oracle Database Administrator
The Customer seeks an experienced Advanced Database Analyst for the Bureau of Application Development Services to supplement existing staff and be responsible for designing, modeling, developing, and supporting Database Management Systems (DBMS) and other supporting systems.
Database Analyst Responsibilities:
1. The Advanced Database Analyst(s) will be responsible for operational duties and assisting with the administration of the Enterprise Oracle Databases and shall perform, at a minimum, the below tasks and/or activities:
A. Database administration in a large Oracle (12c and 19c) Solaris-based production environment, including assisting staff, as directed by the Contract Manager or Functional Manager, with the following:
1) All stages of database implementation and deployment.
2) Analysis, review, coordination, and implementation of new database requests.
3) Monitoring, troubleshooting, and resolving database performance issues or related problem resolution.
4) Provide administration and support of Oracle WebLogic, Oracle Forms, and Oracle Reports.
5) Provide maintenance and support of server hardware with Sun Solaris operating systems.
B. Provide direct support for Oracle databases as assigned by the Contract Manager.
C. Ensure the logical data model design adheres to the standards based on best practices and guidelines.
D. 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.
E. Write 12c and 19c 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.
F. Write and use custom scripts and processes to handle data loads, data cleansing, and data migration, including migrations to and from multiple data sources and types, such as Access, SQL Server, Excel, flat files, and different Oracle database versions.
G. Run diagnostic tools to identify database performance issues and take appropriate corrective actions to improve database performance.
H. Work with development teams to tune SQL queries and improve performance.
I. Ensure that the associated hardware resources allocated to the databases result in high availability and optimum performance.
J. Design, implement, and maintain database maintenance scripts, including replication and monitoring.
K. Perform daily operational duties, including monitoring, statistical analysis, and troubleshooting performance issues using appropriate and approved tools and scripts.
L. Design and maintain automated processes, including DBA jobs, DBA scheduler, and CRON scripts.
M. Attend and participate in all assigned meetings.
N. Attend required training; and,
O. Complete a Project Report and a Project Timesheet every week.
Minimum Qualifications:
1) Ability to communicate effectively (verbally and in writing) with staff.
2) At least ten (10) years of IT business/industry work experience.
3) At least five (5) years of Oracle Database Management Systems administration.
4) Experience with Sun Solaris operating systems and Oracle WebLogic.
5) A minimum of five (5) years supporting multiple services and multiple databases of medium to high complexity with multiple concurrent users, ensuring control, integrity, and accessibility of data.
Preferred Experience:
1) Oracle Database Administration Certified Professional
2) Experience leading the planning, design, development, implementation, and maintenance of Oracle Relational Database Management Systems.
3) Experience leading the installation, configuration, and maintenance of Sun Solaris operating systems and Oracle WebLogic.
4) Experience working in a Unix environment.
5) Extensive experience diagnosing, isolating, and resolving complex problems with the database infrastructure.
6) Extensive experience writing PL/SQL, SQL, and Oracle Stored Procedures, Functions, Packages, and Database Triggers.
7) Extensive experience in designing logical databases and data models.
8) Knowledge of data privacy and protection initiatives.
9) Strong communication and collaboration skills.
10) Excellent verbal and written communication skills.
Educational qualifications meeting at least one of the following levels:
1) A minimum of a bachelor's degree in one of the computer sciences fields or management information systems or five years of work experience in information technology, systems analysis, management analysis, program planning, program research, or program evaluation.
Additional Details :
Projected Start Date: 2025-04-01T00:00:00
Projected End Date 2025-12-31T00:00:00
The Customer seeks an experienced Advanced Database Analyst for the Bureau of Application Development Services to supplement existing staff and be responsible for designing, modeling, developing, and supporting Database Management Systems (DBMS) and other supporting systems.
Database Analyst Responsibilities:
1. The Advanced Database Analyst(s) will be responsible for operational duties and assisting with the administration of the Enterprise Oracle Databases and shall perform, at a minimum, the below tasks and/or activities:
A. Database administration in a large Oracle (12c and 19c) Solaris-based production environment, including assisting staff, as directed by the Contract Manager or Functional Manager, with the following:
1) All stages of database implementation and deployment.
2) Analysis, review, coordination, and implementation of new database requests.
3) Monitoring, troubleshooting, and resolving database performance issues or related problem resolution.
4) Provide administration and support of Oracle WebLogic, Oracle Forms, and Oracle Reports.
5) Provide maintenance and support of server hardware with Sun Solaris operating systems.
B. Provide direct support for Oracle databases as assigned by the Contract Manager.
C. Ensure the logical data model design adheres to the standards based on best practices and guidelines.
D. 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.
E. Write 12c and 19c 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.
F. Write and use custom scripts and processes to handle data loads, data cleansing, and data migration, including migrations to and from multiple data sources and types, such as Access, SQL Server, Excel, flat files, and different Oracle database versions.
G. Run diagnostic tools to identify database performance issues and take appropriate corrective actions to improve database performance.
H. Work with development teams to tune SQL queries and improve performance.
I. Ensure that the associated hardware resources allocated to the databases result in high availability and optimum performance.
J. Design, implement, and maintain database maintenance scripts, including replication and monitoring.
K. Perform daily operational duties, including monitoring, statistical analysis, and troubleshooting performance issues using appropriate and approved tools and scripts.
L. Design and maintain automated processes, including DBA jobs, DBA scheduler, and CRON scripts.
M. Attend and participate in all assigned meetings.
N. Attend required training; and,
O. Complete a Project Report and a Project Timesheet every week.
Minimum Qualifications:
1) Ability to communicate effectively (verbally and in writing) with staff.
2) At least ten (10) years of IT business/industry work experience.
3) At least five (5) years of Oracle Database Management Systems administration.
4) Experience with Sun Solaris operating systems and Oracle WebLogic.
5) A minimum of five (5) years supporting multiple services and multiple databases of medium to high complexity with multiple concurrent users, ensuring control, integrity, and accessibility of data.
Preferred Experience:
1) Oracle Database Administration Certified Professional
2) Experience leading the planning, design, development, implementation, and maintenance of Oracle Relational Database Management Systems.
3) Experience leading the installation, configuration, and maintenance of Sun Solaris operating systems and Oracle WebLogic.
4) Experience working in a Unix environment.
5) Extensive experience diagnosing, isolating, and resolving complex problems with the database infrastructure.
6) Extensive experience writing PL/SQL, SQL, and Oracle Stored Procedures, Functions, Packages, and Database Triggers.
7) Extensive experience in designing logical databases and data models.
8) Knowledge of data privacy and protection initiatives.
9) Strong communication and collaboration skills.
10) Excellent verbal and written communication skills.
Educational qualifications meeting at least one of the following levels:
1) A minimum of a bachelor's degree in one of the computer sciences fields or management information systems or five years of work experience in information technology, systems analysis, management analysis, program planning, program research, or program evaluation.
Additional Details :
Projected Start Date: 2025-04-01T00:00:00
Projected End Date 2025-12-31T00:00:00