What are the responsibilities and job description for the Oracle Pl/SQL Dveloper position at ProvinceSoft Inc.?
Job Title: Oracle PL/SQL Developer
Job Location: Chicago, IL (Onsite Job)
Job Type: Long Term
Visa: H4 Ead, TN, GC Ead, USC
If interested, please share your updated resume. Will discuss in detail.
Key Responsibilities:
Design, develop, and optimize complex SQL queries and PL/SQL procedures.
Develop and maintain Unix shell scripts to automate routine processes.
Manage scheduling of jobs using Control-M or similar tools.
Collaborate with cross-functional teams for database integration and data migration projects.
Provide performance tuning and query optimization to ensure high-efficiency database systems.
Troubleshoot and resolve database-related issues.
Implement and maintain database security policies and procedures.
Document processes and maintain knowledge base for developed systems.
Qualifications
Experience: Total 10 years of experience in Oracle SQL and PL/SQL development.
Proficiency in writing complex queries and stored procedures.
Experience in Unix shell scripting.
Familiarity with job scheduling tools like Control-M (or similar).
Strong analytical and problem-solving skills with a focus on performance tuning.
Understanding of database security and optimization techniques.
Ability to work independently and within a team environment.
Excellent verbal and written communication skills.
Experience in cloud technologies.
Knowledge of Agile development methodologies.