General information

Office (s)
Bangalore, IND
Date Published
Thursday, February 3, 2022
Country
India
Job ID
20120
Function
Information Technology

Description & Requirements

About us:

Epicor is one of the world’s leading enterprise software companies, with more than 20,000 customers in over 150 countries using our products to automate effectively and efficiently to streamline their essential business functions. With industry specific solutions for the manufacturing, distribution, retail and service industries, the strength of Epicor business solutions lies in a simplified approach to technology, with products and services designed to fit our customers and how they work. Epicor is privately owned by KKR & Co. and produces approximately $900M in annual revenue with around 4,000 employees.

Role Summary/Purpose:

As a SQL DB Administrator, you will be responsible supporting day to day database operations, maintaining cloud customer databases including performance tuning and monitoring. The Database Administrator will be responsible for support and sustainment for all hosted client databases including Epicor 10, Prophet 21 and EPICOR’s hosted customer-facing e-commerce web sites. You will be based in our recently opened India Technology Center. This is a unique opportunity for you to take part in Epicor’s next success story from the very beginning as we are building up our new tech campus in Bangalore.

Skills Required:

  • Microsoft MS-SQL product
  • SQL Server Management Studio
  • Ability to create SQL queries and objects such as Triggers, Stored Procedures, Functions and Views
  • Experience maintaining and managing environments with multiple databases (100+) is preferred.
  • Knowledge of MySQL installed in a UNIX environment is a Plus
  • Strong English skills since there will be direct interaction with the US customer base to resolve performance issues.
  • Experience managing mid to large scale database development and sustainment.
  • Excellent customer service skills
  • DBA experience with MYSQL in a Unix environment
  • Previous work with maintaining customer databases in a cloud environment 

Essential job functions:

  • Perform daily monitoring and administrative tasks for all production databases.
  • Participate in the change control process to implement both planned and unplanned migrations through application environments.
  • Work closely with application and systems administrators on current production system changes or upgrades.
  • Support Enterprise Production Operation staff and create/update procedures on database recovery.
  • Create and or utilize automated tools for database monitoring.
  • Assist in database architecting for database systems development, management, and administration and modeling of business applications.
  • Establish database structures and support application development, testing and implementation.
  • Assist with the data recovery from system or application crashes.
  • Maintain current patches and release enhancements for DB server and assess impact on currently running applications.
  • Liaison to the DB vendor for extended problem resolution.
  • Optimize database performance through proactive maintenance.
  • Perform database tuning, monitoring, and database security administration.
  • Always On High Availability / replication and Performance monitoring.

 General requirements:

  • BS degree in Computer Science or related field.
  • Knowledge of MS SQL server and Management Studio
  • 3 - 4 years’ experience or general knowledge in SQL DBA administration
  • Minimum 3 years’ experience evaluating and diagnosing Microsoft SQL performance issues
  • Demonstrated project management skills.
  • Familiarity with MS environment specifically Dot NET
  • Hands on technical knowledge of database monitoring, including database trace tool, building indexes, and creating views.
  • SQL Query scripting experience
  • Excellent English and customer service skills to effectively communicate changes to the customer base.

We offer a clear career path within the IT, Support function with opportunity for further career advancement into our Consulting and Product Development Teams. At Epicor, you can reach your full potential because growth for you means growth for us.

Location: Bangalore

Shift Timings: 5:30pm – 2:30am IST