DBA SQL freelance project
Budget: €36 – €0 EUR
- Good knowledge about Oracle and SQL Server.
- Most of the databases are Oracle 19c databases.
- Have good knowledge about TOAD, OEM and SQL Developer.
- He/she should perform database changes requested by the application teams.
- These changes needs to be done on all database in DEV/QA/PRODUCTION
- Advanced working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity Oracle databases.
- Experience performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement.
- Technical expertise with data models, data mining, and segmentation techniques
- Experience designing and writing PL/SQL procedures
- Create new tables in DEV/QA/PRODUCTION
- Delete tables when they are not in use anymore.
- Add columns, Indexes.
- Export/Import data.
- Maintain our data dictionary.
- Create proper SQL scripts to perform the databases changes in DEV/QA and production.
- Support the product teams and advise them which naming to use for the columns tables.
- Update the connection strings for the databases used by the application teams.
- Strong communication skills
- Mandatory skills :- SQL-Oracle DB ,PL/SQL
- Most of the databases are Oracle 19c databases.
- Have good knowledge about TOAD, OEM and SQL Developer.
- He/she should perform database changes requested by the application teams.
- These changes needs to be done on all database in DEV/QA/PRODUCTION
- Advanced working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity Oracle databases.
- Experience performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement.
- Technical expertise with data models, data mining, and segmentation techniques
- Experience designing and writing PL/SQL procedures
- Create new tables in DEV/QA/PRODUCTION
- Delete tables when they are not in use anymore.
- Add columns, Indexes.
- Export/Import data.
- Maintain our data dictionary.
- Create proper SQL scripts to perform the databases changes in DEV/QA and production.
- Support the product teams and advise them which naming to use for the columns tables.
- Update the connection strings for the databases used by the application teams.
- Strong communication skills
- Mandatory skills :- SQL-Oracle DB ,PL/SQL