Konda Chevva

ad3gbq@r.postjobfree.com 609-***-****

Objective

Experienced and detail-oriented Database Administrator seeking to leverage a comprehensive background in database management, optimization, and security to contribute to the efficient and effective management of your company's data infrastructure. With a strong foundation in SQL, data migration, and backup/recovery procedures, coupled with a proven track record of improving database performance and ensuring data integrity.

Professional Summary

Over 15 years of experience building data lakes and Enterprise Data Warehouses (EDW) using Spark-based Hadoop and RDBMS applications in the healthcare industry.

Spearheaded the design and implementation of a robust database architecture, enhancing data integrity, availability, and scalability across the organization, supporting a 40% growth in data volume without compromising performance.

Led the migration of legacy databases to new management systems, including Oracle and Microsoft SQL Server, ensuring seamless data transfer with zero downtime and minimal impact on business operations.

Developed and enforced best practice database management policies and procedures, including backup and recovery strategies, resulting in a 50% reduction in data retrieval times and a significant improvement in disaster recovery capabilities.

Implemented advanced monitoring and tuning techniques to identify and rectify performance bottlenecks, achieving a 30% improvement in database response times and enhancing user satisfaction.

Collaborated with cross-functional teams to understand data needs, leading to the development of customized database solutions that improved data analysis capabilities and supported strategic decision-making.

Conducted regular security audits and vulnerability assessments, implementing robust security measures that resulted in a 100% compliance rate with industry standards and regulations, such as HIPAA.

Automated routine database maintenance tasks, reducing manual intervention by 60% and allowing the DBA team to focus on strategic initiatives and innovation.

Actively participated in the planning and execution of IT infrastructure projects, ensuring database compatibility and performance were maintained at optimal levels during system upgrades and expansions.

Provided critical support during emergency situations, including data recovery and system restorations, minimizing data loss and ensuring business continuity with minimal disruption.

Extensive experience developing data pipelines for on-premises and cloud environments.

Expert in designing, developing, and maintaining data warehouse applications, with a strong focus on database and query performance tuning.

Agile methodologies expert (Scrum, Kanban) with a proven track record including 4+ years as a Scrum Master. Proficient in using Jira for issue tracking and Agile planning.

Excellent communication, collaboration, and leadership skills, complemented by volunteer experience as a Board Member at Beloved Archives.

Skills

Scala, pyspark, Hive, SQL, Python, Java, Bash Shell Script and Linux/Unix Tools

Big Data: Apache Spark, Scala and HDFS

DBMS: Oracle, MS SQL Server, MySQL, MongoDB

Cloud Platform: AWS, In-House Cloud

Project Management: Scaled Scrum Master, Jira

Scrum and Agile methodologies

Problem-solving and conflict resolution

Coaching and mentoring

Business Applications: DW Applications for Medicare, Medicaid and Commercial Healthcare

Certifications:

Professional Experience

01/2023-Current LVS Group Remote

Lead DBA

Database Management & Performance Tuning:

Oversaw the maintenance and administration of databases in MS SQL Server, MySQL, and Oracle environments.

Implemented performance tuning techniques, indexing strategies, and partitioning to improve query performance, leading to a 25% reduction in query response times.

Coordinated the successful migration of databases from older versions to the latest releases, resulting in enhanced performance and new feature utilization.

Security & Compliance:

Implemented advanced security measures such as Transparent Data Encryption (TDE) and Always Encrypted for sensitive data protection.

Collaborated with the compliance team to ensure all database operations adhered to GDPR, CCPA, and other regulatory requirements.

Capacity Planning & Scalability:

Forecasted database growth and proactively scaled resources, ensuring seamless operations even during peak loads.

Cross-Functional Collaboration:

Acted as the primary liaison between the IT department and business units, ensuring optimal performance and addressing specific data needs.

Trained junior DBAs and mentored them in best practices, raising the team’s overall efficiency by 15%.

Monitoring & Troubleshooting:

Set up alerts and monitors using tools such as SQL Server Profiler and Oracle Enterprise Manager, ensuring 99.98% database uptime.

Addressed critical incidents, minimizing service interruptions and consistently meeting SLAs.

Documentation & Process Improvement:

Created comprehensive documentation detailing database architectures, processes, and best practices.

Introduced automation scripts that reduced manual intervention in routine tasks by 30%.

High Availability & Load Balancing:

