Oracle Database Administrator Salary in Iowa, USA

Job Summary The Lead Financial Systems Analyst is responsible for administering our EBS environment (General Ledger, Fixed Assets, Accounts Payable). This position will be responsible for creating new and modifying existing complex allocations ensuring data integrity, research, database and financial report troubleshooting. This position is responsible for owning tools (EBS, GL wand) and the patching, testing, upgrades, and training for those tools. This position will also own several audit controls and interface with internal and external audit. The Lead Financial Systems Analyst reports directly to the Director of Financial Systems. The department interacts actively with the various functional areas in the company both in order to obtain input for its analysis and reporting, and to provide output and comments for other department's reporting initiatives, including recommendations for improvements in reporting controls and efficiency. Duties and Responsibilities Design, development and implementation of software programs for Oracle EBS, specifically General Ledger, Payables and Assets. Develop information and analysis in support of management reporting including the development of new reports and recommendations for enhanced reporting. Identifies process improvements with a focus on improved quality, efficiency or controls. Prepare analysis of financial data related to operations, business performance, opportunities and investments. Leads projects defined as Corporate/Finance objectives for the Finance department. Mentor finance members in the development/implementation of data collection and reporting initiatives. Summarize and escalate significant data reporting issues and bugs as required. Provide backup to financial systems team members (interface support, database management), to ensure the accuracy and availability of critical financial database applications. Create and maintain documentation on system / reporting environment for internal team use. Work with Financial Systems team members to maximize Oracle, Tableau and other financial systems reporting and accounting functionality and capabilities. Lead efforts to work cross functionally with Finance, Tax, Actuarial, Investment and Accounting teams to develop effective reporting and delivery of data and analysis in order to improve the entire organizations functionality and effectiveness. Manage working relationships with IT staff and Third-Party Administrators to maintain an efficient and stable Oracle environment. Work with the business to derive business requirements, contributes to solution design, prototyping, testing, and deployment of Configuration/Customization, Extension, Modification, Localization and Integration (CEMLI) and Forms customizations to Oracle EBS and performs application configuration in support of the stated business requirements and solution designs. Provide technical support for the Oracle infrastructure management, including allocation development, maintenance and troubleshooting. Provides functional subject matter experience, and application development support for the Oracle EBS implementation, enhancements and upgrade projects. Translate business and functional requirements into technical approach, solution, and technical design specifications. Analyze and troubleshoot complex system and user issues, coordinate issue resolution efforts across peer support groups, technical support teams, and vendors as needed. Experience and Education Requirements Bachelor's degree in Accounting, Finance, Business Administration or Information Systems 5+ years overall business experience with a minimum of 3 years working in an accounting/finance environment Experience in report development, including experience with Microsoft products Experience administering financial applications such as Oracle EBS, Oracle Fusion Cloud Financials, SAP, Great Plains, PeopleSoft, etc.; general ledger experience is strongly preferred Willingness and aptitude to learn additional applications such as Tableau, Alteryx, etc. Skills and Abilities Ability to produce in a fast-paced environment while addressing multiple projects and responsibilities Strong system knowledge including familiarity with current era of client-server accounting/financial packages Strong interpersonal and communication (verbal and written) skills Highly motivated and demonstrated ability to take initiative Ability to work both independently and as part of a team with professionals at all levels Experience with understanding key data Ability to successfully work on multiple tasks/projects to meet critical deadlines Strong organizational and time management skills Proficiency in Microsoft Office Suite (e.g., Excel, Word) Demonstrated ability to maintain confidentiality Ability to create complete and accurate documentation of work performed Strong problem solving skills Other Requirements Perform other functions, duties and projects as assigned Regular and punctual attendance Minimal travel required (less than 10%) #IND-HP #LI-MK1 #LI-RemoteAdditional Information Work Environments F&G believes in an employee-centric flexible environment, which is why we offer the ability for in-office, hybrid and remote work arrangements. During the hiring process, you'll work with your leader to decide what works best for your role. F&G complies with federal and state disability laws and makes reasonable accommodations for applicants and candidates with disabilities, unless such accommodation would cause an undue hardship for F&G. If reasonable accommodation is needed to participate in the job application or interview process, please contact [email protected]. Join our employee-centric hybrid work environment: F&G Careers About F&G Since 1959, Fidelity & Guaranty Life Insurance Company (F&G) has offered annuity and life insurance products to those who are seeking security in retirement and protection during life's unexpected events. As a national Top Workplace1, an Iowa Top Workplace2 and a proud equal opportunity employer, F&G team members are empowered, collaborative, dynamic and authentic. We believe that by embracing these values, we will continue to build and strengthen the company while continuing to be a great place to work. 1Top Workplaces USA 2022 - 2023 2Des Moines Register Top Workplaces 2018 - 2022 Notice for all Applicants who are California residents under the California Privacy Rights Act. Please click here to review the policy.

