MOOKESH SUBRAMANIAN

• Lead database and data engineering initiatives for enterprise clients, delivering scalable and high‑performance solutions across Oracle, MySQL, SQL Server, and PostgreSQL platforms.
• Design, implement, and manage cloud‑based database architectures on AWS and Azure, ensuring high availability, security, and cost optimization.
• Drive end‑to‑end database migration and modernization programs, including heterogeneous migrations (Oracle to Aurora/PostgreSQL, SQL Server to Azure SQL) with minimal downtime.
• Architect and support data engineering pipelines using Databricks, enabling large‑scale data ingestion, transformation, and analytics.
• Provide technical leadership in database performance tuning, capacity planning, indexing strategies, and query optimization for OLTP and analytical workloads.
• Collaborate with application, cloud, and DevOps teams to implement secure, compliant, and scalable data platforms aligned with business requirements.
• Manage and mentor teams of database and data engineers, ensuring delivery excellence, best practices, and Deloitte quality standards.
• Lead production support, incident management, and root cause analysis for business‑critical data systems, ensuring SLA adherence.
• Implement automation and DevOps practices for database provisioning, monitoring, backups, patching, and disaster recovery using cloud‑native tools.
• Define and enforce data governance, security, backup, and compliance frameworks across cloud and on‑premise environments.
• Translate business and analytics needs into logical and physical data models, database designs, and data platform roadmaps.
• Prepare and present technical solution designs, migration strategies, and executive‑level status updates for stakeholders and client leadership.

Key Skills

• Databases: Oracle, MySQL, SQL Server, PostgreSQL
• Cloud Platforms: AWS (RDS, Aurora, EC2), Azure (Azure SQL, VMs)
• Data Engineering: Databricks, data pipelines, SQL optimization
• Migration & HA/DR: AWS DMS, CDC, backup and recovery strategies
• Leadership: Team management, client engagement, delivery governance

Technical Skill Set

• Operating System Unix, Linux, AIX, SunOS, Red Hat Linux, windows
• Database Oracle 19c,12C,11g, 10g, 9i, OCI
• Languages SQL
• Tool / Utility AWR Reports, OEM, RMAN, expdp, impdp, TKprof, Data Guard, ASM, RAC, Performance Tuning, OCI – Oracle Cloud Infrastructure, Oracle@Azures
• OS Utilities FTP, SCP, Win SCP, SSH, Putty, Telnet.

● Conducted regular performance audits, identifying areas for improvement and adjusting configurations as needed.

● Optimized database performance through regular maintenance, tuning and optimization.

● Collaborate with business, developers and DBAs to design and validate architecture.

● Monitored and analyzed database activity to identify and prevent incidents and recommend performance improvements.

● Implementing DDL/DML in database through ServiceNow ticket from SVN repository or GitHub repository and supporting Devops.

● Liaised with system administrators to monitor, troubleshoot, triage and provide RCAs for incidents both in on-premises and cloud (Azure & OCI).

● Assisted in migrating databases to newer versions or alternate platforms, minimizing disruption to business operations.

● Developed automated processes to manage database creation in virtualized or cloud.

● Doing data refresh between prod and development environments based on the business

requirement using data pump.

● Managing and mentoring team to use proper SOP to work efficiently with zero error.

Technical skillsets:

● Operating System Unix, AIX, sql , Red Hat Linux Windows Server

● Database Oracle 19c,12C,11g, 10g, 9i

● Languages SQL, Python

● Tool / Utility AWR Reports, OEM, RMAN, expdp, impdp, TKprof, Data Guard, ASM, RAC, Performance Tuning, Exadata, Goldengate

● OS Utilities FTP, SCP, Win SCP, SSH, Putty, Telnet.

CLIENT: Emblem Health - USA 10/2020 – 02/2023 | Remotely from India

● Provided 24/7 support and engineered solutions for high-availability Prod and Dev database utilizing RAC, Data Guard, and ASM as part of MAA strategies in Exadata.

● Pioneered the use of shell scripting for automation of standby status checks and space monitoring, reducing manual oversight.

● Supporting implementation of ASM configuration, patching and upgradation.

● Trouble-shooting database impacting SQL queries using OEM, AWR and ADDM.

● Engaged and supporting in database migration activity from PureFlex to Exadata, Exadata to Exadata servers and other environments.

● Creation of Schema with Quota maintenance, roles and privileges.

● Creating and managing profiles, passwords and oracle key Vaults.

● Monitoring database growth and backup logs.

● Taking performance report on daily, weekly basis and managing junior DBA team.

● Performed logical backups using RMAN and DATA PUMP.

● Proposed database changes to ease monitoring and administrative in RAC.

● Monitored and analyzed database activity to identify and prevent incidents and recommend performance improvements in Exadata and non-Exadata environment.

Technical skillsets:

● Operating System Unix, AIX, sql , Red Hat Linux Windows Server

● Database Oracle 19c,12C,11g, 10g, 9i, PostrgreSql, MongoDB, AWS

● Languages SQL, Python

● Tool / Utility AWR Reports, OEM, RMAN, expdp, impdp, TKprof, Data Guard, ASM, RAC, Performance Tuning, Exadata, Goldengate

● OS Utilities FTP, SCP, Win SCP, SSH, Putty, Telnet.

CLIENT: The Hartford – Insurance BU - USA 11/2017 – 10/2020 | Remotely from India

● Comprehensive knowledge on Oracle Architecture and networking.

● Worked on performance tuning such as analysis of long running & Database slowness

and Capacity Monitoring, etc.

● Good experience in change management & patching activities over Scrum.

● Experience in Datafix (Prod & Non-Prod) script execution activities.

● Gained knowledge in Automatic Storage Management, RAC and Exadata management.

● Handled Release in Production environment.

● Worked on Table Reorg and Stats Gather.

● Worked on Kill DB Session and Process ID.

● Knowledge in Object Logical Backup and Autosys Job monitoring.

● Worked on Oracle SR Creation and follow-up.

● Have experience in 1view and Contract Pull.

● Worked in Shareplex Activity and golden gate for active data replication.

• Collaborated with cross-functional teams to develop innovative solutions for complex technical problems.
• Implemented proactive monitoring systems that minimized potential technical issues before escalating into critical incidents.
• Participated actively in continuous learning opportunities to maintain proficiency in relevant technologies and methodologies.
• My key role is about product design in modelling softwares and coding using arduino.
• Provided remote support for product functionality, maintenance and troubleshooting.
• Provided technical support throughout development phases of new products.
• Collaborated with team members in virtual environments to optimise field experience and development capabilities.
• Ensured data security by implementing stringent backup protocols, safeguarding vital company information from loss or corruption.
• Identified opportunities for process improvement by analyzing current workflows and suggesting strategic enhancements.