Oracle Pl Sql Developer Jobs in Alabama (NOW HIRING)

Pay Grade/Pay Range:  Minimum: $74,200 - Midpoint: $100,200 (Salaried E12)

Department/Organization: 200721 - Enterprise Technology

Normal Work Schedule: Monday - Friday 8:00am to 5:00pm

Note to Applicants: Position is eligible for hybrid work subject to University policy.

Job Summary: The Programmer Analyst IV designs, develops, supports, and codes high-complexity and enterprise software systems to support the administrative function of the University under minimal supervision. Develops processes and web applications. Creates workflows. Installs, customizes, supports, and creates integrations for vendor-supplied software systems. Works on a team and collaborates with specific departments, colleges, and customers around campus. Supports their needs, troubleshooting and resolving issues, and responding to their questions and concerns in a timely manner.

Additional Department Summary: This lead-level position is a part of the IT Collaboration & Reporting team, which primarily designs, supports, and develops data integration platforms, reporting infrastructures, and automation solutions. The team develops reporting solutions utilizing tools such as Microsoft Fabric and Power BI, and Argos; develops processes utilizing Atlassian's Cloud Suite; and supports vendor-supplied software systems, including Visix Signage Suites and the Boomi iPaaS. This position is expected to be both the primary and secondary support person for various applications and processes. Additionally, this position is expected to act as a mentor and help train lower-level team members and be the technical lead on projects of moderate to high complexity.

Required Minimum Qualifications: Master's degree and four (4) years of IT programming experience; OR bachelor's degree and six (6) years of IT programming experience; OR associate's degree and eight (8) years of IT experience to include six (6) years of IT programming; OR high school diploma or GED and ten (10) years of IT experience to include six (6) years of IT programming.

Skills and Knowledge: The applicant must have: An aptitude for solving problems, being self-motivated, desire to learn and improve skills, resourceful, finding ingenious solutions, and managing highly complex assignments and systems. High level of experience supporting complex systems and troubleshooting application issues. High level of experience with working with customers, gathering and analyzing requirements. Expert level experience with relational databases and ability writing and analyzing SQL queries and reports; preferably with Oracle, MS SQL, or MySQL; and ability to analyze table data structures and patterns in the data to gain insights. Expert level experience with the creation and management of database and data warehouse objects including tables, triggers, indexes, and procedures and processes, including SSIS. Substantial level of programming knowledge and ability, with languages such as Oracle PL/SQL and scripting languages such as Python. High level of experience with ETL tools and data management principles.
Additionally, in order to be successful, the applicant must have: The ability to effectively communicate, both verbally and in writing, and work with customer groups and users of varying degrees of technical ability and understanding. The ability to manage work tasks using Atlassian JIRA tickets and follow through to completion. Have effective time management skills and ability to work on multiple projects simultaneously. Troubleshooting skills to independently learn of, analyze, track, and resolve issues. The ability to implement critical third-party applications, analyzing installation and configuration documentation, to successfully install and take on support for an application. Familiarity with ETL/ELT processes and other data warehousing techniques. Familiarity with data warehousing platforms such as MS Fabric, and reporting tools such as Power BI.

Preferred Qualifications: Expert level experience supporting University of Alabama administrative applications and tools, such as MS Fabric, Power BI, Atlassian Cloud Suite, or integration tools such as Boomi. Experience with advanced BI analytic concepts, including OLAP, data warehousing, data lakes, scaling and performance tuning, and dashboard design. Experience with other programming concepts and tools including restful APIs; shell, Powershell, and Python scripting; Git versioning; and managing flat file data feeds.

Background Investigation Statement: Prior to hiring, the final candidate(s) must successfully pass a pre-employment background investigation and information obtained from social media and other internet sources. A prior conviction reported as a result of the background investigation DOES NOT automatically disqualify a candidate from consideration for this position. A candidate with a prior conviction or negative behavioral red flags will receive an individualized review of the prior conviction or negative behavioral red flags before a hiring decision is made.