No more applications are being accepted for this job
- 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
DBA Tech Lead - Charlotte, United States - The Dignify Solutions LLC
