Additional Requirements
> Prior experience with ODI ELT /SSIS ETL of data using flat files/DB2/Salesforce/Oracle NoSQL as source
> Hands-on experience in troubleshooting data issues arising out of the ELT/ETL process.
> Design and develop SQL Server/Oracle stored procedures, functions, views and triggers to be used during the ELT/ETL process
> Strong and hands-on PL/SQL skillset
> Design, implement and maintain database objects (tables, views, indexes, ) and database security
> Proficient with ETL/ELT tools such as Microsoft SSIS/Oracle ODI.
> Analyze and develop strategies and approaches to import and transfer data between source, staging, and ODS/Data Warehouse destinations
> Development experience in Oracle Apex
> Knowledge of database systems, data modeling, and data architecture.
Responsibilities & Context
> Database Design and Planning:
Collaborate with application developers to understand data requirements.
Design, implement, and maintain database structures, tables, and relationships.
> Database Installation and Configuration:
Install and configure database management systems.
Set up and maintain database servers, ensuring proper security and access controls.
> Data Security:
Implement and manage data security measures, including access controls, encryption, and authentication.
Regularly audit database access and take corrective actions as needed.
> Backup and Recovery:
Develop and implement backup and recovery strategies to ensure data integrity.
Perform regular backups and conduct recovery procedures in the event of data loss or system failures.
> Performance Monitoring and Tuning:
Monitor database performance and identify areas for improvement.
Optimize query performance and conduct tuning activities to enhance
Overall system efficiency.
> Database Maintenance:
Apply patches and updates to the database management system.
Conduct routine maintenance tasks, such as index rebuilding and database reorganization.
> Troubleshooting:
Investigate and resolve database-related issues, such as connectivity problems and performance bottlenecks.
> Collaboration:
Work closely with developers, system administrators, and other IT staff to ensure smooth integration of the database with other systems.
Familiarity with specific database management systems (e.g., Oracle, MySQL, SQL Server).
> Technical Skills:
Proficiency in SQL and database query optimization.
Knowledge of database design principles and normalization.
> Security Awareness:
Understanding of database security best practices and the ability to implement security measures.
