Krishnamoorthy Ramachandran

IT professional with background in U.S. healthcare, enterprise data, and database administration of large-scale deployment, optimization, tuning of database systems on Teradata, Exadata, Databricks. Management of team and production environment for system high reliability and availability. Proficient in database security, backup and recovery, and system migration. Familiarity with ServiceNow for incident management and workflow automation. Practical experience in different database technologies, frameworks, and software tools, and adequate knowledge of software architectures, cloud platforms, and DevOps practices. IT professional with background in U.S. healthcare, enterprise data, and database administration of large-scale deployment, optimization, tuning of database systems on Teradata, Exadata, Databricks. Management of team and production environment for system high reliability and availability. Proficient in database security, backup and recovery, and system migration. Familiarity with ServiceNow for incident management and workflow automation. Practical experience in different database technologies, frameworks, and software tools, and adequate knowledge of software architectures, cloud platforms, and DevOps practices.

• IBM Certified Database Associate, The certification on IBM Database product DB2 Universal Database v8.1 Family, IBM Software group
• Oracle Certified Professional, The certification on develop PL/SQL program units, Oracle Corp.
• Teradata Certified Professional, The certification on Teradata Database, Teradata Corp.
• Diploma in Computer Technology, Certifications in Information Technology encompass a diverse range of subjects., State Board of Technical Education and Training Madras Tamil Nadu India VISA

• Results-driven with extensive experience in data analysis, business process re-engineering, and large database administration in U.S. healthcare. Effectively managed and tuned big-data deployments using Teradata, Exadata, and Azure Data Bricks to deliver data operations and integrity. Experienced in leading teams and collaborating with cross-functional teams to develop and implement data-driven solutions aligned to business objectives. 24/7 Production environment monitoring, troubleshooting of critical performance and user access issues Installation, upgrade, maintenance, administration of muti-terabyte RAC on Linux platform Administered Oracle clusterware and resources using SRVCTL SQL Tuning, End user tuning and troubleshooting using tools like EXPLAIN PLAN, AUTOTRACE, SQLTRACE , AWR , ASH and v$ performance views Proactively monitored and diagnosed symptoms using OEM (Enterprise Manager) to significantly increase probability of success of production db and application Good experience with Data modeling to translate logical data elements into the physical database design. Provide and implement performance tuning recommendations of all components in Exadata database machine and in-depth knowledge of Exadata Storage Indexes, Hybrid Columnar Compression, and Smart Scan for performance tuning. Provide guidance on SQL query optimization, leveraging parallel query processing, partitioning, and indexing strategies Ensured system, application performance and availability with debugging complex technical problems and resolving them. Established incident ticket management and change/service request practices using ServiceNow and offered real-time resolution through best process procedures. Primary technical resource in SQL tuning in Exadata production and performance Testing Good experience with Data Modeling to translate logical data elements into the physical database design Provided technical troubleshooting and give consultation to development teams Load tested DB workload with > 2000+ concurrent sessions accessing EPIC clarity system on Exadata Involved in X6 to X8 hardware migration and database configuration Good experience in Hot/Cold backups Good understanding of RMAN backups Experience in Security and Database Auditing Collaborated with Oracle Engineers in debugging and resolve the problems Schema management, partitioning the tables and indexes of objects Tuning of the queries of the PL/SQL procedure for faster execution Worked extensively on Unix Environment to offer DBA support Worked on Table partitions task such as exchange partition, split partition etc
• Teradata to Exadata Migration & EPIC Clarity Upgrade Challenge: We were experiencing scalability and performance issues in our existing Teradata configuration, which made it difficult to process big-size analytics. The project team also wishes to derive maximum benefit and implement Exadata new version and integrate the EPIC Clarity system to manage database Roles and Responsibilities Directed a high-profile migration project, leading the migration of 800 TB of production data from Teradata to Oracle Exadata Collaborative efforts with DBAs and business stakeholders towards creation of a top-to-bottom migration strategy in a bid to maintain data integrity while migrating. Performed thorough performance analysis, SQL query optimization for faster execution time and database performance optimization while migrating. Cloud Data Migration – Data Bricks Challenge: The organization was facing issues with on-premises data warehouses that were giving rise to scalability issues and were costly to operate. Business consumers need to consolidate different downstream data sources into the Databricks common integration platform in order to generate informative reports. Roles and responsibilities Team member of end-to-end enterprise data migration from on-premises Exadata database to Azure Databricks Performed gap analysis to determine major dependencies and reduce business downtime. Created and applied data validation approaches, with 100% data accuracy after migration Worked with implementing the process for Incremental data processing on a daily basis Worked with developing code using Pyspark Data Migration on Instance consolidation project Challenge: The company used EPIC Health connect instance on a few instances running and challenge in managing a few licenses and expense of managing the infrastructure. The proposed solution to consolidate multiple EPIC Health connect instance to the single instance. This initiative will have direct impact to the data management of the production system. Roles and responsibilities Lead Member of end-to-end enterprise solution to design the data migration strategy, with a smooth transition preserving business continuity in reporting. Designed and executed solutions to enable business reporting without major changes, aligning with existing business processes. Developed complex PL/SQL stored procedures to integrate multiple datasets into one business logic, simplifying data usage for business teams. Managed databases and provided ongoing support to preserve data integrity, performance, and availability.