Job Description
Must Have Technical/Functional Skills
We are seeking a highly experienced Oracle PL/SQL Developer with 10+ years of professional experience in designing, developing, tuning, and monitoring Oracle-based systems. The ideal candidate should be proficient in writing complex queries, managing database objects, and optimizing performance using tools like Oracle Enterprise Manager (OEM). A strong background in SQL, PL/SQL, and Java, along with the ability to work on enterprise-level solutions, is essential for this role.
- Must-Have Technical / Functional Skills:
Core Database Skills
- 10+ years of hands-on experience in Oracle Development.
- Expert-level proficiency in SQL and PL/SQL.
- Strong experience in designing database objects such as tables, triggers, procedures, and partitions.
- Ability to write and optimize complex SQL/PLSQL queries for data analysis and processing.
Performance Tuning & Tools
- In-depth knowledge of SQL Tuning, SQL traces, SQLLDR, and other Oracle utilities.
- Hands-on experience with OEM (Oracle Enterprise Manager) for monitoring and performance optimization.
- Familiarity with transaction monitoring and use of third-party tools.
Additional Skills
- Experience with Java and integration of database logic with Java-based applications.
- Strong debugging, troubleshooting, and performance improvement capabilities.
Roles & Responsibilities
- Design, develop, and maintain robust PL/SQL programs, stored procedures, triggers, and packages.
- Work with application teams to integrate database solutions and ensure data accuracy and consistency.
- Tune SQL queries for performance optimization using Oracle tools and best practices.
- Monitor and troubleshoot database performance issues using OEM and other diagnostic tools.
- Participate in database design discussions and ensure proper indexing, partitioning, and storage management.
- Collaborate with QA and DevOps teams to support builds, deployments, and defect resolution.
- Document technical solutions, queries, and procedures for maintainability and compliance.
- Provide production support and proactively monitor database health and performance.
TCS Employee Benefits Summary
Discretionary Annual Incentive.
Comprehensive Medical Coverage: Medical & Health, Dental & Vision, Disability Planning & Insurance, Pet Insurance Plans.
Family Support: Maternal & Parental Leaves.
Insurance Options: Auto & Home Insurance, Identity Theft Protection.
Convenience & Professional Growth: Commuter Benefits & Certification & Training Reimbursement.
Time Off: Vacation, Time Off, Sick Leave & Holidays.
Legal & Financial Assistance: Legal Assistance, 401K Plan, Performance Bonus, College Fund, Student Loan Refinancing.
Salary Range: $100,000-$115,000 a year
Qualifications: BACHELOR OF COMPUTER SCIENCE
US
