Database Administrator -Microsoft SQL

JOB DESCRIPTION

About OJ Commerce:        

OJ Commerce (OJC), a rapidly expanding and profitable online retailer, is headquartered in Florida, USA, with a fully-functional office in Chennai, India.

We deliver exceptional value to our customers by harnessing cutting-edge technology, fostering innovation, and establishing strategic brand partnerships to enable a seamless, enjoyable shopping experience featuring high-quality products at unbeatable prices. Our advanced, data-driven system streamlines operations with minimal human intervention.

Our extensive product portfolio encompasses over a million SKUs and more than 2,500 brands across eight primary categories.

With a robust presence on major platforms such as Amazon, Walmart, Wayfair, Home Depot, and eBay, we directly serve consumers in the United States.

As we continue to forge new partner relationships, our flagship website www.ojcommerce.com, has rapidly emerged as a top-performing e-commerce channel, catering to millions of customers annually.

• Manage SQL Server databases through multiple product lifecycle environments, from development to mission-critical production systems.
• Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.
• Apply data modelling techniques to ensure development and implementation support efforts meet integration and performance expectations
• Hands-on with Query Optimisation, Replication etc.
• Create and maintain roadmap for our database infrastructure
• Assist developers with complex query tuning and schema refinement.
• Perform scheduled maintenance and support release deployment activities after hours.
• Defining current and future standards for large data-sets with high uptime requirements

Skills

• Must have technical skills in SQL Server 2016+, SSIS, SSRS, SSAS, Power Shell

• Min 2 years MS SQL Server Administration experience required

• Experience with Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools.

• Experience with Query Store, DMVs, Extended Events, wait states, DBCC, PowerShell, SQL Server DBA certification, monitoring/tuning SQL Server without any Third Party Tools and SQL query basics.

• Experience with backups, restores and recovery models

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

• Experience working with Windows server, including Active Directory

What we Offer

• Competitive salary

• Medical Benefits/Accident Cover

• Flexi Office Working Hours

• Fast paced start up