ตัวอย่าง Resume นักพัฒนา SQL (SQL Developer) ฉบับที่ 158
Resume Example SQL Developer #0158 ประมาณ 1311 คำ
เรซูเม่ฉบับนี้เป็นตัวอย่างสำหรับตำแหน่ง SQL Server Database Administrator ระดับมืออาชีพ มีประสบการณ์รวมประมาณ 12 ปี เรานำมาวิเคราะห์เพื่อให้เห็นว่า โครงสร้างมีจุดเด่นอย่างไร และส่วนใดนำไปปรับใช้กับข้อมูลของคุณได้
จุดเด่นของฉบับนี้ แสดงประสบการณ์ทำงาน 7 ตำแหน่ง พร้อมหน้าที่และผลงานของแต่ละช่วงอย่างเป็นลำดับ
สิ่งที่ควรสังเกตในตัวอย่างนี้
- ประวัติงานต่อเนื่อง 12 ปี เห็นการเติบโตของตำแหน่งได้ชัด
- ประสบการณ์ 7 ตำแหน่ง ไล่ระดับจาก Junior ขึ้นไปจนถึงตำแหน่งปัจจุบัน
- Professional Summary กระชับ ใช้คำที่สื่อความสามารถได้จริง
Professional Summary
Talented Database Administrator with 12+ years of diverse experience in database design and administration, data modeling, data warehousing. Extensive technical skills and advanced understanding of SQL Server, Oracle and Postgres administration. Strong collaborator and team player with excellent communication skills and expertise in analytical problem-solving.
Experience
SQL Server Database Administrator12/2017 - Current
Genesis Consulting Group Client Name: Farmers Insurance Group
- Duration : Nov 2017 to Till Date
Location: Woodland Hills, CA / Client Name: United States Automobile Association / Location: San Antonio, Texas / Responsibilities in SQL server:Feb 2017 - Nov 2017
Duration:
- Worked on SQL Server 2016 & 2012 migration from SQL Server 2008/2005 (using Backup/Restore, Detach/Attach and Drive/Mount point mirroring)
- Worked on SQL server Import/Export for moving the data from higher version to lower version
- Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies
- Expertise in designing databases and capacity planning.
- Implemented Merge Replication for CISCO databases
- Expertise in Always-On Availability Groups (AAG) and HA/DR Troubleshooting
- Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.
- Strong technical background along with the ability to perform business analysis and write effective documentation and specifications
- Handling database space issues
- Administering SQL Server High Availability and Disaster Recovery strategies.
- Experience in using DMV and dynamic management functions for finding out long running queries.
- Worked extensively on Clustering and server consolidation. Troubleshooting production issues and raising high availability.
- Proficiency and expertise in SQL Server Replication, Backup/Recovery, Disaster recovery and planning.
- Having hands on experience in DR processes including Log shipping and Database Mirroring.
- Troubleshoot performance problems
- Implemented Always-ON (AAG) on SQL Server 2016 SP1 (4 Node Configuration)
- Implemented Always-ON (AAG) on SQL Server 2012 SP2 CU5 (2 Node Configuration)
- Expertise in Always-On Availability Groups (AAG) and HA/DR Setup and Configuration
- Recovering the databases from backup in disasters. Implementing Point-In-Time Recovery solutions.
- Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
Responsibilities in Oracle:
- Logging into the server and setting the environment
- Creating Users and granting them access
- Creating schemas and Roles
- Created DB link as per the users request
- Performing Import/Export on the schema level as per the users request
- Executing scripts as on the Oracle databases and spooling the output of the scripts
- Looking for active sessions and checking if any queries are running longer
- Checking the database status in RAC using SRVCTL commands
- Checking the TableSpace details and increasing the space if required
Responsibilities in Postgres:
- Installing Postgres on the Linux server
- Creating database and connecting to the database
- Creating users and granting them the required access
- Creating the tables as per the application requirements
- Taking backup and restoring the database using PGADMIN tool
- Stopping and starting the Postgres instance
- Creating schema's and creating tables on the schema
- Executing the scripts on the Postgres database using PGADMIN tool
SQL Server Database Administrator / Client Name: United States Automobile Association.Jun 2013 - Feb 2017
Genesis Consulting Group
- Worked on SQL Server 2016 & 2012 migration from SQL Server 2008/2005 (using Backup/Restore, Detach/Attach and Drive/Mount point mirroring)
- Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies
- Expertise in designing databases and capacity planning.
- Created SILENT install scripts for installing SQL server 2012 and 2016 without any manual interruption
- Expertise in Always-On Availability Groups (AAG) and HA/DR Troubleshooting
- Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.
- Strong technical background along with the ability to perform business analysis and write effective documentation and specifications
- Handling database space issues
- Administering SQL Server High Availability and Disaster Recovery strategies.
- Experience in using DMV and dynamic management functions for finding out long running queries.
- Worked extensively on Clustering and server consolidation. Troubleshooting production issues and raising high availability.
- Proficiency and expertise in SQL Server Replication, Backup/Recovery, Disaster recovery and planning.
- Having hands on experience in DR processes including Log shipping and Database Mirroring.
- Troubleshoot performance problems
- Implemented Always-ON (AAG) on SQL Server 2016 SP1 (4 Node Configuration)
- Implemented Always-ON (AAG) on SQL Server 2012 SP2 CU5 (2 Node Configuration)
- Strong experience in mentoring team members and writing documentation.
- Expertise in Always-On Availability Groups (AAG) and HA/DR Setup and Configuration
- Rebuilding / monitoring the indexes at regular intervals for better performance.
- Recovering the databases from backup in disasters. Implementing Point-In-Time Recovery solutions.
- Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
- Experience in using SQL Server Profiler, SQL Server Agent
SQL Server Database AdministratorMay 2011 - June 2013
Genesis Consulting Group Client Name: Travelers (An insurance Company)
- Troubleshooting of backup failure
- Doing master rebuilt
- Creating RCA's
- Migration of the Databases from lower version to Higher versions
- Creating Logins and granting access to the users
- Handling T-log space issue
- Working with clustering and standalone SQL servers
- Failover in Clustering
- Restoration of DB's from PROD to Pre-PROD, DEV, etc...
- Creating Logins and providing the access
- Installing SQL server 2005, 2008
- Creating secondary data and log files in case of space issues both in standalone and Clusters
- Table refresh between instances using IMPORT and EXPORT
- Creating databases
- Doing table level restore
- Install / Upgrade the SQL server on production servers
- Troubleshooting space issue
- Creating and scheduling the change
SQL Server Database Administrator / Client Name: Microsoft / Client Name: NIKE / Client Name: NESTLENov 2010 - May 2011
Genesis Consulting Group
- Troubleshooting of backup failure
- Migration of the Databases from lower version to Higher versions
- Creating Logins and granting access to the users
- Handling T-log space issue
- Working with clustering, mirroring, Replication and Database Mirroring
- Failover in Clustering
- Restoration of DB's from PROD to Pre-PROD, DEV, etc...
- Creating Logins and providing the access
- Installing SQL server 2005
- Creating secondary data and log files in case of space issues both in standalone and Clusters
- Creating maintenance plans and scheduling the jobs
- Configuring Replication, adding an article in Publications, Troubleshooting Transactional Replication issues
- Table refresh between instances using IMPORT and EXPORT
- Creating databases
- Table refresh between two servers using DTS
- Adding and removing the IIS servers whenever needed
- Install / Upgrade the SQL server on production servers
- Troubleshooting space issue
- Moving the system DB's to another location (Master, Model, MSDB and Tempdb)
- Taking backups of the Encryption Key
- Executing the scripts on user's request
- Patching SQL server
- Monitoring SQL machines and IIS machines using Sitescope tool
- Checking the SQL replication between EBIS DB and metropolis DB
- Checking all the terminal servers and doing DELPROF if the users are facing any issues
- Bachelor of Science: Computer Application, 04/2006 Bharathidasan University - Tiruchirappalli, TamilNadu,INDIA
Education
- Certified in Hardware and Networking – IIHT (Indian Institute of Hardware Technology) · ITIL Foundation in IT Service Management
Skills
Oracle & Postgres)Relational Database ManagementSystems administrationCommunicationsMS OfficeProblem Resolution
สรุปว่าจะได้อะไรจากตัวอย่างนี้
ตัวอย่างนี้ช่วยให้เห็นแนวทางการเขียนเรซูเม่สำหรับตำแหน่ง SQL Server Database Administrator ประสบการณ์ 12 ปี โดยเปิดด้วยบทสรุปที่บอกจุดเด่นของผู้สมัคร ตามด้วยประสบการณ์ทำงาน 7 ตำแหน่ง และข้อมูลการศึกษาที่จำเป็น พร้อมทักษะที่เกี่ยวข้องกับงาน คุณสามารถนำลำดับและวิธีนำเสนอไปปรับใช้ โดยเปลี่ยนรายละเอียดให้ตรงกับประสบการณ์จริงของคุณ
อย่างไรก็ตาม เรซูเม่ที่ชนะต้องเขียนให้ตรงตำแหน่งที่คุณสมัครโดยเฉพาะ ตัวอย่างนี้คือต้นแบบ ไม่ใช่สำเนา ทีมเรซูเม่ของเรารับเขียน Resume และ Cover Letter ภาษาอังกฤษให้โดดเด่นจากคู่แข่ง ส่งงานใน 2 วัน รับประกันความพึงพอใจ