Associate Lead, Data Transformation

Why join us

Our purpose is design for the good of humankind. Its the ideal we strive toward each day in everything we do. Being a part of MillerKnoll means being a part of something larger than your work team or even your brand. We are redefining modern for the 21st century. And our success allows MillerKnoll to support causes that align with our values so we can build a more sustainable equitable and beautiful future for everyone.

Role: Associate Lead Data Transformation

Location: India / China

Purpose
We have open role for Associate Lead for DBA team in Software Engineering group. Primary responsibilities are - Administers and maintains multiple high-availability database servers and database services supporting various HMI systems. Establishes positive working relationships within IT the business partners and with other functional areas of the company. Utilizes technical expertise to define design and implement database solutions within functional area(s) of responsibility. Establishes and maintains priorities for projects and simultaneous assignments. Implements monitors and enforces data security controls and measures to ensure integrity and high availability of database systems. Manages mentors guides and instructs team members of work delivery prioritization and capacity planning. 70% of time is expected to be spent as an Individual Contributor with above mentioned experience.

Rest 30% of time is expected to be spent as an Associate Team Lead. The Associate Lead will perform other duties as assigned that are in line with the roles responsibilities and are required for the business. Along with technical expertise this role involves the following people management responsibilities:

Regular team connects and one-one meetings with the team members.
Regular interactions with Business Partners for Team management feedback collection and to liaise on work delivery matters.
Conducting performance reviews via Check-in conversations.
HR policy compliance (leave and discipline)
Conflict resolution
Mentoring coaching and development of team members as necessary.
Participation in all recruitment activities of the team

This role extends beyond geographical boundaries as it aims to support the Herman Miller business across the globe and involves some amount of travel and flexible working in shift rotations extended hours and weekend coverage to ensure business is supported.

Responsibilities as Individual Contributor:
Ensure security and SOX requirements are adhered to and respond to audits as required.
Complete the periodic internal SOX Audits ensuring Documented evidence and IPE is maintained.
provide effective ERP and DBA support across the international sites.
Manage SQL Server databases
Configure and maintain database servers and processes
Monitor systems health and performance
In charge of database backup and recovery methods database access security and integrity physical data storage design and data storage administration
In charge of database migrations and server updates
Ensure high levels of performance availability sustainability and security
Analyze solve and correct issues in real time
Provide suggestions for solutions
Refine and automate regular processes track issues and document changes
Proactively monitor SQL Server maintenance tasks troubleshoot failed processes and address issues as soon as possible.
Assist developers with query tuning and schema refinement
Provide 24x7 support for critical production systems
Perform scheduled maintenance and support release deployment activities after hours
Participate in continuous process improvement
Make recommendations for system architecture per Microsoft SQL Server best practices
Ensures that the infrastructure is built-out for High Availability Recoverability DR and Performance.
Ensures integration of enterprise application and database performance monitoring and altering management systems.
Manage the periodic refresh and ad-hoc refresh of test and Stage Environments
Upgrade ERP systems and apply patches as required
Provide Support for the development teams in US UK India and APAC

Minimum Requirements
Bachelors / Masters Degree in Computer Science or equivalent
One or more technical certifications on Database management / administration preferably coupled with certification in Windows server administration.
Total experience of 9 years and at least 6 years of hands-on database administration experience with Microsoft SQL in large multi-server multi-location enterprise environments (including virtualized environments).
Excellent interpersonal skills. Strong oral and written communication skills to work closely with internal customers (IT and users) and third party vendors
Strong analytical and problem solving skills with attention to detail.
Ability to view opportunities and solutions from a broad long term perspective.
Good working knowledge of SQL with experience on SSRS SSIS SSMS
Good working knowledge of SQL Security
Knowledge of Windows operating systems:
Knowledge of VM and SAN database optimization
Proactive methodical and willing to own and resolve issues
A team player with the ability to work on their own
Able to work to tight deadlines
Able to work closely with the leadership to design implement and improve processes regularly

Essential Experience
Database Administration experience of at least 6 years in a busy commercial and enterprise environment
Certification in Microsoft SQL server administration (2014 and above)
SQL Profiler & Tuning skills
Experience of database replication mirroring or log shipping
SQL Security management
Experience of managing small team of DBAs
Experience of Business Application Administration and support.
Clear confident communication skills
Experience building and maintaining a strategic plan.

Desirable

Experience of Infor Syteline ERP system - This is highly desirable
Certification in Oracle Database Administration (Preferred)
Foglight / Spotlight on SQL Server SharePoint Red-Gate
Exposure to SOX and ITIL

Specific notes on Leadership responsibilities:
Those aspiring to take on leadership responsibilities should demonstrate a high level of emotional intelligence to be able to connect and work well with their direct reports their peers and other stakeholders in the organization through empathy motivation and partnership that leads to better results as a team.
Ability to articulate thoughts plans and decisions clearly along with capabilities in planning and forecasting for the future will be attributes that are sought after for this position.
This role may involve some amount of international travel to support other locations.

Who We Hire

Simply put we hire qualified applicants representing a wide range of backgrounds and abilities. MillerKnoll is comprised of people of all abilities gender identities and expressions ages ethnicities sexual orientations veterans from every branch of military service and more. Here you can bring your whole self to work. Were committed to equal opportunity employment including veterans and people with disabilities.

MillerKnoll complies with applicable disability laws and makes reasonable accommodations for applicants and employees with disabilities. If reasonable accommodation is needed to participate in the job application or interview process to perform essential job functions and/or to receive other benefits and privileges of employment please contact MillerKnoll Talent Acquisition at .