ตัวอย่าง Resume นักพัฒนา SQL (SQL Developer) ฉบับที่ 251
Resume Example SQL Developer #0251 ประมาณ 2197 คำ
เรซูเม่ฉบับนี้เป็นตัวอย่างสำหรับตำแหน่ง CAREER OVERVIEW ระดับมืออาชีพ มีประสบการณ์รวมประมาณ 7 ปี เรานำมาวิเคราะห์เพื่อให้เห็นว่า โครงสร้างมีจุดเด่นอย่างไร และส่วนใดนำไปปรับใช้กับข้อมูลของคุณได้
จุดเด่นของฉบับนี้ แสดงประสบการณ์ทำงาน 5 ตำแหน่ง พร้อมหน้าที่และผลงานของแต่ละช่วงอย่างเป็นลำดับ
สิ่งที่ควรสังเกตในตัวอย่างนี้
- ประวัติงานต่อเนื่อง 7 ปี เห็นการเติบโตของตำแหน่งได้ชัด
- มีการกล่าวถึง Sap ซึ่งเป็นสิ่งที่ HR สายนักพัฒนา SQL ให้ความสำคัญ
- ประสบการณ์ 5 ตำแหน่ง ไล่ระดับจาก Junior ขึ้นไปจนถึงตำแหน่งปัจจุบัน
- Professional Summary กระชับ ใช้คำที่สื่อความสามารถได้จริง
- มีทักษะแยกเป็นหมวด 40+ รายการ ให้ HR เห็นสเปกครบถ้วน
Professional Summary
* 7+ years of experience in Database Administration and Developer for very large and complex databases in SQL Server 2012, SQL Server 2008 R2, 2008 and 2005. * 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. * Expertise in T-SQL writing stored procedures, triggers and functions. * Administering SQL Server High Availability and Disaster Recovery strategies. * Expert in data transformation services like SSIS, DTS, BCP and Bulk Insert. * Implemented the new SQL Server 2012 mechanisms like data compressions, online indexing, Contained Databases, security principals and AAG. * Worked on logical and physical data base modeling with UML and ERWIN tools. * 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. * Experience in Disaster Recovery Planning and Security Management operations. * 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. * Worked on configuring SQL Server with minimum privileged access. * Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels. * Troubleshoot performance problems, fine-tuning of databases and index Analysis. * Worked on SQL Server 2012 migration from SQL Server 2008/2005. * Experience on 64 bit SQL Server 2012 / SQL Server 2008 R2 systems and MSCS Configurations. * Maintained individual service accounts for SQL Server services on cluster with different Security groups to raise security mark. * Having Experience on Data center servers and handling 1.4 TB databases.* Handling Memory configurations for SQL Server 2012 and SQL Server 2008 on Windows 2008. * Experience in Batch processes, Import, Export, Backup, Database Monitoring tools and Application support. * Created Linked Servers between SQL Server 2008 R2 & Oracle 9i and 10g. Also created DTS package for data transfer between the two environments. * Working knowledge in Analysis Services(SSAS), Reporting Services (SSRS) and Clustering. * Experience in supporting Very Large databases (VLDB) and troubleshooting the problems. * Strong experience in mentoring team members and writing documentation. * 24 X 7 Production Database on Call Support
Highlights
- Technical Expertise Databases: MS SQL Server 2012, 2008, MS SQL Server 2005 Programming: Visual Basic 6, Visual Basic 5, C, C++ & SQL DBA: database administration of MS SQL Server 2012,2008, 2005 Operating System: Windows 2008/2003 Advanced Server, NT & Windows 9x, Linux Other Software: Windows 2008/2003 Advanced Server, NT & Windows 9x, Linux Tools: Backup Utility, SQL LiteSpeed, Visio Network Topologies: TCP/IP, DNS, WINS, DHCP, FTP, SNMP, SMTP
- Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities
Experience
SQL Server DBA06/2009 - 07/2013
Cognizant Technology Solutions
- Responsibilities * Migrated SQL server 2008 to SQL Server 2012 in Microsoft Windows Server 2012 Enterprise Edition. * Installed and administered Eight-Node cluster Active/Passive on Microsoft Windows Server 2012 Enterprise Edition on SAN environment. * Migrated SSIS packages from SQL Server 2008 R2 to SSIS 2012. * Extensively worked on SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS). * Expert in Using DMVs, Performance dash board, Mirroring, database snapshots and tracking Performance Counters. * 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. * Involved in Source Data Analysis, analysis and designing mappings for data extraction also responsible for Design and Development of SSIS Packages to load the Data from various Databases and Files. * Experience in using SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor(DTA). * Expert in implementing the snapshot isolation and DDL triggers. * Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases. * Implemented Data partitioning. Error Handling through TRY-CATCH-THROW statement, Common Table Expression (CTE). * Performed installation of SQL Enterprise 2012 SP1 CU 5 64bit version on Windows 2012 Sp1 Clusters (HP servers in enterprise Data Centers). Environment: SQL Server 2008/2012 Enterprise, Windows Enterprise Server 2012, .NET, Microsoft Visio, SFTP, Microsoft Reporting Services.
SQL Server DBA12/2007 - 05/2009
Cognizant Technology Solutions
- Responsibilities * Perform business analysis, technical analysis, systems design, application software programming." Prepared DFD's & Entity Relationship (ER) diagrams. * Restructuring the stored procedure, designing, coding and developing the same using the TSQL Programming * Transferring the data (ETL) to Data warehouse (Informatica) by SSIS. * Extensively worked on Dynamic Management Views in SQL Server 2005. * Installed, authored, and managed reports using SQL Server 2005 Reporting Services. * Managed the migration of SQL Server 2000 databases to SQL Server 2005. * Monitoring SQL server performance using SQL Profiler to find performance and dead locks. * Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS. * Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor. * Extensively worked on Data Partitioning and Snapshot Isolation in SQL Server 2005. * Re-engineering Customer Cognos and People Soft modules into SQL Server 2005 Integration Services. * Prepared the project management and technical documentation. * Unit Testing the SSIS packages with respect to its flow and performance issues. * Solving the Bugs Reflected by the Testing team. * Rebuilding the indexes at regular intervals for better performance. * Monitored and modified Performance using execution plans and Index tuning. * Rebuilding the indexes at regular intervals for better performance. * Managing the VERITAS net backups. * Extensively worked DBCC commands and Dynamic Management Objects. * Expertise in SQL Server Reporting Services and SQL Server Analysis Services. * Involved in trouble shooting and fine-tuning of databases for its performance and concurrency. * Complete documentation about the database. Recovering the databases from backup in disasters. * Export or Import data from other data sources like flat files using Import/Export through DTS, SSIS. * To analyze long running slow queries and tune the same to optimize application and system performance. *To set up SQL Server configuration settings for better server management. * Monitoring the servers using Idera third party software. * Worked on SQL Server tools Like Enterprise Manager and SQL Query Analyzer. Environment: SQL Server 2008/2005, Oracle 10g/91, .Net Framework 2.0, C#.Net, Asp.Net2.0, JavaScript, VSS, Windows 2000, Windows 2003 Server, MS TFS, MS-Access.
Database Administrator / Kipp Houston Public Schools - Houston, TX10/2007 - 12/2007
- Responsibilities:* Database Administrator, Database Programming. * Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users. * Rebuilding the indexes at regular intervals for better performance * Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented. * Involved in trouble shooting and fine-tuning of databases for its performance and concurrency. * Monitored and modified Performance using execution plans and Index tuning. * Rebuilding the indexes at regular intervals for better performance. * Deploying new code base release to UAT and Production Environments. * Perform SQL Server service pack and Windows Service pack upgrades. * Working with customers on Application rollouts and server migrations. * Extensively worked on Enterprise Manager for managing the database. * Troubleshoot performance problems and fine-tuning of databases. * Involved in Index Analysis and Performance Tuning. * Worked with different upstream team for downloading ETL MART data. * Converting DTS packages into SQL Server 2005 Integration Services. * Migrating SQL Server 2000 data bases into SQL Server 2005. * Recovering the databases from backup in disasters. * To analyze long running slow queries and tune the same to optimize application and system performance. Environment: SQL Server 2005, SQL Server 2000, Windows 2003/2000 Server, SQL LiteSpeed 4.5, MSE, ME Change Request, Visio. Enterprise Manager, SQL Query Analyzer, SQL Profiler.
Mid-level Database Administrator07/2006 - 09/2007
Icf International, Inc
- Responsibilities: * Installing SQL Server with minimum access privileges service account to improve security and to attain high ratings in SOC audits. * Installed, configured SQL Server 2005 Clustering on Microsoft Clustering services (MSCS) from Hardware inventory to test environment. * Involved in Analyzing and Upgrading SQL Server 2000 test servers to SQL Server 2005. * Having experience on SAN and RAID levels and building SQL Cluster servers on SAN Environments. * Perform SQL Server service pack and Windows Service pack upgrades. * Designed and implemented comprehensive Backup plan using SQL LiteSpeed. * Resolved and tweaked memory pressures caused during product release. * Worked with customers on Application rollouts and server migrations.* Troubleshoot performance problems and fine-tuning of databases. * Expertise in designing databases and capacity planning. * Rebuilding the indexes at regular intervals for better performance. * Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented. * To provide 24x7 production support for SQL Server databases on Clustered Servers with sizes ranging from 1 to 2 Terabytes to achieve maximum performance and uptime in production environment. * Worked extensively in Query analyzer and profiler for tuning queries using variable for characteristics and query costs. * Monitored and modified Performance using execution plans and Index tuning. * Transferring the data (ETL) to Data ware house by SQL Server 2005 Integration Services. * Rebuilding the indexes at regular intervals for better performance. * Involved in trouble shooting and fine-tuning of databases for its performance and concurrency. * Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented and Scheduled Replication process for updating our parallel servers. * Designed and created databases, tables, views, store procedures and triggers. Environment: SQL Server 2005 and SQL Server 2000, Windows 2003/2000 Server, SQL LiteSpeed 4.5, MSE, VSS and Password Updater.
Junior SQL Server DBA03/2005 - 07/2006
Hartford Life Insurance
- Responsibilities: * Monitoring the server for High availability of the servers. * Solving the request raised by user support. * Participate in implementation of new releases into production. * Facilitates application deployment and joint effort deployments. * Meet the SLA (Service Level Agreement) established. * Day-to-day administration of live SQL Servers. * Designed and implemented Security policy for SQL Servers. * Used Stored Procedures, DTS packages, BCP for updating Servers. * Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented and Scheduled Replication process for updating our parallel servers. * Automated messaging services on server failures, for task completion and success. * Execute procedures to accomplish short-term business goals. * Deploying Administration tools like SQL DB Access, Performance Monitor and Backup Utility. * Deploying monitoring tools like Sitescope and spot light. * Table partitioning to improve I/O access. * Enforce Database Security by Managing user privileges and efficient resource management by assigning profiles to users. * Using database level triggers code for database consistency, integrity and security. * Tested and Implemented procedures to detect poor database performance, collecting required information, root cause analysis. Environment:SQL Server 2000/7.0, IIS, Windows 2003/2000 Server, SQL DB Access, Performance Monitor, Backup Utility, MOM, MSE and Sitescope.
Education
- Bachelors: Electronics and Communication Engineering
- University of Madras - Madras, TAMIL NADU
- Bachelors in Electronics and Communication Engineering, University of Madras, India
- Masters: springfield · Computers and Information Systems Universty of Illinois
- Masters in Computers and Information Systems Universty of Illinois, springfield(US) · CTS CTE
Skills
DatabaseMicrosoft WindowsMs Sql ServerSqlSql ServerDatabasesIntegrationIntegratorIts.netDatabase EngineSanStorage Area NetworkVisioData AnalysisData ExtractionDdlFileMarketing AnalysisMicrosoft SsrsMicrosoft VisioSapSftpSolutionsSsrsStatisticsAccessAnalyzerEtlExtractTransformVssDisaster RecoverySecurityReplicationAnalysis ServicesApplication SoftwareAspBackupsBusiness Analysis
สรุปว่าจะได้อะไรจากตัวอย่างนี้
ตัวอย่างนี้ช่วยให้เห็นแนวทางการเขียนเรซูเม่สำหรับตำแหน่ง CAREER OVERVIEW ประสบการณ์ 7 ปี โดยเปิดด้วยบทสรุปที่บอกจุดเด่นของผู้สมัคร ตามด้วยประสบการณ์ทำงาน 5 ตำแหน่ง และข้อมูลการศึกษาที่จำเป็น พร้อมทักษะที่เกี่ยวข้องกับงาน คุณสามารถนำลำดับและวิธีนำเสนอไปปรับใช้ โดยเปลี่ยนรายละเอียดให้ตรงกับประสบการณ์จริงของคุณ
อย่างไรก็ตาม เรซูเม่ที่ชนะต้องเขียนให้ตรงตำแหน่งที่คุณสมัครโดยเฉพาะ ตัวอย่างนี้คือต้นแบบ ไม่ใช่สำเนา ทีมเรซูเม่ของเรารับเขียน Resume และ Cover Letter ภาษาอังกฤษให้โดดเด่นจากคู่แข่ง ส่งงานใน 2 วัน รับประกันความพึงพอใจ