Talent.com
Sr. Database Administrator
Sr. Database AdministratorGolden State Foods • Irvine, CA, US
Sr. Database Administrator

Sr. Database Administrator

Golden State Foods • Irvine, CA, US
[job_card.30_days_ago]
[job_preview.job_type]
  • [job_card.full_time]
[job_card.job_description]

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

  • 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.

50%

2.      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.
  • 20%

    3.      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.
  • 20%

    4.      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.
  • 10%

    5.      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.
  • 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

  • Database HA Architecture
  • SQL Always On (2016 / 2019)
  • SQL Profiler
  • MSSQL Performance
  • SQL Query analysis
  • ETL tools knowledge
  • Database administration (design, installation & troubleshooting)
  • Proficient

  • 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
  • Basic

  • Client / Server Systems
  • Business Continuity
  • Remote Assistance Tools
  • SOA Strategy
  • User Interface Design
  • Microsoft Project
  • Veeam backup foundational knowledge
  • Server Virtualization
  • Business

    Expert

  • Management of high-transaction-volume WMS
  • Innovative Solution Development
  • Benefits of Information Technology
  • Tabletop exercises and Business continuity / recovery planning
  • Proficient

  • Business Acumen
  • Business Alignment
  • ITIL
  • Project Management Methodology (PMM)
  • Requirements Definition
  • Risk Management
  • Systems Delivery Life Cycle (SDLC)
  • Technical Writing
  • Test Plans
  • Basic

  • Quality Assurance & Controls
  • Release Management
  • Service Level Management
  • 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 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_alerts.create_a_job]

    Sr Database Administrator • Irvine, CA, US

    [internal_linking.similar_jobs]
    Database Administrator

    Database Administrator

    TradeJobsWorkForce • 92618 Irvine, CA, US
    [job_card.full_time]
    Responsibility for the evaluation of database software purchases Supervision of modifications to any existing database software to meet the needs of their employer Responsibility for maintaining th...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Customs and Border Protection Officer

    Customs and Border Protection Officer

    U.S. Customs and Border Protection • San Clemente, CA, US
    [job_card.full_time]
    Customs and Border Protection Officer (CBPO) .Customs and Border Protection (CBP) offers those interested in a career in law enforcement an exceptional opportunity to work with an elite team of...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Center Administrator

    Center Administrator

    American Family Care Tustin • Tustin, CA, US
    [job_card.full_time]
    American Family Care (AFC) is one of the largest primary and urgent care companies in the U.AFC Urgent Care Tustin is a rapidly growing clinic in Orange County. Our state-of-the-art center focuses o...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    RN

    RN

    Hilton • Dana Point, CA, US
    [job_card.part_time]
    The award-winning AAA 5-DiamondWaldorf Astoria Monarch Beach Resort & Club is looking for a.Located in the beautiful coastal town of Dana Point adjacent to Laguna Beach, this town played an iconic ...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Survey Taker : Earn up to $25 per survey (Remote)

    Survey Taker : Earn up to $25 per survey (Remote)

    Earn Haus • Dana Point, CA, US
    [filters.remote]
    [job_card.full_time] +1
    Looking for people to participate in taking online surveys for Fortune 500 brands.All you need to do is complete online surveys by sharing your opinion. You will help influence brand decisions on se...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Sr. Software Engineer, Platform

    Sr. Software Engineer, Platform

    Viant • Irvine, California, United States
    [job_card.full_time]
    Viant’s customers use the Demand Side Platform (DSP)to set up, run and monitor ad campaigns.The platform team owns a complex set of backend services and the frontend UI that makes up the DSP.These ...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Work from Home

    Work from Home

    HomeJobFinder • San Clemente, CA
    [filters.remote]
    [job_card.full_time]
    Remote Opportunity : Link Posting Marketing Rep (No Experience Needed!) Are you self-driven, reliable, and ready to earn from anywhere? We’re looking for motivated individuals to jo...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Administrative Assistant (Remote Position)

    Administrative Assistant (Remote Position)

    GOLD GATE • San Clemente, California
    [filters.remote]
    [job_card.full_time] +1
    [filters_job_card.quick_apply]
    Administrative Assistant (Remote Position).Part-Time : $18–$24 per hour.Full-Time : $20–$28 per hour.We are seeking a dependable and well-organized Remote Administrative Assistant to supp...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Azure SQL Database Administrator

    Azure SQL Database Administrator

    VirtualVocations • Ontario, California, United States
    [job_card.full_time]
    A company is looking for an Azure SQL Database Administrator / Data Architect.Key Responsibilities Administer and optimize Azure SQL-based enterprise geodatabases for mission-critical utility GIS...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Data Steward / Analyst

    Data Steward / Analyst

    University of California - Irvine • Irvine, CA, United States
    [job_card.full_time]
    Association of American Universities and is ranked among the nation's top 10 public universities by U.The campus has produced five Nobel laureates and is known for its academic achievement, premier...[show_more]
    [last_updated.last_updated_variable_hours] • [promoted] • [new]
    IT Architect 4 - Enterprise Data & Analytics - FT - Day - Remote

    IT Architect 4 - Enterprise Data & Analytics - FT - Day - Remote

    University of California - Irvine Health • Irvine, CA, United States
    [filters.remote]
    [job_card.full_time]
    University of California, Irvine, and the only academic health system based in Orange County.UCI Health is comprised of its main campus,. UCI Health Community Network in Orange and Los Angeles count...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Sr. Software Engineer, Data

    Sr. Software Engineer, Data

    Viant Technology • Irvine, California, United States
    [job_card.full_time]
    We are looking for a Senior Software Engineer to join our team and contribute to the design and implementation of large-scale big data systems. You will get to work with the full stack from UI to th...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Azure Kubernetes SME

    Azure Kubernetes SME

    Ascending • Irvine, California, United States
    [job_card.full_time]
    Only Available for W2 or 1099.As a Senior Software Engineer, you will play a significant part in leading the rearchitecting efforts of our existing monolithic payment system to a cloud-native ar...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Lead Data Architect

    Lead Data Architect

    Capital Group • Irvine, CA, United States
    [job_card.full_time]
    I can succeed as a Lead Data Architect at Capital Group.As a Lead Data Platform Architect, you will serve as the technical domain expert on foundational data and integration technologies to better ...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Earn $50,000–$100,000 as a Surrogate – Must Have Healthy Prior Delivery

    Earn $50,000–$100,000 as a Surrogate – Must Have Healthy Prior Delivery

    Ivy Surrogacy • San Clemente, CA, US
    [job_card.full_time] +1
    Becoming a surrogate mother is one of the greatest gifts of life!.Ivy Surrogacy is a third-party reproductive agency for parents all over the world seeking. At Ivy Surrogacy, we genuinely believe we...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Information Technology Professional

    Information Technology Professional

    U.S. Navy • San Clemente, CA, US
    [job_card.full_time] +1
    To be eligible to enlist in the U.Navy, candidates must be between the ages of 18-34.At any given moment, hundreds of complex networked computer systems are operating in tandem to keep ships and su...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Head of Product

    Head of Product

    Sonance, Inc. • San Clemente, CA, United States
    [job_card.full_time]
    The Head of Product will play a pivotal role in leading product management, product development, and the full product lifecycle management (PLM) process across Sonance and James brands.Reporting di...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Program Director

    Program Director

    Rippling • San Clemente, CA, United States
    [job_card.full_time]
    At ROWI Teen & Parent Wellness Centers, we are dedicated to transforming the lives of adolescents struggling with mental health issues. Why ROWI? SIGN ON BONUS OPPORTUNITY!.Culture of Care : We pride...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]