Sql Server Database Administrator
Resume:
HANA W
BAILEY
*****.******@*****.***
Washington, DC, DC 20011
SKILLS
SQL Server installation and configuration
Database design maintenance
Database security
Database Administration
Backup and recovery
High Availability and Disaster recovery
Documentation, MS SQL Server
SQL Profiler
Windows Clustering
SQL Jobs Automation
Replication
ETL, SSIS\SSRS, Data warehouse
Performance Monitoring
Programming T-SQL, PowerShell
Microsoft office 365
DB2 \IIAS
Deployment Teradata
EDUCATION
Bachelor: Computer Science
PROFESSIONAL SUMMARY
As A Database administrator I handle all facets of managing Microsoft SQL Server ranging from installation and creating databases to patching. Also, as a get keeper of my data, managing permissions that allow users to use the databases also relay on me. Making sure all the servers up and running more importantly my hands-on experience in SQL Server Migration (on-premises), database documentation, administration, performance monitoring and tuning, as well as backup & recovery, maintenance plan, job automation are what I signed for as a database administrator even on terabyte plus databases
I am also well-organized, and detail-oriented with outstanding interpersonal communication, multitasking skills, and have the ability to independently research and resolve difficult technical problems in complex environments. Exceptional troubleshooting and analytical problem-solving skills.
WORK HISTORY
Airos\Kodiak systems Database Administrator09/2021 – Current
Roles and responsibilities
Database security (should grant minimum required privileges)
Creating stored procedures and scheduled jobs
Monitor database performance implement changes and apply new patches.
Install and configure a new SQL 2019 server for in-place upgrades or SQL migration in Prod and non-prod environments.
Perform tests and evaluations regularly to ensure data security, privacy, and integrity and make tuning recommendations to enhance performance
Database backup and restoring
Work on Ansible for DB-mail configuration automated task for over 200 SQL servers.
Working on ticket\tasks requests assigned to the DBA team.
As HADR soliton method worked on high availability solution and Sql Server replication experience
CarMax Through Robert and Half - SQL Database Administrator
Remote • 06/2021 – 10/2021
Roles and responsibilities
Making sure all SQL servers up and running
MS.SQL \Sybase package releases on non-production environments
Deploying MS. SQL packages to the production environment
Database refresh between production and QA environments.
Working on Database mail configuration in all Dev and QA sql servers
Deployment and job scheduling in Sybase database
Ensure SQL Server and database security through account permissions and login audit.
Monitor, optimize, and troubleshoot MSSQL Server, including disk-related, using native and third-party tools.
Working on SQL inventory documentation and others
Envolve Health, Centene corporation Through Robert and Half - SQL Database Administrator Remote • 04/2020 – 09/2020
Roles and responsibilities
Microsoft SQL Server 2008 R2, 2012, 2014, 2016 and 2017 Database administration and configuration.
Deploy Patch and service pack/cumulative updates on production and non-production environments
Design documentation that includes architecture, configuration, security, maintenance, troubleshooting, and backup details.
Ensure SQL Server and database security through account permissions and login audit.
Automate and monitor database backup and restore.
Database and object deployment and refresh between production and staging environments.
Monitor, optimize and troubleshoot MSSQL Server performance issues (including indexes, queries, network, memory, and disk related) using native and third-party tools.
Develop and deploy SSIS packages in data warehouse, Configure SQL Server Reporting Services.
Configure and support SQL replication (transactional and merge) for different project needs and monitor with replication monitor, SQL scripts, and replication jobs.
Plan, Implement, and support high availability and disaster recovery solutions (log shipping, database mirroring, and Always On)
Handel deployment on live servers running on Linux (change, incident, and problem management.)
Blue Cross and Blue Shield Through Insight Global - SQL Database Administrator
Hoover, Alabama • 07/2018 - 11/2019
Roles and responsibilities
Install, configure, and manage multiple SQL server environments in standalone and cluster.
Apply SQL server patches, service packs, hotfixes, and cumulative updates and create documentation for tracking.
Review server configurations, monitor and optimize query execution, and perform database health checks and server resource utilization to ensure optimal performance of servers.
Develop automated maintenance tasks including database backup, index and statistics maintenance, cleanup, and integrity check.
Ensure server and database level security by implementing SQL server Audit specifications, database encrypting and setting/reviewing user permissions.
Perform changes on production databases based on change order requests.
Work with database developer team on database design, data modeling and normalization.
Design, plan and perform on premise to azure SQL server migration.
Perform on call duties (including after-hours and weekends) troubleshooting, root cause analysis, workaround.
Deploy database change scripts provided by developers or third-party vendors supporting application.
Work on windows failover clustering and configuring Always On SQL server 2016 and SQL server 2017.
Perform tests and evaluations regularly to ensure data security, privacy, and integrity.
Work on IBM Integrated Analytics System (IIAS) security implementation and monitor IIAS performance.
Work on BLUDB/schema backup with script and using console.
Global Wireless Solutions, Inc - SQL Database Administrator
Sterling, VA • 04/2015 - 04/2018
Roles and responsibilities:
Perform installation, configuration, optimization, server builds, patches, service packs, upgrading and troubleshooting of SQL Servers in Clustered and Non-Clustered Environments.
Perform routine SQL server patch using PowerShell scripts.
Work on optimizing the performance of the database using SQL server profiler
Automate server and database health checks using PowerShell scripts.
Manage and support production database servers.
Design and implement policy and conditions to ensure server, database, and database object level security baseline.
Plan, design, and implement backup and restore strategies following RPO and RTO guidelines.
Configured and managed High Availability solutions (Clustering, Database Mirroring, Log shipping, replication)
Perform premises side-by-side migration between SQL server 2008, 2012, and 2014 and documented the complete Upgrade Process.
Configure Always-ON for High availability as a disaster recovery (DR) solution.
Monitor indexes and statistics at regular intervals for better performance.
Schedule jobs to automate different database-related activities including backup, and monitoring database health.
Design, implement, and deploy SSIS packages to migrate data from multiple data sources.
Participating in 24/7 ‘on-call' support for SQL Server database systems.
Inova Health Systems - MSSQL Server DBA
Arlington, VA • 03/2012 - 03/2015
Roles and responsibilities:
Manage databases, from planning and testing stages through implementation and production support.
Implement SQL server security best practices by maintaining authentication modes, configuring permissions and roles (database and server level) on principals
Automate and actively monitor day-to-day DBA activities such as checking scheduled job status, disk space, and performance issues
Perform on-premise migration from SQL SQL Server 2008/2008R2 to 2012.
Set up ne SQL Server instances on Hyper-V/VMWARE environments.
Configure, Schedule and check SQL Server agent Jobs/ Alerts for Maintenance plans, Backup and Recovery plans, Database Mail Configuration, and Transparent Data Encryption.
Check database conditions, rebuild indexes, and other database maintenance purposes as well.
Maintain the functionality of ongoing databases by Applying performance-tuning techniques.
Deployment administration and operational support of the production environment.
Perform day-to-day activities/tickets including full, differential, and log backups, database restores/refreshes, and proactive monitoring of SQL server health.
Work with database developers to optimize SQL queries and stored procedures
.
Contact this candidate