Home

Remote Role::Oracle PL SQL Developer with AWS::6+ month-USC at Remote, Remote, USA
Email: [email protected]
From:

AMIT,

SUS

[email protected]

Reply to:   [email protected]

Position: Oracle PL/SQL Developer with AWS

Location: Remote Role

Duration: 6+ month

Phone and Skype

USC

What is driving the need

Need someone to help re-architect and redesign the way this database is organized to eventually help build a new reporting platform.

Come in and help optimize database and queries to help with reporting functionality

This is critical to fix and implement

We are seeking an AWS Database Developer with extensive hands-on experience with large-scale database migration projects to AWS, particularly Oracle to AWS Aurora and Redshift

Experience in Oracle database 11g and above Extensive knowledge in Oracle SQL

Proficiency in AWS data services such as Aurora, Redshift, S3, Athena, Glue, and R3 Spectrum

Deep understanding of cloud-native data architecture principles and best practices

Expertise in database performance optimization, troubleshooting, and tuning in cloud environments

Excellent knowledge of SQL, ETL processes, and data modeling

tables, indexes, partitions, DB links, and experience in Oracle Advanced Pl/SQL

Experience in tuning SQL queries & PL/SQL code for optimum performance

Review & propose.

Schemas and database server, in the queries being executed.

Propose solution for SQL long queries.

SQL queries to improve performance.

Monthly Reports solutions for all equipment at customer level.

Design database structure for planned projects like file Management and Smart Tag.

Optimize Queries - Ensure that queries are properly optimized.

Tables and create indexing. Ensure that tables are indexed on columns frequently used in WHERE clauses, JOIN conditions, and ORDER BY clauses.

Adjust database configuration parameters (such as memory allocation, cache sizes, and connection limits) to match the hardware resources and workload of our system.

Add partitioning and sharding to distribute load if required.

Large tables, consider partitioning them based on certain criteria (such as range or hash partitioning).

Evaluate database schema and consider normalizing or de-normalizing it based on the Current KC requirements.

Reporting Strategy

Purpose reporting tool for automated report and dashboard.

Establish a reporting cadence that provides timely insights without overwhelming stakeholders.

Balance frequency with the availability of relevant data and the need for real-time decision-making.

Explore various reporting tools available in the market. Consider factors such as functionality, ease of use, scalability, cost, integrations with existing systems, and support for data visualization.

Regards,

Amit Panthri

Sr. Technical Recruiter

E: [email protected]

Keywords: sthree database information technology procedural language Delaware
Remote Role::Oracle PL SQL Developer with AWS::6+ month-USC
[email protected]
[email protected]
View all
Thu Jun 20 20:02:00 UTC 2024

To remove this job post send "job_kill 1498328" as subject from [email protected] to [email protected]. Do not write anything extra in the subject line as this is a automatic system which will not work otherwise.


Your reply to [email protected] -
To       

Subject   
Message -

Your email id:

Captcha Image:
Captcha Code:


Pages not loading, taking too much time to load, server timeout or unavailable, or any other issues please contact admin at [email protected]
Time Taken: 1

Location: ,