The College of Public Health Department of Information Technology is seeking a Senior Systems Administrator to be responsible for the design, configuration, administration, security, operational integrity, support, and integration of diverse systems in an enterprise environment, including both cloud computing and on-premises resources. This position performs complex administrative tasks and collaborates effectively with other IT staff across the University of Iowa in support of the College of Public Health. Analysis and Design: Evaluate technology and tools and recommends buying decisions for departments, centers, research projects, and outreach programs in the College of Public Health. Include budget and regulatory requirements in analysis. Implement infrastructure and system design changes within the College of Public Health IT environment. Evaluate and implement changes in an enterprise environment to improve efficiency in the College of Public Health, optimize system performance, and ensure compliance with security policies and best practices. Develop complex Puppet Enterprise configurations for servers, Linux workstations, and cloud environments. Design and implement complex high-availability web services in both cloud and on-premises virtual environments. Design and maintain diverse Collegiate Linux systems, including servers and workstations. Implementation (Installation, Configuration, Integration). Perform advanced and complex systems administration tasks such as hardware setup and upgrades, software upgrades, system backups, and preventive maintenance on College of Public Health servers and firewalls. Manage, maintain and monitor automated operating system and software patching, including the development of scripts and enterprise software configurations for all College of Public Health servers. Develop and maintain a secure environment for College of Public Health servers and data in both cloud and on-premises environments, including the management of file system access control lists, Cisco ASA firewalls, and processes for identity authentication. Configure, maintain, and monitor collegiate backup/restore servers and software, including Veeam Backup software and Amazon cloud backup services. Develop, manage and maintain College of Public Health software licensing and asset management databases. Build, install, and configure Linux software from source files when necessary. Manage Shibboleth Service Provider in cloud environment and integrate with ITS Shibboleth Identity Provider. Maintain, configure, and integrate various services with database engines, including Microsoft SQL Server, Oracle Database, MySQL, and Amazon Aurora. Configure CI/CD pipelines and integrate with complex infrastructure. Implement infrastructure as code (IAC) designs across on-premises and cloud environments to configure many systems in a consistent and reliable manner. Documentation: Write, maintain, and audit documentation relating to College of Public Health servers and server administration processes. Maintain public knowledgebase to assist end-users and IT staff with common support questions and complex configurations. Assist in developing and writing DR/BC plans for mission-critical collegiate services, including shared network file systems and web services. Develop cost estimates, service agreements, and memorandums of understanding (MoU) for administrative and research projects. Assist researchers in reviewing and writing data use agreements. Support: Provide direct support to both end users and other technical support staff on advanced issues involving processes and software used within the College. Support end users from other colleges and UI Healthcare, as well as users external to the University, in technical issues involving Collegiate services and research projects. Create complex system scripts and/or programs to diagnose and solve systems administration challenges within the College of Public Health IT environment. Maintain and extend automation of Active Directory security groups and e-mail distribution lists according to the business requirements of the College. Support Active Directory security groups and Amazon IAM users, groups, and policies for user rights delegation and system access. Maintain security by implementing principle of least privilege (PoLP) in access granted to users and systems. Support MECM and Puppet Enterprise environments for the College of Public Health. Provide on call support for critical issues and complex problems. Monitor uptime of critical services and configure alerts for issues which may impact operations. Support enterprise VMware cluster environment. Relationship Management (Vendor/Customer). Interface directly with hardware and software vendors at the University and collegiate levels. Serve as a mediator between end-users and product or service vendors. Communicate with end-users regarding pertinent system changes within the College. Leadership: Mentor and train peer staff in the areas of networking, security, scripting, version control, and cloud computing. Develop and deliver presentations to senior management in the College and peer groups in the University. Participate in University-wide campus communities such as the IT Admins, Linux Admins, and AWS Users Group. Lead projects to successful outcomes by setting direction, delegating tasks, and engaging with Collegiate/University/external resources as necessary. Participate in the planning process for developing operating procedures, guidelines, and policies at a collegiate level. Collaborate with peers across the University to find ways to enhance research and IT services in the College of Public Health. Identify shifting trends in technology and align with forward thinking strategies.Required Qualifications: A bachelor's degree in Engineering, MIS, or Computer Science or equivalent combination of education and related experience. Minimum of 5 years of experience managing Windows Server operating systems, including Server Core configurations. Minimum of 5 years of experience with Microsoft Active Directory computer administration. Minimum of 3 years of experience in Microsoft Group Policy administration. Minimum of 5 years of experience with backup and restore tools in an enterprise environment. Minimum of 3 years of experience managing virtual server environments, such as VMware vSphere and Microsoft Hyper-V. Desired Qualifications: Minimum of 3 years of experience configuring, deploying, and maintaining Linux operating systems, including Ubuntu, CentOS, and Amazon Linux. Minimum of 5 years of experience with command line scripting languages. Minimum of 3 years of experience utilizing Cloud Services, such as Amazon Web Services and Microsoft Azure. Application Details: To be considered for an interview, applicants must upload a resume and cover letter and mark them as a "Relevant File" to the submission. Job openings are posted for a minimum of 14 calendar days and may be removed from posting and filled any time after the original posting period has ended. Successful candidates will be required to self-disclose any conviction history and will be subject to a criminal background check and credential/education verification. Up to five professional references will be requested at a later step in the recruitment process. This position is eligible for hybrid work, within Iowa and will require a work arrangement form to be completed upon the start of your employment. Per policy, work arrangements will be reviewed annually, and must comply with the remote work program and related policies and employee travel policy when working at a remote location.Additional Information Classification Title: Senior Systems Administrator Appointment Type: Professional and Scientific Schedule: Full-time Work Modality Options: On Campus, Hybrid within Iowa Compensation Pay Level: 5B Contact Information Organization: College of Public Health Contact Name: Janet Duncan Contact Email: [email protected]

