John meeting 2

 00:01:37

1

Hey, John.

00:01:38

1

Afternoon.

00:01:40

1

Hey Robert.

00:01:41

1

How you doing?

00:01:42

2

Definitely keep myself busy.

00:01:45

1

Good, good.

00:01:47

1

That's what I count on is people that can be self motivated to, to get things done.

00:01:54

1

No, sorry I didn't get a chance to join you guys.

00:01:56

1

I actually did want.

00:01:59

1

How'd it go?

00:01:59

2

Oh yeah, no, yeah, it was pretty helpful within at least the, I guess the time that she had.

00:02:07

2

I think she was kind of in back to back calls so.

00:02:13

1

Sorry.

00:02:14

1

There's a patching release that she has to kind of be available for because the restarts using one of the automation tools like Ansible to do restarts doesn't always start up those Payara servers the way it's supposed to and it starts screwing stuff up.

00:02:34

1

So she's got to validate and run some messages through it to make sure it's working and have them redo it and pick it a few times.

00:02:44

1

So yeah.

00:02:45

1

So yeah, not something that you want to spend an afternoon on, but she had to do it for a couple hours.

00:02:52

1

I think she might be wrapping up now.

00:02:54

2

Yeah, yeah.

00:02:55

2

So yeah, that's Piara seems a little finicky, let's put it that way.

00:03:01

1

Yeah.

00:03:01

2

With what I've gathered so far.

00:03:02

2

But yeah, she wanted to I guess kind of drop a little early just to go grab lunch, which is fair, you know, because I guess she'd get pretty tied up all morning, I guess and that's fine.

00:03:13

1

And here's the thing, I didn't expect, you know, to you to get everything that you needed from it, but maybe with the understanding of what the service does and what they're trying to do and then you know, diving into where they're doing that validation, where are they applying those changes?

00:03:34

1

So, so did you sort of pick up on what, what the, the ultimate goal would be for me to, to get you involved when available is they're working on, you know, each of those objects that, that were converted and you know, doing a, I don't want to say one to one validation of how it worked in Oracle.

00:03:59

2

Yeah.

00:04:00

1

Making sure that the result is the same in Postgres.

00:04:03

1

So I saw you put in the chat that if we look at any other tools and to be honest with you, from the conversion, the schema conversion tool, I think we leveraged the previous tool that we did, that SCT tool that we did for Direct Connect and gds because we had a consultant group help us out.

00:04:32

1

But that was years ago.

00:04:33

1

Right.

00:04:34

1

Things changed.

00:04:34

1

So I didn't know if, if you had any, any familiarity with the, with the tools you mentioned, but like was it aura to PG or something that you posted in there and then something else.

00:04:47

1

But we even met with AWS John to, to see what it is that we could, you know, what we have at our disposal and what we, you know, what we could leverage to, to make that effort a lot less painful.

00:05:05

1

So they didn't offer anything.

00:05:08

1

They offered the AI plugin or the AI assistant for Genai on the SCT tool to help convert more than what was originally done.

00:05:20

1

And that was just smoke and mirrors right there.

00:05:23

1

It commented out code.

00:05:27

2

Yeah, those gen AI tools will do stuff like that sometimes if you just kind of let them run wild.

00:05:33

2

I've found their.

00:05:35

2

And it depends on how good the I, I guess you could say like it depends on how well they were it was trained.

00:05:42

1

Right.

00:05:42

2

The model that it's running on and, and how, how much I guess compute you give it.

00:05:48

2

Yeah.

00:05:49

2

But yeah.

00:05:52

1

So my question to you John is, is one are, are you okay with taking something like this on?

00:05:58

1

And when I say this I'm keeping it open.

00:06:01

1

I'm saying there's the approach that Ashwini either went through and discussed with you thoroughly or there's the, you kind of know what we're talking about and you know, it shouldn't take long or you know, the final option which is hey, you could be doing this way differently and way more efficiently by doing X, Y and Z.

00:06:26

1

So first, what are your initial thoughts?

00:06:30

1

Yeah, maybe too early to make that type of of assumption but yeah, no.

00:06:35

2

I mean it's definitely a good question that it's kind of where my, my head was at too was like I guess I see two main paths that I think would be like best for us to like you know, secure like a good win for me like helping with this is.

00:06:50

2

Yeah like that research of like looking into like additional tools and then hey, like this is my high level understanding of these tools.

00:06:56

2

Right.

00:06:57

2

Like you know, if it makes sense with the timelines that we're working on and honestly where that I guess sub project is at.

00:07:05

2

Right.

00:07:06

2

Let's leverage you know, one of these or and Ashwini and I kind of talked about this directly.

00:07:13

2

Right.

00:07:13

2

Is just kind of having me like jump into like a less complex query to refactor over into because I, I don't want to.

