Jobs
>
Newport Beach

    ms sql dba - Newport Beach, United States - TEKsystems

    TEKsystems
    TEKsystems Newport Beach, United States

    4 weeks ago

    TEKsystems background
    Description
    :

    This role will be a Senior Level MS SQL DBA. The company has over 240 instances and 4000 databases of various sizes/ 3-4 mission critical databases. You will be working as the expert onshore contributor with knowledge in MS SQL. You will be working normal PST hours and working in the Newport Beach CA Office 3 Days a week.

    In this role you will be expected to be able to provide Tier 2 to Tier 3 level support to the team.

    This is a customer facing position that will require you to interact with c level executives to developers.

    Skills:

    Strong Communication

    5+ years of expertise in MS SQL 2014 and newer

    Expert experience in support/ troubleshooting

    Understanding of infrastructure components including VMware

    Responsibilities:


    Implements, maintains, and designs DB2, ORACLE, IMS, SYBASE, SQL Server and other data bases in support of the development and installation of new systems and enhancements to existing systems.

    Uses available tools and utilities to provide for necessary DBMS maintenance activities:

    data base reorganizations, backup and recovery, space management, performance and tuning, and change management. Performs system administration and system management functions for DB2 and ORACLE data base systems.

    Assists application developers and other clients with data base usage and software development activities.


    Ensures that all software or systems for which they are responsible are monitored and tuned to ensure acceptable levels of performance and resource utilization, ensures that the software is utilizing all appropriate functions and features, timely and accurate reporting on performance, utilization and feature use as requested.

    Provides project management regarding all technical aspects of implementing projects/major release upgrades for Client's largest, most complex and critical systems which includes:

    properly following a project life cycle, the development of project plans, completing all appropriate documentation and notifications in order to obtain resolution within the established timeframes.

    Provides input to the development of corporate IT standards and policies to ensure compatibility and integration throughout the company. Approve/Manage subcontracting and vendor evaluation studies pertaining to the IT organization, IT Infrastructure and Architectures.

    Skills:

    Sql, AWS, Ms SQL, Mssql server, troubleshooting, vmware, Database administrator, Oracle, Backup, Recovery, Installation, Performance tuning

    Top Skills Details:

    Sql,AWS,Ms SQL,Mssql server,troubleshooting,vmware,Database administrator,Oracle

    Additional Skills & Qualifications:

    Questions:

    What considerations do you make when running a SQL Server in a virtualized environment?


    • Should mention anything about memory
    :

    ballooning, lock pages in memory, guest memory reservations


    • Overprovisioned hosts
    • NUMA alignment between the guest and the host
    Describe indirect checkpoints


    • Should mention target recovery time settings
    • Dirty buffer pages and flushing to disk
    Describe what a service SID is and how are they implemented for a service account


    • Should mention account isolation
    • It's a best practice for granting permissions to SQL service accounts
    Describe the effects of running an online Index rebuild operation


    • Transaction log growth
    • Storage requirements if sorting operations are required
    Will consider candidates that hit any one of the bullet points for each question.

    Experience Level:

    Intermediate Level

    About TEKsystems:

    We're partners in transformation. We help clients activate ideas and solutions to take advantage of a new world of opportunity.

    We are a team of 80,000 strong, working with over 6,000 clients, including 80% of the Fortune 500, across North America, Europe and Asia.

    As an industry leader in Full-Stack Technology Services, Talent Services, and real-world application, we work with progressive leaders to drive change.

    That's the power of true partnership. TEKsystems is an Allegis Group company.


    The company is an equal opportunity employer and will consider all applications without regards to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.

  • TEKsystems

    ms sql dba

    3 weeks ago

    TEKsystems Newport Beach, United States

    :This role will be a Senior Level MS SQL DBA. The company has over 240 instances and 4000 databases of various sizes/ 3-4 mission critical databases. You will be working as the expert onshore contributor with knowledge in MS SQL. You will be working normal PST hours and working i ...

  • Insight Global

    remote sql dba

    3 weeks ago

    Insight Global Irvine, United States

    Insight Global is searching for a SQL DBA to manage our client's SQL Server, MySQL, MariaDB and Oracle database systems. You will be required to install and maintain database software, create and administer databases including and not limited toperformance tuning, storage managem ...

  • Diverse Lynx

    SQL Server DBA

    3 weeks ago

    Diverse Lynx Irvine, United States

    Principal Data Engineer - SQL Server DBA · Expertise in Database Management, Best Practices, Installation/Configuration, Always On, Clustering, Replication, Backup/Recovery, Server Migrations, Optimization, Troubleshooting, Linked Servers, PowerShell, SSIS, SSRS, SSAS, Data Part ...

  • Insight Global

    remote sql dba

    3 weeks ago

    Insight Global Irvine, United States

    Job Description · Insight Global is searching for a SQL DBA to manage our client's SQL Server, MySQL, MariaDB and Oracle database systems. You will be required to install and maintain database software, create and administer databases including and not limited to -- performance t ...

  • University of California

    report programmer and technical database analyst

    2 weeks ago

    University of California Irvine, United States Full time

    Required Qualifications · Job Opening ID: 69525 Reports To: Director, Decision Support Services Working Title: REPORT PROGRAMMER AND TECHNICAL DATABASE ANALYST Department: SOM-Decision Support Services Bargaining Unit: 99 FLSA: Exempt Payroll Job Code: Job Location: UCI Campus- ...

  • CoStar Group

    Senior Database Administrator

    6 days ago

    CoStar Group Orange County, United States Full time

    Responsibilities · Administrate and integrate with Microsoft SQL Server so decent MSFT SQL DBA skill is required · Demonstrate extensive knowledge of all aspects AWS Database Engines (RDS, DynamoDB) · Include DB technology evaluation, guidance and consultation, design support, t ...

  • JPMorgan Chase Bank, N.A.

    Data Engineer II, Database Administrator

    3 weeks ago

    JPMorgan Chase Bank, N.A. Newport Coast, United States

    You thrive on diversity and creativity, and we welcome individuals who share our vision of making a lasting impact. Your unique combination of design thinking and experience will help us achieve new heights. · As a Data Engineer II, Database Administrator (SQL/AWS DBA) at JPMorg ...

  • Rancho Santiago Community College District

    Business Systems Analyst

    5 days ago

    Rancho Santiago Community College District Santa Ana, United States

    Business Systems Analyst · Rancho Santiago Community College District · Salary Range: · Grade 15: $72, $92,770.14/year · Job Type: · Full Time · Job Number: · CL · Location: · Santa Ana, CA · Division: · DO Educational Services · Closing: · 5/1/2024 5:00 PM Pacific · ...

  • American Honda Motor Co.

    Dept. Manager

    5 days ago

    American Honda Motor Co. Torrance, United States

    What Makes a Honda, is Who makes a Honda · Honda has a clear vision for the future, and it's a joyful one. We are looking for individuals with the skills, courage, persistence, and dreams that will help us reach our future-focused goals. · At our core is innovation. Honda is con ...

  • American Honda Motor

    Manager, Data Strategy, Governance and Delivery

    2 weeks ago

    American Honda Motor Torrance, United States

    What Makes a Honda, is Who makes a Honda · Honda has a clear vision for the future, and its a joyful one. · We are looking for individuals with the skills, courage, persistence, and dreams that will help us reach our future-focused goals. · At our core is innovation. Honda is co ...

  • American Honda Motor Company, Inc.

    Enterprise Data Architect

    3 weeks ago

    American Honda Motor Company, Inc. Torrance, United States

    What Makes a Honda, is Who makes a Honda · Honda has a clear vision for the future, and it's a joyful one. We are looking for individuals with the skills, courage, persistence, and dreams that will help us reach our future-focused goals. · At our core is innovation. Honda is cons ...

  • American Honda Motor Co.

    Manager, Data Strategy, Governance and Delivery

    2 days ago

    American Honda Motor Co. Torrance, United States

    What Makes a Honda, is Who makes a Honda · Honda has a clear vision for the future, and it's a joyful one. We are looking for individuals with the skills, courage, persistence, and dreams that will help us reach our future-focused goals. · At our core is innovation. Honda is con ...

  • Tri Pointe Homes Holdings, Inc.

    Jde CNC Administrator

    3 days ago

    Tri Pointe Homes Holdings, Inc. Irvine, United States

    Overview: · **Tri Pointe Homes is looking for an experienced individual to join our talented group as a JDE CNC Administrator.** · **Remote locations available in CA, WA, NV, AZ, UT, NC, MD, CO, and TX** · **Position Responsibilities**: · - Maintain JD Edwards E1 9.2 release leve ...

  • MobilityWare

    Data Scientist

    3 weeks ago

    MobilityWare Irvine, United States

    As a Senior Data Scientist, you will support the product team with in-depth analyses related to in-game activity, user behaviors, retention, funnel and monetization analysis, and provide insights to enhance the user experience. Your work will directly influence what features are ...

  • Sukut Construction

    SQL Database Administrator

    3 weeks ago

    Sukut Construction Santa Ana, United States

    Sukut Construction is a nationwide heavy civil general contractor with over 55 years of superior performance and industry expertise on residential, public, and commercial projects. · Our commitment to creating excellence in people and projects has earned us over 100 industry awar ...

  • Sukut Construction LLC

    Jr/mid SQL Database Administrator

    1 week ago

    Sukut Construction LLC Santa Ana, United States

    **Who We Are** · Sukut Construction is a nationwide heavy civil general contractor with over 55 years of superior performance and industry expertise on residential, public, and commercial projects. · Our commitment to creating excellence in people and projects has earned us over ...

  • Rancho Santiago Community College District

    Business Systems Analyst

    3 weeks ago

    Rancho Santiago Community College District Santa Ana, United States

    **Business Systems Analyst** · **Rancho Santiago Community College District** · **Salary Range**: Grade 15: $72, $92,770.14/year · **Job Type**: Full Time · **Job Number**: CL · **Location**: Santa Ana, CA · **Division**: DO Educational Services · **Closing**: 5/1/2024 5:00 PM P ...

  • Diverse Lynx

    Net Developer

    3 weeks ago

    Diverse Lynx Long Beach, United States

    Primary Skills: · •Over all .NET Experience should be 6+ years · •Classic ASP, ASP.Net, C#, MVC, Angular, DevOps, · •HTML/CSS, JavaScript · •Reporting: Crystal Reports · •Worked on GIT and TFS · •Experience in creating understanding documents based on available source code ...

  • Resourcesoft, Inc.

    SQL Developer

    2 weeks ago

    Resourcesoft, Inc. Corona, United States

    Requirements: · 6+ years of experience as a SQL Database Developer. · Must have 3 plus years of experience using SQL queries. · Must have experience with SSIS, SSAS, SSRS, MS SQL . · Must have experience with Jira, ALM, TFS/ADO. · Experience in agile and waterfall methodologies. ...

  • SMART TECH SKILLS LLC

    SQL Server Developer

    3 weeks ago

    SMART TECH SKILLS LLC Corona, United States

    Job Description · Job DescriptionRequirements: · 6 or more years of experience as a SQL Database Developer. · Must have 3 plus years of experience using SQL queries. · Must have experience with SSIS, SSAS, SSRS, MS SQL. · Must have experience with Jira, ALM, TFS/ADO. · Experience ...