SUMMARY:

To obtain a Senior SQL Server Database Administrator position which requires responsibility and challenge with an opportunity for advancement and personal development.

EXPERIENCE:

Confidential

Senior SQL Server Database Administrator, Phoenix, Az

Responsibilities:

• Monitor all environments to ensure optimal performance
• Setup, monitor and test backups to ensure minimal exposure and maximum recoverability
• Provide performance tuning using SQL Server Management Studio (SSMS), Dynamic management views\functions and SQL Server Profiler (depending on version)
• Server resource utilization and monitoring using Windows Perfmon
• Install, configure and manage active\passive clusters
• Migrated all database servers from SQL Server 2000 to 2012
• Setup, manage and monitor replication and log shipping
• Provide daily reports outlining the health of each server
• Provide statistical reporting for top SQL statement by duration, IO, CPU and frequency
• Provide guidance, assistance and training to developers
• Provide capacity planning for all environments
• Provide high availability options for critical data
• 24x7 on call

Confidential

Senior SQL Server Database Administrator, Phoenix, Az

Responsibilities:

• Version: 2008 R2
• Provide all aspects of SQL Server support, including:
• Execute all requests using Remedy ITSM
• Setup, troubleshoot, manage log shipping
• Server resource utilization and monitoring using Windows Perfmon
• Provide performance tuning recommendations using SQL Server Management Studio (SSMS),
• Dynamic management views\functions and SQL Server Profiler
• Backup and restore across environments in support of development and QA
• Participate in 24x7 on call rotation

Confidential

Senior SQL Server Database Administrator, Phoenix, Az

Responsibilities:

• Versions: 2000, 2005 and 2008 R2
• Created, tested and documented a backup solution to replace existing backup implementation
• Created, tested and documented a backup, job and index maintenance summary and exception reporting solution
• Provide performance tuning recommendations using SQL Server Management Studio (SSMS), Dynamic management views\functions and SQL Server Profiler

Confidential

Senior SQL Server Database Administrator, Phoenix, Az

Responsibilities:

• Versions: 2000, 2008 R2 and 2012
• Monitor all environments to ensure optimal performance
• Setup, monitor and test backups to ensure minimal exposure and maximum recoverability
• Provide performance tuning using SQL Server Management Studio (SSMS), Dynamic management views\functions, Enterprise Manager, Query Analyzer and SQL Server Profiler (depending on version)
• Server resource utilization and monitoring using Windows Perfmon
• Install, configure and manage active\passive clusters
• Migrated all database servers from SQL Server 2000 to 2008 R2
• Setup, manage and monitor log shipping
• Setup, manage and monitor SQL Server 2012 mirroring
• Provide daily reports outlining the health of each server
• Provide statistical reporting for top SQL statement by duration, IO, CPU and frequency
• Provide guidance, assistance and training to developers
• Provide capacity planning for all environments
• Provide high availability options for critical data
• 24x7 on call

Confidential

Senior SQL Server Database Administrator, Phoenix, Az

Responsibilities:

• Version: 2005
• Monitor all environments to ensure optimal performance
• Setup, monitor and test backups to ensure minimal exposure and maximum recoverability
• Provide performance tuning using SQL Server Management Studio (SSMS), Dynamic management views\functions and SQL Server Profiler
• Server resource utilization and monitoring using Windows Perfmon
• Provide capacity planning for all environments
• Provide high availability options for critical data
• Provide daily reports outlining the health of each server
• Provide statistical reporting for top SQL statement by duration, IO, CPU and frequency
• 24x7 on call

Confidential

Senior SQL Server Database Administrator, Phoenix, Az

Responsibilities:

• Performance Tuning
• Backup\Recovery
• Installation and Configuration
• Index Tuning
• Disaster Recovery
• High Availability using clustering, log shipping, mirroring and replication
• Monitoring

Confidential

Senior SQL Server Database Administrator, Phoenix, Az

Responsibilities:

• Performance Tuning
• Backup\Recovery
• Clustering
• Installation and Configuration
• General Troubleshooting
• Index Tuning
• Disaster Recovery
• High Availability
• Log Shipping
• Mirroring
• Monitoring

Senior SQL Server Database Administrator

Confidential, Phoenix, Az

Responsibilities:

• Monitor all environments to ensure optimal performance
• Setup, monitor and test backups to ensure minimal exposure and maximum recoverability
• Provide performance tuning recommendations using SQL Server Management Studio (SSMS), Dynamic management views\functions and SQL Server Profiler
• Server resource utilization and monitoring using Windows Perfmon
• Provide capacity planning for all environments
• Provide high availability options for critical data
• Install, configure and manage active\passive clusters
• Migrated all database servers from SQL Server 2005 to 2008 R2
• Provide daily reports outlining the health of each server
• Provide statistical reporting for top SQL statements by duration, IO, CPU and frequency
• Provide database (schema) synchronization between development, quality assurance, staging, load testing and production environments
• Table and index partitioning
• 24x7 on call

Senior SQL Server Database Administrator

Confidential, Scottsdale, Az

Responsibilities:

• Monitor all environments to ensure optimal performance (approximately 80 servers and 1100 databases)
• Setup, monitor and test backups to ensure minimal exposure and maximum recoverability
• Provide performance tuning recommendations using SQL Server Management Studio (SSMS), Dynamic management views\functions, Enterprise Manager, Query Analyzer and SQL Server Profiler (depending on version)
• Server resource utilization and monitoring using Windows Perfmon
• Provide capacity planning for all environments
• Provide high availability options for critical data
• Install, configure and manage active\passive clusters
• Provide daily reports outlining all database errors

Senior SQL Server Database Administrator

Confidential, Phoenix, Az

Responsibilities:

• Provide database administration support for off - site clients
• Support off site clients regarding Sarbanes-Oxley

Senior Database Administrator

Confidential, Phoenix, AZ

Responsibilities:

• Monitor all environments to ensure optimal performance
• Setup, monitor and test backups to ensure minimal exposure and maximum recoverability
• Provide performance tuning recommendations using Enterprise Manager, Query Analyzer and SQL Server Profiler
• Server resource utilization and monitoring using Windows Perfmon
• Migrate all database servers from SQLBase 6.1 to SQL Server 2000
• Provide guidance, assistance and training to developers
• Provide capacity planning for all environments
• Familiar with implementing Sarbanes-Oxley compliance including:
• Documentation requirements
• Use of Ticking systems for problem resolution
• Use of Exchange to store all ticketing information in public folders