ตัวอย่าง Resume นักพัฒนา SQL (SQL Developer) ฉบับที่ 190
Resume Example SQL Developer #0190 ประมาณ 1525 คำ
เรซูเม่ฉบับนี้เป็นตัวอย่างสำหรับตำแหน่ง Azure/SQL Server Database Administrator ระดับอาวุโส มีประสบการณ์รวมประมาณ 9 ปี เรานำมาวิเคราะห์เพื่อให้เห็นว่า โครงสร้างมีจุดเด่นอย่างไร และส่วนใดนำไปปรับใช้กับข้อมูลของคุณได้
จุดเด่นของฉบับนี้ แสดงประสบการณ์ทำงาน 4 ตำแหน่ง พร้อมหน้าที่และผลงานของแต่ละช่วงอย่างเป็นลำดับ
สิ่งที่ควรสังเกตในตัวอย่างนี้
- ประวัติงานต่อเนื่อง 9 ปี เห็นการเติบโตของตำแหน่งได้ชัด
- มีการกล่าวถึง Salesforce ซึ่งเป็นสิ่งที่ HR สายนักพัฒนา SQL ให้ความสำคัญ
- ประสบการณ์ 4 ตำแหน่ง ไล่ระดับจาก Junior ขึ้นไปจนถึงตำแหน่งปัจจุบัน
- Professional Summary กระชับ ใช้คำที่สื่อความสามารถได้จริง
- มีทักษะแยกเป็นหมวด 21+ รายการ ให้ HR เห็นสเปกครบถ้วน
Professional Summary
- Accomplished and qualified IT professional with diverse and extensive on-premises and Azure cloud database administration experiences. - An effective team member, including work as a Senior Microsoft SQL DBA, database design, and system administration using Microsoft SQL Server 2012,2014,2016,2017 and 2019. - Experienced in the MS-Azure Cloud environment from design to Administering Azure SQL Databases. Key strengths include: problem-solving skills, attention to detail, multitasking, and the ability to build effective business relationships, even during times of high stress deployments. - Extensive project management experience and process oriented; deeply experienced in providing solutions to performance issues. Equipped with an excellent work ethic; possesses a strong sense of responsibility and teamwork with a track record of dependability. - Possess excellent verbal, written and presentation skills. MS-SQL Server Experiences A Microsoft SQL server (DBA) with 9+ years IT experience: designing, coding, testing, and supporting next-generation database solutions in SQL Server environment. - Possess strong communication and problem-solving skills developed through a variety of projects. Offer proven ability in team work and proactive system support. - Experience in Installing, configuring, administration and Maintenance of mission critical client databases in SQL server 2012, 2014, 2016, 2017 and 2019 versions. Good experience in configuring the SQL Server in AWS Relational Database Management system and in EC2. - Extensive Experience in Upgrading SQL Server (In place Up and Side by side Upgrade) based on application compatibility and fixing the orphan users. Experience in implementing SQL Server security and Object permissions like creation of users, granting permissions and assigning roles to users. Deployment, administration and operational support of production, development and test environments utilizing proper change management and other ITIL best practices using ticketing tool. - Good experience implementing and troubleshooting High Availability of database servers using Replication, Log Shipping, Database Mirroring, failover clustering and Always ON AG. Strong experience on understanding and creating the server level and database level roles as per business requirement. - Experience in Configuring and Scheduling SQL Server agent Jobs, Alerts, operators, Maintenance plans, Database Mail Configuration, facets and Transparent Data Encryption. Extensive experience with Monitoring, Performance Tuning and analyzing DB performance issues. Strong experience on designing and implementing the backup and disaster recovery strategies as per RPO and RTO values.
Experience
Azure/SQL Server Database Administrator06/2019 - Current
Cgi Group Inc.
- Azure cloud professional with strong experience in migrating resources to Azure, Azure Adminstration, Azure infrastructure Operations, and end to end Project Managment. Produced high-standard database solutions to meet stability, reliability, Bash and PowerShell.
- Migrate SQL-Server Databases to Microsoft Azure hosted DBs, Managed instances.
- Performed Database Migration from On-Premises SQL environment to Azure Database in cloud Managed database security and users in Active Directory, ensure Database Integrity and setup maintenance plans via SQL Agent.
- Managed Servers and database level Security by implementing the Triple As (AAA); Authentication, Authorization and Auditing. All Users are Authenticated through the various security protocols.
- Participate in an on-call support rotation and provide non-standard work hour support
- Provides database support to business users. Restores functionality to database processes that have failed, documents resolutions, and creates and maintains troubleshooting documentation
- Employs general SQL, Microsoft T-SQL, stored procedures, Date Transformation Services (DTS) scripts, and SQL Server Integration Services (SSIS) to manage database systems and to automate data migration and processing
- Designs, develops and implements database tables, views, triggers, indexes, and stored procedures to ensure data integrity for custom applications. Communicates with IT management, and peers regarding database solutions and potential enhancements - Designs, develops, tests, documents, and implements scripts to automate data importing, exporting, reporting, and analysis to ensure data confidentiality, availability and integrity
- Installing, configuring, administering and securing production and non-production servers (clustered and non-clustered). Upgrading SQL server 2016 to SQL Server 2019
- Experience in implementing windows cluster across multiple availability zones and Implemented SQL Server 2016 Always On availability group in AWS.
- Managed SQL server Logins, Database users & roles and involved in Daily User Maintenance.
- Created Database Maintenance jobs to perform full & transaction log Backups and scheduled them with the SQL Server agent job scheduler.
- Monitor database growth activities & Troubleshoot Transaction Log Issue.
- Created and configured mirroring for Disaster Recovery
- Providing weekly status information on all projects to Project Manager
- Wrote and debugged Stored Procedures and (DDL /DML) Triggers, Functions as per client requirements.
- Logical and Physical design of database for projects on basis of user requirements using ERWIN
- Reporting on a weekly basis to the project manager.
- Extensively worked on troubleshooting and fine-tuning of databases for optimal performance.
- Worked with Performance Tuning/Query tuning, execution plans, trace flags and SQL Profiler
- Installation of Service packs to all environments.
- Environment: SQL Server 2012-2019, AWS-RDS, AWS-EC2, IDERA SQL diagnostic Manager, SQL safe 6.0, Red-gate SQL Compare 10 and Data Compare 10, Visio 2010, DataEdo, ERWIN.
SQL Server Database Administrator02/2016 - 05/2019
Cgi Group Inc.
- Installed and Configured various editions and versions of SQL Server in standalone, and clustered nodes
- Applied service packs, hotfixes and cumulative updates
- Upgraded SQL Server 2012 R2 Database into SQL Server 2014 and 2016
- Created and maintained logins, Users, Roles and managed security of the database
- Implemented Disaster recovery plan by performing routine backups and restore
- Taking Full, Differential and Transactional log backups and setting automated jobs
- Migrated data using Import/Export, bulk, backup-restore, DTS, SSIS, Detach/Attach
- Performed data Extracting, Transforming and Loading (ETL) from different data sources
- Rebuilding /reorganize indexes to reduce fragmentation and enhance SQL server performance
- Created triggers, views and stored procedures
- Implemented database Maintenance plans, scheduled automated SQL Server jobs, Created Alerts, Operators, Notifications and configured database Mail
- Hands on experience monitoring and performance tuning using Tuning Advisor, SQL server Profiler, Activity monitor, Windows performance monitor, DBCC, DMVs, Stored procedures
- Working with Resource Governor to control and allocate CPU and memory resources depending on the priority of applications
- Configured and Managed Database High Availability: Replication, Database Mirroring, Log Shipping, Failover Clustering and Always On availability group
- Scheduled reports using SSRS to generate daily, weekly, monthly, quarterly reports
- Worked in a team with integrated Developers, CAB (Change Approval Board) and Disaster Recovery Planning team
- Experience in contacting Microsoft and other vendors for product and technical support
- Providing resolution to assigned tickets (JIRA, Team Track and Service Desk) as per their severity and meet the deadline before SLA is due
- Experience in Agile projects with a solid foundation in Software Development Lifecycle (SDLC)
- Environment: SQL Server 2008, 2014, IDERA SQL diagnostic,, Red-gate SQL Compare 10 and Data Compare 10, Visio 2010, SSDT.
SQL Server Database Administrator / Mastercard - City, STATE09/2014 - 02/2016
- Database High Availability: Installed, Configured and Maintained AlwaysOn High Availability Group using SQL Server 2012.Installed, Configured and Maintained Fail-Over Clustering using SQL Server 2008. Installed, Configured and Maintained Database Mirroring using automatic fail-over option in SQL Server 2012. Configured Log Shipping as Standby database from Production database for Reporting purposes. Configured and Maintained Replications.
- Database Upgrade: SQL Server SQL Server 2008 R2 to SQL Server 2012
- Database Migration: Migrated MS Access 2012 R2 and 2014 database into MS SQL Server. Migrated Oracle 10g, MySQL into MS SQL Server 2012.
- Data Modeling: Worked on more than 10 data modeling projects and generated E-R Diagrams. Data Modeling tools used using SQL Server Data Diagram.
- Database Monitoring/Performance Tuning: Strong on database Monitoring and Performance tuning. Scheduled jobs to automate different database related activities including backup, monitoring database health, disk space, and backup verification. Monitor SQL Server Error Log, space usage.
- Database Programming: Wrote T-SQL, Trigger, and Stored-Procedures. Assisted Database Developers to optimize SQL queries and Stored Procedures.
- ETL Tools: Used ETL tools like DTS, SSIS, Import/Export, BCP (Bulk Copy), to import & export data from flat files, and excel to MS SQL Server databases.
- Export & Import: Data from Oracle and SQL Server Excel and setup and performed ETL data load from Oracle and other flat files like text, Excel, and CSV files
- Backup/Recovery: Proficient in Database Backup and Disaster Recovery. Experienced with Point-in-Time Recovery. Restored
Database from backup.
- Report Development: Installed, Configured, and administered SQL Server Reporting Services. Developed Reports using SSRS. Deployed Reports. Developed Ad-hoc Reports using Report Builder 3.0, 2.0.
- Used DBCC to check database conditions, Rebuilding indexes and other database Maintenance purposes as well.
- Environment: SQL Server 2012 - 2014, SQL Server 2012 SSMS, Profiler, Extended Events, Perfmon, RAID
Education
- Bachelor of Science: Computer Science, 08/2009
- Unity University
- Certificate in MCDBA: Administering Microsoft SQL Server 2012/2014 (70-462)
Skills
Windows Server OSSQL ServerT-SQLAWS-RDSDataEdoERWINSSDTAzureSSISSSRSSSMSDTAJIRARAIDMYSQLLiteSpeedAZURE VMAzure managed instanceMuleSoftSalesforceAPI.
สรุปว่าจะได้อะไรจากตัวอย่างนี้
ตัวอย่างนี้ช่วยให้เห็นแนวทางการเขียนเรซูเม่สำหรับตำแหน่ง Azure/SQL Server Database Administrator ประสบการณ์ 9 ปี โดยเปิดด้วยบทสรุปที่บอกจุดเด่นของผู้สมัคร ตามด้วยประสบการณ์ทำงาน 4 ตำแหน่ง และข้อมูลการศึกษาที่จำเป็น พร้อมทักษะที่เกี่ยวข้องกับงาน คุณสามารถนำลำดับและวิธีนำเสนอไปปรับใช้ โดยเปลี่ยนรายละเอียดให้ตรงกับประสบการณ์จริงของคุณ
อย่างไรก็ตาม เรซูเม่ที่ชนะต้องเขียนให้ตรงตำแหน่งที่คุณสมัครโดยเฉพาะ ตัวอย่างนี้คือต้นแบบ ไม่ใช่สำเนา ทีมเรซูเม่ของเรารับเขียน Resume และ Cover Letter ภาษาอังกฤษให้โดดเด่นจากคู่แข่ง ส่งงานใน 2 วัน รับประกันความพึงพอใจ