| Database Developer - Onsite at Houston, Texas, USA |
| Email: [email protected] |
|
From: Raghu, Msysinc [email protected] Reply to: [email protected] Title: Database Developer - Onsite Location: Houston, TX, USA Length: Long term Restriction: W2 or C2C Send resume to: [email protected] Description: *** Webcam interview *** Long term project *** *** Onsite *** *** Local Candidates or Within 100 Miles Houston, TX *** Experience: 8+ Years Key Responsibilities: Design, develop, and maintain database objects, including Tables, Stored Procedures, DDL/DML Triggers, Views, Indexes, Cursors, and User Defined Data Types. Utilize PL/SQL to create efficient, scalable solutions for data processing and management. Implement Oracle Performance Tuning using concepts like Oracle Hints and EXPLAIN PLAN tools. Leverage SQL & PL/SQL features, such as Built In Functions, Analytical Functions, Native Dynamic SQL, & Bulk Binding Techniques, to handle data efficiently. Optimize database performance through robust query designs and indexing strategies. Develop and support data warehousing solutions, including ETL processes for data extraction, transformation, and loading. Use tools like Oracle SQL Loader and External File Utilities for file management and data loading. Work with Snowflake cloud data platform, utilizing tools such as SnowSQL, SnowPipe, and cloud services (AWS or Azure) for data loading and processing. Work as part of a cross functional team, collaborating with stakeholders to understand data requirements and deliver solutions. Document database processes, designs, and best practices to support ongoing maintenance and development. Analyze and resolve complex database issues efficiently. Provide technical support for database operations, ensuring high performance and reliability. Qualifications and Skills: 8+ years of database development experience, with 5+ years of relevant expertise in SQL and PL/SQL. Bachelors degree in Computer Science, Information Technology, or a related field. Strong experience in creating database objects: Tables, Stored Procedures, DDL/DML Triggers, Views, Indexes, Cursors, User Defined Data Types. In depth understanding of Oracle Performance Tuning using hints and EXPLAIN PLAN. Knowledge of RDBMS concepts, especially in Oracle environments. Familiarity with Oracle SQL Loader and External File Utilities. Experience with Snowflake cloud data platform, including SnowSQL and SnowPipe. Expertise in Data Warehousing concepts and ETL processes. Working knowledge of AWS or Azure cloud platforms for data operations. Keywords: wtwo procedural language Texas Database Developer - Onsite [email protected] |
| [email protected] View All |
| 12:25 AM 16-Jan-25 |