ตัวอย่าง Resume นักพัฒนา SQL (SQL Developer) ฉบับที่ 108
Resume Example SQL Developer #0108 ประมาณ 1434 คำ
เรซูเม่ฉบับนี้เป็นตัวอย่างสำหรับตำแหน่ง Pgbouncer/pgpool-II, EFM. / Cloud Database Administrator (PostgreSQL, MS SQL) ระดับมืออาชีพ มีประสบการณ์รวมประมาณ 6 ปี เรานำมาวิเคราะห์เพื่อให้เห็นว่า โครงสร้างมีจุดเด่นอย่างไร และส่วนใดนำไปปรับใช้กับข้อมูลของคุณได้
จุดเด่นของฉบับนี้ แสดงประสบการณ์ทำงาน 6 ตำแหน่ง พร้อมหน้าที่และผลงานของแต่ละช่วงอย่างเป็นลำดับ
สิ่งที่ควรสังเกตในตัวอย่างนี้
- ประวัติงานต่อเนื่อง 6 ปี เห็นการเติบโตของตำแหน่งได้ชัด
- มีการกล่าวถึง Kubernetes ซึ่งเป็นสิ่งที่ HR สายนักพัฒนา SQL ให้ความสำคัญ
- ประสบการณ์ 6 ตำแหน่ง ไล่ระดับจาก Junior ขึ้นไปจนถึงตำแหน่งปัจจุบัน
- Professional Summary กระชับ ใช้คำที่สื่อความสามารถได้จริง
- มีทักษะแยกเป็นหมวด 32+ รายการ ให้ HR เห็นสเปกครบถ้วน
Professional Summary
More than 6 years of diverse experience in administration of Relational Databases. Extensive technical skills and understanding of PostgreSQL, MS SQL Server Databases in the cloud and on-prem. Strong collaborator and team player with excellent communication skills and expertise in analytical problem-solving. Key participant in daily meetings to discuss about the new database maintenance strategies, Backups and creation. Installing and configuring open source and enterprise databases systems. Experience designing database structures, indexes, views, partitioning. Installing and configuring multiple PostgreSQL utilities e.g. EFM, pgbouncer, pgpool, pgbadger, pgbackrest, pgrepack etc. Installing and configuring MS SQL Server 2017, 2019 & 2021 (standard and enterprise editions), PostgreSQL 10.x, 11.x, 12.x, 13.x &14.x on AWS RDS and EC2. Installed, configured, upgraded, migrated (as necessary) and maintain several instances. Troubleshoot replication, corruption issues and fix as appropriate. Extensive work experience on production databases. - PostgreSQL, EDB Postgres, RDS Postgres, MS SQL SERVER, MYSQL.. - Linux/Unix (Cent-OS, Debian, Ubuntu), Kubernetes
Experience
Pgbouncer/pgpool-II, EFM. / Cloud Database Administrator (PostgreSQL, MS SQL)07/2022 - Current
Cognizant Technology Solutions
- Taking Backup of PostgreSQL Databases running on AWS RDS using pgdump, AWS Lambda & AWX Backup.
- Configured MS SQL Server Option group called "Native-backup-restore" to backup MS SQL databases running on AWS RDS. and store in S3 bucket.
- Working in collaboration with the SRE Team for database monitoring
- Monitored my databases using Dynatrace, Performance Insights, Enhanced monitoring. CloudWacth and Dynatrace.
- Compared 2 different schemas and two different databases to find the missing tables using PgAdmin.
- Installing and configuring PostgreSQL & MS SQL Databases running on AWS RDS, on-premises.
- Configuration of pgbadger to analyze the results of load testings in order to address database issues.
- Stand up a production database with a snapshot of the staging environment, shared from a different AWS account.
- Modification of the RDS databases to enable more features like performance insights, enhanced monitoring, delete protection etc. Upgraded multiple PostgreSQL databases from 10.x to 12 and 13.x
- Homogenous migration of PostgreQL databases from on-prem to AWS RDS using pgdump, pgrestore and psql.
- Assisting deployment teams by running database scripts (MDL, DDL, TCL etc.), by taking a backup of specific database or table as recommended on the Jira Tickets.
- Assisting deployment team with issues related to backup and restore etc.
- Worked with DEVOPS Team to address the database readiness after a new deployment.
- Troubleshooted staging & production databases and resolved issues with corruptions, queries and Database latency
- Checking fragmentations, database integrity, custom database report.
- memory management, thread and tasks managements, buffer management
- Configuration of PostgreSQL & MS SQL SERVER Parameter group to address specifics database problem based on the result of our investigations
- Proposed to the DBA a maintenance plan strategy to resolve database issues, specially for some critical production databases.
- Configured pgcron to automate our db maintenance tasks like VACUUM ANALYZE, REINDEX, CLUSTER.
- Resolved issues with cache missed, bloat, tempfiles, deadlocks, locks, frequent checkpoints, index corruption, latency due to the table size, full storage, extension not present in rsd allowextensions, high CPU usage etc.
- Configured pgrepack for full database vacuum with minimum downtime.
- Scheduled SQL agents to resolve issues with fragmentation & kill sleeping processes on MS SQL SERVER databases
- Used basics Kubernetes commands to find information as per business requirement.
- Providing response for all system/database issues on 24 x 7 schedule responding to critical events and situations outside normal work hours
- Monitored the database for Index, partitioning Memory and I/O utilization
- Connect to my RDS MS SQL SERVER using MS SQL Management studio
- Used EXPLAIN and EXPLAIN ANALYZE to identify and fine tune SQL queries for performance improvements
- Switched the Database from Production to Testing and Testing to Production
- Prepared technical interview questions to interview with few candidates for the position of Database administrator
- Familiarity with Parameter store, Route 53, EBS, LastPass etc.
PostgreSQL Database Administrator02/2019 - 05/2022
The Active Network
- Create IAM user accounts and role-based policies for access to AWS Postgres on Both RDS and EC2 Instances, Compared custom and default parameters group
- Defined AWS Security Groups which acted as virtual firewalls that controlled the traffic allowed to reach one or more AWS EC2 instances
- Manage the Space and Storage of Databases through various Shell Scripts scheduled in the crontab periodically in regular intervals
- Performed database Refreshes and monitored replication delays
- Highly experienced in Configuration, Implementation and Maintenance of Log Shipping:
- Created new cluster and upgraded the cluster to another PostgreSQL sever
- Database secutity with Row level security, search path, pghba.conf and postgresql.conf
- Installed and configured MTK for migration from Oracle to postgresql and EDB advance server
- Maintained postgresql with PgAdmin 4, Psq
- Created tablespace, databases, indexes, moving data, granting of necessary privileges in posgresql and EDB advance server from 9.6 to x.
- Performed backup, restore, and created databases using PgAdmin 4, pgdump and pgbasebackup, pgbackrest.
- Created Tablespaces, Schemas, Users, profiles and implementing various adjustments in postgresql.conf file and granting users and application access through pghba.conf file etc
- Tuning autovacuum parameters to ensure up to date table stats and reclaim space consumed by dead tuples.
- Provided response for all system/database issues on 24 x 7 schedule responding to critical events and situations outside normal work hours
- Worked with development and operations teams to tune production queries for optimal performance
- Proactive managing standby replication methodologies like Streaming replication and hot standby for disaster recovery
- Configuring monitoring tools for better performance like PEM, CloudWatch, Performance Insight, Postgresql logs.
- Proactive in updating the latest security patches to database, which are provided by PostgreSQL open-source community
- Configured and Database installation creating tables, schemas
- Monitored the database for Index, partitioning Memory and I/O utilization
- Configured Enterprise Failover Manager for fast database failover, and integrate that with pgpool-II for connection pooling and load balancing to resolve issues with locks and deadlocks.
- Implemented cascading replication for our databases running on EC2.
- Used EXPLAIN and EXPLAIN ANALYZE to identify and fine tune sql queries for performance improvements.
Database Administrator02/2018 - 01/2019
CVS Pharmacy
- Maintained detailed technical documentation of database architecture and modeling as per business requirements
- Provided technical assistance for preparation of shell scripts for tasks automation
- Conducted complete analysis of database capacity and performance requirements
- Implemented procedures for analysis, consolidation and tuning of databases for efficiency
- Implemented a database replication, replication monitoring
- configured pgbouncer for load connection pooling
- Upgraded databases from 9.6 to 10.x and 11.x using pgupgrade
- Performed database maintenance tasks like vacuum, analyze, vacuum full, reindex, cluster, create index etc.
- Monitored using Datadog
- scheduled my jobs using crontab.
Junior Database Administrator (MySQL & PostgreSQL) / Trader Joe's - City, STATE01/2015 - 11/2017
- Responsible for configuring, integrating, and maintaining all Development, QA, Staging and Production PostgreSQL databases within the organization
- Implement, configure, and troubleshoot database instances, replication, backup, partitions, storage, and access
- Set user privileges within and outside the database environment from the pghba.conf
- Migration of Data from Reports generated by various vendors into PostgreSQL Databases using PostgreSQL Export/Import Procedures
- Manage the Space and Storage of the Databases through various Shell Scripts scheduled in the crontab periodically in regular intervals
- Migration of Data from Reports generated by various vendors into PostgreSQL Databases using PostgreSQL Export/Import Procedures; - During production hours, resolved lock/deadlocks and resource contention issues
- Administered, supported and monitored databases by proactively resolving database issues and maintaining servers.
- pgdump, pgbasebackup, X-TRA backup for MYSQL
- Monitored my databases using solarwinds
- created a MySQL and PostgreSQL Databases
- Familiarity with psql, DML, DDL, DCL etc.
- Performed MYSQL daily Maintenance tasks.
- reload/refresh the privilege or the grants tables
- started, stopped and reloaded my databases.
- Database security with row level security, searchpath, pghba.conf and Postgresql.conf.
- Certification of: PostgreSQL-12 Certified Associate, 03/2022
EnterpriseDB - USA
- Bachelor of Science: Computer Science, 08/2014
University of Douala - Douala, Cameroon
Skills
AWS RDSLambdaPerformance InsightsCloudWatchKMSExplain AnalyzedDatabase developmentRelational Database Management.PostgreSQL extensions (pgcronpgrepackpgbadgerpgstatstatements etc.)Replicationupgrademigration etc.MTKpgdumpGreen/Blue DeploymentPgupgradepghba.confpostgresql.conf etc.AnsibleTerraformAWXProblem-SolvingMultitaskingAbilities. Analytical and Critical ThinkingDBeaverPgAdminDynatracepsqlscripting etc.
สรุปว่าจะได้อะไรจากตัวอย่างนี้
ตัวอย่างนี้ช่วยให้เห็นแนวทางการเขียนเรซูเม่สำหรับตำแหน่ง Pgbouncer/pgpool-II, EFM. / Cloud Database Administrator (PostgreSQL, MS SQL) ประสบการณ์ 6 ปี โดยเปิดด้วยบทสรุปที่บอกจุดเด่นของผู้สมัคร ตามด้วยประสบการณ์ทำงาน 6 ตำแหน่ง พร้อมทักษะที่เกี่ยวข้องกับงาน คุณสามารถนำลำดับและวิธีนำเสนอไปปรับใช้ โดยเปลี่ยนรายละเอียดให้ตรงกับประสบการณ์จริงของคุณ
อย่างไรก็ตาม เรซูเม่ที่ชนะต้องเขียนให้ตรงตำแหน่งที่คุณสมัครโดยเฉพาะ ตัวอย่างนี้คือต้นแบบ ไม่ใช่สำเนา ทีมเรซูเม่ของเรารับเขียน Resume และ Cover Letter ภาษาอังกฤษให้โดดเด่นจากคู่แข่ง ส่งงานใน 2 วัน รับประกันความพึงพอใจ