ตัวอย่าง Resume นักพัฒนา SQL (SQL Developer) ฉบับที่ 217
Resume Example SQL Developer #0217 ประมาณ 1281 คำ
เรซูเม่ฉบับนี้เป็นตัวอย่างสำหรับตำแหน่ง SQL Server Developer/DBA ระดับมืออาชีพ มีประสบการณ์รวมประมาณ 5 ปี เรานำมาวิเคราะห์เพื่อให้เห็นว่า โครงสร้างมีจุดเด่นอย่างไร และส่วนใดนำไปปรับใช้กับข้อมูลของคุณได้
จุดเด่นของฉบับนี้ แสดงประสบการณ์ทำงาน 5 ตำแหน่ง พร้อมหน้าที่และผลงานของแต่ละช่วงอย่างเป็นลำดับ
สิ่งที่ควรสังเกตในตัวอย่างนี้
- ประวัติงานต่อเนื่อง 5 ปี เห็นการเติบโตของตำแหน่งได้ชัด
- มีการกล่าวถึง Salesforce ซึ่งเป็นสิ่งที่ HR สายนักพัฒนา SQL ให้ความสำคัญ
- ประสบการณ์ 5 ตำแหน่ง ไล่ระดับจาก Junior ขึ้นไปจนถึงตำแหน่งปัจจุบัน
- Professional Summary กระชับ ใช้คำที่สื่อความสามารถได้จริง
- มีทักษะแยกเป็นหมวด 18+ รายการ ให้ HR เห็นสเปกครบถ้วน
Professional Summary
- Jessica Claire Certified SQL DBA/Developer Over 5+ years of experience in Database Administration using MS SQL Server 2008/2012/2014. - Has 1+ years of experience in using Elastic Search and Altreyx - Has experience in the analysis, design, development, implementation, testing, and maintenance of application systems in the Internet/Intranet, Client Server environments; with 2+ years of experience as a SQL Server DBA/ETL developer. - Very good experience in Installation, configuration and maintenance of SQL Server. - Experience in Data Modeling (Logical and Physical Design of Databases), Normalization and building Referential Integrity Constraints. - Excellent backend skills in creating SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers, Rules, Defaults, user defined data types and functions. - Very good T-SQL Programming skills. Experience in query optimization & performance tuning. Used SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands - Experience in Database backup and disaster recovery procedures. - Experience in Replication - Snapshot, Merge and Transactional. - Has very good experience in complete ETL cycle including data analysis, database design, data mapping and conversion and data load. - Worked in OLTP & OLAP environment that includes Production (24x7). - Extensively worked on Active-Active and Active-Passive Clustering. - Has very strong background in a disciplined software development life cycle (SDLC) process and has excellent analytical, programming and problem solving skills. * - Has the ability to work in a fast paced environment, Good team player and can work independently. Helped the database developers on technical issues. - Migration experience with multiple databases/servers from SQL 2008R2 and SQL 2012 to SQL 2014. - Monitoring SQL server Error logs, Disk Space growth, Clustering Environment. - Monitoring Indexes for Performance Related Issues. - Experience and Knowledge on HA/DR like log shipping/Mirroring/Clustering & Replication. - Extensive experience in implementing Clustering and mirroring on physical and virtual machines. - Experience in Creating Roles and managing user permissions, Jobs, Alerts, SQL Mail Agent, and using performance monitor/ profiler for resolving deadlocks.
Highlights
- Expert 4 - Designed and implemented Elascticsearch for the client. - Created Data indexes using ElasticSearch(NoSQL) for fast accessing data - Implemented Altryx to create packages - Upgraded over 20 SQL servers to the latest version in a 3-month period. - Improved vital processing jobs by reducing process duration by 60%. - Enrolled users, maintained system security, and controlled and monitored user access to the database, operating 24/7, with 40-50 concurrent users at any given time. - Eliminated months of production server issues by systematically troubleshooting and resolving the problem with no further downtime. - Employee of the year 2013 in Cognizant Technology Solutions
Experience
SQL Server Developer/DBA06/2016 - Current
Iron Mountain
- Provides ongoing support for MS SQL SERVER database servers for systems, which include creation, configuration, maintenance and upgrade.
- Installed and Configured MS SQL SERVER on Stand-Alone, and Failover Cluster.
- Designed and implemented SQL server's migrations from 2008R2 to 2012/14/16.
- Configured and Managed the High Availability and Disaster recovery Solutions Always On, Replication, Clustering on Critical Production Servers.
- Configured and Managed Always On Availability Mirror Groups and Replica Databases.
- Upgrading the existing servers with Service Packs, Patches and Hotfixes.
- Created & maintained databases, users, Logins, tables, indexes, stored procedures, roles, permissions and other schema objects.
- Perform database troubleshooting, management, backup, restore and routine maintenance DBCC, Re-index of database table indexes, database performance tuning.
- Managed Users, Roles, Principals and Securable Administration to access the databases at various levels to provide better security on both SQL Server and Windows Authentication Modes.
- Monitored database status including CPU, memory, I/O, space, and dead lock using SQL Server Utilities.
- Developed SSIS and SSAS packages in SQL Server using Business Intelligence Studio and created jobs to schedule the SSIS and SSAS packages in SQL Scheduler.
- Migrated SSIS and SSAS packages from development to test to Production environments using SSIS configuration files and deployment wizard.
SQL SERVER DBA01/2013 - 05/2014
Cognizant Technologies For MANULIFE FINANCIAL - City
- Worked with Terabytes of Data with over 500 databases.
- Installed recommended service packs and security patches on production, test and development servers.
- In SQL 2008R2 set up Database Partitioning to improve query performance.
- Introduced and Implemented Features like Data and maintain security respectively.
- ompression and transparent data encryption to reduce I/O and to
- Utilized Resource Governor to handle two applications on the Server.
- Supported and learned a very complicated Replication system between hundreds of Sybase and SQL Servers.
- Tuning Queries and Database performance using tools SQL Server Tuning Advisor, SQL Server Profiler, Perfmon and Best
Practice Analyzer.
- Experience in Shell scripting (Perl, power shell).
- Expertise in Using Third party tools like DB artisan, Commvault.
- Monitoring and Troubleshooting jobs, Backups and Restore database policies.
- Worked with Application Developers to design databases and tables to support Development activities and achieve optimal efficiency.
- Thorough understanding of standard SOP's, SLA's and change control management process.
- Generating Reports as per the requirement using SSRS 2005/2008.
- Coordinated physical changes and performance monitoring of two replicated production servers and two development servers.
- Develop SSIS Packages to transform data from excel/Access file to SQL Server database.
- Environment: SQL Server 2008/2012, Windows NT/2008/2003 Advanced Server, T-SQL, SSIS, and SSRS, PLSQL, UNIX, AIX servers.
SQL Server DBA/Developer2012 - 01/2013
Cognizant Technology Solutions
- Technologies involved in this application include SQL Server 2000, 2005 Replication, Microsoft Analysis Services and Microsoft
Position
DTS (ETL).
- Responsible for Installations and configurations of SQL Server 2008, applying Service packs.
- Installed and Configured SQL Server 2008 and Clustering Services.
- Worked on SSIS packages using SQL Server 2008.
- Worked extensively on creation of Databases, Objects, Stored Procedures, Triggers, Security, DTS (i.e.
- Import and Export), BCP, Transact-SQL, Backups, Recovery, and SQL Server Agent, SQL Server profiler using SQL Server.
- Implemented high availability solutions, including Clustering, Database Mirroring, Replication and Log Shipping.
- Worked extensively on Data Modeling on creation of new data models add existing tables to the data models and creation of new tables.
- Used Replication (both Transactional and Merge replication) to move databases from SQL server 2000 to SQL server 2005.
- Extensively worked on SharePoint projects and applications having Terra bytes of databases.
- Good knowledge and experience in TEAM FOUNDATION SERVER(TFS).
- Experienced in Configuring, Implementing and Maintaining Database Mirroring.
- Extensive experience in Configuration, Implementation and Maintenance Using Log Shipping, Transactional and Merge Replication in SQL Server2000/2005.
- Performance Tuning to increase the speed and performance of website, tuning hardware and software requirements.
- In SQL 2008R2 set up Database Partitioning to improve query performance.
- Introduced and Implemented Features like Data and Backup compression and transparent data encryption to reduce I/O and to maintain security respectively.
- Environment: SQL Server 2005/2008R2, Windows NT/2008R2/2008/2003, IBM Lombardi BPM 7.5, T-SQL, SSIS, and SSRS, ETL.
Education
- Master of Science: Information Systems, 2016
- Marist College - Poughkeepsie, NY · Information Systems 3.4
- Bachelors of Technology: Computer Science, 2011
- Jawaharlal Nehru University - Hyderabad · Computer Science 3.5 · Microsoft Certified Professional (MCP) · MCSA: SQL Server 2012/2014 · ITIL V3 Foundation certified · Oracle certified Java Programmer(OCJP) · Salesforce Certified Cloud Developer
Skills
Database maintenance plansschedulingalertsExpertBackup/RecoveryClustering (AlwaysOnClustering)Devicesdatabases and logs - designcreationDisaster RecoveryElasticSearchIntermediateAltreyxPerformance Tuning (Optimization)Reporting Services (SSRS)SSISSQL (T-SQL)
สรุปว่าจะได้อะไรจากตัวอย่างนี้
ตัวอย่างนี้ช่วยให้เห็นแนวทางการเขียนเรซูเม่สำหรับตำแหน่ง SQL Server Developer/DBA ประสบการณ์ 5 ปี โดยเปิดด้วยบทสรุปที่บอกจุดเด่นของผู้สมัคร ตามด้วยประสบการณ์ทำงาน 5 ตำแหน่ง และข้อมูลการศึกษาที่จำเป็น พร้อมทักษะที่เกี่ยวข้องกับงาน คุณสามารถนำลำดับและวิธีนำเสนอไปปรับใช้ โดยเปลี่ยนรายละเอียดให้ตรงกับประสบการณ์จริงของคุณ
อย่างไรก็ตาม เรซูเม่ที่ชนะต้องเขียนให้ตรงตำแหน่งที่คุณสมัครโดยเฉพาะ ตัวอย่างนี้คือต้นแบบ ไม่ใช่สำเนา ทีมเรซูเม่ของเรารับเขียน Resume และ Cover Letter ภาษาอังกฤษให้โดดเด่นจากคู่แข่ง ส่งงานใน 2 วัน รับประกันความพึงพอใจ