As a Senior SQL Developer, you will develop ORACLE SQL complex queries, stored procedures, implementing views, functions, jobs and managing transactions. create custom reports to enhance organizational productivity. You will also be responsible for designing databases and ensuring their stability, reliability, and performance.
Job Description:
- MUST have 4+ years of Oracle SQL developer Position.
- Valuable exposure in writing PLSQL/SQL, AWS RDS.
- Develop high-quality database solutions.
- Use T-SQL to develop and implement procedures and functions, writing complex queries.
- Involve in creating and managing tables, indexes, DB links and privileges.
- Review and interpret ongoing business report requirements.
- Must be aware on MetaBase tool.
- Build appropriate and useful reporting deliverables.
- Analyze existing SQL queries for performance improvements.
- Suggest new queries improvement / optimization of queries.
- Develop procedures and scripts for data migration.
- Program databases,
query data and manage data with T SQL.
- Ensure high levels of data availability.
- Database backup and recovery.
- Analyze log files to identify performance issues.
- Should be able to perform SQL profiling
- Schedule jobs to automate different database related activities including backup, monitoring database health, disk space, backup verification.
- Ability to establish best practices and identify gaps to drive process improvements.
- Prior experience in troubleshooting Production failures, specifically working on SLA based delivery in Operations/Support project.
- Hands-on experience in operation management (Dev & Ops team) to ensure project timelines, team productivity and quality of deliverables.
- Provide timely scheduled management reporting.
- Investigate exceptions with regard to asset movements.