00:07:24

2

Well I'll put it like this right.

00:07:25

2

Like I, I don't know, I guess it seems like you've got a copy of my resume in front of you and you know, things get kind of lost in the game of telephone sometimes I Guess between yeah, you know, interview and going to the actual person sort of thing.

00:07:35

2

But yeah, I mean like as far as I'm guessing maybe you guys saw like the, you know, the Oracle DB migration work that I was doing over at Northern, right?

00:07:42

2

And then.

00:07:43

1

And the skill skills with Postgres, right?

00:07:46

1

Yeah, yeah.

00:07:48

2

So I mean like to, to kind of clarify on that, right?

00:07:51

2

Over at Northern that was really, I mean I would say like at least two thirds of my job over there was more like kind of like a DevOps engineer, right where I wasn't like, you know, translating SQL queries for them but like it was more like hey, here's this solution, right of like how you would for example with Liquibase, like migrate over or here's how you would use like an Azure managed service and here are like the recommended Azure managed services for us to just kind of plug and chug the data from on prem Oracle up into Azure.

00:08:27

1

Right?

00:08:27

2

Okay.

00:08:29

2

I mean that said, like I'm you know, pretty comfortable with like SQL Postgres especially, right.

00:08:34

2

And so I think yeah, that's probably like another good option is for like me to take a ticket that's like a, I guess maybe like a smaller or like a lower risk query and just like translate that and then kind of go from there.

00:08:48

2

I, I mean does that, does one of those sound like a bad idea to you or like which one do you think would be maybe more useful?

00:08:55

1

Well, if I were going to ask you to help, you know, provide additional support, the latter would be the way that I envisioned not knowing of any other options or tried and true options because and this is just, you know, this is just me being very transparent for enterprise solutions or application solutions.

00:09:23

1

At an architect level we've got one architect that is not fully engaged with all of our applications.

00:09:33

1

So Ball is here specifically for the Disk team, but he was embedded into PMX from the get go.

00:09:43

1

So he never picked up on the other applications.

00:09:46

1

He's aware of how they work and he's aware of, you know, different.

00:09:51

1

Different.

00:09:53

1

You know, let's just say that the way they're set up, how they process and you know, general overview.

00:10:03

1

But when it comes to, you know, deep diving into oh the stored procedures or oh, this is how the service works or you know, these are the triggers and all that stuff, he doesn't have that, that, that wherewithal because he hasn't actually, you know, dove into it.

00:10:20

1

So he's provided architectural, you know, guidance and solutions that were potentially, you know, for to help us out.

00:10:30

1

But it's only delayed it.

00:10:31

1

So, so I'm not really looking for the, the, the, the, the alternative unless you know that there's something that's tried and true.

00:10:40

1

So other than that, then, yeah, that would be the way to do it.

00:10:44

1

So that, that's one less ticket that we're able to get out on a weekly basis or however we end up turning through those.

00:10:53

1

And then the other part of that is this is what Matendra is doing.

00:11:00

1

He's breaking up the SQL queries, at least to get the syntax correct.

00:11:04

1

And he's breaking out the select statement, the where clause and stuff like that on Copilot because you can't plug in the whole thing because I don't have an accurate actual.

00:11:12

1

We don't have an actual AI assistant on any of the embedded software, although some people do.

00:11:19

1

So I kind of don't want to say too much, John, of how people are doing things.

00:11:24

1

I know Amazon Q is okay, but, but at the same time, I don't know, I don't know from the, the, the Oracle to Postgres what, what can be leveraged to do it.

00:11:34

1

So I know, you know that there's, There's Copilot and GitHub and that hasn't been approved yet, which I did go out and check.

00:11:41

1

So.

00:11:42

2

Yeah, but wait, so Amazon Q is approved for some of the coding work that we're doing, you're saying, but not necessarily correct?

00:11:51

1

I believe so.

00:11:51

1

I believe that.

00:11:52

1

I don't want to say.

00:11:53

1

Not for this.

00:11:54

1

I just don't know if it's being.

00:11:55

1

If any of the others are using it for this.

00:11:58

2

Yeah, it's.

00:11:58

2

Yeah, it's tricky.

00:12:00

2

I don't know if there's like a subscription model with that.

00:12:03

2

I haven't used that one specifically before.

00:12:05

2

I've mostly used the ChatGPT Codex.

00:12:08

1

I had somebody sharing, sharing their KIRO on.

00:12:14

1

On VS code.

00:12:16

1

Yeah.

00:12:16

1

For.

00:12:17

1

Yeah.

00:12:17

1

And you know, I don't know what can do what.

00:12:20

1

And that.

00:12:21

1

That's probably my upcoming, you know, skilling up is getting more, you know, understanding of what you can use and how to use it or how to leverage it.

