Yyyyyy x. yyyyyy

xxxxxx South District Dr., #0000 xxxxxx xxxx , xxxx , xxxxx 00000 (xxx-xxx-xxxx abc@xyz.com

Microsoft SQL Server SQL Server Integration Services Transact SQL

SSIS Package Development IBM iSeries UDB Troubleshooting User Relations

         16+ years experience administering Microsoft SQL Server database relational management systems, CRM tools, ERP systems, point-of-sale (POS) software solutions, and accounting systems.

         Adept at design and development of SSIS and DTS packages, RDBMS design, performance tuning, and scripting via C#, Visual Basic, and JavaScript.

         Well-versed in Agile development principles, database security, and OLTP/OLAP technologies.

         Excel at design, development, and support of MS SQL Server in production, test, development and cluster server environments.

         Solid understanding of high availability SQL Server solutions, including replication models, change data, Change Data Capture, and SQL Server clustering (i.e. active-active, active-passive).

         Possess extensive experience throughout complete software development life cycle.

• Constantly focus on optimizing application performance, reliability, security, and usability.
• Extremely well-versed in applying regular backup procedures to protect and defend vital information.

Prime Insurance Group, 2017 to Present

Database Administrator

         Support MS SQL Server 2000, 2005, 2008, 2008r2, 2012, 2012r2, 2014, and 2016 as primary DBA tasked with ensuring optimally functioning databases for 130 end users.

         Create SSIS packages to support ETL processes, and employ SQL Server Management Studio and Visual Studio for development, maintenance, user management, and performance monitoring/tuning.

         Revamped replacement and maintenance plans for all production instances to improve performance of SQL Server environments.

         Administer VMWare virtual desktop, monitor SQL Server instances, and proficiently support four Web Services servers comprising MS SQL Server and MySQL backend database management systems.

         Methodically review metrics reports and historical trends to augment performance tuning.

         Formulate, implement, and maintain backup and disaster recovery strategies.

Extra Space Storage, 2016

Database Administrator

         Independently administered hundreds of production and development databases to support 300+ corporate users and thousands of users in the field.

         Deployed and tested development environment for retail software utilizing Change Data Capture to enhance existing ETL solutions.

         Teamed with management and developers to perform data modeling of new Point of Sale (POS) software solution, and established best practices for migrating legacy data to new POS system.

         Analyzed, revamped, and markedly improved current SQL Server security infrastructure.

         Designed, developed, and maintained queries, stored procedures, user defined functions, and other database objects to support and optimize business operations.

         Designed and maintained ETL jobs for data warehouse and other data exchange processes.

Continued ►

Yyyyyy x. yyyyyy -- Page 2 of 2

Oracle Corporation of America, 2010 to 2016

Implementation Consultant Level III

         Provided comprehensive and specialized support to clients including design and development of SSIS packages, migrating legacy DTS packages to SSIS, and deploying legacy DTS packages and SSIS packages using MS SQL Server Agent Job Scheduler.

         Clarified client needs and practiced ongoing follow-up to ensure satisfaction and problem resolution.

         Performed nightly after-hour maintenance events for clients including database maintenance, backups, applying server patches, and deploying software upgrades and/or patches.

         Resourcefully designed, implemented, and maintained SharePoint site to house internal documentation for department, significantly enhancing efficiency.

Sundance Catalog Compaxxxxxx, 2000 to 2010

Manager of Catalog Technologies (2006 to 2010)

         Steadily advanced through a series of promotions to oversee all facets of catalog technologies including strategic planning, vendor relations, workload optimization, project supervision, staff training, system mitigations, software upgrades, and continuous improvement.

         Directed, coached, mentored, and supervised Database Administrator, iSeries System Operator, and Midrange Computer Programmer.

Senior Systems Administrator Programmer Analyst (2003 to 2006)

         Headed performance tuning, backups, and routine software and hardware maintenance for corporate data warehouse, MS SQL Server, Oracle database, CRM/ERP, and UDB database.

         Designed, developed, and maintained SSIS packages and DTS packages to facilitate seamless data transformation and ETL processes.

Midrange Computer Programmer Level I (2000 to 2003)

         Leveraged solid expertise in requirements gathering, solution design and development, testing, debugging, implementation, and maintenance to solve a wide range of business needs and issues.

         Communicated with end users to discuss requirements and pinpoint deficiencies with existing systems.

         Performed data mining on system of record querying iSeries UDB database or data warehouses/OLAP server (MS SQL Server) to gather data and generate reports for applicable departments.

BS, Information Technology, University of Phoenix

AAS, Midrange Computer Programming, Saint Cloud Community College

Operating Systems: IBM iSeries, Windows Server/advanced server, Windows, Vista, some Linux/Unix

Database Tools: SQL Server Management Studio (SSMS), Business Intelligence Developer (BIDS), Visual Studio, SQL Profiler, SQL Server Service Agent, Job Scheduler, SQL Server Integration Services (SSIS), Legacy DTS Designer, Query Analyzer, DB Mail, SAP Data Services, SAP Business Objects, SQL Server Reporting Services, Spotlight, SQL Tool Belt

Languages & Programming: VBScript, VB.NET, Transact SQL (T-SQL), RPG ILE, Visual RPG, CL, C#, Java, JavaScript, Java Server Pages (JSP), HTML, XML, VBScript, MS-DOS scripting, JavaScript, WSDL

Web Server: Apache Tomcat, MS Internet Information Services

Databases: MS SQL Server 2000/2005/2008/2012/2014, limited exposure to Oracle

Other Software & Tools: MS Visual Source Safe, Tortoise, Aldon, MS Team Foundation Services, GIT, ProClarity, MS Reporting Services, OLAP plugin for Visual Studio, SAP Business Objects, MS Power BI, Office 365, MS Teams, Slack, Postman, Skype

Yyyyyy x. yyyyyy

xxxxxx South District Dr., #0000 xxxxxx xxxx , xxxx , xxxxx 00000 (xxx-xxx-xxxx abc@xyz.com

[INSERT DATE]

[HIRING MANAGER S NAME]

[COMPAXXXXXX]

[ADDRESS]

[CITY, STATE, ZIP CODE]

Dear Hiring Manager:

I am seeking a career opportunity as a Database Administrator and am submitting my resume for your review.

I am excited to build a rewarding career with your organization, and can offer more than 15 years of experience in the IT industry with specialization in MS SQL Server technologies, SQL Server Integration Services, and Transact-SQL. I am also well-versed in performance tuning, scripting, database security and RDBMS design, among other areas.

Currently I am a Database Administrator at Prime Insurance where I work extensively with MS SQL Server, SSIS, SQL Server Management Studio, Visual Studio, T-SQL, and VMWare. I am also charged with devising, implementing, and administering robust backup and disaster recovery strategies to safeguard critical compaxxxxxx information. I excel at driving high-impact process improvements and possess exemplary talents in end user relations, system upgrades, migrations, and project coordination.

As this is just a summary of my qualifications, please refer to the accompaxxxxxxing resume for additional experience. I look forward to speaking with you personally, as I believe the sum of these aforementioned reasons will prove me to be an asset to your organization. Thank you for your consideration.

Sincerely,

Yyyyyy x. yyyyyy