AeroLeads people directory · profile
Clair Hamill Email & Phone Number
Postgresql Database Engineer and Administrator
at
Software Technology Group
2 work emails found
@stgconsulting.com
5 phones found area 801 and 716
LinkedIn matched
✓ Verified Jun 2026
4 data sources
Profile completeness 100%
Current company
Role
Postgresql Database Engineer and Administrator
Location
Sandy, Utah, United States
Who is Clair Hamill? Overview
A concise factual answer block for searchers comparing this professional profile.
Quick answer
Clair Hamill is listed as Postgresql Database Engineer and Administrator at Software Technology Group, based in Sandy, Utah, United States. AeroLeads shows a work email signal at stgconsulting.com, phone signal with area code 801, 716, and a matched LinkedIn profile for Clair Hamill.
Clair Hamill previously worked as Postgresql Database Engineer / Administrator at Software Technology Group and SQL Server Database Administrator / Developer at Software Technology Group. Clair Hamill holds Bachelor Of Applied Science (Basc), Computational Mathematics from Rochester Institute Of Technology.
Company email context
Email format at Software Technology Group
This section adds company-level context without repeating Clair Hamill's masked contact details.
{first}.{last}@stgconsulting.com
89% confidence
AeroLeads found 2 current-domain work email signals for Clair Hamill. Compare company email patterns before reaching out.
Profile bio
About Clair Hamill
Over 30 years of professional information technology experience. Significant relational database (DBA/DBE) experience including Postgresql, SQL Server, MySQL, Oracle, and more. Highly experienced with Performance Tuning (database and queries), Upgrades, Migrations, Queries, Security, etc.. Skills also include application development and mentoring other developers and database staff. Excellent candidate with solid teamwork, analytical, and communication skills. Technical Skills• PostgreSQL, SQL Server, Oracle, MySQL DBA• OnPrem and AWS Cloud• Database Migrationso OnPrem to AWS Aurora, AWS EC2 to AWS Aurorao Oracle to PostgreSQL, Oracle to SQL Server o SQL Server to Postgresql• Database Developmento Extensive DDL development, performance tuning, Auditing, Encryption, Securityo Implementation of Compliance (PII, PCI, HIPAA, PHI)o Relational Data modeling, design, implementationo Data Warehouse design and implementation (Postgresql, Oracle, SQL Server)o Code/query creation, tuning, auditing (ex: functions, procs, triggers, etc.)• Installation / Tuning / Backup / Upgradeo Creating new DBMS's OnPrem / AWSo Disk Space utilization, memory allocation, upgrades, backups (Full, transaction)o Upgrading from older to newer DMBS versions• Audit Reviewo Verification of users and permissionso Verifications of compliance (PII, PCI, HIPAA)o Verifications of backups, testing recovery processeso Log review and analysiso Review schema/table/user usages
Listed skills include Oracle, Pl/Sql, Sql, Software Development, and 7 others.
Current workplace
Clair Hamill's current company
Company context helps verify the profile and gives searchers a useful next step.
7 roles
Clair Hamill work experience
A career timeline built from the work history available for this profile.
Postgresql Database Engineer / Administrator
Current- Postgresql (OnPrem, AWS EC2/RDS/Aurora), MySQL (OnPrem)
- Primary Postgresql and MySQL DBA/DBE for the DPHIP group at the Utah DHHS
- Upgrade all PG10 databases to PG14 on seven servers, OnPrem and AWS EC2
- Migrate all PG14 databases from OnPrem and EC2 to AWS Aurora Postgres
- Analyze environments, remove unused or redundant objects, users, roles
- Performance tune DB and queries, including adjusting Vacuum/Analyze settings
Oct 2021 - Present
Sql Server Database Administrator / Developer
CurrentSQL Server DBA, DeveloperIntegral member of Data Migration team migrating (ETL) data from a SQL Server 2008 database to a continuously changing SQL Server database (not within our control).Responsible for source data analysis, target DB table design analysis, creation of ETL design, T-SQL procedure coding (SSIS not used), unit testing, and system testing.
Nov 2004 - Present
Oracle Dba, Developer, Business Analyst
Performed analysis on existing Client/Server application and rewrote critical portions of Client/Server application logic into Oracle PL/SQL objects for performance improvements and ease of understanding by others in the future. Application Run times reduced from Days to Hours. Error handling improved.Analyzed existing Oracle DB design and updated or.
Oct 2015 - Mar 2017
Oracle Dba, Developer, Performance Tuning, Auditing
Backup / Recovery of databases; Apply Security updates for databases.Performance Monitoring/Auditing, granting permissions and roles to users as necessary, creating users, assigning proxy account.Work in concert with the Development team to design, model, create and deploy new application databases or modify existing databases.Extensive PL/SQL development.
Apr 2012 - Sep 2015
Oracle Dba, Pl/Sql Developer
Created data models and database design using client’s data modeling tools.Created or modified Oracle objects including Emergency changes for ProductionPL/SQL and Database tuning.Implemented Row Level Security (RLS) and Fine Grain Auditing (FGA) into the databases (Dev, QA, Staging, Prod).Created new users, set up development or QA environments, controlled.
Jun 2004 - Nov 2011
Websphere, Ibm Applications, Oracle
Member of DBA team supporting various projects for Hill AFB.Responsible for: Updating WebSphere servers with current patches from IBM.Updating IBM applications on servers with latest patches and upgrades.Backing up / recovery for databases.Applying Oracle patches / upgrades as required.Assisting Developer and End User personnel with database issues related.
Nov 2011 - Apr 2012
2 education records
Clair Hamill education
Bachelor Of Applied Science (Basc), Computational Mathematics
Rochester Institute Of Technology
Bachelor Of Science (B.S.), Computational Mathematics
Rochester Institute Of Technology
FAQ
Frequently asked questions about Clair Hamill
Quick answers generated from the profile data available on this page.
What company does Clair Hamill work for?
Clair Hamill works for Software Technology Group.
What is Clair Hamill's role at Software Technology Group?
Clair Hamill is listed as Postgresql Database Engineer and Administrator at Software Technology Group.
What is Clair Hamill's email address?
AeroLeads has found 2 work email signals at @stgconsulting.com for Clair Hamill at Software Technology Group.
What is Clair Hamill's phone number?
AeroLeads has found 5 phone signal(s) with area code 801, 716 for Clair Hamill at Software Technology Group.
Where is Clair Hamill based?
Clair Hamill is based in Sandy, Utah, United States while working with Software Technology Group.
What companies has Clair Hamill worked for?
Clair Hamill has worked for Software Technology Group and Rylex.
How can I contact Clair Hamill?
You can use AeroLeads to view verified contact signals for Clair Hamill at Software Technology Group, including work email, phone, and LinkedIn data when available.
What schools did Clair Hamill attend?
Clair Hamill holds Bachelor Of Applied Science (Basc), Computational Mathematics from Rochester Institute Of Technology.
What skills is Clair Hamill known for?
Clair Hamill is listed with skills including Oracle, Pl/Sql, Sql, Software Development, Data Modeling, Microsoft Sql Server, Networking, and Tai Chi Chuan.
Find 750M verified contacts
Search by job title, company, industry, location, and seniority. Export verified B2B contact data when you need it.
Start free trial