ตัวอย่าง Resume นักพัฒนา SQL (SQL Developer) ฉบับที่ 244
Resume Example SQL Developer #0244 ประมาณ 1850 คำ
เรซูเม่ฉบับนี้เป็นตัวอย่างสำหรับตำแหน่ง Sr. PL/SQL Developer ระดับมืออาชีพ มีประสบการณ์รวมประมาณ 12 ปี เรานำมาวิเคราะห์เพื่อให้เห็นว่า โครงสร้างมีจุดเด่นอย่างไร และส่วนใดนำไปปรับใช้กับข้อมูลของคุณได้
จุดเด่นของฉบับนี้ แสดงประสบการณ์ทำงาน 12 ตำแหน่ง พร้อมหน้าที่และผลงานของแต่ละช่วงอย่างเป็นลำดับ
สิ่งที่ควรสังเกตในตัวอย่างนี้
- ประวัติงานต่อเนื่อง 12 ปี เห็นการเติบโตของตำแหน่งได้ชัด
- มีการกล่าวถึง SAP ซึ่งเป็นสิ่งที่ HR สายนักพัฒนา SQL ให้ความสำคัญ
- ประสบการณ์ 12 ตำแหน่ง ไล่ระดับจาก Junior ขึ้นไปจนถึงตำแหน่งปัจจุบัน
- Professional Summary กระชับ ใช้คำที่สื่อความสามารถได้จริง
- มีทักษะแยกเป็นหมวด 40+ รายการ ให้ HR เห็นสเปกครบถ้วน
Professional Summary
12+ years of programming experience as an Oracle PL/SQL Developer in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS). Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines. Experience with Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modeling and design techniques. Expertise in Client-Server application development using Oracle 12c/11g/10g/91/8i, PL/SQL, SQL PLUS, TOAD and SQL LOADER. Effectively made use Table Functions, Indexes, Table made use of Table Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-Write and Transportable table spaces. Strong experience in Data warehouse concepts, ETL. Good knowledge on logical and physical Data Modeling using normalizing Techniques. Created Tables, Views, Constraints, Index (B Tree, Bitmap and Function Based). Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL. Developed materialized views for data replication in distributed environments. Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP. Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables. Loaded Data into Oracle Tables using SQL Loader. Partitioned large Tables using range partition technique. Experience with Oracle Supplied Packages such as DBMSSQL, DBMSJOB and UTLFILE. Created Packages and Procedures to automatically drop table indexes and create indexes for the tables. Worked extensively ensively on Ref Cursor, External Tables and Collections. Expertise in Dynamic SQL, Collections and Exception handling. Experience in SQL performance tuning using Cost-Based Optimization (CBO). Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes. Experience with Performance Tuning for Oracle RDBMS using Explain Plan and HINTS. Experience in ETL techniques and Analysis and Reporting including hands on experience with the Reporting tools such as Cognos. Created Shell Scripts for invoking SQL scripts and scheduled them using crontab. Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.
Experience
Sr. PL/SQL Developer11/2022 - Current
State Street Bank
- Coordinated with the front-end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data
Worked on SQL
- Loader to load data from flat files obtained from various facilities every day
- Created and modified several UNIX shell Scripts according to the changing needs of the project and client requirements
- Wrote Unix Shell Scripts to process the files on daily basis like renaming the file, extracting date from the file, unzipping the file and remove the junk characters from the file before loading them into the base tables
- Involved in the continuous enhancements and fixing of production problems
- Generated server-side PL/SQL scripts for data manipulation and validation and materialized views for remote instances
- Developed PL/SQL triggers and master tables for automatic creation of primary keys
- Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart
- Created scripts to create new tables, views, queries for new enhancement in the application using TOAD
- Created indexes on the tables for faster retrieval of the data to enhance database performance Involved in data loading using PL/SQL and SQL
- Loader calling UNIX scripts to download and manipulate files
- Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL
TRACE, TKPROF and AUTOTRACE
- Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan plan
- Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines
- Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTLFILE package
- Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL
Plus / Plus
- Partitioned the fact tables and materialized views to enhance the performance
- Extensively used bulk collection in PL/SQL objects for improving the performing
- Created records, tables, collections (nested tables and arrays) for improving Query performance by reducing context switching
- Used Pragma Autonomous Transaction to avoid mutating problem in database trigger
- Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL SOL
- Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application
- Analyze and understand system requirements, business rules, functional and non-functional requirements
- Design and develop Informatica ETL mappings, sessions and workflows as per system requirement document
- Create SQL and PLSQL scripts for oracle and Teradata databases as per system requirement document
- Develop Unix shell scripts, Teradata BTEQ scripts, configuration files and parameter files Environment: Oracle 19c, SQL
Plus, TOAD, SQL / Loader, SQL Developer, Shell Scripts, UNIX, Windows XP. / Specialist DB DeveloperSTATE 12/2018 - 11/2022
BNY MELLON
- Coordinated with the front-end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data
Worked on SQL
- Loader to load data from flat files obtained from various facilities every day
- Created and modified several UNIX shell Scripts according to the changing needs of the project and client requirements
- Wrote Unix Shell Scripts to process the files on daily basis like renaming the file, extracting date from the file, unzipping the file and remove the junk characters from the file before loading them into the base tables
- Involved in the continuous enhancements and fixing of production problems
- Generated server-side PL/SQL scripts for data manipulation and validation and materialized views for remote instances
- Developed PL/SQL triggers and master tables for automatic creation of primary keys
- Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart
- Created scripts to create new tables, views, queries for new enhancement in the application using TOAD
- Created indexes on the tables for faster retrieval of the data to enhance database performance Involved in data loading using PL/SQL and SQL
- Loader calling UNIX scripts to download and manipulate files
- Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL
TRACE, TKPROF and AUTOTRACE
- Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan
- Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines
- Analyze and understand system requirements, business rules, functional and non-functional requirements
- Design and develop Informatica ETL mappings, sessions and workflows as per system requirement document document
- Create SQL and PLSQL scripts for oracle and Teradata databases as per system requirement document
- Develop Unix shell scripts, Teradata BTEQ scripts, configuration files and parameter files
- Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTLFILE package
- Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL
Plus
- Partitioned the fact tables and materialized views to enhance the performance Extensively used bulk collection in PL/SQL objects for improving the performing
- Created records, tables, collections (nested tables and arrays) for improving Query performance by reducing context switching
- Used Pragma Autonomous Transaction to avoid mutating problem in database trigger
- Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic
SQL
- Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application
Plus, TOAD, SQL / Environment: Oracle 19c, SQL / Loader, SQL Developer, Shell Scripts, UNIX, Windows XP / Project Lead developer
BNY Mellon Private LimitedMar
- Developed Advance PL/SQL packages, procedures, triggers, functions, Indexes and Collections to implement business logic using SQL Navigator
- Generated server-side PL/SQL scripts for data manipulation and validation and materialized views for remote instances
Created
- I management analysis reporting using Parallel Queries, Java stored procedure, HTP
Package and WEB.SHOWDOCUMENT
- Participated in change and code reviews to understand the testing needs of the change components Worked on troubleshooting defects in timely manner
Education
- SV University · Tirupathi, India. 06/2005
- Bachelor of Science: Mathematics, Statistics And Computer Science
Skills
TECHNICAL SKILLS DatabasesPL/SQLStored ProceduresTriggers)TeradataSAP Tables and MS Access. Oracle Toolsetc.FTL ToolsSQLOperating SystemsUNIX (Sun SolarisLINUXHPUNIAUNIXAIX)Data ModelingLanguages/UtilitiesUnix shellscriptsXMLOther ToolsAutoSysControl-MPVCSWINCVSInformatica Data QualityTPumpFast LoadBTEQPerformance ImprovementsPerforData WarehousingRDMS Development and SQLAgile DevelopmentMethodologiesTesting and DeploymentDatabase DevelopmentDocumentation Management
สรุปว่าจะได้อะไรจากตัวอย่างนี้
ตัวอย่างนี้ช่วยให้เห็นแนวทางการเขียนเรซูเม่สำหรับตำแหน่ง Sr. PL/SQL Developer ประสบการณ์ 12 ปี โดยเปิดด้วยบทสรุปที่บอกจุดเด่นของผู้สมัคร ตามด้วยประสบการณ์ทำงาน 12 ตำแหน่ง และข้อมูลการศึกษาที่จำเป็น พร้อมทักษะที่เกี่ยวข้องกับงาน คุณสามารถนำลำดับและวิธีนำเสนอไปปรับใช้ โดยเปลี่ยนรายละเอียดให้ตรงกับประสบการณ์จริงของคุณ
อย่างไรก็ตาม เรซูเม่ที่ชนะต้องเขียนให้ตรงตำแหน่งที่คุณสมัครโดยเฉพาะ ตัวอย่างนี้คือต้นแบบ ไม่ใช่สำเนา ทีมเรซูเม่ของเรารับเขียน Resume และ Cover Letter ภาษาอังกฤษให้โดดเด่นจากคู่แข่ง ส่งงานใน 2 วัน รับประกันความพึงพอใจ