Oracle PL/SQL Developer
Responsibilities for this Position
Location: USA VA Fort BelvoirFull Part/Time: Full time
Job Req: RQ207840 Type of Requisition:
Regular Clearance Level Must Currently Possess:
Top Secret Clearance Level Must Be Able to Obtain:
Top Secret/SCI Public Trust/Other Required:
None Job Family:
IT Infrastructure and Operations Job Qualifications: Skills:
Databasing, SQL Databases, Stored Procedures
Certifications:
None
Experience:
5 + years of related experience
US Citizenship Required:
Yes Job Description: ISQL developer must develop high-quality database solutions to implement and optimize with stored procedures and functions using Oracle PL/SQL. They will review and interpret ongoing business and functional requirements and research the required data structures. They must build appropriate and effective reporting deliverables with existing SQL and analyze existing SQL queries for performance improvements. They will investigate exceptions concerning asset movements.
- Create and manage data flow and data models for various systems.
- Provide troubleshooting and support for database instances in dedicated and multi-node clustered SQL Server environments.
- Participate in identifying stored procedure enhancements for database performance, reliability, and stability.
- Respond to client requests for data by mining a data warehouse.
- Develop requirements from data requests and develop necessary SQL queries to produce output.
- Act as a liaison between the development team leadership, coding teams, and support teams.
- Provide guidance to software engineers, architects and additional team members.
- Perform QA tests to ensure data integrity and quality.
- Review workflow charts developed by business analysts and programmers.
- Design and document database architecture using logical and physical data modeling tools and utilities.
- Run routine and ad-hoc queries as requested by the client.
- Conduct data exploration of new tables and schema in a data warehouse environment.
- Participate in technical design and requirements gather meetings with stakeholders.
- Assist with mapping activities to assist with data normalization activities.
- Demonstrate ability to analyze resource bottlenecks and provide suggestions to team, management, and internal customers on how to alleviate pressure and plan for capacity.
- Experience with Oracle PL/SQL, SQL Server software and systems.
- High level of proficiency with PL/SQL exception handling.
- Experience with TOAD and TOAD Data Modeler
- Experience with on-premise Microsoft Azure DevOps.
- Experience with C# coding language
- Fluency in scripting, debugging and relational databases.
- Comfortable running analysis services
- Preferred certified Oracle PL/SQL Developer Certified Associate
- Preferred Bachelor's Degree in computer science, engineering, information systems or information technology or equivalent experience.
- Preferred COMPTIA Security+ Certification
- Preferred experience with DoDAF documentation
US Citizenship Required GDIT IS YOUR PLACE:
401K with company match
Comprehensive health and wellness packages
Internal mobility team dedicated to helping you own your career
Professional growth opportunities including paid education and certifications
Cutting-edge technology you can learn from
Rest and recharge with paid vacation and holidays #armajobs #gditpriority The likely salary range for this position is $117,300 - $158,700. This is not, however, a guarantee of compensation or salary. Rather, salary will be set based on experience, geographic location and possibly contractual requirements and could fall outside of this range. Scheduled Weekly Hours:
40 Travel Required:
Less than 10% Telecommuting Options:
Onsite Work Location:
USA VA Fort Belvoir Additional Work Locations: Total Rewards at GDIT:
Our benefits package for all US-based employees includes a variety of medical plan options, some with Health Savings Accounts, dental plan options, a vision plan, and a 401(k) plan offering the ability to contribute both pre and post-tax dollars up to the IRS annual limits and receive a company match. To encourage work/life balance, GDIT offers employees full flex work weeks where possible and a variety of paid time off plans, including vacation, sick and personal time, holidays, paid parental, military, bereavement and jury duty leave. To ensure our employees are able to protect their income, other offerings such as short and long-term disability benefits, life, accidental death and dismemberment, personal accident, critical illness and business travel and accident insurance are provided or available. We regularly review our Total Rewards package to ensure our offerings are competitive and reflect what our employees have told us they value most. We are GDIT. A global technology and professional services company that delivers consulting, technology and mission services to every major agency across the U.S. government, defense and intelligence community. Our 30,000 experts extract the power of technology to create immediate value and deliver solutions at the edge of innovation. We operate across 50 countries worldwide, offering leading capabilities in digital modernization, AI/ML, Cloud, Cyber and application development. Together with our clients, we strive to create a safer, smarter world by harnessing the power of deep expertise and advanced technology. Join our Talent Community to stay up to date on our career opportunities and events at
gdit.com/tc . Equal Opportunity Employer / Individuals with Disabilities / Protected Veterans
PI278304437
ISQL developer must develop high-quality database solutions to implement and optimize with stored procedures and functions using Oracle PL/SQL. They will review and interpret ongoing business and functional requirements and research the required data structures. They must build appropriate and effective reporting deliverables with existing SQL and analyze existing SQL queries for performance improvements. They will investigate exceptions concerning asset movements.
- Create and manage data flow and data models for various systems.
- Provide troubleshooting and support for database instances in dedicated and multi-node clustered SQL Server environments.
- Participate in identifying stored procedure enhancements for database performance, reliability, and stability.
- Respond to client requests for data by mining a data warehouse.
- Develop requirements from data requests and develop necessary SQL queries to produce output.
- Act as a liaison between the development team leadership, coding teams, and support teams.
- Provide guidance to software engineers, architects and additional team members.
- Perform QA tests to ensure data integrity and quality.
- Review workflow charts developed by business analysts and programmers.
- Design and document database architecture using logical and physical data modeling tools and utilities.
- Run routine and ad-hoc queries as requested by the client.
- Conduct data exploration of new tables and schema in a data warehouse environment.
- Participate in technical design and requirements gather meetings with stakeholders.
- Assist with mapping activities to assist with data normalization activities.
- Demonstrate ability to analyze resource bottlenecks and provide suggestions to team, management, and internal customers on how to alleviate pressure and plan for capacity.
Qualifications
- Experience with Oracle PL/SQL, SQL Server software and systems.
- High level of proficiency with PL/SQL exception handling.
- Experience with TOAD and TOAD Data Modeler
- Experience with on-premise Microsoft Azure DevOps.
- Experience with C# coding language
- Fluency in scripting, debugging and relational databases.
- Comfortable running analysis services
- Preferred certified Oracle PL/SQL Developer Certified Associate
- Preferred Bachelor's Degree in computer science, engineering, information systems or information technology or equivalent experience.
- Preferred COMPTIA Security+ Certification
- Preferred experience with DoDAF documentation
Position is on Customer Site
US Citizenship Required
GDIT IS YOUR PLACE:
401K with company match
Comprehensive health and wellness packages
Internal mobility team dedicated to helping you own your career
Professional growth opportunities including paid education and certifications
Cutting-edge technology you can learn from
Rest and recharge with paid vacation and holidays
Recommended Jobs
Early Childhood (Day Care)- Teacher
Summary The Teacher is responsible for the direct care, supervision, and education of a specific group of children within the center. They are responsible for implementing the curriculum, creati…
Systems Administrator
J5 Consulting is a Maryland based company established in 2006 to provide computing and consulting services for government and commercial entities. Our services improve Information System networking p…
Product Safety Engineer
Electrify America is committed to revolutionizing the way people charge. As the country's largest open DC fast charging network, Electrify America is actively contributing to electrifying mobility tod…
Server
Job Description Job Description Duties & Responsibilities: Provide excellent customer services Greet customers and present menus Make suggestions based on their preferences Take an…
Class A Freight Truck Driver Job
Class A Freight Truck Driver Job We are seeking a Dedicated Truck Driver to join our team! You will be responsible for safely operating a truck with a capacity of at least 26,000 pounds Gross Vehicle…
Target Analyst (Targeter) (2023-0087)
Acclaim Technical Services, founded in 2000, is a leading language and intelligence services company supporting a wide range of U.S. Federal agencies. We are an Employee Stock Ownership Plan (ESOP) …
Interventional Cardiology MD - Suffolk and Norfolk - Coastal Virginia - Bon Secours
Bon Secours in the beautiful coastal Hampton Roads/Tidewater Region of Virginia - is adding an Interventional Cardiologist to our growing team! This full-time Interventionalist position will …
Help Desk Lead
Job Description Job Description Company Description Abacus Technology Corporation is a Federal government contractor and provider of enterprise information technology (IT) services and solut…
Lead Teacher-Sub
Summary Summary Bethel Child Development Center is dedicated to providing a nurturing and educational environment for young children. We are seeking a passionate and experienced Lead Teacher …
AECOM is Hosting a Networking Event for Upcoming Entry-Level Civil Water Resources Engineer in Philadelphia, PA!
Work with Us. Change the World. At AECOM, we're delivering a better world. Whether improving your commute, keeping the lights on, providing access to clean water, or transforming skylines, our…