The Opportunity:
Serve as an Agile Scrum team member providing software implementation, testing and maintenance for the delivery of releasable software in sprint cycles. Responsible for activities associated with delivery of software solutions associated with customer-defined systems and software projects by working in close collaboration with software developers/engineers, stakeholders, and end users within Agile processes.
Responsibilities:
·Testing and implementing custom of the shelf software
·Troubleshooting and fixing active directory, server and database performance issues
·Fixing security vulnerabilities related to server and databases
·Create data reports with SQL Server and Oracle
·Production support for outages.
·SQL Query performance tuning
·Extract, Transform and load data using scripts / ETL software
·Active participation in release and sprint planning, artifact creation, sprint testing, regression testing, demonstrations, retrospectives and solution releases
·Ensuring product quality and timeliness of work, providing advice and guidance, resolving problems to meet objectives, and providing periodic performance reports
·Developing new and refining existing process to enhance quality and productivity
·Proficient in taking backups and restoring database when needed. As well as grant or revoke database permissions when needed
Qualifications:
Must be a U.S. Citizen with the ability to pass CBP background investigation, criteria will include:
o3-year check for felony convictions
o1-year check for illegal drug use
o1-year check for misconduct such as theft or fraud
•College degree (B.S.) in Computer Science, Software Engineering, Information Management Systems or a related discipline.Equivalent professional experience will be considered in lieu of degree
•Professional Experience: at least seven (7) years related Database and system administration experience.
Desired:
Experience with Data streaming from Oracle to PostgreSQL
• Ability to apply advanced principles, theories, and concepts, and contribute to the development of innovative principles and ideas
• Direct experience providing production support for PostgreSQL and Oracle database
• Programming background in Java, Python
• Technical Certifications, such as OCP or AWS certification
• Experience with PostgreSQL and Oracle Database Development including Stored Procedures, Constraints, Joins, Keys, Indexes, Triggers and Data Import/Export.
• Experience using Data streaming technologies like AWS DMS, or Kafka
• AWS Cloud Database (RDS) experience, especially PostgreSQL and Oracle
• Knowledge of large-scale data migration from Oracle to PostgreSQL
• Working experience with advanced procedures/functions concepts and features such as Analytic Functions and Hierarchical Queries with Oracle and PostgreSQL
• Experience with database tools like TOAD, SQL Developer and PGadmin
• Experience in Creating and Maintaining Database objects like Tables, Indexes, Views, Synonyms, Object types and Collections
• Experience with database design and stored SQL procedures
• Excellent written and verbal communication skills
• Highly responsible, team-oriented individual with very strong work ethic and a self-starter
-What You Can Expect:
A culture of integrity.
At CACI, we place character and innovation at the center of everything we do. As a valued team member, you’ll be part of a high-performing group dedicated to our customer’s missions and driven by a higher purpose – to ensure the safety of our nation.
An environment of trust.
CACI values the unique contributions that every employee brings to our company and our customers - every day. You’ll have the autonomy to take the time you need through a unique flexible time off benefit and have access to robust learning resources to make your ambitions a reality.
A focus on continuous growth.
Together, we will advance our nation's most critical missions, build on our lengthy track record of business success, and find opportunities to break new ground — in your career and in our legacy.
Pay Range:
There are a host of factors that can influence final salary including, but not limited to, geographic location, Federal Government contract labor categories and contract wage rates, relevant prior work experience, specific skills and competencies, education, and certifications. Our employees value the flexibility at CACI that allows them to balance quality work and their personal lives. We offer competitive compensation, benefits and learning and development opportunities. Our broad and competitive mix of benefits options is designed to support and protect employees and their families. At CACI, you will receive comprehensive benefits such as; healthcare, wellness, financial, retirement, family support, continuing education, and time off benefits.
The proposed salary range for this position is:
$103,800 - $218,100caci