четвртак, 28. август 2014.

One usual working day of database software enginnering team lead (deputy)


  • Come to work at 7:45 (official working time starts at 8:15).
  • Read e-mails from previous day and send response to urgent ones. One is to the our client in USA (North Carolina) where they ask me if they can execute SQL scripts in a way I have told them to do.
  • Prepare a coffee - Nescafe with lots of milk.
  • Surf the internet while drinking coffee and reading the news from two news site B92 and Blic.
  • Other team members are arriving in the office between 8 and 9.
  • Send an e-mail to admin team to allow me VPN to client system (in USA) for live connection which should happened at 13:00h (7:00 am client time). I should observe their actions over QA databases.
  • Prepare for that activity.
  • Consult my boss (which is on vacation) what we should do with one problem, which is not in our domain but one PM is trying to push us into solving it. My boss is also reluctant to do that, so I presume that we will leave this to the owner of this to fix the issue.
  • Overhear team members where were discussing conclusions from yesterday meeting about OSI PI integration.
  • At 9:20 SCRUM stand up team meeting. There are 3 sub-teams, and all team members are present, except the people who are at vacation. Our language is English, since one of our team member is Italian.
  • Meeting took about 10 - 15 minutes, where we briefly discuss current issues for that day.
  • Preparing report about current status in a team for a meeting at 10:00, with other team leaders. Report consists of development status for projects in development phase, and bug resolving status for projects in maintenance, support and warranty phase.
  • At 10:00 there is a meeting with other team leaders. where we are passing through our reports, and inform our supervisor (director) about issues which need to be discussed. Meeting took about 30 minutes. During the meeting, speaking with some of the team leaders about situation in a company, and listen to his complaints, which I understand, and feel the same but we are not in position to do anything about it. I asked him did he speak with his managers, and he said that he spoke with them but without result. We are discussing some bug which needs to be solved, but since this is some very old project, we are not sure is there a still test system for that project, and PM for that project is on vacation, so we do not know.
  • On my way back to the office, I am visiting one of the sub team leads to remind him that his duty is to transfer bug from project Bugzilla to our internal Bugzilla where bugs are going to be processed.  
  • While being on meeting there were several new mails which need to be answered. One of them requires a report for tomorrow, with people absence during a previous month. Because I am hungry, at 10:45 a took a breakfast. With going to the store, it took about 20 minutes for finish this. While siting for the machine, I am drinking chocolate milk.
  • At 11:00 I am starting to create absence reports. I need to speak with almost all of the people to check one more about reasons.
  • At 11:30 I finish report.
  • After finishing report I have received an e-mail to do the QA for two things which are developed. Since our QA machines are not updated for couple of days, I am connecting to them and run procedure for updating repositories. While repositories are updating I come to the idea that I would create this article which may be read by someone who would like to know - what's like working in IT on this particular position.
  • At 11:45, I am starting to write this article. Now is 12:00, and I am going to update it at the end of the day.
  • At 12:00, QA repositories are update with latest changes, and I am going to do the QA process for two development projects. QA consists of checking the code, build the repository, some simple testing (thorough testing is done by the development guy himself, and it will be additionally tested by test team when this reach them). 
  • At 12:05 reading the report from one FAT testing for one project in India. We are going well.
  • At 12:06 two project repositories are in build process, and I am ready to push the changes to central repository. While projects build is underway, I am reading latest from Harvard Business Review. I am not quite sure why I am reading this since I will never be any Cxy (COO, CEO, CMO or some other), but it keeps me in a illusion that I can become different person that I am currently. 
  • 12:15 Changes are pushed to central repository. I think that it will be all for QA for today. 
  • 12:20 I've just find out that our R&D introduced some new database into upcoming release. I am not quite sure why they need it to be in production, but this is always the same situation, for every new release - we from project delivery are figuring out how thigs are working not by reading documentation, but installing that on client, and observing it.
  • 12:25 I've just remember that I did not drink a water for whole day! Going to drink a glass of water. Or two, to be sure that I am not going to dehydrate. Before that I need to make some spaca to do that. While going to the bathroom, I spotted one guy who is leaving our company. I was joking him with "Dead man walking". He came to the company 10 years ago, one year before me, and he was (and is) one of the best computer\software people I ever met. We were good colleagues, and I am really sorry that he is leaving. I am also little bit worry that also few other people hav left the company in last year.
  • 12:30 Listening to https://www.youtube.com/watch?v=SZQzW_QfPew
  • 12:30 - 12:55 Going through our dot project, where task on projects are defined to see if there are some delays, and update weekly project delivery report if I find something connected with our DB team. I have found two delays, and address them - by moving finish date, or contacting PM to do that.
  • 13:10 - I've got an email from client from NC, which said that they successfully applied SQL scripts I created. Bravo me! :-)
  • 13:20 Another mail regarding discussion about OSI PI integration emerged from R&D. Yesterday we have very productive meeting where PM, project delivery and R&D participated, and we have created some cool solution. Today we need to discuss some more details (new meeting is organized for 14:00), but the path is quite clear and I presume that we are going clear remaining items as well.
  • 13:40 Mail from NC. They got some errors, but errors are not so big. They just did not follow a document which I have send them. I hope that there will be no more errors...Nobody reads documentation.
  • 13:55 Since I am old school,working for the company for 9 years, people come to me to ask some things about older version of our software. Since I love that version, I do not complain when need to answer something. Generally, I like answering different questions and teach people.
  • 14:00 Another meeting for OSI PI integration. On previous meeting, I thought that we are converging with solution, but during this meeting I got scared that we are diverging from solution. And the deadline is very near. I do not like these situations. Instead of 1 hour, meeting last 1 hour and 45 minutes, with 12 new things to reconsider. At the beginning there were only 4 points!
  • 15:45 Late lunch. Usually I go to the lunch at about 14:30. I am eating very fast(because I am thinking about work) and I finished my lunch in less then 15 minutes. This is not good for my health. Always postponing thinking about proper dietary.
  • 16:00 Another mail from NC. I said that they should execute script 1 on system A, and they executed script 1 on systems A, B, C and D...And they asked me what did they do wrong. I answered politely as possible.
  • 16:05 I have started revision of the some ETL process for some whole another project, which one on my colleagues is developing. Giving him suggestion what to do, and point him to the questions he need to ask and to which people these question should be sent.
  • 16:40 I hope that I will finish my working day now.
  • After doing revision of this article, and click Update button, I am going to fill my time sheet for today, and leave at 16:50. All in all, 9 hours working day. Not so bad ;-)


Нема коментара: