Urgent Hiring :Oracle PL SQL,Location:Must be local to NYC area at NYC, New York, USA |
Email: [email protected] |
From: sujata, Vyzeinc [email protected] Reply to: [email protected] Oracle PL/SQL I need only 2 profile at this time Location: Must be local to NYC area onsite from day 1 2x per week+ (no generated bills please) Duration: 6 Month Visa: USC, Gc Must have LinkedIn Interview Mode: Round 1 virtual with team lead and possibly some other team members technical interview Round 2 possible in person meet and greet but not necessary Must have: Oracle PL/SQL Postgres Complex queries AWS huge plus Job Details: -3-6 years of experience writing PL/SQL Developer who has experience in Oracle or Postgres. 90% of the databases they are working on are Postgres. -Ability to write complex queries and develop reports to support business needs. Users are primarily Sony Music's music Labels; their "customers/external users". -Documentation of processes, reports, and database relationships and ensuring databases meeting business requirements. -Diagnose and resolve database access and performance issues. -Automate and execute required database reports and migration activities using Linux shell scripting/Python. Plusses: -AWS RDS experience. (100% of databases are now in AWS Cloud). -To automate more modern apps they use Lambda/Python. It is simple code and not a must-have, but someone who is at least open to learning. Day to Day: As a Database Developer, you will play a crucial role in designing, coding, and maintaining databases across Sony Music Entertainment. Collaborating closely with senior developers, you will implement business needs and evaluate technology components for effective database management systems and applications. Your responsibilities will also include diagnosing and resolving database access and performance issues, developing change control and testing processes, and ensuring all database systems meet business and performance requirements. The Database Developer will be a part of the team managing the Asset Management & Promotional Systems team of the Digital Supply Chain group, focusing on databases as a layer, supporting various databases such as PostgreSQL, MySQL, Mongo, and Oracle, and contributing to the modernization of applications into microservices. All of these systems are internally developed systems by Sony, and theyve been on these systems since 2005. Since 2005, there have been upgrades, maintenance, and new feature additions. There will be a focus of pulling microservices and writing reports and backfilling scripts for performance and data issues. They will be managing Kafka on the backend for messaging and GraphQL. The role involves collaboration with app developers, end-users, and business users being music Labels, particularly in generating trading reports and scripts. This team supports close to 50 databases, but this person will be supporting about 6 databases; about 2-3 applications (each application has 3 databases). Keywords: information technology green card procedural language Urgent Hiring :Oracle PL SQL,Location:Must be local to NYC area [email protected] |
[email protected] View all |
Thu May 30 09:17:00 UTC 2024 |