Senior Database Administrator

Found in: Appcast Linkedin GBL C2 - 2 weeks ago

Elk Grove, United States ALLDATA 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, GCP 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, GCP 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
  • GCP 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

  • Strategic Account Manager

    1 week ago

    Elk Grove, United States CareerBuilder Full time

    Job Description Job Description Sustainability, plastic pollution, and climate change have never been more at the forefront of our world as they are today. At Ranpak, sustainability has been in our DNA since our founding in 1972. Ranpaks goal then was to create the first environmentally responsible system to protect products during shipment and today, our...

  • Strategic Account Manager

    2 weeks ago

    Elk Grove, United States RANPAK Full time

    Job DescriptionJob DescriptionSustainability, plastic pollution, and climate change have never been more at the forefront of our world as they are today. At Ranpak, sustainability has been in our DNA since our founding in 1972. Ranpak’s goal then was to create the first environmentally responsible system to protect products during shipment and today, our...

  • Executive Assistant

    3 days ago

    Elk Grove, United States Orsini Pharmaceutical Services Full time

    **Description**: **About Orsini Specialty Pharmacy** Providing patients with comprehensive and compassionate care since 1987, Orsini Specialty Pharmacy is a leader in rare diseases and gene therapies. Orsini partners with biopharma innovators, healthcare providers, and payors to support patients and their families in accessing revolutionary treatments for...

  • Executive Assistant

    3 days ago

    Elk Grove, United States Orsini Specialty Pharmacy Full time

    **About Orsini Specialty Pharmacy** Providing patients with comprehensive and compassionate care since 1987, Orsini Specialty Pharmacy is a leader in rare diseases and gene therapies. Orsini partners with biopharma innovators, healthcare providers, and payors to support patients and their families in accessing revolutionary treatments for rare diseases....

  • Real Estate Services Administrator

    Found in: Appcast Linkedin GBL C2 - 2 weeks 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...

  • Maintenance Director

    1 week ago

    Banner Elk, United States Navion Senior Solutions Full time

    Job DescriptionJob DescriptionDeerfield Ridge Assisted Living, a community of Navion Senior Living, located in Boone, NC is seeking a Maintenance Director to join its rapidly growing team. A great Maintenance Director will have a solid understanding of plumbing and electrical systems as well as carpentry and other crafts. They will be well-versed in all...

  • Senior Data Architect- Hybrid Chicago

    1 week ago

    Elk Grove Village, United States UX Hires Full time

    Job DescriptionJob DescriptionSenior Data ArchitectLocation: Hybrid Chicago Area. Work onsite 3-5 days a week.Our client, a leader in global market access, is looking for a Sr. Data Architect – Team Lead. Their ideal candidate will work with their enterprise architect to develop a program, run as process owner, and build/configure acquire tooling to...

  • Senior Data Architect- Hybrid Chicago

    2 days ago

    Elk Grove Village, United States UX Hires Full time

    Job DescriptionJob DescriptionSenior Data ArchitectLocation: Hybrid Chicago Area. Work onsite 3-5 days a week.Our client, a leader in global market access, is looking for a Sr. Data Architect – Team Lead. Their ideal candidate will work with their enterprise architect to develop a program, run as process owner, and build/configure acquire tooling to...

  • Real Estate Administrative Assistant

    1 week ago

    Pleasant Grove, United States REMAX Associates - The Kochniuk Group Full time

    Job DescriptionJob DescriptionOur mission is to create a first-class buying and selling experience for all our clients and we are seeking an Administrative Assistant who is passionate about helping us reach our objectives and supporting the team. The ideal candidate will have real estate experience helping agents from listing to closing. There are...

  • Order Support Administrator

    2 days ago

    Garden Grove, United States FEI-Zyfer Inc Full time

    Full-Time Non-Exempt Position - Req # 191 U.S. Citizenship Required for this Position **Overview**: We are seeking a highly organized and detail-oriented Order Support Administrator to join our team. As an Order Support Administrator, you will play a crucial role in supporting our sales team and ensuring the smooth operation of our sales processes. This is...

  • Medication Technician/Med Tech

    Found in: Resume Library US A2 - 1 week ago

    Banner Elk, North Carolina, United States Navion Senior Solutions Full time

    Deerfield Ridge Assisted Living, a community of Navion Senior Living, located in Boone, NC is seeking Certified Medication Technicians for medication administration-related roles. Our Medication Technicians are responsible for delivering high quality medication administration and resident care oversight in a cutting edge Assisted Living and/or Memory Care...

  • Senior Human Resources Generalist

    1 week ago

    Spring Grove, United States Pixelle Specialty Solutions Full time

    Company Description Pixelle Specialty Solutions™ is the largest specialty paper company in North America, with fully integrated pulp and paper operations in Chillicothe, Ohio, Spring Grove, Pennsylvania, Stevens Point, Wisconsin and a coating operation in Fremont, Ohio. Supported by an experienced product development team, Pixelle excels in designing...

  • EXECUTIVE ADMINISTRATIVE ASSISTANT

    Found in: Careerbuilder One Red US C2 - 18 hours ago

    Long Grove, IL 60047, USA, United States ACCO Brands Corporation Full time

    ACCO Brands is seeking an Executive Administrative Assistant to support our Senior Vice President of U.S. C&OP and Power. A and their team. We seek an enthusiastic, highly competent, organized and customer service orientated, seasoned professional to Administrative Assistant, Executive, Administrative, Microsoft, Vice President, Assistant, Business Services,...

  • Quality Assurance Administrator

    7 days ago

    Garden Grove, United States BuildSubmarines.com Full time

    As our QA Administrator for El-Com Systems, a division of Winchester Interconnect, located in Garden Grove, you will work closely with the Quality Assurance Manager to maintain the AS9100 program for the company and support the Quality Department. El-Com Systems' values are Elevating Customers, Continuously Learning, Caring for our People, Operating with...

  • Quality Assurance Administrator

    3 days ago

    Garden Grove, United States BuildSubmarines.com Full time

    As our QA Administrator for El-Com Systems, a division of Winchester Interconnect, located in Garden Grove, you will work closely with the Quality Assurance Manager to maintain the AS9100 program for the company and support the Quality Department. El-Com Systems' values are Elevating Customers, Continuously Learning, Caring for our People, Operating with...

  • Sr. Software Engineer, Data

    3 days 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...

  • Maintenance Director

    Found in: Resume Library US A2 - 7 days ago

    Banner Elk, North Carolina, United States Navion Senior Solutions Full time

    Deerfield Ridge Assisted Living, a community of Navion Senior Living, located in Boone, NC is seeking a Maintenance Director to join its rapidly growing team. A great Maintenance Director will have a solid understanding of plumbing and electrical systems as well as carpentry and other crafts. They will be well-versed in all maintenance process and health...

  • Senior DevOps Engineer

    11 hours ago

    Downers Grove, United States GTT Full time

    Senior DevOps Engineer Job Description As a Senior DevOps Engineer, your primary responsibility will be to implement DevOps solutions in Azure. The role is a technical, consultative, and client facing role that will be accountable for client solution development, delivery, and support. The ideal candidate will have experience in consulting and have...

  • Quality Assurance Administrator​/Manufacturing

    Found in: beBee jobs US - 1 week ago

    Garden Grove, California, United States Winchester Interconnect Full time

    Position: Quality Assurance Administrator (Manufacturing)As our QA Administrator for El-Com Systems, a division of Winchester Interconnect, located in Garden Grove, you will work closely with the Quality Assurance Manager to maintain the AS9100 program for the company and support the Quality Department.El-Com Systems' values are Elevating Customers,...

  • Quality Assurance Administrator

    9 hours ago

    Garden Grove, United States Winchester Electronics Full time

    As our QA Administrator for El-Com Systems, a division of Winchester Interconnect, located in Garden Grove, you will work closely with the Quality Assurance Manager to maintain the AS9100 program for the company and support the Quality Department. El-Com Systems' values are Elevating Customers, Continuously Learning, Caring for our People, Operating with...