LiveCareer-Resume

database administrator resume example with 15+ years of experience

Jessica Claire
  • , , 609 Johnson Ave., 49204, Tulsa, OK 100 Montgomery St. 10th Floor
  • Home: (555) 432-1000
  • Cell:
  • resumesample@example.com
Professional Summary

Talented Database Administrator with over 10 years of diverse experience in database design and administration, data modeling, data warehousing, Enterprise Systems Architecture and Business Intelligence (BI). Talented at working effectively in collaborative and self-motivated environments.

Skills
  • Database Optimization
  • Writing Queries
  • Administering Databases
  • SQL Server Integration Services (SSIS)
  • SQL Server Reporting Services (SSRS)
  • Extraction Transformation and Loading (ETL)
  • Performance Evaluation and Optimization
  • Data Warehousing and Analytics
Work History
Database Administrator, 04/2018 to 09/2022
Spencer Gifts, LlcOrlando, FL,
  • Administered, supported and monitored databases by proactively resolving database issues and maintaining servers.
  • Created and implemented database designs and data models.
  • Administered, supported and monitored OLTP and OLAP SQL Server 2014 & 2017 on Windows servers and also supported multiple concurrent projects enabling delivery efficiencies and technical resolution.
  • Performed database backups and restores within same sever and also between different environments using SSMS and also using PowerShell scripts
  • Created and implemented database designs and data models using Visual Studio
  • Monitored, Investigated and troubleshooted database issues such as blocking and deadlocking,
  • Created and maintained complex T-SQL scripts and objects in multi environments such as stored procedures, user-defined functions and views per business requirements and participated T-SQL code review and provided performance improvement feedback.
  • Designed, developed, deployed, and monitored complex data pipelines using SSIS and ensured data quality and integrity using Redgate Data Compare tool.
  • Set up and controlled user profiles and access levels for SQL Server database and also SAS environments to protect important data
  • Monitored database activity and files usage, and ensured necessary resources are available to prevent any foreseeable performance issues.
  • Created, scheduled and maintained scheduled jobs for snapshots, SSIS packages, etc.
  • Participated Agile development methodologies such as daily stand-ups, weekly/monthly sprint planning, and retrospective meetings and provided project estimates and task required for database activities.
  • Created and maintained technical documentation, functional documentation, data flow diagrams and data mapping documents.
  • Performed data mapping conforming standard and data modeling, and ETL large volume of multi-source data to data warehouse ensuring data quality and integrity
Database Administrator, 04/2017 to 04/2018
Spencer Gifts, LlcOswego, IL,
  • Lead DBA for SQL Server 2008 R2 servers to SQL 2014 SP2 upgrade efforts following standard practices for migrating changes to test and production environments and provided technology support to meet business requirements.
  • Performed SQL Server Reporting Services (SSRS) 2016 installation and configuration
  • CIS Security Benchmark scans and SQL Server security configuration modification to achieve minimum score of 85%
  • Developed SQL queries using Oracle SQL Developer for statistical and graphical reporting purposes and also create interfaces with reporting applications using either SQL Server or Oracle databases.
  • Managed and troubleshoot SSRS reports, scheduled jobs and SSIS packages
  • Automated deploying SSRS reports and purging bulk data
  • Performed upgrade SQL Server from 2012 to 2016 on Windows server and Eliminated downtime by accurately implementing upgrade.
  • Performed database backups and restores within same sever and also between different environments using SSMS and also using PowerShell scripts
  • Administered, supported and monitored databases by proactively resolving database issues and maintaining servers
SR. PROGRAMMER ANAYLYST, 05/2010 to 04/2017
Associated BankWisconsin Rapids, WI,
  • Analyzed and designed relational databases using Visual Studio.
  • Worked closely with clients to establish specifications and system designs.
  • Performed regression and system-level testing to verify software quality and function prior to release.
  • Lead developer for defining architecture and developing FLOC / R07 application for OFM that leverages on ASP.NET Model-View-Controller Framework with MVC 3 and Entity Framework with EF 4, which uses SQL Server 2008 as database as well as interfaces with Oracle.
  • Participated in database design, data conversion, system testing and E2E testing for applications interface with Statewide Integrated Governmental Management Applications which is replacement of state's enterprise-wide financial system using the following technologies: Visual Studio 2010 Ultimate with Team Foundation Server (TFS), .Net Frameworks 4.0/3.5/2.0 with C# & ASP.Net, ADO.Net, SQL Server 2008, AJAX (JavaScript, XML, HTML with CSS).
  • Provided support for mission-critical State Aid Management System (SAMS) financial application with SQL database support for Integration (SSIS), Reporting (SSRS), and other Service-Oriented Architecture (SOA) services.
  • As lead developer performed requirements gathering/analysis and SUITE documentation, designing, developing, testing, and implementation of Payroll Projections system that tracks MDE employee positions and projects payrolls for current and upcoming fiscal year. Application leveraged on ASP.NET Model-View-Controller Framework with MVC 3 and Entity Framework with EF 4.1, which uses SQL Server 2008 as database and interfaces with Oracle as well.
  • Designed and developed critical SSRS reports for multiple projects.
  • Developed proof-of-concept prototypes before full-blown systems design is started on key features.
  • Complied with SUITE software processes including adoption of Agile development methodologies such as daily stand-ups and review/retrospective meetings.
Systems Analyst, 05/2007 to 05/2010
State Of Michigan, DTMB Agency Services - TreasuryCity, STATE,
  • Resolved or escalated problem tickets to resolve user issues.
  • Performed system analysis, documentation, testing, implementation and user support for platform transitions.
  • Planned and conceived computer systems using information engineering, data modeling and structured analysis.
  • Resolved malfunctions with systems and programs through troubleshooting.
  • Analyzed and defined business requirements, functional designs, technical designs, testing scripts for mainframe systems, client-server applications, and web-based applications for special taxes division.
  • Created project charter, project estimation, work breakdown structure and project plan.
  • Designed and implemented system architecture.
Education
Master of Science: Information Science, Expected in 08/2000
University of Pittsburgh - Pittsburgh, PA
GPA:

By clicking Customize This Resume, you agree to our Terms of Use and Privacy Policy

Your data is safe with us

Any information uploaded, such as a resume, or input by the user is owned solely by the user, not LiveCareer. For further information, please visit our Terms of Use.

Resume Overview

School Attended

  • University of Pittsburgh

Job Titles Held:

  • Database Administrator
  • Database Administrator
  • SR. PROGRAMMER ANAYLYST
  • Systems Analyst

Degrees

  • Master of Science

By clicking Customize This Resume, you agree to our Terms of Use and Privacy Policy

*As seen in:As seen in: