Jeffery Alexander

Database Administrator at Texas Pipe Family of Companies
  • Claim this Profile
Contact Information
Location
Greater Houston
Languages
  • English -

Topline Score

Bio

Generated by
Topline AI

0

/5.0
/ Based on 0 ratings
  • (0)
  • (0)
  • (0)
  • (0)
  • (0)

Filter reviews by:

No reviews to display There are currently no reviews available.

0

/5.0
/ Based on 0 ratings
  • (0)
  • (0)
  • (0)
  • (0)
  • (0)

Filter reviews by:

No reviews to display There are currently no reviews available.
You need to have a working account to view this content. Click here to join now

Experience

    • United States
    • Oil and Gas
    • 1 - 100 Employee
    • Database Administrator
      • Jul 2023 - Present

      In this role, I actively contribute to all phases of the development cycle that will take my skills and experience to the next level. Job Responsibilities: * Act a as subject matter expert across products, for the modification and creation of database schemas and queries * Analyze database usage patterns to optimize performance for indexes and queries. * Participate in all phases of the software development lifecycle – requirements, architecture, design, development, testing, and deployment. * Install, configure, and maintain databases in Linux and Windows environments, both in cloud and on-site. * Structure database security so that the framework of “least privilege” security practices are followed at all times. * Participate in the project planning process including estimating and process improvements in an Agile environment. * Developing new features, enhancing existing features, fixing bugs and upgrading software to maintain tech health. * Always strive to do work using best practices – through experience or experimentation. * Collaborate with application and management teams to ensure projects comply with standards and meet expectations. * Create and maintain documentation to ensure manageability and supportability. * Assist development teams with data architecture, query, and performance tuning. * Maintain scripts for automation of routine tasks. * Perform capacity planning and system resource evaluations. Show less

    • Independent Consultant
      • Jan 1998 - Present

      Troubleshot hardware and Software issues for PC and Macintosh Computers. Installed Microsoft Windows Operating Systems (WIN 95 and above). Installed Microsoft Office Applications (Word, Excel, and Access). Hands-on experience in resolving locks deadlocks, handling Isolation levels and performance issues like CPU, I/O, Memory bottlenecks. Performed Logical data modeling using VISIO and ONE NOTE. Troubleshot hardware and Software issues for PC and Macintosh Computers. Installed Microsoft Windows Operating Systems (WIN 95 and above). Installed Microsoft Office Applications (Word, Excel, and Access). Hands-on experience in resolving locks deadlocks, handling Isolation levels and performance issues like CPU, I/O, Memory bottlenecks. Performed Logical data modeling using VISIO and ONE NOTE.

    • United States
    • Defense and Space Manufacturing
    • 700 & Above Employee
    • IT Database Administrator
      • Jul 2020 - Jul 2023
    • Sensior Systems Analyst
      • Aug 2019 - Jul 2020

      My responsibilities and duties at Maverick Resources include the implementing, analyzing, and maintaining of the following applications and systems: • (DBA) SQL Database Administrator • SharePoint • Enertia • ProCount • (WEM) Well Evaluation Model • Send Word Now • EVIN • WellView • (OFM) Oil Field Management • EMK3 My responsibilities and duties at Maverick Resources include the implementing, analyzing, and maintaining of the following applications and systems: • (DBA) SQL Database Administrator • SharePoint • Enertia • ProCount • (WEM) Well Evaluation Model • Send Word Now • EVIN • WellView • (OFM) Oil Field Management • EMK3

    • United States
    • Oil and Gas
    • 700 & Above Employee
    • Engineering Specialist
      • Dec 2016 - Jul 2020

      Create and manage multiple SpotFire analysis. Manage OBO proposal tracking database. Manage OBO production SQL database. Create and manage multiple SpotFire analysis. Manage OBO proposal tracking database. Manage OBO production SQL database.

    • Technical Business Analyst
      • Sep 2013 - Jan 2016

      Managed production data and assisting engineers in maintaining production and economic forecasts, as well as providing technical support for other engineering applications. Maintained Aries SQL databases for economic calculations. Provided technical support as the WellView and Prodview champion for Operated and Non-Operated Assets. Developed a processes in Access and SQL to automatically update the engineering databases. Was responsible for the monthly sales accruals estimates report, sales volumes variance report, field downtime. Created Marco embedded Excel Spreadsheets functions using VBA Vertical and Horizontal lookups. Supervised and trained junior engineering techs in the team in SQL database management, ARIES and Wellview. Maintained a complete and accurate well status of all properties in the operated assets, including field names, working and Net Revenue interests, region, and special area roll-ups. Managed Microsoft Access Databases Created Microsoft Access User interfaces using VBA. Generated various daily operations reports as needed. Updated Aries database as required. Create new projects within Aries for Engineers as needed. Provided support to field staff on Reporting, Production Surveillance, Downtime, as needed Generated executive production reports, perform reserves assessments and prepare corporate quarterly reports. Was the project Lead in the implementation of Prodview for production accounting and optimization. Oversaw the data integration between engineering, operations, accounting and land departments. Worked with Land Department with GIS – Esri 10.0 or above creating Polygons and other geo-reference features. Managed Asset identification for broad areas of interest. Created and managed Spotfire and Tableau reports to visually analyze comparison data between monthly and weekly production and sales of oil and gas products. Managed Microsoft SharePoint to share information throughout the business organization. Show less

    • DBA MANAGER
      • Sep 2011 - Sep 2013

      Assisted with SQL implementation. Entered data from upload templates into SQL (data / information into web based database). Entered personnel resources into SQL to enable actionable items (enable verification of data & requirements) Liaison with SQL administration / Support to UA implementation of SQL. Liaison with Drilling supervisors / superintendents (Sr. Well Engineer) for SQL compliance and completeness to enable implementation time targets (drilling, completions & well intervention work scope). Uploaded test frequency and criteria for each operational unit under contract (once a contract with service provider has been established with supply chain). Maintenance of SQL database. Updated database requirements for operational units under contract (contract with service provider). Focal point for SQL database. Liaison with Open-wells (software) engineering technician on well control test & operations data alignment & assurance. Liaison with service providers to obtain and collect missing data / certification to ensure compliance with SQL & PCM (pressure control manual) requirements / criteria. Hands on SQL DBA Show less

    • United States
    • Staffing and Recruiting
    • 1 - 100 Employee
    • SQL TECHNICAL ANALYST
      • Aug 2010 - Sep 2011

      Created and maintained MS and SQL databases to provide statistical and inventory management of multiple company assets. Assisted in implementing testing procedures of various HAN devices. Created Graphical Interfaces utilizing various programming languages. Created web applications in order to assist the company in obtaining statistical data from various sources. Applied Physical and logical data modeling using ERWIN & VISIO. Used SSMS-Creating and scheduling jobs, alerts and operators with SQL Server Agent, handling Backup/Recovery of databases, Replication, Linked Servers, and Database Maintenance. Experienced in resolving locks deadlocks, handling Isolation levels and performance issues like CPU, I/O, Memory bottlenecks Show less

    • ENGINEERING TECH /SQL DBA
      • Jul 2005 - May 2010

      Maintained statistical, production, market, and news databases on a daily basis. Coordinated, tracked, and Preserved data from multiple sources pertaining to oil and gas platforms/wells located in the Gulf of Mexico, Texas, and the San Juan Basin. Generated and distributed Esri Ark GIS maps and corresponding MS Excel reports on a weekly and monthly basis for the Permian Basin, Marcellus, Eagle Ford, Haynesville, Barnett and Deepwater assets. Utilized PI Dwight’s Scouting and Production disk to assimilate statistical data. Created Microsoft Power Point Presentations. Utilized SQL Server Profiler, Database Tuning Advisor and Perfmon. Worked with MSSQL SERVER 2005, 2008 and 2008R2. Show less

Education

  • Capella University
    Masters, Science - Information Assurance and Security
  • Troy State University
    Bachelors of Computer Science
  • Capella University
    PhD, Information Technology with a focus in Education

Community

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