Position: Senior Oracle Database Administrator - EBS
Trisian-Global Consulting LLC is currently seeking a highly skilled and experienced Oracle Database Administrator to join our client's team in Memphis, TN . As an Oracle Database Administrator, you will maintain the integrity of data including the logical, physical design and implementation of databases. In this role, you'll be responsible for database management including the performance and recoverability of databases, application administration, patching and upgrades. This position will work closely with our Application, Operation and Security teams to build out future application roadmaps.
Qualifications: Bachelor's degree in computer science, IT or related field is required. 5+ years of hands-on experience as an Oracle EBS Applications DBA combined with Oracle Applications system administrator, Oracle WebLogic Administrator and related technologies to maintain, upgrade, and support a multi-node Oracle EBS database 12c/19c and Oracle ERP Application R12.2. Hands-on experience with scripting on Unix and Linux environments using Shell, Perl, SQL, PL/SQL. Knowledge in AIX v7.1/v7.2, Linux, IBM P series hardware, Storage Area Network, Rubrik maintenance is required. Experience in application monitoring using Grid Control and other tools is required. Experience in cloud migration is preferred. Strong analytical skills. Familiarity with Oracle EBS technical tools like Oracle Application Framework, BI/XML Reports, Java, JVM, JSP, Oracle Forms/Reports, Interfaces, Workflow etc. Technical and functional knowledge of the Oracle E-Business Suite. Web services (REST or SOAP) Development. Architecture (Cloud, Web Services, SOA). Self-starter and able to deliver results on a proactive and independent basis. Ability to work independently with limited general supervision.
Key Responsibilities: Develop and maintain both application and database tuning and connectivity standards, policies, and procedures, ensuring compliance with industry best practices and security regulations. Follows, defines and manages enterprise level policies and procedures that ensure the security, optimization and integrity of Oracle database environments. Manages database backup & recovery procedures, disaster recovery preparation and the associated exercises. Migrating code, database changes and data through the various stages of development. Database patching and upgrade support. Diagnoses/anticipates and resolves database performance, capacity and replication issues. Participates in client/project meeting(s) for needs assessment and design review. Manages database backup & recovery procedures, disaster recovery preparation and the associated exercises. Collaborates with SAN, server, applications and operational staff in support of database objectives. Manage Concurrent Programs, Request Sets, Request Groups, Workflows, and troubleshoot Workflow Mailer/Notification issues, and take care of user access. Use monitoring tools to proactively monitor systems and respond to various system generated alerts. Administer and maintain Single Sign- On for Oracle Applications. Utilize Applications DBA utilities to support/maintain the multi-node environment to tune and improve database performance. Administer and maintain the Oracle Service Oriented Architecture (SOA), Oracle WebLogic Server to support Oracle EBS system connectivity with integrated systems. Analyze Patches and build execution steps. Perform Oracle EBS Applications database administration (DBA) tasks including patching (adop cycle and opatch), cloning, creating backup/recovery strategies, upgrading, performance tuning. Setup DR environment and supporting periodic DR drills. Perform code and patch migration to non-prod and production environment using the deployed tool or manually by adhering to the set change control policies and procedures. Establish, contribute and adhere to all key departmental operating procedures around governance, project management, software lifecycle management, change management and provide oversight on key delivery of application topology solutions and enhancements as needed.
