About

High-performing professional with extensive experience managing large-scale, complex databases. Skilled in Microsoft SQL Server database administration and Microsoft Azure. Strong understanding of database design and data modeling with excellent troubleshooting skills. Smart and committed to staying up-to-date with new technologies and advancements. Proven success in deployment of effective IT roadmaps, processes, and procedures including setting up high availability and disaster recovery solutions in SQL such as Always On Availability Groups, Log Shipping, Mirroring, Replication, and Traditional Fail Over Clustering. Significant expertise in SQL server upgrade and database migration as well as Azure Databases, elastic pools, Managed instance and new instances installation. Demonstrated history of successful execution of various processes including disaster recovery solutions, performance tuning, and monitoring. Excel at supporting mission-critical databases on both on-premise and Azure with the highest efficiency. Detail-oriented team player with strong organizational skills. Ability to handle multiple projects simultaneously with a high degree of accuracy. Organized and dependable candidate successful at managing multiple priorities with a positive attitude. Willingness to take on added responsibilities to meet team goals.

Skills

  • Communication
    10
  • Teamwork
    9
  • Problem-Solving
    9
  • Creativity
    9
  • Leadership
    10
  • English
    9

Experience

BUKUKA FELIX NJOGHONYI

Education
  • Certificate In Microsoft SQL Server Database Administration
  • Training In Administering Relational Databases on Azure Cloud.
  • Bachelor of Science Degree (BSC Hons Second Class Upper Division)

BUKUKA FELIX NJOGHONYI

Work experience
  • Plans, installs, updates/upgrades, tests and documents instances of SQL server following the company needs and Microsoft best practices.
  • Ensures security on environment by creating users/logins following the principle of least privileges, implement Always Encrypted (AE), Dynamic Data Masking (DDM), and Transparent Data Encryptions (TDE), create Audits, Views and Store procedure to ensure data integrity.
  • Ensures High Availability (HA) and Disaster Recovery (DR) solutions by creating jobs like migration based on transactions activities to minimize downtime, backup and restore following the company’s Service Level Agreement (SLA), log shipping, traditional failover clustering, always on availability groups (AO-AG) on critical databases.
  • Makes sure servers are up and running, perform performance tuning on slow running queries, creating indexes on tables to ensure optimal performance.
  • Administers supports and monitors databases by proactively resolving database issues and maintaining servers.
  • Administers SQL databases on Azure platform, migration from on-premise to Azure.
  • Configures virtual machines both on cloud and on-premise and ensures communication among all the VMs.
  • Understands the basic networking and connectivity in both the on-premise and cloud VMs.
  • Can use Powershell ISE well to achieve any given task.
  • Manage active directory on VMs and Vaults on Azure to ensure security on the servers and databases.
  • Provide guidance and expertise for database Performance Tuning, and Query optimization using both SQL Server inbuilt and third-party tools (Query Store, Extended Event, SQL server Profiler, SQL Server turning Advisor).
  • Configure High Availability (HA) and Disaster Recovery (DR) Solutions on productions systems using Clustering - Always On, Traditional Failover Clustering (Windows Server Failover Cluster - WSFC), Database Mirroring, Replication such as peer-to-peer replication, merger replication and transactional replication and Log Shipping.
  • Created Jobs and maintenance plans for better performance of the server, jobs included index rebuild reorganize, DBCC check, update database stats, database cleanup and other SSIS packages to help with data migration IT Support Specialist
  • Analyzed locks, dead locks and managing the isolation level and concurrence effects
  • Administered multiples SQL server Instances on clustered Environment for server Consolidation projects built on SAN
  • Install and configure SQL Server SSIS AND SSRS

Related persons