Oracle PL/SQL Developer

Hi, Hope you are doing good!! Job title: Oracle PL/SQL Developer Location - Irving, TX, or Baskin Bridge, NJ MUST HAVE SKILLS (must be showcased on resume): Minimum 8 years of experience with Oracle, PL SQL Proficient in understanding and creating complex SQL queries Knowledge of version control practices and procedures (GIT) Highly proficient in Oracle PL SQL developer activities and multi-task to work in other technologies (Teradata/MS SQL Server) Experience in Unix shell scripting ADDITIONAL SKILLS AWS Infrastructure setup and understanding DESIRED SKILLS BUT NOT MANDATORY: Experience in MS SQL server Teradata Experience with ETL and Teradata utilities (BTEQ, MLOAD, FLOAD, FAST EXPORT) Exposer to any reporting tool set like Qlik or Tableau JOB DUTIES: The Position will be responsible specific to(1) Designing database tables and structures.(2) Creating views, functions, triggers, stored procedures and packages.(3) Research complex Oracle programs and address data issues.(4) Provide batch application support.(5) Build new ETL workflow in Teradata and unix(6) Work with the onshore and offshore team in application design and build using the technologies defined in the must have skills(7) Communicate status of the activities effectively with management or clients EDUCATION/CERTIFICATIONS: Bachelor's or master's degree in computer science/information technology or relevant engineering field with minimum 6 to 10 years of experience Job Description: Documentation: Possess strong oral and written communication skills, including ability explain complex concepts simply. Can communicate effectively across with higher management and to audiences of varying technical prowess. Ability to clearly and simply organize information that conveys a story using PowerPoint. Strategic Planning/Vision: Ability to define the future state, as well as identifying the path to get there. Problem Solving: Ability to investigate and solve complex technical problems and data discrepancies. Ability to develop solutions that align tactical solutions with strategic goals. Self-Starter: Able to work independently, and multi-task under short deadlines, based upon general directions. Candidate will work in a team spread around multiple locations and expected to be a good team player within global setting Backup and Recovery: Developing and implementing backup strategies, testing recovery procedures, and ensuring data can be restored in case of failures, according to LinkedIn. Troubleshooting: Diagnosing and resolving database errors, performance issues, and other problems. Automation: Creating and maintaining scripts and procedures for automating routine tasks, according to SQLServerCentral. Collaboration: Working with developers, business users, and other stakeholders to understand their needs and provide solutions, according to janbasktraining.com. Documentation: Maintaining clear and up-to-date documentation for database configurations, procedures, and processes, according to SQLServerCentral. Capacity Planning: Monitoring database growth trends and planning for future capacity need Years of Experience: 12.00 Years of Experience Thanks & Regards, John Joseph M Sr. Associate US IT Recruiter A: 101 E Park Boulevard, Suite 720 Plano, Texas, USA-75074 E: john.j@kasmoglobal.com M: +1 346 308 2660 Job Type: Contract Pay: Up to $55.00 per hour Benefits: Health insurance Schedule: 8 hour shift Ability to Commute: Basking Ridge, NJ 07920 (Required) Ability to Relocate: Basking Ridge, NJ 07920: Relocate before starting work (Required) Work Location: In person