ERP Database Engineer (MSDynamics & SQL Server)

Prosum; Irvine (CA); On-site; USD 90,000 - 120,000; Full time

Benefits offered by this job

Competitive salary

Best places to work recognition

Job summary

A leading sales and marketing agency in California is seeking a Senior Database Administrator. You will be responsible for developing and operationalizing SQL Server features, ensuring database performance, and managing problem resolution. Candidates should have a Bachelor's degree and over 5 years of experience in database administration with strong T-SQL skills. This role involves collaboration with IT teams and requires excellent communication skills. Work in a diverse, fast-paced environment offering both team and independent contributions.

Qualifications

• 5+ years of experience in a SQL Server Data Administration role.
• 3+ years as a Senior Professional DBA.
• Experience in ERP systems and relational database development.

Responsibilities

• Provide architecture and development for Dynamics AX interfaces.
• Research and implement new SQL Server features.
• Drive problem resolution and participate in root cause analysis.

Skills

Database administration

T-SQL

SDLC standards

Problem resolution

Communication skills

Education

Bachelor’s Degree in Information Systems, Information Technology, Computer Science / Engineering or equivalent experience

Tools

SQL Server

Dynamics AX

Job description

• Full-time

Company Description

Our client is one of North America’s leading sales and marketing agencies specializing in outsourced sales, merchandising, category management and marketing services to manufacturers, suppliers and producers of food products and consumer packaged goods.

They service a variety of trade channels including grocery, mass merchandise, specialty, convenience, drug, dollar, club, hardware, consumer electronics and home centers. They bridge the gap between manufacturers and retailers, providing consumers access to the best products available in the marketplace today.

Job Description

DUTIES AND RESPONSIBILITIES

1. Database Technology Solutions Development

• Provides architecture and development for new Dynamics AX interfaces and internal modifications as necessary
• Provides architecture and development across all supported SQL server features/components such as: High Availability, Disaster Recovery, SQL Server monitoring, Data Collection, and others utilizing T-SQL, PowerShell and .Net development tools
• Focuses on further increasing the levels of automation and self-service
• Collaborates with key vendors and Embedded IT teams in providing innovative added value solutions to the company’s SQL Server infrastructure

2. Operationalize new SQL Server features

• Research new SQL Server features and provide recommendations on their implementation in the company environment
• Participate in designing and implementing new solutions utilizing SQL Server features
• Provide detailed documentation, technical presentations and training for development and support teams

3. Problem Resolution and Process Management

• Drive problem resolution and root cause analysis across the technology stack
• Participate in the resolution of database availability, capacity, and performance issues
• Contribute to ongoing improvement of internal processes and SQL Server tools
• Participate in infrastructure and organizational initiatives across multiple IT disciplines

4. Other duties as required

Qualifications

REQUIREMENTS FOR THE ROLE

• Education Level: Bachelor’s Degree in Information Systems,Information Technology, Computer Science / Engineering or equivalent experience
• Experience in ERP systems
• Experience in relational database data warehouse development and maintenance
• 5+ years of experience in an SQL Server Data Administration role
• 3 + years of experience as a Senior Professional DBA
• 3 + years of experience developing applications in Transact SQL
• Hands on experience working with Software Development Life Cycle (SDLC) from concept to production delivery
• Experience working on initiatives across multiple IT disciplines
• Demonstrated strong knowledge of and adherence to SDLC standards
• Demonstrated ability to interface with collaborative work groups to resolve service issues
• Ability to participate and drive problem resolution and root cause analysis
• Ability to analyze situations and develop solutions
• Strong written and verbal communications skills including the ability to communicate technical and business information to both technical and non-technical people
• Proven ability to establish strong partnerships with customers, vendors and peers
• Must be able to work with a diverse workgroup made up of various cultural backgrounds, both remote and local employees
• Must be able to work both as a team member and independently in multi-tasking fast-paced deadline driven environment
• This position is required to participate in the company’s on-call rotation

Additional Information

JENALYN BERNARDO |Prosum|Technical Recruiter

Awarded 7th “Best Places to Work in Los Angeles”