Ask IT Consulting Inc. visualizes itself as a leader in IT services and staffing in coming years. With strong dedication and commitment of our employees, we would surpass all our competitors establishing the wider channel of media marketing building a better connection with clients.
Position: Oracle PL/SQL Developer
Place of Performance: Alexandria, VA
Duration :Long Term.
Must Need: Active Secret Security Clearance
Responsibilities·
Define and create data structures for schemas including tables, views, indexes etc.·
Understand table indexing and query strategies, database objects maintenance and performance issues.·
Proficiency in writing packages, stored procedures and functions, and triggers.·
Read, understand and improve upon (refactor) existing SQL and PL/SQL code.·
Unit test code, ability to identify and fix bugs.·
Assist in developing deployment scripts for releases.·
Understand how to develop and enforce coding standards and source code development standards.·
Create consistent and accurate technical documentation.·
Ability to support and understand multiple existing applications and schemas.·
Ability to multi-task, prioritize and manage work load.
Qualifications·
1-2 years of experience with Oracle and PL/SQL of experience in software development.·
Solid understanding of Relational Model.·
Possess a strong understanding of SQL, PL/SQL and Oracle platform.·
Solid understanding of Oracle database design and development using PL/SQL.·
Must be self-directed and able to function both independently and as part of a team.·
Demonstrate advanced critical thinking and trouble-shooting capabilities to assess, prioritize, plan, and implement tasks and solutions effectively, including the ability to manage multiple applications at a time.·
Excellent written and oracle communication skills·
Toad and UNIX/Linux experience·
Relevant combination of education and experience.·
Desired, but not essential·
Oracle Certifications·
Experience with PHP, JavaScript or .NET
Unfeigned regards,
Amit Kumar
Skills Required
- Active Secret security clearance
- 1-2 years of experience with Oracle and PL/SQL in software development
- Strong understanding of SQL, PL/SQL, and Oracle platform
- Solid understanding of relational data modeling
- Experience with Oracle database design and development using PL/SQL
- Experience writing packages, stored procedures, functions, and triggers
- Experience with query optimization, indexing, and database performance tuning
- Experience reading, refactoring, and debugging existing SQL and PL/SQL code
- Unit testing and bug fixing of database code
- Experience developing or assisting with deployment/release scripts
- Familiarity enforcing coding standards and source control for database code
- Ability to create accurate technical documentation
- Ability to support multiple existing applications and schemas simultaneously
- Self-directed, able to work independently and in a team
- Advanced critical thinking and troubleshooting skills
- Excellent written and oral communication skills
- Experience with Toad
- Experience with UNIX/Linux
- Relevant combination of education and experience
- Oracle Certifications
- Experience with PHP, JavaScript, or .NET
What We Do
Ask IT Consulting Inc. is a global information technology management firm founded in 2008 and headquartered in Holtsville, NY. The company specializes in providing comprehensive technology and workforce solutions, including IT consulting, talent management, and digital services. Their expertise extends to cybersecurity, cloud computing, and IT staffing, focusing on delivering tailored, innovative, and effective solutions to meet the unique objectives of their diverse clients.
