Sorry, this job is no longer accepting applications. See below for more jobs that match what you’re looking for!

SQL DBA / JDE CNC

Expired Job

Stoneridge, Inc. Novi , MI 48377

Posted 5 months ago

JOB SUMMARY:

The SQL DBA/JDE CNC is responsible for leading the design, support and administration of SQL databases and servers. Including installation / administration / maintenance of SQL server instances, create database users, assign user permissions, capacity monitoring, database performance tuning and optimization, database backup and recovering planning/testing and debugging/troubleshooting poorly performing SQL queries and programs.

The SQL DBA/JDE CNC is also responsible for the design, development, testing, support and documentation of client/server application and system architectures for a multi-instance JDE Enterprise One environment. The scope of the position requires a thorough understanding in the current technology of CNC tasks related to package builds, deployments, security, and configuration / troubleshooting of the Enterprise One Application and Web Servers (Web Logic) running in a Windows/SQL environment.

PRINCIPLE RESPONSIBILITIES:

  • Install, configure, patch/upgrade and maintain Microsoft SQL Server instances

  • Administer database users, permissions and manage database objects

  • Configure client network configurations

  • Perform logical and physical database design

  • Implement and enforce database security

  • Monitor and plan for database growth

  • Design and test database backups and recovery planning to meet business's Recovery Point Objectives (RPO) and Recovery Time Objective (RTO)

  • Design and administer SQL Server failover clustering

  • Understand SAN based replication for disaster recovery

  • Provide support and consultation to the Global IT Team on all database related areas

  • Handle incidents and determine system and application failures

  • Daily review of SQL Server logs for unusual events

  • Verify daily that all scheduled jobs have run successfully

  • Verify daily success of database backups

  • Provide 247 support for critical production systems

  • Perform scheduled maintenance and support release deployment activities after hours

  • Participate in Disaster Recovery planning and testing

  • Experience in the development and implementation of standards, procedures and guidelines to support operational processes

  • Work with Network Administrators and Analysts to assess the state of the infrastructure, including servers, and make recommendations to improve efficiency, reduce costs, and support global operations

  • Stay up to date with Microsoft SQL Server features and propose upgrades to enhance system performance and availability

  • Have an understanding of SSIS, SSRS and SSAS

  • Document and publish SQL Server environments so that others can understand and assist in administration of SQL Servers after hours

  • Provide technical diagnosis, execute performance tuning, system optimization and make recommendations on design improvements for the corporate JDE E1 system

  • Responsible for JDE CNC activities, including package builds/promotions, ESU installations, Tools upgrades, service packs, maintaining OMW and OCM

EDUCATION, EXPERIENCE AND KNOWLEDGE:

  • A Bachelor's degree in computer science, programming, or a related field is required; a Master's degree is preferred

  • 5+ years or experience working with SQL server databases, tuning, performance, database tools

  • Knowledge of High Availability (HA), Always On and Disaster Recovery (DR) options for SQL Server

  • Experience working with Windows server, including Active Directory

  • In-depth knowledge of SQL Server with SSIS/SSRS/SSAS is a plus

  • Strong self-management skills in multiple-priority, high ambiguity situations

  • Ability to proactively communicate at multiple levels: executive to individual contributor

  • Comfortable with resolving conflicting viewpoints and achieving consensus

  • Collaborative work style

  • Strong sense of personal accountability for results

  • Excellent written and verbal communication

  • Excellent analytical and problem-solving abilities

  • 3+ years of experience with Oracle's JDE E1 platform is a plus

upload resume icon
See if you are a match!

See how well your resume matches up to this job - upload your resume now.

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon
lc_ad

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove

SQL DBA / JDE CNC

Expired Job

Stoneridge, Inc.