Katrina Sims Email & Phone Number

Belmont, Nc, Us

Charlotte, Nc, Us

Manage 8 agile teams that deliver business initiatives and architectural improvements for 3 Tier 1 / always up applicationsTeams include 22 employees and 55 contractors onshore and offshoreManage a 10 million dollar budgetManaged applications deliver real-time marketing insights and offers to customers and front-line unitsTechnologies include Oracle Exadata backend, Java API services, Datastage with Autosys jobs, and UI business front end applicationsBrought into a team to complete a 3-year project that was already one year behind. Was able to quickly determine the issues, organize the team and successfully deliver the project within 6 months. Worked the plan closely with the team and business partners to ensure awareness and buy-in.After completion of the project, was provided an opportunity to take on additional applications and teamsWorked closely with agile partners to migrate and guide the team into agilePassionate mentor taking on a couple of mentees through the company’s mentoring programsContinually focused on self-improvement through training, collaboration, Toastmasters, and mentorship programsFocus time and team to the values of building high performing teams: transparency, listening, speed of trust, quality, mentoring, accountability, good steward of the company’s assets, and learning from mistakes

Charlotte, Nc, Us

• Led a diverse team of engineers including developers, DBAs, architects and DevOps. Built team from 6 to 31 team members in 1.5 years across two locations• Implemented a roadmap for automated deployments and the benefits of continuous integration and continuous deployment (CI/CD) to improve efficiency and accuracy of delivering products to the business using JIRA, TFS and Octopus• Transitioned and trained the engineering team on agile• Implemented blue/green architecture to allow for application high availability and continuous uptime during patching and deployments• Led architecture discussions and challenged the team to build with scalability, reliability and automation• Created operational efficiencies through the implementation of a third-party pharmacy dispensing system• Provided real-time dispensing information to Prescribers through the build of a web Portal following HIPAA and security standards• Improved Clinical Staffs’ patient engagement through a green field Clinical Pathways tool allowing scheduling and questionnaires to monitor patients’ health• Worked as Scrum Master while building the team which included leading daily scrums, sprint planning, sprint reviews, retrospectives and building metrics to measure progress• Implemented pharmacy support improvements by leveraging ServiceNow

Charlotte, Nc, Us

• Managed a team of 40 engineers responsible for the support of all Premier production systems (QMR, SafetySurveillor, PhysicianFocus) that included Oracle, Netezza, Postgres, DB2 and SQL Server DBMS and all product technologies Cognos, MicroStrategy, Ab Initio, DataStage, Tomcat, etc. on Windows, UNIX/Linux and Solaris systems• Involved in the consolidation of Healthcare Informatics and Corporate divisions and took on additional DevOps and DBA team members• Proposed and wrote the job description for a Release Engineer position responsible for deployment automation and tool selection• Lead the federation of the Solution Support team to multiple product lines

Charlotte, Nc, Us

• Improved the build out of new environments by implementing standards for server builds and application installations and including procedures for team members to follow• Implemented a build and deployment schedule including processes ensuring deployments worked properly through all environments and did not jeopardize production availability

Charlotte, Nc, Us

• Built and managed a team of senior professionals responsible for production activities for Healthcare Informatics; including Java, MicroStrategy, QA, and DBAs responsible for Oracle, Netezza, SQL Server and Postgres • Developed a Tier II escalation process in the organization for the purposes of funneling client issues to a research group before they are sent to development• Led production operational events including all ETL processing and data releases for Premier’s comparative data warehouse on a weekly basis• Managed five Oracle production databases ranging from 400 Gig to 1 TB each, two Netezza production databases 4 TB each and ten to fifteen SQL Server databases ranging from 1 Gig to 100 Gig• Coordinated and managed government Quality Measures data submissions by working with the Data Management group and ensuring data is properly updated and submitted to the correct government agencies• Used Subversion to keep scripts needed for projects or production related issues• Interfaced daily with internal customers to solve complex database and application issues• Communicated to management and directors inside and outside of IT daily providing updates and KPIs on production issues and status• Proactively found process improvements and implement changes as needed

Charlotte, Nc, Us

• Managed a group of DBAs responsible for Oracle on UNIX, SQL Server, Netezza and Red Brick on UNIX• Improved backup and recovery methodologies by standardizing processes and procedures• Planned and performed maintenance for production, quality assurance and development environments; including regaining space from database reorgs, moving from pfiles to spfiles, and adding or removing indexes based on index monitoring in Oracle• Personally, mentored junior level DBAs to grow their skills

Charlotte, Nc, Us

• Responsible for administration of over eight production databases, four of which totaled more than 1TB of data• Managed Oracle backups using Oracle RMAN Backup and Recovery• Created backup plans and scripts and tested recovery on a quarterly basis• Cloned databases from one server to another server using RMAN• Performed capacity planning and tuning on all Oracle databases• Team Leader responsible for managing and distributing tasks and work load to four other DBAs• Responsible for managing and performing database upgrades and performance related tasks for the Oracle databases• Experience in writing SQL, PL/SQL, Procedures, Functions, Packages and database Triggers to meet business requirements• Executed and Project Managed movement of databases from a Solaris platform to a Fujitsu platform

• Managed Systems, including Oracle RDBMS and Oracle Financials• Performed administration and trouble-shooting for Oracle Financials 10.4 (including GL, PO, AR, AP, INV, FA) and Oracle RDBMS• Coordinated the upgrades of Oracle RDBMS from 7.16.2 to 7.3.3.5 and Oracle Financials from 10.4 to 10.7• Led a team to implement Oracle Inventory for use in a production system• Used Oracle SQL*Plus and Oracle Discoverer/2000 proficiently

• Worked as a Technical Lead and sole Customer Contact for database development for USAFMC• Involved with all phases of software development, including job requirement analysis, ERD design, documentation (Data Dictionary, User’s Manual, etc.), table layout and design• Ran tables through SQL*Plus, built forms, and validated data entered into the forms through PL/SQL• Generated reports for customer using Oracle Reports• Experienced in using Oracle 7 and Oracle Developer/2000, which includes Forms 4.0 and 4.5, and Reports 2.0 and 2.5