Sr. Database Administrator

Sr. Database Administrator Location: Irvine, CA, United States Description JOB SUMMARY The Database Administrator is responsible for managing all Microsoft SQL databases, architecture, and infrastructure within the GSF organization. Their duties include monitoring, designing, developing, securing, testing, maintaining, installing, and optimizing database technologies at GSF. 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. This position is Hybrid (3 days in the office). ESSENTIAL FUNCTIONS (% of time may vary depending on assignments/projects) 1. Database Administration Duties u00b7 Drive database optimization by engaging with software vendors to identify poor queries. u00b7 Optimize and tune high transactional database systems engaging with application team. u00b7 Monitors database performance and implements changes to tune performance. u00b7 Works side by side with the applications team to optimize application performance. u00b7 Establishes physical database parameters. u00b7 Work closely with the applications teams to maintain a data dictionary u00b7 Calculates optimum values for database parameters. u00b7 Specifies user access level for each segment of one or more data items such as insert, replace, retrieve, or delete data. u00b7 Tests and corrects errors, and refines changes to database. u00b7 Work with development teams and analysts to make changes to the database. u00b7 Establish standards for database systems and database security. u00b7 Implements cybersecurity best practices. 50% 2. Business Information Requirements u00b7 Works with the users and enterprise architect to develop and maintain databases and determine the best ways to organize and store data. u00b7 Understand the information requirements of the systems and coordinate the development and / or maintenance needed to satisfy further processing and retrieval of information. u00b7 Ensure the performance of the systems understands the platform on which the database runs and develop the standards for data elements and relationships. u00b7 Has the ability to communicate business requirements into technical requirements. u00b7 Works within the defined project methodology within the GSF IT organization. 20% 3. Business Information Design u00b7 Designs logical and physical databases or reviews descriptions of changes to database design to understand how changes to be made affect physical database. Coordinates database development and security systems required. u00b7 Responsible for data integrity, backup systems, and database security. u00b7 Maintain the ETL and BI Tools to support the enterprise information systems. 20% 4. Resource Management u00b7 Coordinate the work efforts, scheduling, and prioritization for cross-team resources. u00b7 Effectively transition senior-level knowledge to other members of the team to help grow the organization as a whole. u00b7 Train and mentor other team members in team standards, processes, and methodologies. u00b7 Support the professional development of other team members. u00b7 Effectively delegate tasks to other team members to challenge individuals appropriately. 10% 5. Additional Responsibilities u00b7 Accountable for properly following all IT standards, processes and methodologies as applicable including but not limited to Quality Assurance (QA), Project Management Life Cycle (PMLC) and Software Delivery Life Cycle (SDLC). u00b7 Other responsibilities and accountabilities may be assigned based on business and organization needs. Varied TRAVEL EXPECTATIONS + No travel requirements MANAGEMENT RESPONSIBILITY + Manage relationships with applications teams to collaborate & triage technical issues and optimization. MINIMUM QUALIFICATIONS Education/Certification + A Four year college degree is preferable 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 AzureSQL Database ESSENTIAL KNOWLEDGE, SKILLS AND ABILITIES Refer to separate handout for Competency definitions (B/basic; P/proficient; E/expert): Technical Expert u00b7 Database HA Architecture u00b7 SQL Always On (2016/2019) u00b7 SQL Profiler u00b7 MSSQL Performance u00b7 SQL Query analysis u00b7 ETL tools knowledge u00b7 Database administration (design, installation & troubleshooting) Proficient u00b7 RedGate Monitoring u00b7 Azure SQL DB Management u00b7 Data Warehouse experience (RedShift) u00b7 Database policy & procedure development u00b7 Infrastructure 101 u00b7 Code Management u00b7 Data Transport u00b7 Enterprise Data Modeling u00b7 General Office Applications u00b7 Information Security Basic u00b7 Client/Server Systems u00b7 Business Continuity u00b7 Remote Assistance Tools u00b7 SOA Strategy u00b7 User Interface Design u00b7 Microsoft Project u00b7 Veeam backup foundational knowledge u00b7 Server Virtualization Business Expert u00b7 Management of high-transaction-volume WMS u00b7 Innovative Solution Development u00b7 Benefits of Information Technology u00b7 Tabletop exercises and Business continuity/recovery planning Proficient u00b7 Business Acumen u00b7 Business Alignment u00b7 ITIL u00b7 Project Management Methodology (PMM) u00b7 Requirements Definition u00b7 Risk Management u00b7 Systems Delivery Life Cycle (SDLC) u00b7 Technical Writing u00b7 Test Plans Basic u00b7 Quality Assurance & Controls u00b7 Release Management u00b7 Service Level Management u00b7 Strategic Sourcing CORE COMPETENCIES The following universal core competencies apply to every job at Golden State Foods. Performance expectations are based on the specific job and grade level. GSF VALUES Maintains the highest standards. Treats others the way youu2019d like to be treated. Makes the best product. Gives the customer a fair deal. TRUST Exhibits sense of fairness. Leads by example. Consistently lives the Values and Creed. Builds trust by being willing to say u201cI made a mistakeu201d. Assures that promises are met on time, every time. INSPIRATION TO OTHERS Walks the talk. Is supportive of others. Helps others develop great ideas. Looks for the best in others. Rewards positive performance. Finds ways to succeed, not reasons to fail. Is willing to do jobs u201cbelow themu201d. Addresses failures in the process, not the people. Accepts responsibility for own failures. Creates vision for team. DRIVES TOWARDS HIGHEST QUALITY RESULTS Is creative and innovative. Is a prudent risk-taker. Always looks for new methods and better ways to run the business. Meets annual goals and objectives. Has a passion for the business. Is willing to change. Puts forth quality efforts. INTEGRITY Represents self honestly in all situations, even if it exposes mistakes or weakness. Gives the customer a fair deal. Always does the right thing, even when no one is watching. Walks the talk. Meets commitments. Applies rules across all levels u2013 no exceptions. OPEN & HONEST COMMUNICATION Is timely in communications in both directions. Listens actively. Speaks directly, (say what you mean u2013 mean what you say). Listens with empathy and without judgment. Gets all the facts before jumping to conclusions. TEAM PLAYER/PARTNERSHIP Avoids acting like a big shot. Shares success with others. Recognizes others achievements timely. Reacts constructively to mistakes. Is willing to do whatever is necessary to get job done. Puts otheru2019s success first. Values team over individual. Acknowledges others with Golden Spirit Awards. Creates win/win situations. Apply Now

Created: 2025-12-26