ตัวอย่าง Resume นักพัฒนา SQL (SQL Developer) ฉบับที่ 212
Resume Example SQL Developer #0212 ประมาณ 1199 คำ
เรซูเม่ฉบับนี้เป็นตัวอย่างสำหรับตำแหน่ง PL/SQL Developer ระดับมืออาชีพ มีประสบการณ์รวมประมาณ 8 ปี เรานำมาวิเคราะห์เพื่อให้เห็นว่า โครงสร้างมีจุดเด่นอย่างไร และส่วนใดนำไปปรับใช้กับข้อมูลของคุณได้
จุดเด่นของฉบับนี้ แสดงประสบการณ์ทำงาน 5 ตำแหน่ง พร้อมหน้าที่และผลงานของแต่ละช่วงอย่างเป็นลำดับ
สิ่งที่ควรสังเกตในตัวอย่างนี้
- ประวัติงานต่อเนื่อง 8 ปี เห็นการเติบโตของตำแหน่งได้ชัด
- ประสบการณ์ 5 ตำแหน่ง ไล่ระดับจาก Junior ขึ้นไปจนถึงตำแหน่งปัจจุบัน
- Professional Summary กระชับ ใช้คำที่สื่อความสามารถได้จริง
Professional Summary
- 8+ years of programming experience as an Oracle PL/SQL Developer in Analysis, Design and Data Modeling (Logical and Physical). - Development of client/server, multi-tiered applications using the Oracle Relational Database Management System (RDBMS), SQL and PL/ SQL on different platforms like Windows NT/2000/XP, UNIX, and Linux. Well experienced working with Waterfall &Agile Methodologies. Experienced in Tuning Queries for better performance with a large volume of data. - Created technical design for the back end PL/SQL based on business requirement documents and the functional system design. - Creation of database objects like tables, views, synonyms, materialized views, stored procedures, packages using Oracle tools like PL/SQL developer. - Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data. - Involved in updating procedures, functions, triggers, and packages based on the change request. - Built complex queries using SQL and wrote stored procedures using PL/SQL. - Used ref cursors and collections for accessing complex data resulted from joining of a large number of tables. - Involved in moving the data from flat files to staging area tables using SQL loader. - Extensively used for all and bulk collect to fetch large volumes of data from the table. - Performed SQL and PL/SQL tuning and application tuning using various tools like tkprof, autotrace and dbmsSQLtune. Languages: SQL, PL/SQL, UNIX Shell, BASIC, C, C++, HTML.
Experience
PL/SQL Developer01/2022 - Current
Cognizant Technology Solutions
- Developed System using PL/SQL packages, procedures, triggers, functions, Indexes and Collections to Implement business logic using Oracle Developer and toad.
- Designed, developed and maintained data extraction and transformation processes and
- ensured that data is properly loaded and extracted in and out of our systems.
- Investigated data quality issues and implemented appropriate solutions.
- Helped to improve the performance, scalability and stability of database systems.
- Identified and implemented programming enhancements.
- Developed technical system documentation.
- Understanding and Collecting requirements from Business user side or Business Analyst and to Convert that requirement to SQL queries or PL/SQL.
- Convert the business need in to Technical complex queries.
- Use different strategies of database development to meet the client functional requirement.
- Work with SQL and PL/SQL programming, developing complex code.
- Creating PL/SQL packages, procedures, Functions, Triggers, Views and Exception handling
- For retrieving, manipulation, checking and migration complex data sets in Oracle.
- Creating the indexes on tables and partitioning the table for SQL tuning purpose.
- Writing procedures, functions, views, materialized views as required.
- Writing complex SQL queries for reporting purpose.
- Support the users of application with using multiple SQL and PL/SQL techniques
- Support all day to day activities related to database like data consolidation, data
Migration scripting.
- Creating complex views, materialized views on multiple table as per customer Requirement.
- Used PL/SQL Tables, Cursors to process huge volumes of data and used bulk
- Collect for mass update as performance improvement process.
- Migrated data from flat files to tables using SQL*Loader.
- Work with Data migration using import and export user excepting
- Manage unit testing for UAT
PL/SQL Developer08/2018 - 12/2019
Cognizant Technology Solutions
- Involved in creating detailed Documentation, which includes all Business requirements and technical specifications.
- Created data mapping files for the data coming from different web services.
- Worked for designing Logical and Physical data models for staging.
- Knowledge and experience in structured systems analysis and design techniques.
- Developed database objects including tables, clusters, Indexes, views, sequences, packages, triggers and procedures to troubleshoot any database problems.
- Extensively used stored procedures to apply validation logic for the data in staging area to load into catalog Database.
- Used Explain Plan, HINTS for performance tuning of SQL, PL/SQL queries.
- Worked with ETL team and architect to build data model for staging area.
- Worked with business experts to understand the source data in web service systems.
- Prepare the Mapping document which details out the mapping of source to the target data model with application of business rules. - Worked with Financial tools.
- Maintain and manage backup, recovery, storage and user administration using Sybase.
- Execute and handle database objects, views, procedures, indexes and file system structure.
- Supported for code integration and system integration testing for this application.
- Involving creating a test plan by using Unit testing and fix the bugs if any and re test the code.
- Designed and developed multiple CTM jobs to automate the process.
- Execute and handle database objects, views, procedures, indexes and file system structure by using Sybase.
- Expertise in production support.
- Worked with Operations closely and provided the required support.
- Involved in multiple reports creation for operations usage.
- Prepared mitigation scripts in Production to resolve the issue temporarily.
- Analyze the production issues and send the tickets to DEV tracks for code fix.
- Involving creating the python scripts to move the data from one database to another database.
PL/SQL Developer05/2017 - 07/2018
Allied Global Services
- Analyzed and overviewed the database design for better understanding the relations, associations and dependencies within the database. - Data modeling for client specific requirements.
- Developed database objects including tables, clusters, Indexes, views, sequences, packages, triggers and procedures to troubleshoot any database problems.
- Developed complex queries on Data Warehousing and developed PL/SQL procedures to give in nice strategic plans to higher level of management.
- Tuned complex Stored Procedures for faster execution and Developed database structures, according to the requirements in Oracle data warehousing.
- Used Dynamic SQL programming technique to build and process SQL statements "on the fly" at run time.
- Developed PL/SQL scripts for Data cleansing.
SQL Developer03/2010- 02/2015
Bankers Healthcare Group
- Create and maintain database for Server Inventory, Performance Inventory
- Working with SQL, and T-SQL, VBA
- Involved in creating tables, stored procedures, indexes
- Creating and Maintain users
- Creating/Running jobs with packages
- Design, Develop, Deploy Packages with WMI Queries
- Importing Data from various sources like Excel, SQL Server, Frontbase
- Collecting Server Inventory data from users using InfoPath 2003/2007 into SQL Server 2005
- Creating Linked Servers to other databases like Frontbase, and import data
- Using Linked Servers
- Ensuring Data Consistency, Analyzing the Data
- Generate Dash Board Reports for Internal Users using SQL Server 2005 Reporting Services
- Backing up the Database
- Rack/Stack Proliant Servers, installing base operating system
- Deploy various reports on SQL Server 2005 Reporting Server
- Design Reports as of User Requirements
- Involved in migrating servers i.e., physical to virtual, virtual to virtual
- Installing and Configuring SQL Server 2005 on Virtual Machines
- Migrated hundreds of Physical Machines to Virtual Machines
- Conduct System Testing and functionality after virtualization - Monitor the migrated System for next 48 hrs.
Skills
MS AccessMS SQL Server
สรุปว่าจะได้อะไรจากตัวอย่างนี้
ตัวอย่างนี้ช่วยให้เห็นแนวทางการเขียนเรซูเม่สำหรับตำแหน่ง PL/SQL Developer ประสบการณ์ 8 ปี โดยเปิดด้วยบทสรุปที่บอกจุดเด่นของผู้สมัคร ตามด้วยประสบการณ์ทำงาน 5 ตำแหน่ง พร้อมทักษะที่เกี่ยวข้องกับงาน คุณสามารถนำลำดับและวิธีนำเสนอไปปรับใช้ โดยเปลี่ยนรายละเอียดให้ตรงกับประสบการณ์จริงของคุณ
อย่างไรก็ตาม เรซูเม่ที่ชนะต้องเขียนให้ตรงตำแหน่งที่คุณสมัครโดยเฉพาะ ตัวอย่างนี้คือต้นแบบ ไม่ใช่สำเนา ทีมเรซูเม่ของเรารับเขียน Resume และ Cover Letter ภาษาอังกฤษให้โดดเด่นจากคู่แข่ง ส่งงานใน 2 วัน รับประกันความพึงพอใจ