Oracle and SQL Server Database Administrator (Senior)
Job Location:
Los Angeles, CA - USA
Monthly Salary:
Posted on:
Vacancies:
Job Summary
Location: Remote initially; transitioning to on-site (Pomona or Downtown Los Angeles)
Work Schedule: Part-Time (0.5 FTE 20 hours/week MondayFriday)
Availability: Must be available for weekends and holidays for emergencies and special projects
Background
The Authority is seeking qualified technology professionals to support internal computing systems enterprise applications and infrastructure. This role supports ongoing operations maintenance enhancements and staff augmentation as well as targeted one-off initiatives. The selected candidate will provide database administration support across Oracle and SQL Server environments.
Position Overview
We are seeking a Senior Oracle Apps DBA with cross-platform expertise in SQL Server to support enterprise database environments. This role requires strong experience in Oracle E-Business Suite (EBS) database administration performance tuning high availability and production support along with the ability to operate across both Oracle and Microsoft SQL Server platforms.
Required Experience & Qualifications
- 7 years of IT experience with a strong emphasis on Oracle database administration to include:
- 1 year DBA experience supporting Oracle E-Business Suite (EBS) 12.2
- 2 years of experience functioning as a SQL Server DBA
- 7 years of database administration best practices change management and production support
- 2 years of experience supporting SOX compliance and audit reporting
- 2 years of experience in tools and technologies including:
- Oracle Enterprise Manager ADI XML Publisher Workflow
- AD Utilities: ADOP ADADMIN ADPATCH ADCONFIG DCTRL ADSPLICE ADRELINK
- 2 years of experience with Single Sign-On (SSO) implementation for Oracle EBS
- 2 years of experience in performance tuning troubleshooting and database optimization
Oracle DBA Responsibilities
- Provide production and operational support including on-call duties
- Manage database environments including:
- User creation tablespaces and logs
- Performance tuning and capacity management
- AutoConfig and configuration management
- Execute patch management including testing and deployment across multiple environments
- Manage backup recovery cloning and disaster recovery strategies
- Support security compliance and audit reporting (SOX)
- Administer Oracle EBS environments including workflow integrations and technical components
SQL Server DBA Responsibilities
- Develop and optimize stored procedures and functions
- Analyze and improve existing SQL queries for performance
- Design and build data queries and reporting deliverables
- Provide recommendations for continuous system improvements
- Administer SQL Server environments including:
- High availability and disaster recovery solutions
- Failover Cluster Instances
- Availability Groups
- Database Mirroring
- Log Shipping
- Backup and restore processes
Oracle Technologies
- Oracle EBS 11i and EBS 12.2.9
- Oracle Real Application Clusters (RAC): 11gR2 12c 19c
- Oracle Grid Control / Enterprise Manager
- Oracle Forms Reports PL/SQL Java
- SOA WebLogic JVM
- DataGuard SSO
- Tools: Toad SQL Developer
SQL Server Technologies
- SQL Server 2017
- T-SQL Replication
- Monitoring Tools: Foglight Spotlight
- GitHub (source control and collaboration)
Operating Systems
- Linux
- Windows
Soft Skills
- Strong problem-solving and analytical thinking
- Ability to operate independently and manage priorities across environments
- Effective communication and stakeholder collaboration skills
Working at ICF
ICF is a global advisory and technology services provider but were not your typical consultants. We combine unmatched expertise with cutting-edge technology to help clients solve their most complex challenges navigate change and shape the future.We can only solve the worlds toughest challenges by building a workplace that allows everyone to thrive. We are an equal opportunity employer.Together our employees are empowered to share theirexpertiseand collaborate with others to achieve personal and professional goals. For more information please read ourEEOpolicy.
We will consider for employment qualified applicants with arrest and conviction records.
Reasonable Accommodations are available including but not limited to for disabled veterans individuals with disabilities and individuals withsincerely heldreligious beliefs in all phases of the application and employment process. To requestan accommodationplease emailand we will be happy toassist. All information you provide will be kept confidential and will be used only to the extentto provide needed reasonable accommodations.
Read more aboutworkplacediscriminationrightsor our benefit offerings which are included in theTransparency in (Benefits) CoverageAct.
At ICF we are committed to ensuring a fair interview process for all candidates based on their own skills and knowledge. As part of this commitment the use of artificial intelligence (AI) tools to generate orassistwith responses during interviews (whether in-person or virtual) is notpermitted. This policy is in place tomaintainthe integrity and authenticity of the interview process.
However we understand that some candidates may require accommodationthat involves the use of AI. Ifsuch anaccommodation is needed candidates are instructed to contact us in advance at. Weare dedicated to providingthe necessary support to ensure that all candidates have an equal opportunity to succeed.
Pay Range - There are multiple factors that are considered in determining final pay for a position including but not limited to relevant work experience skills certifications and competencies that align to the specified role geographic location education and certifications as well as contract provisions regarding labor categories that are specific to the position.
The pay range for this position based on full-time employment is:
$118807.00 - $201971.00California Client Office (CA88)Required Experience:
Unclear Seniority
About Company
About ICF: The Integral Coach Factory is one of the earliest production units of independent India. It was inaugurated by the first Prime Minister of India Pt. Jawaharlal Nehru on 2nd October, 1955. Later the Furnishing Division was inaugurated on 2nd October, 1962 and the production ... View more