00:12:32

1

But right now I know it can give you an executive plan to come up with a test case strategy and being able to get you where you need to be.

00:12:43

1

And from that standpoint, great.

00:12:44

1

It's more of a template and you plug in your stuff and things work how well it validates or checks on the postgres objects that were converted.

00:12:58

1

I don't know if you have to know exactly how it's supposed to work, which I'm assuming you do.

00:13:02

1

And you do that by doing it once in Oracle and the other time in Postgres, making sure it's doing the same thing.

00:13:09

2

Yeah, yeah.

00:13:14

1

Yes, I would be good with that, John.

00:13:15

1

And if you would be agreeable to it, that's probably the next steps to get you more acquainted with it with the Sweeney.

00:13:25

2

Yeah.

00:13:25

1

Okay.

00:13:26

2

Yeah.

00:13:27

2

And then like as far as like concrete ticket.

00:13:29

2

Yeah, I'm cool with like taking, I guess.

00:13:31

1

Yeah.

00:13:31

2

Like our understanding of a maybe like a lower risk one, you know, just to get my feet kind of wet with that, I guess.

00:13:40

2

Not to put you on the spot, but like, are there any maybe tickets that come to mind that kind of fit that criteria?

00:13:47

1

Well, so let me share with you something.

00:13:48

1

Hold on a second.

00:13:49

1

Okay, it.

00:14:22

1

So each one of the objects that was detailed out has a, has a.

00:14:26

1

The initial story that's tied to it.

00:14:30

1

So we've broken those out into level of complexity.

00:14:36

1

So you can see each one of the objects had a story to it.

00:14:38

1

Right.

00:14:39

1

So yeah.

00:14:39

1

Yeah.

00:14:40

1

Okay.

00:14:41

1

Packages and procedures.

00:14:44

1

Here's the JIRA stories that are tied to it.

00:14:46

1

What we've done is any of the team that have grabbed one, you know, basically input their, their information.

00:14:55

1

So here's, you know, the different RTC packages and procedures.

00:14:59

1

Here's the gold one packages and procedures.

00:15:03

1

So this is RTC's the real time cache.

00:15:06

1

So this is the stuff that's on 85, Gold 1.

00:15:09

1

This is the packages and procedures on Gold 1 or 03, which is the two Google packages.

00:15:18

1

RTC, Gold 1 procedures.

00:15:24

1

You can see there's a few and then functions.

00:15:27

1

I'm thinking maybe the function that you look at.

00:15:31

1

But if I go to the status here, each one of those tabs has been identified as to what Ashwini consider whether it's high complexity, low complexity or medium.

00:15:44

1

Yeah.

00:15:45

1

So from that standpoint, I don't know if it would be looking at.

00:15:49

1

Well, you won't be able to do AWS jobs.

00:15:52

1

This is BW batch jobs that were created that are to pool data reporting stats and stuff like that.

00:16:02

1

This will be like the last thing that we work on because I'm not really concerned with it.

00:16:06

1

But for me it's just going to change the database references on how it generates the reports.

00:16:15

1

So out of the question on that one, the other DB objects, there's only one of those.

00:16:22

1

And then gold one type RTC and gold one types, there's 26 of those.

00:16:28

1

None of those have been done.

00:16:37

1

So not sure if, if if it would be those objects or having a Schwinni sort of cherry pick and tell you which one to look at she wants, it might be.

00:16:50

1

It would be easy from.

00:16:51

1

From this category.

00:16:52

2

Yeah.

00:16:52

2

Do you.

00:16:53

2

I don't think I have a copy of that spreadsheet.

00:16:55

2

Would you mind?

00:16:55

1

I'm gonna start.

00:16:56

1

I'm just gonna start adding you to.

00:16:58

1

To the chat.

00:16:58

1

I didn't want to add you until you had a conversation with a Sweeney.

00:17:02

2

Yeah.

00:17:02

1

But I've got no problem adding you to the chat and you'll have access to it.

00:17:05

2

Okay, cool.

00:17:07

1

So there's this one, and there's a push dev discussion.

00:17:11

2

Yeah.

00:17:12

2

And then I could just like.

00:17:14

1

Yeah.

00:17:14

2

Take a look at it and kind of analyze that and then give you.

00:17:20

2

I would say, like, hey, you know, can I just take this one by day today?

00:17:24

2

That sounds fair to you?

00:17:26

1

That's totally fine and fair.

00:17:29

1

Cool, cool.

00:17:35

1

And then you should have here all of these Tech offshore.

00:18:04

1

Ashwini, who you spoke to, Bala, the.

00:18:07

1

The architect.

00:18:09

1

Brandon's are.

00:18:10

1

He's.

00:18:11

1

