Oracle PL/SQL data modeller

Larsen & Toubro - Tampa, FL

Full-time

Tampa, FL

10,001+ employees

Professional, Scientific, and Technical Services

About the position

The Oracle PL/SQL Data Modelling position at LTIMindtree involves designing, developing, and maintaining data models while ensuring adherence to data governance and quality standards. The role requires proficiency in Oracle PL/SQL development, performance tuning, and optimization, as well as collaboration with various stakeholders to meet data requirements. Additionally, the position includes documentation and reporting responsibilities to support business decision-making.

Responsibilities

• Design, develop, and maintain logical and physical data models.
• Create and maintain data dictionaries and metadata repositories.
• Ensure data models adhere to data governance and quality standards.
• Analyze business requirements and translate them into data models and schema designs.
• Develop and optimize PL/SQL procedures, functions, triggers, and packages.
• Write complex SQL queries for data extraction, manipulation, and reporting.
• Perform database performance tuning and query optimization to enhance system performance.
• Identify and resolve bottlenecks and other issues affecting database performance.
• Work closely with application developers, business analysts, and other stakeholders to understand data requirements.
• Provide technical support and troubleshooting for data-related issues.
• Participate in code reviews and ensure adherence to best practices and coding standards.
• Document data models, database designs, and development processes.
• Create reports and dashboards as needed to support business decision-making.
• Maintain up-to-date documentation for ongoing and future reference.

Requirements

• Proficiency in Oracle PL/SQL and SQL.
• Strong experience with data modeling tools (e.g., ERwin, Oracle Data Modeler).
• Proven track record in database performance tuning and optimization.
• Familiarity with database management and data warehousing concepts.
• Excellent analytical and problem-solving skills.
• Strong communication and interpersonal skills.
• Ability to work independently and as part of a team.
• Experience with other database management systems (e.g., SQL Server, MySQL).
• Knowledge of data integration and ETL tools.
• Familiarity with cloud-based databases and technologies.

Benefits

• Comprehensive Medical Plan Covering Medical, Dental, Vision
• Short Term and Long-Term Disability Coverage
• 401(k) Plan with Company match
• Life Insurance
• Vacation Time, Sick Leave, Paid Holidays
• Paid Paternity and Maternity Leave