Patricia Nchimi

Dear Hiring Manager

With recognized expertise in designing, implementing, and maintaining high-performing SQL Server databases in both on-premise and cloud environments, I am excited to apply for the SQL Server Database Administrator role. I understand that your company is seeking a creative, solutions-focused professional to install and configure Microsoft SQL server; maintain Pro, Test, and Dev environment; and improve database performance The leadership that I have demonstrated over the course of my career in both tactical and strategic roles gives me confidence in my ability to bring the right balance to the position, ensuring team success. Additionally, I offer a keen attention to detail, cultural awareness, and a talent for developing others.

Throughout my career—including my current role with JoinIT Solutions as a Database Administrator —my focus has been on SQL Server Installation and configuration database migration, system security and overall functionality improvement, and SQL elastic pools management, and my achievements reflect my success in those areas. I am strongly self-motivated with a drive to continuously improve my team’s performance and scale the business through innovative systems and processes.

Furthermore, please consider the following achievements of my working experience:

• Increased database agility and flexibility by strategizing and migrating environments from on-premises to cloud- based.
• Secured clients sensitive data by using tools, such as Always Encrypted, Transparent Data Encryption (TDE), and Dynamic Data Masking (DDM).
• Enhanced system working performance by assessing, solving, and correcting issues in real time; providing end-to-end problem resolution, including hardware and software purchases, server configuration changes; and assisting developers with query/index tuning, partitioning, compression and statistics.
• Enabled database integrity, stability, and system availability by using in-built software in SSMS, such as SQL server profiler, performance monitor, extended events, DMVs, database integrity checks.

Sincerely,

Patricia Nchimi

Enclosure: Resume

•  Supervise and Upgrade SQL Server 2008 servers to SQL Server 2016 with both In-place and Side by Side 
• Configure and setup Always On availability groups in a 3-node cluster 
• Create various maintenance plans for index fragmentation and backups to automate tasks as per SLA and ensure better system health and performance 
• Improve efficiency in the processes via automation of database refreshes by creating SSIS packages
• Troubleshoot and provide guidance in database and server issues from infrastructure to configuration settings for optimal database performance
• Experience using SQL Server features such as Query Store, data Import/Export, Extended Events and Tuning Advisor. 
• Control and establish an appropriate database user Access control levels by provisioning and deprovisioning users based upon company policy to control access for each segment of the Databases. 
• Develops database security guidelines and performs audits.

• Responsible in the Extraction, transform, and load data using SQL and/or Informatics
• Providing technical expertise on data storage structures, updates, deletion, and data cleansing
• Optimized data collection procedures and generated reports on a weekly and monthly basis, and troubleshooting the reporting database environment and reports.
• Responsible for database structures management and administration tasks on SQL server RDBMS such as taking and maintaining database backups to restore, application and database support, performance analysis and tuning, security, and audits
• Upgraded database management software SQL server 2008 to SQL server 2016 with In-place and Side by Side upgrade for new applications in the company 
• Configured and setup Always On availability groups in a Windows cluster test, and production environment, where two were in house and 1 in a data center for disaster recovery 
• Handled SQL Server installations, Configuration, Security, and maintenance following best practices
• Used SQL Server Profiler, Extended Events, Database Engine Tuning (DTA) for performance tuning and other third-party monitoring tools 
• Install and configure SQL Server Integration and Reporting Services (SSIS), (SSRS)