Oracle PL/SQL Developer Job at ACS Consultancy Services, Albany, NY

cUhaVnZUVFJiTHgyTkx0R1ZtTk5OaFN4QVE9PQ==
  • ACS Consultancy Services
  • Albany, NY

Job Description

Job Title: Oracle PL/SQL Developer Location: Remote

We are currently seeking candidates who meet the following qualifications:

Key Responsibilities:

  • Design and develop PL/SQL packages, stored procedures, functions, and triggers to support business processes.
  • Write efficient and optimized SQL queries for data retrieval, updates, and complex reports.
  • Analyze existing database systems and enhance functionality, performance, and reliability.
  • Perform database performance tuning and query optimization to improve system efficiency.
  • Collaborate with business analysts, project managers, and other development teams to design and implement technical solutions.
  • Create and maintain database documentation, including data models, ER diagrams, and design specifications.
  • Ensure data integrity and security within the database environment.
  • Participate in the full software development lifecycle (SDLC) from planning, design, and implementation to testing and support.
  • Troubleshoot and resolve PL/SQL-related issues, including performance bottlenecks, bugs, and system errors.
  • Provide support in production systems and assist with user requirements.
  • Stay current with the latest trends and technologies in database management systems and Oracle PL/SQL.
Required Skills and Qualifications:
  • Bachelor's degree in Computer Science, Information Technology, or a related field.
  • Proven experience as an Oracle PL/SQL Developer with strong expertise in Oracle SQL, PL/SQL, and database design.
  • Proficiency in creating, debugging, and optimizing PL/SQL scripts, stored procedures, triggers, and functions.
  • In-depth understanding of database design, normalization, and query optimization techniques.
  • Hands-on experience with Oracle tools (e.g., SQL Developer, TOAD).
  • Experience in performance tuning and database optimization.
  • Strong knowledge of data modeling and relational database management systems (RDBMS).
  • Familiarity with Oracle 11g, 12c, or higher versions.
  • Excellent analytical, problem-solving, and troubleshooting skills.
  • Good communication and teamwork skills, with the ability to interact with both technical and non-technical teams.
  • Experience in version control tools (e.g., Git, SVN) is a plus.
  • Knowledge of Oracle Data Integrator (ODI) and Oracle Application Express (APEX).
  • Experience with cloud-based Oracle databases (e.g., Oracle Autonomous Database).
  • Understanding of data warehousing and ETL processes.
  • Knowledge of Unix/Linux scripting is a plus.
  • Federal Experience is a plus.
  • Required Security clearance.


    If you meet these qualifications, please submit your application via link provided in Linkedin.
    Kindly do not call the general line to submit your application.

Job Tags

Remote job,

Similar Jobs

Mara Talent

Senior 360 Recruitment Consultant Job at Mara Talent

 ...Senior 360 Recruitment Consultant - Austin, Texas Are you an experienced recruiter (360) ready for a new opportunity? Join a company that offers up to 30% commission, invests in your growth, and paves a clear path to success. Specialising in permanent and... 

JPoles Wireless Group

Business Management - Entry Level Job at JPoles Wireless Group

 ...As an Entry Level Business Manager, we are looking for motivated individuals who can manage and implement our team philosophies through one-on-one coaching, mentorship, and daily classroom-style training. We set the highest standards in customer service and customer acquisition... 

Brian Booth - State Farm Agency

Insurance Telemarketing Specialist / Sales Job at Brian Booth - State Farm Agency

 ...specialist. You will be calling potential clients who have requested insurance information, and transferring them to one of our Agency...  ...fun personality who is not afraid to make calls. Previous sales experience is preferred. Must be fluent in Spanish and English.... 

DOCTORS CHOICE PLACEMENT SERVICES, INC.

Internal Medicine - Geriatrics Physician Job at DOCTORS CHOICE PLACEMENT SERVICES, INC.

 ...Employer-Paid Life Insurance & Long-Term Disability Coverage 401(k) Program Flexible Spending & Dependent Care Accounts Available Monday-Friday Schedule Relocation Assistance Branded Tesla Work/Life balance Minority Partnership/Ownership is offered!

Ashley | The Wellsville Group

Retail General Manager Job at Ashley | The Wellsville Group

 ...fastest-growing licensees out thereis looking for driven General Managers to join us in the greater Akron/Canton area and Northeast Ohio....  ...and a spark of competition. If youre ready to step up, lead a retail crew, and make an impact, this is your shot. We shape leaders...