Sr. Database Administrator

2 weeks ago

Elk Grove, United States Alldata LLC Full time

ALLDATA is the industry s #1 choice for unedited OEM automotive repair and collision information. Founded in 1986, the Elk Grove, California-based company has more than 115,000 subscribers worldwide who rely on us for access to the OEM-accurate information and procedures they need for safe and accurate repairs. More than 400,000 technicians trust ALLDATA s industry-leading software solutions for faster diagnostics, updated OEM information covering 95% of vehicles on the road today, and simpler shop management. With the support of our parent company, AutoZone, we are an employer of choice for those who are passionate about working for a leader in the automotive software industry.

Position Summary:

As a member of Database Administration Team, you will be responsible for providing second-level support for our IT operations, product engineering, data services, and data analysis teams; responsible for managing RDMS and DBMS (relational, data warehouse, data lake, data mart, and operational data stores) services hosted in multiple datacenters. Areas of coverage include but are not limited to MS SQL Server, Google Cloud Platform Cloud Databases and multiple common document-oriented databases. Daily operational and development duties of a Senior Database Administrator are: technical elaboration and enablement during application planning and engineering agile exercises, workload performance profiling and optimization, design/implement/maintenance of blue-green production environments, query optimization, and after-hours on-call support.

Position Responsibilities - Other duties may be assigned:

  • Apply strong technical problem-solving skills daily
  • Be proactive with a focus on constant improvement and follow through at all levels
  • Demonstrate your ability to work in a fast-paced environment while balancing multiple priorities
  • Provide excellent oral and written communication skills
  • Analyze/troubleshoot all levels of server, application and network issues.
  • Document, track and monitor technical issues to ensure timely resolution
  • Provide timely and thorough input for regular status reporting
  • Take ownership of issues, work independently or escalate as needed, and find creative ways to resolve problems
  • Perform other duties and special projects as required or assigned
  • Work closely with the IT operations, product engineering, data services, and data analysis teams to provide database development/administrative technical enablement
  • Provide advice/recommendations on database architecture, design and implementation
  • Establish database design conventions in best practice, assure conventions and standards are compliant and fully documented
  • Work with data modelers to review and optimize logical data models and implement them in physical database schemas using data modeling tools
  • Communicate with non-technical users and technical personnel on business and product delivery teams
  • Support and participate in the database change management and deployment processes
  • Develop and implement stored procedure verification tools that assist developers in troubleshooting and performance improvement
  • Develop and implement procedures for the synchronization between different database environments
  • Provide training and documentation for knowledge transfer to other database team members
  • 50% - Database development and administrative technical enablement, and collaboration with application team members, assigned to Agile story work, elaboration exercises
  • 30% - ITOPS duties: Ticket handling, audit, plan, patch, test, and implementing of changes
  • 15% - Document processes, procedures, configuration settings and infrastructure design for business continuity and disaster recovery
  • 5% - Includes on-call activities

Position Requirements:

  • The Senior Database Administrator shall possess 7+ years of technical knowledge, and experience with the following systems, platforms, and/or applications
  • Hands-on/applied experience in database development/administration using MSSQL, Google Cloud Platform Cloud databases, common document-oriented databases; including performance monitoring, capacity and multi-site disaster planning, transaction workload balancing, performance tuning.
  • MSSQL: SQL Clustering, Replication, Log shipping, Database Mirroring, Availability Groups
  • Google Cloud Platform Cloud Databases
  • Common document-oriented databases: MongoDB, CouchDB, Couchbase, Solr
  • Extensive knowledge with complex SQL, stored procedures, and SQL programming, and optimization
  • Experience in Agile database development and administration
  • Proficiency with MSSQL running in converged or hyperconverged environments - VMWare & physical
  • Experience in database schema design including logical and physical for large scale, highly available application systems
  • Good writing skills to provide documentation for DBA and software development teams
  • Strong knowledge/understanding of ITSM/ITIL support processes and methodologies, incident management, change control management, problem management
Sr. Database Administrator

  • Sr. Software Development Engineer in Test

    1 month ago

    Elk Grove Village, United States HirexHire Full time

    Job DescriptionJob DescriptionABOUT USHirexHire (pronounced hire by hire) is a Chicago-based recruiting and talent consultancy that integrates with companies short-term to provide long-term talent solutions. We take a seat in our client’s everyday operations to understand their people's goals, gaps, and challenges. We then develop and implement the...

  • Administrative Assistant in Disaster Restoration

    2 weeks ago

    Elk Grove Village, United States JobGiraffe Full time

    Job DescriptionJob DescriptionOffice / Clerical / AdministrativeAdministrative Assistant (PT) (Disaster Restoration) (Hybrid WFH)$20.00 per hour plus bonusPart Time - Flexible Scheduling - Approximately 20 hours per weekOnce training is complete, be able to have a Hybrid WFH Schedule and have 2 WFH days per week.JobGiraffe's client is a a leader in...

  • Sr. Systems Analyst

    5 days ago

    Maple Grove, Minnesota, United States Data Recognition Corporation Full time

    Sr. Systems Analyst - Technical / SDLCMaple Grove, MN, USA * Virtual Req #486Wednesday, May 15, 2024DRC is one of the largest educational assessment and curriculum/instruction companies in the industry. Sr. Systems Analyst (technical role)Data Recognition Corporation - Maple Grove, MNCompany cannot provide sponsorship for this rolePlease, no agencies...

  • Sr. Cost Accountant

    6 days ago

    Elk Grove Village, Illinois, United States Genfare Full time

    Sr. Cost AccountantLocation:Elk Grove Village, Illinois, United States Building the people that build the world. With platforms in HVAC and Detection and Measurement, SPX Technologies builds innovative solutions that enable a safer, more efficient, sustainable world. Through our RiSE talent development framework, we Reach, Identify, Strengthen, and Engage...

  • Sr Clinical Pharmacist, Formulary Administration

    4 weeks ago

    Buffalo Grove, United States CVS Pharmacy, Inc. Full time

    The Sr. Clinical Pharmacist is responsible for supporting the development, creation, maintenance, and management of CVS Caremarks standard Medicare formularies, drug lists, utilization management, and other clinical programs and related processes, a Clinical, Pharmacist, Clinic, Product Development, Project Management, Support, Retail, Healthcare

  • Administration Support-Afternoons

    5 days ago

    Maple Grove, United States Lord Of Life Lutheran Church Full time

    Job DescriptionJob DescriptionJOB DESCRIPTION Job Title: Administration Support Position Summary: In coordination with the Administrative Support Team and under the direction of the Administration Coordinator, provide receptionist, hospitality, administrative and computer/database duties in support of the Lord of Life staff and congregation. Department:...

  • Sr. Systems Analyst

    5 days ago

    Maple Grove, United States Data Recognition Corporation Full time

    DRC is one of the largest educational assessment and curriculum/instruction companies in the industry. Sr. Systems Analyst (technical role) Data Recognition Corporation - Maple Grove, MN Company cannot provide sponsorship for this role Please, no agencies SUMMARY: The Systems Analyst position works within the application development group translating...

  • Sr. Systems Analyst

    6 days ago

    Maple Grove, Minnesota, United States Data Recognition Corp. Full time

    DRC is one of the largest educational assessment and curriculum/instruction companies in the industry.Sr. Systems Analyst (technical role)Data Recognition Corporation - Maple Grove, MNCompany cannot provide sponsorship for this rolePlease, no agencies SUMMARY:The Systems Analyst position works within the application development group translating...

  • Sr. Software Engineer, Data

    1 month ago

    Elk Grove Village, United States HirexHire Full time

    Job DescriptionJob DescriptionABOUT USHirexHire (pronounced hire by hire) is a Chicago-based recruiting and talent consultancy that integrates with companies short-term to provide long-term talent solutions. We take a seat in our client’s everyday operations to understand their people's goals, gaps, and challenges. We then develop and implement the...

  • Sr. IT System/ Network Admin

    5 days ago

    Morton Grove, United States Optimized Personnel Solutions Full time

    Job DescriptionJob DescriptionIf you have 5 years of experience and know ERP systems, crystal reports, SQL, and EDI admin, then apply and you will receive a prompt response. Directs, plans, and schedules the development, production, and administrative processing of the organization's computer operations.ResponsibilitiesBuilds systems capability that...

  • Temp Sr. Human Resources Coordinator Hybrid

    6 days ago

    Cottage Grove, Minnesota, United States Renewal by Andersen Full time

    Description & RequirementsSr. Human Resource CoordinatorLong Term Temporary OpportunityHybrid 2 days WFHRenewal by Andersen has a newly created opportunity for an experienced and motivated Human Resource professional to fill a Long-Term Temporary Sr. HR Coordinator. In this role, you will be assisting an HR team of Sr. HRBPs and HR Manager in supporting two...

  • Sr. Systems Analyst

    4 days ago

    Maple Grove, United States Data Recognition Corporation Full time

    Sr. Systems Analyst - Technical / SDLC Maple Grove, MN, USA * Virtual Req #486 Wednesday, May 15, 2024 ...

  • Real Estate Services Administrator

    1 week ago

    Downers Grove, United States Rossi Real Estate Corp. Full time

    Rossi Real Estate Corp., is a full-service real estate company specializing in commercial landlord representation, property management, construction services, and marketing services. We are a small, dynamic, professional team seeking a Real Estate Services Administrator to join our experienced Property Management Team.As the Real Estate Services...

  • Real Estate Services Administrator

    2 months ago

    Downers Grove, United States Rossi Real Estate Corp. Full time

    Rossi Real Estate Corp., is a full-service real estate company specializing in commercial landlord representation, property management, construction services, and marketing services. We are a small, dynamic, professional team seeking a Real Estate Services Administrator to join our experienced Property Management Team.As the Real Estate Services...

  • Temp Sr. Human Resources Coordinator Hybrid

    6 days ago

    Cottage Grove, Minnesota, United States Renewal by Andersen Full time

    Description & RequirementsSr. Human Resource CoordinatorLong Term Temporary OpportunityHybrid 2 days WFHRenewal by Andersen has a newly created opportunity for an experienced and motivated Human Resource professional to fill a Long-Term Temporary Sr. HR Coordinator. In this role, you will be assisting an HR team of Sr. HRBPs and HR Manager in supporting two...

  • Temp Sr. Human Resources Coordinator Hybrid

    5 days ago

    Cottage Grove, United States Renewal by Andersen Full time

    Description & Requirements Sr. Human...

  • Sr. Systems Analyst

    4 days ago

    Maple Grove, United States Data Recognition Corporation Full time

    DRC is one of the largest educational assessment and curriculum/instruction companies in the industry.   Sr. Systems Analyst (technical role) Data Recognition Corporation  - Maple Grove, MN Company cannot provide sponsorship for this role Please, no agencies  SUMMARY: The Systems Analyst position works within the application development group...

  • Administrative Assistant Sales

    1 week ago

    Cedar Grove, United States Yanina & Co. Full time

    Job DescriptionJob DescriptionJob Description: Administrative Assistant in Retail Sales Small Business We are seeking a highly organized and detail-oriented individual to join our team as an Administrative Assistant in our retail sales small business. As an Administrative Assistant, you will play a vital role in supporting our day-to-day operations and...

  • Healthcare Admin Secretary

    2 weeks ago

    Elk Grove, United States Fresenius Medical Care North America Full time

    **POSITION FEATURES:** May entails 25 % travel to other clinics in the area. PURPOSE AND SCOPE: The Secretary/ Receptionist performs general clerical support and office duties for the department and its Management. PRINCIPAL DUTIES AND RESPONSIBILITIES: + Performs basic administrative functions including preparation of business correspondence,...

  • Sr. Systems Analyst

    5 days ago

    Maple Grove, United States Data Recognition Corporation Full time

    DRC is one of the largest educational assessment and curriculum/instruction companies in the industry.   Sr. Systems Analyst (technical role)Data Recognition Corporation  - Maple Grove, MNCompany cannot provide sponsorship for this rolePlease, no agencies  SUMMARY: The Systems Analyst position works within the application development group...