ตัวอย่าง Resume นักพัฒนา SQL (SQL Developer) ฉบับที่ 125
Resume Example SQL Developer #0125 ประมาณ 1310 คำ
เรซูเม่ฉบับนี้เป็นตัวอย่างสำหรับตำแหน่ง MS SQL SERVER DBA มีประสบการณ์รวมประมาณ 7 ปี เรานำมาวิเคราะห์เพื่อให้เห็นว่า โครงสร้างมีจุดเด่นอย่างไร และส่วนใดนำไปปรับใช้กับข้อมูลของคุณได้
จุดเด่นของฉบับนี้ แสดงประสบการณ์ทำงาน 3 ตำแหน่ง พร้อมหน้าที่และผลงานของแต่ละช่วงอย่างเป็นลำดับ
สิ่งที่ควรสังเกตในตัวอย่างนี้
- ประวัติงานต่อเนื่อง 7 ปี เห็นการเติบโตของตำแหน่งได้ชัด
- ประสบการณ์ 3 ตำแหน่ง ไล่ระดับจาก Junior ขึ้นไปจนถึงตำแหน่งปัจจุบัน
- Professional Summary กระชับ ใช้คำที่สื่อความสามารถได้จริง
- มีทักษะแยกเป็นหมวด 14+ รายการ ให้ HR เห็นสเปกครบถ้วน
Professional Summary
- 7 Years of experience in Database Administration for very large and complex databases in SQL Server 2019,2017,2016, 2014, 2012, 2008, 2005. - Performed all day-to-day aspects of MS SQL database administration. Responsibilities include database design, installation, configuration, upgrades, security, managing users and logins, performance monitoring and tuning, database availability, backup and recovery, troubleshooting and problem resolution. - Configured High Availability Solution- Clustering, Always On, Database Mirroring and Log Shipping. - Involved in ensuring data recovery, maintenance, and data integrity and space requirements for physical database. Creating and Modifying Tables, Stored Procedures, Views, Indexes, User-defined Functions and Triggers as requirement on SQL Server Environments. - Planning and implementation of Database backup/restore and disaster recovery - Installed SQL Server 2005-2019 on following Microsoft best practices, applied Patches and security fixes. - SQL Server Profiler, Extended Events, Query Store and Database Engine Tuning Advisor (DTA) for performance. - Configured and supported replication and log shipping in both SQL 2008 and 2012. - Maintained database response times in 24/7 in Production environments. - Monitoring standby Databases to ensure high availability - Automation of DBA tasks using PowerShell scripts and monitoring - Configured and managed Contained Database - Managed and provisioned Azure SQL databases and services. - Configured and supported replication and log shipping in both SQL 2008 and 2012. - Managed and reduced cost by effectively monitoring the databases elastic pool - Performed Database Migration from an On-Premises SQL environment to Azure Database in the cloud - Installed and configured MS SQL Server VM in Azure Database
Experience
MS SQL SERVER DBA01/2020 - Current
Edge Link
- Planning an Installation of Microsoft SQL Server 2005SP4, 2008R2, 2012, 2014, 2016, 2017, 2019, building, designing, Configuration, Upgrade, Migration and application of Windows and SQL Patches during scheduled database non production hours to ensure databases are up to date in Virtualized environments
- Implement and define vigorous Backup and Recovery strategy and Capacity planning following company's SLA that is Recovery Point Objective (RPO), Recovery Time objective(RTO) and Retention policy
- Recommend and implement data security by creating users and assigning permissions based on the principle of least privileges and also with technologies such as Always Encrypted, Transparent Data Encryption (TDE) and Dynamic Data Masking (DDM) to secure clients sensitive data
- Using SQL server in-built tools such as SQL Server profiler, Extended Events, activity monitor to monitor performance and system health; Database Integrity checks to ensure database integrity, stability, and system availability.
- Configured High Availability (HA) and Disaster Recovery (DR) Solutions on production in standalone and Clustered environments such as Always On, Traditional Failover Clustering (Windows Server Failover Cluster - WTFC), Database Mirroring, Replication such as transactional replication and Log Shipping to make sure the databases are always available and participating in disaster recovery.
- Troubleshooting and resolving database integrity issues, performance issues, blocking and deadlock issues, updating statistics for query optimization using performance and activity monitor, event viewers, extended events. - Managing and providing end to end support and problem resolution for SQL Server databases through multiple product lifecycle environments, such as development, testing to mission-critical production systems.
- Create and update database documentation about company standard procedures, technology features and production issue troubleshooting.
- Analyze, solve and correct issues in real time and provide end-to-end problem resolution such as hardware and software purchases, server configuration changes and assisting developers with query/index tuning, Partitioning. compression and updating statistics to enhance speed and maximize system performance.
- Creating and monitoring maintenance plans and agent jobs that automates backups and reorganize/rebuild indexes for query performance.
- Hands-on database tuning and troubleshooting of SQL Server service outages as they occur, including providing On call support during after-hours and weekends. Providing scheduled maintenance, supporting application deployment, and hardware/software upgrades after hours and 24 x 7 support.
- Review scripts submitted by the development team and Working with other teams like systems analysts, developers, business analysts, and project teams to perform capacity planning required to create and maintain the Databases.
- Control and establish appropriate database user access control levels by provisioning and deprovisioning users based upon company policy to control access for each segment of the Databases. Develop database security guidelines and perform audits.
- Migrate SQL server databases from on prem to AZURE using Data Migration Assistant.
- Develop and monitor system and application alerts to ensure Health monitoring and performance tuning
- Create and maintain azure managed SQL instances and databases
MS SQL SERVER DBA Texas Department Of Criminal Justice - City, STATE02/2018 - 12/2019
- Manage infrastructure performance, data security and make recommendations for improvements
- Manage infrastructure performance, data security and make recommendations for improvements
- Assist in monitoring and review of Strong analytical, planning, and organizational skills with ability to manage competing demands
- Involved in planning, setup and implementation of new servers across the entire enterprise
- Involved in ensuring data recovery, maintenance, and data integrity and space requirements for physical database.
- Planned and deployed monthly windows and SQL server patches.
- Planning and implementation of Database backup/restore and disaster recovery
- Create and work on High Availability (HA) and Disaster Recovery (DR) options for SQL Server
- Writing basics TSQL scrips, stored procedures, functions and triggers, data transformations using BIDS
- Implementation of snapshot isolation and DDL triggers
- Migration of SQL Server 2005 servers to SQL Server 2008
- Stable Replication Topology
- Installed SQL Server 2008 on advanced servers, applied security fixes
- SQL Server Upgrade
- Performed Database Migration from an On-Premises SQL environment to Azure Database in the cloud
- Installed and configured MS SQL Server 2008 R2, supported all Production and development servers
- Maintained database response times in 24X7 Production environments
- Developing SQL scripts for maintaining administration tasks
- Capacity Planning and resource allocation.
- Monitoring standby databases to ensure high availability
- Troubleshoot, resolve issues related to computer software and hardware controlling production equipment application
- Production level support for onsite and offshore Clients
- Support Patch Management
- Integrated Temporal Tables
JUNIOR MS SQL SERVER DBA American Airlines - City, STATE05/2015 - 01/2018
Education
- M.D.: Chemical And Natural Gas Engineering Texas A&M University - Kingsville - Kingsville, TX
- Bachelor of Science: Geology
- University of Buea - Cameroon · MS SQL SERVER DBA And TSQL · Empire Data System - Texas
Skills
Excelpower pointService NowActive directoryHyper-VVMware WorkstationSolarWinds - JiraSQL Server Tools SSMSProfilerQuery AnalyzerSSISSSRSMS AccessETL DTS
สรุปว่าจะได้อะไรจากตัวอย่างนี้
ตัวอย่างนี้ช่วยให้เห็นแนวทางการเขียนเรซูเม่สำหรับตำแหน่ง MS SQL SERVER DBA ประสบการณ์ 7 ปี โดยเปิดด้วยบทสรุปที่บอกจุดเด่นของผู้สมัคร ตามด้วยประสบการณ์ทำงาน 3 ตำแหน่ง และข้อมูลการศึกษาที่จำเป็น พร้อมทักษะที่เกี่ยวข้องกับงาน คุณสามารถนำลำดับและวิธีนำเสนอไปปรับใช้ โดยเปลี่ยนรายละเอียดให้ตรงกับประสบการณ์จริงของคุณ
อย่างไรก็ตาม เรซูเม่ที่ชนะต้องเขียนให้ตรงตำแหน่งที่คุณสมัครโดยเฉพาะ ตัวอย่างนี้คือต้นแบบ ไม่ใช่สำเนา ทีมเรซูเม่ของเรารับเขียน Resume และ Cover Letter ภาษาอังกฤษให้โดดเด่นจากคู่แข่ง ส่งงานใน 2 วัน รับประกันความพึงพอใจ