Senior DBA/System Administrator

1 month ago


O'Fallon Missouri, United States True Manufacturing Full time
Overview:
The IT Department is seeking a motivated and professional Data Base/System Administrator who will be based out of a MO office.  The position will be part of the Business Solutions software development team and play a key role in supporting, maintaining, and updating application and SQL database servers for the company software systems.  This position will be a blend of remote from home and on-site at one of our locations.

Responsibilities:
Responsible for the technical analysis, design, installation, configuration, administration, security, maintenance, monitoring, backups, and disaster recovery of Microsoft Windows application servers and Microsoft SQL database servers. This includes new installations and maintenance of existing environments through tickets and projects.

Responsible for the following third-party application servers: Estore, ConnectShip, Epicor Configurator, SQL Server Report Services (SSRS), SQL Server Integration Services, Power BI and backup for JDE E1 ERP system.

Proactively monitor application servers and databases by configuring server monitoring tools such as SolarWinds.

Diagnose and resolve performance issues by determining the most effective way to increase performance including hardware purchases, server configuration changes, or index/query changes.

Follow change control process, review, and apply development teams’ software and database updates to UAT and Production environments.

Own, track and resolve database related service requests and incidents.

Review and enhance server related reports and monitoring daily to ensure service-related issues are identified and resolved. Develop strategic solutions for recurring problems.

Role requires a service-oriented mentality, high sense of ownership of the problems and service requests assigned thru the Service Desk ticketing system.

Create configuration and systems documentation.

Perform vendor application and database updates per vendor instructions.

Develop strategic solutions to recurring problems.

Effectively communicate with Agile teams, IT Department, Business, and Management.

Perform installations and upgrades, provide support, and troubleshoot system issues during office hours and after hours as required by the business.

Perform Upgrades/System Administration for web servers, application hosts, all Microsoft SQL servers (including Epicor), SQL Server Report Services (SSRS), SQL Server Integration Services (SSIS), and cloud environments.

Monitor scheduled Microsoft SQL jobs, troubleshoot, and resolve issues for any failed jobs.

Position will provide after hours support on critical issues.

Qualifications:
High School Diploma or General Education Degree (GED) required.

Bachelor’s degree in Computer Science, MIS, or similar field OR equivalent work experience required.

Seven or more years of DBA/Windows System Administrator experience required.

Experience designing, installing, and configuring new SQL and Windows Server environments.

Experience configuring and using server monitoring tools.

Hands on experience with Windows servers, patch installation, IIS configurations, FTP, web site/application installation and administration.

Knowledge of High Availability (HA) and Disaster Recovery (DR) options for MS SQL Server.

IT experience with a strong understanding of web applications, web site design, database structures, and practices.  Including experience with HTML, scripting, XML, IIS, web services, etc.

Knowledge on storage technologies in relation to application and database performance/best practices.

Strong technical aptitude and ability to research and solve complex issues independently.

Experience designing and implementing a database backup process in a way that meets the business’s recover point and time objectives.

Experience with migrations and upgrades including consolidation planning.

Experience in implementing operational automation using scripts.

Experience tuning SQL queries to improve performance.

Experience deploying SQL server HA using Virtualization technologies.

Good communication and documentation skills.

Basic WAN/LAN knowledge

Network knowledge Domains/sub-domains.

Experience with Business Intelligence database/tools

Knowledge of the following Microsoft products is required:Microsoft SQL Server

SQL Server Integration Services, and Reporting Services.

Windows Server

We are proud to be an Equal Opportunity Employer.

