Vacancy description
Hyring®
India, Chennai
DBA / Database Administrator - SQL Server - fully remote in Chennai, India is listed on Jobeax. Browse 30,000+ vacancies available.
JOB DESCRIPTION Database Administrator — Trading Portals
Owning the data tier behind One Portal and the client, IB and admin portals already in production.
Database Administrator (Senior / Lead)
Department:- Technology:- Portals & Platform
Remote
Experience required:- 6+ years MySQL / MariaDB in production
The database schema has grown alongside the product rather than under a dedicated data owner. The client and admin applications share one operational database whose migration history now exceeds 165 change files, several of which rewrite client identity and tenancy keys on live tables.
The One Portal programme consolidates the client portal, the IB portal and a new in-house CRM onto a single multi-entity data model, and moves reporting, dashboard and AI-assistant reads onto read replicas and redacted views.
Funding currently dual-writes to external instant-funding and payment-provider databases while the portal-side ledger becomes authoritative. The cutover requires reconciliation that someone owns end to end.
No one currently rehearses database restores, owns index and capacity strategy, or reviews schema changes before they reach production. Because the data includes client money movement and KYC records, this is a compliance exposure as well as an engineering one.
Own backup, point-in-time recovery and retention across every production data store, proven by scheduled restore rehearsals with measured recovery point and recovery time objectives.
Review every database migration before it is merged — locking behaviour, index coverage, nullability, foreign keys and backfill cost against real production row counts.
Enforce the expand → backfill → switch → contract pattern for breaking changes, using online schema-change tooling where table size requires it.
Rehearse the high-risk CRM and identity migration chain on a production-shaped copy of the data, retaining reconciliation evidence for each rehearsal.
Own the maintenance calendar against the FX trading week: structural change is released at weekend market close, not mid-week.
2.3 Performance and capacity
Set index, partitioning and archival strategy for the large funding, trading-account and audit tables, including retention of records required by compliance but not queried operationally.
Tune connection pooling, buffer pools and server parameters across application, queue-worker and reporting workloads.
Forecast capacity and review instance sizing and cost for managed database and cache services.
Implement least-privilege database roles: separate credentials per application, per queue worker and per reporting consumer, with SELECT-only redacted views behind reporting and AI read paths.
Maintain encryption at rest and in transit, credential rotation, and the removal of shared logins and ad-hoc production access.
Maintain audit trails and data-retention controls that withstand regulator and external-auditor scrutiny of KYC and money-movement records.
Define and publish naming, character-set and data-modelling standards, and keep an inventory of databases, owners and data classification.
Six or more years administering MySQL or MariaDB in production, including at least one environment carrying financial or otherwise regulated transaction data.
Strong query and schema optimisation: execution-plan analysis, composite index design, and the judgement to rewrite a query rather than add another index.
Delivered zero-downtime schema changes on large tables using gh-ost, pt-online-schema-change or native online DDL.
Able to review an ORM-generated migration and the SQL it produces. Laravel or other PHP framework experience is an advantage; unfamiliarity with PHP is not a blocker.
Practical AWS RDS or Aurora experience: parameter groups, multi-AZ, replicas, snapshots and CloudWatch metrics.
Monitoring and diagnosis using slow-query logs, performance_schema, and a tool such as Percona Monitoring and Management.
Automation scripting in Bash plus Python or PHP, with database changes version-controlled and peer-reviewed like application code.
Retail FX, CFD or brokerage industry background, or familiarity with MT4/MT5 data structures.
Multi-tenant or multi-entity data modelling, where one client identity is scoped by regulatory entity.
Data migration from a SaaS CRM such as Salesforce into a self-hosted model, including reconciliation of migrated records.
Redis, RabbitMQ or Kafka operations alongside a relational estate.
PostgreSQL or SQL Server, and analytics or data-warehouse replica experience.
Experience working within PCI DSS, GDPR or financial-regulator audit cycles.
Similar vacancies
COFORGE LIMITED
Job Title : Database ArchitectKey Skills : Database Architecture, AWS Cloud, Data Modeling, PostgreSQL, MongoDB, MS SQL Server, Redis, Database Administration, Data Security, CI/CD, Performance https://jobeax.com/link/5NeFQ1bToKfk86Fe : 10+ https://jobeax.com/link/elpmNuUlUrtRmNOJ : Greater Noida / Hyderabad / https://jobeax.com/link/UCZrYp5CpALPbNuJ ...
India, Bengaluru
Sedgwick Group
10k - 33k
... related field. 7+ years of data engineering experience, including expertise in data integration, pipeline optimization, and enterprise-scale data solutions. - Databases: Oracle and PostgreSQL - ETL/ELT & Data Integration: Experience in maintaining and refactoring existing data pipelines - Data Warehousing & Governance: Strong ...
India, Bengaluru
Quotient Consultancy
... creation of software and systems to increase observability, product reliability, and organizational efficiency.- Maintain and monitor deployment, orchestration, of servers, docker containers, databases, and general backend infrastructure.- Develop Run Books/Standard Operating Procedure for recurring Production issues, also working ...
India, Mumbai
Tech Specialist, Database & Middleware
India, Bengaluru
Flexiple
Systems Administrator A global pharmaceutical company building its India hub Location: Remote (India) A global pharmaceutical company is building its India hub and has partnered with Flexiple to hire a systems administrator to run its India IT infrastructure. You will keep servers, systems, and identity infrastructure secure ...
India, India
fetchjobs.co
... delivering solutions that make a tangible difference in our clients' operations. We are seeking a highly skilled and self-motivated Senior IT Systems & Automation Administrator to join our dynamic team. This role is pivotal in managing and modernizing our internal IT environment, with a focus on building AI agents and automations ...
India, India
com/link/8om4ubga9gvjbUNE
India, Chennai
jbr architecture college
We are looking for a System Administrator to maintain, upgrade and manage our software, hardware and networks. Install and configure software and hardware Monitor performance and maintain systems according to requirements Any graduate with minimum 2 years of experience as a System Administrator, Network Administrator and ...
India, Rāniganj
SPAR Solutions
... designing Salesforce integrations using APIs and middleware (such as MuleSoft, TIBCO, Dell Boomi, or similar), as well as point-to-point integrations. Salesforce Administrator certification required; Proven experience with full lifecycle Salesforce implementations, including configuration Experience working in agile delivery environments. ...
India, Pune
Rs 2 - 3 lakhs p.a.
Key Responsibilities: • Manage front desk, visitor handling, and incoming calls. - Greet visitors and coordinate meetings and appointments. - Handle emails, courier, post, and general office communication. - Maintain office records, documents, attendance, and stationery.
India, Mumbai
Position Overview We are seeking a detail-oriented and proactive Problem Manager to join our IT department.
India, Ahmedabad
... In-House Hiring Understand manpower requirements and job specifications from hiring managers. Source candidates through job portals, social media, referrals, databases, and other recruitment channels. Screen CVs and conduct initial telephonic/virtual interviews. Assess candidates based on skills, experience, communication, ...
India, Chandigarh
Weekday AI
... zero-touch MDM and endpoint security across macOS and Windows environments. Manage endpoint encryption, patching, EDR, security policies, compliance controls, and remote-wipe capabilities. Maintain accurate IT asset records from procurement through disposal , ensuring zero untracked devices. Manage ITAM/ITSM platforms and maintain ...
India, Bengaluru
Rs 2 - 3 lakhs p.a.
Key Responsibilities: • Manage front desk, visitor handling, and incoming calls. - Greet visitors and coordinate meetings and appointments. - Handle emails, courier, post, and general office communication. - Maintain office records, documents, attendance, and stationery.
India, Thāne
index trendz
Company Description Index Trendz is a leading platform for stock market education in India, specializing in Futures & Options (F&O) and Commodity Trading. Based in Chhattisgarh, the organization provides practical, result-oriented training for learners ranging from beginners to advanced traders.
India, India
Apex Talent
... experienced Oracle PL/SQL Developer with hands-on experience in Core Banking Systems (CBS), preferably Oracle FLEXCUBE. The candidate will be responsible for PL/SQL development, FLEXCUBE customization, database-related development, troubleshooting, and production support. Java experience is https://jobeax.com/link/evc6pNVFUYDlaokF ...
India, Chennai
Ensono
Job Description – Linux L3 System Administrator Job Summary The Linux L3 System Administrator is responsible for advanced architecture, administration, troubleshooting, and optimization of large-scale Linux environments. This role provides technical leadership, handles complex incidents and escalations, drives automation ...
India, Bengaluru
Ensono
Job Description – Linux L3 System Administrator Job Summary The Linux L3 System Administrator is responsible for advanced architecture, administration, troubleshooting, and optimization of large-scale Linux environments. This role provides technical leadership, handles complex incidents and escalations, drives automation ...
India, Chennai
Alike Thoughts
... development efficiency and https://jobeax.com/link/nhK2IvkRzA154ncr Skills:- Strong hands-on experience with SQL and Advanced PL/SQL.- Strong experience with MySQL/database development.- Proficiency in Python or PySpark.- Experience in data pipeline and ETL/ELT development.- Strong database performance-tuning and query-optimization ...
India, Pune
Artech Infosystems Private Limited
Rs 8 - 18 lakhs p.a.
... reusable, scalable, and maintainable Python code. Write complex and optimized SQL queries , stored procedures, joins, subqueries, and CTEs. Work with relational databases such as PostgreSQL, MySQL, Oracle, or SQL Server . Develop and integrate REST APIs and backend services. Troubleshoot application and database-related issues ...
India, Chennai