המקום בו המומחים והחברות הטובות ביותר נפגשים
This is a data architect position for an individual with a strong background in data architecture, data modeling, performance tuning and trouble shooting skills in Oracle, Big Data and Cloud based databases.
• At a minimum, a bachelor’s degree in Computer Science, Information Technology or a related field is required
• 10+ years' experience in a database technologies
• Strong communication and customer engagement skills
• Deep experience and "Hands- On" experience in architecting, designing, and building enterprise-class relational and dimensional data models for large scale OLTP and data warehouse
• Hands on experience with Oracle and at least one Cloud based DB
• Extensive experience in analyzing and fixing query performance issues. Very good understanding in reading and analyzing explain plan and fixing performance issues.
• Extensive experience in advanced database skills such as oracle in-memory, data partitioning, stat gather, data purging, materialized views, star and snowflake design, index and stored procedures.
• Advanced knowledge of SQL and related programming languages such as PL/SQL, Python and Unix Shell scripting
• Familiar with technologies including Snowflake, ETL/ELT tools, Spark SQL, AWS
• Understanding data management and governance concepts such as data quality, data purging, metadata management, data lineage, data lakes etc
• Experienced with integration tool like Talend, dimensional models, slowly changing dimensions, and database tuning
• Self-starter attitude and ability to work independently
• Excellent communication skills and problem solving skills
• Involve in architect, design and development of data warehouse and ODS databases
• Work with system architects, software architects, and design analysts to understand business requirements
• Develop standards: Create and enforce standards for database development
• Manage and Monitor : Oversee the day-to-day activities of the database, including monitoring quality, service, and utilization standards
• Optimize for throughput, concurrency, load and performance with best practices for SQL queries, caching, indexing strategies and other performance best practices
• Work closely with production support and developers to identify trouble queries, analyze query plan and tune queries for performance issues
• Develop and enhance existing framework using python that can performs data load/unload, export/import, purging, stat gather and other db monitoring.
• Pro-actively monitor db locks, blocks, long running queries and act on its
• Ensure proper process and policies are being followed by enforcing data management and governance.
• Create, build and maintain lower environments (i.e UAT/QA/Dev) and regularly perform data refresh on these environment
• Builds data models including conceptual, logical, and physical design
• Work with SA and DBA to ensure latest VTM patches and bug fixes are applied.
• Monitor DB and tablespace size and keep db size under control by purging
• Defining strategic roadmaps for migration of data from legacy app to new app.
• Added benefits: Cloud and Snowflake certifications.
Applications Development
Time Type:
View the " " poster. View the .
View the .
View the
משרות נוספות שיכולות לעניין אותך