We provide IT Staff Augmentation Services!

Database Administrator Resume

5.00/5 (Submit Your Rating)

Pensacola, FL

PROFESSIONAL SUMMARY:

Over 15 years of experience in IT fields ranging from systems administration, database administration, education, hardware maintenance, help - desk support, programming and web design.

AREAS OF STRENGTH:

  • SQL Server Installation and Implementation Disaster Recovery Database Security
  • SQL Querying Backup & Restore MySQL PHP Data Forms
  • Replication Log Shipping
  • Database Maintenance

TECHNICAL COMPETENCIES:

  • Database administration including installation, configuration, upgrades, capacity planning, performance tuning, backup and recovery, index maintenance in a fast pace environment.
  • Manage the production and development databases including performance tuning, capacity planning, SQL Server clustering, database security configuration, and database continuity.
  • Knowledge of High Availability of database servers using Database mirroring, replications, and Log Shipping.
  • Design and implement SQL Server 2014 databases for mission-critical business.
  • Knowledge of Disk and Server configuration through Raid for SQL Server.
  • Use SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and SQL code.
  • Develop and modify stored procedures, queries, triggers, views, indexes, and functions to handle business rules, history data and audit analysis.
  • Use Data Transformation Services (DTS)/SQL Server Integration Services (SSIS) and Extract Transform Loading (ETL) tools of SQL Server to populate data from various data sources, creating packages for different data loading operations for application.
  • Configure and support SSIS and SSRS for SQL Server 2014.
  • Troubleshoot databases and custom application issues.
  • Knowledge acquired to work with end users to define, implement, and maintain their reporting requirements.
  • Assists in the design, coding, testing and implementation of high volume transactional (OLTP) SQL databases instances.
  • Develop and document SQL coding guidelines.
  • Generate the weekly, monthly, and quarterly report by using SQL Standard Report.
  • Create reports that ran daily for jobs running in SQL Server Agent.
  • Knowledge with monitoring and troubleshooting in 24x7 operations.

PROFESSIONAL EXPERIENCE:

Confidential, Pensacola, FL

Database Administrator

Responsibilities:

  • DBA for many production servers totaling several terabytes of databases
  • Specialized in disaster recovery and maintenance
  • Wrote stored procedures and backup/restore scripts for automation
  • Created and maintained transactional replication for multiple servers
  • Assisted developers in optimizing SQL code and procedures

Confidential, Pensacola, FL

SQL Developer/Analyst

Responsibilities:

  • Served as SQL Server DBA as 3rd party app transitioned to Postgres Cloud storage
  • Assist in maintenance of FOCUS student information system
  • Assist in maintenance and administration of multiple SQL Server instances
  • Write T-SQL queries to develop FOCUS reports using SQL Server
  • Tune SQL queries in FOCUS for performance in SQL Server
  • Write triggers in SQL Server database to add functionality to FOCUS
  • Convert SQL Server queries, triggers and functions to PostgreSQL

Confidential, Fayetteville, GA

Systems Administrator, Database Manager, Office Administrator

Responsibilities:

  • Create and maintain multiple online web-based training systems for instructing Customer Service and Management/Executive Training for credit unions
  • Create and maintain MySQL databases
  • Create MySQL based web-apps for Confidential staff
  • Maintain computer networks and equipment for small business
  • Manage service projects and client relations for small business

Confidential, Jonesboro, GA

Computer Teacher

Responsibilities:

  • Taught basic computer operation, web design and business apps
  • Created and maintained school communications presence online, including websites and local VOIP phone system
  • Served as help-desk support for school staff
  • Served as local network admin

Confidential, Pensacola, FL

Duty Officer

Responsibilities:

  • Telecommunications via radio and computer
  • NCIC/FCIC Computer operator
  • Public service contact via telephone

We'd love your feedback!