Job Duties/Responsibilities:
- Design and develop backend (database) solutions in collaboration with the Development Team and Business Process SMEs.
- Analyze user requests and software requirements for design feasibility and potential impact.
- Write and maintain SQL and PL/SQL stored program units/packages.
- Lead the team in database-related security and infrastructure upgrade requirements.
- Maintain database naming and coding standards.
- Participate in code reviews, ensuring compliance with best practices and providing improvement feedback.
- Provide support for problem identification and resolution, including off-shift and weekend support.
- Assist team and customers with documentation, training, and usability efforts.
- Collaborate with System DBAs for overall database performance improvements and efficient data processing.
- Adhere to security directives, implement security concepts, and minimize overall risk.
- Perform programming, project management, and development assignments independently.
- Resolve complex application/technical problems, including off-shift and weekend support.
- Drive database development and support focused on delivering business value.
- Establish good practices and habits to improve data quality.
- Identify and encourage areas for team growth and improvement.
Required Skills:
- Strong understanding of relational databases, preferably Oracle.
- Proficiency in data modeling and data analysis.
- Expertise in Oracle SQL and PL/SQL, including object-oriented analysis and design.
- Experience in creating and maintaining database tables, views, and PL/SQL objects (e.g., Packages, Procedures, Functions).
- Ability to design and implement logical and physical database models, including concepts like indexes, primary keys, foreign keys, and constraints.
- Proficient in fine-tuning SQL queries and improving application performance.
- Familiarity with Oracle development tools such as SQL Plus and SQL Developer for programming and maintenance tasks.