DB Architect

9-10 Years
New York, NY

EZOPS is seeking a highly motivated candidate to be the DB Architect for helping Dev teams with DB code reviews and performance tuning and engage with the clients for DB issues and guide the teams to isolate problems as and when they occur and propose solutions.

Responsibilities:

• Design and Review application DB Data Model for new and existing modules
• Database / SQL tuning – Interpret Query Plans, AWR Reports (or equivalent), and recommend solutions to optimize DB access
• Coordinate with architects and lead engineers to recommend optimizations for slow and time taking queries
• Participate in Performance Lab initiatives to focus on Product Performance issues
• Participate in SQL Code and Schema reviews and walkthrough
• Define and enforce database development standards and guidelines
• Prepare ER diagrams of the database
• Ensure Data integrity and Security of the DB Platform

Requirements:

• Should have minimum of 8 years overall experience, in Databases Technologies Oracle (Must), Postgres and SQL Server. Keen to learn new DB tech
• Successful track record in managing and tuning large databases
• Experience with Oracle RAC and high availability cluster will be added advantage
• Interest in latest technology trends in the industry & drive innovation into engineering
• Must be excellent problem solver, creative thinker & self- motivated
• Excellent collaboration and communication skills

Nice to have:

• Experience within the financial services industry
• Experience of load testing of the database by populating records and executing expensive queries from some load generator tools

Qualifications:

• Bachelor’s degree required
• Experience with AWS RDS desired

About EZOPS: 

EZOPS offers clients an integrated data management platform to resolve data quality, automation and reporting challenges across the data lifecycle. The platform empowers users to transform data, setup and configure reconciliation rules, gain insights into root cause of breaks using machine learning algorithms, seamlessly setup rules via a UI for automated break remediation using BOTS and to create reports and dashboards with low I.T involvement. EZOPS has 5 global offices (San Francisco, NYC, NJ, Dublin, Chennai and Noida) and its clients include some of the largest global financial institutions.