Database Administrator II

4 weeks ago


Rancho Cordova, California, United States Compunnel Full time
Job Summary:

We are in search of a BI Developer/Database Administrator to design and develop business intelligence database solutions supporting Tableau and Power BI analytics dashboards and reports. The individual will be responsible for understanding business requirements, writing functional specifications, prototyping, development, quality testing, user acceptance testing, roll-out, and post-launch enhancements. As a Database Administrator, you will manage and maintain SQL server databases, monitor and troubleshoot batch jobs, manage access roles, and support server management and patches.

Key Responsibilities:

• Partner closely with upstream application teams and developers to ensure data sources are accurate, available, and timely.

• Efficiently develop complex SQL queries (stored procedures, views, and functions).

• Collaborate with business intelligence developers and analysts to test, clean, and standardize data to meet business requirements.

• Document database structures, configurations, and procedures to maintain a well-managed database environment.

• Design new database structures, including tables, relationships, and data integrity constraints, ensuring optimal performance and efficiency (including normalization/denormalization).

• Proactively monitor server, database, and query performance.

• Fine-tune query, database, and server performance as needed.

• Ensure access is provisioned through database roles and address non-compliant instances.

• Perform regular database backups and manage retention according to policy.

• Monitor agent jobs and troubleshoot when issues arise.

• Monitor SSIS package runs and troubleshoot issues in SSIS/SQL.

• Conduct periodic audits of access to ensure proper user permissions.

• Collaborate cross-functionally with business stakeholders and technical partners to meet business requirements.

• Maintain excellent verbal communication and documentation skills for workflows and query functionality.

• Adhere to Agile SCRUM methodology and processes.

Required Qualifications:

• Leverage SQL and SSIS for interacting with SQL server data models, including data connectors, dimensional modeling, and query writing.

• Experience working with large and complex data sets and writing complex queries (stored procedures, views, and functions).

• Strong understanding of BI analytics, data blending, data warehousing, and data ELT.

• Experience in documenting, researching, and solving problems through a service help desk ticketing system.

• Experience gathering and validating functional requirements with business analysts or sponsors and providing design specifications.

• SQL server administration experience, including management, monitoring, and performance tuning.

• Experience managing OLAP and OLTP databases.

• Expertise in creating, managing, and troubleshooting agent jobs.

• Experience with SSIS: creating, maintaining, and troubleshooting packages.

• Ability to query system and user databases, analyze query plans, and implement performance optimizations (schema, query, and index optimizations).

• Ability to work on multiple projects and adapt to changing priorities.

• 4-year degree in MIS, Information Technology, Computer Science, or a related field.

• Minimum of 5 years' experience as a BI SQL Developer and/or Database Administrator.

