Janette Andrews

Senior SQL DBA at Colonial Pipeline Company
  • Claim this Profile
Contact Information
us****@****om
(386) 825-5501
Location
Roswell, GE

Topline Score

Topline score feature will be out soon.

Bio

Generated by
Topline AI

You need to have a working account to view this content.
You need to have a working account to view this content.

Experience

    • United States
    • Oil and Gas
    • 700 & Above Employee
    • Senior SQL DBA
      • Apr 2017 - Jun 2020

      Alpharetta, GA I have built many PowerBI reports/workflows based on multiple data sources. I have also created many integrations with SSIS and reports with SSRS. In this role, I migrated all SharePoint databases to an upgraded version of SharePoint and SQL Server. As part of this migration, I set up and tested the SQL instance with SQL Always On to ensure continuity in any disaster recovery scenario. In conjunction with database administration to include installation, configuration, altering schemas… Show more I have built many PowerBI reports/workflows based on multiple data sources. I have also created many integrations with SSIS and reports with SSRS. In this role, I migrated all SharePoint databases to an upgraded version of SharePoint and SQL Server. As part of this migration, I set up and tested the SQL instance with SQL Always On to ensure continuity in any disaster recovery scenario. In conjunction with database administration to include installation, configuration, altering schemas, security management, performance tuning, and SQL job creation/maintenance. Show less

    • SQL DBA
      • Jun 2014 - Feb 2017

      Alpharetta, GA Database administration to include installation, configuration, altering schemas, security management,performance tuning, SQL job creation/maintenance and SSIS package creation/deployment. I have also installed several SQL 2012 clusters and installed and configured Always On across multiple states.

    • IT Services and IT Consulting
    • 100 - 200 Employee
    • SQL DBA
      • Aug 2013 - Jun 2014

      Database Administrator working on migrating SQL 2008 to SQL 2012, creating high availability and load balance via replication and log shipping and created a 20 server Development environment.

    • United States
    • Investment Management
    • 1 - 100 Employee
    • SQL DBA, VP
      • Jan 2011 - Jun 2013

      Atlanta, Georgia Database Administrator working on migrating databases from SQL 2005 to 2008, optimizing database performance by using SQL Profiler, Database Tuning Advisor and Query Optimizer • Acted as Project Manager, DBA, SQL Programmer, and QA efforts on an Order Management System project that saved $500,000 in annual ongoing fees. • Created scripts and SSIS packages to facilitate an ETL project to feed into an Eagle Warehouse. • Created SSRS reports and subscriptions to meet weekly, monthly and… Show more Database Administrator working on migrating databases from SQL 2005 to 2008, optimizing database performance by using SQL Profiler, Database Tuning Advisor and Query Optimizer • Acted as Project Manager, DBA, SQL Programmer, and QA efforts on an Order Management System project that saved $500,000 in annual ongoing fees. • Created scripts and SSIS packages to facilitate an ETL project to feed into an Eagle Warehouse. • Created SSRS reports and subscriptions to meet weekly, monthly and quarterly compliance needs.

    • SQL DBA, Asst VP
      • 2003 - 2011

      Atlanta, Georgia • SQL 2000/2005/2008 Database Administrator working with the latest SQL 2008 tools. Installed, upgraded, maintained SQL 2000/2005/2008. • Design and develop databases, tables, views and stored procedures in MS-SQL 2000/2005/2008. • Worked in MS Business Intelligence Development Studio to create and publish to web links using SQL Server Reporting Services. •Worked in MS Business Intelligence Development Studio to transfer and modify data between files to databases using SQL… Show more • SQL 2000/2005/2008 Database Administrator working with the latest SQL 2008 tools. Installed, upgraded, maintained SQL 2000/2005/2008. • Design and develop databases, tables, views and stored procedures in MS-SQL 2000/2005/2008. • Worked in MS Business Intelligence Development Studio to create and publish to web links using SQL Server Reporting Services. •Worked in MS Business Intelligence Development Studio to transfer and modify data between files to databases using SQL Server Integration Services. • Responsible for database security, architecture, performance tuning. Develop and maintain stored procedures, backup scripts, database restores, disaster recovery, fail over and high availability via SQL replication and log shipping. • Create virtual servers/workstations using VMWare. • Act as project manager, DBA, etc on many vendor applications, upgrades, migrations, etc.

    • Systems Network Specialist
      • 1998 - 2003

      Atlanta, Georgia • Installed many Windows NT and 2000 servers • Installed and configured Sybase databases • Installed and maintained Exchange 2000 mail system • Responsible for all Hardware/Software Purchasing, Installation and Maintenance • Responsible for data integration between systems • Responsible for 40 users for all Desktop Support

Education

  • University of Wisconsin - Milwaukee
    Bachelor's of Business Administration, Management Information Systems, Management Information Systems

Community

You need to have a working account to view this content. Click here to join now