Sql Server Database Administrator

DOVICE KITIO

Grand Prairie, TX ***** 661-***-**** ************.*****@*****.***

PROFESSIONAL SUMMARY

Experienced Database Administrator with over 5 years of expertise in managing, optimizing, and securing databases. Proven track record in ensuring database integrity and availability, with a strong focus on performance tuning, backup and recovery, and data integration. Adept at working collaboratively with IT teams and providing support to end-users. Expertise in managing large-scale databases, ensuring data integrity, and providing data insights using SSRS and Power BI. Superior knowledge in creating tables, troubleshooting existing tables, joining tables, Stored procedures, Triggers, Functions, Views. Experience extracting, transforming and loading data from various sources using SSIS. Experienced configuring and monitoring clustering including Always On and Failover clustering. Experienced Installing/Setting up and maintain MS SQL database software with updates/patches. Committed to staying updated with the latest database technologies and trends.

SKILLS

• MS SQL Server 2012, 2016, 2017 and 2019

• Database Architecture, Design, and Capacity

Planning

• High Availability and Disaster Recovery (HADR)

solutions: Always on Availability Groups, Log

shipping, Replication

• Jobs automation, Jobs Alerts

• Database Migration from On-Prem to Azure

• Performance Tuning and Optimization: Query

optimization, Indexing, Database partitioning.

• Backup and Recovery: Backup plans, restore

procedures, Disaster recovery, SQL Server

Management Studio (SSMS), SQL Server Agent,

SQL Server Backup and Restore

• Monitoring Tools: RedGate, Performance

monitor, SQL Server Extended Events, SSMS,

SQL Server Profiler

• Scripting and Automation: T-SQL scripting,

Automation tools (ola.Hallengren)

• Security Management: User roles, Permissions,

Encryption, Security audits

• Data warehouse

• Data Integration: ETL processes, Data quality,

Data consistency, SSIS

• Reporting Tools: SQL Server Reporting

Services (SSRS), Power BI Data Modeling

• Data Analysis

• Data Visualization

• Problem-Solving and Analytical Thinking

• Attention to Detail

• Critical Thinking

• Communication and Collaboration

• Time Management

• Agile Methodology

WORK HISTORY

SQL Server Database Administrator (Contractor), 01/2022 - Current Chase Bank – Fort Worth, TX

• Installed and configured DBMS software, set up database servers, and configured environments for development, testing, and production use

• Deploys and maintains Microsoft SQL Server databases/DB projects across a range of current SQL Server versions in both physical and virtual environments

• Maintains database security, integrity, and availability

• Manages database performance and capacity

• Implements database design enhancements

• Collaborates with Development team on creating and evaluating stored procedures, tables, indexes, schemas etc. to optimize queries and applications.

• Maintains detailed documentation of database Design/Architecture and setup

• Configures and monitors clustering including Always On and Failover clustering

• Designs and builds operational infrastructure to support our databases, automating where possible

• Creates users, assign roles and manages permissions

• Performed regular database monitoring and tuning to ensure high performance and reliability

• Implemented and managed database high availability solutions, including Always-On Availability Groups, log shipping, and Replication

• Created and maintained comprehensive database documentation and operational procedures

• Monitored database performance, identified performance bottlenecks, and implemented query, index, and configuration optimizations

• Managed database security, including user roles, permissions, and encryption; conducted regular security audits and vulnerability assessments

• Developed and implemented backup and recovery plans; performed regular backups and tested restore procedures

• Monitored database health and performance, performed routine maintenance tasks, and resolved database-related issues

• Developed ETL processes for data integration, ensuring data quality and consistency across systems

• Configured and maintained SQL Server instances, focusing on high availability and disaster recovery solutions

• Conducted regular performance tuning and query optimization to enhance database efficiency

• Automated database maintenance tasks including backups, indexing, and integrity checks using T-SQL

• Monitored database storage usage, planned for future growth, and ensured sufficient resources for efficient operation

• Documented database configurations, procedures, and policies; generated reports on performance, usage, and security

• Collaborated with IT staff to ensure database systems were integrated and functioning properly; provided support to end-users

• Developed scripts and automation tools to streamline database management tasks; implemented automated monitoring and alerting systems

• Actively participated in an on-call rotation to provide 24/7 support for critical database issues, minimizing downtime and ensuring system availability. SQL Server Database Administrator, 01/2018 - 12/2021 Epsilon Data Management LLC – Irving, TX

• Installed and configured database management systems; set up database servers and environments

• Designed and optimized database schemas; collaborated with developers for application optimization

• Monitored and optimized database performance, identifying and resolving bottlenecks

• Managed database security, ensuring compliance with data security and privacy regulations

• Improved query performance by 25% through index optimization and query tuning

• Developed and tested backup and recovery plans; ensured disaster recovery readiness

• Performed routine database maintenance and troubleshooting

• Managed ETL processes for data integration; ensured data consistency

• Planned for database growth and resource allocation

• Documented procedures and generated performance and security reports

• Provided support and collaboration with IT staff and end-users

• Executed database migrations with minimal downtime

• Conducted compliance audits and implemented automation tools for database management. EDUCATION

Bachelor degree: Computer science, 06/2008

University of Yaoundé - Cameroon

Associate degree: IT Administrator, 06/2006

ESG Douala - CAMEROOON

TRAINING

Azure Database Administrator

Contact this candidate