JOBSEARCHER

DBA Tech Lead

Requires bachelor's degree or equivalent experience. Key hands-on team member with a minimum of 7+ years of strong programming experience with PL/SQL stored procedures and complex SQL to develop robust, reliable and high-performance solutions. Experience with 19c features such as in-memory pinning Extensive experience with database development tools (Oracle, Toad), ETL and integration technologies Prior experience working with Apache NiFi, AWS, Snowflake is preferred Firm understanding of the overall architecture required to support common schema based objects used to store data and implement business logic. Ability to perform PL/SQL coding assignments including stand-alone SQL scripting and database stored code (triggers, packages, procedures, and functions) in compliance with standards and procedures. Ability to Setup, Maintain and Enhance Partitioning of Table Spaces Ability to provide guidance, oversight, and peer review to more junior database developers. Experience with managing and resolving problems on a live production system. Solid understanding of SQL performance tuning techniques including query plan understanding and management, SQL tracing, DB stats, indexing techniques, using AWR reports etc. Experience working in an Agile delivery environment Strong written and oral communication skills are essential