VIDUSHA GADDIPATI

• Analyzing on-premises database environments such as PostgreSQL ,MS SQL Server and other Commercial DB Engines On-PREM to migrate to cloud open Source Engines like Aurora PostgreSQL/MySQL,RedShift, DynamoDB and EC2 instances
• Performing homogenous and heterogenous database migrations using migration tools like DMS,SCT.
• Developing scripts to automate database migrations and schema conversions
• Working on complex code conversions written in TSQL and PG/PLSQL for target database compatibility during migrations.
• Analyzing complex distributed production deployments, and making recommendations to optimize performance and troubleshoot issues
• Working closely with AWS Platform Service Engineering and Architecture teams to help ensure success of project consulting engagements with customer
• Working directly with customers technical resources to devise and recommend migration solutions based on requirements

Environment - AWS,MSSQL 2008/2012/2014/2016/2019, PostgreSQL 9.5/10.6/11/12/13/14/15, PgAdmin, PGPSQL, SSMS,SSIS,Cloudwatch, EC2,GitLab,Python,CodeCommit, Lambda, Power shell, AWS Step Functions, AWS cloud formation, pg_tap, AWS SCT, AWS DMS

• Working as MSSQL/PostgreSQL Database Administrator in fast paced Agile Environment supporting 30+ business critical applications.
• Architected all aspects of MSSQL and PostgreSQL databases throughout Software Development Life Cycle.
• Collaborated with business users, development teams, and operation engineering teams to tackle business requirements and deliver against high operational standards of database reliability and security.
• Modernized data platform by migrating Postgres databases from legacy on-prem linux instances to AWS/RDS and involved in converting and migrating legacy application from MSSQL to PostgreSQL RDS and EC2 instances
• Installing, Managing and setting up MSSQL databases on EC2 instances
• Implemented high availability solutions like multi-node clustering on PostgreSQL EC2, availability groups in MSSQL, transactional replication and implemented Point in time Backup and Recovery Plans of all mission critical databases ensuring continuous 24X7 operation.
• Assessing, developing, implementing and sustaining Disaster Recovery plans and procedures.
• Worked with Production Engineering and development teams to review and deploy changes to production environment, advise on datastore availability and scalability policies and best practices.
• Implemented multi cloud solutions. Working with data analytics team setting up data transfer from RDS to GCP BigQuery using fivetran and help building machine learning data models using Dataiku.
• Provided production support to Tableau users and wrote custom SQL to support business requirements
• Troubleshooting and debugging issues. Performance tuning of queries there by increasing responsive time of historical queries on platform by 30%, improved time of EOD reports generation, and database maintenance part by 90% during nightly application maintenance
• Ability to think critically about solutions, and debate the merits of different approaches with team members.
• High attention to detail,organization, team-orientation and an ability to work under tight deadlines
• Created and maintained run books for documentation and training purposes.
• Created and deployed CICD pipelines using jenkins

Environment - AWS,GCP/BigQuery,MSSQL 2008/2012/2014/2016, PostgreSQL 9.5/10.6/11/12/13,PgAdmin,SSMS,SSIS,Cloudwatch, AWS EC2,Humio,Jenkins,GitHub,Kubernetes, Nagios, DBT,Fivetran,NoSQL,Tableau Desktop,Tableau Server

• Working as Lead DBA in fast paced Agile Environment supporting multiple business critical applications.
• Architected all aspects of MSSQL and PostgreSQL databases throughout Software Development Life Cycle.
• Modernized data platform by migrating Postgres databases from legacy on-prem linux instances to AWS/RDS and involved in converting and migrating legacy application from MSSQL to PostgreSQL in cloud.
• Implemented high availability solutions like multi-node clustering in PostgreSQL, availability groups in MSSQL, transactional replication and implemented Point in time Backup and Recovery Plans of all mission critical databases ensuring continuous 24X7 operation.
• Assessing, developing, implementing and sustaining Disaster Recovery plans and procedures.
• Excellent verbal, visual and written communication skills, especially an ability to simplify sophisticated data into useful insights
• Modified existing databases to meet unique needs and goals determined during initial evaluation and planning process.
• Created and implemented database designs and data models.
• Created scripts and processes for data integration and maintenance.

• Design and develop specifications for database requirements including enhancements, upgrades and capacity planning.
• Created and maintained SQL server instances in 24/7 environment achieving 99.9% availability.
• Migrated database from SQL Server 2008 to SQL Server 2012
• Ensure database availability in multiple environments, monitored performance using SQL Monitor and SQL Server Profiler.
• Established database deployments workflow to production using SSDT tools.
• Developing SSIS packages to export data from OLTP database to OLAP database.
• Administered, supported and monitored databases by proactively resolving database issues and maintaining servers.
• Set up and controlled user profiles and access levels for each database segment to protect important data.

Environment - MSSQL 2008/2012, Visual Studio 2013, SSDT, SSIS

• Design and develop specifications for database requirements including enhancements, upgrades and capacity planning.
• Created and maintained SQL server instances in a 24/7 environment achieving 99.9% availability.
• Migrated database from SQL Server 2008 to SQL Server 2012
• Ensure database availability in multiple environments, monitored performance using SQL Monitor and SQL Server Profiler.
• Established database deployments workflow to production using SSDT tools.
• Developing SSIS packages to export data from OLTP database to OLAP database.

Environment - MSSQL 2008/2012, Visual Studio 2013, SSDT, SSIS