ตัวอย่าง Resume นักพัฒนา SQL (SQL Developer) ฉบับที่ 147
Resume Example SQL Developer #0147 ประมาณ 1456 คำ
เรซูเม่ฉบับนี้เป็นตัวอย่างสำหรับตำแหน่ง SQL DBA/Database Administrator ระดับมืออาชีพ มีประสบการณ์รวมประมาณ 7 ปี เรานำมาวิเคราะห์เพื่อให้เห็นว่า โครงสร้างมีจุดเด่นอย่างไร และส่วนใดนำไปปรับใช้กับข้อมูลของคุณได้
จุดเด่นของฉบับนี้ แสดงประสบการณ์ทำงาน 8 ตำแหน่ง พร้อมหน้าที่และผลงานของแต่ละช่วงอย่างเป็นลำดับ
สิ่งที่ควรสังเกตในตัวอย่างนี้
- ประวัติงานต่อเนื่อง 7 ปี เห็นการเติบโตของตำแหน่งได้ชัด
- ประสบการณ์ 8 ตำแหน่ง ไล่ระดับจาก Junior ขึ้นไปจนถึงตำแหน่งปัจจุบัน
- Professional Summary กระชับ ใช้คำที่สื่อความสามารถได้จริง
- มีทักษะแยกเป็นหมวด 23+ รายการ ให้ HR เห็นสเปกครบถ้วน
Professional Summary
A Microsoft Certified SQL Server Database Administrator (DBA) with over five years Of progressive professional working experience in all aspects of SQL Server Databases (2000, 2005, 2008, 200812 and 2012), including installation, configurations, and database high availability solutions (mirroring, log shipping, replication and failover cluster). Proven ability in managing large databases in a 24/7 processing environment including backup/recovery, performance tuning, developing and managing reports using SQL Reporting Services (SSRS), creating
Highlights
- - Database: SQL Server 2012/2008R2/2008/2005/2000, MS Access 2003 & 2000. Experience in production, test, development environments and proficiency of the following: - - SQL Tools: Query Analyzer, Profiler, Query Execution Plan, -Installation, configuration & maintenance of MS SQL Server 2000, Counter. - - Reports Development/Management: SSRS (SQL Server Reporting Services), MS Access, Excel. - - Data Modeling: Toad Data Modeler, ERWin, SSDD (SQL Server Database Diagram). 2005, 2008 and 2012 on standalone and clustered servers [both active/active and active/passive cluster design]. -Applied SP (Service Packs) and hot fixes. -Upgrades of SQL Server 2000, 2005, 2008 and 2012. -Configuration tools such as SQL Server Configuration Manager - Programming: SQL, T-SQL, JOIN, Store Procedures, Trigger, and SQL Server Surface Area Configuration. and Functions. -Security management. - Operating System: Windows Server 2012/2008/R2, 2003/R2, -Data Modeling tools (Data Modeler and Toad). 2000, Vware. - - Hardware/Storage: SAN, RAID. - - Performance Monitoring Tool: Profiler, Execution Plan, PerfMon, Database Tuning Advisor, DMV, Activity Monitor. -Forward and backward engineering. -Database backup, recovery and disaster recovery procedures. -Database High Availability Solutions. -Linked and Remote Servers to run queries between SQL servers and other data sources using ODBC, OLE DB drivers. -Database Monitoring and Performance Tuning. -Online indexing. -Query optimization. -Database consistency checks using DBCC commands. -SQL Server Reporting Services [SSRS]. -Creating and scheduling SSIS/DTS packages in SQL Server to transfer data between various DBMS and files. -Ability to debug SQL Server stored procedures and triggers. -Ability to create and perform alerts, schema management, database reorganization, data loading, database maintenance and optimization.
Experience
SQL DBA/Database Administrator07/2011 - Current
Citi Group
- Installs, Configures, and Manages SQL Server 2005 & 2000 in development, test, and production environments and installs and configures SQL Server 2008 for testing different features and stability backup/recovery. Performs database backup and disaster recovery using point-in-time restoration.
- Performs database high availability and installs, configures and maintains database mirroring including automatic fail-over option in SQL Server 2008. Configures log shipping as standby database from production database for reporting purposes. Performs clustering using SQL Server 2008/2005. Configures and maintains Replication.
- Uses DBCC to check database conditions, fix database corruption, rebuild indexes and other database maintenance functions. Development: Installs, Configures, and administers SQL Server Reporting Services (SSRS). Developed Reports for different purposes like DBA Reports, user reports using SSRS and Report Builder 3.0 as well as deploying reports and managing security of report server.
- Exporting & importing data from Flat file, CSV file to/from SQL Server Database using DTS, SSIS. Exporting& importing data from/to databases like Oracle, My-SQL, and Access to/from SQL. Performing server database upgrades, like SQL Server 2000 to 2005/2008/2008 R2 SQL Server 2005 to SQL Server 2008/2008 R2. Performs database migration, like MS Access 97/2000/2003 databases into MS SQL Server 2000, 2005, and 2008, Oracle databases to SQL Server 2008 R2, My-SQL databases to SQL Server 2005/2008 R2. Conducts data modeling through conceptual, logical, and physical data models. Works on data modeling projects from start to finish, and includes generating scripts for objects, developing relationships between tables, and creating E-R diagrams. Performs backward & forward engineering for logical and physical data models respectively.
- Utilization of tools such as Erwin and SSD. Creation and management of objects, schemas, indexes, and constraints. Application of SP (Service Pack) on SQL Server 2000, 2005, 2008, 2008 R2 and application of patch on Windows Server 2003, 2003 R2. Conducts database monitoring/performance tuning/scheduled jobs to automate different activities such as: monitoring database health, disk space, job, alert, index monitoring, etc.
- Assists database developers to optimize SQL queries, stored procedures, T-SQL and Triggers. Work environment includes: Windows Server 2008 R2, 2003 R2, IIS 7.5, 6.5. SQL Server 2008 R2, 2005. ASP.net, PHP, AD (Active Directory)
SQL DBA/Database Administrato02/2008 - 07/2011
IBM
- Installed, Configured, and Managed SQL Server 2008, 2005 & 2000 in development, test, and production environment. Installed and Configured SQL Server 2008 for testing different features and stability.
- Backup/Recovery: Strong knowledge and working experience in Database Backup and Disaster Recovery experienced with Point-in- Time Recovery. Restored Database from backup
- Database High Availability: Installed, Configured and Maintained Database Mirroring including automatic fail-over option in SQL Server 2008. Configured Log Shipping as Standby database from Production database for reporting purposes. Maintained Fail-Over Clustering using SQL Server 2008/2005. Configured and Maintained Replications
DBCC:
- Used DBCC to check database conditions, fix database corruption, rebuild indexes and other database Maintenance purposes as well Report Development.
- Installed, Configured, and administered SQL Server Reporting Services (SSRS). Developed Reports for different purposes like DBA Reports, user reports using SSRS and Report Builder 3.0 & 2.0.
- Deployed Reports and managed security of report server including folder level.
Database Upgrade:SQL Server 2000 - 2005/2008/2008 R2.
- SQL Server 2005 to SQL Server 2008/2008 R2.
Database Migration:
- MS Access 2003/2000/97 databases into MS SQL Server 2000, 2005, and 2008.
- Oracle 10gR2/11gR2 databases to SQL Server 2008 R2.
- My-SQL 4.1.0/5.0.15 databases to SQL Server 2005 and 2008 R2.
Data Modeling:
- Worked on data modeling projects, generated scripts, and E-R Diagram
- Backward & Forward Engineering for logical and physical model respectively Data Modeling tools used using ERWin, Toad Data Modeler
Created and managed Indexes, Constraints. / Patch Management:
- Applied SP (Service Pack) on SQL Server 2000, 2005, 2008, 2008 R2
- Applied Patch on Windows Server 2003, 2003 R2
Microsoft SQL Server Database Administrator05/2007 - 01/2008
Golden Living Hospital And Health Care Industry
- Installed, Configured, and Managed SQL Server 2005 & 2000 in development, test, and production environment.
- Installed and Configured SQL Server 2008 for testing different features and stability.
- Installed, Configured and Maintained Fail-Over Clustering using SQL Server 2005
- Installed, Configured and Maintained Database Mirroring using automatic fail-over option in SQL Server 2005.
- Configured Log Shipping as Standby database from Production database for Reporting purposes.
- Configured and Maintained Replications (Transactional).
- Installed, Configured, and administered SQL Server Reporting Services (SSRS).Developed Reports using SSRS
- Developed Ad-hoc Reports using Report Builder 3.0, 2.0.
- Upgraded Database (development, testing and production environment) SQL Server 2000 to 2005
- Migrated Database (development, testing and production environment) MS Access 2003/2000/97 databases into MS SQL Server 2000, and 2005 My-SQL 4.1.0/5.0.1 databases to SQL Server 2005.
- Worked on more than 10 data modeling projects and generated E-R Diagram Data Modeling tools used using ERWin, SQL Server Data Diagram.
- Backward & Forward Engineering with data modeling tools mentioned above
- Applied SP (Service Pack) on SQL Server 2000, 2005
- Applied HOT Fixes on SQL Server 2000, 2005
- Applied Patch on Windows Server 2003 Enterprise Edition
- Strong on database Monitoring and Performance tuning
- Scheduled jobs to automate different database related activities including backup
- Monitoring database health, disk space, backup verification
- Monitor SQL Server Error Log, space usage.
- Wrote T-SQL, Trigger, and Stored-Procedures.
- Assisted Database Developers to optimize SQL queries and Stored Procedures
- Export & Import data from Flat file, CSV file to/from SQL Server Database using DTS, SSIS, and BCP
- Export & Import data from/to databases like Oracle, My-SQL, and Access to/from SQL Server
- Strong knowledge and working experience in Database Backup and Disaster Recovery
- Experienced with Point-in-Time Recovery. Restored Database from backup.
Education
- Bachelor of Computer Science: Computer Science, 2006
- Kabul University - Kabul · and Maintenance
Skills
Active DirectoryAutomationBackupClusteringHardwareData ModelingDTSDatabase AdministrationDisaster RecoveryIISAccessMS AccessMicrosoft OfficeWindows Operating SystemsWindows (XPVistaOptimization.TSQLRAIDSANUpgradeWeb ApplicationsWeb Server
สรุปว่าจะได้อะไรจากตัวอย่างนี้
ตัวอย่างนี้ช่วยให้เห็นแนวทางการเขียนเรซูเม่สำหรับตำแหน่ง SQL DBA/Database Administrator ประสบการณ์ 7 ปี โดยเปิดด้วยบทสรุปที่บอกจุดเด่นของผู้สมัคร ตามด้วยประสบการณ์ทำงาน 8 ตำแหน่ง และข้อมูลการศึกษาที่จำเป็น พร้อมทักษะที่เกี่ยวข้องกับงาน คุณสามารถนำลำดับและวิธีนำเสนอไปปรับใช้ โดยเปลี่ยนรายละเอียดให้ตรงกับประสบการณ์จริงของคุณ
อย่างไรก็ตาม เรซูเม่ที่ชนะต้องเขียนให้ตรงตำแหน่งที่คุณสมัครโดยเฉพาะ ตัวอย่างนี้คือต้นแบบ ไม่ใช่สำเนา ทีมเรซูเม่ของเรารับเขียน Resume และ Cover Letter ภาษาอังกฤษให้โดดเด่นจากคู่แข่ง ส่งงานใน 2 วัน รับประกันความพึงพอใจ