Required Skills:Bachelors Degree5+ years experience in database administrationStrong background in data warehouse management and data integrationExpertise in Microsoft SQL ServerExperience with Integration Services (SSIS), Reporting Services (SSRS), and Analysis Services (SSAS)Skilled with Power BI and other business intelligence toolsProven experience in data visualization and dashboard creationStrong understanding of ETL processes, performance tuning, and SQL query optimizationExperience with cloud technologies (Azure) and managing hybrid database environmentsDesired Skills:Experience working in fast past/high demand environmentsExperience supporting implementation and post-implementation troubleshootingDescription of Role/Responsibilities:We are seeking an experienced Database Administrator to oversee the performance, integrity, and security of all databases. The person in this role will play a key part in the management and maintenance of both on-prem and cloud databases. This role will be responsible for building enterprise data lakehouse and warehouse, establishing robust data connections, and creating data gateways across multiple sources. This role will work closely with system engineers, data analysts, and project managers. If you are a strong DBA and team player looking for a new role with an outstanding organization this could be the perfect opportunity!Beacon Hill is an Equal Opportunity Employer that values the strength diversity brings to the workplace. Individuals with Disabilities and Protected Veterans are encouraged to apply.If you would like to complete our voluntary self-identification form, please click here or copy and paste the following link into an open window in your browser: https://jobs.beaconhillstaffing.com/eeoc/Completion of this form is voluntary and will not affect your opportunity for employment, or the terms or conditions of your employment. This form will be used for reporting purposes only and will be kept separate from all other records.Company Profile:Beacon Hill Technologies, a premier National Information Technology Staffing Group, provides world class technology talent across all industries utilizing a complete suite of staffing services. Beacon Hill Technologies' dedicated team of recruiting and staffing experts consistently delivers quality IT professionals to solve our customers' technical and business needs.Beacon Hill Technologies covers a broad spectrum of IT positions, including Project Management and Business Analysis, Programming/Development, Database, Infrastructure, Quality Assurance, Production/Support and ERP roles.Learn more about Beacon Hill Staffing Group and our specialty divisions, Beacon Hill Associates, Beacon Hill Financial, Beacon Hill HR, Beacon Hill Legal, Beacon Hill Life Sciences and Beacon Hill Technologies by visiting www.beaconhillstaffing.com .We look forward to working with you.Beacon Hill. Employing the Future (TM)