ตัวอย่าง Resume นักพัฒนา SQL (SQL Developer) ฉบับที่ 187
Resume Example SQL Developer #0187 ประมาณ 1317 คำ
เรซูเม่ฉบับนี้เป็นตัวอย่างสำหรับตำแหน่ง SQL Server DBA ระดับมืออาชีพ มีประสบการณ์รวมประมาณ 7 ปี เรานำมาวิเคราะห์เพื่อให้เห็นว่า โครงสร้างมีจุดเด่นอย่างไร และส่วนใดนำไปปรับใช้กับข้อมูลของคุณได้
จุดเด่นของฉบับนี้ แสดงประสบการณ์ทำงาน 4 ตำแหน่ง พร้อมหน้าที่และผลงานของแต่ละช่วงอย่างเป็นลำดับ
สิ่งที่ควรสังเกตในตัวอย่างนี้
- ประวัติงานต่อเนื่อง 7 ปี เห็นการเติบโตของตำแหน่งได้ชัด
- มีการกล่าวถึง Tableau ซึ่งเป็นสิ่งที่ HR สายนักพัฒนา SQL ให้ความสำคัญ
- ประสบการณ์ 4 ตำแหน่ง ไล่ระดับจาก Junior ขึ้นไปจนถึงตำแหน่งปัจจุบัน
- Professional Summary กระชับ ใช้คำที่สื่อความสามารถได้จริง
Professional Summary
Client-focused Database Administrator with about 7 years proactively of working toward achieving high client satisfaction. As an IT professional very much committed to maintain cutting edge technical skills and up-to-date industry knowledge. Deadline-focused with broad skill range including, Database Design Development and Support of MS SQL Server 2019/2017/2016/2014/2012/2008R2/in Production, UAT, Test, Development and Cluster Server Environments. Strong Skill set in Database Administration using Windows platform. Always eager to acquire knowledge and share with colleagues. I am part of multiple IT Professional groups and participate in blogging like PASS, SQL Saturday, and SQL Server Central.
Experience
SQL Server DBA03/2020 - Current
Pinnacle Technical Resources Inc
- Loss prevention
- Cash register operations
- Product promotions
- Installed and configured SQL Server 2012/2014/ 2016/2017/2019 on production and non-production servers both on Standalone and Clustered servers
- Migrated over 200+ databases from SQL Server 2008 and 2012 to SQL Server 2017/2019 as part of Data Center migration project and troubleshoot related issues that were reported post migration.
- Experienced in installing and configuring Always-On Availability Groups (AAG) and DR Troubleshooting.
- Administering SQL Server High Availability and Disaster Recovery strategies such as log shipping, mirroring and replication. .Configured and implemented Always-On Availability Groups with one primary and two secondary replicas for HA/DR. - Manage logins and users, assign roles, auditing, applied least privileges and TDE to ensure data security.
- Experience and knowledgeable in designing critical production database backup and recovery strategies following Customer SLA's Contracts to satisfy their RTO's and RPO's.
- Experience in setting up full, diff, trans logs backups by scheduling jobs and alerts. Also monitoring these jobs and troubleshooting them in case of any failure.
- Experience in successfully restore/recovering a corrupted database using the different backup and recovery techniques. - Experience in capacity planning of the SQL server databases by managing and monitoring disk space usage, datafile and log file usage using native tools and third-party tools like SolarWinds and what sup gold.
- As part of a team of DBA, I was task with a project to effective design a SQL server database following best practice and successful come out with plan to patch and upgrade/migrated over 200+ database running on multiple instances.
- Implemented and monitored transactional replication for DR and reporting purposes.
- Created database objects such as tables, Stored Procedures, Views and Triggers.
- Setup and configured Always-On Availability Groups on multiple databases.
- Working on Database backup strategies, scheduling the jobs and working on failures.
- Re-designed a database maintenance plan which freed about 30% disk space by avoiding frequent running of DBCC checks, adjusting fill factor and rebuilding indexes based on fragmentation level.
- Implemented User-Defined server roles in SQL Server 2012, default schemas for groups.
- Created Jobs and maintenance plans for better performance of the server some of the jobs include index rebuild/reorgs, DBCC check, update database stats, database cleanup and other SSIS packages to help with data migration.
- Created alerts with database mail Simple Mail Transfer Protocol (SMTP).
- Worked extensively in Query analyzer and profiler for tuning queries using variable for characteristics and query costs. Setup and maintained Linked Servers.
- Implemented Transparent Data Encryption (TDE) to protect sensitive data and backups.
- Used Database Consistency Checks - DBCC Commands for database maintenance.
- Created maintenance plans for integrity checks and resolved issues related to it.
- Modified Stored Procedures and complex T-SQL Queries to improve query execution process.
- Used SQL Profiler, Server-side trace to identify performance issues on the server.
Managing SQL Server Workload using Resource Governor.
- Improved query performance by analyzing the stats, Query Execution Plans, system performance by system Performance Analysis, and used SQL Profiler for optimizing stored procedures.
- Monitored all the SQL Server databases using Solar Winds and created custom statistics reports to users in Tableau.
- Knowledgeable in migrating On PREM databases to Azure using database Migration assistant (DMA) or other techniques like BACPAC or back and restore to Azure blob storage.
- Installation and Setup of MongoDB Ops Manager and Mongo Atlas
- Supported a 24/7 on call rotation database infrastructure and a very willing team player.
- Environment: SQL Server 2008/2012/2016/2017,2019 Windows server 2008/2012/2016, SSIS, Solar Winds, VMware, SAN, SQL profiler, SSMS, DMA, AZURE, oracle, Veeam, Always ON, Log shipping, replication, mirroring etc.
SQL Server DBA02/2019 - 03/2020
Pinnacle Technical Resources Inc
- SQL Server installation and database setup/configuration (2012, 2014 & 2016) in on premise locations with different trust levels and Domains.
- Planning and implementing SQL Server patching on quarterly basis on all non-Prod and Prod environments.
- .Configuring and Managing SQL AlwaysOn High availability environment in Local clusters & GeoCLusters and troubleshooting the availability Groups and other issues.
- Monitoring SQL server/Database health checks and performance related issues using BMC Patrol and Database Mail Alerts.
- Identify the usage of Old SQL servers (SQL 2000, SQL 2005), Migrate/Upgrade the databases to higher versions based on Application compatibility and planning to Decommission.
- Implement and support High Availability: Mirroring, Log shipping and transactional Replication.
- Managing the over 200+ database instance with multiple databases running on them both on VM's and physical machines.
- Maintain the integrity, availability, and recoverability of all production data systems. Planning for overall data deployment and operational health.
- Troubleshooting, Debugging and Performance Optimization for SQL Server Database and Application Related issues.
- Conducting Database Refresh once a week from PROD to UAT, DEV, and Test Environments.
- Monitoring SQL server Error logs, Disk Space growth, Clustering Environment.
- Planning and applying latest Service Packs and CU to different versions of SQL Server.
- Worked on performance and tuning, identifying locking and blocking for long running queries.
- Works on Yearly password renewal activities for all SQL server service accounts through Password Vault.
- Monitor server capacity and make recommendations for hardware upgrades or add-ons (E.g., processors, disk space and memory) to accommodate current and planned server usage.
- Monitoring, Configuring Database Backups using third party tools NetBackup tool and Native SQL Backup Maintenance jobs.
- Create Linked servers between SQL server and Oracle server databases.
- Refreshing the development databases with production data as per Application team's request.
- Deploy SSIS packages in SQL servers and configured the jobs using those SSIS packages based on user requirements using dedicated Proxy accounts.
- Migrating databases and DB Objects between DEV, QA and Prod environments using Export/Import wizard and/or Generate Scripts, back and restore methods.
- Managing SQL Server and Database level security, like creating and managing logins, database users and user permissions.
- Review performance stats and recommend changes for Database Tuning, Query Optimization, Diagnosing & fixing SQL performance issues.
- Works on performance tuning, identifying locking and blocking for long running queries.
- Monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index
- modification, code optimization and adding scheduled jobs to re-index and update statistics in databases.
- Using SQL Compliance tool to compare and migrate the database objects Schema from one server to another.
- Maintain and update SQL Inventory and Database Growth Report on regular basis.
- Communicating with clients to ensure end-user discrepancies are resolved.
- Supported a 24/7 mission critical infrastructure and was involve in and on call rotation process to support the business databases and application.
- Environment: MS SQL Server 2016/2014/2008R2/2005, T-SQL, SSIS, SQL Profiler, Log Shipping, always on, Mirroring, Clustering Windows Server 2012R2 and Windows Server 2008R2, PowerShell, MS DOS, SharePoint 2010, Oracle 10g, VMware, SolarWinds, apache, SAN etc.
Data Analyst03/2017 - 02/2019
Cushman & Wakefield
- Collected, tracked and reviewed data to evaluate business and market trends.
- Reviewed business requirements and revised implementation strategies to resolve data issues.
Education
- Bachelor of Science: Mathematic And Economics, 11/2007
- University of Benin - Benin City, Nigeria
Skills
Guest servicesInventory control proceduresMerchandising expertise
สรุปว่าจะได้อะไรจากตัวอย่างนี้
ตัวอย่างนี้ช่วยให้เห็นแนวทางการเขียนเรซูเม่สำหรับตำแหน่ง SQL Server DBA ประสบการณ์ 7 ปี โดยเปิดด้วยบทสรุปที่บอกจุดเด่นของผู้สมัคร ตามด้วยประสบการณ์ทำงาน 4 ตำแหน่ง และข้อมูลการศึกษาที่จำเป็น พร้อมทักษะที่เกี่ยวข้องกับงาน คุณสามารถนำลำดับและวิธีนำเสนอไปปรับใช้ โดยเปลี่ยนรายละเอียดให้ตรงกับประสบการณ์จริงของคุณ
อย่างไรก็ตาม เรซูเม่ที่ชนะต้องเขียนให้ตรงตำแหน่งที่คุณสมัครโดยเฉพาะ ตัวอย่างนี้คือต้นแบบ ไม่ใช่สำเนา ทีมเรซูเม่ของเรารับเขียน Resume และ Cover Letter ภาษาอังกฤษให้โดดเด่นจากคู่แข่ง ส่งงานใน 2 วัน รับประกันความพึงพอใจ