Database Application Developer

MUST HAVE SKILLS (Most Important):MYSQL, Oracle, Database Migration and maintenanceResponsibilities:Database Migration Expertise:Strong understanding of both Oracle and MySQL architectures.Experience with database migration tools (e.g., Oracle SQL Developer, MySQL Workbench, or custom scripts).Knowledge of data modeling and schema conversion between Oracle and MySQL. Proficiency in SQL and PL/SQL for both databases.Familiarity with handling large datasets and minimizing downtime during migration.Ability to resolve compatibility issues, especially around stored procedures, triggers, and views.Expertise in configuring and maintaining MySQL on a Redhat 7/8 environment.Ability to test the connectivity between the PHP application and MySQL database after the migration including troubleshooting thru firewallsExperience in troubleshooting database issues that might arise due to changes in system libraries or configuration.Understanding of optimizing SQL queries for performance in MySQL. Familiarity with index creation and optimization techniques to improve the performance of Python and Bash scripts interacting with the database.Regression testing - Ensuring that the scripts retain their functionality and that no existing operations are broken due to migrationDocumentationDevelop and maintain databases across the organization, while ensuring high levels of data availabilityEvaluate and advise on all technology components, such as software, hardware, and networking capabilities, for database management systems and applicationsDesign and deploy data table structures, forms, reports, and queriesConduct research and make recommendations on database products, services, protocols, and standards in support of procurement and development effortsIdentify inefficiencies in current databases and investigate solutionsDiagnose and resolve database access and performance issuePlan and coordinate data migrations between systemsDevelop, implement, and maintain change control and testing processes for modifications to databasesEnsure all database systems meet business and performance requirementsProduce ad-hoc queries and develop technical documentation to support business needsDESIRED SKILLS:PHP Expertise:-Strong understanding of PHP and its dependencies, including any specific extensions or libraries used by the application.Ability to identify and address compatibility issues between PHP versions and Redhat 8.Proficiency in web server configuration (e.g., Apache or Nginx) to ensure proper integration with PHP post-upgrade.Scripting (Python and Shell):Ability to review and update Python and Shell scripts to ensure they work in the Redhat 8 environment, which may involve updates to libraries or system paths.Familiarity with Python versions and handling any deprecation warnings or updates required for compatibility.Application Testing and Validation:Ability to conduct thorough testing of the web application post-upgrade to ensure that all components (front-end, back-end, scripting) work as expected.Familiarity with RedHat 8