Company-paid background check required upon hire.


  • PostgreSQL DBA

    6 days ago


    O'Fallon, United States Diverse Lynx Full time

    Must gave have relevant experience and in-depth knowledge in any PostgreSQL administration task. A database administrator's responsibilities can include the following tasks: • Perform installations and upgrades of PostgreSQL (Preferably PPAS 9.4+) • Plan and perform DB Patching. • Knowledge of Database backups / Troubleshoot failures, query execution...


  • O'Fallon, Missouri, United States True Manufacturing Full time

    Overview: The Program and Sales Quota Administrator manages customer pricing programs and calculation of sales quotas and sales credit. This role is responsible for ensuring customer programs are documented accurately for internal and external parties and that our sales representatives receive proper sales credit. The Program and Sales Quota Administrator...


  • O'Fallon, Missouri, United States True Manufacturing Full time

    Overview: The Sr. Marketing Coordinator is responsible for creating and presenting detailed reports by conducting research, maintaining records, and other industry data to aid management in determining marketing direction. This position is responsible for supporting the department’s operations including media campaigns, promotions, and projects, to support...

  • Compliance Manager

    10 hours ago


    O'Fallon, United States Hospital Sisters Health System Full time

    Summary Hybrid at St. Elizabeth's Hospital in O'Fallon, IL The Manager-SEO Compliance Officer is responsible for the successful development, implementation, and oversight of compliance functions for the organization, including but not limited to ministry providers, regulatory, audits, and compliance programs. This role supervises and provides guidance to...


  • O'Fallon, United States TPSC Transportation Products Sales Company - O Fallon, MO Full time

    Job DescriptionJob DescriptionAutomated Railroad Maintenance Systems (ARMS) is located in O’Fallon, MO and sells power and communication  systems to the North American Railroad Industry. ARMS specializes in Design, Distribution, and System Integration including complete turnkey systems. ARMS has an exciting position for a Senior Electronics Technician...


  • O'Fallon, United States TPSC Transportation Products Sales Company - O Fallon, MO Full time

    Job DescriptionJob DescriptionBenefits:Disability InsuranceLife Insurance401(k) matchingBonus based on performanceDental insuranceHealth insurancePaid time offVision insuranceWellness resourcesAutomated Railroad Maintenance Systems (ARMS) is located in OFallon, MO and sells power and communication systems to the North American Railroad Industry. ARMS...


  • O'Fallon, United States Fort Zumwalt R-II School District Full time

    Fort Zumwalt School District SS511**An additional $2/hour is available for those who waive health coverage and are able to prove group creditable coverage elsewhere. JOB TITLE: Administrative Services Executive SecretaryREPORTS TO: Assistant Superintendent, Administrative ServicesFLSA: Non-Exempt Note: Critical features of this job are described under the...


  • Missouri, United States Reflexallen Group Full time

    Reflexallen Group, multinazionale con diverse sedi sparse su tutto il globo e con headquarter sulle colline di Guiglia a Modena, leader internazionale di progettazione, sviluppo e produzione in ambito Automotive è alla ricerca di:La risorsa ideale, riportando all'Infrastructure Manager, supporterà l'intero Team ICT, in un contesto giovane e...

  • Senior TPM

    1 week ago


    O'Fallon, United States SoftPathTechnologies Full time

    Job DescriptionJob DescriptionSenior TPMOfallon MO Long Term OVERVIEW Are you a technical program manager who wants to work for a company that offers above and beyond benefits including paid parental leave, flexible work hours, gift matching, and even volunteer incentives? Do you want to work in an inclusive and nurturing culture that encourages your own...


  • O'Fallon, United States O'Fallon Township High School Full time

    Position Type: Accounting/Secretarial/Clerical/Secretary - 10-MonthsDate Posted: 3/20/2024Location: O'Fallon Township High SchoolClosing Date: 05/09/2024Training/Qualifications/Skills: High School diploma required. Additional college coursework preferred. Computer Skills- must be proficient in Microsoft Office Suite with focus on Word and Excel Experience...


  • O'Fallon, United States True Manufacturing Full time

    Overview: The Sr. Marketing Coordinator is responsible for creating and presenting detailed reports by conducting research, maintaining records, and other industry data to aid management in determining marketing direction. This position is responsible for supporting the departments operations including media campaigns, promotions, and projects, to support...


  • Springfield, Missouri, United States Dexter Axle Full time

    Overview: Dexter, a premier manufacturer and distributor of axles, suspension, brakes, doors, venting products, trailer parts and accessories, and towing components serving the commercial trailer, RV, heavy-duty, marine, agriculture, and manufactured housing markets, has an opportunity for a Administrative Assistant at our distribution facility located in...


  • O'Fallon, United States Resource Informatics Group Inc Full time

    Job DescriptionJob DescriptionRole:-SENIOR SOFTWARE DEVELOPMENT ENGINEER IN TEST (Sr. SDET)Location:-O’fallon MOVisa:-USC/GC Preferred Duration:- 9 Months Interview:-Phone/SkypeOverview• Push Payments Development team owns a number of applications, primarily focusing on the Mastercard Send application.• Mastercard send is an API based application...


  • Chesterfield, Missouri, United States Mercy Full time

    Overview: We’re a Little Different   Our mission is clear. We bring to life a healing ministry through our compassionate care and exceptional service. At Mercy, we believe in careers that match the unique gifts of unique individuals – careers that not only make the most of your skills and talents, but also your heart. Join us and discover why Modern...


  • Jefferson City, Missouri, United States FCS Financial Full time

    Description/Job Summary At FCS Financial, part of the nationwide Farm Credit System, we are looking for an Administrative Assistant to join our Team! FCS Financial is a member of the largest agriculture lending cooperative in the United States today. At FCS, we seek individuals who share passion for agriculture, rural living and helping people achieve...


  • O'Fallon, United States St. Louis Pediatric Dentistry Full time

    Job DescriptionJob DescriptionDescription:The job description is as follows; - Partner with senior manager to ensure quality patient care.- Communicate needs within the office to senior manager (scheduling, doctor, patient, staff). - Oversee all billing within their location.- Assist senior manager in hiring and training staff.- Provide direction to staff as...


  • Kansas City, Missouri, United States BlueScope Full time

    Job Description The Shared Services department consults with North American business leaders and supports their employees by providing a full range of HR services including planning, recruiting, employee relations, training, compensation, benefits, HR systems, and payroll. The HRIS Support Administrator BlueScope business units in the use of the HRIS...


  • Chesterfield, Missouri, United States Mercy Full time

    Overview: We’re a Little Different   Our mission is clear. We bring to life a healing ministry through our compassionate care and exceptional service. At Mercy, we believe in careers that match the unique gifts of unique individuals – careers that not only make the most of your skills and talents, but also your heart. Join us and discover why Modern...


  • Chesterfield, Missouri, United States Mercy Full time

    Overview: We’re a Little Different   Our mission is clear. We bring to life a healing ministry through our compassionate care and exceptional service. At Mercy, we believe in careers that match the unique gifts of unique individuals – careers that not only make the most of your skills and talents, but also your heart. Join us and discover why Modern...

  • Senior TPM

    1 week ago


    O'Fallon, United States Soft source inc Full time

    Job DescriptionJob DescriptionOVERVIEW Are you a technical program manager who wants to work for a company that offers above and beyond benefits including paid parental leave, flexible work hours, gift matching, and even volunteer incentives? Do you want to work in an inclusive and nurturing culture that encourages your own professional learning and...