ตัวอย่าง Resume นักพัฒนา SQL (SQL Developer) ฉบับที่ 116
Resume Example SQL Developer #0116 ประมาณ 1635 คำ
เรซูเม่ฉบับนี้เป็นตัวอย่างสำหรับตำแหน่ง SQL SERVER DBA มีประสบการณ์รวมประมาณ 6 ปี เรานำมาวิเคราะห์เพื่อให้เห็นว่า โครงสร้างมีจุดเด่นอย่างไร และส่วนใดนำไปปรับใช้กับข้อมูลของคุณได้
จุดเด่นของฉบับนี้ แสดงประสบการณ์ทำงาน 3 ตำแหน่ง พร้อมหน้าที่และผลงานของแต่ละช่วงอย่างเป็นลำดับ
สิ่งที่ควรสังเกตในตัวอย่างนี้
- ประวัติงานต่อเนื่อง 6 ปี เห็นการเติบโตของตำแหน่งได้ชัด
- ประสบการณ์ 3 ตำแหน่ง ไล่ระดับจาก Junior ขึ้นไปจนถึงตำแหน่งปัจจุบัน
- Professional Summary กระชับ ใช้คำที่สื่อความสามารถได้จริง
- มีทักษะแยกเป็นหมวด 35+ รายการ ให้ HR เห็นสเปกครบถ้วน
Professional Summary
- Over 6 years of experience in Database Administration, System Analysis, Design, Development and Support of MS SQL Server 2014/2012/2008 R2/2008/2005 in Production, Test, Development, Replication and Cluster Server Environments. - Expertise in Database Administration on Production Servers with Server Configuration, Performance Tuning and maintenance with outstanding troubleshooting capabilities. - Experience on High Availability/Disaster Recovery (HADR) solutions; Failover Clusters and AlwaysOn Availability Groups, Replication, Log Shipping and Mirroring. - Experienced in Upgrade/Migration of MS SQL Server 2008 to MS SQL Server 2008R2, from SQL Server 2012 and SQL Server - Experience working with application team and implemented databases as per the specification from LOB applications. Experienced in installation, configuration, maintenance and optimization of SQL Server HADR solutions. - Experienced with partially contained databases. - Experienced in Backup and Recovery, Query Optimization and Security. - Experienced in monitoring the health and performance of SQL servers as well as home grown applications using SQL Server native tools and several other third party solutions. - Expert in creating DTS packages to utilize SSIS functionalities and DB dependency resolutions. - Created various SSIS, SSRS and SSAS Packages to serve company needs. - Familiar with PCI Compliance Standards required for Retail Industry. - Expert in using DTA/Extended Events/PerfMon/SQL Profiler/Scripts and other third party tools to resolve bottlenecks, dead locks and slow running queries. - Able to benchmark and load test new instance builds for performance with DB load simulators. - Responsible for securing SQL Server, user management, assigning permissions and roles. - Good Knowledge of LiteSpeed, Diagnostic Manager and Log explorer for MS SQL Server. - Strong System Administration background in Windows and Linux environments. - Experienced with Development/Test/Production QA which included documentation of processes, creation of test scenarios and - Experienced in creating technical documentations and process archiving and change management. - Experienced in working independently as well as in team-oriented environments. - Expert in problem solving, analysis and conflict resolutions. - Experienced in supporting and maintaining large databases and troubleshooting their problems. - Excellent analytical, communication and interpersonal skills.
Experience
Position
- Adept at T-SQL, stored procedures, tables, indexes, views, functions, and triggers.
- execution of tests, via T-SQL scripts, to ensure UI standards met the required specifications.
SQL SERVER DBA01/2016 - Current
- As a production L2 support, we are responsible for resolving incident tickets escalated from L1 support and handling critical incidents(Sev1,Sev2 high).
- Providing SQL Server implementation changes requested from application teams.
- Responsible for installing, configuring, and maintaining as per supported LOB applications.
- Writing and improving SQL Server T-SQL queries.
- Created necessary T-SQL scripts, stored procedures, tables, views, functions, triggers and indexes.
- Responsible for providing SQL Server problem resolution and 24x7 production support and server outages.
- Responsible for disaster recovery and high availability solutions and large scale database migrations from SQL server 2005 to SQL server 2008R2 and 2012.
- Created and migrated partially contained databases within AlwaysOn Availability Groups.
- Created automation of day to day operations, critical SQL server alerts and repetitive tasks.
- Monitored the health and performance of SQL, server instances and home grown applications using Extended Events, SQL server Profiler, PerfMon and other third party tools.
- Tested newly built servers for performance impact with DB load simulators.
- Setup and maintained Log Shipping between various environments.
- Development/Test/Production QA which included documentation of processes, creation of test scenarios and execution of tests
- via T-SQL scripts, to ensure UI standards met the required specifications.
- Created necessary T-SQL scripts, stored procedures, tables, views, functions, triggers and indexes.
- Operated and oversaw database and log backups and restoration, planning backup strategies, and scheduling.
- Backed up master & system databases and restoring them when necessary.
- Optimized the Indexes, adding/deleting them when necessary for better performance.
- Verified backups and error logs on the servers and troubleshoot any failures or alert problems, and open trouble tickets if necessary to work with technicians from other departments.
- Responsible for Installing, configuring and maintaining SQL failover clustering for production environments.
- Worked with installation, configuration and creation of SSRS.
- Deciding whether clustering, log shipping, mirroring, replication, etc are the right fit to solve a business problem.
- On-call troubleshooting for SQL Server service outages.
- Responsible for securing SQL Server, user management, and taking care of permissions and roles.
- Environment: Microsoft SQL Server 2014/2012/2008R2 Enterprise and Standard Editions, Windows 2012/2008R2, Clustering, Always On, Mirroring, replication, SQL Server Management Studio, SQL Profiler, Performance Monitor, SSIS, SSRS, Microsoft Visual Studio 2012, TOAD for MYSQL, Microsoft Office 2013, MongoDB.
SQL Server DBA01/2013 - 11/2015
Nbc Universal
- United Healthcare, serves key markets and geographic regions with a broad range of health benefit products and services for both consumers and benefit sponsors.
- Installed and configured SQLServer2008 R2/SQLServer2008 with backup jobs, database mail and configuration options.
- Upgraded SQL Servers with latest service packs.
- Migrated SQL Server databases from SQL Server 2005 to SQL Server 2008 R2.
- Created, administered & maintained SQL Server Databases on Production, Test and Staging for various groups and ensured the availability of the database Servers.
- Configured and maintained transnational replication for flow of data from QA and Dev. Server to the replica servers.
- Monitored data activities like database status, logs, space utilization, locks and long transactions.
- Implemented SQL standards in writing stored procedures, Triggers, Views, SQL functions.
- Involved in resolving deadlock and blocking issues for concurrent users.. Worked with developers to optimize the code if
- required to minimize the duration and look if the indexes were used appropriately.
- Provided appropriate access to users except system databases owners.
Education
- Bachelor of Science: COMPUTER SCIENCE, 2012
- JNTU UNIVERSITY - INDIA · Emphasis in DATABASE and MANAGEMENT. · Trained in SQL and Testing. · volunteered and participated in several cultural events. · 100 percent attendance and Top of the class in one of the semester. · Coursework includes: SQL,JAVA,C,C++.
Skills
Languages:T-SQLPL/SQLHTMLVB.NETJavaPERLASPPHP and XMLMSMySQLSQL Loader and Export/ImportPowerShell.Backup Software:SQLBackupLite SpeedRed GateId era SQLSafeETL Tools:SSISData Modeler:SSASSQL Developer Data ModelerTOAD Data Modeler.SpotlightIderaSQLsuitephpMyAdminOlas's Maintenance ScriptsPuTTYWireshark.DB Query Tools:MS SQL Server Query AnalyzerSQLProfilerETLSSMSPL/SQL DeveloperToad for SQL/MYSQL/Oracle.Windows NT/
สรุปว่าจะได้อะไรจากตัวอย่างนี้
ตัวอย่างนี้ช่วยให้เห็นแนวทางการเขียนเรซูเม่สำหรับตำแหน่ง SQL SERVER DBA ประสบการณ์ 6 ปี โดยเปิดด้วยบทสรุปที่บอกจุดเด่นของผู้สมัคร ตามด้วยประสบการณ์ทำงาน 3 ตำแหน่ง และข้อมูลการศึกษาที่จำเป็น พร้อมทักษะที่เกี่ยวข้องกับงาน คุณสามารถนำลำดับและวิธีนำเสนอไปปรับใช้ โดยเปลี่ยนรายละเอียดให้ตรงกับประสบการณ์จริงของคุณ
อย่างไรก็ตาม เรซูเม่ที่ชนะต้องเขียนให้ตรงตำแหน่งที่คุณสมัครโดยเฉพาะ ตัวอย่างนี้คือต้นแบบ ไม่ใช่สำเนา ทีมเรซูเม่ของเรารับเขียน Resume และ Cover Letter ภาษาอังกฤษให้โดดเด่นจากคู่แข่ง ส่งงานใน 2 วัน รับประกันความพึงพอใจ