Summary
Overview
Work History
Education
Skills
Websites
Certification
Timeline
Generic

La Vitesse Njinke

San Antonio,TX

Summary

Highly skilled Senior Database Administrator with over 8 years of hands-on experience supporting Microsoft systems in complex enterprise environments. Proficient in Microsoft SQL Server Database Installation, upgrading, Configuration, Administration, Maintenance, Performance Tuning, Backup and Recovery experience in SQL Server 2019/2017/2016/2014/2012; On-Premise and on AZURE cloud environment. Proficient in MySQL with hands-on experience in database management, and query optimization. Familiar with PostgreSQL Comprehensive knowledge and experience in all phases of the Software Development Life Cycle (SDLC) and great working experience in an Agile/SCRUM development team. Experience in implementing SQL Server Security, object permission, maintaining creation of users, configuring permissions database authentication and assigning roles of users. Extensive working experience in troubleshooting, monitoring and performance tuning various issues. Extensive experience in implementing HADR solutions such as Always on Availability Group, Replication, Log shipping, Clustering and Mirroring on physical and virtual machines. I am an expert in Data conversion, Data modeling, Normalization, Data Scrubbing, Data Staging and Data Validation in preparation of pushing data to production environment. I am highly proficient in using T-SQL scripts, Views, Triggers, and knowledgeable in Common Table Expressions (CTE), Functions, stored procedures that meet business requirements. Experienced in creating and deploying ETL packages to move data from various heterogeneous data sources such as Access, Excel, and CSV Flat files. Well Experienced with Microsoft SQL Server Integration (SSIS) and Reporting Services (SSRS). Well experienced in managing very large databases with minimum to no downtime, strong understanding of RDBMS concepts as well as Data Modeling Concepts. Demonstrates advanced proficiency in designing and optimizing ETL processes, implementing intricate Data Warehousing, Operations Data Store concepts, and employing expertise in creating data marts and OLAP technologies, along with a sophisticated understanding of Star and Snowflake schema design. Showcases exceptional proficiency in providing seamless support for mission-critical databases, leveraging extensive experience in Microsoft SQL Server Integration (SSIS) and Reporting Services (SSRS). Proficiently craft and optimize T-SQL scripts, Views, Triggers, and demonstrate advanced expertise in Common Table Expressions (CTE), Functions, and stored procedures, ensuring seamless alignment with intricate business requirements. Navigate seamlessly through advanced database management features such as Policy Based Management, Transparent Data Encryption, Always Encrypted, Dynamic Data Masking, and Contained Databases. Expertly define and enforce robust database standards, policies, security measures, and documentation, ensuring optimal efficiency in database operations. Possesses excellent analytical, problem-solving skills, and superior written and verbal communication skills across all organizational levels, showcasing an unwavering commitment to detail and precision.

Overview

8
8
years of professional experience
1
1
Certification

Work History

MS SQL Server Database Administrator

American Express
Phoenix, Arizona
09.2021 - Current
  • Proactively administered, supported, and monitored databases, demonstrating agility in resolving issues and maintaining server integrity
  • Successfully managed workloads independently while fostering collaboration within a distributed team environment to accomplish larger-scale tasks efficiently
  • Enforced adherence to corporate standards and policies, including comprehensive database auditing to ensure data integrity and security
  • Proficiently created and modified Tables, Stored Procedures, Views, Indexes, User-defined Functions, and Triggers as per evolving requirements in SQL Server Environments
  • Executed all facets of MS SQL database administration, including database design, installation, configuration, upgrades, security implementation, user and login management, performance monitoring and tuning, database availability, and backup and recovery
  • Diligently adhered to Change Control Procedures, developing and executing scripted change requests in strict accordance with established procedures
  • Applied optimization strategies to enhance SQL Code, ensuring optimal performance across database environments
  • Utilized Agile tools and ticketing systems as efficient work queues, streamlining task management processes
  • Established, administered, and maintained SQL Server Databases for diverse environments, including Production, Development, Test, and Staging, catering to the specific needs of groups such as Developers, QA, BA, and End Users
  • Spearheaded On-Prem to Azure Migration Projects, implementing seamless transitions and ensuring operational continuity

Senior SQL Server Database Administrator

