IT Database Analyst

Job Summary

Provides increasingly complex cross‑functional strategic, analytical and technical support for database‑related activities while working under some supervision. Performs activities as directed by management and senior staff to support projects that require DBA staff involvement. Assists in problem identification and issue resolution. As needed, works with IT project teams and technical staff to collect, clarify and translate project requirements into required database design.

• Provides continuous support and education to IT analysts and development staff to ensure DB best practices are used in all projects.
• Ensures optimum performance and efficient use of system resources for new applications by monitoring application processes during development and production installs.
• Regularly monitors DB system and alerts DBAs, capacity or tech teams of potential issues.
• Develops solutions to improve the effectiveness of the processes and procedures used by DBA staff and documents improvements.
• Following DBA guidelines and best practices for backup and recovery, ensures data integrity for assigned applications by designing backup procedures with consideration for quick onsite recovery and disaster recovery at an offsite location.
• Supports testing, implementation and break‑fix troubleshooting and root cause analysis.
• Participates in the testing of the database system when new releases or maintenance is applied to the RDBMS and related software and identifies and documents issues.
• Performs other duties as assigned.

• Bachelor’s degree in Computer Science, Business or related field or equivalent experience.
• Six years of experience in database analysis and design concepts.

• Mid to senior Oracle E‑Business Suite application database administrator with experience in operational DBA work.
• Expertise in upgrading, patching, performance tuning and strong EBS knowledge.
• Familiarity with EBS purging functionality.
• Ability to do independent research and find solutions on their own.
• Experience with GL wand (plus).
• Excellent troubleshooting skills and ability to work in a team environment.
• Extensive knowledge of both the EBS application and database with version 19C.
• General overall Oracle DBA experience with VLDB (very large databases) in a production environment.
• Available for on‑call rotational shift bi‑weekly.
• EBS patching experience required.
• Ability to work in a fast‑paced environment with minimal direction.
• Good knowledge of Unix (preferably AIX).

• Solid understanding of software development methodologies including Waterfall and Agile.
• Advanced SQL coding and operating systems skills.
• Advanced understanding of logical and physical database design concepts.
• Solid analytical, problem‑solving and time‑management skills.
• Strong technical writing skills.
• Advanced understanding of Database Management System software.

• Overall responsibility for DB system, including but not limited to tuning, performance, maintenance, backup and recovery, OS compatibility and issue resolution.
• Coordinates activities with Capacity, Tech Support, DASD/SAN Admin, Server/Desktop Support and IT operations.
• Provides continuous support and education to IT analysts and development staff to ensure DB best practices are used in all projects.
• Ensures optimum performance and efficient use of system resources for applications.
• Develops solutions to improve the effectiveness of the processes and procedures used by DBA staff and documents improvements.
• Following DBA guidelines and best practices for backup and recovery, ensures data integrity for assigned applications by designing backup procedures with consideration for quick onsite recovery and disaster recovery at an offsite location.
• Supports testing, implementation and break‑fix troubleshooting and root cause analysis.
• Participates in the testing of the database system when new releases or maintenance is applied to the RDBMS and related software and identifies and documents issues.
• Performs other duties as assigned.

• Bachelor’s degree in Computer Science, Business or related field or equivalent experience.
• Eight years of experience in database analysis and design concepts.

• Solid understanding of software development methodologies including Waterfall and Agile.
• Advanced SQL coding and operating systems skills.
• Advanced understanding of logical and physical database design concepts.
• Advanced analytical, problem‑solving and time‑management skills.
• Advanced technical writing skills.
• Advanced understanding of Database Management System software.