Sql Server Database Administrator

PEORIA, IL, US, ***** • **********@*****.*** • 779-***-****

ELVIS TASEH

PROFESSIONAL SUMMARY

A Detail-oriented SQL Database Administrator with over 10 years of expertise, and an outstanding record in managing database architecture both On-premises and in the cloud. Skill set includes database and server migration, monitoring, automation, system administration, and optimizing database environments, designing databases (and database objects), implementing high availability and disaster recovery solutions, and fine-tuning SQL query performance for maximum efficiency. Highly proficient in ETL processes, data analytics, and data security, ensuring seamless database backup and recovery, prioritizing high performance and reliability across all database systems. Highly innovative and dedicated Administrator who demonstrates great cross-functional team collaboration and communication skills with both technical and non-technical clients.

Highly skilled in Snowflake objects deployment, role and row level security, ingestions, task automation, Access management, Artificial Intelligence (A.I.), Data Science, management of Data Warehouses, Cost reduction, and Data Visualization including Power BI.

TECHNICAL SKILLS

SQL Server Administration, SSAS, SSRS, SQL Queries, Database Migration, Data Modeling, AWS RDS, PostgreSQL, MySQL, Oracle Database, Java, Python, C++, Data Mining, ETL, Salesforce Administration, CRM Database Management, Azure DevOps, Dynamic 365, Network administration, Docker, TempDB Optimization, Clustering, Database partitioning, VMware, CD/CD Agile Methodologies, IT project management, Information Technology Strategy, System administration, SaaS, PaaS, IaaS, System Architecture, Schema Design, SQL Server Integration Services, Database Development, Linux Operating System, Database Design, PowerShell Scripting, NoSQL Databases, Microsoft .NET framework, Database server monitoring, Agile Methodology, ETL development, Code debugging, AI, Machine learning, SolarWinds, Relational Database Management, Information modeling, Database locking, Implementing security measures, Root Cause Analysis, Snowflake, Visual Studio, OLTP/OLAP, JSON, XML, SDLC, Tableau, Data audits, Continuous Process Improvement, System Testing, Document Management, Compiling Data, Server Migration, Patching, Data Governance, New Product Testing, Task Prioritization, Database Normalization, Data Center, Atlassian Jira, VS Code, Dbeaver, SourceTree, Github, Data Catalog, Snowsight.

RECENT PROJECTS

Implement a mission control project aimed at assembling massive data from different datalakes into single data platform in Snowflake for a comprehensive data analyses and visualization giving Caterpillar stakeholders and its partners the ability to make informed decisions in real time.

Led the successful migration and upgrade of 12 production and non-production SQL Servers from 2016 to 2019, implementing Windows clustering and log shipping with minimal downtime.

Conducted detailed performance tuning and maintenance, including index and query tuning to up to 30% system responsiveness.

Coordinated a cross-functional team project that migrated 500+ SSIS jobs from SQL Server agent scheduler to JAMS scheduler and scheduled based on dependencies.

Design an automated process for Data refresh from production to non-production environments ensuring real time data for testing during SDLC process saving over 20 hours of administrative overhead monthly.

EMPLOYMENT HISTORY

SENIOR IT ANALYST 1/6/2025 – Present

Caterpillar Peoria, Illinois

Administered the Snowflake arcchitecture including optimization of Snowflake databases and warehouses acheiving a 99.9% uptime and Data availability.

Configure the snowflake environment to align with organizational needs and requrements, thus ensuring rebost access management to hundreds of Terabytes of data assets.

Designing and implementating database structure for optimal performance, scalability and cost-efficiency, with clear Visio diagrams designed and documented reducing cost by 30%.

Perform monitoring, performance tunning, optimization, access management, documentation of processes and ensuring compliance with data governance policies and regulatory requirements.

Collaborating with data architects, data engineers and other stakeholders including support and training on Snowflake best practices.

SENIOR DATABASE ADMINISTRATORMay 2023 – Nov 2024

Illinois Mutual InsurancePeoria, Illinois

• Led a SQL server upgrade, built windows failover clusters, software installation and migrations with minimal downtime ensuring data integrity across 800+ databases and implementing best practices.

• Optimized database performance by monitoring and pinpointing regressive queries, implementing index tuning strategies, resource utilization and query optimization techniques with up to 75% improvement.

• Implemented data recovery, maintenance, data integrity and space requirements for physical databases. Creating and modifying tables, stored procedures, views, indexes, user-defined functions and triggers and so on, as requirement on SQL Server environments for small to large databases.

• Coordinated all day-to-day aspects of MS SQL database administration. Tasks include database design, installation, configuration, upgrades, security, managing users and logins, performance monitoring and tuning, database availability, backup and recovery, troubleshooting, problem resolution and task prioritization.

• Managed multi-site SQL environments including QA and production support, maintaining 24/7 availability.

DATABASE ADMINISTRATORMay 2020 - May 2023

Bankers TrustDes Moines, Iowa

• Installed SQL Server 2019 on advanced servers, applied security fixes and patches, migrated databases and upgraded database compatibility.

• Implemented SQL Server high availability (HA) and disaster recovery strategies by configuring Always on Availability Groups and Log shipping with 3 replicas; achieved business continuity by ensuring 99.9% uptime across critical database (DB) systems.

• Deployed and troubleshoot SSIS packages related issues across the data architecture, built and published Power BI reports, managing user access and dashboard views, enabling 100% real-time insights for decision-making.

• Deployed strategic process automation scripts within the SQL framework and windows servers that reduced manual maintenance tasks by over 20 hours per week, thereby ensuring more efficient database operations with minimal downtime incidents.

• Provisioned and administered azure resources such as azure SQL databases, managed instances, virtual machines (VMs), Synapse analytics, SQL pools, Data Lake Gen2 storage, pipelines and dataflows, data factory.

LEAD DATABASE ADMINISTRATORFeb 2013 - Nov 2019

AEDES/IRESCO CONSORTIUM, Ministry of Public HealthCameroon

• Administered and optimized BI solutions with Power BI and Tableau for advanced data analytics and visualization. Create and maintain databases and database objects, manage ETL processes and data integration to enhance data availability and decision-making.

• Formulated and developed complex DAX and SQL queries for data modeling towards enhancing organizational analytics and visualization capabilities. Maintained, tested and upgraded BI tools for maximum performance and 100% user satisfaction.

• Configured SQL Server Security Audits and Data masking to ensure compliance with HIPAA and GDPR regulations resulting in up to

40% reduction in vulnerability based on assessments.

EDUCATION/CERTIFICATIONS

ASSOCIATES: MS SQL DATABASE ADMINISTRATIONFeb 2016

KiawitechIT LLCHouston, Texas, USA

BACHELOR'S DEGREE: COMPUTER SCIENCEDec 2015

University of BueaCameroon

Microsoft Azure Administrator (AZ-104) – Certified. No. EEEF7B-65AM4A

Microsoft Azure Database Administrator – Certified. No Q00716-50D880

Microsoft Technology Associate (MTA) – Certified. No. I319-3964

Contact this candidate