Summary role description:

Hiring for a Database Administrator (Oracle DBA on GCP) for a global technology company specialising in E-commerce and product data management in the B2B marketplace.  

Client description:

Our client is a global technology company that delivers powerful, affordable eCommerce solutions for the B2B marketplace. They have been helping the world’s largest retailers and distributors transform their e-commerce experiences for over 20 years. Their cloud-based eCommerce platform and product data enrichment services help distributors, manufacturers, and wholesalers increase online sales, reduce cost to serve, and enhance their digital channel. There are certified ISO 9001:2008- and ISO 8000-certified company with North American headquarters outside of Philadelphia, PA. Their flagship E-Commerce Platform is at the center of some of the most successful digital transformations in the B2B Mid-Market in the United States. They also offer a syndicated product data subscription that makes it easier for customers to launch their storefronts quickly. They have almost 400 customers and are uniquely positioned as the leader in B2B E-commerce for the mid-market. They are backed by one of the world’s largest private equity groups – Investcorp. They have offices in Bangalore and Mysore in India and are headquartered in Philadelphia, PA. They are named one of the "50 Fastest Growing Tech Companies" by The Silicon Review and have been positioned in the Magic Quadrant for Digital Commerce by Gartner since 2016. 

Role details:

• Title: Database Administrator 
• Location: Bangalore, Mysore
• Work mode: Onsite / Remote

Role & responsibilities:

• Assist in daily administration activities including setup, configuration, and monitoring of databases to ensure backups, availability and performance are all maintained to the highest standards.  
• Tuning, troubleshooting and on-call production support for database environments deployed in multi-zone GCP environments. 
• Monitor and work the JIRA ticket queue for requests to make schema and security changes, execute scripts against the databases, and refresh non-production databases. 
• Advise application development and support teams on process bottlenecks and provide database tuning to ensure optimal performance. 
• Assist the support staff to troubleshoot SQL and any other database errors. 

• Provide 24*7 on-call support (includes holidays) for the Oracle, CloudSQL (MySQL/PostgreSQL) production and non-production databases. 
• Report weekly to management about abnormalities and critical issues; provide root cause analysis and recommendations; work with infrastructure, application, and/or other teams for problem resolutions, following the escalation path if needed. 

Candidate requirements:

• Must have more than 5+ years’ experience in database administration (Oracle DBS on GCP). 
• Must have 3+ years’ experience in Oracle, MySQL, MSSQL or other database scripting language. 
• Must have experience in Unix/Linux general administration skills and/or bash/python/PowerShell scripting.
• Must have knowledge of ANSI SQL Language (SELECT, INSERT, UPDATE, DELETE, JOIN, WHERE, etc...) 
• Knowledge of one or more database data replication tools.
• Strong analytical, communication both written and verbal, and quality control skills 
• Detail oriented, self-motivated and uses sound judgment in managing multiple projects with different timelines

Interview process:

• 2 Technical rounds 
• HR Discussion