Kishore Machiraju
Wesley Chapel
Summary
Accomplished Sr. Database Administrator at EPAM, specializing in SQL performance tuning and cloud architecture. Proven track record in optimizing database systems, enhancing performance by up to 60%. Adept at project coordination and effective communication, ensuring seamless data migration and high availability configurations across diverse environments.
Overview
14
14
years of professional experience
Work History
Sr. Software Database Engineer/Architect
EPAM
Newtown
04.2024 - Current
- Day-to-day DBA duties involve monitoring all the instances for any specific errors, activities.
- Migrated and Upgraded Oracle 12c Databases to 19c using Transportable Tablespaces for Large databases in Linux environment.
- Administered PostgreSQL databases to ensure optimal performance and availability.
- Monitored database health using pg_stat_activity, pg_stat_replication, and monitoring dashboards to ensure optimal performance.
- Tuned complex SQL queries, PL/SQL/PLpgSQL procedures, and functions to improve performance by up to 40–60%.
- Developed logical and physical data models, optimized schema design, and enforced best practices for indexing, partitioning, and normalization to support data integrity.
- Maintained MySQL databases across dev, test, and production environments, performing tuning and daily operations to enhance stability.
- Implemented database monitoring and performance dashboards using Datadog / Oracle Enterprise Manager / pg_stat_statements.
- Designed partitioning strategies, query parallelization, and caching layers for high-throughput applications.
- Working on DataDog to monitor Postgres databases like setting up monitoring, metrics, APM, database Integrations.
- Administered Cosmos DB instances across Azure regions.
- Monitored performance metrics using Azure Monitor and Log Analytics
- Resolved issues related to Data Guard, Oracle RAC environments, and Golden Gate.
- Installed and configured High Availability Oracle GoldenGate (OGG) systems on Oracle 11GR2.
Sr. Database Administrator
KK Associates – Allianz Life
Minneapolis
08.2021 - 04.2024
- Migrated and Upgraded Oracle 12c Databases to 19c using Transportable Tablespaces for Large databases in Linux environment.
- Resolved issues related to Data Guard, Oracle RAC environments, and Golden Gate to maintain system integrity.
- Installed and configured High Availability Oracle GoldenGate (OGG) systems on Oracle 11GR2.
- Managed all aspects of the OGG design and support in development, UAT, and production environments.
- Developed and optimized complex PL/SQL procedures, packages, and materialized views to support analytical workloads.
- Implemented partitioning, indexing, and parallel query strategies in Oracle EDW to improve query performance for large fact tables (100M+ rows).
- Designed subject-oriented data marts and integrated them into the centralized EDW.
- Monitored all database instances for errors and activities to ensure optimal performance and reliability.
Prometheus/Grafana DevOps Engineer
Dahl Consulting (Reach Media Network)
Minneapolis
04.2021 - 08.2021
- Monitoring wide range of databases along with host level metrics through Prometheus using Grafana dashboards.
- Installing and Configuring Node exporters on Prometheus to monitor through Grafana.
- Developed alerts using complex PromQL ad hoc queries to enhance monitoring capabilities.
- Configured alerts to deliver notifications via SMS, Teams Chat, and email based on warning or critical status.
- Setting up and configuring Redis/ Mongo DB/ MySQL exporters on Grafana using as data sources.
- Monitored remote inaccessible hosts on Azure to ensure comprehensive visibility and reliability.
Sr. Database Administrator/Architect and AWS Architect Consultant
ProPharma Group
Minneapolis
05.2012 - 03.2021
- Proficient in AWS services like VPC, EC2, S3, ELB, AutoScalingGroups (ASG), EBS, RDS, IAM, CloudFormation, Route 53, CloudWatch, CloudFront, CloudTrail.
- Set up S3 buckets in AWS to efficiently store and serve static content for web applications.
- Created EBS volumes for storing application files for use with EC2 instances whenever they are mounted to them.
- Created snapshots to take backups of the volumes and images to store launch configurations of the EC2 instances.
- Migrated PostgreSQL from on-premises to AWS EC2 and RDS environments.
- With the help of IAM created roles, users and groups and attached policies to provide minimum access to the resources.
- Scaled distributed in-memory cache environment in the cloud using Elastic cache.
- Configured AWS Identity Access Management (IAM) Group and users for improved login authentication.
- Installation and configuration of Oracle 10g/11g/12c/18c/19c Database on Windows environments.
- Coordinated Oracle Argus Safety system operations, ensuring system reliability and compliance.
- Configured Argus Safety System in Validation and Production environments.
- Written SQL queries for generating Ad-Hoc Reports for Oracle Argus Safety.
- Designed, Installation, Configuration and Administration of the Oracle 12c Active Data Guard.
- Maintaining Data Guard Observer to switchovers, enabling or disabling FSFO.
- Resolved database performance issues and managed user administration, schema, profile, and role handling to optimize database functionality.
- Set up RMAN backup configuration and implemented the Incremental backups using Level 0 and Level 1 along with Archive scheduling.
MySQL Database Administrator
Optum
MN
12.2019 - 02.2021
- Utilized Percona Grafana to monitor and optimize MySQL database performance.
- Managed MySQL databases through Dbeaver for streamlined administration.
- Installation, Configuration and Administration of MySQL (5.7.30).
- Executed MySQL upgrade processes to enhance database performance.
- Addressed database performance and user administration issues, improving overall system functionality.
- Actively involved in database backups and restores from Prod to lower environments.
- Delivered on-call support for production systems.
Sr. Oracle Database Administrator
Prime Therapeutics
Minneapolis
02.2018 - 05.2019
- Designing, Installing, Configuring, and administrating the Oracle 12c Active Data Guard, Oracle Golden Gate 12c.
- Managed Data Guard Observer to facilitate seamless switchovers and FSFO operations.
- Worked on issues related to database performance, user administration, schema, profile, and role handling.
- Worked on Database Refreshes using RMAN and Data Pump procedures.
- Administered CAMM and ScriptMed applications, enhancing performance and reliability.
- Collaborated with project and application teams to ensure compliance with data quality standards and architectural guidelines.
Sr. Oracle Database Administrator
Solutran Inc.
Minneapolis
06.2017 - 12.2017
- Resolved database performance issues and managed user administration, schema, profile, and role handling to improve overall database efficiency.
- Installed, configured, and maintained Oracle 13c Enterprise Manager Cloud Control to ensure optimal database management.
- Installed agent software across multiple host platforms to enhance system monitoring and management.
Sr. Oracle Database Administrator
Target Corporation
Minneapolis
01.2017 - 06.2017
- Coordinated migration from Oracle RAC to Exadata platform in collaboration with Exadata services team and EDABI portfolio teams.
- Extensive experience in administering maintaining Oracle Applications E-Business Suite 11i:11.5.10,11.5.10.2 and R12:12.0.4.
- Expertise in Oracle Apps 12.2 Patching.
- Installed, configured, and deployed Oracle E-Business Suite.
- Set up and Administration of Oracle 12c Golden Gate.
- Worked on issues related to database performance, user administration, schema, profile, and role handling.
- Worked on issues related to Data Guard, Oracle RAC environments, Golden Gate.
- Worked on issues related to RMAN Full, Archive and Control file backups via GRID Jobs and manually connecting to target and catalog.
- Executed database refreshes from production to test and development environments for Micro-Strategy, eDW, and DPM portfolios.
- Coordinated with off-shore DBAs in India to address incidents and resolve issues.
Education
MS - Computer Science
University of Oklahoma
Norman, OklahomaBachelor of Technology - Computer Science
JNTU
HyderabadSkills
- Database administration
- SQL optimization
- Data migration and monitoring
- Data warehousing
- Data modeling and design
- High availability systems
- Cloud architecture
- Problem solving strategies
- Risk analysis
- Project management
- Effective communication skills
Education And Professional Development
MS, Computer Science, University of Oklahoma, Norman, OK, Bachelor of Technology, Computer Science, JNTU, Hyderabad, Not Provided, Microsoft Azure Data Fundamentals, Oracle Certified Professional (OCP): Oracle12c DBA, Oracle Certified Professional (OCP): Oracle11g DBA, Oracle Certified Professional (OCP): Oracle10g DBA, Oracle Certified Professional (OCP): Oracle9i DBA, Oracle Certified Professional (OCP): Oracle8i DBA, Oracle Certified Associate (OCA): Oracle Application Server 10g Administrator, Real Application Clusters Administrator Certified Expert: Oracle Database 10g, ServiceNow Fundamentals, ServiceNow, AWS Solutions Architect, CloudGuru, AWS Database Specialty, Udemy, Oracle Application Server Administration, Online
Applications Systems And Cloud
- Oracle Argus Safety, OAM, Atlassian JIRA, HP Service Desk, Oracle 10g/11g/12c/13c Enterprise Manager Cloud Control, CVS, BMC Remedy, HP OVO Java console, Crystal Reports, IBM WebSphere, Grafana, Oracle 8.0/8i/9i,10g,11g,12c,18c,19c, Oracle 10g/11g RAC, Oracle9i AS, Oracle10g AS, Oracle Golden Gate, Oracle Data Guard, Oracle Peoplesoft, Oracle Argus, Oracle Exadata, SQL Server, MySQL, PostgreSQL 9.5, SQL Plus, PL/SQL, Oracle Enterprise Manager (OEM), EDW, GRID Control, SQL
- Loader, Export/Import, ERWIN, ASM, RMAN, Streams, RAC-CRS, Informix, Objectivity, OAppCfgEd, Opera SMT, LogMiner, TSM, Autosys, CVS, Oracle 11g Forms and Reports, Dbeaver, MySQL Workbench, EC2, EBS, S3, Glacier, VPC, Elastic IPs, Security Groups, AutoScalingGroups, CloudTrail, CloudFormation, CloudWatch, CloudFront, IAM, SNS, RDS, Dynamo DB, ElasticCache, RedShift, KMS, Route 53, Aurora, CosmosDB, DataLake, DataDog, UNIX, Red Hat Linux 7.3, MS Excel, Sun Solaris 9, AIX, Window 95/98/2000/2003, 2012, Windows NT 4.0, VMWare, macOS
Industry And Regulatory Experience
- Banking
- Hospitality
- Government
- Retail
- Finance
- Education
- Pharmaceuticals
- Medical Devices
- Clinical Trials
- Health & Safety Call Center
- Food and Drug Administrator (FDA)
- 21 CFR Part 11
Timeline
Sr. Software Database Engineer/Architect
EPAM
04.2024 - Current
Sr. Database Administrator
KK Associates – Allianz Life
08.2021 - 04.2024
Prometheus/Grafana DevOps Engineer
Dahl Consulting (Reach Media Network)
04.2021 - 08.2021
MySQL Database Administrator
Optum
12.2019 - 02.2021
Sr. Oracle Database Administrator
Prime Therapeutics
02.2018 - 05.2019
Sr. Oracle Database Administrator
Solutran Inc.
06.2017 - 12.2017
Sr. Oracle Database Administrator
Target Corporation
01.2017 - 06.2017
Sr. Database Administrator/Architect and AWS Architect Consultant
ProPharma Group
05.2012 - 03.2021
MS - Computer Science
University of Oklahoma
Bachelor of Technology - Computer Science
JNTU