Yashwanth Reddy Nukala

Projects: Loan Origination System, Loan management system, MDM, CMS

• Developed and implemented data models, database designs, data access and table maintenance codes using DataVault 2.0 model.
• Analyzed user requirements, designed and developed ETL processes(AWS Glue, python, pyspark) to load enterprise data into the Data Warehouse snowflake.
• Developed Python scripts for extracting data from web services API's(API gateway, kinesis) and loading into databases.
• Implemented best practices for database architecture design and development processes.
• Optimized queries for maximum efficiency and scalability in a production environment.
• Monitored system performance and identified areas of improvement or potential issues.
• Performed database security management including user access control and privilege assignment.
• Collaborated with other teams to understand their requirements and deliver solutions accordingly.
• Integrated multiple heterogeneous sources into one unified source via ETL processes.
• Migrated all the ETL jobs from legacy Talend software to Aws Glue.
• Cleaned and manipulated raw data(DBT).
• Recommended data analysis tools to address business issues.
• Managed team of 8 Data engineers and guiding them with assistance on various problem statements.

• Databases: Aurora mysql, postgresql, mssql
• Managed multiple databases running on different platforms like Linux and UNIX systems.
• Migrated existing databases from one platform to another with minimal downtime.
• Participated in capacity planning initiatives to forecast future resource needs based on current trends.
• Coordinated with other teams such as network administrators and system admins for resolving complex issues.
• Configured user accounts, privileges, roles, profiles. in the database server.
• Resolved customer queries related to database issues promptly and accurately.
• Deployed patches and upgrades on a timely basis to keep up-to-date with latest software releases.
• Performed regular health checks on all databases to ensure optimal performance levels are maintained.
• Developed scripts for automating routine maintenance tasks such as index rebuilds and statistics updates.
• Assisted in disaster recovery planning by testing various backup strategies and scenarios.
• Monitored performance of queries and tuned them as needed using Explain Plan tool.
• Developed and implemented database security measures to ensure data protection.
• Performed version upgrade of mysql 5.7 to mysql 8.0
• Defined database design specifications based upon project requirements.
• Implemented RBAC access policy across organization for all the database systems(mysql, postgresql, snowflake).

• Databases: mysql RDS, mariadb, mssql
• Implemented data replication between two different databases (mysql & mariadb)
• Created new tablespaces for applications to store their data in the database.
• Performed daily backups of the databases.
• Resolved customer queries related to database issues promptly and accurately.
• Conducted training sessions for junior DBAs regarding best practices related to database administration.
• Ensured that all the stored procedures are optimized for better performance of the system.
• Consulted with internal departments to identify customer needs to include in project objectives.
• Communicated with data architects, programmers and engineers to keep projects on track.
• Worked with software vendors to analyze and resolve software installation and ongoing support issues.
• Developed and implemented security initiatives to protect important company data.
• Coordinated security compliance and audit preparation with cyber security team.
• Optimized queries for efficient data retrieval and analysis.
• Managed user access, ensuring proper security measures.

• Databases: mysql, mongodb, neo4j
• Performed daily backups of the databases.
• Script to Create and remove of replica readers based up on load on the database
• Migration and version upgrade of mysql from onpremisses to aws cloud
• Analyzed system logs regularly to identify any potential problems or suspicious activities.
• Analyzed and developed technical and functional specifications for databases.
• Implemented database backup and recovery strategies.
• Managed user access, ensuring proper security measures.
• Provided technical support and training to end-users as needed.
• Evaluated emerging technologies to improve current systems.
• Reviewed system logs to proactively identify potential issues.
• Created data dictionary for all the tables in database

• Databases: Oracle 11g, mysql
• Created and monitored performance metrics to keep databases functioning at optimal capacity.
• Established security controls to help protect client systems.
• Implemented database backup and recovery strategies.
• Managed user access, ensuring proper security measures.
• Reviewed system logs to proactively identify potential issues.
• Streamlined data management processes across departments.