What are the responsibilities and job description for the Senior Operational Oracle DBA position at ASSYST?
ASSYST is seeking a Senior Operational Oracle DBA to support our client project in Austin, TX.
This position is Remote
Position Summary:
We are seeking a Senior Operational Oracle DBA to ensure the stability, security, patching, and scalability of critical database environments supporting multiple concurrent ERP implementations and upgrades. The primary responsibility is to design and execute database upgrades from Oracle 19c to Oracle 23ai and maintain multiple environments that support ETL activities.
This position requires hands-on experience with Oracle Grid Infrastructure, high-availability solutions, database security compliance, performance tuning, and advanced scripting. The role may require working outside standard business hours based on project activities.
Key Responsibilities:
- Administer, maintain, and monitor enterprise Oracle database environments.
- Design, implement, and support Oracle database upgrades and migrations, including Oracle 19c to Oracle 23ai.
- Install, configure, and maintain Oracle Grid Infrastructure, including ASM and Clusterware.
- Implement and support high-availability and disaster recovery solutions using Oracle GoldenGate and Active Data Guard.
- Monitor database performance and perform performance tuning to improve system efficiency and scalability.
- Analyze database storage requirements and implement appropriate search and storage strategies.
- Design, develop, and maintain logical and physical data models and relational database structures.
- Ensure data integrity, minimize redundancy, and support database loading, reorganization, and optimization activities.
- Execute database backup, recovery, and restoration procedures to protect against hardware and software failures.
- Implement and maintain database security controls, vulnerability remediation, and compliance standards.
- Support disaster recovery planning, testing, and operational readiness.
- Create and maintain test database environments, libraries, and procedures for application development and testing.
- Evaluate requests for new data elements and database enhancements and provide technical guidance to stakeholders.
- Collaborate with application developers, analysts, and business users to assess the impact of database changes.
- Maintain data dictionaries, standards, and documentation to ensure consistency and governance.
- Assist with database software evaluation, benchmarking, threshold testing, and technology selection.
- Provide technical support and troubleshooting for database-related issues and user inquiries.
- Develop and maintain automation scripts using Linux shell scripting and SQL.
Required Qualifications:
- Experience administering Oracle Database 19c or higher.
- Strong experience with Oracle Grid Infrastructure (ASM, Clusterware).
- Experience with Oracle high-availability technologies, including GoldenGate and Active Data Guard.
- Advanced Linux and SQL scripting skills.
- Experience with database performance tuning, backup/recovery, and security administration.
- Knowledge of database design, data modeling, systems analysis, and database management principles.
- Understanding of database security, disaster recovery, and vulnerability management practices.
- Knowledge of computer programming, systems design, and project estimation methodologies.
Accessibility Requirements:
- Working knowledge of EIR Accessibility standards and assistive technologies.
- Ensure database administration interfaces and data input/output processes comply with accessibility standards.
- Provide support to users when accessibility-related issues impact access to data or reports.
- Preferred Qualifications
- Experience working with Federal, State, or Local Government organizations.
- Experience working with hosting vendors or managed service providers.
- Experience supporting Oracle PeopleSoft environments.
ASSYST is an Equal Opportunity Employer. Qualified applicants will receive consideration for employment without regard to race, color, religion, sex, age, disability, military status, national origin or any other characteristic protected under federal, state, or applicable local law