SQL Server Database Administrator Resume TX - Hire IT People

SUMMARY

TECHNICAL SKILLS

SQL Server 2008 R2, SQL Server 2012, SQL Server 2014

SQL Replication, SQL Clusters, SQL MirroringSQL Server Capacity

SQL Database Design and Troubleshooting

PROFESSIONAL EXPERIENCE

Confidential, Plano, TX

Database Administrator III

Responsibilities:

Developing ETL packages to import data files from vendors into database
Creating stored procedure to produce report for external and internal use
Creating triggers to update archive tables
Collaborated wif team members to make reporting process more efficient and streamlined.
Designing tables to house raw data file.
Implementing database backup strategy and testing backups for disaster recovery
Tuned queries for performance optimization
Migrated data between development site and test site

Confidential, Richardson, TX

SQL Server DBA

Responsibilities:

Installed and configured SQL Server 2008R2 and 2012
Created backup jobs using SSIS packages for full, differential and transactional log backups.
Importing and exporting data
Refreshing data across two untrusted domains me.e Production to Test or vice versa
Monitored and optimized performance of database
Reconfiguring and deploying SSIS packages.
Provisioning access to database wif proper authorization
Created transactional replication
Decommissioning of servers
Created SQL Server Event, Maintenance Plans and Performance Condition Alerts

Confidential, Washington D.C

SQL Server DBA

Responsibilities:

Installed, Configured and Administered SQL server 2008, and 2012
Created SSIS package to extract data from excel files to SQL database
Created back up databases using Full, Differential and Transactional log backup process.
Monitor Server Activity, Error Log, space usage, and solving problems as needed
Maintained server level, database level and object level security using best practices by creating logins and users, configuring permissions and assigning different roles to users
Configured Database Mail and SQL Server Agent
Created SQL Server maintenance plans and performance condition alerts
Scheduled jobs to automate different database related activities such as backups, maintaining index, monitoring disk space and backup verification
Set up transactional replication on remote server.
Set up development site for SQL server developers using both snapshots and BULK import and export
Importing and exporting from various platforms such as Oracle, excel, and MSSQL server 2005 and 2008
Configured and administered Fail-Over Clustering, log shipping and database mirroring
Performed database migration and upgrade from SQL Server 2005 and 2008 to 2012.
Installed and applied Service Packs (SP) on SQL Server 2008 and 2012.
Installed, configured, and administered Visual Basics for 2008 and 2010 Integration Services (SSIS) and Reporting Services (SSRS).

Confidential, Washington, D.C.

SQL Server DBA

Responsibilities:

Tasked wif providing installation, configuration, technical and maintenance support of SQL databases
Plans, executes, and documents migration activities for software version updates and service pack installation
Configured Database Mail and SQL Server Agent
Set up development site for SQL server developers using both snapshots and BULK import and export
Importing and exporting from various platforms such as Oracle, excel, and MSSQL server 2005 and 2008
Configured and administered log shipping, transactional replication, and database mirroring
Performed backups and rebuild or reorganize indexes as needed.