ตัวอย่าง Resume นักพัฒนา SQL (SQL Developer) ฉบับที่ 130
Resume Example SQL Developer #0130 ประมาณ 1259 คำ
เรซูเม่ฉบับนี้เป็นตัวอย่างสำหรับตำแหน่ง SENIOR SQL SERVER DATABASE ADMINISTRATOR (DBA) / Wells Fargo | Bellingham, WA / Responsibility ระดับอาวุโส มีประสบการณ์รวมประมาณ 8 ปี เรานำมาวิเคราะห์เพื่อให้เห็นว่า โครงสร้างมีจุดเด่นอย่างไร และส่วนใดนำไปปรับใช้กับข้อมูลของคุณได้
จุดเด่นของฉบับนี้ แสดงประสบการณ์ทำงาน 7 ตำแหน่ง พร้อมหน้าที่และผลงานของแต่ละช่วงอย่างเป็นลำดับ
สิ่งที่ควรสังเกตในตัวอย่างนี้
- ประวัติงานต่อเนื่อง 8 ปี เห็นการเติบโตของตำแหน่งได้ชัด
- ประสบการณ์ 7 ตำแหน่ง ไล่ระดับจาก Junior ขึ้นไปจนถึงตำแหน่งปัจจุบัน
- Professional Summary กระชับ ใช้คำที่สื่อความสามารถได้จริง
Professional Summary
SKILLS O Jessica Claire An experienced SQL server Database Administrator with around 8 years of expertise in 24/7/365 production environment and possess extensive knowledge in SQL installation, configuration, optimization, server builds, patches, service packs, upgrading and troubleshooting of SQL Servers in Clustered and Non- Clustered environments. Implemented and supported different High Availability and Disaster Recovery scenarios like Always-On Availability Groups, Clustering, Replication, Log Shipping and Database Mirroring. Strong DBA/Development skills writing T-SQL scripts, worked extensively on ETL process using DTS, SSIS packages, handling data quality issues and generated various types of reports using SSRS on OLAP databases. Good knowledge and experience on Azure cloud services, Azure storage, Azure Active Directory (AD), Azure VMs, and SQL Database. Operating system and Virtualization; Window server 2008/2008R2/2012/2012R2/2016 Relational DBMS; MS SQL server Migration tools: DMS, DMA for Azure cloud environment Development and Modelling tool; Data tools 2005/2008/2008R2/2012/2014/2016/2017/2019, MS Visual Studio, BIDS, SSMS, Query Analyzer and ERWIN Programming; SQL, T-SQL, C/C++, XML, HTML Networking; SAN, NAS, LAN, WAN, TCP/IP, FTP, SMTP Performance Tool; Database Engine Tuning and shell scripting (Power Shell) Advisor, Profiler, Performance Monitor
Experience
SENIOR SQL SERVER DATABASE ADMINISTRATOR (DBA) / Wells Fargo | Bellingham, WA / Responsibilityaccess 2000, 2005, 2008 · 02/2022 - CURRENT
- Responsible for working on 2008, 2012, 2014 and 2016 versions of SQL involved in building out new secondary data center servers by configuring SQL 2008/2012/2016 with DR strategy.
- Performed Log shipping, replication, mirroring and implemented as high availability techniques and setting up and automatic/forced fail over for production servers.
- Involved in Administering the servers by creating User logins with appropriate roles, logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups Configured SQL Server 2016 Always On Availability Groups
- Involved in Analyzing and Upgrading SQL Server 2008 to SQL Server 2016
- Auditing of database for Logins, Users transactions, and database activities and resolving orphan users.
- Troubleshoot Blocking and Deadlocking issues by making appropriate changes to Transaction Isolation levels and the types of locks being held; avoid keeping transactions open for long durations, breaking large transactions to smaller ones.
- Scheduling and monitoring SQL agent jobs.
- Designed and developed script to refresh selective data from production to development, and
- implementing to support business needs and deadlines
- Extensively worked on data migration from physical to virtual and virtual to virtual across various versions of SQL sever
- Work with Server/SAN team to diagnose IO latency occurring with several VM's suffering from -IO taking longer than 15 seconds configured HADR techniques such as log shipping and Always on
- Managed workload independently but collaborated with colleagues to complete larger scale tasks in distributed team environment.
- Worked with staff to develop and implement procedures to prevent data loss and maximize system availability.
SECIOR SQL SERVER DATABASE ADMINISTRATOR (DBA) / Wells Fargo | Brentwood, TN / Responsibility06/2019 - 01/2022
- Install and configure new Microsoft SQL Server instances, including Always On availability groups and failover clustering.
Configured and maintained IIS 6.0.
- Create database, table, index, stored procedure, triggers.
- Create Users and assign permissions based on the level of database access the users would need.
- Create, schedule, modify and optimize SQL Server Agent jobs and maintenance plans, verify that all scheduled job has run successful.
- Design database Backup and Restoration Strategy, monitor those backups are being performed regularly.
- Configured and maintained transactional, snapshot replication and merge replication.
Experience in Windows Azure, migrating database to Azure.
- Worked and coordinated with developers in writing and tuning new stored procedures.
- Proactively design, document, and promote security 'best practice', policies, standards and protocols for SQL environments using SQL server management studio.
- Perform ETL process of importing large volumes of data, cleaned up and transformed to the desired format.
- Check all statistics related to memory, locks, I/O, database response time, wait events, top sessions and background processes.
- Monitoring the performance of physical configuration, the way the database is indexed, regularly monitor and identify blocking and lock issues. Design a procedure that continuously run on all
- production server and notifies DBA team if any blockings, long running quires/transaction. Scripted and automate day to day maintenance tasks using PowerShell scripts
- Converted existing T-SQL batch scripts to PowerShell scripts and improving SQL Server maintenance jobs performance.
- Configured Temp DB with considerable Memory and RAID Levels for better performance.
- Created an internal secured website linking to the database that includes updated information about all target SQL server information.
- Create, configuring and managing virtual machine
- Wrote and maintained technical and functional specifications to document database intentions and requirements.
SCO SERVER DATABASE ADMINISTRATOR / Technical Resource International(TRI) | City, STATE / Responsibility
- Worked on migrating SQL Server from SQL Server 2012 to SQL Server 2014/2016
Position02/2017 - 05/2019
- Design and implement the appropriate database maintenance for database systems (Index maintenance, update statistics, Backup strategies).
- Work with application teams on tuning queries which causes extended blocking, deadlock and locking. Developed automated tasks for daily, weekly and monthly database maintenance such as database backup, database integrity verification and indexing using control-M agent and SQL server agent. Developed complex T-SQL script and stored procedure to improve performance, preserve referential integrity and provide application functionality.
- Worked on linked server to run distributed queries between SQL server and Oracle databases. Periodically apply the required service packs and cumulative updates on database servers. Configured Transparent Data Encryption (TDE) and backup/restore strategies on encrypted database Worked with IDERA tool by setting up alerts for the monitors of various SQL servers for different types of issues.
- Followed standard practices for migrating changes to test and production environments.
SCO SERVER DATABASE ADMINISTRATOR / Zambia National Commercial Bank | City, STATE / Responsibility08/2014 - 01/2017
- Installed SQL server 2012/2008/2008R2.
- Worked on applying service pack upgrade for SQL2012 SP3 to SQL 2012 SP4 on 2 node cluster Manage logins and users, assigned roles, auditing, credential and proxies and apply least privilege to ensure data security.
- Perform daily checkups on SQL jobs, replication, hardware diagnostics for hard drives, backups, disk- space, SQL and windows error logs as part of proactive maintenance plan.
- Created active directory with security group with table level permission.
- Set up and maintain replication for production server to provide high availability and monitor using replication monitor.
- Installed SSL encrypted certificate on Windows cluster to use SQL server force encryption for incoming SQL server connections on database servers
- Created and develop tables, views, indexes, functions and advanced queries for database by using query analyzer and SQL server enterprise manager.
- Maintain index-rebuild and reorganize index periodically.
- Created and developed stored procedures to handle complex business rules, history data, and audit analysis.
- Implement the DDL triggers, created DDL triggers to prevent accidental table and to restrict access for unauthorized user.
- Design, implement and manage database maintenance and disaster recovery plans including replication, full/differential/transactional log backups with recovery.
- Created mail profile and setting up alerts using SQL mail to send automatic mail to respective people when a job failed or succeed.
- Proactively trouble shoot performance issues through SQL server error Log, Windows Event logs, Profiler, Execution plan, Perfmon, Activity monitor and DMVS
- Documented changes made to the servers, including documentation of performance issues. Designed ETL packages dealing with different data sources (SQL server, Flat files and XML) and loaded the data into target data sources by performing different kind of transformation using SSIS 2008/2005.
- Generated periodic reports based on statistical analysis of data using SQL server reporting services (SSRS) according to the client requirement.
Education
- Bachelor of Science · Information Technology
- Microsoft Certified Solutions Associate (MCSA): SQL server 2012/2014 · Professional developments · Training on Microsoft SQL Server 2012/2014/2016/2019
สรุปว่าจะได้อะไรจากตัวอย่างนี้
ตัวอย่างนี้ช่วยให้เห็นแนวทางการเขียนเรซูเม่สำหรับตำแหน่ง SENIOR SQL SERVER DATABASE ADMINISTRATOR (DBA) / Wells Fargo | Bellingham, WA / Responsibility ประสบการณ์ 8 ปี โดยเปิดด้วยบทสรุปที่บอกจุดเด่นของผู้สมัคร ตามด้วยประสบการณ์ทำงาน 7 ตำแหน่ง และข้อมูลการศึกษาที่จำเป็น คุณสามารถนำลำดับและวิธีนำเสนอไปปรับใช้ โดยเปลี่ยนรายละเอียดให้ตรงกับประสบการณ์จริงของคุณ
อย่างไรก็ตาม เรซูเม่ที่ชนะต้องเขียนให้ตรงตำแหน่งที่คุณสมัครโดยเฉพาะ ตัวอย่างนี้คือต้นแบบ ไม่ใช่สำเนา ทีมเรซูเม่ของเรารับเขียน Resume และ Cover Letter ภาษาอังกฤษให้โดดเด่นจากคู่แข่ง ส่งงานใน 2 วัน รับประกันความพึงพอใจ