Sql Server Database Administrator
Resume:
FRITZ DESVARIEUX
*********@*****.***
PROFILE:
* ***** ** ********** ** a Microsoft SQL Database Administrator responsible for the configuration, administration, monitoring and maintenance of SQL Server databases. I am also responsible for data migration, database mirroring, disaster recovery, integration services, performance tuning, reporting services, troubleshooting performance issues, database upgrades, patching, backup and restore, disaster recovery, database security and high availability solutions. I have experience with third party tools such as Lite Speed, spotlight and Idera.
CERTIFICATIONS:
Microsoft Certified Database Administrator (MCDBA)
Microsoft Certified System Engineer (MCSE, MCSA)
TECHNICAL CONCEPTS:
Databases : Sql Server 2005,2008,2008R2,2012,2014 and Access Database
Networking/Communications: LAN, WAN, routers/switches, voice, data, TCP/IP, VPN
Operating Systems: Windows Server 2008/2012, UNIX, Active Directory
DBA Workshops: T-SQL, SQL Server 2005 & 2008 R2 and 2012 High Availability Solutions
EXPERIENCE:
SQL Server Database Administrator 2011-Present
Next Media Inc., Atlanta GA
Performs database administration activities including; installation, configuration and space management
Environment consisted of SQL Server 2005, 2008, 2008R2 and 20012
Troubleshooting slow running queries
Proactive and active performance monitoring and tuning of production databases resolving concurrency issues (blocking,locking,deadlocks)
Maintains database performance by evaluating current performance, adjusting values for database parameters and configuring metrics for meaningful alerts.
Making copies of databases for development and production testing
Developing Backup strategies and recovery solutions
Developing reports using SQL Server reporting services
Database maintenance tasks (rebuilding and reorganizing indexes, updating statistics, running integrity checks
Data migration and database upgrading
Developing packages and backup database using integrated services (SSIS)
Setting up and administering security (creating sql server logins, assigning appropriate server, database and schema roles and permissions
Working with developers,support and QA team to maintain all database environment
Creating and automating maintenance jobs and backup
Creation of stored procedures,triggers, tables, functions and indexes
High availability solutions
Setting up and monitoring Replication(transactional,snapshot and merge)
Setting up and monitoring Database Mirroring and log shipping
Administering sql server on windows cluster (active/passive)
Perform technical analysis and troubleshooting on complex database problems
Administers, maintains, develops and implements policies and procedures for ensuring the security and integrity of the company database.
Assists Developers with debugging, performance tuning and ensuring that best practices for database transactions are being met
Jr. Database Administrator 2009-2011
HMBI Atlanta, GA
Developing backup strategies and recovery solutions
Perform database administration tasks including; Installation, Configuration, Upgrades, Capacity Planning, Performance Tuning, Backup and Recovery.
Data Analysis - importing/exporting via (frontend/backend) processes, extracting large amounts of data, creating tables and databases, cleansing and analyzing data.
Retrieving data from the database using excel spreadsheet
Creating and formatting reports using access, excel (pivot tables, v-lookup, etc.) and PowerPoint
Data validation and consistency check
Handling ETL processes using SQL Server integration service(SSIS)
Troubleshooting maintenance job failures
Developing reports using SSRS
Exporting data from production to our reporting data warehouse
Using Event Viewer,Perfmon and Task manager to troubleshoot windows issues as it relates to Sql server
Schedule Maintenance Jobs and Backups
Monitoring transactional replication Resolved SQL Server query issues and perform SQL Server query tuning
Developing tabular, matrix and parameterized reports with SSRS
EDUCATION:
Florida Atlantic University, Boca Raton, FL
Bachelor of Computer Science, Network, Communications Management
Microsoft Office Suite (Word, Excel, Powerpoint, outlook) Unix/Linux, PowerShell
GPA: 3.5/4.0 - Deans List
Gwinnett Technical College, Lawrenceville GA
Associates Degrees, Computer Application and Network Administration
Networking/Communications: LAN, WAN, routers/switches, voice, data, TCP/IP, VPN
Contact this candidate