Required Skills

PL/SQL Tech Lead/Developer

Work Authorization

  • Us Citizen

  • Green Card

Preferred Employment

  • Corp-Corp

Employment Type

  • Consulting/Contract

education qualification

  • UG :- - Not Required

  • PG :- - Not Required

Other Information

  • No of position :- ( 1 )

  • Post :- 18th Sep 2021

JOB DETAIL

  • 7  years’ experience in significant Oracle and Postgres development, including both SQL, PL/SQL and pl/pgSQL.
  • 3 years’ experience in a technical leadership role.
  • Strong database capabilities
  • Understand a variety advanced SQL techniques, and how to adapt and refactor complex Oracle SQL into effective and performant Postgres SQL statements.
  • Practical experience utilizing SQL in an enterprise Java application environment utilizing JDBC.
  • Strong PL/SQL coding skills, including database triggers, stored procedures and packages executed via application code and/or shell scripts.
  • Highly proficient in refactoring Oracle to Postgres through the full development lifecycle, with a very strong focus on performance and quality.
  • Strong knowledge of database and SQL concepts and understanding, and equally must be able to ingest, understand and design for customer-driven requirements SQL and procedure language.
  • Lead the day-to-day activities of assigned SQL developers and DBAs and coordinate with the Java Tech Lead to provide practical database and SQL skills to Java developers.
  • Analyze technical and business problems, define solution alternatives, and lead team to design, build and deploy recommended solution.
  • Develop automation frameworks and tools where necessary to facilitate seamless refactoring.
  • Ensure performance is scalable and robust on the target PostgreSQL databases on AWS EC2 and RDS Platforms by applying deep and practical performance tuning skills.
  • Bring rigorous attention to quality and standards throughout the project lifecycle, including during code reviews and throughout unit, load and performance testing activities.
  • Develop utility database scripts and processes to create data at scale for performance testing.
  • Continuously improve skills with Oracle, PostgreSQL and AWS Cloud Platform.

Bachelors Degree, preferably in Software Engineering or Technology, Computer Science or Information Technology, although consideration will be given to candidates with other degrees having relevant experience.

  1. A minimum of 7 years of consolidated experience in Software Development or Systems Engineer and out of which at least 7 years of demonstrable experience as an accomplished SQL and PL/SQL developer.
  2. A minimum of 4 years of consolidated experience in a technical leadership capacity.
  3. Must have a very strong Oracle & PostgreSQL background. Knowledge of other RDBMS Platforms such as MySQL or Microsoft SQL Server is desirable.
  4. Must have strong knowledge of DB performance factors and performance tuning, etc.
  5. Must have good soft skills such as verbal and written communication skills.
  6. Should have experience working on AWS Cloud Platform with good domain knowledge on services such as RDS, EC2, S3, EBS, SQS, etc.
  7. Experience with GitHub, GitLab or similar source code repositories. Experience with Jira and Confluence desired.

 

Company Information