Database Administrator - SQL Server (4-8 yrs)

Role : Database Administrator

Location : Bangalore- India

Purpose :

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.

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 :

- 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 system's 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 :

- Bachelor's / Master's Degree in Computer Science or equivalent

- One or more technical certifications on Database management / administration preferably coupled with certification in Windows server administration.

- 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 2016,2019 with experience on SSRS, SSIS, SSMS

- Good working knowledge of SQL Security

- Knowledge of Windows operating systems: 2016,2019

- 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 / SpotlightonSQLServer, SharePoint, Red-Gate

- Exposure to SOX and ITIL

- This role could involve some amount of International travel to support other locations.