Address
Form of work
Salary**The candidate for this role must be willing to work at the client site in Washington, DC 2 days a week.**
ICF’s Digital Modernization division is a rapidly growing, entrepreneurial, technology department, seeking a Senior Database Developer to support upcoming needs with our federal customer.
Our Digital Modernization division is an information technology and management consulting department that offers integrated, strategic solutions to its public and private-sector clients. ICF has the expertise, agility, and commitment to design, build, and operate high-performance IT engines to support all aspects of our client’s business.
ICF 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 (DMD) 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 DMD team, you'll play a vital role in guiding organizations through the process of transitioning from legacy systems to the Appian platform. We focus on Appian implementation, ensuring tailored solutions that seamlessly integrate into our clients' operations. Collaborating with public and private entities, we prioritize a user-centric approach, employing design principles for intuitive interfaces. Our commitment to innovation and best practices, coupled with an agile methodology, ensures we deliver transformative results in dynamic environments.
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
- 5+ years of experience with Oracle and MariaDB/MySQL 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 integrating database operations with Business Process Modeling PaaS tools such as Appian
- 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.
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 non-discrimination: Know Your Rights
and Pay Transparency Statement.
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:
