Joe Phillips

Joe Phillips Email and Phone Number

Database Administrator at Texas Windstorm Insurance Association @ Texas Windstorm Insurance Association
Austin, TX, US
Joe Phillips's Location
Austin, Texas, United States, United States
Joe Phillips's Contact Details
About Joe Phillips

MS SQL Database Administrator who's dabbled some in Oracle/Sybase. Past opportunities include: Systems Analyst for government State Agency, DBA for private insurance association, DBA work with Massively Multiplayer Online Gaming Companies, work with Fed Govt. as a contractor for NG, and Corporate Enterprise DBA consulting for IBM (USA).Goal: To Ensure Everybody's Got Data!Specialties: Database installation/administration, security, performance tuning; database (OLTP & OLAP) physical/logical architecture and design; trouble-shooting, high availability, db programming.

Joe Phillips's Current Company Details
Texas Windstorm Insurance Association

Texas Windstorm Insurance Association

View
Database Administrator at Texas Windstorm Insurance Association
Austin, TX, US
Website:
twia.org
Employees:
175
Joe Phillips Work Experience Details
  • Texas Windstorm Insurance Association
    Texas Windstorm Insurance Association
    Austin, Tx, Us
    View
  • Texas Windstorm Insurance Association
    Database Administrator
    Texas Windstorm Insurance Association Mar 2016 - Present
    Austin, Texas, Us
    Monitors and analyzes current databases and their performance/stability; makes recommendations to improve performance, and implements recommendationsReviews database changes recommended by development and network administrators while providing feedbackAssists developers and network/system administrators in problem analysis and resolution; makes recommendations, accordinglyCoordinates changes to databases to ensure implementation goes smoothly and without incident.Designs new databases and changes to current databases in concert with the system development teamMaintains a data dictionary of TWIA-developed databasesAssists in installing new software with respect to databasesAssists Quality Assurance in setting up test environments, as requiredReviews upgrades to current versions of SQL Server and makes recommendations for implementation of those upgrades considering input from System DevelopmentReviews database maintenance plans and results; recommends improvements and implements improvements, as appropriateRecovers databases from backups, as requiredAnalyzes growth patterns in database size and recommend increases in disk space requirementsAssists in designing, coding, unit testing, and installing stored proceduresEvaluates and recommends software tools to monitor the performance of the IT infrastructure and application systemsEvaluates and recommends the overall IT hardware/software architecture for the production, test, and development environmentsEvaluates and recommends the IT service level objectives for response time and availability and responsiveness to support requestsEvaluates and recommends IT processes and procedures and defining deliverables for system development and system operation
    View
  • Texas Windstorm Insurance Association
    Database Administrator
    Texas Windstorm Insurance Association Mar 2016 - Present
    Austin, Texas, Us
    View
  • Thermon Manufacturing Inc.
    Database Administrator
    Thermon Manufacturing Inc. May 2012 - Feb 2016
    Austin, Texas, Us
    • Provide on-going SQL SERVER 2008 clustered server support for MS AX2009 multi-company ERP installation in use by global Chemical/Petroleum Engineering and Manufacturing company. Performed database auditing, performance turning and administration.• Configured and implemented SQL SERVER multi-node High Availability Disaster Recovery(HADR) cluster for AX2012 Dynamics environment. Cluster utilized Database Availability Groups(DAG) and databases operating in synchronous and asynchronous mode, which also included configuration of group listener for DAG and read-only routing for secondary replicas. Performed rolling upgrade of multi-node HADR cluster from SQL SERVER 2012 to SQL 2014, with minimal downtime per best practices. Set up custom scripts to manage full/transactional backups across the HADR nodes,configured DAG preferences for which node backups occur on,monitoring/alerts for backup jobs. • Set up Microsoft DDL triggers to support change tracking and version control of AX database schema. Implemented scripts for database consistency routines across the HADR nodes, optimized to perform lowest performance impact version of DBCC based on what role the database replica has been granted within the DAG. Set up DynaPerf database objects/jobs to gather performance data for tuning the AX2012/AX2009 environments.• Designed, programmed, and tested implementation of SOX governance changes on company database systems. Documented fully through a controlled change process, also provided full security audit of entire database environment.• Served as key team member of Microsoft AX implementation and support team- including SSAS/SSIS/SSRS work for BI/DW projects related to AX.
    View
  • Tek Systems
    Sql Developer/Dba
    Tek Systems Jan 2011 - Apr 2012
    Hanover, Md, Us
    Provide documentation, maintenance and integration of hardware, application software, and custom applications. Laid out storage presentation and SAN zones, RAID types, installed and configured HBA and failover path software, database and O/S clustering. Also installation and patching of SQL Server product itself. Verification through failover testing of various SQL SERVER services and resources to be sure active-passive node configuration works properly. Expertise with SQL SERVER 2005, 2008R2 and Windows 2003, 2008R2 in a multi-node clustering environment.Generate project plans for SQL Server migration and clustering efforts for customers with Production databases. Participate in technology planning associated with SQL Server and Microsoft Cluster Services. Ongoing migration of SQL Server 2000, 2005 databases to SQL Server 2008. This has involved both side-by-side and in-place upgrades of SQl instances. Running pre-upgrade analysis of existing DTS packages, reporting any errors or issues with the upgrade process that were detected. Acted as technical liason with development teams regarding existing DTS production packages and proposed migration paths to Integration Services, install and configure Integration Services. SQL Server 2005, SQL Server 2008. Some VB Active X scripting to establish load checks and precedence chains for ETL routines, subsequent re-factor of code once migrated to SSIS. Compilation of SSIS packages, upload to Integration Server, scheduled execution of jobs to call the packages. Most recently done for Unidata import processes into SQL Server 2005 of flat file data extracts for business reporting purposes.
    View
  • Austin Community College
    Database Administrator
    Austin Community College Jun 2009 - Dec 2010
    Austin, Tx, Us
    Coordinates with application developers regarding database development, migration, revision and update, procedure development, troubleshooting, system configuration, and account setup. Installs, deploys and upgrades database systems, maintains documentation, and performs routine database maintenance activities. Configures, monitors, and analyzes the performance and health of databases. Resolves database performance, capacity, and distributed data issues. Provides assistance to end users and programmers regarding database related problems and issues. Initiates processes and documentation of College-wide data warehousing system. Develops procedures to ensure security and integrity of data. Coordinates with IT project managers, programmers, web developers, and operational staff to define and ensure standards for database performance, availability, and security are being met. Develops and monitors the process for synchronization between different Database Management Systems. Manages end-user accounts and accessibility. Provides technical expertise to end-users who create complex queries and virtual fields. Coordinates, schedules, and tests upgrades to the College-wide database system. Researches and evaluates software, system upgrades and enhancements, and provides technical recommendations.
    View
  • Ibm Global Services
    Database Administrator
    Ibm Global Services May 2007 - Jun 2009
    Armonk, New York, Ny, Us
    Worked as a Database Administrator/Consultant. Provided Lead Technical support for MS SQL Server DBA group - SOT account. Wrote, tested, and implemented T-SQL scripts for Production/Test MS SQL SERVER databases. Scripts include table/trigger design, stored procedure, index schemes, and report generation for MS SQL SERVER databases. Installation and maintenance, as well as configuring and monitoring of database Software. Created multi-instance MS SQL Server Windows clusters. SQL 2000,2005,2008 installation and configuration. Enterprise roll out of TSM/TDP Products, MS SQL patches/security audits, SQL 2008 installs.
    View
  • Northrop Grumman Information Systems
    Dba
    Northrop Grumman Information Systems Nov 2006 - May 2007
    Falls Church, Va, Us
    Worked as contract consultant/on site DBA. In that capacity:Designed and implemented SAN solution for SQL SERVER 2005 on Windows 2003 2 node cluster for OLTP solution. Laid out storage presentation and SAN zones, RAID types, installed and configured HBA and failover path software, database and O/S clustering. This database system is in use with a government agency providing medical data processing. Provided technical support, enhancements, and troubleshooting of the databases running on SQL Server 2005 in a Windows 2003 clustered server environment, including SAN benchmarks with SQL SERVER for validation of configuration and improved db throughput.
    View
  • Ncsoft
    Senior Database Administrator
    Ncsoft Dec 2001 - Oct 2006
    Bellevue, Wa, Us
    Database design and implementation included normalization, T-SQL stored procedure programming and trigger design, security, and load testing/capacity planning for billing/login/game systems. Implemented encrypted, high performance SQL Server 2005 database mirroring across separate data center and Windows Domains. This included automated creation of database snapshots of the database mirror through stored procedures to be used for real time data reporting on Production databases and disaster recovery purposes. Strict adherence to SLA for high availability. • Administration and Publishing for Production database environments for On-line game servers across the Enterprise. Implemented Change Management Control, administered security at user, system, and object levels. Responsible for code moves into production environment during both regularly scheduled releases and emergency situations.
    View
  • Origin Systems (Electronic Arts)
    Dba
    Origin Systems (Electronic Arts) May 1999 - Dec 2001
    Redwood City, Ca, Us
    Operational DBA for EA.com online billing, Ultima Online, other games, Oracle databases/Solaris. MS SQL Server.Programming in PL/SQL for aggregate reporting on Ultima Online subscriber base.Upgraded production UO player database to SQL Server 7. Responsible for daily operations of UO game accounts database- an online game with 200,000 subscribers world wide. Backup/Restore, Security, Performance Tuning of all Production Databases.Responsible for archiving of on-line log database, purging of old character data using Shell Scripts, bcp/sql load data, implementing indexes for performance gains.Created MS Access database application for Online Ops to track departmental work orders.Implemented Oracle 8.0 instance on Linux for UO billing system conversion work.Implemented Security for Oracle- remote password files, password protect connect internal.
    View

Joe Phillips Skills

Performance Tuning High Availability Security Troubleshooting Programming Languages Databases Database Design Sql Disaster Recovery Windows Server Servers Integration Data Warehousing Linux Microsoft Sql Server Ssis Sql Server Integration Services

Joe Phillips Education Details

  • The University Of Texas At Austin
    The University Of Texas At Austin
    History
  • Westlake High School
    Westlake High School
    College/University Preparatory And Advanced High School/Secondary Diploma Program

Frequently Asked Questions about Joe Phillips

What company does Joe Phillips work for?

Joe Phillips works for Texas Windstorm Insurance Association

What is Joe Phillips's role at the current company?

Joe Phillips's current role is Database Administrator at Texas Windstorm Insurance Association.

What is Joe Phillips's email address?

Joe Phillips's email address is jw****@****att.net

What schools did Joe Phillips attend?

Joe Phillips attended The University Of Texas At Austin, Westlake High School.

What skills is Joe Phillips known for?

Joe Phillips has skills like Performance Tuning, High Availability, Security, Troubleshooting, Programming Languages, Databases, Database Design, Sql, Disaster Recovery, Windows Server, Servers, Integration.

Who are Joe Phillips's colleagues?

Joe Phillips's colleagues are Rajesh B Pmp®, Pmi-Acp®, Marianne Moul, Jeremy Grimsley, Hara Subhramanya Hanumanth Pasumarthy, Ninad G., Kimberly Williams, Allen T. K.

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.