Janette Andrews
Senior SQL DBA at Colonial Pipeline Company- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
Topline Score
Bio
Experience
-
Colonial Pipeline Company
-
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.
-
-
-
Outcomes Health Information Solutions, An Altegra Health Company
-
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.
-
-
-
Atlanta Capital Management Co., LLC
-
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