Education: Bachelors Degree

  • Rancho Cordova, California, United States Akraya Inc. Full time

    Primary Skills: SQL (Expert), SSIS (Advanced), Database Management (Advanced), Performance Tuning (Advanced), Data Warehousing (Intermediate)Contract Type:  W2 OnlyDuration:  6+ MonthsLocation: Rancho Cordova, CAPay Range: $68 - $70 per hour on W2Job Summary:This role is perfect for a professional adept at technically designing and developing BI...

  • HRIS Administrator

    3 days ago


    Rancho Cordova, California, United States Bank of Marin Bancorp Full time

    Bank of Marin, voted by our employees as one of the "Best Places to Work" in the North Bay Business Journal, is seeking an HRIS Administrator to join our Human Resources team at our corporate office in Novato. The Human Resource Information System Administrator (HRIS) will support and maintain the organizations HRIS payroll software applications and modules....


  • Rancho Cucamonga, California, United States Option One Plumbing Inc Full time

    Responsibilities and DutiesBook service appointments for our customers in a timely and efficient manner.Maintain accurate records in SkyBoss database, including customer information and notes.Communicate effectively with technicians through clarifying messages and updating customer information as needed.Participate in ongoing training to improve call...

  • system administrator

    4 weeks ago


    Rancho Cordova, California, United States State of California Full time

    Telework is available. Under the general direction of the UNIX Support Group Information Technology Manager I (IT Mgr I) as part of OTech UNIX Support Group, the Information Technology Specialist II (IT Spec II) provides advanced level system administration for central UNIX (AIX) servers in a highly available and reliable computing environment. Services...


  • Rancho Cordova, California, United States State of California Full time

    Are you an energetic, self-motivated, creative problem-solver with attention to detail? If so, we encourage you to apply Under the general direction of the Information Technology Manager I (ITM I), the Information Technology Specialist II (ITS II) performs systems administrator work and participates with other Information Technology (IT) Specialists within...


  • Rancho Cordova, California, United States Sevita Full time

    Mentor Community Services, a part of the Sevita family, provides community-based services for individuals with intellectual and developmental disabilities. Here we believe every person has the right to live well, and everyone deserves to have a fulfilling career. You'll join a mission-driven team and create relationships that motivate us all every day. Join...


  • Rancho Cordova, California, United States Sound Window & Door Inc. DBA Renewal by Andersen Full time

    Job Description Job Description Description:Join our team in Rancho Cordova at Renewal by Andersen of Sacramento We're hiring an Operations Administrator to track, update and maintain completion of projects while collaborating with homeowners to ensure a smooth and efficient customer experience. This role requires a large focus on strong communication,...

  • Analyst II

    7 days ago


    Rancho Cucamonga, California, United States Inland Empire Health Plan Full time

    *What you can expect *Find joy in serving others with IEHP We welcome you to join us in "healing and inspiring the human spirit" and to pivot from a "job" opportunity to an *authentic experience*Under the general direction of leadership among the Population Health (PH) team, the Analyst II - Population Health (Analyst II - PH) will provide support in the...

  • System Administrator

    3 weeks ago


    Rancho Cordova, California, United States State of California Full time

    Telework is available. Under general direction of the Office of Information Security (OIS) Security Operations (SecOps) Information Technology Manager II (IT Mgr II), the IT Manager I (IT Mgr I) provides the technical and managerial guidance for the administration, monitoring, maintenance, and support of production security systems and services managed by...


  • Rancho Cordova, California, United States State of California Full time

    What We Offer: As a member of our team, you can expect a competitive salary, comprehensive benefits package, and opportunities for professional growth and development. We are committed to creating a diverse and inclusive work environment that fosters collaboration, creativity, and innovation.Requirements: To be considered for this position, you must have a...


  • Rancho Cucamonga, California, United States OLE' Mexican Foods Full time

    Maintain employee records (soft and hard copies) Update HR databases (e.g. new hires, separations, vacation and sick leaves) Assist in payroll preparation by providing relevant data, like absences, bonus and leaves Prepare paperwork for HR policies a Administrative Assistant, Administrative, Assistant, HRIS, HR, Manufacturing


  • Rancho Cordova, California, United States Yusen Logistics Co., Ltd. Full time

    We are seeking a highly skilled Cloud and Network Engineer III to join our team. The successful candidate will design, implement, and maintain cloud-based infrastructure, networks, and systems, ensuring high availability and scalability. Key responsibilities include administration of Azure Services, VMWare, Kubernetes, containers, storage, and backups,...


  • Rancho Cordova, California, United States Dewberry Engineers Incorporated Full time

    **About the Role**We are seeking a highly motivated and organized individual to join our team as a Proposal Coordinator. This role requires excellent communication and interpersonal skills, as well as the ability to work independently and collaboratively within a team environment.Key qualifications include:Bachelor's degree in Liberal Arts, Marketing,...

  • IT Administrator

    2 weeks ago


    Rancho Cucamonga, California, United States CESNA GROUP INC Full time

    Job Summary This client is seeking a permanent, full-time IT Administrator for the current location of the company at Rancho Cucamonga, CA. Job Description The specific duties of the this role include the following: Conceptualize design, implement, and develop a solution for complex/ programs independently Codes and programs enhancements, updates, and...


  • Rancho Cordova, California, United States Nidec Corporation Full time

    We begin with dreams. Dreams drive our motivation. Dreams are our future. The world's dreams, people's dreams, our dreams. Our passion creates ideas that make dreams come alive. Technology and products that were only dreams become reality.All for dreams. Dreams challenge and the Nidec-Group will continue to meet the challenge. For the world's and people's...


  • Rancho Cucamonga, California, United States National CORE Full time

    We are seeking a highly organized and detail-oriented Administrative Support Specialist to join our National CORE team. In this role, you will provide administrative support to our Senior Vice President of Construction, handling special projects and ensuring the smooth operation of our Construction department.About the Role:Provide administrative support to...


  • Rancho Cucamonga, California, United States National CORE Full time

    We are seeking a highly skilled Senior Administrative Officer to join our National CORE team. In this role, you will provide advanced administrative support to our Senior Vice President of Construction, handling special projects and ensuring the effective operation of our Construction department.About the Role:Provide senior-level administrative support to...


  • Rancho Cucamonga, California, United States Ole Mexican Foods, INC Full time

    JOB TITLE: HUMAN RESOURCES GENERALIST DEPT: HUMAN RESOURCES Job briefWe are looking for an HR administrative assistant to perform a variety of personnel-related administrative tasks. You will support the HR department in duties like posting job ads, updating HR database and processing employees' requests.Our HR administrative assistant position requires...


  • Rancho Cucamonga, California, United States OLE' Mexican Foods Full time

    JOB TITLE: HUMAN RESOURCES GENERALISTDEPT: HUMAN RESOURCES Job brief We are looking for an HR administrative assistant to perform a variety of personnel-related administrative tasks. You will support the HR department in duties like posting job ads, updating HR database and processing employees' requests. Our HR administrative assistant position requires...


  • Rancho Cucamonga, California, United States OLE' Mexican Foods Full time

    JOB TITLE: HUMAN RESOURCES GENERALISTDEPT: HUMAN RESOURCES Job brief We are looking for an HR administrative assistant to perform a variety of personnel-related administrative tasks. You will support the HR department in duties like posting job ads, updating HR database and processing employees' requests. Our HR administrative assistant position requires...