Sr. Database Developer
CurrentI’m a core member of the VIP I/T database developer group which is responsible for creating, maintaining, and deploying backend Oracle database PL/SQL code for the purpose of compensating ACN IBOs (Individual Business Owners) in 28 countries. As a senior-level developer, I participate in compensation plan requirements review sessions with senior management and business partners to clarify business needs for new projects. Once requirements are reviewed, I provide LOE estimates in MS Excel for project delivery managers. I attend daily scrum meetings to communicate accomplishments and roadblocks. I create a development approach document in MS Word and supplement with data flow diagrams (using MS Visio) as necessary to clarify the design. I create and modify PL/SQL packages, procedures, functions, triggers, DDL scripts, and DML scripts using Toad and SQL Developer, and complete thorough unit testing and performance tuning before turnover to the QA team. Finally, I attend weekly change control meetings to ensure code is implemented successfully, followed by post deployment spot checking of the data in our production database to get ahead of any potential issues.In addition to software development duties, I continue to participate in a monthly support / on-call rotation of developers to monitor system processes during the evenings and weekends. I lead a weekly meeting to discuss production support issues. As new developers join the team and our support rotation, I’m the primary person responsible for training them on our system monitoring process.