Golden State Foods
Join to apply for the
Sr. Database Administrator
role at
Golden State Foods .
Description The Database Administrator is responsible for managing all Microsoft SQL databases, architecture, and infrastructure within the GSF organization. Duties include monitoring, designing, developing, securing, testing, maintaining, installing, and optimizing database technologies. This encompasses both on‑premise SQL servers and SQL‑as‑a‑service options such as RDS and Azure SQL Database.
This position is primarily focused on supporting GSF business‑critical applications and is hybrid, requiring three days in the office.
Essential Functions
Database administration duties, including database installation and maintenance.
Drive database optimization by engaging with software vendors to identify and resolve poorly performing queries.
Optimize and tune high‑transactional database systems in collaboration with the application team.
Monitor database performance and implement changes to tune performance.
Work closely with the applications team to optimize application performance.
Maintain a data dictionary and coordinate with business users to clarify information requirements.
Calculate optimum values for database parameters and specify user access levels for data segments.
Test and correct errors, refine changes to the database, and collaborate with development teams and analysts.
Establish and enforce standards for database systems and database security, implementing cybersecurity best practices.
Minimum Qualifications
A four‑year college degree is preferred, with applicable work experience.
Experience
6+ years hands‑on experience implementing and maintaining MSSQL clusters.
4 years of hands‑on experience implementing and supporting SQL Always On.
Experience with RedGate SQL monitoring platform.
Experience with Ola Hallengren and Brent Ozar maintenance and optimization scripts.
Experience with Azure SQL Database.
Essential Knowledge, Skills and Abilities
Technical (Expert)
– Database HA Architecture, SQL Always On (2016/2019), SQL Profiler, MSSQL Performance, SQL Query analysis, ETL tools knowledge, Database administration (design, installation & troubleshooting).
Technical (Proficient)
– RedGate Monitoring, Azure SQL DB Management, Data Warehouse experience (RedShift), Database policy & procedure development, Infrastructure basics, Code management, Data transport, Enterprise Data Modeling, General Office Applications, Information Security.
Technical (Basic)
– Client/Server Systems, Business Continuity, Remote Assistance Tools, SOA Strategy, User Interface Design, Microsoft Project, Veeam backup fundamentals, Server Virtualization.
Business (Expert)
– Management of high‑transaction volume WMS, Innovative solution development, Benefits of information technology, Business continuity/recovery planning.
Business (Proficient)
– Business Acumen, Business Alignment, ITIL, Project Management methodology (PMM), Requirements definition, Risk management, Systems Delivery Life Cycle (SDLC), Technical writing, Test plans.
Business (Basic)
– Quality Assurance & Controls, Release management, Service Level Management, Strategic Sourcing.
#J-18808-Ljbffr
Sr. Database Administrator
role at
Golden State Foods .
Description The Database Administrator is responsible for managing all Microsoft SQL databases, architecture, and infrastructure within the GSF organization. Duties include monitoring, designing, developing, securing, testing, maintaining, installing, and optimizing database technologies. This encompasses both on‑premise SQL servers and SQL‑as‑a‑service options such as RDS and Azure SQL Database.
This position is primarily focused on supporting GSF business‑critical applications and is hybrid, requiring three days in the office.
Essential Functions
Database administration duties, including database installation and maintenance.
Drive database optimization by engaging with software vendors to identify and resolve poorly performing queries.
Optimize and tune high‑transactional database systems in collaboration with the application team.
Monitor database performance and implement changes to tune performance.
Work closely with the applications team to optimize application performance.
Maintain a data dictionary and coordinate with business users to clarify information requirements.
Calculate optimum values for database parameters and specify user access levels for data segments.
Test and correct errors, refine changes to the database, and collaborate with development teams and analysts.
Establish and enforce standards for database systems and database security, implementing cybersecurity best practices.
Minimum Qualifications
A four‑year college degree is preferred, with applicable work experience.
Experience
6+ years hands‑on experience implementing and maintaining MSSQL clusters.
4 years of hands‑on experience implementing and supporting SQL Always On.
Experience with RedGate SQL monitoring platform.
Experience with Ola Hallengren and Brent Ozar maintenance and optimization scripts.
Experience with Azure SQL Database.
Essential Knowledge, Skills and Abilities
Technical (Expert)
– Database HA Architecture, SQL Always On (2016/2019), SQL Profiler, MSSQL Performance, SQL Query analysis, ETL tools knowledge, Database administration (design, installation & troubleshooting).
Technical (Proficient)
– RedGate Monitoring, Azure SQL DB Management, Data Warehouse experience (RedShift), Database policy & procedure development, Infrastructure basics, Code management, Data transport, Enterprise Data Modeling, General Office Applications, Information Security.
Technical (Basic)
– Client/Server Systems, Business Continuity, Remote Assistance Tools, SOA Strategy, User Interface Design, Microsoft Project, Veeam backup fundamentals, Server Virtualization.
Business (Expert)
– Management of high‑transaction volume WMS, Innovative solution development, Benefits of information technology, Business continuity/recovery planning.
Business (Proficient)
– Business Acumen, Business Alignment, ITIL, Project Management methodology (PMM), Requirements definition, Risk management, Systems Delivery Life Cycle (SDLC), Technical writing, Test plans.
Business (Basic)
– Quality Assurance & Controls, Release management, Service Level Management, Strategic Sourcing.
#J-18808-Ljbffr