JAY MUDBHARY

Duluth, GA, Phone: 678-***-****, ad49qv@r.postjobfree.com (26) Dhananjay Mudbhary LinkedIn

Years of experience in testing, analysis, design, development, and database management.

RDBMS AND TOOLS

MS SQL Server 2008/2012/2016/2022, ORACLE 10g/11g/12c/21c, SQL developer, SolarWinds Sentry One, SQL, PL/SQL Developer, Putty, SSH, SQL server management studio, Windows PowerShell, DBeaver Universal DB manager for AWS Redshift, PgAdmin for PostgreSQL, Oracle Enterprise Manager, NetBackup, Veeam backup, Postman, Jira, Confluence Etc.

•Experience working within Agile team utilizing Scrum framework.

•Experience in analyzing Business Requirements and Specifications.

•Experience in Manual, System, Regression, and Performance Testing.

•Proficient in using SQL queries to retrieve and test backend data.

•Ability to work effectively independently or as a part of a team.

•Extensive experience testing web applications manually.

•HIPAA (Health Insurance Portability and Accountability Act) Certified.

•Experience using Explain plan for query cost.

•Experience using Active Directory, Service Now, SharePoint, Confluence and Jira.

•AWS Certified Cloud Practitioner.

•Oracle Certified Associate (OCA) on SQL and Database fundamental.

•Working knowledge of SQL server management studio.

•Working knowledge of SQL server database and BI tools.

•Experience working with SQL packages, procedures, functions etc.

•Experience supporting SSIS & SSRS.

•Experience creating DBMS jobs to run periodically.

•Experience using Oracle client to create linked Server on SQL Server.

•SQL server database migrations to SQL Server newer versions.

•Database software installation.

•Experience using Oracle Enterprise Manager.

•Good concept of tablespace creation and management.

•User access and roles creation and maintenance.

•Shell (Bash) scripting knowledge.

WORK HISTORY

Allina Health, Minneapolis, MN (Remote)

System Analyst/ SQL Developer

April 2023 – Present

•Maintenance and support SQL Server & Oracle databases including backups, restores, maintenance plans and stored procedures.

•Monitor nightly SQL jobs to provide extensive amount of files movements support in case of failures by re-running and fixing issues.

•Maintain and update configuration as needed to improve the performance of database servers through optimization.

•Develop and implement best practices to manage data relationships and data integrity.

•Manage database access, security, and auditing for user controls to mitigate security risks.

•SQL server 2012 migration to SQL Server 2022.

•Monitor performance and tuning of database systems.

•Provide SQL Server SSIS & SSRS service by creating new and maintain existing once with constant changes as per business requirements.

•Consult with analysts on application system features and functionality as defined in requirements to configure the application to meet the business requirements and technical function specifications.

•As a subject matter expert, analyze and provide input to business users regarding technical challenges in development and translate into functional requirements.

•Partnership with system-wide IT organization to provide on-call support for purposes of incident and problem management.

•Work with third party vendors in the diagnosis of and application of their products.

•Use postman to get responses to the requests made for RevSpring Payment portal.

Environment: Oracle 21C, MS SQL Server 2016/2022, Windows NT.

Transamerica Individual Solutions, Johns Creek, Georgia Intermediate DBA SQL/Oracle

July 2016 – January 2023

•Maintenance and support of all database backups, restores, SQL jobs, maintenance plans and stored procedures.

•Maintain and update configuration as needed to improve the performance of database servers through optimization.

•Develop and implement best practices to manage data relationships and data integrity.

•Manage database access, auditing for user controls to mitigate security risks.

•Monitor performance and tuning of database systems.

•Install, upgrade, or migrate, and manage database applications.

•Diagnose and troubleshoot database errors and log failures.

•Performed Database Restore, Database Refreshes, Monitoring in regular basis.

•Created Always-On Availability Groups (AAG) and participated during HA/DR Troubleshooting.

•SQL server 2008 migration to SQL Server 2016.

•DB Migration and administration on Cloud Azure DB and AWS RDS.

•Provide securities, configuration, data migration support on SSIS & SSRS to the business.

•Support change migration for Code deployments

•Control and monitor user access, roles, grant, revoke, assign privileges and maintain security.

•Experience with MS Azure AWS Console, EC2, RDS database management

•Performance Tuning, Monitoring (SSMS, Sentry One).

•Work as a part of team to provide 24X7 on call support when required.

Environment: Oracle 12C, MS SQL Server 2008/2012/2016, Oracle Enterprise Manager, Windows NT, UNIX.

Navicure Inc (Present day Waystar), Duluth, Georgia

Quality Assurance Engineer

February 2007– June 2016

•Provide outstanding Quality Assurance work to Navicure web-based application.

•Provide clearinghouse support to thousands of doctor’s offices and billing services.

•Develop Test cases, mapped requirements to test cases and executed end to end testing.

•Execute test cases manually and reported defects using JIRA to communicate with developers.

•Use FileZilla FTP client to test FTP file uplo

•Execute the SQL queries to validate data changes.

•Experience working with EDI ANSI X12 Navicure claim files.

•Test for Functionality, Interface, and Regression testing.

•Run PERL scripts for Electronic Data Integration (EDI) to mass load client data into the application.

•Create automated jobs in test environments for scoreboard refresh and reports.

•Software validation and documentation and Post release Verification.

Environment: Oracle 10g/11g, SQL, PL/SQL, HTML, JavaScript, Perl, Windows NT, UNIX.

EDUCATION:

Master of Business Administration, Brenau University, Atlanta, Georgia.

BS in Chemistry & minor Math, Piedmont College, Demorest, Georgia.

Contact this candidate