Post Job Free

Resume

Sign in

Sql Server Database Administrator

Location:
Houston, TX
Posted:
February 18, 2024

Contact this candidate

Resume:

Sounitta Manto

Houston, TX ***** 336-***-****

ad3p4w@r.postjobfree.com

Professional Summary:

As an accomplished Database Administrator with over five years of experience in SQL Server management, where I have honed my skills in both technical and strategic aspects of database administration. My key competencies include:

I am proficient in developing, deploying, and optimizing SQL Server databases for various scales, from small businesses to large enterprises.

I specialize in enhancing database performance, utilizing both SQL Server features and third-party tools for maximum efficiency.

My experience extends to setting up and managing high availability solutions like AlwaysON Availability Groups, Clustering, Database Mirroring, Log Shipping, and various Replication models.

I am adept in database backup, restore, and recovery procedures, and I excel at implementing disaster recovery strategies to ensure data integrity and continuity.

In the realm of ETL processes and reporting, I am proficient with SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS), developing and supporting critical data management tasks.

Managing Active Directory objects and user permissions, I ensure SQL Server security and compliance with organizational policies.

Recognized for my problem-solving skills, I make informed decisions that align with and further organizational goals.

My role often involves leading projects and collaborating effectively with cross-functional teams, always with a focus on meeting team goals and strict deadlines.

Developing custom database solutions to meet unique business requirements and enhance overall functionality is another area where I excel.

I also take pride in mentoring junior staff and leading training sessions, sharing knowledge to build a stronger, more capable team.

My professional ethos is centered around leveraging my technical expertise to drive organizational efficiency and growth, while staying updated with the latest industry trends and technologies.

Technical Skills:

Database Systems: Microsoft SQL Server ( 2014, 2016, 2017, 2019, 2022)

Database Tools: SQL Server Management Studio (SSMS), SQL Server Profiler, SQL Server Data Tools (SSDT), SQL Server Reporting Services (SSRS)

Languages: T-SQL, PowerShell

HA/DR: Always On Availability Groups, Database Mirroring, Log Shipping, Replication, Backup and Restore

Performance Optimization: Query Tuning, Indexing, Query Execution Plans, query store, extended event, DMV Views.

Security: User Access Controls, Authentication, Auditing. Encryption (TDE, Always Encrypted), Data Masking

Education:

Bachelor’s in information technology

University of Buea - Cameroon

SQL SERVER DATABASE ADMINISTRATOR

May 2020 – Present

Fulton Bank, Lancaster - PA

Implemented robust SQL Server security measures, safeguarding critical systems and data integrity.

Successfully led daily standup meetings to monitor project progress and team coordination.

Managed a complex SQL Server environment, ensuring the support of critical transactional and enterprise data warehouse systems.

Applied data modeling techniques to optimize integration and performance, enhancing database efficiency and reliability.

Spearheaded change management initiatives, contributing to continuous improvement in database operations.

Created and deployed database objects and ETL processes, streamlining data handling and workflow processes.

Proactively monitored system health and performance, identifying and addressing issues to maintain high availability.

Provided comprehensive support for SQL Server versions ranging from 2014 to 2019.

Administered Reporting, Integration, and Analysis Services, enhancing data analysis and reporting capabilities.

Conducted regular database backups and maintenance, ensuring data safety and compliance with recovery protocols.

Collaborated effectively with developers and third-party providers, integrating diverse systems and enhancing project outcomes.

Offered 24x7 Production On-Call Support, ensuring rapid response and resolution of critical issues.

Designated and managed tickets on ServiceNow, assigning tasks to team members and tracking progress.

Installed, configured, and maintained database servers and processes, monitoring system health and performance for optimal operation.

Utilized SQL Profiler, Dynamic Management Views (DMVs), and Windows Performance Monitor for SQL Server performance tuning and monitoring.

Performed SQL Server and Windows service pack patches and upgrades, maintaining system currency and security.

SQL Server Database Administrator

February 2018 – April 2020

Cheniere Energy, Houston, TX

Spearheaded collaboration with stakeholders to gather requirements and recommend database standards, ensuring alignment with organizational goals.

Provided expert technical advice to design efficient and cost-effective solutions for Microsoft SQL Servers.

Installed, configured, monitored, upgraded, and maintained MSSQL databases in both production and non-production environments, ensuring optimal performance.

Played a key role in the consolidation and migration of databases to new hardware and platforms, providing hands-on support and technical expertise.

Conducted regular database capacity planning and implemented archival solutions, managing database growth and system utilization while providing trend analysis and future resource predictions.

Offered comprehensive DBA support for enterprise monitoring, backup, alerting, and security compliance solutions for SQL servers.

Executed database refresh tasks, maintaining data accuracy and reliability.

Took the initiative in performance analysis, monitoring, troubleshooting, and resolving database issues.

Demonstrated proficiency in automating managerial and repetitive DBA tasks.

Exhibited the ability to work effectively both in a team setting and independently with minimal supervision.

Implemented strategic security measures to protect vital business data, eliminating potential vulnerabilities.

Successfully eliminated downtime by accurately implementing High Availability/Disaster Recovery (HA/DR) solutions.

Managed user profiles and access levels for each database segment, safeguarding critical data.

Proven experience in supporting mission-critical SQL Server environments.

Showcased proficiency in disaster recovery planning and implementation, ensuring business continuity.

Expert in setting up high-availability solutions like Always On and Clustering to ensure uninterrupted database access.

Proficient in T-SQL, PowerShell scripting, and the automation of complex database tasks.

Utilized Microsoft Office for dataset analysis, enhancing data-driven decision-making.

Oversaw and managed backup and maintenance jobs, ensuring data integrity and consistency.

Conducted physical and logical data modeling to improve database structure and efficiency.



Contact this candidate