Title:
Oracle and SQL Server Database Administrator Location:
Remote initially, transitioning to on-site (Pomona, CA or Downtown Los Angeles, CA).
Hire Type:
Contract Job Description:
Senior Oracle Apps DBA with 10 plus years of IT Industry experience with strong emphasis in Oracle database as well as the ability to function as a SQL Server DBA. Support change management including maintenance across multiple environments and deploying approved patches. Support security/SOX Audit Reporting and provide input and recommendations. Provide production and operational support, and on call duties. Creating users, tablespaces, logs, Performance tuning, Upgrades, Capacity management, Auto Config
- Disaster Recovery, Backup and Cloning, Security Technical Patch Management.
Oracle Enterprise Manager, Oracle ADI, XML, and Publisher and Workflow Hands on experience with
AD Utilities:
ADOP, Adadmin, Adpatch, Adconfig, dctrl, Adsplice & Adrelink Single Sign-On implementation of Oracle eBusiness Suite Must have extensive DBA experience with Oracle eBusiness Suite Version 12.2 and above.
SQL Server Administration:
Develop, implement and optimize stored procedures and functions Research required data
- Build appropriate and useful reporting deliverables Analyze existing SQL queries for performance improvements Suggest new queries for continuous systems improvement Detailed knowledge of SQL Server Experience and knowledge of high availability and disaster recovery solutions including Failover Cluster Instances, Availability Groups, Database Mirroring, Log Shipping, and backups and restores
Environment:
Oracle EBS 11i, Oracle EBS 12.2.9 and up
- Oracle Real Application Clusters 12c,19c, 11gR2
- Linux OS and Windows OS
- Grid Control
- Toad, SQL Developer iAS, Forms, Reports, PL/SQL, Java, Enterprise Manager, SOA, WebLogic and JVM, SSO, DataGuard SQL Server Databases, MS
- SQL•Fog light•Spotlight•GitHub•T-SQL•Replication•SQL Server 2017 and up