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