Senior Oracle Developer # 26-16705

Duration 12 Months Job Description Language i.e., Bash, C, KornShell, Bourne shell - Knowledgeable about data integration tools like Actian/Pentaho 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 Experience Required 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 US Tech Solutions is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, colour, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran. #J-18808-Ljbffr US Tech Solutions