SUMMARY:

• I am an experienced SQL Server DBA who has been supporting database applications for over four years.
• 8+ years of administration experience on Database Design and Implementation using various SQL Server versions in an OLTP environment.
• Manage Microsoft SQL Server database administration assignments for diverse industry clients.
• Enhance database performance tuning, database backup & restore, implement recovery procedures.
• Ensure technical and functional designs meet business requirements.
• Database administration including installation, configuration, upgrades, capacity planning, performance tuning, backup and recovery in SQL servers clusters and stand alone on both virtual and physical machines.
• Experienced with the setup and administration of SQL Server Database Security
• Provide SQL Server database physical model creation and implementation (data type, indexing, table design)
• Ability to ensure the technical integrity of corporate databases by protecting against the loss or misuse of information and backup/recovery strategies
• Database Mirroring
• Database Security
• Ability to troubleshoot SQL Server
• Improvement and maintenance of the databases to include release rollout and upgrades
• Experienced in writing and tuning T - SQL
• Experience with SQL Profiler, SSIS, SSRS

MY CORE EXPERIENCE IS IN THE AREA OF:

• Data Migration
• Disaster Recovery
• Performance Tuning
• Backup and Recovery
• Database Security
• High Availability Solutions
• Cluster services
• Database Upgrades patches
• Reporting Services
• Azure
• Integration Services

SKILLS SUMMARY:

RDBMS Versions: SQL 2005, SQL 2008, SQL 2008R2, SQL 2012, SQL 2014, SQL 2016

Operating systems: Windows 2003/2008/2008 R2/2010/2012

Languages: .NET C# and TSQL

EXPERIENCE:

Confidential, Farmers Branch, TX

SQL Server Database Administrator

Responsibilities:

• Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end
• Manage SQL Server databases through multiple product lifecycle environments, from development to mission-critical production systems
• Cluster and stand-alone (virtual and physical) installations and decommissions
• Setup and maintain database mirroring and high availability (AlwaysOn)
• SQL Tuning/Code review
• Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security
• Automated the creation of new databases from a template source for client onboarding
• SQL Upgrades and Migrations
• Handle all support tickets
• Perform scheduled maintenance and support release deployment activities after hours
• Share domain and technical expertise, providing technical mentorship and cross-training to other peers and team members
• Provide 24x7 support for critical production systems

Confidential, Downtown Dallas, TX

Sr. SQL Server Database Administrator

Responsibilities:

• Ability to handle everything, completely independent and work on projects without direction.
• Environment is 1200+ servers and using SQL Server 2000-2015
• SQL Tuning
• In Depth Troubleshooting
• AG Clustering- Always-On High Avail Group
• 60% of work on the EHR, 4 node AG cluster
• Performance Tuning
• Build custom stored procedures
• Build and deploy custom SSIS packages
• Manage Audited applications and send out quarterly reports (via SSRS) for audit approval
• Participate in 24x7 On-call rotations within the team
• Migration and upgrades

Confidential, Plano, TX

Mid-Level SQL Server Database Administrator

Responsibilities:

• Verify backups are taken and up to date
• Create report for missing backups, long running jobs
• Migration and upgrades
• Troubleshooting performance issues
• Meeting SLAs (tickets and business critical incidents)
• Cluster and stand-alone (virtual and physical) installations and decommissions
• Setup and maintain database mirroring and high availability (AlwaysOn)
• Setup and maintain replication
• Participate in 24x7 On-call rotations within the team
• SQL Server patching
• Conduct and assist application deployments to production
• Grant/Revoke permissions
• Code review
• Azure backups

Confidential, Dunwoody, GA

SQL Server Database Administrator

Responsibilities:

• Provide day-to-day maintenance and administration of Microsoft SQL Server databases supporting client-facing and back-office production applications.
• Manage all aspects of database administration including planning, installation; configuration and monitoring of SQL Server databases.
• Maintain SQL Server database security (internal and external)
• Maintains and monitor infrastructure for database backups and recovery.
• Performs general and advanced troubleshooting as required to resolve database issues affecting both internal and client-facing systems.
• Configures and establishes database mirroring.
• Transact SQL code review
• Use development practices and migration processes as database applications are built.
• Create technical and support documentation.
• Import/Export Data to new databases or existing tables
• Knowledge of Transact-SQL (DDL, DML).
• Complete ad-hoc requests from users.
• Proficient in implementing all transformations available on the SSIS toolbox.
• Created and tuned stored procedures and tables.
• Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases
• Created indexes for better performance

Confidential, Marietta, GA

Jr. Database Administrator / SQL Server Developer

Responsibilities:

• Managed multiple instances of SQL Server. Ranging from 2GB databases to 1TB.
• Experience with SQL Server and T-SQL in constructing triggers, tables, user functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity.
• Experience in database backups/restoration
• Perform SQL Server Database upgrade
• Assisted with rebuild and overall hardware upgrades.
• Communicate problems and issues to business owners and management.
• Generated the weekly, monthly, and quarterly report by using SQL Reporting Services
• Verify backups and error logs on the servers and troubleshoot any failures or alerts, open trouble tickets if necessary to work with technicians from other departments.
• Migrated databases
• Migrated data from different data sources to SQL server
• Experience in database backups/restore
• Performance tuning and capacity planning
• Planned company system configuration and computer needs for business needs.
• Provided technical support for 25+ users and performed maintenance
• Respond to user service request and expediently resolve trouble tickets to maximize system uptime.
• Diagnose, troubleshoot and resolve client issues with hardware maintenance, installation and upgrades.
• Database support maintaining servers and information concerning basic backups and recovery.

Confidential, Marietta, GA

SQL Work Study / Intern Program

Responsibilities:

• Provided PC rebuild and overall hardware upgrades.
• Worked with Business Analysts and Users to understand the requirement.
• Migrated databases
• Migrated data from different data sources to SQL server
• Experience in database backups/restore
• Performance tuning and capacity planning
• Planned company system configuration and computer needs for business needs.
• Provided technical support for 25+ users and performed maintenance
• Respond to user service request and expediently resolve trouble tickets to maximize system uptime.
• Diagnose, troubleshoot and resolve client issues with hardware maintenance, installation and upgrades.
• Documented help desk ticket and resolutions.
• Performed software installations.
• Database support maintaining servers and information concerning basic backups and recovery.
• Assist in planning server specs and network needs for server communication.