Senior Database Analyst

McLane is one of the largest and most stable supply chain services leaders in the United States. We've been at the forefront of delivering retail and restaurant solutions for convenience stores, mass merchants, drug stores, and chain restaurants for over 125 years. Our vision is to be an agile, innovative, and unified supply chain partner that delivers a superior customer experience, improves the lives of our teammates and community, and produces best-in-class returns.
This is a hybrid remote position which will require the candidate to report and work from the office two days a week. Therefore, interested candidates should be within a 50-minute radius from Temple, Tx.
JOB DESCRIPTION:
This position installs and maintains Golden Gate and Oracle Databases software. They will provide guidance with Golden Gate deployments that allow for future growth. They will provide ongoing monitoring of the Golden Gate and Oracle Database environments. They will work with application development teams on various projects. They will manage service requests with Oracle support. Finally, they will review Golden Gate processes for Performance and assist with Database/SQL tunning.
ESSENTIAL JOB FUNCTIONS / PRINCIPAL ACCOUNTABILITIES:

• Install, Upgrade, and support Golden Gate software.
• Works with Oracle Database 19c and any future release.
• Identifies and solve complex problems proactively and lead effective solutions implementation.
• Performs system maintenance, Backup and Recover, support active Data Guard for DR, and quarterly patching.
• Continuously learns new tools and environments and acquire new skills to maintain and enhance job performance.
• Provides the appropriate implementation documentation for installs.
• Supports implementation and post-implementation activities.

MINIMUM QUALIFICATIONS & REQUIREMENTS:

• Bachelor's degree in computer science or equivalent experience
• Minimum of 5 years' experience working with Golden Gate and Oracle DB.
• Strong knowledge of OEM.
• A thorough knowledge of Oracle RDBMS 19c and above, including ASM, OEM, RMAN, Data Guard and Data Pump, all running on Exadata.
• Strong knowledge of Oracle Database monitoring and tuning using OEM and AWR.
• Strong knowledge of Database Backup and recovery using RMAN backups.
• Strong knowledge of SQL and PL/SQL.
• Strong knowledge of Linux Operating System, SUSE, RedHat, and Oracle Enterprise Linux with shell scripting knowledge.
• Identify and resolve poorly executing SQL (high reads/execution counts/extended runtimes).
• Working knowledge of Golden Gate is highly desirable.
• Excellent interpersonal and communication skills.
• Project Management and strong analytical skills are also desired.
• Experience in any of the following areas is a plus.

• • • Oracle E-Business Suite R12.2
    • Demantra Demand Planning
    • Oracle Access Manager
    • MS SQL Server
    • DB2
    • MongoDB, other non-relational databases.

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.