Dear Seniors,
Based on your experience pls let me know if the below roles and responsibilities look good for 2172 NOC.
• Gathering user requirement specifications.
• Performing feasibility study and suggesting the software, hardware and skill requirements for the project.
• Preparing functional and detailed technical design documents.
• Designing the database architecture and developing data models.
• Creating and managing tablespaces, datafiles, database links, schemas, tables, indexes, views, synonyms.
• Writing scripts for packages, procedures, functions, triggers, scheduler jobs and PL-SQL code to implement the functionality.
• Creating users, roles, policies and encryption methods to maintain the data security.
• Integrating, testing and modifying the data models and the database systems.
• Doing data cleansing and putting controls in place to avoid bad/junk entering into the system.
• Optimizing the queries, PL-SQL code, gathering statistics and tuning the database for improving the performance of the system
• Educating the reporting and data warehouse professionals about the implemented database management system for better usage for tools.
• Doing research and innovative new ways to enhance system and end users experience.
• Mentor the junior members in the team and co-ordinate with the teams working at various geo-graphical locations on different modules.
• Doing database back-up, recovery, import/export of schemas or tables and handling maintenance activities.
Thanks a lot.