Boston Scientific
MN, Remote
06.2018 - 08.2021
  • Create and configure Logical SQL servers, databases, elastic pools in Azure Cloud
  • Import and Export data within Azure Cloud environment
  • Creating and Managing logins/Access levels in Azure IAAS and PAAS environments
  • Ensuring a successful monitor of resources And Log Analytics
  • Able to configure automatic tuning, recovered azure deleted databases and able to recover databases to a point in time
  • Monitoring standby Databases to ensure high availability
  • Setup Database Mail and Operator to alert whenever any automated job fails
  • Participating in Agile/Scrum calls including weekly sprints and daily standups
  • Manage and maintain SQL Server instances in IAAS and PAAS environments
  • Perform SQL Server installation, configuration, backup, and recovery procedures
  • Optimize database performance by creating and implementing indexes, views, and stored procedures
  • Develop ETL processes and create reports using SSIS, SSAS, and SSRS
  • Utilize Azure Data Factory and Azure Synapse for data integration and analysis
  • Implement security measures to ensure data confidentiality and integrity
  • Uses Database tool for PowerShell scripts for automation of database administration tasks
  • Provide technical support to end-users and troubleshoot database-related issues
  • Ensure high availability and disaster recovery procedures are in place
  • Implemented Spring Boot Microservices to divide the application into various sub modules
  • Proficient in responsive web development using Bootstrap and Media Query
  • Proficient in resolving tickets and user requests, following change management process using ServiceNow
  • Developed effective Database Migration procedures to migrate from on-premise to Azure

SQL Database Administrator

Delta Airlines
Houston, Hybrid
08.2016 - 05.2018
  • Provided 24-hour Production support for mission-critical databases in a complex environment
  • Carried out Database server installations, patches, and upgrades, including both standalone and clustered server environments
  • Carried out deployments and post-validation testing
  • Maintained Databases following best practices with operations like index rebuilds, distribution statistics and database consistency checks
  • Set up Disaster recovery solutions using Backups, carried out Disaster recovery testing and verification
  • Database performance tuning activities such as analyzing MS SQL query plans, index tuning, troubleshooting database blocking and resolving deadlocks
  • Set up and maintained High availability strategies including clustering and availability groups
  • Provided expert level database administration support to vendors, developers and others as needed
  • Monitored and cross trained staff members
  • Participates in 24x7x365 on call support rotation, as well as evening and weekend maintenance and deployment cycles as needed
  • Performed routine performance and availability testing on database servers to ensure scalability, resiliency, and capacity of all applications
  • Performed daily monitoring of database servers to include error logs, database file sizes, successful backups, volume space, etc
  • Assisted in the architecture and design of database systems for high volume database applications with high availability requirements
  • Administering Windows server using VMware
  • Managing users and user groups in windows active directory

Education

Bachelor’s Degree - Network and Cloud Architecture

Northwest Vista College
San Antonio
11.2024

Bachelor’s Degree - Computer Science

University of Buea
Buea, Cameroon

Skills

  • T-SQL
  • Windows CMD
  • PowerShell
  • Shell Scripting
  • Based Management
  • Resource Governor
  • DMA (Data Migration Assistance)
  • Azure Database Migration Service
  • Data Stage
  • Runbooks
  • Hung processes
  • IDERA
  • Red Gate
  • DD-Boost
  • Commvault
  • Net-Backup
  • Jira
  • Service Now
  • Splunk
  • Locks
  • Access and Excel
  • MS-Access
  • MS-Outlook
  • MS-Teams
  • Git
  • Jenkins
  • Bitbucket
  • Testing Data

Certification

  • IT Fundamentals
  • Networking Fundamentals
  • Cloud Essentials
  • AZ-900
  • SQL for Data Analysis and Development
  • Linux Fundamentals

Timeline

MS SQL Server Database Administrator

American Express
09.2021 - Current

Senior SQL Server Database Administrator

Boston Scientific
06.2018 - 08.2021

SQL Database Administrator

Delta Airlines
08.2016 - 05.2018

Bachelor’s Degree - Network and Cloud Architecture

Northwest Vista College

Bachelor’s Degree - Computer Science

University of Buea
La Vitesse Njinke