What are the responsibilities and job description for the Sr. Database Administrator position at Golden State Foods?
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)
TRAVEL EXPECTATIONS
Education/Certification
Refer to separate handout for Competency definitions (B/basic; P/proficient; E/expert):
Technical
Expert
Expert
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 you’d 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 “I made a mistake”. 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 “below them”. 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 – no exceptions.
OPEN & HONEST COMMUNICATION
Is timely in communications in both directions. Listens actively. Speaks directly, (say what you mean – 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 other’s success first. Values team over individual. Acknowledges others with Golden Spirit Awards. Creates win/win situations.
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)
- Database Administration Duties
- Drive database optimization by engaging with software vendors to identify poor queries.
- Optimize and tune high transactional database systems engaging with application team.
- Monitors database performance and implements changes to tune performance.
- Works side by side with the applications team to optimize application performance.
- Establishes physical database parameters.
- Work closely with the applications teams to maintain a data dictionary
- Calculates optimum values for database parameters.
- Specifies user access level for each segment of one or more data items such as insert, replace, retrieve, or delete data.
- Tests and corrects errors, and refines changes to database.
- Work with development teams and analysts to make changes to the database.
- Establish standards for database systems and database security.
- Implements cybersecurity best practices.
- Business Information Requirements
- Works with the users and enterprise architect to develop and maintain databases and determine the best ways to organize and store data.
- Understand the information requirements of the systems and coordinate the development and / or maintenance needed to satisfy further processing and retrieval of information.
- Ensure the performance of the systems understands the platform on which the database runs and develop the standards for data elements and relationships.
- Has the ability to communicate business requirements into technical requirements.
- Works within the defined project methodology within the GSF IT organization.
- Business Information Design
- 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.
- Responsible for data integrity, backup systems, and database security.
- Maintain the ETL and BI Tools to support the enterprise information systems.
- Resource Management
- Coordinate the work efforts, scheduling, and prioritization for cross-team resources.
- Effectively transition senior-level knowledge to other members of the team to help grow the organization as a whole.
- Train and mentor other team members in team standards, processes, and methodologies.
- Support the professional development of other team members.
- Effectively delegate tasks to other team members to challenge individuals appropriately.
- Additional Responsibilities
- 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).
- Other responsibilities and accountabilities may be assigned based on business and organization needs.
TRAVEL EXPECTATIONS
- No travel requirements
- Manage relationships with applications teams to collaborate & triage technical issues and optimization.
Education/Certification
- A Four year college degree is preferable with applicable work 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
Refer to separate handout for Competency definitions (B/basic; P/proficient; E/expert):
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)
- RedGate Monitoring
- Azure SQL DB Management
- Data Warehouse experience (RedShift)
- Database policy & procedure development
- Infrastructure 101
- Code Management
- Data Transport
- Enterprise Data Modeling
- General Office Applications
- Information Security
- Client/Server Systems
- Business Continuity
- Remote Assistance Tools
- SOA Strategy
- User Interface Design
- Microsoft Project
- Veeam backup foundational knowledge
- Server Virtualization
Expert
- Management of high-transaction-volume WMS
- Innovative Solution Development
- Benefits of Information Technology
- Tabletop exercises and Business continuity/recovery planning
- Business Acumen
- Business Alignment
- ITIL
- Project Management Methodology (PMM)
- Requirements Definition
- Risk Management
- Systems Delivery Life Cycle (SDLC)
- Technical Writing
- Test Plans
- Quality Assurance & Controls
- Release Management
- Service Level Management
- Strategic Sourcing
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 you’d 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 “I made a mistake”. 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 “below them”. 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 – no exceptions.
OPEN & HONEST COMMUNICATION
Is timely in communications in both directions. Listens actively. Speaks directly, (say what you mean – 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 other’s success first. Values team over individual. Acknowledges others with Golden Spirit Awards. Creates win/win situations.