Senior Oracle Developer with Debezium at Pyramid Technology Solutions, Inc

Job Role: Senior Oracle Developer

Location: Downey, CA

Duration: 6+ Months Contract

Skills Preferred

- Excellent verbal and written communication

- Extensive expertise in one or multiple database management systems (DBMS) such as Oracle, Microsoft SQL Server, MySQL, PostgreSQL, or MongoDB, encompassing tasks such as installation, configuration, maintenance, and troubleshooting of these systems

- Robust abilities in database design and data modeling, encompassing tasks such as crafting efficient database schemas, establishing relationships between tables, maintaining data integrity, and enhancing database structures for optimal performance

- Comprehensive grasp of backup and recovery strategies to formulate backup plans, schedule backup procedures, validate restore processes through testing, and execute disaster recovery plans.

- Skilled in monitoring and enhancing database performance by addressing performance bottlenecks, fine-tuning SQL queries, adjusting database parameters, deploying indexing strategies, and analyzing database statistics

- Proficient in one more Unix scripting language i.e., Bash, C, KornShell, Bourne shell

- Knowledgeable about data integration tools like Actian/Pentaho

Experience Preferred

- 2 years of practical experience employing Debezium

- 5 years of programming experience as an Oracle PL/SQL Developer

- 3 years of creating Shell Scripts experience for invoking SQL scripts

- 5 years of Oracle performance-related features such as Query Optimizer, Execution Plans, and Indexes.

- 5 years of client-server application development using Oracle 19c, PL/SQL, SQL *Plus, and TOAD

- 5 years of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-write and Transportable table spaces

- 2 years of experience with data warehouse concepts, ETL