ตัวอย่าง Resume นักพัฒนา SQL (SQL Developer) ฉบับที่ 157
Resume Example SQL Developer #0157 ประมาณ 1255 คำ
เรซูเม่ฉบับนี้เป็นตัวอย่างสำหรับตำแหน่ง SQL SERVER DATABASE ADMINISTRATOR ระดับมืออาชีพ มีประสบการณ์รวมประมาณ 8 ปี เรานำมาวิเคราะห์เพื่อให้เห็นว่า โครงสร้างมีจุดเด่นอย่างไร และส่วนใดนำไปปรับใช้กับข้อมูลของคุณได้
จุดเด่นของฉบับนี้ แสดงประสบการณ์ทำงาน 5 ตำแหน่ง พร้อมหน้าที่และผลงานของแต่ละช่วงอย่างเป็นลำดับ
สิ่งที่ควรสังเกตในตัวอย่างนี้
- ประวัติงานต่อเนื่อง 8 ปี เห็นการเติบโตของตำแหน่งได้ชัด
- มีการกล่าวถึง Power BI ซึ่งเป็นสิ่งที่ HR สายนักพัฒนา SQL ให้ความสำคัญ
- ประสบการณ์ 5 ตำแหน่ง ไล่ระดับจาก Junior ขึ้นไปจนถึงตำแหน่งปัจจุบัน
- Professional Summary กระชับ ใช้คำที่สื่อความสามารถได้จริง
- มีทักษะแยกเป็นหมวด 12+ รายการ ให้ HR เห็นสเปกครบถ้วน
Professional Summary
Result oriented Database Administrator with 8+ years of experience and a proven knowledge of back-office operations, confidential correspondence, and data entry. Aiming to leverage my skills to successfully fill the SQL Server Database Administrator role at your company. Database Professional with over 7 years of experience managing critical databases both on Prem and in the Cloud (Azure) Have substantial expertise on Performance Tuning, Maintenance, High Availability and Disaster Recovery (HADR) Strategies Hands on experience in setting up and troubleshooting Always On, Clustering, Database Mirroring, Log Shipping, including Replication (Snapshot, Transactional/ Merge and Peer to Peer) Database Backup and Restore/Recovery, Query Optimization, Security, SQL Server Installation, Configuration of Stand-alone and Clustered environments Migration/Upgrade, applying service packs and routine/emergency DBA operations like database health check, index optimization, updating statistics, client/server connectivity and capacity planning. Responsible for securing SQL Server, User Management, assigning permissions and roles Using Query Store, Extended Events, Database Engine Tuning Advisor (DTA), SQL Profiler, Scripts, and other third-party tools to resolve bottlenecks, deadlocks, and slow running queries Database security through configuring dynamic data masking Experienced with Active Directory (AD) objects and user permissions.
Experience
Position03/2019 - Current
- Operating Systems: Windows Server 2008 R2, 2012 and 2016
Ticketing Tools: Remedy 8.0
- Other Essential Software: Microsoft Office Word, Excel - Database Support
- Administering Databases
SNR SQL SERVER DATABASE ADMINISTRATOR
Rr Donnelley & Sons
- Developed custom database objects, stored procedures and delivered application support.
- Followed standard practices for migrating changes to test and production environments and provided technology support to meet business requirements.
- Managing over 3000 databases and VLDB across multiple data centers
- Involved in Technical decisions for Business requirement, Interaction with Business Analysts, Client team, Development team, Capacity planning and upgrading of SQL Servers
- Migrated SQL Data from on-premises to Azure SQL Database
- Responsible for setting up and maintaining High Availability and Disaster Recovery Solutions and large-scale database migrations from SQL Server 2008R2 to SQL Server 2019
- Performed Physical and Logical Data Modelling for databases of varied sizes including VLDBS
- Responsible for providing 24x7 DBA & Production support for over 180 SQL Server databases in Production on Clustered Servers
- Involved in assisting SQL Server prime customers with Configuration, Administration, Implementation and Troubleshooting for Business workflow with Log Shipping mechanism
- Configured DR solution with Transaction Replication from Distribution Server with multiple Updatable subscriptions
- Perform Database Refresh tasks from production to Development and Staging Servers
- Perform Scheduled backups and restore operations
- Create (with respect to standards) Logins, Users, groups, Roles, Jobs, Alerts, Mail's confirmation upon tasks
- Perform Database consistency checks with DBCC, Defrag, Index tuning and monitored error logs
- Provide On-Call support to Mission critical Environments and expertise with Disaster Recovery mechanisms
- Resolve SQL Server problems in conformance with SLAs, which involves in-depth knowledge of SQL Server architecture, connectivity, replication, backup/restore, security and continuous improvement
- Maintain two different databases: Read-only reporting database and Disaster recovery database
- Perform security tasks like Grant, Revoke permissions for security tasks
- Involved in auditing and performing transactions to database and resolve issues with PerfMon and SQL Profiler
- and Used NetMon for Monitoring and Performing Network throughput issues
- Designed and implemented TSQL queries for reporting and complex solution development.
- Maintained complex T-SQL queries, views and stored procedures in multi-database environment with little supervision.
- Produced high-standard database solutions to meet stability, reliability and performance metrics.
- Managed workload independently but collaborated with colleagues to complete larger scale tasks in distributed team environment.
SQL SERVER DATABASE ADMINISTRATOR06/2017 - 03/2019
SYNOVUS BANK,
- MS SQL Server design, Development and administration using SQL Server 2005-2017 database environments
- Monitoring SQL health checks and identifying issues and fixing them
- Used SQL Indexes for improving query performance, lower storage, and maintenance cost
- Used Optimization tools like SQL Profiler, Dynamic Management Views (DMVs) and Windows Performance Monitor for monitoring and tuning SQL Server performance
- Implemented Installation, Configuration and Upgrading of SQL Server
- Good experience in User Management and maintaining databases
- Automation of administrative tasks like creating jobs and schedules, alerts using SQL Server Agent monitoring and troubleshooting jobs, event notifications using Database Mail
- Maintained server security assigning logins, server and database roles and server permissions
- Implemented disaster prevention and recovery strategies and supported High Availability features like Clustering, Always On, Log Shipping, Database Mirroring and Replication
- Maintained database response times in 24X7 production environment and proactively generated reports
- Planned and Implemented database backup/restore and disaster recovery
- Implemented Log Shipping from Primary to Standby servers
- Created and maintained SQL objects like Tables, Views, Stored Procedure, Constraints and User defined functions
- Used tools like SQL Profiler, Fog Light, Red Gate, SolarWinds, SQL Sentry for monitoring my environment
- Responsible for installing and maintaining SSIS, SSRS, and Power BI
- Produced high-standard database solutions to meet stability, reliability and performance metrics.
JNR SQL SERVER DATABASE ADMINISTRATOR06/2013 - 05/2016
RTSI GLOBAL INC
- Setup and troubleshoot Active/Passive Clustering on SQL 2012
- Built useful reporting deliverables to properly document analysis results and provide performance improvement feedback.
- Involved controlling and co-coordinating the installations (Security patches, Service packs) and
- System performance before pre-deployment in production
- Expert in Using DMV's, Performance dash board, Mirroring, database snapshot
- Involved in assisting SQL Server prime customers with Configuration, Administration
- Implementation and Trouble-shooting for Business work flow with Log Shipping mechanism
- Setup Snapshot, Merge and Transactional Replication between Servers, and troubleshoot and monitor Publishers, Distributors, and Subscribers
- Involved in Installation of SQL Server with
- Multiple instances, latest SPs and hot fixes
- Performed Database Refresh tasks from production to Development and Staging Servers
- Involved in auditing/performing the transactions to database and resolve the issues with PerfMon and SQL Profiler
- Performance monitor for Memory, Processor, Disk I/O, and fine-tuning Disk usage, Cache-hit ratio, Transaction p/s
- Fine Tuned stored procedures for Better performance and also maintaining data Integrity in SQL Server, Written Stored Procedures for Application Developers
- Involved in solving high critical throughput, mission critical problems
- Tuned the application queries, generated reports for the development teams using STATSPACK reports, Explain plan, Session trace, giving hints (parallel, index), tkprof, etc
- Used Process Explorer for maintenance of stuck process, and to release the handles on files
- Monitored and tuned the server and databases using DBCC, server configuration options like spconfigure and database option as spdboption
- Involved in Creation of databases, writing queries, monitoring of execution plan for tracing the execution flow for critical throughput
- Environment: SQL Server 2008 R2, Windows NT/2003/2008, BMC Patrol, VERITAS Net Backup
Education
- POST GRADUATE DIPLOMA: Maritime Technology
- UNIVERSITY OF LAGOS - LAGOS, NIGERIA
- Bachelor of Science: Applied Science
- MARITIME ACADEMY OF NIGERIA - AKWA IBOM, NIGERIA · MEDCERTS - Livonia, MI
- CompTIA Security+ Certification CompTIA Network+ Certification AZ-104 Microsoft Certified Azure Administrator Associate Microsoft Certified Azure Fundamentals Microsoft Certified Solution Associate (MCSA) - SQL Database Administration 2016 Server DP300 Microsoft Certified Azure Database Administration Associate
Skills
SQL ProfilerPerformanceMonitorSQLCMDDatabase Tuning WizardDTADMV's and DBCCDR Configuration: Log ShippingMirroringClusteringTransactional ReplicationsData Integration
สรุปว่าจะได้อะไรจากตัวอย่างนี้
ตัวอย่างนี้ช่วยให้เห็นแนวทางการเขียนเรซูเม่สำหรับตำแหน่ง SQL SERVER DATABASE ADMINISTRATOR ประสบการณ์ 8 ปี โดยเปิดด้วยบทสรุปที่บอกจุดเด่นของผู้สมัคร ตามด้วยประสบการณ์ทำงาน 5 ตำแหน่ง และข้อมูลการศึกษาที่จำเป็น พร้อมทักษะที่เกี่ยวข้องกับงาน คุณสามารถนำลำดับและวิธีนำเสนอไปปรับใช้ โดยเปลี่ยนรายละเอียดให้ตรงกับประสบการณ์จริงของคุณ
อย่างไรก็ตาม เรซูเม่ที่ชนะต้องเขียนให้ตรงตำแหน่งที่คุณสมัครโดยเฉพาะ ตัวอย่างนี้คือต้นแบบ ไม่ใช่สำเนา ทีมเรซูเม่ของเรารับเขียน Resume และ Cover Letter ภาษาอังกฤษให้โดดเด่นจากคู่แข่ง ส่งงานใน 2 วัน รับประกันความพึงพอใจ