Oracle PL/SQL Developer & Database Developer Resume – 2.5+ Years Experience | SQL Performance Tuning, Backup & Recovery, UNIX Scripting

Oracle PL/SQL Developer & Database Developer Resume – 2.5+ Years Experience | SQL Performance Tuning, Backup & Recovery, UNIX Scripting

A results-driven Oracle PL/SQL Developer and Database Developer with 2.5+ years of experience in backend development, database design, SQL query optimization, database administration, and performance tuning. Proven expertise in Oracle PL/SQL programming, stored procedure development, table partitioning, indexing strategies, database backup & recovery, and materialized views to deliver scalable, high-performance solutions. Skilled in event management systems including exhibitor registration, booth allocation, scheduling, and reporting. Adept at automation scripting in UNIX/Linux, Agile (Scrum) methodologies, and managing multi-terabyte databases. Holds a Snowflake Certified Professional (2025) credential with strong cross-platform data handling skills.

Core Competencies:

• Oracle Database Development (Oracle 11g/10g/9i)

• PL/SQL Programming – Procedures, Functions, Packages, Triggers

• SQL Query Optimization, Performance Tuning, Execution Plan Analysis

• Table Partitioning, Index Organized Tables, Materialized Views

• Bulk Collect, Bind Variables, Dynamic SQL, Ref Cursors

• Data Modeling, Database Design, Transaction Management, Data Integrity

• Database Administration – Backup & Recovery, Security Management, User Privileges, DB Monitoring

• UNIX/Linux Shell Scripting, Process Automation

• Error Handling, Exception Management, Batch Job Optimization

• Agile (Scrum) & Waterfall Project Methodologies

Key Achievements:

• Improved query performance by 40% through SQL tuning, indexing enhancements, and execution plan optimization

• Reduced response time by 20% via database schema redesign and query restructuring

• Lowered CPU usage by 15% by optimizing batch processes and implementing table partitioning

• Automated repetitive tasks with UNIX shell scripts, saving approximately 10 hours per week

• Designed partitioned tables and materialized views for datasets exceeding 2TB

Technical Skills:

Databases:

• Oracle 11g/10g/9i, Snowflake, Ingres

Languages:

• SQL, PL/SQL, UNIX Shell Scripting

Performance Tools:

• TKPROF, AUTOTRACE, EXPLAIN PLAN, SQL Trace

Development Tools:

• Toad, SQL Developer, PgAdmin, WinSCP, FileZilla, Nexus Terminal

Database Administration:

• Backup & Recovery, Security Management, User Privileges, DB Monitoring

Operating Systems:

• UNIX, Solaris, Red Hat Linux, Windows

Methodologies:

• Agile (Scrum), Waterfall

Certifications:

• Snowflake Certified Professional (Feb 2025 – Jul 2025)

Soft Skills:

• Problem-Solving & Analytical Thinking

• Cross-Functional Collaboration

• Time Management

• Client Communication

• Adaptability

• Continuous Learning

Professional Experience & Key Responsibilities:

Associate Database Developer (Backend Developer) – Event Management Domain (Trade Show Management System)

• Designed and implemented database schemas, table partitioning, index-organized tables, and materialized views to improve query performance and scalability

• Developed and maintained 100+ PL/SQL components including stored procedures, packages, triggers, and dynamic SQL scripts for large-scale event data processing

• Performed SQL performance tuning using Oracle Hints, EXPLAIN PLAN, SQL Trace, TKPROF, and AUTOTRACE on high-volume transactional datasets

• Managed CLOB/BLOB data types ensuring performance for large-scale applications

• Implemented bulk collect and bind variables to enhance execution speed and reduce memory consumption

• Automated data loading, backup, and monitoring using UNIX shell scripts

• Collaborated in Agile (Scrum) sprints to deliver features ahead of schedule

• Tools Used: Toad, SQL Developer | OS: UNIX, Solaris, Linux, Windows

Education:

• Master of Computer Applications (MCA)

Ideal For:

• Full-time Oracle PL/SQL Developer / Database Developer roles

• SQL performance tuning and database optimization projects

• Event management and trade show systems

• Database administration and backup/recovery

• Remote or Trichy/Tamil Nadu-based opportunities

Important Notice : Candidate personal contact details including name, phone number, and email address are hidden for privacy and security reasons. Resume is strictly intended for legal hiring and recruitment purposes only. Any misuse, fraud, spam, illegal activity, or unauthorized distribution is strictly prohibited. Digital product only. No physical item will be shipped.