Address
Form of work
SalaryICF is a leading provider of low-code, open-source and cloud native solutions to federal agencies, deploying over 1,300 technologists who have built and maintained over 700 systems for digital modernization projects. ICF combines public-sector domain expertise with an ecosystem of platform partners and digital practices to rapidly deliver complex, scalable solutions that achieve clients' mission outcomes and a step change in productivity.
The Team:
ICF’s Digital Modernization division is a leading information technology and management consulting department, providing integrated, strategic solutions to clients in both the public and private sectors. Within DMD, our dedicated professionals specialize in spearheading digital modernization efforts, facilitating a smooth transition from legacy systems to the cutting-edge Appian platform. Committed to enhancing efficiency, agility, and user experience, we are at the forefront of transformative initiatives, ensuring our clients thrive in the evolving digital landscape.
The Work:
As a member of the team, you will be responsible for building a thorough understanding of the client’s database architecture, data, and operational needs. You will be responsible for building, managing, operating, and continuously improving database and tools infrastructure in support of a Federal client.
As the Senior Oracle Database Administrator, you will develop and maintain database policies, standards, and overall documentation including availability, replication, and backup & recovery policies. You will be responsible for building, deploying, and stabilizing code, services, systems and tools; driving standardization and service-focused instrumentation, resolving break/fix scenarios, and engaging broader teams as necessary. You will develop solutions to problems working closely with other engineering teams like Storage, Systems, Platforms, and Networks.
Responsibilities Include:
- Be able to work with clients, peers, and management in a highly visible, mission critical environment.
- Be able to gather, organize, prioritize technical requirements.
- Designing database structures & good understanding of data modeling.
- Strong knowledge of Materialized views and query rewrite functionality.
- Develop PL SQL Packages, Procedures, Functions, Triggers.
- Develop data transformation and validation scripts.
- Develop Unix scripts for automatic processing of back-end jobs.
- Maintenance of all database objects and purging process of large tables.
- Performance tuning which impacts the UI and back-end jobs.
- Work on product support on analysis, fix and patch release process.
- Provide emergency production support to mission critical operations.
Required Skills:
- Bachelor’s degree
- 8+ years of experience with Oracle databases
- 5+ years of experience as a SQL Developer
- 5+ years of experience designing and implementing a migration plan for large data sets and complex data architectures
- 5+ years of experience with procedure coding, demonstrating excellent capabilities in crafting efficient and optimized code
- 3+years experience in debugging queries and enhancing query performance for optimal system efficiency.
- 3+ years of experience in elevating overall database performance through strategic optimizations and enhancements.
- US Citizenship is required (required by the federal government for this position).
- Must be able to obtain Public Trust clearance.
- MUST RESIDE IN THE United States (U.S.) and the work MUST BE PERFORMED in the United States (U.S.), as this work is for a federal contract and laws do apply.
Desired Skills:
- Strong verbal and written communication skills and strong sense of ownership
- Should have strong analytical and problem-solving skills and hands-on experience with debugging tools.
- Should be willing to work as individual capacity and in teams across the organization.
- Able to manage dependencies and timely manage priority.
- Proactive and able to work independently with minimal supervision.
- Open-minded, flexible and willing to adapt to changing situations while being focused on delivery.
Working at ICF
ICF is a global advisory and technology services provider, but we’re 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 world's toughest challenges by building an inclusive workplace that allows everyone to thrive. We are an equal opportunity employer, committed to hiring regardless of any protected characteristic, such as race, ethnicity, national origin, color, sex, gender identity/expression, sexual orientation, religion, age, disability status, or military/veteran status. Together, our employees are empowered to share their expertise and collaborate with others to achieve personal and professional goals. For more information, please read our
EEO & AA policy
. Reasonable Accommodations are available, including, but not limited to, for disabled veterans, individuals with disabilities, and individuals with sincerely held religious beliefs, in all phases of the application and employment process. To request an accommodation please email
icfcareercenter@icf.com
and we will be happy to assist. All information you provide will be kept confidential and will be used only to the extent required to provide needed reasonable accommodations. Read more about
workplace discrimination rights
, the Pay Transparency Statement
, or our benefit offerings which are included in the Transparency in (Benefits) Coverage Act.
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 is:
