Summary
Work History
Education
Skills
Hobbies And Strengths
Technical Experience
Timeline
Generic

SONITA ITANGHI NDZI

Dallas

Summary

Over 3 years of experience in SQL Database Administration, supporting MS SQL servers 2017/2016/2014/2012/2008r2/2005 in various environments. Expertise in installation, configuration, maintenance, and administration of all versions of SQL servers. Proven ability to troubleshoot and resolve database issues, including integrity, performance, blocking, deadlocking, replication, log shipping, and connectivity issues. Strong knowledge of backups, restores, recovery models, database shrink operations, DBCC commands, clustering, database mirroring, and replication. Experience in implementing DR solutions, high availability of database servers using mirroring, replications, and log shipping. Hands-on experience in implementing SQL server security and object permissions. Proficient in performance tuning, query optimization, using performance monitor, SQL profiler, and other related monitoring and troubleshooting tools. Skilled in creating jobs, alerts, and database mail. Familiarity with applying patches and service packs to maintain the database at the current patch level. Excellent client-facing communication skills and a focus on delivery.

To pursue a challenging career with active interest in the field of Database Administration. I am seeking an opportunity to demonstrate my skills and contribute to the growth of your prestigious organization. I am a team player who excels under pressure, adapts to change, and willingly takes on additional responsibilities to ensure successful project deliveries. Proficient in prioritizing and coordinating tasks to meet deadlines effectively.

Work History

SQL Server Database Administrator/ Azure Administrator

Bridgewater Associates - Hedge Fund
  • Installed, configured, and administered databases in Test, Development, and Production environments using MS SQL 2005/2008 R2/2012/2014/2016
  • Assisted in maintaining fully functional databases using MSSQL Server 2008R2/2012/2014
  • Managed T-SQL transactions and resolved concurrency problems
  • Conducted daily backups and implemented recovery strategies as needed
  • Tuned database performance using Profiler, DMVs, index analysis, and Tuning Advisors
  • Scheduled, performed, and maintained routine jobs, alerts, and maintenance plans
  • Applied Service Packs and Security patches for the servers as released
  • Assisted in migration of data from various sources and provided 24/7 production support
  • Collaborated with developers to guide and review code for Production Servers
  • Created standards for developers to meet company specifications and standards.

SQL Server Database Administrator

HYCITE ENTERPRISES LLC
  • Performed database backups, restores, performance tuning, capacity planning, and disaster recovery
  • Implemented and maintained High Availability solutions, including Log Shipping, Mirroring, and Clustering
  • Configured Transactional Replication on production databases
  • Reviewed physical database structures for data integrity, quality, recoverability, maintenance, and space requirements
  • Troubleshot databases and custom application issues
  • Created and maintained database objects using T-SQL
  • Analyzed database growth for capacity planning, normalized data for efficiency, and partitioned data
  • Used SQL Profiler to monitor server performance and optimize queries
  • Implemented database standards and naming conventions
  • Assisted in maintaining fully functional databases using MS SQL 2008 R2/2012/2014/2016.

SQL Server Database Analyst

University of Bridgeport
  • Installed SQL Server 2008 R2 on production and pre-production servers
  • Designed and implemented backup and recovery strategy for production databases
  • Performed database audits and managed permissions through logins/roles
  • Configured and implemented SQL Agent jobs
  • Worked on database setup documentation and documented SQL server procedures and standards
  • Implemented Database mirroring on production and pre-production environments
  • Investigated and created missing indexes for performance tuning
  • Designed logical and physical database structures
  • Created new database objects using T-SQL in Development and Production
  • Implemented Database Maintenance Plan for SQL Server performance.

Education

Skills

  • Capacity Planning
  • Performance Tuning
  • Data Warehousing
  • Disaster Recovery

Hobbies And Strengths

  • Ability to achieve targets.
  • Reading, playing cricket, and playing Sudoku.
  • Net surfing, traveling, and listening to music.

Technical Experience

SQL, Transact SQL (T-SQL), Microsoft Azure, Microsoft SQL Server 2005, 2008R2, 2012, 2014, 2016, 2017, Windows Server 2003, 2008 R2, Windows 2012 R2, Vista, XP, SSMS, SSCM, SAC, SQL Server Extended Events (replaced SQL Profiler), SQL Query Analyzer, Index Tuning Wizard, PerfMon, Database Engine Tuning Advisor (ETA), Basic PC upgrades/repairs, Network cabling, Connectivity troubleshooting, Hard drive recoveries, Component level replacements

Timeline

SQL Server Database Administrator/ Azure Administrator

Bridgewater Associates - Hedge Fund

SQL Server Database Administrator

HYCITE ENTERPRISES LLC

SQL Server Database Analyst

University of Bridgeport

SONITA ITANGHI NDZI