He's a dva.

00:18:12

2

Yeah.

00:18:13

1

GOPI is a bench resource, but he's helping out Aretha, she is our DB expert on our team, but she's offshore as well.

00:18:24

1

So she's the one that's kind of gotten past some of the obstacles of Oracle functionality that was needed for postgres, like partitioning and stuff.

00:18:36

1

So she's very good.

00:18:38

1

And then yourself.

00:18:40

1

Cool, cool.

00:18:41

2

And then I guess just to help be mindful of who I ping, if I ping someone directly, you said, go, gopi.

00:18:50

2

He's a.

00:18:51

1

He's.

00:18:51

2

He's on the bench, I guess you're saying.

00:18:53

2

Or is he?

00:18:54

1

Well, no, he's.

00:18:55

1

So there's.

00:18:56

1

For resources from tech, we call them incremental core and bench.

00:19:02

1

So core is like a Sweeney.

00:19:03

1

So she's, you know, like a base employee, but dedicated to us.

00:19:08

1

The incremental ones are the offshore resources that, you know, take on additional development support, maintenance, off hours, and then bench being tech has an individual that wants to skill up, and we're not really paying for them, but they're helping out.

00:19:27

1

So.

00:19:28

2

Okay.

00:19:28

1

Yeah.

00:19:29

2

Okay.

00:19:30

2

So, yeah, so carries a different meaning in the consulting world.

00:19:35

2

Yeah, makes sense.

00:19:37

1

So, yeah, from that standpoint, you can probably ping in your questions in that Oracle 1 in the Oracle chat that I first added you to.

00:19:46

1

Yeah.

00:19:47

2

And I don't know if that showed up on my end.

00:19:51

2

What is it called again?

00:19:52

2

Oracle.

00:19:52

1

Oh, how about I do this?

00:19:54

1

So, John.

00:19:58

2

Yeah, the.

00:19:59

2

The push migration dev discussion one worked, but I think you Added me to a second one.

00:20:03

2

I didn't have the teams screen share open now, so I'm not sure if you did.

00:20:11

1

Again.

00:20:11

2

Yeah, that one worked.

00:20:12

2

And then there was a second one.

00:20:15

1

That one right there.

00:20:15

2

That one?

00:20:16

2

Yeah, that's the one that I didn't.

00:20:18

2

I don't know if it added me or what happened.

00:20:40

2

Cool.

00:20:40

2

All right.

00:20:41

1

Got it right on.

00:20:43

1

Other than that, I did get your email on the analysis on the paying with points for elite tiers, stuff like that.

00:20:51

1

I have not gotten to it yet, so if there's anything that, that I can read into it.

00:20:57

1

I'm assuming that you got more information, just not specific details.

00:21:02

1

I'm guessing not because of what you sent, only because I'm guessing they didn't know how they were gonna do it with.

00:21:10

1

The response I got back was not that it's on hold, but because of the dependencies on Canary that they needed to get some assumptions out of the way for GRs and GWs, which anybody that would be doing anything similar, like using a new rate plan for lesser points and stuff would be after they finish their work or, or get those assumptions out of the way.

00:21:37

2

Yeah, so I didn't look into that a ton.

00:21:42

2

I mean, honestly, I just did my best to like kind of answer the questions that you kind of explicitly outlined when we, when we spoke and then what was in the story criteria as far as like getting those answers?

00:21:52

2

I mean.

00:21:52

2

Yeah, I pulled them mostly from Turner, like where I couldn't get them from like Apex stocks that we have, which I can.

00:21:59

2

I don't know if I can share those with you.

00:22:01

2

I was about to offer too, but like, I don't know how that.

00:22:03

1

Don't, don't, don't worry about it.

00:22:05

1

The.

00:22:05

1

The politics there for now.

00:22:08

1

Let me look at it and then I'll come back with.

00:22:10

1

With any questions or follow up and we can go from there.

00:22:13

2

Sounds good.

00:22:13

2

Cool.

00:22:14

1

Cool.

00:22:15

1

All right, John, let me know if you need anything.

00:22:18

2

Oh yeah, just like kind of like a general open question, like.

00:22:20

2

So, like as far as priorities go, between the DB migration and then the kind of bug ticket that I've been working on, do you want me to keep the bug ticket as priority or swap over to the DB migration as higher priority?

00:22:36

1

Keep the bug ticket.

00:22:38

1

If it's something that we can get past from your analysis, investigation and potential development, I can always hand off the development to somebody else and then get you going on the postgres stuff.

00:22:52

1

Okay, cool.

00:22:53

2

Yeah.

00:22:54

2

Yeah, I guess I'll let you know if I get majorly blocked, but I think I'm making good progress now.

00:22:58

1

Okay, perfect.

00:23:01

1