Implemented clustering, mirroring, and replication solutions to ensure data availability and load distribution across servers.

05/2018-09/2022 SS&C Health Remote

Scrum Master/Lead Data Engineer

Led the migration of a decade's worth of patient data into both Redshift and MongoDB, enhancing accessibility and improving query speeds by 60%.

Designed real-time ETL processes for Redshift and established real-time data sync for MongoDB, integrating data from 20+ healthcare providers and reducing integration times by 40%.

Optimized queries for electronic health records in Redshift, while also enhancing MongoDB collections' performance, expediting critical report generation.

Unified 5TB of diverse health datasets in both Redshift and MongoDB, laying the groundwork for multi-faceted research on patient outcomes.

Enabled genomic queries on 15TB+ data in S3 through Redshift and structured genetic data storage in MongoDB, accelerating medical research initiatives.

Maintained rigorous data security in both Redshift and MongoDB environments, achieving 99.999% uptime and stringent compliance with HIPAA and GDPR.

Expertly managed resources in both Redshift and MongoDB, cutting costs by 30%, even with a 20% increase in patient data volume.

Seamlessly integrated Redshift and MongoDB with BI tools, empowering 100+ researchers to access diverse datasets and enhance patient care.

Collaborated with clinicians and data scientists, leveraging both Redshift and MongoDB to co-develop an AI tool that reduced hospital readmissions by 25%.

Collaborated with Product Owner to prioritize and maintain product backlog in Jira, ensuring alignment with project goals and stakeholder requirements.

Integrated Apache Spark into traditional ETL, accelerating the extraction, transformation and loading of structured and unstructured data. Reduced run time.

Performed Oracle Database administration and developed DB application using PL/SQL. Developed packages and stored procedures. Implemented security controls around data access and storage to minimize the risk of a data breach.

Ingested data from data sources using a combination of Spark SQL, Scala and Hive to create data views to be used in BI tools, saved $500K/year.

Mentored 4 junior team members with code and design reviews, enforcing coding standards and best practices.

Developed shell scripts on Unix/Linux. Extensively used Linux/Unix commands.

Developed Perl to Python Conversion Project – Developed regular expression-based programs to automatically convert Perl to Python and tested successfully.

Utilized Azure Data Factory to design, develop, and deploy scalable data pipelines for integrating disparate data sources, enabling efficient data movement and transformation. Leveraged scheduling and monitoring capabilities to automate and optimize ETL processes, resulting in improved data quality and reduced processing time.

02/2006-04/2018 DST Health Solutions Remote

Lead DBA

Designed and implemented data pipeline architecture for major clients which gained processing speed by 150%.

Performed Oracle Database administration and developed DB application using PL/SQL. Developed packages and stored procedures. Implemented security controls around data access and storage to minimize the risk of a data breach.

Worked closely with teams across the company to identify and solve business challenges utilizing large structured and unstructured data in a distributed processing environment; led to $100K/year of new revenue.

Led 10 data extraction, warehousing and analytics initiatives that reduced operating costs by 20% and created customized programming options.

Developed proof of concept used in requirements gathering as Subject Matter Expert (SME) for company-wide data migration activities. Reduced time to completion by 8 weeks.

03/2005-01/2006 CSC (Computer Sciences Corp) Health Solutions Southfield, MI

Technical Consultant/DBA

Installed and administered Oracle and MS SQL RDBMS

Tuned, optimized kernel and database parameters. Tuned sql statements to access healthcare data, which increased application performance by 40%.

Designed and developed basic ETL that ingested Medicare/Medicaid data from different sources with $500K transactions on daily basis

Developed and tested PL/SQL stored procedures and SQL functions for ETL processing including staging and target processing from 10 sources.

Worked closely with quality assurance analyst and business analysts.

Developed reusable scripts for data wrangling which improved processes by 10%.

Volunteer Experience

Board Member Beloved Archives, Hamilton, NJ July 2022 - February 2023

Actively participated in board meetings, providing valuable input and guidance on organizational strategy, operations, and fundraising initiatives.

Contributed to the planning and execution of events, campaigns, and community outreach efforts to raise awareness and support for Beloved Archives.

Education

MASTER’S IN COMPUTER SCIENCE Hyderabad, India

JNT University

Citizenship US Citizen

References Available upon request.

Certified SAFe® 5 Scrum Master

AWS Cloud Practitioner Certification

Oracle Certified DBA

Contact this candidate