Intelligence and National Security Alliance
Database Developer
Intelligence and National Security Alliance, Fairfax, Virginia, United States, 22032
Database Developer
Position DescriptionCGI Federal is seeking a motivated and customer-oriented professional to support our US Courts client. This role involves designing, implementing, and managing database solutions to ensure data integrity, consistency, and performance. This position is located in our Fairfax, VA office; however, a hybrid working model is acceptable.
Your future duties and responsibilitiesDatabase Design and Development:
Design and implement database schemas, tables, views, indexes, and other database objects.Develop and optimize SQL queries, stored procedures, and functions for data extraction, transformation, and loading (ETL) processes.Create and maintain documentation of database structures and processes.
Data Management and Integration:
Ensure data integrity, consistency, and accuracy across all database systems.Integrate data from various sources, including external databases and APIs.Implement data migration and data warehousing solutions as needed.
Performance Tuning and Optimization:
Monitor and optimize database performance, including query performance tuning and index optimization.Troubleshoot and resolve database performance issues and provide recommendations for improvements.
Collaboration and Support:
Collaborate with data analysts, IT staff, and other stakeholders to understand data requirements and provide database solutions.Provide technical support for database-related issues and assist with user training on database functionalities.
Required qualifications to be successful in this role7+ years of relevant experience.Experience with Oracle GoldenGate and SAP BusinessObjects 4.2.Bachelor's Degree in a relevant field.Ability to obtain and maintain a Public Trust.
Desired qualifications/non-essential skills required:Experience implementing mobile components.Experience supporting multiple new product and enhancement releases.
Due to the nature of this government contract, US Citizenship is required.
CGI's benefits include:Competitive compensationComprehensive insurance optionsMatching contributions through the 401(k) plan and the share purchase planPaid time off for vacation, holidays, and sick timePaid maternity and parental leaveLearning opportunities and tuition assistanceMember assistance and wellness programs
Together, as owners, let's turn meaningful insights into action.Life at CGI is rooted in ownership, teamwork, respect and belonging. Here, you'll reach your full potential because...You are invited to be an owner from day 1 as we work together to bring our Dream to life. That's why we call ourselves CGI Partners rather than employees. We benefit from our collective success and actively shape our company's strategy and direction.Your work creates value. You'll develop innovative solutions and build relationships with teammates and clients while accessing global capabilities to scale your ideas, embrace new opportunities, and benefit from expansive industry and technology expertise.You'll shape your career by joining a company built to grow and last. You'll be supported by leaders who care about your health and well-being and provide you with opportunities to deepen your skills and broaden your horizons.Come join our team-one of the largest IT and business consulting services firms in the world.
#J-18808-Ljbffr
Position DescriptionCGI Federal is seeking a motivated and customer-oriented professional to support our US Courts client. This role involves designing, implementing, and managing database solutions to ensure data integrity, consistency, and performance. This position is located in our Fairfax, VA office; however, a hybrid working model is acceptable.
Your future duties and responsibilitiesDatabase Design and Development:
Design and implement database schemas, tables, views, indexes, and other database objects.Develop and optimize SQL queries, stored procedures, and functions for data extraction, transformation, and loading (ETL) processes.Create and maintain documentation of database structures and processes.
Data Management and Integration:
Ensure data integrity, consistency, and accuracy across all database systems.Integrate data from various sources, including external databases and APIs.Implement data migration and data warehousing solutions as needed.
Performance Tuning and Optimization:
Monitor and optimize database performance, including query performance tuning and index optimization.Troubleshoot and resolve database performance issues and provide recommendations for improvements.
Collaboration and Support:
Collaborate with data analysts, IT staff, and other stakeholders to understand data requirements and provide database solutions.Provide technical support for database-related issues and assist with user training on database functionalities.
Required qualifications to be successful in this role7+ years of relevant experience.Experience with Oracle GoldenGate and SAP BusinessObjects 4.2.Bachelor's Degree in a relevant field.Ability to obtain and maintain a Public Trust.
Desired qualifications/non-essential skills required:Experience implementing mobile components.Experience supporting multiple new product and enhancement releases.
Due to the nature of this government contract, US Citizenship is required.
CGI's benefits include:Competitive compensationComprehensive insurance optionsMatching contributions through the 401(k) plan and the share purchase planPaid time off for vacation, holidays, and sick timePaid maternity and parental leaveLearning opportunities and tuition assistanceMember assistance and wellness programs
Together, as owners, let's turn meaningful insights into action.Life at CGI is rooted in ownership, teamwork, respect and belonging. Here, you'll reach your full potential because...You are invited to be an owner from day 1 as we work together to bring our Dream to life. That's why we call ourselves CGI Partners rather than employees. We benefit from our collective success and actively shape our company's strategy and direction.Your work creates value. You'll develop innovative solutions and build relationships with teammates and clients while accessing global capabilities to scale your ideas, embrace new opportunities, and benefit from expansive industry and technology expertise.You'll shape your career by joining a company built to grow and last. You'll be supported by leaders who care about your health and well-being and provide you with opportunities to deepen your skills and broaden your horizons.Come join our team-one of the largest IT and business consulting services firms in the world.
#J-18808-Ljbffr