Oracle SQL DBA
No H1B(Only usc gc ,gc ead and h4)
At least 10 years.
- Assist with schema design, code review, SQL query tuning
- Proactively and regularly make recommendations for system improvements
- Perform review of schema, stored procedures, and other changes to the database DDL.
- Expert knowledge of PL/PgSQL, triggers, and stored procedure development and optimization in PostgreSQL
- Experience with PostgreSQL in the cloud, including Amazon RDS
- Analyzing the method of transforming existing data into a format for the new environment and the loading of this data into other database structures.
- Reviewing existing migration tools and providing recommendations for improving performance of the migration process.
- Providing necessary change and support documentation.
- Extensive experience with database technologies (MySQL, MS SQL, PostgreSQL Oracle, MongoDB)
- Experience with cloud services (AWS, Microsoft Azure) a plus
- Excellent written and verbal communication skills
- Previous experience with DBA case tools (frontend/backend) and third party tools
- Familiarity with programming languages API