Skills & Technology
- Data Platforms: Cloudera Data Platform
- Big Data: Spark Kafka HDFS Hive
- Languages: SQL Python Scala Java
- Databases: Oracle PostgreSQL
- Other: NoSQL Time-Series Data Management
Job Description
- Understand business requirements and translate them into scalable database solutions.
- Design and develop complex database architectures and schemas.
- Develop advanced database objects including Stored Procedures Functions Packages and Triggers using Oracle PL/SQL or PostgreSQL pgPL/SQL.
- Strong hands-on experience with:
- Table partitioning
- DB Links
- Materialized Views
- Ref Cursors
- External Tables
- Collections and Dynamic SQL
- Extensive experience in file handling using database scripts.
- Expertise in SQL performance tuning and query optimization.
- Experience with database batch job scheduling.
- Knowledge of time-series data management and large-scale data processing.
Skills & Technology Data Platforms: Cloudera Data Platform Big Data: Spark Kafka HDFS Hive Languages: SQL Python Scala Java Databases: Oracle PostgreSQL Other: NoSQL Time-Series Data Management Job Description Understand business requirements and translate them into scalable database solutions. D...
Skills & Technology
- Data Platforms: Cloudera Data Platform
- Big Data: Spark Kafka HDFS Hive
- Languages: SQL Python Scala Java
- Databases: Oracle PostgreSQL
- Other: NoSQL Time-Series Data Management
Job Description
- Understand business requirements and translate them into scalable database solutions.
- Design and develop complex database architectures and schemas.
- Develop advanced database objects including Stored Procedures Functions Packages and Triggers using Oracle PL/SQL or PostgreSQL pgPL/SQL.
- Strong hands-on experience with:
- Table partitioning
- DB Links
- Materialized Views
- Ref Cursors
- External Tables
- Collections and Dynamic SQL
- Extensive experience in file handling using database scripts.
- Expertise in SQL performance tuning and query optimization.
- Experience with database batch job scheduling.
- Knowledge of time-series data management and large-scale data processing.
View more
View less