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.variable_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]

    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]
    Join Us as a DSP Mission Viejo $500 Bonus

    Join Us as a DSP Mission Viejo $500 Bonus

    Redwood Family Care Network • Dana Point, CA, United States
    [job_card.full_time] +1
    Direct Support Professional (DSP) Mission Viejo.Direct Support Professional- Mission Viejo $500 SIGN-ON BONUS.Date : Walk-ins Tuesdays & Thursdays . Location : 505 N Tustin Ave #114, Santa Ana, CA 9270...[show_more]
    [last_updated.last_updated_variable_hours] • [promoted] • [new]
    Cath Lab Rad Tech - Per Diem

    Cath Lab Rad Tech - Per Diem

    Concentric • Chino, CA, United States
    [job_card.full_time]
    Radiology profession with focus in Radiation Technologist (Catheterization Laboratory) for a 52 week contract in the Chino, CA area. Concentric is a premier staffing firm dedicated to matching outst...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Funding Team Lead

    Funding Team Lead

    Western Alliance Bancorporation • Irvine, CA, US
    [job_card.full_time]
    As the Funding Team Lead you'll supervise and manage the daily pipeline of loans assigned to the team.You'll provide guidance to staff to assist with expectations, pipeline reviews, and communicate...[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]
    Analyst - Parts Logistics - Irvine, CA

    Analyst - Parts Logistics - Irvine, CA

    VetJobs • Irvine, CA, US
    [job_card.full_time]
    Our organization works with partner companies to source qualified talent for their open roles.The following position is available to Veterans, Transitioning Military, National Guard and Reserve Mem...[show_more]
    [last_updated.last_updated_variable_hours] • [promoted] • [new]
    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]
    Senior Software Engineer, Core Experiences - Irvine, USA

    Senior Software Engineer, Core Experiences - Irvine, USA

    Speechify • Irvine, California, United States
    [job_card.full_time]
    Speechify is the easiest way to listen to the world’s information.Articles on the web, documents in the cloud, books on your phone. We absorb it all and let you listen to it at your desk, on the go,...[show_more]
    [last_updated.last_updated_variable_days] • [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]
    Field Applications Program (Texas Region)

    Field Applications Program (Texas Region)

    Texas Instruments • Irvine, CA, US
    [job_card.full_time]
    When you join TI, you will participate in the Career Accelerator Program (CAP), which provides professional and technical training and resources to accelerate your ramp into TI and set you up for l...[show_more]
    [last_updated.last_updated_variable_hours] • [promoted] • [new]
    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]
    Sign Out Director, Genetics (Board Certified) - Remote

    Sign Out Director, Genetics (Board Certified) - Remote

    Quest Diagnostics • San Juan Capistrano, CA, United States
    [filters.remote]
    [job_card.full_time]
    Sign Out Director, Genetics (Board Certified) - Remote.The Genetics Laboratory Director is responsible for providing interpretation of results, implementing new assays, assay troubleshooting, actin...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Sr. Reimbursement Specialist

    Sr. Reimbursement Specialist

    MDxHealth • Irvine, CA, United States
    [job_card.full_time]
    Reimbursement Specialist is responsible for complete, timely, and accurate follow-up and collections on submitted claims to clients, commercial / government payers, and patients, to optimize overall ...[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]
    Scheduler III

    Scheduler III

    MemorialCare Health System • Laguna Hills, CA, United States
    [job_card.full_time]
    MemorialCare is a nonprofit integrated health system that includes four leading hospitals, award-winning medical groups - consisting of over 200 sites of care, and more than 2,000 physicians throug...[show_more]
    [last_updated.last_updated_1_day] • [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]
    Interventional Radiology Technologist - IRT

    Interventional Radiology Technologist - IRT

    MLee Healthcare Staffing and Recruiting, Inc • San Clemente, CA, United States
    [job_card.full_time]
    Interventional Radiology Technologist - Full-Time Position.Become part of our dynamic team in the heart of San Diego County, where we pride ourselves on our state-of-the-art facilities and dedicate...[show_more]
    [last_updated.last_updated_30] • [promoted]